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