public void pathtohis(string blh, string bglx, string bgxh, string debug, string dz, string msg)
{
if (bglx == "")
{
bglx = "cg";
}
if (bgxh == "")
{
bgxh = "0";
}
debug = f.ReadString("savetohis", "debug", "").Replace("\0", "").Trim();
string tjtxpath = f.ReadString("savetohis", "toPDFPath", @"\\192.0.19.147\GMS");
bglx = bglx.ToLower();
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;
}
string jpgname = "";
string jpgpath = "";
string ispdf = f.ReadString("savetohis", "ispdf", "1").Replace("\0", "").Trim();
if (ispdf == "1")
{
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")
{
bgzt2 = jcxx.Rows[0]["F_BGZT"].ToString();
}
}
catch
{
}
if (bgzt2.Trim() == "")
{
log.WriteMyLog("报告状态为空！不处理！" + blh + "^" + bglx + "^" + bgxh);
}
if (bgzt2.Trim() == "已审核" && dz != "qxsh")
{
string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM");
string err_msg = "";
//生成pdf
bool isrtn = MD_PDF_JPG(blh, bglx, bgxh, ML, ZgqPDFJPG.Type.PDF, ref err_msg, ref jpgname, ref jpgpath);
if (isrtn)
{
jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1);
ZgqClass.BGHJ(blh, "his接口", "报告审核", "生成pdf成功:" + jpgpath + "\\" + 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 + "','" + jpgpath + "','" + jpgname + "')");
}
else
{
log.WriteMyLog(blh + "-" + err_msg);
ZgqClass.BGHJ(blh, "his接口", "审核PDF", "生成pdf失败" + err_msg, "ZGQJK", "pdf");
if (msg == "1")
{
MessageBox.Show("病理号：" + blh + " 生成pdf失败，请重新审核！\r\n" + err_msg);
}
return;
}
}
if (dz == "qxsh")
{
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 + "'");
ZgqPDFJPG zgq = new ZgqPDFJPG();
string rtn_msg = "";
zgq.DelPDFFile(dt2.Rows[0]["F_ML"].ToString(), dt2.Rows[0]["F_FILENAME"].ToString(), ref rtn_msg);
}
}
return;
}
}
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 pathtohis(string blh, string bglx, string bgxh, string msg1, string debug, string[] cslb)
{
string qxsh = "";
string xdj = "";
bglx = bglx.ToLower();
string jkmsg = f.ReadString("jkmsg", "jkmsg", "0").Replace("\0", "");
f.WriteInteger("jkmsg", "jkmsg", 0);
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";
}
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().Trim();
}
int plsc = f.ReadInteger("fsjk", "plsc", 0);
string msg = f.ReadString("savetohis", "msg", "1");
if (plsc != 1)
{
////增加体检回写接口/////zgq
if (jcxx.Rows[0]["F_BRLB"].ToString().Trim() == "体检")
{
# region 体检回写接口
if (jcxx.Rows[0]["F_BRBH"].ToString().Trim() == "")
{
ZgqClass.BGHJ(blh, "体检接口", "体检审核", "体检病人无病人编号，不处理", "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='体检病人无病人编号，不处理' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
log.WriteMyLog(blh + ",体检病人无病人编号，不处理！");
if (jkmsg == "1")
{
MessageBox.Show("此体检病人无病人编号，不处理！");
}
return;
}
string err_msg = "";
string constr = f.ReadString("savetohis", "tj_odbcsql", "Provider='MSDAORA';data source=ZSYYTJ;User ID=SD_PE_LIS;Password=SD_PE_LIS;");
OleDbDB db = new OleDbDB();
DataTable TJ_bljc = new DataTable();
TJ_bljc = aa.GetDataTable(" select top 1 * from T_TBS_BG where F_blh='" + blh + "'", "blxx");
if (debug == "1")
{
log.WriteMyLog("执行体检");
}
//体检确认
if (jcxx.Rows[0]["F_TJBJ"].ToString().Trim() != "1")
{
try
{
OleDbParameter[] oledbPt = new OleDbParameter[4];
for (int j = 0; j < oledbPt.Length; j++)
{
oledbPt[j] = new OleDbParameter();
}
oledbPt[0].ParameterName = "para_sfywid";
oledbPt[0].OleDbType = OleDbType.Decimal;
oledbPt[0].Direction = ParameterDirection.Input;
oledbPt[0].Size = 10;
oledbPt[0].Value = Decimal.Parse(jcxx.Rows[0]["F_BRBH"].ToString().Trim());
oledbPt[1].ParameterName = "para_flag"; //
oledbPt[1].OleDbType = OleDbType.Char;
oledbPt[1].Direction = ParameterDirection.Input;
oledbPt[1].Size = 1;
oledbPt[1].Value = '1';
oledbPt[2].ParameterName = "para_result"; //
oledbPt[2].OleDbType = OleDbType.Char;
oledbPt[2].Direction = ParameterDirection.Output;
oledbPt[2].Size = 1;
oledbPt[3].ParameterName = "para_msg"; //
oledbPt[3].OleDbType = OleDbType.VarChar;
oledbPt[3].Direction = ParameterDirection.Output;
oledbPt[3].Size = 200;
if (debug == "1")
{
log.WriteMyLog("执行标记:" + oledbPt[0].Value.ToString() + "@" + oledbPt[1].Value.ToString() + "@" + err_msg);
}
//删除
db.ExecuteNonQuery(constr, "updateBL", ref oledbPt, CommandType.StoredProcedure, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("体检执行标记返回：" + oledbPt[2].Value.ToString() + "@" + oledbPt[3].Value.ToString() + "@" + err_msg);
}
if (oledbPt[2].Value.ToString() != "Y")
{
log.WriteMyLog("体检确认失败：" + oledbPt[2].Value.ToString() + "@" + oledbPt[3].Value.ToString() + "\r\n" + err_msg);
}
else
{
aa.ExecuteSQL("update T_JCXX set F_TJBJ='1' where F_BLH='" + blh + "'");
}
}
catch (Exception e1)
{
log.WriteMyLog(e1.Message);
}
// 确认过程：updateBL
//--para_sfywid 收费业务ID
//--para_flag 0：取消 1：确认
//--para_result N:失败 Y:成功
//procedure updateBL(para_sfywid in number, para_flag in char， para_result out char);
}
if (bgzt.Trim() == "已审核")
{
string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM");
string jpgname = "";
string jpgpath = "";
//生成jpg
bool isrtn = MD_PDF_JPG(blh, bglx, bgxh, ML, ZgqPDFJPG.Type.JPG, ref err_msg, ref jpgname, ref jpgpath);
if (isrtn)
{
jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1);
ZgqClass.BGHJ(blh, "体检接口", "体检审核", "生成jpg成功:" + jpgpath + "\\" + jpgname, "ZGQJK", "体检生成jpg");
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 + "','" + jpgpath + "','" + jpgname + "')");
}
else
{
log.WriteMyLog(blh + "-" + err_msg);
ZgqClass.BGHJ(blh, "体检接口", "体检审核", "生成JPG格式图片失败" + err_msg, "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='生成JPG格式图片失败：" + err_msg + "' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
if (jkmsg == "1" || msg == "1")
{
MessageBox.Show("病理号：" + blh + " 生成JPG格式图片失败，请重新审核！\r\n" + err_msg);
}
return;
}
# region 回传体检报告
// 诊断描述
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() == "TCT")
{
Res_char = Res_char + "标本满意度：" + TJ_bljc.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + "\r\n";
Res_char = Res_char + "细胞量：" + TJ_bljc.Rows[0]["F_TBS_XBL"].ToString().Trim() + "\r\n细胞成分：" + TJ_bljc.Rows[0]["F_TBS_XBXM2"].ToString().Trim()
+ "\r\n炎细胞：" + TJ_bljc.Rows[0]["F_TBS_YZCD"].ToString().Trim() + "\r\n";
Res_char = Res_char + "微生物：" + TJ_bljc.Rows[0]["F_TBS_WSW2"].ToString().Trim() + "\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 path = f.ReadString("savetohis", "jpgpath", @"\\192.10.33.84\pdfbg\");
jpgpath = path + jpgpath + "\\" + jpgname;
string sql_insert = "insert into BL_TJ_TJJGB0(SFYWID,TJH000,SQXMID,TZMS00,KSZD00,YXLJ00,JYYS00,SHYS00,JYRQ00,JYSJ00,SHRQ00,SHSJ00,JCXMLX,SFYX00)"
+ " values(" + jcxx.Rows[0]["F_BRBH"].ToString().Trim() + "," + jcxx.Rows[0]["F_mzh"].ToString().Trim() + "," + jcxx.Rows[0]["F_YZXM"].ToString().Trim().Split('^')[0] + ",'"
+ Res_char + "','" + Res_con + "','" + jpgpath + "','" + jcxx.Rows[0]["F_BGYS"].ToString().Trim() + "','" + jcxx.Rows[0]["F_shys"].ToString().Trim() + "','"
+ DateTime.Parse(jcxx.Rows[0]["F_BGRQ"].ToString().Trim()).ToString("yyyyMMdd") + "','" + DateTime.Parse(jcxx.Rows[0]["F_BGRQ"].ToString().Trim()).ToString("HH:mm:ss")
+ "','" + DateTime.Parse(jcxx.Rows[0]["F_SPARE5"].ToString().Trim()).ToString("yyyyMMdd") + "','" + DateTime.Parse(jcxx.Rows[0]["F_SPARE5"].ToString().Trim()).ToString("HH:mm:ss")
+ "','BL','0')";
string sql_del = "delete from BL_TJ_TJJGB0 where SFYWID=" + jcxx.Rows[0]["F_BRBH"].ToString().Trim() + " and TJH000=" + jcxx.Rows[0]["F_mzh"].ToString().Trim() + " and SQXMID="
+ jcxx.Rows[0]["F_YZXM"].ToString().Trim().Split('^')[0] + " and JCXMLX='BL'";
//删除
if (debug == "1")
{
log.WriteMyLog("删除体检表，语句：" + sql_del);
}
int x = db.ExecuteNonQuery(constr, sql_del, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("删除体检表：" + err_msg + "@" + x.ToString());
}
if (debug == "1")
{
log.WriteMyLog("回写体检表，语句：" + sql_insert);
}
//插入
x = db.ExecuteNonQuery(constr, sql_insert, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("回写体检表：" + err_msg + "@" + x.ToString());
}
if (x < 0)
{
ZgqClass.BGHJ(blh, "体检接口", "体检审核", "回写体检报告失败：" + err_msg, "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='回写体检报告失败：" + err_msg + "' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
log.WriteMyLog(blh + "-" + err_msg);
if (jkmsg == "1" || msg == "1")
{
MessageBox.Show("病理号：" + blh + "-回写体检报告失败，请重新审核！\r\n" + err_msg);
}
}
else
{
ZgqClass.BGHJ(blh, "体检接口", "体检审核", "回写体检报告成功", "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
aa.ExecuteSQL("update T_JCXX set F_TJBJ='2' where F_BLH='" + blh + "'");
if (jkmsg == "1")
{
MessageBox.Show("病理号：" + blh + "-回写体检报告成功");
}
}
return;
#endregion
}
else
{
if (bgzt == "取消审核")
{
//删除中间表
string str_sql = "delete from BL_TJ_TJJGB0 where SFYWID=" + jcxx.Rows[0]["F_BRBH"].ToString().Trim() + " and TJH000=" + jcxx.Rows[0]["F_mzh"].ToString().Trim() + " and SQXMID="
+ jcxx.Rows[0]["F_YZXM"].ToString().Trim().Split('^')[0] + " and JCXMLX='BL'";
if (debug == "1")
{
log.WriteMyLog("回写体检表，语句：" + str_sql);
}
int x = db.ExecuteNonQuery(constr, str_sql, ref err_msg);
if (x < 0)
{
ZgqClass.BGHJ(blh, "体检接口", "体检取消审核", "取消体检报告失败：" + err_msg, "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='取消体检报告失败：" + err_msg + "' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
log.WriteMyLog(blh + "-" + err_msg);
if (msg == "1")
{
MessageBox.Show("病理号：" + blh + "-取消体检报告失败！\r\n");
}
}
else
{
ZgqClass.BGHJ(blh, "体检接口", "体检取消审核", "取消体检报告成功", "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX_FS set F_BZ='',F_FSZT='已处理' where F_blh='" + blh + "' and F_BGLX='cg' and F_BGXH='0'");
aa.ExecuteSQL("update T_JCXX set F_TJBJ='1' where F_BLH='" + blh + "'");
}
//删除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中未能找到记录");
}
return;
}
return;
}
return;
# endregion
}
// 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 pathtoTJ(string blh, string bglx, string bgxh, DataTable jcxx, string debug)
{
////增加体检回写接口/////zgq
if (jcxx.Rows[0]["F_BRLB"].ToString().Trim() == "体检" && jcxx.Rows[0]["F_brbh"].ToString().Trim() == "体检")
{
// 生成pdf
string err_msg = "";
string constr = f.ReadString("savetohis", "tj_odbcsql", "Data Source=192.168.90.236;Initial Catalog=tj_xlms;User Id=xlmsuser;Password=topsky;");
SqlDB db = new SqlDB();
if (jcxx.Rows[0]["F_BGZT"].ToString().Trim() == "已审核")
{
string ML = DateTime.Parse(jcxx.Rows[0]["F_SDRQ"].ToString()).ToString("yyyyMM");
string jpgname = "";
string jpgpath = "";
//生成jpg
bool isrtn = MD_PDF_JPG(blh, bglx, bgxh, ML, ZgqPDFJPG.Type.JPG, ref err_msg, ref jpgname, ref jpgpath);
if (isrtn)
{
jpgname = jpgname.Substring(jpgname.LastIndexOf('\\') + 1);
ZgqClass.BGHJ(blh, "体检接口", "审核", "生成jpg成功:" + ML + "\\" + jpgname, "ZGQJK", "jpg");
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 + "','" + jpgpath + "','" + jpgname + "')");
}
else
{
log.WriteMyLog(blh + "-" + err_msg);
ZgqClass.BGHJ(blh, "体检接口", "审核", "生成jpg失败" + err_msg, "ZGQJK", "jpg");
if (debug == "1")
{
MessageBox.Show("病理号：" + blh + " 生成jpg失败，请重新审核！\r\n" + err_msg);
}
// return;
}
# region 回传体检报告
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().Contains("TCT"))
{
Res_char = Res_char + "标本满意度：" + TJ_bljc.Rows[0]["F_TBS_BBMYD"].ToString().Trim() + "\r\n";
Res_char = Res_char + 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" + TJ_bljc.Rows[0]["F_TBS_XBXM3"].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" + TJ_bljc.Rows[0]["F_TBS_WSW3"].ToString().Trim() + "\r\n" + TJ_bljc.Rows[0]["F_TBS_BDXM1"].ToString().Trim() + "\r\n";
Res_char = Res_char + "炎症程度：" + TJ_bljc.Rows[0]["F_TBS_YZCD"].ToString().Trim() + "\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 path = f.ReadString("savetohis", "jpgpath", @"\\192.10.33.84\pdfbg\");
jpgpath = path + jpgpath + "\\" + jpgname;
string sql_insert = "insert into tj_pacsjgb(Djlsh,Zhxmbh,jg,jcsj,Jl,shr,Shrq,Tpzt,jcqkfzsm,Tplj,czy,Sysdatetime,Jkid,flag)"
+ " values('" + jcxx.Rows[0]["F_MZH"].ToString().Trim() + "','" + jcxx.Rows[0]["F_YZID"].ToString().Trim() + "','"
+ Res_con + "','" + Res_char + "','','" + jcxx.Rows[0]["F_SHYS"].ToString().Trim() + "','"
+ jcxx.Rows[0]["F_spare5"].ToString().Trim() + "','1','病理检查','" + jpgpath + ";','" + jcxx.Rows[0]["F_bgYS"].ToString().Trim() + "','" + DateTime.Now + "',2,'0')";
string sql_del = "delete from tj_pacsjgb where Djlsh='" + jcxx.Rows[0]["F_MZH"].ToString().Trim() + "' and Zhxmbh='" + jcxx.Rows[0]["F_YZID"].ToString().Trim() + "' and jcqkfzsm='病理检查'";
//删除
if (debug == "1")
{
log.WriteMyLog("删除体检表，语句：" + sql_del);
}
int x = db.ExecuteNonQuery(constr, sql_del, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("删除体检表：" + err_msg + "@" + x.ToString());
}
if (debug == "1")
{
log.WriteMyLog("回写体检表，语句：" + sql_insert);
}
//插入
x = db.ExecuteNonQuery(constr, sql_insert, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("回写体检表：" + err_msg + "@" + x.ToString());
}
if (x < 0)
{
ZgqClass.BGHJ(blh, "体检接口", "审核", "回写体检报告失败：" + err_msg, "ZGQJK", "体检接口");
log.WriteMyLog(blh + "-" + err_msg);
if (debug == "1")
{
MessageBox.Show("病理号：" + blh + "-回写体检报告失败，请重新审核！\r\n" + err_msg);
}
}
else
{
ZgqClass.BGHJ(blh, "体检接口", "审核", "回写体检报告成功", "ZGQJK", "体检接口");
aa.ExecuteSQL("update T_JCXX set F_TJBJ='2' where F_BLH='" + blh + "'");
if (debug == "1")
{
MessageBox.Show("病理号：" + blh + "-回写体检报告成功");
}
}
return;
#endregion
}
else
{
if (jcxx.Rows[0]["F_TJBJ"].ToString().Trim() == "2")
{
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);
}
string sql_del = "delete from tj_pacsjgb where Djlsh='" + jcxx.Rows[0]["F_MZH"].ToString().Trim() + "' and Zhxmbh='" + jcxx.Rows[0]["F_YZID"].ToString().Trim() + "' and jcqkfzsm='病理检查'";
//删除
if (debug == "1")
{
log.WriteMyLog("删除体检表，语句：" + sql_del);
}
int x = db.ExecuteNonQuery(constr, sql_del, ref err_msg);
if (debug == "1")
{
log.WriteMyLog("删除体检表：" + err_msg + "@" + x.ToString());
}
return;
}
}
}