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 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 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文件异常"); } } } } }