2023年6月21日发(作者：)

C#保存byte[]到数据库和读取，把byte[]写进⽂件⽂件中只能⽤参数传值的⽅式才能把byte[]的内容保存到数据数据库中的字段类型为： varbinary

///

/// 保存模板/// /// /// public static bool TemplateSave(TemplateEntity t){bool boo = false;try{if (eQuery("SELECT * FROM TemplateEntity WHERE Name=N'" + + "'"). > 0)throw new Exception("模板 [" + + "] 已存在");

SqlParameter[] par = { new SqlParameter("@Description",ption) ,new SqlParameter("@TemplateFile",teFile)//byte[]数组内容};string sql = @"INSERT INTO teEntity( Id ,Memo ,CreateDate ,LastEditDate ,Printer ,Name ,[FileName] ,[Description],TemplateFile)VALUES ( NEWID(),N'" + + @"' ,GETDATE() ,GETDATE() ,N'" + r + @"' ,N'" + + @"' ,N'" + me + @"' ,@Description ,@TemplateFile)";

if (NonQuery(sql, par) > 0)boo = true;}catch (Exception ex){throw ex;}return boo;}

///

/// 根据ID查询打印模板/// /// /// public static TemplateEntity GetObjectsById(string id){//return BaseNhibernate.GetObjectsByFrom("from TemplateEntity o where ='" + id + "'").FirstOrDefault();TemplateEntity t = null;try{DataTable dt = eQuery("SELECT TOP 1 * FROM TemplateEntity WHERE Name=N'" + id + "'");if ( > 0){t = new TemplateEntity(); = new Guid([0]["Id"].ToString());me = [0]["FileName"].ToString(); = [0]["Name"].ToString();ption = [0]["Description"].ToString();r = [0]["Printer"].ToString();if (OrEmpty([0]["TemplateFile"].ToString()))throw new Exception("请重新上传打印模板 [ " + + " ]");teFile = (byte[])[0]["TemplateFile"];}}catch (Exception ex){throw ex;}return t;}

public static string TagsTemplateDir = rectory + @"TagsTemplate";///

/// 下载模板到本地⽂件夹中/// /// public static void GetTemplateFile(TemplateEntity t){try{WebClient myWebClient = new WebClient();tials = tCredentials;Stream postStream = ite(TagsTemplateDir + "" + me, "PUT");(teFile, 0, );();

}catch (Exception ex){throw ex;}}

2023年6月21日发(作者：)

C#保存byte[]到数据库和读取，把byte[]写进⽂件⽂件中只能⽤参数传值的⽅式才能把byte[]的内容保存到数据数据库中的字段类型为： varbinary

///

/// 保存模板/// /// /// public static bool TemplateSave(TemplateEntity t){bool boo = false;try{if (eQuery("SELECT * FROM TemplateEntity WHERE Name=N'" + + "'"). > 0)throw new Exception("模板 [" + + "] 已存在");

SqlParameter[] par = { new SqlParameter("@Description",ption) ,new SqlParameter("@TemplateFile",teFile)//byte[]数组内容};string sql = @"INSERT INTO teEntity( Id ,Memo ,CreateDate ,LastEditDate ,Printer ,Name ,[FileName] ,[Description],TemplateFile)VALUES ( NEWID(),N'" + + @"' ,GETDATE() ,GETDATE() ,N'" + r + @"' ,N'" + + @"' ,N'" + me + @"' ,@Description ,@TemplateFile)";

if (NonQuery(sql, par) > 0)boo = true;}catch (Exception ex){throw ex;}return boo;}

///

/// 根据ID查询打印模板/// /// /// public static TemplateEntity GetObjectsById(string id){//return BaseNhibernate.GetObjectsByFrom("from TemplateEntity o where ='" + id + "'").FirstOrDefault();TemplateEntity t = null;try{DataTable dt = eQuery("SELECT TOP 1 * FROM TemplateEntity WHERE Name=N'" + id + "'");if ( > 0){t = new TemplateEntity(); = new Guid([0]["Id"].ToString());me = [0]["FileName"].ToString(); = [0]["Name"].ToString();ption = [0]["Description"].ToString();r = [0]["Printer"].ToString();if (OrEmpty([0]["TemplateFile"].ToString()))throw new Exception("请重新上传打印模板 [ " + + " ]");teFile = (byte[])[0]["TemplateFile"];}}catch (Exception ex){throw ex;}return t;}

public static string TagsTemplateDir = rectory + @"TagsTemplate";///

/// 下载模板到本地⽂件夹中/// /// public static void GetTemplateFile(TemplateEntity t){try{WebClient myWebClient = new WebClient();tials = tCredentials;Stream postStream = ite(TagsTemplateDir + "" + me, "PUT");(teFile, 0, );();

}catch (Exception ex){throw ex;}}