private void ChangeStatus(DataTable bljc, PathHISJK.ODBCHelper bb)
{
int resultnum = 3;
OdbcCommand cmd = bb.GetStoredProcCommond("{call Pro_Pacs_ReqStauts(?,?,?,?,?)}");
bb.AddInParameter(cmd, "@Exam_No", DbType.String, bljc.Rows[0]["F_SQXH"].ToString().Trim());
bb.AddInParameter(cmd, "@ID", DbType.String, bljc.Rows[0]["F_SQXH"].ToString().Trim());
bb.AddInParameter(cmd, "@StudyType", DbType.String, "GJ");
bb.AddInParameter(cmd, "@StudyState", DbType.Int32, 1);
bb.AddOutParameter(cmd, "@result", DbType.Int32, resultnum);
bb.ExecuteNonQuery(cmd);
resultnum = Convert.ToInt32(bb.GetParameter(cmd, "@result").Value);
switch (resultnum)
{
case 0:
log.WriteMyLog("回写成功！");
break;
case 1:
log.WriteMyLog("参数错误");
break;
case 2:
log.WriteMyLog("更新失败");
break;
default:
log.WriteMyLog("未知原因");
break;
}
}
private void SaveToHIS(DataTable bljc, PathHISJK.ODBCHelper bb)
{
string blh = bljc.Rows[0]["F_BLH"] == null ? "" : bljc.Rows[0]["F_BLH"].ToString().Trim();
string sqxh = bljc.Rows[0]["F_SQXH"] == null ? "" : bljc.Rows[0]["F_SQXH"].ToString().Trim();
string xm = bljc.Rows[0]["F_XM"] == null ? "" : bljc.Rows[0]["F_XM"].ToString().Trim();
string xb = bljc.Rows[0]["F_XB"] == null ? "" : bljc.Rows[0]["F_XB"].ToString().Trim();
string bbmc = bljc.Rows[0]["F_BBMC"] == null ? "" : bljc.Rows[0]["F_BBMC"].ToString().Trim();
string rysj = bljc.Rows[0]["F_RYSJ"] == null ? "" : bljc.Rows[0]["F_RYSJ"].ToString().Trim();
string blzd = bljc.Rows[0]["F_BLZD"] == null ? "" : bljc.Rows[0]["F_BLZD"].ToString().Trim();
string bgys = bljc.Rows[0]["F_BGYS"] == null ? "" : bljc.Rows[0]["F_BGYS"].ToString().Trim();
string shys = bljc.Rows[0]["F_SHYS"] == null ? "" : bljc.Rows[0]["F_SHYS"].ToString().Trim();
string bgrq = bljc.Rows[0]["F_BGRQ"] == null ? "" : bljc.Rows[0]["F_BGRQ"].ToString().Trim();
mdjpg xx = new mdjpg();
string bglj = "";
xx.BMPTOJPG(blh, ref bglj, "CG", "0");
string ftpserver = f.ReadString("hisftp", "ftpip", "").Replace("\0", "");
string ftpuser = f.ReadString("hisftp", "user", "ZKFTP").Replace("\0", "");
string ftppwd = f.ReadString("hisftp", "pwd", "ZKFTP").Replace("\0", "");
string txpath = f.ReadString("hisftp", "txpath", "PACSDATA").Replace("\0", "");
string ftppath = Path.Combine(ftpserver, txpath);
if (bglj != "")
{
FtpWeb fw = new FtpWeb(ftpserver, txpath, ftpuser, ftppwd);
string status = "";
fw.Upload(@"C:\temp\" + blh + @"\" + blh + @"_1.jpg", "", out status);
string insertsql = string.Format("insert into dbo.T_SYN_ZK_CHECK(PACS_CheckID,CISID,PatientNameChinese,PatientSex,PatientBirthday,StudyType,StudyBodyPart,ClinicDiagnose,ClinicSymptom,ClinicAdvice,IMGStrings,StudyState,Check_Doc,Check_Date,Report_Doc,Report_Date,Audit_Doc,Audit_Date) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')", blh, sqxh, xm, xb, "", "GJ", bbmc, blzd, rysj, "", blh + @"_1.jpg", 5, "", "", bgys, bgrq, shys, bgrq);
OdbcCommand cmd = bb.GetOdbcStringCommond(insertsql);
if (msg == "1")
{
MessageBox.Show(cmd.Connection.ConnectionString);
}
bb.ExecuteNonQuery(cmd);
}
}