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;
}
}