private void SaveToHIS(DataTable bljc, PathHISJK.ODBCHelper bb) { string blh = bljc.Rows[0]["F_BLH"] == null ? "" : bljc.Rows[0]["F_BLH"].ToString().Trim(); string sqxh = bljc.Rows[0]["F_SQXH"] == null ? "" : bljc.Rows[0]["F_SQXH"].ToString().Trim(); string xm = bljc.Rows[0]["F_XM"] == null ? "" : bljc.Rows[0]["F_XM"].ToString().Trim(); string xb = bljc.Rows[0]["F_XB"] == null ? "" : bljc.Rows[0]["F_XB"].ToString().Trim(); string bbmc = bljc.Rows[0]["F_BBMC"] == null ? "" : bljc.Rows[0]["F_BBMC"].ToString().Trim(); string rysj = bljc.Rows[0]["F_RYSJ"] == null ? "" : bljc.Rows[0]["F_RYSJ"].ToString().Trim(); string blzd = bljc.Rows[0]["F_BLZD"] == null ? "" : bljc.Rows[0]["F_BLZD"].ToString().Trim(); string bgys = bljc.Rows[0]["F_BGYS"] == null ? "" : bljc.Rows[0]["F_BGYS"].ToString().Trim(); string shys = bljc.Rows[0]["F_SHYS"] == null ? "" : bljc.Rows[0]["F_SHYS"].ToString().Trim(); string bgrq = bljc.Rows[0]["F_BGRQ"] == null ? "" : bljc.Rows[0]["F_BGRQ"].ToString().Trim(); mdjpg xx = new mdjpg(); string bglj = ""; xx.BMPTOJPG(blh, ref bglj, "CG", "0"); string ftpserver = f.ReadString("hisftp", "ftpip", "").Replace("\0", ""); string ftpuser = f.ReadString("hisftp", "user", "ZKFTP").Replace("\0", ""); string ftppwd = f.ReadString("hisftp", "pwd", "ZKFTP").Replace("\0", ""); string txpath = f.ReadString("hisftp", "txpath", "PACSDATA").Replace("\0", ""); string ftppath = Path.Combine(ftpserver, txpath); if (bglj != "") { FtpWeb fw = new FtpWeb(ftpserver, txpath, ftpuser, ftppwd); string status = ""; fw.Upload(@"C:\temp\" + blh + @"\" + blh + @"_1.jpg", "", out status); string insertsql = string.Format("insert into dbo.T_SYN_ZK_CHECK(PACS_CheckID,CISID,PatientNameChinese,PatientSex,PatientBirthday,StudyType,StudyBodyPart,ClinicDiagnose,ClinicSymptom,ClinicAdvice,IMGStrings,StudyState,Check_Doc,Check_Date,Report_Doc,Report_Date,Audit_Doc,Audit_Date) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", blh, sqxh, xm, xb, "", "GJ", bbmc, blzd, rysj, "", blh + @"_1.jpg", 5, "", "", bgys, bgrq, shys, bgrq); OdbcCommand cmd = bb.GetOdbcStringCommond(insertsql); if (msg == "1") { MessageBox.Show(cmd.Connection.ConnectionString); } bb.ExecuteNonQuery(cmd); } }
public string CaQZ(string blh, string bglx, string bgxh, string debug, DataTable dt_cg, string yhmc, string bgzt) { string msg = f.ReadString("savetohis", "camsg", "0").Replace("\0", ""); string logname = "CAZGQJK"; dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); string blbh = blh; if (bglx == "bc" || bglx == "bd") { blbh = blh + bglx + bgxh; } try { if (debug == "1") { log.WriteMyLog("开始签字。。。", logname); } DataTable dt_bd = new DataTable(); DataTable dt_bc = new DataTable(); //补充审核 string sql_str = ""; if (bglx == "bc") { sql_str = "select * from T_BCBG where F_BLH='" + blh + "' and F_BC_BGZT='已审核' and F_BC_BGXH='" + bgxh + "'"; dt_bc = aa.GetDataTable(sql_str, "bcbg"); if (dt_bc.Rows.Count <= 0) { log.WriteMyLog("未查询到此补充报告" + blbh, logname); return("0"); } } //小冰冻审核 if (bglx == "bd") { sql_str = "select * from T_BDBG where F_BLH='" + blh + "' and F_BD_BGZT='已审核' and F_BD_BGXH='" + bgxh + "'"; dt_bd = aa.GetDataTable(sql_str, "bdbg"); if (dt_bd.Rows.Count <= 0) { log.WriteMyLog("未查询到此冰冻报告" + blbh, logname); return("0"); } } string TimeSign_XML = ""; //时间戳服务地址 string yztime = f.ReadString("CA", "yztime", "0"); if (yztime == "1") { string timeip = f.ReadString("CA", "timeip_web", "http://172.20.89.23:8080/xjcaTimestamp/services/sign"); string hash = blbh + "^" + dt_cg.Rows[0]["F_XM"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_NL"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_XM"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_BRBH"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_SQXH"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_ZYH"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_MZH"].ToString().Trim() + "^" + dt_cg.Rows[0]["F_SFZH"].ToString().Trim(); if (debug == "1") { log.WriteMyLog("验证时间戳:" + blbh + "\n" + hash, logname); } //返回值时间戳xml(TimeSign_XML)需要写人数据库 StringBuilder md5 = new StringBuilder(Getmd5(hash)); try { TimeSign_XML = XJCA_TimeSign(timeip, blbh, md5); } catch (Exception ee2) { if (msg == "1") { MessageBox.Show("CA签名:时间戳验证失败:" + ee2.Message); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "时间戳验证失败:" + ee2.Message, "ZGQJK", "CA签名"); log.WriteMyLog("CA签名:时间戳验证失败:" + ee2.Message, logname); return("0"); } if (debug == "1") { log.WriteMyLog("CA签名:TimeSign_XML:" + TimeSign_XML, logname); } if (debug == "1") { log.WriteMyLog("CA签名:时间戳完成", logname); } } //签章---------------------------------- if (debug == "1") { log.WriteMyLog("CA签名:开始签章。。。", logname); } //签章原文 string xmlstr = ""; string bgwy = ""; if (bglx == "cg" || bglx == "") { xmlstr = xmlstr + "<F_BLZD><![CDATA[" + dt_cg.Rows[0]["F_BLZD"].ToString() + "]]></F_BLZD>"; xmlstr = xmlstr + "<F_BGYS>" + dt_cg.Rows[0]["F_BGYS"].ToString() + "</F_BGYS>"; xmlstr = xmlstr + "<F_SHYS>" + dt_cg.Rows[0]["F_SHYS"].ToString() + "</F_SHYS>"; xmlstr = xmlstr + "<F_BGRQ>" + dt_cg.Rows[0]["F_BGRQ"].ToString() + "</F_BGRQ>"; xmlstr = xmlstr + "<F_SPARE5>" + dt_cg.Rows[0]["F_spare5"].ToString() + "</F_SPARE5>"; xmlstr = xmlstr + "<F_BGLX>" + "cg1" + "</F_BGLX>"; } if (bglx == "bc" && dt_bc.Rows.Count > 0) { xmlstr = xmlstr + "<F_BLZD><![CDATA[" + dt_bc.Rows[0]["F_BCZD"].ToString() + "]]></F_BLZD>"; xmlstr = xmlstr + "<F_BGYS>" + dt_bc.Rows[0]["F_BC_BGYS"].ToString() + "</F_BGYS>"; xmlstr = xmlstr + "<F_SHYS>" + dt_bc.Rows[0]["F_BC_SHYS"].ToString() + "</F_SHYS>"; xmlstr = xmlstr + "<F_BGRQ>" + dt_bc.Rows[0]["F_BC_BGRQ"].ToString() + "</F_BGRQ>"; xmlstr = xmlstr + "<F_SPARE5>" + dt_bc.Rows[0]["F_BC_spare5"].ToString() + "</F_SPARE5>"; xmlstr = xmlstr + "<F_BGLX>" + "bc" + bgxh + "</F_BGLX>"; } if (bglx == "bd") { xmlstr = xmlstr + "<F_BLZD><![CDATA[" + dt_bd.Rows[0]["F_BDZD"].ToString() + "]]></F_BLZD>"; xmlstr = xmlstr + "<F_BGYS>" + dt_bd.Rows[0]["F_BD_BGYS"].ToString() + "</F_BGYS>"; xmlstr = xmlstr + "<F_SHYS>" + dt_bd.Rows[0]["F_BD_SHYS"].ToString() + "</F_SHYS>"; xmlstr = xmlstr + "<F_BGRQ>" + dt_bd.Rows[0]["F_BD_BGRQ"].ToString() + "</F_BGRQ>"; xmlstr = xmlstr + "<F_SPARE5>" + dt_bd.Rows[0]["F_BD_BGRQ"].ToString() + "</F_SPARE5>"; xmlstr = xmlstr + "<F_BGLX>" + "bd" + dt_bd.Rows[0]["F_BD_BGXH"].ToString() + "</F_BGLX>"; } if (xmlstr == "") { log.WriteMyLog("CA签名:签章数据内容为空,请重新审核", logname); if (msg == "1") { MessageBox.Show("CA签名失败:签章数据内容为空"); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "签章数据内容为空", "ZGQJK", "CA签名"); return("0"); } string bgyw = ""; bgyw = "<BL>"; bgyw = bgyw + "<F_BLBH>" + blbh + "</F_BLBH>"; bgyw = bgyw + "<F_BLH>" + blh + "</F_BLH>"; bgyw = bgyw + "<F_XM>" + blh + "</F_XM>"; bgyw = bgyw + "<F_XB>" + blh + "</F_XB>"; bgyw = bgyw + "<F_NL>" + blh + "</F_NL>"; bgyw = bgyw + "<F_ZYH>" + blh + "</F_ZYH>"; bgyw = bgyw + "<F_MZH>" + blh + "</F_MZH>"; bgyw = bgyw + "<F_SQXH>" + blh + "</F_SQXH>"; bgyw = bgyw + "<F_YZID>" + blh + "</F_YZID>"; bgyw = bgyw + "<F_BRBH>" + blh + "</F_BRBH>"; bgyw = bgyw + "<F_SFZH>" + blh + "</F_SFZH>"; bgyw = bgyw + "<F_SDRQ>" + blh + "</F_SDRQ>"; bgyw = bgyw + "<F_CH>" + blh + "</F_CH>"; bgyw = bgyw + xmlstr + "</BL>"; if (debug == "1") { log.WriteMyLog("CA签名:签章内容:" + bgyw, logname); } try { int len = 0; StringBuilder signxml = new StringBuilder(100000); bool qzrtn = XJCA_SignSeal(Getmd5(bgyw), signxml, ref len); if (debug == "1") { log.WriteMyLog("CA签名:" + signxml.ToString(), logname); } if (!qzrtn) { log.WriteMyLog("CA签名:数字签名失败,请重新审核" + qzrtn, logname); if (msg == "1") { MessageBox.Show("CA签名:数字签名失败,请重新审核" + qzrtn); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:数字签名失败" + qzrtn, "ZGQJK", "CA签名"); return("0"); } else { string sign = signxml.ToString().Trim(); if (sign == "") { log.WriteMyLog("CA签名:KEY密码验证失败:签名失败", logname); if (msg == "1") { MessageBox.Show("CA签名:KEY密码验证失败:签名失败"); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:KEY密码验证失败:签名失败", "ZGQJK", "CA签名"); return("0"); } if (sign.Split(',')[0].Trim() == "") { log.WriteMyLog("CA签名:KEY密码验证失败:签名失败", logname); if (msg == "1") { MessageBox.Show("CA签名失败:KEY密码验证失败:签名失败"); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:KEY密码验证失败:签名失败", "ZGQJK", "CA签名"); return("0"); } if (debug == "1") { log.WriteMyLog("CA签名:签字通过,解析返回值", logname); } try { // 签章返回的信息signxml 包含签章数据,证书内容,证书id,以“,”隔开,保存签章数据和证书id string[] getsignxml = signxml.ToString().Split(','); //签章数据 string signxml_str = getsignxml[0]; //证书内容 string cert = getsignxml[1]; //证书id string certID = getsignxml[2]; //将signxml,,TimeSign_XML等返回值 存入数据库------------- try { string sqlstr = "insert into T_CAXX(F_blbh,blh,RQ,KeyName,bgnr,TimeSign_XML,signxml,cert,certID) values ('" + blbh + "','" + blh + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + yhmc + "','" + bgyw + "','" + TimeSign_XML + "','" + signxml.ToString() + "','" + cert + "','" + certID + "') "; int x = SQL_ExecuteNonQuery(sqlstr); if (x <= 0) { log.WriteMyLog("CA签名:写入数据库T_SZQM失败", logname); if (msg == "1") { MessageBox.Show("CA签名:写入数据库T_SZQM失败"); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:写入数据库T_SZQM失败", "ZGQJK", "CA签名"); return("0"); } else { if (debug == "1") { log.WriteMyLog("CA签名:插入T_SZQM完成", logname); } if (bglx == "cg") { aa.ExecuteSQL("update T_JCXX set F_SZQZ='1' where F_BLH='" + blh + "'"); } if (bglx == "bc") { aa.ExecuteSQL("update T_BCBG set F_SZQZ='1' where F_BLH='" + blh + "' and F_bc_bgxh='" + bgxh + "'"); } if (bglx == "bd") { aa.ExecuteSQL("update T_BDBG set F_SZQZ='1' where F_BLH='" + blh + "' and F_bd_bgxh='" + bgxh + "'"); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:签名成功", "ZGQJK", "CA签名"); } } catch (Exception ee7) { log.WriteMyLog("CA签名:写入数据库异常:" + ee7.Message, logname); if (msg == "1") { MessageBox.Show("CA签名:写入数据库异常:" + ee7.Message); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:写入数据库异常:" + ee7.Message, "ZGQJK", "CA签名"); return("0"); } } catch (Exception ee8) { log.WriteMyLog("CA签名:解析签名数据异常:" + ee8.Message, logname); if (msg == "1") { MessageBox.Show("CA签名:解析签名数据异常:" + ee8.Message); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:解析签名数据异常:" + ee8.Message, "ZGQJK", "CA签名"); return("0"); } } log.WriteMyLog("CA签名:签名完成", logname); } catch (Exception ee9) { log.WriteMyLog("CA签名:签名异常:" + ee9.Message, logname); if (msg == "1") { MessageBox.Show("CA签名:签名异常:" + ee9.Message); } ZgqClass.BGHJ(blh, yhmc, "数字签名", "CA签名:签名异常:" + ee9.Message, "ZGQJK", "CA签名"); return("0"); } //---------------------------------------------- //----------------获取签章图片---------------------- //---------------------------------------------- string getbmpfs = f.ReadString("CA", "getbmpfs", "2").Replace("\0", "").Trim(); string upbmpfs = f.ReadString("CA", "upbmpfs", "0").Replace("\0", "").Trim(); string bmppath = ZgqClass.GetSz("view", "szqmlj", Application.StartupPath.ToString() + "\\rpt-szqm\\ysbmp").Replace("\0", ""); if (getbmpfs == "0") { goto GetEwm; } if (getbmpfs == "2") { if (File.Exists(bmppath + "\\" + yhmc + ".bmp")) { goto GetEwm; } } if (!Directory.Exists(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\")) { Directory.CreateDirectory(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\"); } if (debug == "1") { log.WriteMyLog("获取签章图片开始。。。", logname); } bool ss = XJCA_GetSealBMPB(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp", 1); // XJCA_ResetDevice(); if (ss) { if (!File.Exists(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp")) { log.WriteMyLog("获取签章图片失败" + Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp", logname); } if (debug == "1") { log.WriteMyLog("获取签章图片成功,开始上传。。", logname); } if (upbmpfs == "1") { if (debug == "1") { log.WriteMyLog("上传签名图片:" + Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp --->" + bmppath + yhmc + ".bmp", logname); } File.Copy(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp", bmppath + yhmc + ".bmp", true); if (!File.Exists(bmppath + yhmc + ".bmp")) { log.WriteMyLog("签章图片上传失败" + bmppath + yhmc + ".bmp", logname); return("0"); } if (debug == "1") { log.WriteMyLog("签章图片上传成功", logname); } return("1"); } if (upbmpfs == "2") { ///////上传签章图片至ftp--------------------- string ftpServerIP = f.ReadString("ftp", "ftpip", ""); string ftpUserID = f.ReadString("ftp", "user", ""); string ftpPassword = f.ReadString("ftp", "pwd", ""); string ftpszqmpath = f.ReadString("ca", "ftpszqmpath", "/pathsetup/pathqc/rpt-szqm/YSBMP/"); string ftpURI = "ftp://" + ftpServerIP + "/" + ftpszqmpath + "/"; string status = ""; FtpWeb fw = new FtpWeb(ftpServerIP, ftpszqmpath, ftpUserID, ftpPassword); fw.Upload(Application.StartupPath.ToString() + "\\rpt-szqm\\YSBMP\\" + yhmc + ".bmp", "", out status); if (status == "Error") { log.WriteMyLog("CA签名:签章图片上传失败,请重新审核", logname); return("0"); } if (debug == "1") { log.WriteMyLog("签章图片上传成功", logname); } } } else { if (debug == "1") { log.WriteMyLog("签章图片获取失败,请重新审核", logname); } return("1"); } /////验章 // XJCAverify.(M_signxml, M_signxml.Length, Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP", 7, 3, 3, 0); GetEwm: # region 获取二维码图片 string get2wm = f.ReadString("ca", "get2wm", "0").Replace("\0", ""); if (get2wm == "1") { if (!Directory.Exists(Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\")) { Directory.CreateDirectory(Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\"); } else { DirectoryInfo dir = new DirectoryInfo(Application.StartupPath.ToString() + @"\rpt-szqm\MakePdfFile\"); foreach (FileInfo ff in dir.GetFiles("*.*")) { ff.Delete(); } } StringBuilder M_signxml = new StringBuilder(blbh, 10000); XJCA_MakePdf417ToFile(M_signxml, M_signxml.Length, Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP", 7, 3, 3, 0); //XJCA_ResetDevice(); if (!File.Exists(Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP")) { log.WriteMyLog("二维码不存在" + Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP", logname); return("1"); } string up2wmfs = f.ReadString("ca", "up2wmfs", "1").Replace("\0", ""); if (up2wmfs == "1") { string ewmpath = f.ReadString("ca", "ewmpath", Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile").Replace("\0", ""); if (debug == "1") { log.WriteMyLog("上传二维码图片:" + Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP --->" + ewmpath + "\\" + blbh + "EWM.BMP", logname); } File.Copy(Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP", ewmpath + "\\" + blbh + "EWM.BMP", true); if (!File.Exists(ewmpath + "\\" + blbh + "EWM.BMP")) { log.WriteMyLog("二维码图片上传失败" + ewmpath + "\\" + blbh + "EWM.BMP", logname); return("0"); } if (debug == "1") { log.WriteMyLog("二维码图片上传成功", logname); } return("1"); } if (upbmpfs == "2") { ///////上传签章图片至ftp--------------------- string ftpServerIP = f.ReadString("ftp", "ftpip", ""); string ftpUserID = f.ReadString("ftp", "user", ""); string ftpPassword = f.ReadString("ftp", "pwd", ""); string ftpewmpath = f.ReadString("ca", "ftpewmpath", "/pathimages/szqm/MakePdfFile/"); string ftpURI = "ftp://" + ftpServerIP + "/" + ftpewmpath + "/"; string status = ""; FtpWeb fw = new FtpWeb(ftpServerIP, ftpewmpath, ftpUserID, ftpPassword); fw.Upload(Application.StartupPath.ToString() + "\\rpt-szqm\\MakePdfFile\\" + blbh + "EWM.BMP", "", out status); if (status == "Error") { log.WriteMyLog("二维码图片上传失败,请重新审核!", logname); return("0"); } if (debug == "1") { log.WriteMyLog("二维码图片上传成功", logname); } } } return("1"); } catch (Exception ee1) { log.WriteMyLog(ee1.Message, logname); return("0"); } #endregion }
public void pathtohis(string blh, string debug) { dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); msg = f.ReadString("savetohis", "msg", ""); 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("病理数据库设置有问题!"); log.WriteMyLog("病理数据库设置有问题!"); return; } if (jcxx.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); log.WriteMyLog("病理号有错误!"); return; } if (jcxx.Rows[0]["F_brlb"].ToString().Trim() != "体检") { //不检查审核状态 if (jcxx.Rows[0]["F_bgzt"].ToString().Trim() != "已审核") { return; } //string bgzt = dataGridView1.CurrentRow.Cells["报告状态"].Value.ToString().Trim(); if (jcxx.Rows[0]["F_brbh"].ToString().Trim() == "") { log.WriteMyLog(blh + ",无病人编号,不处理!"); return; } string brlb = ""; string brbh = ""; string brxb = ""; string zyh = ""; string yzid = ""; string shys = jcxx.Rows[0]["F_SHYS"].ToString().Trim(); string sdrq = jcxx.Rows[0]["F_sdrq"].ToString().Trim(); string bgrq = jcxx.Rows[0]["F_bgrq"].ToString().Trim(); brxb = jcxx.Rows[0]["F_xb"].ToString().Trim(); brxm = jcxx.Rows[0]["F_xm"].ToString().Trim(); brbh = jcxx.Rows[0]["F_brbh"].ToString().Trim(); // blh = jcxx.Rows[0]["F_blh"].ToString().Trim(); zyh = jcxx.Rows[0]["F_zyh"].ToString().Trim(); yzid = jcxx.Rows[0]["F_yzid"].ToString().Trim(); string his_blh = ""; if (jcxx.Rows[0]["F_brlb"].ToString().Trim() == "住院") { brlb = "1"; his_blh = jcxx.Rows[0]["F_zyh"].ToString().Trim(); //zybh = jcxx.Rows[0]["F_yzid"].ToString().Trim(); } else { if (jcxx.Rows[0]["F_brlb"].ToString().Trim() == "门诊") { brlb = "0"; his_blh = jcxx.Rows[0]["F_mzh"].ToString().Trim(); } //zybh = jcxx.Rows[0]["F_brbh"].ToString().Trim(); } bg01(brlb, brbh, blh, "1", his_blh, brxb, bgrq, yzid, sdrq, shys); } else { //------------------------------ // string msg = f.ReadString("savetohis", "msg", ""); //string odbcstr = f.ReadString("savetohis", "odbcsql", "Data Source=192.168.0.1;Initial Catalog=zonekingnet;User Id=sa;Password=zoneking;"); //获取sz.ini中设置的odbcsql string odbcstr = f.ReadString("savetohis", "odbcsql", "DSN=pathnet-tj;UID=sa;PWD=zoneking;"); //获取sz.ini中设置的odbcsql if (jcxx.Rows[0]["F_SQXH"].ToString().Trim() == "") { log.WriteMyLog("无体检号申请单号,不处理!"); return; } if (jcxx.Rows[0]["F_BGZT"].ToString().Trim() == "已审核") { string jpgname = ""; string ftpstatus = ""; mdjpg mdj = new mdjpg(); try { mdj.BMPTOJPG(blh, ref jpgname, "", ""); } catch (Exception ee) { MessageBox.Show(ee.ToString()); } if (msg == "1") { MessageBox.Show("生成jpg成功"); } //---上传jpg---------- //----------------上传签章jpg至ftp--------------------- string status = ""; string ftps = f.ReadString("ftp", "ftp", "").Replace("\0", ""); string ftpServerIP = f.ReadString("ftp", "ftpip", "").Replace("\0", ""); string ftpUserID = f.ReadString("ftp", "user", "ftpuser").Replace("\0", ""); string ftpPassword = f.ReadString("ftp", "pwd", "ftp").Replace("\0", ""); string ftplocal = f.ReadString("ftp", "ftplocal", "c:\\temp").Replace("\0", ""); string ftpRemotePath = f.ReadString("ftp", "bgjpgPath", "pathimages/bgjpg").Replace("\0", ""); string tjtxpath = f.ReadString("savetohis", "tjtxpath", "bgjpg"); string jpgpath = ""; if (ftps == "1") { FtpWeb fw = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword); string ftpURI = "ftp://" + ftpServerIP + "/" + ftpRemotePath + "/"; try { //判断ftp上是否存在该jpg文件 if (fw.fileCheckExist(ftpURI, blh + "_1.jpg")) { //删除ftp上的jpg文件 fw.fileDelete(ftpURI, blh + "_1.jpg").ToString(); } //上传新生成的jpg文件 fw.Upload("C:\\temp\\" + blh + "\\" + blh + "_1.jpg", "", out status); if (status == "Error") { MessageBox.Show("报告jpg上传失败,请重新审核!"); return; } } catch { if (msg == "1") { MessageBox.Show("上传报告jpg文件异常"); } return; } } else { if (tjtxpath == "") { log.WriteMyLog("sz.ini txpath图像目录未设置"); return; } try { File.Copy(ftplocal + "\\" + blh + "\\" + blh + "_1.jpg", tjtxpath + "\\" + blh + "_1.jpg", true); } catch (Exception ee) { log.WriteMyLog("源路径:" + ftplocal + "\\" + blh + "_1.jpg" + "\n" + " 目标路径:" + tjtxpath + "\\" + blh + "_1.jpg"); log.WriteMyLog("复制文件异常!" + ee.ToString()); return; } } if (msg == "1") { MessageBox.Show("上传报告jpg文件完成"); } try { if (System.IO.Directory.Exists(@"c:\temp\" + blh)) { System.IO.Directory.Delete(@"c:\temp\" + blh, true); } } catch { log.WriteMyLog("删除临时目录" + blh + "失败"); return; } ////////////////////////////////////////////////////////// ///////回写体检数据库-T_SYN_TCT_CHECK//////////////////////////////////// string tj_blzd = jcxx.Rows[0]["F_blzd"].ToString().Trim(); string tj_jcsj = jcxx.Rows[0]["F_rysj"].ToString().Trim(); string tj_ysyj = jcxx.Rows[0]["F_BZ"].ToString().Trim(); DataTable TJ_bljc = new DataTable(); TJ_bljc = aa.GetDataTable(" select * from T_TBS_BG where F_blh='" + blh + "'", "blxx"); if (TJ_bljc.Rows.Count > 0) { if (jcxx.Rows[0]["F_blk"].ToString().Trim() == "TCT体检" || jcxx.Rows[0]["F_blk"].ToString().Trim() == "TCT") { tj_jcsj = "标本满意度:" + TJ_bljc.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + "\n" + TJ_bljc.Rows[0]["f_tbs_xbl"].ToString().Trim() + "\n"; tj_jcsj = tj_jcsj + TJ_bljc.Rows[0]["F_TBS_XBXM1"].ToString().Trim() + "\n" + TJ_bljc.Rows[0]["F_TBS_XBXM2"].ToString().Trim() + "\n"; tj_jcsj = tj_jcsj + TJ_bljc.Rows[0]["F_TBS_XBXM3"].ToString().Trim() + "\n"; tj_jcsj = tj_jcsj + "病原微生物:" + TJ_bljc.Rows[0]["F_TBS_WSW6"].ToString().Trim() + "\n" + TJ_bljc.Rows[0]["F_TBS_WSW2"].ToString().Trim() + "\n" + TJ_bljc.Rows[0]["F_TBS_WSW1"].ToString().Trim() + "\n"; tj_jcsj = tj_jcsj + TJ_bljc.Rows[0]["F_TBS_WSW3"].ToString().Trim() + "\n" + TJ_bljc.Rows[0]["F_TBS_BDXM1"].ToString().Trim() + "\n"; //////////////////////////////////// tj_blzd = "诊断:" + TJ_bljc.Rows[0]["F_TBSZD"].ToString().Trim() + "\n" + "炎症程度:" + TJ_bljc.Rows[0]["F_TBS_YZCD"].ToString().Trim(); if (TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() != "") { tj_ysyj = tj_ysyj + "补充意见1:" + TJ_bljc.Rows[0]["F_TBS_BCYJ1"].ToString().Trim() + "\n"; } if (TJ_bljc.Rows[0]["F_TBS_BCYJ2"].ToString().Trim() != "") { tj_ysyj = tj_ysyj + "补充意见2:" + TJ_bljc.Rows[0]["F_TBS_BCYJ2"].ToString().Trim() + "\n"; } } } tj_blzd = tj_blzd + "\n" + tj_ysyj; if (msg == "1") { MessageBox.Show(tj_jcsj); MessageBox.Show(tj_blzd); } string cmdtxt = @"insert into T_SYN_TCT_CHECK(PACS_CheckID,CISID,PACSItemCode,PatientNameChinese,PatientSex,StudyType,StudyBodyPart,ClinicDiagnose,ClinicSymptom,ClinicAdvice,IMGStrings,StudyState,Check_Doc,Check_Date,Report_Doc,Report_Date,Audit_Doc,Audit_Date) values(" + "'" + jcxx.Rows[0]["F_SQXH"].ToString().Trim() + "','" + jcxx.Rows[0]["F_BRBH"].ToString().Trim() + "','" + jcxx.Rows[0]["F_YZID"].ToString().Trim() + "','" + jcxx.Rows[0]["F_XM"].ToString().Trim() + "','" + jcxx.Rows[0]["F_XB"].ToString().Trim() + "'," + "'BL','" + jcxx.Rows[0]["F_bbmc"].ToString().Trim() + "','" + tj_blzd + "','" + tj_jcsj + "','','" + @"pathimages/bgjpg/" + blh + "_1.jpg" + "',5,'" + jcxx.Rows[0]["F_BGYS"].ToString().Trim() + "','" + jcxx.Rows[0]["F_SDRQ"].ToString().Trim() + "'," + "'" + jcxx.Rows[0]["F_bgys"].ToString().Trim() + "','" + jcxx.Rows[0]["F_bgrq"].ToString().Trim() + "','" + jcxx.Rows[0]["F_shys"].ToString().Trim() + "','" + jcxx.Rows[0]["F_SPARE5"].ToString().Trim() + "')"; // int x = SQL_ExecuteNonQuery(odbcstr, cmdtxt, msg); int x = Odbc_ExecuteNonQuery(odbcstr, cmdtxt, msg); if (msg == "1") { MessageBox.Show("影响行数:" + x.ToString()); } if (x < 1) { log.WriteMyLog("回写体检接口失败。"); } else { aa.ExecuteSQL("update T_JCXX set F_SCBJ='1' where F_BLH='" + blh.Trim() + "'"); } } else { if (jcxx.Rows[0]["F_SCBJ"].ToString().Trim() == "1") { string cmdtxt = "delete from T_SYN_TCT_CHECK where PACS_CheckID='" + jcxx.Rows[0]["F_SQXH"].ToString().Trim() + "' and CISID='" + jcxx.Rows[0]["F_BRBH"].ToString().Trim() + "' and PACSItemCode='" + jcxx.Rows[0]["F_YZID"].ToString().Trim() + "'"; int x = Odbc_ExecuteNonQuery(odbcstr, cmdtxt, msg); } } } }
public void pathtohis(string blh, string debug) { string msg = f.ReadString("savetohis", "debug", ""); dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable bljc = new DataTable(); bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "bljc"); if (bljc == null) { MessageBox.Show("病理数据库设置有问题!"); log.WriteMyLog("病理数据库设置有问题!"); return; } if (bljc.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); log.WriteMyLog("病理号有错误!"); return; } if (bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已审核") { if (bljc.Rows[0]["F_brlb"].ToString().Trim() != "体检") { log.WriteMyLog("非体检病人,不处理!"); return; } if (bljc.Rows[0]["F_brbh"].ToString().Trim() == "") { log.WriteMyLog("无体检号,不处理!"); return; } string jpgname = ""; string ftpstatus = ""; //mdjpg mdj = new mdjpg(); //try //{ // mdj.BMPTOJPG(blh, ref jpgname, "", "", "rpt//szqm"); //} //catch (Exception ee) //{ // MessageBox.Show(ee.ToString()); //} mdjpg mdj = new mdjpg(); try { for (int x = 0; x < 3; x++) { if (!File.Exists("C:\\temp\\" + blh + "\\" + blh + "_1.jpg")) { mdj.BMPTOJPG(blh, ref jpgname, "rpt//szqm"); } else { break; } } } catch (Exception ee) { if (msg == "1") { MessageBox.Show("生成JPG异常:" + ee.Message); } log.WriteMyLog(blh + ",生成JPG异常:" + ee.Message); } if (!File.Exists("C:\\temp\\" + blh + "\\" + blh + "_1.jpg")) { if (msg == "1") { MessageBox.Show("未找到文件" + "C:\\temp\\" + blh + "\\" + blh + "_1.jpg"); } log.WriteMyLog(blh + ",未找到文件" + "C:\\temp\\" + blh + "\\" + blh + "_1.jpg"); return; } else { if (msg == "1") { MessageBox.Show("生成jpg成功"); } } //---上传jpg---------- //----------------上传签章jpg至ftp--------------------- string status = ""; string ftps = f.ReadString("ftp", "ftp", "").Replace("\0", ""); string ftpServerIP = f.ReadString("ftp", "ftpip", "").Replace("\0", ""); string ftpUserID = f.ReadString("ftp", "user", "ftpuser").Replace("\0", ""); string ftpPassword = f.ReadString("ftp", "pwd", "ftp").Replace("\0", ""); string ftplocal = f.ReadString("ftp", "ftplocal", "c:\\temp").Replace("\0", ""); string ftpRemotePath = f.ReadString("ftp", "bgjpgPath", "pathimages/bgjpg").Replace("\0", ""); string tjtxpath = f.ReadString("savetohis", "tjtxpath", "bgjpg"); if (ftps == "1") { FtpWeb fw = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword); string ftpURI = "ftp://" + ftpServerIP + "/" + ftpRemotePath + "/"; try { //判断ftp上是否存在该jpg文件 if (fw.fileCheckExist(ftpURI, blh + "_1.jpg")) { //删除ftp上的jpg文件 fw.fileDelete(ftpURI, blh + "_1.jpg").ToString(); } //上传新生成的jpg文件 fw.Upload("C:\\temp\\" + blh + "\\" + blh + "_1.jpg", "", out status); if (status == "Error") { MessageBox.Show("报告jpg上传失败,请重新审核!"); return; } } catch { if (msg == "1") { MessageBox.Show("上传报告jpg文件异常"); } return; } } else { if (tjtxpath == "") { log.WriteMyLog("sz.ini txpath图像目录未设置"); return; } try { File.Copy(ftplocal + "\\" + blh + "\\" + blh + "_1.jpg", tjtxpath + "\\" + blh + "_1.jpg", true); } catch (Exception ee) { log.WriteMyLog("源路径:" + ftplocal + "\\" + blh + "_1.jpg" + "\n" + " 目标路径:" + tjtxpath + "\\" + "_1.jpg"); log.WriteMyLog("复制文件异常!" + ee.ToString()); return; } } if (msg == "1") { MessageBox.Show("上传报告jpg文件完成"); } try { if (System.IO.Directory.Exists(@"c:\temp\" + blh)) { System.IO.Directory.Delete(@"c:\temp\" + blh, true); } } catch { log.WriteMyLog("删除临时目录" + blh + "失败"); return; } } else { if (bljc.Rows[0]["F_brlb"].ToString().Trim() != "体检") { log.WriteMyLog("非体检病人,不处理!"); return; } if (bljc.Rows[0]["F_brbh"].ToString().Trim() == "") { log.WriteMyLog("无体检号,不处理!"); return; } if (bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已写报告") { string status = ""; string ftps = f.ReadString("ftp", "ftp", "").Replace("\0", ""); string ftpServerIP = f.ReadString("ftp", "ftpip", "").Replace("\0", ""); string ftpUserID = f.ReadString("ftp", "user", "ftpuser").Replace("\0", ""); string ftpPassword = f.ReadString("ftp", "pwd", "ftp").Replace("\0", ""); string ftplocal = f.ReadString("ftp", "ftplocal", "c:\\temp").Replace("\0", ""); string ftpRemotePath = f.ReadString("ftp", "bgjpgPath", "pathimages/bgjpg").Replace("\0", ""); string tjtxpath = f.ReadString("savetohis", "tjtxpath", "bgjpg"); if (ftps == "1") { FtpWeb fw = new FtpWeb(ftpServerIP, ftpRemotePath, ftpUserID, ftpPassword); string ftpURI = "ftp://" + ftpServerIP + "/" + ftpRemotePath + "/"; try { //判断ftp上是否存在该jpg文件 if (fw.fileCheckExist(ftpURI, blh + "_1.jpg")) { //删除ftp上的jpg文件 fw.fileDelete(ftpURI, blh + "_1.jpg").ToString(); } return; } catch { if (msg == "1") { MessageBox.Show("报告jpg文件删除异常"); } return; } } else { if (tjtxpath == "") { log.WriteMyLog("sz.ini txpath图像目录未设置"); return; } try { File.Delete(tjtxpath + "\\" + blh + "_1.jpg"); } catch (Exception ee) { log.WriteMyLog("删除jpg文件异常!" + ee.ToString()); return; } } } } }
public void pathtohis(string blh, string yymc) { blhgy = blh; string msg = f.ReadString("savetohis", "msg", ""); string sfsctx = f.ReadString("savetohis", "sfsctx", ""); string odbcsql = f.ReadString("savetohis", "odbcsql", ""); if (odbcsql.Trim() != "") { ConnectionString = odbcsql; } if (msg == "1") { MessageBox.Show(blh); } dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", ""); DataTable bljc = new DataTable(); bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + blh + "'", "blxx"); if (bljc == null) { MessageBox.Show("病理数据库设置有问题!"); log.WriteMyLog("病理数据库设置有问题!"); return; } if (bljc.Rows.Count < 1) { MessageBox.Show("病理号有错误!"); log.WriteMyLog("病理号有错误!"); return; } if (bljc.Rows[0]["F_sqxh"].ToString().Trim() == "") { log.WriteMyLog("无申请序号(单据号),不处理!"); return; } //----------- //--------------- if (bljc.Rows[0]["F_BGZT"].ToString().Trim() == "已审核") { string brbh = bljc.Rows[0]["F_brbh"].ToString().Trim(); if (msg == "1") { MessageBox.Show("报告已审核,准备上传"); } /////////////// string gs = ""; DataTable dt_blk = new DataTable(); dt_blk = aa.GetDataTable("select F_LISXH from T_BLK_CS where F_BLKMC='" + bljc.Rows[0]["F_BLK"].ToString().Trim() + "'", "blk"); if (dt_blk.Rows.Count > 0) { gs = dt_blk.Rows[0]["F_LISXH"].ToString().Trim(); } else { log.WriteMyLog("获取病例库对应格式错误!"); return; } if (gs == "") { log.WriteMyLog("获取病例库对应格式错误!"); return; } brbh = brbh.Substring(0, 8) + gs + brbh.Substring(8, 4); /////////////// ////string zm = bljc.Rows[0]["F_BLH"].ToString().Trim().Substring(0, 1); ////if (bljc.Rows[0]["F_BLK"].ToString().Trim()=="常规") //// brbh = "B" + brbh; ////else brbh = zm + brbh; ////-----------------查询---------- if (msg == "1") { MessageBox.Show("查询SAMPLE_RESULT"); } string select_to_his = "select * from dbo.SAMPLE_RESULT where id='" + brbh + "' and requisition_id='" + bljc.Rows[0]["F_SQXH"].ToString().Trim() + "'"; OleDbConnection orcon = new OleDbConnection(ConnectionString); OleDbCommand orcom = new OleDbCommand(select_to_his, orcon); bool x = false; try { orcon.Open(); OleDbDataReader dr = orcom.ExecuteReader(); x = dr.HasRows; dr.Close(); orcom.Dispose(); } catch (Exception e) { log.WriteMyLog("查询状态出错:" + e.ToString()); orcom.Dispose(); orcon.Close(); return; } finally { orcom.Dispose(); orcon.Close(); } if (msg == "1") { MessageBox.Show("查询SAMPLE_RESULT," + x.ToString()); } //-------------增加---------------- ////RESULT_ANALYZE 病理诊断 ////diagnosis_advice, 肉眼所见 ////assistant_info_1 镜下所见 ////assistant_info_2 特殊检查 ////assistant_info_3 标本满意度 ////assistant_info_4 反应性细胞变化 ////assistant_info_5 微生物项目 ////assistant_info_6 上皮细胞情况 ////assistant_info_7 报告医生 ////assistant_info_8 病理号 ////remark 备注 //RESULT_ANALYZE 病理诊断 string RESULT_ANALYZE = bljc.Rows[0]["F_blzd"].ToString().Trim(); //assistant_info_3 标本满意度 string assistant_info_3 = ""; //assistant_info_4 反应性细胞变化 string assistant_info_4 = ""; //assistant_info_5 微生物项目 string assistant_info_5 = ""; //assistant_info_6 上皮细胞情况 string assistant_info_6 = ""; //remark 备注 string remark = bljc.Rows[0]["F_bz"].ToString().Trim(); if (bljc.Rows[0]["F_blk"].ToString().Trim().Contains("TCT")) { DataTable tbs = new DataTable(); tbs = aa.GetDataTable("select * from T_TBS_BG where F_blh='" + blh + "'", "TBSbg"); if (tbs.Rows.Count > 0) { //assistant_info_2 = tbs.Rows[0]["F_TBS_JYFF"].ToString().Trim(); //assistant_info_3 = tbs.Rows[0]["F_TBS_jyff"].ToString().Trim(); assistant_info_3 = tbs.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + " " + tbs.Rows[0]["F_TBS_XBL"].ToString().Trim() + " " + tbs.Rows[0]["F_TBS_XBXM1"].ToString().Trim() + " " + tbs.Rows[0]["F_TBS_XBXM2"].ToString().Trim() + " " + tbs.Rows[0]["F_TBS_XBXM3"].ToString().Trim(); assistant_info_4 = tbs.Rows[0]["F_TBS_BDXM1"].ToString().Trim() + "\r\n"; assistant_info_4 = assistant_info_4 + tbs.Rows[0]["F_TBS_BDXM2"].ToString().Trim() + "\r\n"; assistant_info_4 = assistant_info_4 + tbs.Rows[0]["F_TBS_BDXM3"].ToString().Trim() + "\r\n"; assistant_info_4 = assistant_info_4 + tbs.Rows[0]["F_TBS_YZCD"].ToString().Trim() + "\r\n"; assistant_info_5 = tbs.Rows[0]["F_TBS_WSW1"].ToString().Trim() + "\r\n"; assistant_info_5 = assistant_info_5 + tbs.Rows[0]["F_TBS_WSW2"].ToString().Trim() + "\r\n"; assistant_info_5 = assistant_info_5 + tbs.Rows[0]["F_TBS_WSW3"].ToString().Trim() + "\r\n"; assistant_info_5 = assistant_info_5 + tbs.Rows[0]["F_TBS_WSW4"].ToString().Trim() + "\r\n"; assistant_info_5 = assistant_info_5 + tbs.Rows[0]["F_TBS_WSW5"].ToString().Trim() + "\r\n"; assistant_info_5 = assistant_info_5 + tbs.Rows[0]["F_TBS_WSW6"].ToString().Trim(); assistant_info_6 = tbs.Rows[0]["F_TBS_BDXM4"].ToString().Trim() + "\r\n"; assistant_info_6 = assistant_info_6 + tbs.Rows[0]["F_TBS_BDXM5"].ToString().Trim(); RESULT_ANALYZE = tbs.Rows[0]["F_TBSZD"].ToString().Trim(); remark = tbs.Rows[0]["F_TBS_BCYJ1"].ToString().Trim(); } } int ITEM_NUM = 0; if (bljc.Rows[0]["F_blk"].ToString().Trim() == "免疫组化") { DataTable myzh_num = new DataTable(); myzh_num = aa.GetDataTable("select count(*) from T_TJYZ where F_blh='" + blh + "'", "myzh_num"); ITEM_NUM = int.Parse(myzh_num.Rows[0][0].ToString()); } //////////////////// //执行语句 if (msg == "1") { MessageBox.Show("拼接执行语句"); } string Oraclestring = ""; if (x) { Oraclestring = @"update dbo.SAMPLE_RESULT set RESULT_ANALYZE ='" + RESULT_ANALYZE.Trim() + "',remark ='" + remark.Trim() + "',diagnosis_advice='" + bljc.Rows[0]["F_rysj"].ToString().Trim() + "',assistant_info_1='" + bljc.Rows[0]["F_jxsj"].ToString().Trim() + "',assistant_info_2='" + bljc.Rows[0]["F_tsjc"].ToString().Trim() + "',assistant_info_3='" + assistant_info_3.Trim() + "',assistant_info_4='" + assistant_info_4.Trim() + "',assistant_info_5='" + assistant_info_5.Trim() + "',assistant_info_6='" + assistant_info_6.Trim() + "',assistant_info_7='" + bljc.Rows[0]["F_SHYS"].ToString().Trim() + "',assistant_info_8='" + bljc.Rows[0]["F_BLH"].ToString().Trim() + "',ITEM_NUM='" + ITEM_NUM + "',sample_name='" + bljc.Rows[0]["F_bbmc"].ToString().Trim() + "',lczd='" + bljc.Rows[0]["F_lczd"].ToString().Trim() + "' ,SAMPLE_NUMBER='" + bljc.Rows[0]["F_bblx"].ToString().Trim() + "',mcyj= '" + bljc.Rows[0]["F_mcyj"].ToString().Trim() + "',recivedate='" + bljc.Rows[0]["F_SDRQ"].ToString().Trim() + "',report_person='" + bljc.Rows[0]["F_BGYS"].ToString().Trim() + "',is_jj='" + bljc.Rows[0]["F_SFJJ"].ToString().Trim() + "' where id='" + brbh + "' and requisition_id='" + bljc.Rows[0]["F_SQXH"].ToString().Trim() + "'"; } else { //RESULT_ANALYZE 病理诊断 // diagnosis_advice, 肉眼所见 //assistant_info_1 镜下所见 //assistant_info_2 特殊检查 //assistant_info_3 检验方法 //assistant_info_4 标本满意度 //assistant_info_5 病原体 //assistant_info_6 炎症程度 //assistant_info_7 报告医生 //assistant_info_8 病理号 //remark 备注 Oraclestring = @"insert into dbo.SAMPLE_RESULT(id,requisition_id,RESULT_ANALYZE,remark,diagnosis_advice,assistant_info_1,assistant_info_2,assistant_info_3,assistant_info_4,assistant_info_5,assistant_info_6,assistant_info_7,assistant_info_8,ITEM_NUM,sample_name,lczd,SAMPLE_NUMBER,mcyj,recivedate,report_person,is_jj) values ('" + brbh.Trim() + "','" + bljc.Rows[0]["F_sqxh"].ToString().Trim() + "','" + RESULT_ANALYZE.Trim() + "','" + remark.Trim() + "','" + bljc.Rows[0]["F_rysj"].ToString().Trim() + "','" + bljc.Rows[0]["F_jxsj"].ToString().Trim() + "','" + bljc.Rows[0]["F_tsjc"].ToString().Trim() + "','" + assistant_info_3.Trim() + "','" + assistant_info_4.Trim() + "','" + assistant_info_5.Trim() + "','" + assistant_info_6.Trim() + "','" + bljc.Rows[0]["F_SHYS"].ToString().Trim() + "','" + bljc.Rows[0]["F_BLH"].ToString().Trim() + "','" + ITEM_NUM + "','" + bljc.Rows[0]["F_bbmc"].ToString().Trim() + "','" + bljc.Rows[0]["F_lczd"].ToString().Trim() + "','" + bljc.Rows[0]["F_bblx"].ToString().Trim() + "','" + bljc.Rows[0]["F_mcyj"].ToString().Trim() + "','" + bljc.Rows[0]["F_SDRQ"].ToString().Trim() + "','" + bljc.Rows[0]["F_BGYS"].ToString().Trim() + "','" + bljc.Rows[0]["F_SFJJ"].ToString().Trim() + "')"; } if (Oraclestring.Trim() == "") { MessageBox.Show("插入语句不能为空"); return; } if (msg == "1") { MessageBox.Show("执行语句:" + Oraclestring); log.WriteMyLog("执行语句:" + Oraclestring); } OleDbCommand orcom_insert = new OleDbCommand(Oraclestring, orcon); int z = -1; try { orcon.Open(); z = orcom_insert.ExecuteNonQuery(); orcom_insert.Dispose(); orcon.Close(); } catch (Exception ee) { log.WriteMyLog("回传报告出错:" + ee.ToString()); orcom_insert.Dispose(); orcon.Close(); return; } finally { orcom_insert.Dispose(); orcon.Close(); } if (msg == "1") { MessageBox.Show("数据库写入完成,返回:" + z.ToString()); } ////下面程序中图像信息 if (sfsctx.Trim() == "1") //FTP下载方式 { //下载FTP参数 string ftpserver = f.ReadString("ftp", "ftpip", "").Replace("\0", ""); string ftpuser = f.ReadString("ftp", "user", "ftpuser").Replace("\0", ""); string ftppwd = f.ReadString("ftp", "pwd", "ftp").Replace("\0", ""); string ftplocal = f.ReadString("ftp", "ftplocal", "c:\\temp").Replace("\0", ""); string ftpremotepath = f.ReadString("ftp", "ftpremotepath", "").Replace("\0", ""); string ftps = f.ReadString("ftp", "ftp", "").Replace("\0", ""); string txpath = f.ReadString("txpath", "txpath", "").Replace("\0", ""); FtpWeb fw = new FtpWeb(ftpserver, ftpremotepath, ftpuser, ftppwd); string txml = bljc.Rows[0]["F_txml"].ToString().Trim(); //下载图像 DataTable txlb = aa.GetDataTable("select top 4 * from V_dytx where F_blh='" + bljc.Rows[0]["F_BLH"].ToString().Trim() + "'", "txlb"); if (txlb.Rows.Count < 1) { log.WriteMyLog("该病人无图像,不上传"); return; } int i2 = 1; for (int i = 0; i < txlb.Rows.Count; i++) { if (i >= txlb.Rows.Count) { return; } try { //-------------------------- i2 = i + 1; string ftpstatus = ""; fw.Download(ftplocal, txml + "/" + txlb.Rows[i]["F_txm"].ToString().Trim(), txlb.Rows[i]["F_txm"].ToString().Trim(), out ftpstatus); if (ftpstatus == "Error") { log.WriteMyLog("FTP下载图像出错!"); return; } //===================上传图片===================== //---上传jpg---------- //----------------上传签章jpg至ftp--------------------- //上传FTP参数 string status = ""; string ftpServerIP_up = f.ReadString("ftpup", "ftpip", "").Replace("\0", ""); string ftpUserID_up = f.ReadString("ftpup", "user", "ftpuser").Replace("\0", ""); string ftpPassword_up = f.ReadString("ftpup", "pwd", "ftp").Replace("\0", ""); string ftplocal_up = f.ReadString("ftpup", "ftplocal", "c:\\temp").Replace("\0", ""); string ftpRemotePath_up = f.ReadString("ftpup", "ftpremotepath", "pathimages").Replace("\0", ""); FtpWeb fw_up = new FtpWeb(ftpServerIP_up, ftpRemotePath_up, ftpUserID_up, ftpPassword_up); string ml1 = bljc.Rows[0]["F_brbh"].ToString().Trim().Substring(0, 4); string ml2 = bljc.Rows[0]["F_brbh"].ToString().Trim().Substring(4, 2); string ml3 = bljc.Rows[0]["F_brbh"].ToString().Trim().Substring(6, 2); string bh = bljc.Rows[0]["F_brbh"].ToString().Trim().Substring(8, 4); string ftpURI = "ftp://" + ftpServerIP_up + "/" + ftpRemotePath_up; try { //判断目录是否存在 if (!fw_up.fileCheckExist(ftpURI + "/" + ml1, ml1)) { //目录不存在,创建 string stat = ""; fw_up.Makedir(ml1, out stat); } if (!fw_up.fileCheckExist(ftpURI + "/" + ml2, ml2)) { //目录不存在,创建 string stat = ""; fw_up.Makedir(ml1 + "/" + ml2, out stat); } if (!fw_up.fileCheckExist(ftpURI + "/" + ml2 + "/" + ml3, ml3)) { //目录不存在,创建 string stat = ""; fw_up.Makedir(ml1 + "/" + ml2 + "/" + ml3, out stat); } //-------------- string jpgname = gs + "000000" + bh + "0" + (i + 1).ToString() + ".jpg"; //判断ftp上是否存在该jpg文件 if (fw_up.fileCheckExist(ftpURI + "/" + ml1 + "/" + ml2 + "/" + ml3 + "/", jpgname)) { //删除ftp上的jpg文件 fw_up.fileDelete(ftpURI + "/" + ml1 + "/" + ml2 + "/" + ml3, jpgname).ToString(); } //上传新生成的jpg文件 string errMsg = ""; fw_up.Upload("C:\\temp\\" + txlb.Rows[i]["F_txm"].ToString().Trim(), ml1 + "/" + ml2 + "/" + ml3, jpgname, out status, ref errMsg); if (status == "Error") { MessageBox.Show("jpg上传失败,请重新审核\r\n" + errMsg); } try { if (System.IO.Directory.Exists(@"c:\temp\" + blh)) { System.IO.Directory.Delete(@"c:\temp\" + blh, true); } } catch { log.WriteMyLog("删除临时目录" + blh + "失败"); } } catch { MessageBox.Show("上传jpg文件异常"); } } catch { MessageBox.Show("上传jpg文件异常"); } } } } }