public bool MD_PDF_JPG(string blh, string bglx, string bgxh, string ML, ZgqClassPub.ZgqPDFJPG.Type jpgpdf, ref string err_msg, ref string fileName, ref string fielPath) { string message = ""; string jpgname = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, jpgpdf, ref jpgname, "", ref message);; if (isrtn) { bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 3); if (ssa == true) { //jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); fileName = jpgname; fielPath = ML + "\\" + blh; err_msg = ""; zgq.DelTempFile(blh); return(true); } else { err_msg = message; zgq.DelTempFile(blh); return(false); } } else { zgq.DelTempFile(blh); err_msg = message; return(false); } }
public void CreatePDF(string blh, string bgxh, string bglx, DataTable dt_jcxx, string debug, string bgzt) { string blbh = blh + bglx + bgxh; dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); if (bglx == "cg") { blbh = blh; } if (bgzt == "取消审核") { try { aa.ExecuteSQL("delete T_BG_PDF where F_BLBH='" + blbh + "'"); } catch { } return; } #region 生成pdf if (f.ReadString("savetohis", "ispdf", "1").Trim() == "1") { string ReprotFile = ""; string jpgname = ""; string ML = DateTime.Parse(dt_jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); string message = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", ref message); if (isrtn) { if (debug == "1") { log.WriteMyLog("生成PDF成功"); } ////二进制串 if (File.Exists(jpgname)) { string pdfpath = ""; bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 3, ref pdfpath); if (ssa == true) { if (debug == "1") { log.WriteMyLog("上传PDF成功"); } jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "上传PDF成功", "审核", "上传PDF成功:" + pdfpath, "ZGQJK", "上传PDF"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLBH,F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME,f_pdfpath) values('" + blbh + "','" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "\\" + blh + "','" + jpgname + "','" + pdfpath + "')"); } else { if (debug == "1") { log.WriteMyLog("上传PDF失败" + message); } ZgqClass.BGHJ(blh, "上传PDF失败", "审核", message, "ZGQJK", "上传PDF"); } } else { if (debug == "1") { log.WriteMyLog("未找到文件" + jpgname); } ZgqClass.BGHJ(blh, "生成PDF失败", "审核", "未找到文件" + jpgname, "ZGQJK", "生成PDF"); } } else { if (message == "报告未审核") { return; } else { if (debug == "1") { log.WriteMyLog("生成PDF失败" + message); } ZgqClass.BGHJ(blh, "生成PDF失败", "审核", "生成pdf失败" + message, "ZGQJK", "生成PDF"); } } zgq.DelTempFile(blh); } #endregion }
private void scpdf(string blh, string bglx, string bgxh, string bgzt2, string ML) { try { dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); if (bgzt2.Trim() == "") { log.WriteMyLog("报告状态为空!不处理!" + blh + "^" + bglx + "^" + bgxh); } if (bgzt2.Trim() == "已审核") { //string ML = ""; string message = ""; string jpgname = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", ref message); string xy = "3";// ZgqClass.GetSz("ZGQJK", "sctxfs", "3"); if (isrtn) { bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, int.Parse(xy)); if (ssa == true) { jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "批量上传", "审核", "生成PDF成功:" + ML + "\\" + jpgname, "ZGQJK", "生成PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME) values('" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "','" + jpgname + "')"); aa.ExecuteSQL("update T_JCXX_FS set F_bz='生成PDF成功',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } else { log.WriteMyLog(message); ZgqClass.BGHJ(blh, "批量上传", "审核", message, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISJPG='false',F_bz='" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } zgq.DelTempFile(blh); } else { aa.ExecuteSQL("update T_JCXX_FS set F_ISJPG='false',F_BZ='" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } return; } else { if (bgzt2 == "取消审核") { DataTable dt2 = aa.GetDataTable("select top 1 * from T_BG_PDF where F_blh='" + blh + "' and F_BGXH='" + bgxh + "' and F_BGLX='" + bglx + "'", "dt2"); if (dt2.Rows.Count <= 0) { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='取消审核,删除PDF成功!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt2 + "'"); } else { aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); ZgqPDFJPG zgq = new ZgqPDFJPG(); string rtn_msg = ""; zgq.DelPDFFile(dt2.Rows[0]["F_ml"].ToString(), dt2.Rows[0]["F_FILENAME"].ToString(), ref rtn_msg); aa.ExecuteSQL("update T_JCXX_FS set F_bz='取消审核,删除PDF成功!',F_JPG_errmsg='',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } return; } } return; } catch { } }
public void pathtohis(string blh, string bglx, string bgxh, string msg, string debug, string[] cslb) { string qxsh = ""; string xdj = ""; bglx = bglx.ToLower(); if (cslb.Length == 5) { if (cslb[4].ToLower() == "qxsh") { //取消审核动作 qxsh = "1"; } if (cslb[3].ToLower() == "new") { xdj = "1"; } } if (bglx == "") { bglx = "cg"; } if (bgxh == "") { bgxh = "0"; } string tjodbcsql = f.ReadString("savetohis", "tj-odbcsql", "Data Source=172.16.95.190\\SQL2005;Initial Catalog=tj_zdzl;User Id=bl;Password=admin;"); dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable jcxx = new DataTable(); try { jcxx = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; } if (jcxx == null) { MessageBox.Show("病理数据库设置有问题!"); return; } if (jcxx.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); return; } if (bglx.Trim() == "") { log.WriteMyLog("报告类型为空,不处理!" + blh + "^" + bglx + "^" + bgxh); return; } string bgzt = ""; if (qxsh == "1") { bgzt = "取消审核"; } else { bgzt = "已审核"; } int plsc = f.ReadInteger("fsjk", "plsc", 0); if (plsc != 1) { return; } ////增加体检回写接口/////zgq if (jcxx.Rows[0]["F_BRLB"].ToString().Trim() == "体检") { if (jcxx.Rows[0]["F_SQXH"].ToString().Trim() == "") { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='不处理',F_bz='体检病人无体检申请号,不处理!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); log.WriteMyLog(blh + ",体检病人无病人编号,不处理!"); return; } if (jcxx.Rows[0]["F_BGZT"].ToString().Trim() == "已审核" && bgzt != "取消审核") { DataTable TJ_bljc = new DataTable(); TJ_bljc = aa.GetDataTable(" select top 1 * from T_TBS_BG where F_blh='" + blh + "'", "blxx"); // 诊断描述 string Res_char = jcxx.Rows[0]["F_jxsj"].ToString().Trim(); //诊断结论 Res_con string Res_con = jcxx.Rows[0]["F_blzd"].ToString().Trim(); if (TJ_bljc.Rows.Count > 0) { if (jcxx.Rows[0]["F_blk"].ToString().Trim() == "体检LCT" || jcxx.Rows[0]["F_blk"].ToString().Trim() == "液基细胞") { Res_char = Res_char + "标本满意度:" + TJ_bljc.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + "\r\n" + "\r\n"; Res_char = Res_char + "项目:" + "\r\n" + TJ_bljc.Rows[0]["F_TBS_XBL"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_XBXM1"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_XBXM2"].ToString().Trim() + "\r\n" + "\r\n"; Res_char = Res_char + "病原体:" + "\r\n" + TJ_bljc.Rows[0]["F_TBS_WSW2"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_WSW1"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_WSW3"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_BDXM1"].ToString().Trim() + "\r\n" + "\r\n"; Res_char = Res_char + "炎症细胞量:" + TJ_bljc.Rows[0]["F_TBS_YZCD"].ToString().Trim() + "\r\n" + "\r\n"; ///////////诊断///////////////////////// Res_con = "诊断:" + TJ_bljc.Rows[0]["F_TBSZD"].ToString().Trim() + "\r\n" + "\r\n"; if (TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() != "") { Res_con = Res_con + "补充意见:" + TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() + "\r\n"; } } } ///////////////////////////////////////////////////// string str_com = "update tj_pacs_resulto_temp set Res_doctor='" + jcxx.Rows[0]["F_BGYS"].ToString().Trim() + "',Res_doctor_code='',Res_date='" + DateTime.Parse(jcxx.Rows[0]["F_BGrq"].ToString().Trim()) + "',Res_char='" + Res_char + "',Res_con='" + Res_con + "',Res_flag=2 where res_no='" + jcxx.Rows[0]["F_SQXH"].ToString().Trim() + "'"; if (debug == "1") { MessageBox.Show("回写体检表,语句:" + str_com); } SqlDB db = new SqlDB(); string Exceptionmessage = ""; int x = db.ExecuteNonQuery(tjodbcsql, str_com, ref Exceptionmessage); if (Exceptionmessage != "" && Exceptionmessage != "OK") { if (Exceptionmessage.Length > 200) { aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + Exceptionmessage.Substring(0, 200) + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } else { aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + Exceptionmessage + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } log.WriteMyLog(blh + ",体检报告审核,接口异常信息:" + Exceptionmessage); } else { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='体检报告审核,接口上传成功!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); } } else { //取消审核时 if (bgzt == "取消审核") { string str_com = "update tj_pacs_resulto_temp set Res_doctor='" + "" + "',Res_doctor_code='',Res_date='" + DateTime.Today + "',Res_char='" + "" + "',Res_con='" + "" + "',Res_flag=2 where res_no='" + jcxx.Rows[0]["F_SQXH"].ToString().Trim() + "'"; if (debug == "1") { MessageBox.Show("回写体检表,语句:" + str_com); } SqlDB db = new SqlDB(); string Exceptionmessage = ""; int x = db.ExecuteNonQuery(tjodbcsql, str_com, ref Exceptionmessage); if (Exceptionmessage != "" && Exceptionmessage != "OK") { log.WriteMyLog(Exceptionmessage); if (Exceptionmessage.Length > 200) { aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + Exceptionmessage.Substring(0, 200) + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } else { aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + Exceptionmessage + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } log.WriteMyLog(blh + ",体检报告取消审核,接口异常信息:" + Exceptionmessage); } else { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='体检报告取消审核,接口上传成功!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); } } else { aa.ExecuteSQL("update T_jcxx_fs set F_bz='未知操作!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); } } } else { //非体检病人回写 //生成pdf 用于移动app string bgzt2 = ""; try { if (bglx.ToLower().Trim() == "bd") { DataTable dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + blh + "' and F_BD_BGXH='" + bgxh + "'", "bd"); bgzt2 = dt_bd.Rows[0]["F_BD_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "bc") { DataTable dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + blh + "' and F_BC_BGXH='" + bgxh + "'", "bc"); bgzt2 = dt_bc.Rows[0]["F_BC_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "cg") { // DataTable jcxx2 = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); bgzt2 = jcxx.Rows[0]["F_BGZT"].ToString(); } } catch { } if (bgzt2.Trim() == "") { log.WriteMyLog("报告状态为空!不处理!" + blh + "^" + bglx + "^" + bgxh); } if (bgzt2.Trim() == "已审核" && bgzt != "取消审核") { ////MD_JPG_PDF md = new MD_JPG_PDF(); ////int x = md.CreatePDF(blh, bglx, bgxh, MD_JPG_PDF.type.PDF, ref message); ////if (x <= 0) ////{ //// LGZGQClass.log.WriteMyLog(message); //// if (message.Length > 200) //// aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + message.Substring(0, 200) + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); //// else //// aa.ExecuteSQL("update T_jcxx_fs set F_bz='" + message + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); ////} ////else //// aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='审核, 生成PDF成功' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); //string ML = ""; string message = ""; string jpgname = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", ref message); string xy = "3"; // ZgqClass.GetSz("ZGQJK", "sctxfs", "3"); if (isrtn) { bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, int.Parse(xy)); if (ssa == true) { jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "批量上传", "审核", "生成PDF成功:" + ML + "\\" + jpgname, "ZGQJK", "生成PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME) values('" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "','" + jpgname + "')"); aa.ExecuteSQL("update T_JCXX_FS set F_bz='生成PDF成功',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } else { log.WriteMyLog(message); ZgqClass.BGHJ(blh, "批量上传", "审核", message, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISJPG='false',F_bz='" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } zgq.DelTempFile(blh); } else { aa.ExecuteSQL("update T_JCXX_FS set F_ISJPG='false',F_BZ='" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } } else { if (bgzt == "取消审核") { DataTable dt2 = aa.GetDataTable("select top 1 * from T_BG_PDF where F_blh='" + blh + "' and F_BGXH='" + bgxh + "' and F_BGLX='" + bglx + "'", "dt2"); if (dt2.Rows.Count <= 0) { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='取消审核,删除PDF成功!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } else { aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); ZgqPDFJPG zgq = new ZgqPDFJPG(); string rtn_msg = ""; zgq.DelPDFFile("", dt2.Rows[0]["F_FILENAME"].ToString(), ref rtn_msg); aa.ExecuteSQL("update T_JCXX_FS set F_bz='取消审核,删除PDF成功!',F_JPG_errmsg='',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } } else { aa.ExecuteSQL("update T_jcxx_fs set F_bz='未知操作!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); } } } }
public void pdfjpg(string blh, string bglx, string bgxh, string czlb, string dz, string msg, string debug, string yymc) { bglx = bglx.ToLower(); if (bglx == "") { bglx = "cg"; } if (bgxh == "") { bgxh = "1"; } string blbh = blh + bglx + bgxh; if (bglx == "cg") { blbh = blh; } dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable jcxx = new DataTable(); try { jcxx = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; } if (jcxx == null) { MessageBox.Show("病理数据库设置有问题!"); return; } if (jcxx.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); return; } if (bglx.Trim() == "") { log.WriteMyLog("报告类型为空,不处理!" + blh + "^" + bglx + "^" + bgxh); return; } if (dz == "qxsh" || dz == "取消审核") { //取消审核动作 aa.ExecuteSQL("delete T_BG_PDF where F_BLbH='" + blbh + "'"); } string bgzt = jcxx.Rows[0]["F_BGZT"].ToString(); try { if (bglx.ToLower().Trim() == "bd") { DataTable dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + blh + "' and F_BD_BGXH='" + bgxh + "'", "bd"); bgzt = dt_bd.Rows[0]["F_BD_BGZT"].ToString(); // jpgname=blh+bglx+bgxh+"_"+dt_bd.Rows[0]["F_BD_BGRQ"].ToString(); } if (bglx.ToLower().Trim() == "bc") { DataTable dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + blh + "' and F_BC_BGXH='" + bgxh + "'", "bc"); bgzt = dt_bc.Rows[0]["F_BC_BGZT"].ToString(); // jpgname=blh+bglx+bgxh+"_"+dt_bc.Rows[0]["F_BC_SPARE5"].ToString(); } if (bglx.ToLower().Trim() == "cg") { bgzt = jcxx.Rows[0]["F_BGZT"].ToString(); // jpgname=blh+bglx+bgxh+"_"+jcxx.Rows[0]["F_SPARE5"].ToString(); } } catch (Exception e5) { log.WriteMyLog("报告状态为空!不处理!" + blh + "^" + bglx + "^" + bgxh + e5.Message); } if (bgzt != "已审核") { return; } string type = f.ReadString("savetohis", "type", "pdf").Trim().ToLower(); ////生成pdf或jpg string jpgname = ""; //生成pdf或jpg文件名 string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); //ftp 上目录,可为空 ZgqPDFJPG zgq = new ZgqPDFJPG(); string message = ""; // string pdfpath = ""; // if (zgq.CreatePDF(blh, bglx, bgxh, ref jpgname, "", "", ZgqPDFJPG.Type.PDF, ref message)) // { // log.WriteMyLog("[" + blh + "]生成PDF成功"); // //生成pdf成功上传pdf到病理服务器 // if (zgq.UpPDF(blh, jpgname, ML, ref message, 3, ref pdfpath)) // { // log.WriteMyLog("[" + blh + "]上传PDF成功:" + pdfpath); // jpgname = pdfpath.Substring(pdfpath.LastIndexOf('\\') + 1); // aa.ExecuteSQL("delete T_BG_PDF where F_BLBH='" + blbh + "'"); // aa.ExecuteSQL("insert into T_BG_PDF(F_BLBH,F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME,f_pdfpath) values('" + blbh + "','" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "\\" + blh + "','" + jpgname + "','" + pdfpath + "')"); // } // else // log.WriteMyLog("[" + blh + "]上传PDF失败:" + message); // } // else // { // log.WriteMyLog("["+blh+"]生成PDF失败:" + message); // ZgqClass.BGHJ(blh, "生成PDF失败", "审核", "生成pdf失败" + message, "ZGQJK", "生成PDF"); // } bool isrtn = false; if (yymc.Trim() == "pdf") { isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", "", ref message); } else { isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", "", ref message); } if (!isrtn) { log.WriteMyLog("生成PDF失败" + message); ZgqClass.BGHJ(blh, "生成PDF失败", "审核", "生成pdf失败" + message, "ZGQJK", "生成PDF"); } else { if (debug == "1") { log.WriteMyLog("生成PDF成功"); } ////二进制串 if (File.Exists(jpgname)) { //上传 string pdfpath = ""; bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 3, ref pdfpath); if (ssa == true) { if (debug == "1") { log.WriteMyLog("上传PDF成功"); } jpgname = pdfpath.Substring(pdfpath.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "上传PDF成功", "审核", "上传PDF成功:" + pdfpath, "ZGQJK", "上传PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLBH='" + blbh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLBH,F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME,f_pdfpath) values('" + blbh + "','" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "\\" + blh + "','" + jpgname + "','" + pdfpath + "')"); } else { log.WriteMyLog("上传PDF失败" + message); ZgqClass.BGHJ(blh, "上传PDF失败", "审核", message, "ZGQJK", "上传PDF"); } } else { log.WriteMyLog("未找到PDF文件" + jpgname); ZgqClass.BGHJ(blh, "生成PDF失败", "审核", "未找到文件" + jpgname, "ZGQJK", "生成PDF"); } } zgq.DelTempFile(blh); return; }
public bool MD_PDF_JPG(string blh, string bglx, string bgxh, string ML, ZgqPDFJPG.Type jpgpdf, ref string err_msg, ref string fileName, ref string pdfpath, ref string filePath, string IP, string useName, string pwd) { string message = ""; string jpgname = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, jpgpdf, ref message, ref jpgname); string xy = f.ReadString("savetohis", "sctxfs", "1"); filePath = ""; if (isrtn) { bool ssa = false; if (useName.Trim() != "") { //开共享 Process pro = new Process(); try { pro.StartInfo.FileName = "cmd.exe"; pro.StartInfo.UseShellExecute = false; pro.StartInfo.RedirectStandardInput = true; pro.StartInfo.RedirectStandardOutput = true; pro.StartInfo.RedirectStandardError = true; pro.StartInfo.CreateNoWindow = true; pro.Start(); pro.StandardInput.WriteLine("net use \\\\" + IP + "\\ipc$ " + pwd + " /user:"******""); Thread.Sleep(1000); ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 1, ref filePath); } catch (Exception ee) { message = ee.Message; ssa = false; } finally { pro.StandardInput.WriteLine("net use \\\\" + IP + "\\ipc$ /del"); } } else { ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 1, ref filePath); } if (ssa) { log.WriteMyLog(filePath); ssa = false; ssa = zgq.UpPDF(blh, jpgname, ML, ref message, 3, ref pdfpath); if (ssa) { log.WriteMyLog("病理服务器上传PDF成功:" + pdfpath); } else { log.WriteMyLog("病理服务器上传PDF失败" + message); } //jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); fileName = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); err_msg = ""; zgq.DelTempFile(blh); return(true); } else { log.WriteMyLog("上传PDF到平台:失败" + filePath); err_msg = message; zgq.DelTempFile(blh); return(false); } } else { zgq.DelTempFile(blh); err_msg = message; return(false); } }
// string msg = ""; string debug = ""; public void pathtohis(string blh, string bglx, string bgxh, string msg, string debug, string[] cslb) { string jkmsg = f.ReadString("jkmsg", "jkmsg", "0").Replace("\0", ""); f.WriteInteger("jkmsg", "jkmsg", 0); bglx = bglx.ToLower(); if (bglx.ToLower().Trim() == "bd") { return; } debug = f.ReadString("savetohis", "debug", "0"); msg = f.ReadString("savetohis", "msg", "0"); dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable jcxx = new DataTable(); try { jcxx = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(blh + "," + ex.Message); return; } if (jcxx == null) { MessageBox.Show(blh + ",病理数据库设置有问题!"); return; } if (jcxx.Rows.Count < 1) { MessageBox.Show(blh + ",病理号有错误!"); return; } string qxsh = ""; if (cslb.Length == 5) { if (cslb[4].ToLower() == "qxsh") { qxsh = "1";//取消审核动作 } } if (bglx == "") { bglx = "cg"; } if (bgxh == "") { bgxh = "0"; } string bgzt = jcxx.Rows[0]["F_BGZT"].ToString().Trim(); try { if (bglx.ToLower().Trim() == "bd") { DataTable dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + blh + "' and F_BD_BGXH='" + bgxh + "'", "bd"); bgzt = dt_bd.Rows[0]["F_BD_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "bc") { DataTable dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + blh + "' and F_BC_BGXH='" + bgxh + "'", "bc"); bgzt = dt_bc.Rows[0]["F_BC_BGZT"].ToString(); } } catch { } if (qxsh == "1") { bgzt = "取消审核"; } if (bgzt != "取消审核" && bgzt != "已审核" && bglx == "cg") { return; } if (bgzt.Trim() == "") { log.WriteMyLog("报告状态为空!不处理!" + blh + "^" + bglx + "^" + bgxh); return; } if (bgzt != "取消审核" && bgzt != "已审核") { return; } if (bgzt.Trim() == "已审核") { string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); string message = ""; string jpgname = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, "", ref message); string xy = "3";// ZgqClass.GetSz("ZGQJK", "sctxfs", "3"); if (isrtn) { bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, int.Parse(xy)); if (ssa == true) { jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "批量上传", "审核", "生成PDF成功:" + ML + "\\" + jpgname, "ZGQJK", "生成PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME) values('" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "','" + jpgname + "')"); aa.ExecuteSQL("update T_JCXX_FS set F_BZ='',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); if (jkmsg == "1") { MessageBox.Show(blh + ",上传PDF成功"); } } else { if (msg == "1" || jkmsg == "1") { MessageBox.Show(blh + ",上传PDF失败,请重新审核!\r\n异常消息:" + message); } log.WriteMyLog(message); ZgqClass.BGHJ(blh, "批量上传", "审核", message, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_BZ='" + message + "',F_FSZT='未处理' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } zgq.DelTempFile(blh); } else { if (msg == "1" || jkmsg == "1") { MessageBox.Show(blh + ",生成PDF失败,请重新审核!\r\n异常消息:" + message); } log.WriteMyLog(message); ZgqClass.BGHJ(blh, "接口", "审核", message, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_BZ='" + message + "',F_FSZT='未处理' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); zgq.DelTempFile(blh); } return; } else { if (bgzt == "取消审核") { //删除T_BG_PDF记录 DataTable dt2 = aa.GetDataTable("select top 1 * from T_BG_PDF where F_blh='" + blh + "' and F_BGXH='" + bgxh + "' and F_BGLX='" + bglx + "'", "dt2"); if (dt2.Rows.Count > 0) { aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); //删除ftp上pdf文件 ZgqPDFJPG zgq = new ZgqPDFJPG(); string rtn_msg = ""; zgq.DelPDFFile(dt2.Rows[0]["F_ML"].ToString(), dt2.Rows[0]["F_FILENAME"].ToString(), ref rtn_msg); } else { log.WriteMyLog(blh + ",T_BG_PDF中未能找到记录"); } aa.ExecuteSQL("update T_JCXX_FS set F_BZ='',F_FSZT='已处理',F_ISPDF='' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } } return; }
public void pathtohis(string blh, string bglx, string bgxh, string msg, string debug, string[] cslb) { string qxsh = ""; string xdj = ""; bglx = bglx.ToLower(); if (cslb.Length == 5) { if (cslb[4].ToLower() == "qxsh") { //取消审核动作 qxsh = "1"; } if (cslb[3].ToLower() == "new") { xdj = "1"; } } if (bglx == "") { bglx = "cg"; } if (bgxh == "") { bgxh = "0"; } string JsonSvcWeb = f.ReadString("savetohis", "JsonSvcWeb", "http://192.9.200.56:9080/ChasSvc/services/JsonSvc4Ris").Replace("\0", "").Trim(); string yydm = f.ReadString("savetohis", "yydm", "1").Replace("\0", "").Trim(); string MZHISWeb = f.ReadString("savetohis", "WSURL", "http://192.9.199.12:8002/HisForInspectItemService.asmx").Replace("\0", "").Trim(); //获取sz.ini中设置的mrks string tomzhis = f.ReadString("savetohis", "tomzhis", "1").Replace("\0", "").Trim(); string tozyhis = f.ReadString("savetohis", "tozyhis", "1").Replace("\0", "").Trim(); dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable jcxx = new DataTable(); try { jcxx = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; } if (jcxx == null) { MessageBox.Show("病理数据库设置有问题!"); return; } if (jcxx.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); return; } if (bglx.Trim() == "") { log.WriteMyLog("报告类型为空,不处理!" + blh + "^" + bglx + "^" + bgxh); return; } string bgzt = ""; if (qxsh == "1") { bgzt = "取消审核"; } else { bgzt = jcxx.Rows[0]["F_BGZT"].ToString(); } if (tozyhis == "1") { #region 回写住院HIS状态 if (jcxx.Rows[0]["F_brlb"].ToString() == "住院") { if (bglx == "cg" || jcxx.Rows[0]["F_SQXH"].ToString() != "") { string yzxmid = ""; try { yzxmid = jcxx.Rows[0]["F_YZXM"].ToString().Split('^')[1]; } catch { } if (yzxmid == "") { return; } string actionCode = "register"; string actionName = "PACS登记"; string sqdzt = ""; string sqdztCode = ""; if (bgzt == "已登记") { sqdztCode = "CLDS.RISREGISTER.0000"; sqdzt = "登记"; } else if (bgzt == "已审核") { sqdztCode = "CLDS.RISAUDIT.0000"; sqdzt = "审核报告"; actionCode = "updateStatus"; actionName = "更新状态"; } else if (bgzt == "取消审核") { sqdztCode = "CLDS.RISFINISH.0000"; sqdzt = "已检查"; actionCode = "updateStatus"; actionName = "更新状态"; } else if (bgzt == "报告延期") { sqdztCode = "CLDS.RISFINISH.0000"; sqdzt = "已检查"; actionCode = "updateStatus"; actionName = "更新状态"; } else if (bgzt == "已作废") { sqdztCode = "CLDS.RIUNR.0000"; sqdzt = "取消登记"; actionCode = "cancel"; actionName = "退单"; } else { return; } MemoryStream ms = new MemoryStream(); StreamWriter sw = new StreamWriter(ms, Encoding.GetEncoding("gb2312")); JsonWriter writer = new JsonTextWriter(sw); Encoding eee = sw.Encoding; writer.WriteStartObject(); writer.WritePropertyName("reqHeader"); writer.WriteStartObject(); writer.WritePropertyName("callFunction"); writer.WriteValue("updateExaminationApply"); writer.WritePropertyName("systemId"); writer.WriteValue("PACS.BL"); writer.WritePropertyName("reqTimestamp"); writer.WriteValue(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); writer.WriteEndObject(); //申请单 33333333333333333333 writer.WritePropertyName("requestForms"); writer.WriteStartArray(); writer.WriteStartObject(); //申请单号 writer.WritePropertyName("requestFormHisNo"); writer.WriteValue(jcxx.Rows[0]["F_SQXH"].ToString()); //申请单名称 writer.WritePropertyName("requestName"); writer.WriteValue(""); //检查号 writer.WritePropertyName("requestFormSysNo"); writer.WriteValue(blh); //检查分类 writer.WritePropertyName("requestType"); writer.WriteValue(""); //检查项目列表2222222222222 writer.WritePropertyName("orderItem"); writer.WriteStartArray(); string[] orderItemHisNos = yzxmid.ToString().Split('|'); foreach (string orderItemHisNo in orderItemHisNos) { if (orderItemHisNo.Trim() != "") { writer.WriteStartObject(); //子申请单号 writer.WritePropertyName("orderItemHisNo"); writer.WriteValue(orderItemHisNo); //检查项目编码 writer.WritePropertyName("orderCode"); writer.WriteValue(""); //检查项目名称 writer.WritePropertyName("orderName"); writer.WriteValue(""); //检查项目状态 writer.WritePropertyName("statusCode"); writer.WriteValue(sqdztCode); //检查项目状态名称 writer.WritePropertyName("statusName"); writer.WriteValue(sqdzt); ////检查项目部位 //writer.WritePropertyName("subItems"); //writer.WriteStartArray(); //writer.WriteStartObject(); // //检查项目部位编码 // writer.WritePropertyName("orderCode"); // writer.WriteValue(""); // //检查项目部位名称 // writer.WritePropertyName("orderName"); // writer.WriteValue(""); //writer.WriteEndObject(); //writer.WriteEndArray(); writer.WriteEndObject(); } } writer.WriteEndArray(); ////22222222222222222222222222222222 //操作111111111111111111 writer.WritePropertyName("action"); writer.WriteStartArray(); writer.WriteStartObject(); //操作代码 writer.WritePropertyName("actionCode"); writer.WriteValue(actionCode); //操作名称 writer.WritePropertyName("actionName"); writer.WriteValue(actionName); //操作时间 writer.WritePropertyName("actionTime"); writer.WriteValue(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //操作备注 writer.WritePropertyName("memo"); writer.WriteValue(jcxx.Rows[0]["F_WFBGYY"].ToString()); //操作人 writer.WritePropertyName("actor"); writer.WriteStartObject(); /////////////////////////////////// //操作人医院 writer.WritePropertyName("hospital"); writer.WriteStartObject(); //操作人医院 writer.WritePropertyName("hospitalCode"); if (jcxx.Rows[0]["F_sjdw"].ToString() == "大院" || jcxx.Rows[0]["F_sjdw"].ToString() == "总院") { writer.WriteValue("1"); } else if (jcxx.Rows[0]["F_sjdw"].ToString() == "大学城医院" || jcxx.Rows[0]["F_sjdw"].ToString() == "大学城") { writer.WriteValue("2"); } else if (jcxx.Rows[0]["F_sjdw"].ToString() == "二沙分院" || jcxx.Rows[0]["F_sjdw"].ToString() == "二沙") { writer.WriteValue("3"); } else if (jcxx.Rows[0]["F_sjdw"].ToString() == "芳村分院" || jcxx.Rows[0]["F_sjdw"].ToString() == "芳村") { writer.WriteValue("4"); } else { writer.WriteValue("1"); } //操作人医院 writer.WritePropertyName("hospitalName"); writer.WriteValue(jcxx.Rows[0]["F_sjdw"].ToString()); writer.WriteEndObject(); //////////////////////////////////// //操作人科室 writer.WritePropertyName("department"); writer.WriteStartObject(); // 科室名称 writer.WritePropertyName("departmentName"); writer.WriteValue(""); // 科室代码 writer.WritePropertyName("departmentCode"); writer.WriteValue(""); writer.WriteEndObject(); //////////////////////// //操作员工信息 writer.WritePropertyName("employee"); writer.WriteStartObject(); // 人员名称 writer.WritePropertyName("employeeName"); writer.WriteValue(""); // 人员代码 writer.WritePropertyName("employeeCode"); writer.WriteValue(""); writer.WriteEndObject(); //////////////////////// writer.WriteEndObject(); writer.WriteEndObject(); writer.WriteEndArray(); /////11111111111111111111111111111111 writer.WriteEndObject(); writer.WriteEndArray(); writer.WriteEndObject(); /////3333333333333333333333333 ; writer.Flush(); string rtnrequest = GetHisSQD(JsonSvcWeb, ms.ToArray(), debug); if (debug == "1") { log.WriteMyLog("出参:" + rtnrequest); } JObject ja = (JObject)JsonConvert.DeserializeObject(rtnrequest); string respCode = ja["respHeader"]["respCode"].ToString(); string respMessage = ja["respHeader"]["respMessage"].ToString(); if (respCode != "000000") { log.WriteMyLog("执行失败:" + respCode + "^" + respMessage); } else { if (debug == "1") { log.WriteMyLog("执行成功:" + respCode + "^" + respMessage); } } } } #endregion } if (tomzhis == "1") { #region 门诊状态执行 if (jcxx.Rows[0]["F_brlb"].ToString() == "门诊" || jcxx.Rows[0]["F_brlb"].ToString() == "体检") { if (bglx == "cg" && jcxx.Rows[0]["F_SQXH"].ToString().Trim() != "") { if (jcxx.Rows[0]["F_HXBJ"].ToString().Trim() != "1" || bgzt == "已审核") { string deptid = f.ReadString("savetohis", "deptid", "60027").Replace("\0", "").Trim(); string yhgh = f.ReadString("yh", "yhbh", "").Replace("\0", "").Trim(); if (yhgh.Trim() == "") { yhgh = "0502"; } string Flag = "1"; if (bgzt == "已审核") { Flag = "2"; } gdszyyMzHisWeb.HisForInspectItemService mzhis = new gdszyyMzHisWeb.HisForInspectItemService(); try { mzhis.Url = MZHISWeb; } catch (Exception ee2) { log.WriteMyLog("门诊HIS web服务连接异常:" + ee2.Message); return; } string [] sqdh = jcxx.Rows[0]["F_SQXH"].ToString().Split(new char[2] { '|', '|' }); for (int x = 0; x < sqdh.Length; x++) { if (sqdh[x].Trim() == "") { continue; } string request_xml = "<Request><CheckNumber>" + sqdh[x].Trim() + "</CheckNumber><ExecDeptId>" + deptid + "</ExecDeptId><ExecUserNo>" + yhgh + "</ExecUserNo><Flag>" + Flag + "</Flag></Request>"; if (debug == "1") { log.WriteMyLog("门诊项目执行条件:" + request_xml); } string rtn_xml = ""; try { rtn_xml = mzhis.ExecuteCheckItem(request_xml); if (rtn_xml.Trim() == "") { // MessageBox.Show("门诊项目执行失败:HIS返回空"); log.WriteMyLog("门诊项目执行失败!返回消息为空!"); } else { if (debug == "1") { log.WriteMyLog(rtn_xml); } XmlNode xmlok_DATA = null; XmlDocument xd2 = new XmlDocument(); try { xd2.LoadXml(rtn_xml); xmlok_DATA = xd2.SelectSingleNode("/Response"); string ResultCode = xmlok_DATA["ResultCode"].InnerText.Trim(); string ErrorMsg = xmlok_DATA["ErrorMsg"].InnerText.Trim(); if (ResultCode != "0") { log.WriteMyLog("门诊取项目执行失败:" + ErrorMsg); // MessageBox.Show("门诊项目执行失败:" + ErrorMsg); } else { aa.ExecuteSQL("update T_JCXX set F_HXBJ='1' where F_BLH='" + blh + "'"); if (debug == "1") { log.WriteMyLog("门诊项目执行成功:" + ErrorMsg); } } } catch (Exception xmlok_e) { // MessageBox.Show("门诊项目执行失败:解析DATA异常"); log.WriteMyLog("解析DATA异常:" + xmlok_e.Message + "\r\n" + rtn_xml); } } } catch (Exception ee) { // MessageBox.Show("门诊项目执行失败:" + ee.Message); log.WriteMyLog("门诊项目执行失败:连接WebService服务异常:" + ee.Message + "\r\n"); } } } } } #endregion } if (bgzt == "已审核" || bgzt == "取消审核") { string bgzt2 = ""; DataTable dt_bd = new DataTable(); DataTable dt_bc = new DataTable(); try { if (bglx.ToLower().Trim() == "bd") { dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + blh + "' and F_BD_BGXH='" + bgxh + "'", "bd"); bgzt2 = dt_bd.Rows[0]["F_BD_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "bc") { dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + blh + "' and F_BC_BGXH='" + bgxh + "'", "bc"); bgzt2 = dt_bc.Rows[0]["F_BC_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "cg") { // DataTable jcxx2 = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); bgzt2 = jcxx.Rows[0]["F_BGZT"].ToString(); } } catch { } if (bgzt2.Trim() == "") { log.WriteMyLog("报告状态为空!不处理!" + blh + "^" + bglx + "^" + bgxh); } if (bgzt2.Trim() == "已审核" && bgzt != "取消审核") { //////////////////////生成pdf********************************************************** string jpgname = ""; string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); if (f.ReadString("savetohis", "ispdf", "1").Replace("\0", "").Trim() == "1") { #region 生成pdf string message = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); if (debug == "1") { log.WriteMyLog("开始生成PDF。。。"); } bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref message, ref jpgname); string xy = "3"; if (isrtn) { if (File.Exists(jpgname)) { bool ssa = zgq.UpPDF(blh, jpgname, ML, ref message, int.Parse(xy)); if (ssa == true) { if (debug == "1") { log.WriteMyLog("上传PDF成功"); } jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "JK", "审核", "上传PDF成功:" + ML + "\\" + blh + "\\" + jpgname, "ZGQJK", "上传PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME) values('" + blh + "','" + bglx + "','" + bgxh + "','" + ML + "\\" + blh + "','" + jpgname + "')"); aa.ExecuteSQL("update T_JCXX_FS set F_bz='上传PDF成功',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "'"); } else { log.WriteMyLog("上传PDF失败:" + message); ZgqClass.BGHJ(blh, "JK", "审核", message, "ZGQJK", "上传PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_bz='上传PDF失败:" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } } else { log.WriteMyLog("生成PDF失败:未找到文件---" + jpgname); ZgqClass.BGHJ(blh, "JK", "审核", "上传PDF失败:未找到文件---" + jpgname, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_bz='上传PDF失败:未找到文件---" + jpgname + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } } else { log.WriteMyLog("生成PDF失败:" + message); ZgqClass.BGHJ(blh, "JK", "审核", message, "ZGQJK", "生成PDF"); aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_bz='生成PDF失败:" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } zgq.DelTempFile(blh); #endregion } //////////////////////***************************************************************** } else { if (bgzt == "取消审核") { DataTable dt2 = aa.GetDataTable("select top 1 * from T_BG_PDF where F_blh='" + blh + "' and F_BGXH='" + bgxh + "' and F_BGLX='" + bglx + "'", "dt2"); if (dt2.Rows.Count <= 0) { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_bz='取消审核成功!' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='" + bgzt + "'"); } else { aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("update T_JCXX_FS set F_bz='取消审核,删除PDF成功!',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='" + bglx.ToLower() + "' and F_BGXH='" + bgxh + "' and F_bgzt='取消审核'"); } #region 报告回收 #endregion } else { aa.ExecuteSQL("update T_jcxx_fs set F_bz='不处理,状态" + bgzt + "' where F_blh='" + blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理' and F_bgzt='取消审核'"); } } } }
public void pathtohis(string F_blh, string bglx, string bgxh, string czlb, string dz, string msg, string debug) { string qxsh = ""; string xdj = ""; bglx = bglx.ToLower(); try { //审核后上传报告 string shhscbg = f.ReadString("savetohis", "shhscbg", "1").Replace("\0", ""); int yssj = f.ReadInteger("savetohis", "yssj", 8); if (bglx == "") { bglx = "cg"; } if (bgxh == "") { bgxh = "1"; } dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable bljc = new DataTable(); try { bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + F_blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; } if (bljc == null) { MessageBox.Show("病理数据库设置有问题!"); return; } if (bljc.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); return; } string bgzt = ""; if (dz == "qxsh") { bgzt = "取消审核"; } else { bgzt = bljc.Rows[0]["F_BGZT"].ToString(); } if (bljc.Rows[0]["F_ZYH"].ToString().Trim() == "" && bljc.Rows[0]["F_MZH"].ToString().Trim() == "") { log.WriteMyLog("住院号和门诊号为空,不处理"); aa.ExecuteSQL("update T_jcxx_fs set F_fszt='不处理',F_BZ='住院号和门诊号为空,不处理' where F_blh='" + F_blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); return; } bool issc = false; string ftplj = ""; if (shhscbg == "1") { if (bgzt == "已审核" && bljc.Rows[0]["F_SFDY"].ToString().Trim() == "是") { issc = true; } } //修改已发布状态 if (bgzt == "已审核" && bljc.Rows[0]["F_SFDY"].ToString().Trim() == "是") { if (bglx == "cg") { try { if (DateTime.Parse(bljc.Rows[0]["F_spare5"].ToString().Trim()).AddHours(yssj) <= DateTime.Now) { aa.ExecuteSQL("update T_JCXX set F_BGZT='已发布' where F_BLH='" + F_blh + "'"); } else { issc = false; } } catch { } } } bool pdftoyxpt = false; #region 生成并上传pdf到服务器 if (bgzt == "已发布" || issc) { try { string bgzt2 = ""; DataTable dt_bd = new DataTable(); DataTable dt_bc = new DataTable(); try { if (bglx.ToLower().Trim() == "bd") { dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + F_blh + "' and F_BD_BGXH='" + bgxh + "'", "bd"); bgzt2 = dt_bd.Rows[0]["F_BD_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "bc") { dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + F_blh + "' and F_BC_BGXH='" + bgxh + "'", "bc"); bgzt2 = dt_bc.Rows[0]["F_BC_BGZT"].ToString(); } if (bglx.ToLower().Trim() == "cg") { bgzt2 = bljc.Rows[0]["F_BGZT"].ToString(); } } catch { } if (bgzt2.Trim() == "") { log.WriteMyLog("报告状态为空!不处理!" + F_blh + "^" + bglx + "^" + bgxh); } if ((bgzt2.Trim() == "已发布" || issc) && bgzt != "取消审核") { ////////生成pdf********************************************************** string jpgname = ""; string ML = DateTime.Parse(bljc.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); if (f.ReadString("savetohis", "ispdf", "1").Replace("\0", "").Trim() == "1") { #region 生成pdf string message = ""; ZgqPDFJPG zgq = new ZgqPDFJPG(); if (debug == "1") { log.WriteMyLog("开始生成PDF。。。"); } bool isrtn = zgq.CreatePDF(F_blh, bglx, bgxh, ZgqPDFJPG.Type.PDF, ref jpgname, ref message); string pdfpath = ""; if (isrtn) { if (File.Exists(jpgname)) { //上传病理服务器 bool ssa = zgq.UpPDF(F_blh, jpgname, ML, ref message, 3, ref pdfpath); if (ssa == true) { if (debug == "1") { log.WriteMyLog("上传PDF成功"); } string jpgname2 = jpgname.Substring(jpgname.LastIndexOf('\\') + 1); ZgqClass.BGHJ(F_blh, "JK", "审核", "上传PDF成功:" + pdfpath, "ZGQJK", "上传PDF"); aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + F_blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); aa.ExecuteSQL("insert into T_BG_PDF(F_BLH,F_BGLX,F_BGXH,F_ML,F_FILENAME) values('" + F_blh + "','" + bglx + "','" + bgxh + "','" + ML + "\\" + F_blh + "','" + jpgname2 + "')"); aa.ExecuteSQL("update T_jcxx_fs set F_fszt='已处理',F_ispdf='true' where F_blh='" + F_blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' "); } else { if (msg == "1") { MessageBox.Show("上传PDF失败:" + message); } log.WriteMyLog("上传PDF失败:" + message); ZgqClass.BGHJ(F_blh, "JK", "审核", message, "ZGQJK", "上传PDF"); // aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_bz='上传PDF失败:" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } //上传服务器 //string ftpml = DateTime.Now.ToString("yyyyMMdd"); //bool status = false; //for (int y = 0; y < 3; y++) //{ // status = zgq.UpPDF("", jpgname, ftpml, ref message, 4); // if (status) // break; //} //if (status) //{ // pdftoyxpt = true; // FileInfo fi = new FileInfo(jpgname); // ftplj = "PIS" + "//" + ftpml + "//" + fi.Name; // log.WriteMyLog("ftp上传成功,上传路径:" + ftplj); //} } else { if (msg == "1") { MessageBox.Show("生成PDF失败:未找到文件---" + jpgname); } log.WriteMyLog("生成PDF失败:未找到文件---" + jpgname); ZgqClass.BGHJ(F_blh, "JK", "审核", "上传PDF失败:未找到文件---" + jpgname, "ZGQJK", "生成PDF"); } } else { if (msg == "1") { MessageBox.Show("生成PDF失败:" + message); } log.WriteMyLog("生成PDF失败:" + message); ZgqClass.BGHJ(F_blh, "JK", "审核", message, "ZGQJK", "生成PDF"); // aa.ExecuteSQL("update T_JCXX_FS set F_ISPDF='false',F_bz='生成PDF失败:" + message + "' where F_blh='" + blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } zgq.DelTempFile(F_blh); #endregion } //////////////////////***************************************************************** } else { if (bgzt == "取消审核") { aa.ExecuteSQL("delete T_BG_PDF where F_BLH='" + F_blh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'"); } } } catch (Exception ee3) { log.WriteMyLog(ee3.Message); } } #endregion if (bglx != "cg")//只传常规报告 { aa.ExecuteSQL("update T_jcxx_fs set F_fszt='不处理' F_bz='非常规报告' where F_blh='" + F_blh + "' and F_bglx='" + bglx + "' and F_bgxh='" + bgxh + "' and F_fszt='未处理'"); return; } } catch (Exception ee) { log.WriteMyLog(ee.Message); } return; }
public void pathtohis(string blh, string yymc) { string debug = f.ReadString("savetohis", "debug", ""); dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable bljc = new DataTable(); try { bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "jcxx"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); return; } if (bljc == null) { MessageBox.Show("查询数据库失败"); return; } if (bljc.Rows.Count <= 0) { log.WriteMyLog("JCXX表未查询到数据"); return; } if (bljc.Rows[0]["f_brlb"].ToString().Trim() != "体检") { log.WriteMyLog("非体检病人不处理"); return; } string sqxh = bljc.Rows[0]["f_sqxh"].ToString().Trim(); if (sqxh == "") { log.WriteMyLog("体检病人无申请序号,不处理"); return; } if (bljc.Rows[0]["F_BRLB"].ToString().Trim() == "体检") { string odbc_tj = f.ReadString("savetohis", "tjodbc", "Data Source=10.27.1.35;Initial Catalog=zonekingnet;User Id=sa;Password=zoneking;").Replace("\0", "").Trim(); string bglx = "cg"; string bgxh = "1"; string ML = DateTime.Parse(bljc.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM"); SqlDB db_tj = new SqlDB(); #region 执行存储过程,回写登记状态 string errMsg = ""; try { if (bljc.Rows[0]["F_TJXTBJ"].ToString().Trim() == null || bljc.Rows[0]["F_TJXTBJ"].ToString().Trim() == "") { SqlParameter[] sqlPt = new SqlParameter[3]; for (int j = 0; j < sqlPt.Length; j++) { sqlPt[j] = new SqlParameter(); } sqlPt[0].ParameterName = "@Exam_No"; sqlPt[0].SqlDbType = SqlDbType.VarChar; sqlPt[0].Direction = ParameterDirection.Input; sqlPt[0].Size = 20; sqlPt[0].Value = sqxh; sqlPt[1].ParameterName = "@StudyType"; sqlPt[1].SqlDbType = SqlDbType.VarChar; sqlPt[1].Direction = ParameterDirection.Input; sqlPt[1].Size = 20; sqlPt[1].Value = "BL"; sqlPt[2].ParameterName = "@StudyState"; sqlPt[2].SqlDbType = SqlDbType.Int; sqlPt[2].Direction = ParameterDirection.Input; sqlPt[2].Value = 1; int x = db_tj.ExecuteNonQuery(odbc_tj, "dbo.Pro_pacs_ReqStatus", ref sqlPt, CommandType.StoredProcedure, ref errMsg); if (x > 0) { aa.ExecuteSQL("update T_JCXX set F_TJXTBJ='1' where F_blh='" + blh + "'"); } else { } } } catch (Exception ee2) { log.WriteMyLog("体检申请单确认异常:" + ee2.Message); } #endregion #region 回传体检报告 if (bljc.Rows[0]["F_bgzt"].ToString().Trim() == "已写报告" && bljc.Rows[0]["F_TJXTBJ"].ToString().Trim() == "2") { db_tj.ExecuteNonQuery(odbc_tj, "delete from T_SYN_ZK_CHECK_BL where StudyID='" + sqxh + "'", ref errMsg); aa.ExecuteSQL("update T_JCXX set F_TJXTBJ='1' where F_blh='" + blh + "'"); return; } if (bljc.Rows[0]["F_bgzt"].ToString().Trim() == "已审核") { #region 生成jpg ZgqPDFJPG zgq = new ZgqPDFJPG(); string errmsg = ""; string filename = ""; string tjtppath = ""; bool isrtn = zgq.CreatePDF(blh, bglx, bgxh, ZgqPDFJPG.Type.JPG, ref filename, "", ref errmsg); string xy = "3"; if (isrtn) { //二进制串 if (!File.Exists(filename)) { ZgqClass.BGHJ(blh, "体检生成JPG", "审核", "生成JPG失败:未找到文件" + filename, "ZGQJK", "生成JPG"); log.WriteMyLog("未找到文件" + filename); zgq.DelTempFile(blh); return; } ZgqClass.BGHJ(blh, "体检生成JPG", "审核", "生成JPG成功", "ZGQJK", "生成JPG"); string pdfpath = ""; bool ssa = zgq.UpPDF(blh, filename, ML, ref errmsg, 4, ref pdfpath); // zgq.UpPDF(blh, filename, ML, ref errmsg, 3, ref pdfpath); if (ssa == true) { if (debug == "1") { log.WriteMyLog("上传JPG成功"); } filename = filename.Substring(filename.LastIndexOf('\\') + 1); ZgqClass.BGHJ(blh, "上传JPG", "审核", "上传JPG成功:" + pdfpath, "ZGQJK", "上传JPG"); tjtppath = pdfpath.Substring(pdfpath.IndexOf("/", 8)); } else { log.WriteMyLog("上传JPG失败:" + errmsg); ZgqClass.BGHJ(blh, "上传JPG", "审核", "上传JPG失败:" + errmsg, "ZGQJK", "上传JPG"); zgq.DelTempFile(blh); return; } } else { log.WriteMyLog("体检生成JPG失败:" + errmsg); ZgqClass.BGHJ(blh, "生成JPG", "审核", "生成JPG失败:" + errmsg, "ZGQJK", "生成JPG"); zgq.DelTempFile(blh); return; } #endregion DataTable dt_tj = new DataTable(); dt_tj = db_tj.DataAdapter(odbc_tj, "select * from T_SYN_ZK_CHECK_BL where StudyID='" + sqxh + "'", ref errMsg); if (errMsg != "") { log.WriteMyLog(errMsg); } string blzd = bljc.Rows[0]["F_BLZD"].ToString().Trim() + "\r\n" + bljc.Rows[0]["F_TSJC"].ToString().Trim(); string rysj = bljc.Rows[0]["F_rysj"].ToString().Trim() + "\r\n" + bljc.Rows[0]["F_JXSJ"].ToString().Trim(); string bz = ""; if (bljc.Rows[0]["F_blk"].ToString().Trim() == "TCT") { DataTable TJ_bljc = new DataTable(); TJ_bljc = aa.GetDataTable(" select * from T_TBS_BG where F_blh='" + blh + "'", "blxx"); if (TJ_bljc == null || TJ_bljc.Rows.Count <= 0) { } else { rysj = "标本满意度:" + TJ_bljc.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["f_tbs_xbl"].ToString().Trim() + "\r\n"; rysj = rysj + TJ_bljc.Rows[0]["F_TBS_XBXM1"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_XBXM2"].ToString().Trim() + "\r\n"; rysj = rysj + TJ_bljc.Rows[0]["F_TBS_XBXM3"].ToString().Trim() + "\r\n"; rysj = rysj + "病原微生物:" + TJ_bljc.Rows[0]["F_TBS_WSW6"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_WSW2"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_WSW1"].ToString().Trim() + "\r\n"; rysj = rysj + TJ_bljc.Rows[0]["F_TBS_WSW3"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_BDXM1"].ToString().Trim() + "\r\n"; rysj = rysj + "炎症程度:" + TJ_bljc.Rows[0]["F_TBS_YZCD"].ToString().Trim(); //////////////////////////////////// blzd = TJ_bljc.Rows[0]["F_TBSZD"].ToString().Trim(); if (TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() != "") { bz = bz + "补充意见1:" + TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() + "\r\n"; } if (TJ_bljc.Rows[0]["F_TBS_BCYJ2"].ToString().Trim() != "") { bz = bz + "补充意见2:" + TJ_bljc.Rows[0]["F_TBS_BCYJ2"].ToString().Trim(); } } } string sql_insert = "insert into T_SYN_ZK_CHECK_BL(Pacs_CheckID,CISID,StudyID,PacsItemCode,PatientNameChinese," + "PatientSex,PatientBirthday,StudyType,StudyBodyPart,ClinicDiagnose,ClinicSymptom,ClinicAdvice,IMGStrings," + "StudyState,Check_Doc,Check_Date,Report_Doc,Report_Date,Audit_Doc,Audit_Date,Status_To_Cis) values(" + "'" + blh + "','" + bljc.Rows[0]["F_MZH"].ToString().Trim() + "','" + sqxh + "','','" + bljc.Rows[0]["F_XM"].ToString().Trim() + "'," + "'" + bljc.Rows[0]["F_XB"].ToString().Trim() + "','" + bljc.Rows[0]["F_ZY"].ToString().Trim() + "',''," + "'" + bljc.Rows[0]["F_BBMC"].ToString().Trim() + "','" + blzd + "','" + rysj + "','" + bz + "','" + tjtppath + "',5," + "'" + bljc.Rows[0]["F_QCYS"].ToString().Trim() + "','" + bljc.Rows[0]["F_SDRQ"].ToString().Trim() + "'," + "'" + bljc.Rows[0]["F_BGYS"].ToString().Trim() + "','" + bljc.Rows[0]["F_BGRQ"].ToString().Trim() + "'," + "'" + bljc.Rows[0]["F_SHYS"].ToString().Trim() + "','" + bljc.Rows[0]["F_SPARE5"].ToString().Trim() + "',0" + ")"; if (dt_tj.Rows.Count > 0) { sql_insert = "update T_SYN_ZK_CHECK_BL set Pacs_CheckID='" + blh + "',CISID='" + bljc.Rows[0]["F_MZH"].ToString().Trim() + "',PatientNameChinese='" + bljc.Rows[0]["F_XM"].ToString().Trim() + "'," + "PatientSex='" + bljc.Rows[0]["F_XB"].ToString().Trim() + "',PatientBirthday='" + bljc.Rows[0]["F_ZY"].ToString().Trim() + "',StudyBodyPart='" + bljc.Rows[0]["F_BBMC"].ToString().Trim() + "',ClinicDiagnose='" + blzd + "',ClinicSymptom='" + rysj + "',ClinicAdvice='" + bz + "',IMGStrings='" + tjtppath + "'," + "StudyState=5,Check_Doc='" + bljc.Rows[0]["F_QCYS"].ToString().Trim() + "',Check_Date='" + bljc.Rows[0]["F_SDRQ"].ToString().Trim() + "',Report_Doc='" + bljc.Rows[0]["F_BGYS"].ToString().Trim() + "',Report_Date='" + bljc.Rows[0]["F_BGRQ"].ToString().Trim() + "',Audit_Doc='" + bljc.Rows[0]["F_SHYS"].ToString().Trim() + "',Audit_Date='" + bljc.Rows[0]["F_SPARE5"].ToString().Trim() + "',Status_To_Cis=0 " + " where StudyID='" + sqxh + "'"; } if (debug == "1") { log.WriteMyLog(sql_insert); } int z = db_tj.ExecuteNonQuery(odbc_tj, sql_insert, ref errMsg); if (z > 0) { if (debug == "1") { log.WriteMyLog("写入数据库成功"); } aa.ExecuteSQL("update T_JCXX set F_TJXTBJ='2' where F_BLH='" + blh + "'"); } else { log.WriteMyLog("写入数据失败:" + errMsg); } } #endregion return; } }