//生成数据流 public static void SavePdfToDB(string Key, string ProcName, MemoryStream m, string FileID) { byte[] fileData = (byte[])m.ToArray(); //SQL if (!UIPublicClass.PublicClass.IsSingleClent) { IDataParameter[] param = new IDataParameter[] { new SqlParameter(Key, SqlDbType.NVarChar, 50), new SqlParameter("FImage", SqlDbType.Image) }; param[0].Value = FileID; param[1].Value = fileData; int rowsAffected; int rows = (int)DataSql.RunProcedure(ProcName, param, out rowsAffected); } //ACCESS else { string oldConn = DataSql.ConStr; DataSql.ConStr = DataSql.ConStr_Pdf;//暂时更换数据库连接语句 try { string existSql, deleteSql, insertSql, tablename = string.Empty, fieldname = string.Empty; switch (PdfMergerCommand.archivesType) { case UIPublicClass.Enum.ArchivesType.编制档案: tablename = "BZ_FilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.城建档案新: tablename = "CjFilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.公安业务档案: tablename = "YW_FilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.归档文件: tablename = "GD_FilePdf"; fieldname = "文件ID"; break; case UIPublicClass.Enum.ArchivesType.科技档案_2000: tablename = "KeJi_FilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.社保业务档案: tablename = "SBYW_FilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.文书档案: tablename = "WS_FilePdf"; fieldname = "案卷ID"; break; case UIPublicClass.Enum.ArchivesType.沿革档案: tablename = "YG_FilePdf"; fieldname = "案卷ID"; break; } if (tablename != string.Empty && fieldname != string.Empty) { existSql = string.Format("select Count(*) from {0} where {1}={2}", tablename, fieldname, FileID); deleteSql = string.Format("delete from {0} where {1}={2}", tablename, fieldname, FileID); insertSql = string.Format("insert into {0} ({1},Pdf,Status) values (@FileID,@FImage,1)", tablename, fieldname); SqlParameter[] parameter = { new SqlParameter("@FileID", SqlDbType.Int, 4), new SqlParameter("@FImage", SqlDbType.Image) }; parameter[0].Value = FileID; parameter[1].Value = fileData; bool exist = DataSql.Exists(existSql); if (exist) { DataSql.ExecuteSql(deleteSql); } DataSql.ExecuteSql(insertSql, parameter); } } catch { } finally { //还原数据库连接语句 DataSql.ConStr = oldConn; } } }