public void GetYZMX(string sqdh)
{
SqlParameter[] sqlPt = new SqlParameter[1];
for (int j = 0; j < sqlPt.Length; j++)
{
sqlPt[j] = new SqlParameter();
}
//申请单号
sqlPt[0].ParameterName = "In_FunctionRequestIDs";
sqlPt[0].SqlDbType = SqlDbType.NVarChar;
sqlPt[0].Size = 100;
sqlPt[0].Direction = ParameterDirection.Input;
sqlPt[0].Value = sqdh;
DataTable dt_yzmx = new DataTable();
SqlDB_ZGQ db = new SqlDB_ZGQ();
string err_msg = "";
dt_yzmx = db.Sql_DataAdapter(odbc, "pGetFunctionRequestListForPathNet", ref sqlPt, CommandType.StoredProcedure, ref err_msg);
if (dt_yzmx == null)
{
return;
}
dataGridView2.DataSource = dt_yzmx;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView2.Columns[0].HeaderText = "申请单号";
dataGridView2.Columns[1].HeaderText = "项目ID";
dataGridView2.Columns[2].HeaderText = "项目名称";
}
private static double get_je(string odbcsql, string brlb, string sqdh, string debug)
{
SqlDB_ZGQ db = new SqlDB_ZGQ();
SqlParameter[] Parameters = new SqlParameter[2];
for (int j = 0; j < Parameters.Length; j++)
{
Parameters[j] = new SqlParameter();
}
Parameters[0].ParameterName = "sqdh";
Parameters[0].SqlDbType = SqlDbType.VarChar;
Parameters[0].Direction = ParameterDirection.Input;
Parameters[0].Value = sqdh.Trim();
Parameters[1].ParameterName = "return";
Parameters[1].SqlDbType = SqlDbType.Int;
Parameters[1].Direction = ParameterDirection.Output;
string except = "";
DataTable dt = new DataTable();
if (brlb.Trim() == "住院")
{
dt = db.Sql_DataAdapter(odbcsql, "p_pa_zysfxx", ref Parameters, CommandType.StoredProcedure, ref except);
}
else
{
dt = db.Sql_DataAdapter(odbcsql, "p_pa_mzsfxx", ref Parameters, CommandType.StoredProcedure, ref except);
}
if (dt == null)
{
if (debug == "1")
{
MessageBox.Show("费用获取失败:获取数据失败\r\n" + except);
}
return(0);
}
if (dt.Rows.Count <= 0)
{
if (debug == "1")
{
MessageBox.Show("费用获取失败:返回行数为0\r\n" + except);
}
return(0);
}
try
{
if (int.Parse(Parameters[1].Value.ToString()) < 0)
{
if (debug == "1")
{
MessageBox.Show("费用获取失败:" + Parameters[4].Value);
}
log.WriteMyLog("费用获取失败:" + Parameters[4].Value);
return(0);
}
double je = 0;
for (int x = 0; x < dt.Rows.Count; x++)
{
je = double.Parse(dt.Rows[x]["je"].ToString().Trim()) + je;
}
return(je);
}
catch (Exception ee1)
{
if (debug == "1")
{
MessageBox.Show("费用获取异常:" + ee1.Message);
}
log.WriteMyLog("费用获取异常:" + ee1.Message);
return(0);
}
}
public static string ptxml(string Sslbx, string Ssbz, string Debug)
{
SqlDB_ZGQ db = new SqlDB_ZGQ();
if (Sslbx != "")
{
string exp = "";
if (Sslbx == "门诊退费")
{
string odbcsql = f.ReadString(Sslbx, "odbcsql", "Data Source=172.16.10.1;Initial Catalog=xsylzx;User Id=xrh;Password=xsrmyy18;");
string yhmc = f.ReadString("yh", "yhmc", "").Replace("\0", "").Trim();
string yhbh = f.ReadString("yh", "yhbh", "").Replace("\0", "").Trim();
dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", "");
DataTable bljc = new DataTable();
bljc = aa.GetDataTable("select * from T_jcxx where F_blh='" + Ssbz + "'", "bljc");
if (bljc == null)
{
MessageBox.Show("病理号：" + Ssbz + ",病理数据库设置有问题！");
return("0");
}
if (bljc.Rows.Count < 1)
{
MessageBox.Show("病理号：" + Ssbz + ",病理号有错误！");
return("0");
}
if (bljc.Rows[0]["F_SQXH"].ToString().Trim() == "")
{
MessageBox.Show("申请序号为空，不能取消退费");
return("0");
}
if (bljc.Rows[0]["F_brlb"].ToString().Trim() == "门诊")
{
MessageBox.Show("非门诊病人,不能取消退费");
return("0");
}
if (bljc.Rows[0]["F_mzqf"].ToString().Trim() != "1")
{
MessageBox.Show("未确费或非本系统确费，不能取消退费");
return("0");
}
if (bljc.Rows[0]["F_brlb"].ToString().Trim() == "门诊" && bljc.Rows[0]["F_mzqf"].ToString().Trim() != "1")
{
SqlParameter[] Parameters = new SqlParameter[5];
for (int j = 0; j < Parameters.Length; j++)
{
Parameters[j] = new SqlParameter();
}
Parameters[0].ParameterName = "sqdh";
Parameters[0].SqlDbType = SqlDbType.VarChar;
Parameters[0].Direction = ParameterDirection.Input;
Parameters[0].Value = bljc.Rows[0]["F_SQXH"].ToString().Trim();
Parameters[1].ParameterName = "czgh";
Parameters[1].SqlDbType = SqlDbType.VarChar;
Parameters[1].Direction = ParameterDirection.Input;
Parameters[1].Value = yhbh;
Parameters[2].ParameterName = "bz";
Parameters[2].SqlDbType = SqlDbType.Int;
Parameters[2].Direction = ParameterDirection.Input;
Parameters[2].Value = 9;
Parameters[3].ParameterName = "zxysh";
Parameters[3].SqlDbType = SqlDbType.VarChar;
Parameters[3].Direction = ParameterDirection.Input;
Parameters[3].Value = yhmc;
Parameters[4].ParameterName = "return";
Parameters[4].SqlDbType = SqlDbType.Int;
Parameters[4].Direction = ParameterDirection.ReturnValue;
string except = "";
db.Sql_ExecuteNonQuery(odbcsql, "p_yjqr", ref Parameters, CommandType.StoredProcedure, ref except);
if (except != "")
{
MessageBox.Show("连接数据库失败，门诊病人退费失败");
}
else
{
try
{
if (int.Parse(Parameters[4].Value.ToString()) < 0)
{
MessageBox.Show("门诊病人退费失败:" + Parameters[4].Value);
}
else
{
aa.ExecuteSQL("update T_JCXX set F_MZQF='0' where F_BLH='" + Ssbz + "'");
MessageBox.Show("门诊病人退费成功");
}
}
catch (Exception ee1)
{
MessageBox.Show("门诊退费异常：" + ee1.Message);
}
}
return("0");
}
return("0");
}
if (Sslbx == "申请单号" || Sslbx == "标本条码号")
{
string sqxh = Ssbz.Trim();
if (Sslbx == "标本条码号")
{
sqxh = Ssbz.Trim().Split('_')[0].Trim();
}
string odbcsql = f.ReadString(Sslbx, "odbcsql", "Data Source=172.16.10.1;Initial Catalog=xsylzx;User Id=xrh;Password=xsrmyy18;");
string tqbblb = f.ReadString(Sslbx, "tqbblb", "0");
string debug = f.ReadString(Sslbx, "debug", "0");
string djr = f.ReadString("yh", "yhmc", "").Replace("\0", "").Trim();
string sqlstr = "select * from dbo.V_pa_apply WHERE apply_id= '" + sqxh.Trim() + "'";
DataTable dt_SQD = new DataTable();
string exp_db = "";
dt_SQD = db.Sql_DataAdapter(odbcsql, sqlstr, ref exp_db);
if (exp_db.Trim() != "")
{
MessageBox.Show("连接HIS数据库异常：" + exp_db);
}
if (dt_SQD == null)
{
MessageBox.Show("未查询到此条码号记录！");
return("0");
}
if (dt_SQD.Rows.Count <= 0)
{
MessageBox.Show("未查询到此申请序号记录！");
return("0");
}
//取收费je
//-返回xml----------------------------------------------------
try
{
string xml = "<?xml version=" + (char)34 + "1.0" + (char)34 + " encoding=" + (char)34 + "gbk" + (char)34 + "?>";
xml = xml + "<LOGENE>";
xml = xml + "<row ";
try
{
xml = xml + "病人编号=" + (char)34 + dt_SQD.Rows[0]["PATIENT_ID"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "病人编号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
xml = xml + "就诊ID=" + (char)34 + "" + (char)34 + " ";
//----------------------------------------------------------
try
{
xml = xml + "申请序号=" + (char)34 + dt_SQD.Rows[0]["APPLY_ID"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "申请序号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "门诊号=" + (char)34 + dt_SQD.Rows[0]["INPATIENT_NO"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "住院号=" + (char)34 + dt_SQD.Rows[0]["PATIENT_NO"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "住院号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "姓名=" + (char)34 + dt_SQD.Rows[0]["PATIENT_NAME"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "姓名=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "性别=" + (char)34 + dt_SQD.Rows[0]["SEX"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "性别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "年龄=" + (char)34 + dt_SQD.Rows[0]["AGE"].ToString().Trim() + "岁" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "年龄=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "婚姻=" + (char)34 + dt_SQD.Rows[0]["HY"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "地址=" + (char)34 + dt_SQD.Rows[0]["ADDRESS"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "地址=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "电话=" + (char)34 + dt_SQD.Rows[0]["TELPHONE"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "电话=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病区=" + (char)34 + dt_SQD.Rows[0]["PATIENT_DEPT"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "病区=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "床号=" + (char)34 + dt_SQD.Rows[0]["PATIENT_BED"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "床号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "身份证号=" + (char)34 + dt_SQD.Rows[0]["SFZH"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "身份证号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "民族=" + (char)34 + dt_SQD.Rows[0]["MZ"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "民族=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "职业=" + (char)34 + dt_SQD.Rows[0]["ZY"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "职业=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检科室=" + (char)34 + dt_SQD.Rows[0]["APPLY_DEPT_NAME"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "送检科室=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检医生=" + (char)34 + dt_SQD.Rows[0]["APPLY_DOCTOR_NAME"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "送检医生=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
double je = 0;
string brlb = dt_SQD.Rows[0]["PATIENT_TYPE"].ToString().Trim();
if (brlb == "门诊" || brlb == "住院")
{
je = get_je(odbcsql, brlb, dt_SQD.Rows[0]["APPLY_ID"].ToString().Trim(), debug);
}
xml = xml + "收费=" + (char)34 + je.ToString() + (char)34 + " ";
//----------------------------------------------------------
///////////////////////////
string BBLB_XML = "";
if (tqbblb == "1")
{
string sqlstr_mx = "select * from dbo.V_pa_apply_mx WHERE APPLY_ID= '" + sqxh.Trim() + "'";
DataTable dt_SQD_MX = new DataTable();
string exp_db_mx = "";
dt_SQD_MX = db.Sql_DataAdapter(odbcsql, sqlstr_mx, ref exp_db_mx);
if (exp_db_mx.Trim() != "")
{
MessageBox.Show("连接HIS数据库异常：" + exp_db_mx);
}
else
{
if (dt_SQD_MX == null)
{
MessageBox.Show("未查询到此条码号记录！");
}
else
{
if (dt_SQD_MX.Rows.Count <= 0)
{
MessageBox.Show("未查询到此申请序号记录！");
}
else
{
BBLB_XML = "<BBLB>";
try
{
for (int x = 0; x < dt_SQD_MX.Rows.Count; x++)
{
try
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + dt_SQD_MX.Rows[x]["BBXH"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + dt_SQD_MX.Rows[x]["APPLY_BARCODE"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD_MX.Rows[x]["BBMC"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD_MX.Rows[x]["BWMC"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD_MX.Rows[x]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD_MX.Rows[x]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
catch (Exception eee)
{
MessageBox.Show("获取标本列表信息异常：" + eee.Message);
tqbblb = "0";
break;
}
}
}
catch (Exception e3)
{
MessageBox.Show("获取标本名称异常：" + e3.Message);
tqbblb = "0";
}
BBLB_XML = BBLB_XML + "</BBLB>";
}
}
}
}
xml = xml + "标本名称=" + (char)34 + dt_SQD.Rows[0]["BBMC"].ToString().Trim() + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "送检医院=" + (char)34 + "本院" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "医嘱项目=" + (char)34 + dt_SQD.Rows[0]["ORDER_NAME"].ToString().Trim() + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "备用1=" + (char)34 + (char)34 + " ";
//----------------------------------------------------------
try
{
xml = xml + "备用2=" + (char)34 + DateTime.Parse(dt_SQD.Rows[0]["csrq"].ToString().Trim()).ToString("yyyy-MM-dd") + (char)34 + " ";
}
catch (Exception ee4)
{
log.WriteMyLog(ee4.Message);
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "费别=" + (char)34 + dt_SQD.Rows[0]["FEE_CLASS"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "费别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病人类别=" + (char)34 + brlb + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "病人类别=" + (char)34 + "" + (char)34 + " ";
}
xml = xml + "/>";
//----------------------------------------------------------
try
{
xml = xml + "<临床病史><![CDATA[" + "" + "]]></临床病史>";//.Replace("\"", """)
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "<临床病史><![CDATA[" + "" + "]]></临床病史>";
}
//----------------------------------------------------------
try
{
xml = xml + "<临床诊断><![CDATA[" + dt_SQD.Rows[0]["DIAGNOSIS"].ToString().Trim() + "]]></临床诊断>";
}
catch (Exception ee)
{
exp = exp + ee.Message.ToString();
xml = xml + "<临床诊断><![CDATA[" + "" + "]]></临床诊断>";
}
if (tqbblb == "1")
{
xml = xml + BBLB_XML;
}
xml = xml + "</LOGENE>";
if (Debug == "1" && exp.Trim() != "")
{
log.WriteMyLog(exp.Trim());
}
return(xml);
}
catch (Exception e)
{
MessageBox.Show("提取信息出错，请重新操作");
log.WriteMyLog("xml解析错误---" + e.Message);
return("0");
}
}
else
{
MessageBox.Show("无此" + Sslbx);
return("0");
}
}
return("0");
}
public string ca(string yhxx)
{
bool yzpassword = false;
dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", "");
//-------获取sz中设置的参数---------------------
string debug = f.ReadString("CA", "debug", "");
string msg = f.ReadString("CA", "message", "1");
string ftpServerIP = f.ReadString("ftp", "ftpip", "");
string ftpUserID = f.ReadString("ftp", "user", "");
string ftpPassword = f.ReadString("ftp", "pwd", "");
string ftpszqmbmp = f.ReadString("ftp", "szqmbmp", "pathsetup/pathqc/rpt-szqm/ysbmp");
string IP = f.ReadString("CA", "IP", "192.1.33.143:7000").Trim();
string yzzsyxx = f.ReadString("CA", "yzzsyxx", "0").Trim();
string ServerIP = f.ReadString("sqlserver", "Server", "192.10.33.84");
string sqlcon = "Server=192.10.33.84;Database=pathnet_ca;User ID=pathnet;Password=4s3c2a1p;Trusted_Connection=False;";
string getblh = "";
string type = "";
string type2 = "";
string yhm = "";
string yhmc = "";
string yhbh = "";
string yhmm = "";
string bglx = "";
string bgxh = "";
string keyname = "";
string[] getyhxx = yhxx.Split('^');
if (getyhxx.Length == 5)
{
type = getyhxx[0];
yhm = getyhxx[1];
yhmc = getyhxx[3];
yhbh = getyhxx[2];
yhmm = getyhxx[4];
}
else
{
type2 = getyhxx[0];
getblh = getyhxx[1];
bgxh = getyhxx[2];
bglx = getyhxx[3].ToLower();
type = getyhxx[4];
yhm = getyhxx[5];
yhmc = getyhxx[6];
yhbh = getyhxx[7];
yhmm = getyhxx[8];
}
string password = string.Empty;
//string KEY_sbDeviceInfo = f.ReadString("CA_KEY", "sbDeviceInfo", "").Trim();
//string KEY_userName = f.ReadString("CA_KEY", "userName", "").Trim();
//password = f.ReadString("CA_KEY", "pwd", "").Trim();
//if (key == "0")
//{
// return "1";
//}
//------------------------------------------------------------------
//------------------------------------------------------------------
//审核前执行 ,验证KEY
//------------------------------------------------------------------
//------------------------------------------------------------------
if (type == "SH")
{
//if (!axSBFjCAEnAndSign1.OpenFJCAUSBKey())
//{
// axSBFjCAEnAndSign1.CloseUSBKey();
// return;
//}
//axSBFjCAEnAndSign1.CloseUSBKey();
//读取Key的硬件介质号
//if (debug == "1")
// MessageBox.Show("读取Key的硬件介质号");
//StringBuilder sbDeviceInfo = new StringBuilder(256);
//if (GetDeviceInfoOnUsbKey(sbDeviceInfo) == 0)
//{
// if (msg=="1")
// MessageBox.Show("读取Key的硬件介质号失败，请确认Key已经插入电脑。");
//return "0";
//}
//if (debug == "1")
// MessageBox.Show("读取Key的硬件介质号:" + sbDeviceInfo.ToString());
// yzpassword = false;
// if (sbDeviceInfo.ToString() == KEY_sbDeviceInfo)
// {
// if (password != "")
// yzpassword = true;
// }
// bool savepwd=true;
//yzmm:
// if (!yzpassword)
// {
// Frm_XMZSYY_Login login = new Frm_XMZSYY_Login();
// if (login.ShowDialog() != DialogResult.Yes)
// {
// if (msg == "1")
// MessageBox.Show("用户登录取消,验证失败");
// return "0";
// }
// password = login.password;
// savepwd=login.savepwd;
// if (password == string.Empty)
// {
// if (msg == "1")
// MessageBox.Show("密码输入错误,不能为空");
// return "0";
// }
// }
if (debug == "1")
{
MessageBox.Show("打开Key");
}
//打开Key
if (OpenUsbKey("") == 0)
{
//if (MessageBox.Show("打开Key失败,可能密码输入错误\r\n是否重试", "密码验证", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
//{
// yzpassword = false;
// goto yzmm;
//}
//else
if (msg == "1")
{
MessageBox.Show("打开Key失败,Key未插入或密码输入错误");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("打开Key成功");
}
//if (savepwd)
//{
// f.WriteString("CA_KEY", "sbDeviceInfo", sbDeviceInfo.ToString());
// // f.WriteString("CA_KEY", "userName", KEY_YH);
// f.WriteString("CA_KEY", "pwd", password);
//}
//else
//{
// f.WriteString("CA_KEY", "sbDeviceInfo", "");
// // f.WriteString("CA_KEY", "userName", KEY_YH);
// f.WriteString("CA_KEY", "pwd", "");
//}
if (debug == "1")
{
MessageBox.Show("获取签名证书");
}
//获取签名证书
StringBuilder sbSignCert = new StringBuilder(4096);
if (GetSignCertOnUsbKey(sbSignCert) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("获取签名证书失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("证书：" + sbSignCert.ToString());
}
//sfzh
StringBuilder sbInfo = new StringBuilder(1024);
GetCertExtensionInfoById(sbSignCert.ToString(), "1.2.86.21.1.1", sbInfo);
string KEY_SFZH = sbInfo.ToString().Substring(9, sbInfo.Length - 9);
if (debug == "1")
{
MessageBox.Show("身份证号：" + KEY_SFZH);
}
// 证书有效性验证通过，展示证书信息。
StringBuilder sbCertName = new StringBuilder(1024);
if (GetCertName(sbSignCert.ToString(), sbCertName) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("获取签名证书失败");
}
return("0");
}
string KEY_YH = sbCertName.ToString();
if (debug == "1")
{
MessageBox.Show("KEY用户：" + KEY_YH);
}
//关闭Key
CloseUsbKey();
//验证用户名
if (yhmc.Trim() != KEY_YH)
{
if (msg == "1")
{
MessageBox.Show("软件使用者与KEY用户不一致,验证失败！");
}
return("0");
}
if (yhbh.Trim() != KEY_SFZH)
{
if (msg == "1")
{
MessageBox.Show("用户身份证号与KEY中身份证号不一致,验证失败！");
}
return("0");
}
if (yzzsyxx == "1")
{
if (debug == "1")
{
MessageBox.Show("获取随机数");
}
//// 获取随机数
StringBuilder sbRandom = new StringBuilder(64);
if (GetRandomByLengthOnMultiServer(IP, 32, sbRandom) == 0 || sbRandom.ToString().Length <= 0 || sbRandom.ToString() == string.Empty)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("从服务器获取随机数失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("获取随机数完成");
}
//签名SignDataOnUsbKey
StringBuilder sbSignData = new StringBuilder(4096);
if (SignDataOnUsbKey(sbRandom.ToString(), sbSignData) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("签名失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("签名完成");
}
// 验证证书有效性
if (LoginAuthenticationOnMultiServer(IP, sbSignData.ToString(), sbSignCert.ToString(), sbRandom.ToString()) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("连接服务器验证证书有效性失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("验证证书有效性完成");
}
}
if (debug == "1")
{
MessageBox.Show("验证通过");
}
return("1");
}
//***************************************************************
////审核后执行，数字签名，生成pdf和edu文件，并上传，写数据库等
if (type == "QZ")
{
//***************************************************************
if (debug == "1")
{
MessageBox.Show("审核签字");
}
string origindata = "";
DataTable dt_jcxx = new DataTable();
dt_jcxx = aa.GetDataTable("select * from T_JCXX where F_BLH='" + getblh + "'", "cgbg");
if (dt_jcxx == null)
{
if (msg == "1")
{
MessageBox.Show("连接数据库异常");
}
return("0");
}
if (dt_jcxx.Rows.Count <= 0)
{
if (msg == "1")
{
MessageBox.Show("T_JCXX查询数据异常");
}
return("0");
}
string shys = dt_jcxx.Rows[0]["F_shys"].ToString();
string spare5 = dt_jcxx.Rows[0]["F_spare5"].ToString();
if (bglx == "cg")
{
if (dt_jcxx.Rows[0]["F_BGZT"].ToString() != "已审核")
{
if (msg == "1")
{
MessageBox.Show("报告未审核");
}
return("0");
}
origindata = "病理号：" + dt_jcxx.Rows[0]["f_blh"].ToString() + "&报告类型：常规报告&报告序号：" + bgxh + "&&性别：" + dt_jcxx.Rows[0]["F_XB"].ToString() + "&年龄：" + dt_jcxx.Rows[0]["F_nl"].ToString()
+ "&住院号：" + dt_jcxx.Rows[0]["F_zyh"].ToString() + "&门诊号：" + dt_jcxx.Rows[0]["F_mzh"].ToString() + "&科室：" + dt_jcxx.Rows[0]["F_sjks"].ToString()
+ "&病理诊断：" + dt_jcxx.Rows[0]["F_blzd"].ToString() + "&报告医生：" + dt_jcxx.Rows[0]["F_bgys"].ToString() + "&复诊医生：" + dt_jcxx.Rows[0]["F_FZYS"].ToString()
+ "&审核医生：" + dt_jcxx.Rows[0]["F_SHYS"].ToString() + "&报告日期：" + dt_jcxx.Rows[0]["F_bgrq"].ToString() + "&审核日期：" + dt_jcxx.Rows[0]["F_spare5"].ToString();
}
//补充审核
if (bglx == "bc")
{
DataTable dt_bc = new DataTable();
dt_bc = aa.GetDataTable("select * from T_BCBG where F_BLH='" + getblh + "' and F_BC_BGZT='已审核'and F_BC_BGXH='" + bgxh + "'", "bcbg");
if (dt_bc == null)
{
if (msg == "1")
{
MessageBox.Show("连接数据库异常");
}
return("0");
}
if (dt_bc.Rows.Count <= 0)
{
if (msg == "1")
{
MessageBox.Show("T_BCBG查询数据异常");
}
return("0");
}
origindata = "病理号：" + dt_jcxx.Rows[0]["f_blh"].ToString() + "&报告类型：补充报告&报告序号：" + bgxh + "&性别：" + dt_jcxx.Rows[0]["F_XB"].ToString() + "&年龄：" + dt_jcxx.Rows[0]["F_nl"].ToString()
+ "&住院号：" + dt_jcxx.Rows[0]["F_zyh"].ToString() + "&门诊号：" + dt_jcxx.Rows[0]["F_mzh"].ToString() + "&科室：" + dt_jcxx.Rows[0]["F_sjks"].ToString()
+ "&病理诊断：" + dt_bc.Rows[0]["F_BCZD"].ToString() + "&报告医生：" + dt_bc.Rows[0]["F_bc_bgys"].ToString() + "&复诊医生：" + dt_bc.Rows[0]["F_bc_FZYS"].ToString()
+ "&审核医生：" + dt_bc.Rows[0]["F_bc_SHYS"].ToString() + "&报告日期：" + dt_bc.Rows[0]["F_bc_bgrq"].ToString() + "&审核日期：" + dt_bc.Rows[0]["F_bc_spare5"].ToString();
shys = dt_bc.Rows[0]["F_bc_shys"].ToString();
spare5 = dt_bc.Rows[0]["F_bc_spare5"].ToString();
}
//小冰冻审核
if (bglx == "bd")
{
DataTable dt_bd = new DataTable();
dt_bd = aa.GetDataTable("select * from T_BDBG where F_BLH='" + getblh + "' and F_BD_BGZT='已审核' and F_BD_BGXH='" + bgxh + "'", "bcbg");
if (dt_bd == null)
{
if (msg == "1")
{
MessageBox.Show("连接数据库异常");
}
return("0");
}
if (dt_bd.Rows.Count <= 0)
{
if (msg == "1")
{
MessageBox.Show("T_BDBG查询数据异常");
}
return("0");
}
origindata = "病理号：" + dt_jcxx.Rows[0]["f_blh"].ToString() + "&报告类型：冰冻报告&报告序号：" + bgxh + "&性别：" + dt_jcxx.Rows[0]["F_XB"].ToString() + "&年龄：" + dt_jcxx.Rows[0]["F_nl"].ToString()
+ "&住院号：" + dt_jcxx.Rows[0]["F_zyh"].ToString() + "&门诊号：" + dt_jcxx.Rows[0]["F_mzh"].ToString() + "&科室：" + dt_jcxx.Rows[0]["F_sjks"].ToString()
+ "&病理诊断：" + dt_bd.Rows[0]["F_BdZD"].ToString() + "&报告医生：" + dt_bd.Rows[0]["F_bd_bgys"].ToString() + "&复诊医生：" + dt_bd.Rows[0]["F_fz_FZYS"].ToString()
+ "&审核医生：" + dt_bd.Rows[0]["F_bd_SHYS"].ToString() + "&报告日期：" + dt_bd.Rows[0]["F_bd_bgrq"].ToString();
shys = dt_bd.Rows[0]["F_bd_shys"].ToString();
spare5 = dt_bd.Rows[0]["F_bd_bgrq"].ToString();
}
if (origindata.Trim() == "")
{
if (msg == "1")
{
MessageBox.Show("数字签名内容为空");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("打开key");
}
if (OpenUsbKey("") == 0)
{
if (msg == "1")
{
MessageBox.Show("打开Key失败,签名失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("打开key完成");
}
//获取签名证书
StringBuilder sbSignCert = new StringBuilder(4096);
if (GetSignCertOnUsbKey(sbSignCert) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("获取签名证书失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("获取签名证书完成");
}
StringBuilder sbSignData = new StringBuilder(4096);
if (SignDataOnUsbKey(origindata, sbSignData) == 0)
{
CloseUsbKey();
if (msg == "1")
{
MessageBox.Show("签名失败");
}
return("0");
}
if (debug == "1")
{
MessageBox.Show("签名完成");
}
SqlDB_ZGQ sqldb = new SqlDB_ZGQ();
string errmsg = "";
int x = sqldb.Sql_ExecuteNonQuery(sqlcon, "insert into T_CAXX(F_BLH,F_BGLX,F_BGXH,F_SHYS,F_SPARE5,F_CZY,F_QZNR,F_SignCert,F_SignData) values('" + getblh + "','" + bglx + "','" + bgxh
+ "','" + shys + "','" + spare5 + "','" + yhmc + "','" + origindata + "','" + sbSignCert.ToString() + "','" + sbSignData.ToString() + "')", ref errmsg);
if (debug == "1")
{
if (x >= 1)
{
MessageBox.Show("写入T_CAXX完成");
}
else
{
MessageBox.Show("写入T_CAXX失败：" + errmsg);
}
}
string szqmlj = getSZ_String("view", "szqmlj", @"\\192.10.33.84\pathqc\rpt-szqm\YSBMP\");
if (!File.Exists(szqmlj + yhmc + ".bmp"))
{
DataTable dt_ca = new DataTable();
dt_ca = sqldb.Sql_DataAdapter(sqlcon, "select TOP 1 * from t_userInfo where IdCardNumber='" + yhbh.Trim() + "'", ref errmsg);
if (dt_ca == null)
{
if (msg == "1")
{
MessageBox.Show("连接数据库pathnet_CA异常");
}
return("0");
}
if (dt_ca.Rows.Count <= 0)
{
MessageBox.Show("未能查询到用户(" + yhmc + ")的签名图片");
return("0");
}
if (debug == "1")
{
MessageBox.Show("查询t_userInfo完成");
}
try
{
byte[] MyData = new byte[0];
MyData = (byte[])dt_ca.Rows[0]["Image"]; //读取图片的位流
int ArraySize = MyData.GetUpperBound(0); //获得数据库中存储的位流数组的维度上限，用作读取流的上限
FileStream fs = new FileStream(@"c:\temp\" + yhmc + ".jpg", FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(MyData, 0, ArraySize);
fs.Close();
Bitmap source = new Bitmap(@"c:\temp\" + yhmc + ".jpg");
Bitmap bmp = new Bitmap(source.Width, source.Height, System.Drawing.Imaging.PixelFormat.Format24bppRgb);
Graphics.FromImage(bmp).DrawImage(source, new Rectangle(0, 0, bmp.Width, bmp.Height));
bmp.Save(szqmlj + yhmc + ".bmp", System.Drawing.Imaging.ImageFormat.Bmp);
if (szqmlj.Substring(0, 2) != "//")
{
ZgqFtpWeb.FtpUpload(ftpUserID, ftpPassword, ftpServerIP, szqmlj + yhmc + ".bmp", ftpszqmbmp, ref errmsg);
}
bmp.Save(szqmlj + yhmc + ".bmp", System.Drawing.Imaging.ImageFormat.Bmp);
//File.Copy(@"c:\temp\" + yhmc + ".jpg", szqmlj + yhmc + ".jpg");
}
catch (Exception e3)
{
MessageBox.Show(e3.Message);
return("0");
}
if (debug == "1")
{
MessageBox.Show("上传签字图片完成");
}
}
if (debug == "1")
{
MessageBox.Show("签字完成");
}
return("1");
}
//***************************************************************
//////取消审核前
if (type == "QXSH")
{
return("1");
}
//***************************************************************
//------------------------------------------------------------------
//------------------------------------------------------------------
//////取消审核后 ,同时删除数据库ca记录
//------------------------------------------------------------------
//------------------------------------------------------------------
if (type == "QXQZ") //&& (bglx == "BC" || bglx == "BD")
{
SqlDB_ZGQ sqldb = new SqlDB_ZGQ();
string errmsg = "";
sqldb.Sql_ExecuteNonQuery(sqlcon, "delete from T_CAXX where F_BLH='" + getblh + "' and F_BGLX='" + bglx + "' and F_BGXH='" + bgxh + "'", ref errmsg);
return("1");
}
return("1");
}
private void button1_Click(object sender, EventArgs e)
{
string conStr = f.ReadString("病理医嘱列表", "BLODBC", "Data Source=172.16.95.230;Initial Catalog=pathnet;User Id=pathnet;Password=4s3c2a1p");
string sqlstr = f.ReadString("病理医嘱列表", "sqlstr", "select top 10000 F_ZYH as 住院号,F_BRLB as 病人类别, F_XM as 姓名, F_XB as 性别, F_NL as 年龄,F_BLH as 病理号,F_LKH as 蜡块号,F_BJW as 医嘱项目,F_BZ as 备注,F_YZZT as 医嘱状态,F_SQYS as 申请医生,F_SQSJ as 申请日期,F_ZXR as 执行人,F_ZXSJ as 执行时间,F_TJYZH as 医嘱号,F_BRBH as 病人编号,F_LCZD as 临床诊断,F_LXXX as 联系信息,F_SFZH as 身份证号,F_BQ as 病区,F_CH as 床号,F_HY as 婚姻,F_SJDW as 送检单位 FROM V_TJYZ_TO_FZ ");
SqlDB_ZGQ sql = new SqlDB_ZGQ();
sqlstr = sqlstr + " where F_SQSJ>='" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "' and F_SQSJ<'" + dateTimePicker2.Value.AddDays(1).ToString("yyyy-MM-dd") + "' ";
if (txtxm.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_XM='" + txtxm.Text.Trim() + "'";
}
if (txtblh.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_BLH='" + txtblh.Text.Trim() + "'";
}
if (txtzyh.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_ZYH='" + txtzyh.Text.Trim() + "'";
}
if (txtmzh.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_MZH='" + txtmzh.Text.Trim() + "'";
}
if (txtsqys.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_SQYS='" + txtsqys.Text.Trim() + "'";
}
if (txtzxr.Text.Trim() != "")
{
sqlstr = sqlstr + " and F_ZXR='" + txtzxr.Text.Trim() + "'";
}
if (comboBox1.Text.Trim() != "全部")
{
if (comboBox1.Text.Trim() == "未执行")
{
sqlstr = sqlstr + " and F_YZZT=' '";
}
else
{
sqlstr = sqlstr + " and F_YZZT='" + comboBox1.Text.Trim() + "'";
}
}
string errMsg = "";
sqlstr = sqlstr + " order by F_SQSJ desc";
dt = sql.Sql_DataAdapter(conStr, sqlstr, ref errMsg);
if (errMsg != "")
{
MessageBox.Show(errMsg); return;
}
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
groupBox1.Text = "查询结果:" + dt.Rows.Count.ToString();
if (dt.Rows.Count <= 0)
{
MessageBox.Show("未查询到相关记录");
}
else
{
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 100;
dataGridView1.Columns[1].Width = 50;
dataGridView1.Columns[2].Width = 70;
dataGridView1.Columns[3].Width = 30;
dataGridView1.Columns[4].Width = 45;
dataGridView1.Columns[5].Width = 80;
dataGridView1.Columns[6].Width = 85;
dataGridView1.Columns[7].Width = 160;
dataGridView1.Columns[8].Width = 90;
dataGridView1.Columns[9].Width = 60;
dataGridView1.Columns[10].Width = 65;
dataGridView1.Columns[11].Width = 120;
dataGridView1.Columns[12].Width = 65;
dataGridView1.Columns[13].Width = 120;
dataGridView1.Columns[14].Width = 120;
dataGridView1.Columns[15].Width = 80;
dataGridView1.Columns[16].Width = 150;
dataGridView1.Columns[17].Width = 100;
dataGridView1.Columns[18].Width = 160;
dataGridView1.Columns[19].Width = 90;
dataGridView1.Columns[20].Width = 80;
dataGridView1.Columns[21].Width = 50;
dataGridView1.Columns[22].Width = 140;
}
}
public static string ptxml(string Sslbx, string Ssbz, string Debug)
{
SqlDB_ZGQ db = new SqlDB_ZGQ();
if (Sslbx != "")
{
string exp = "";
string djr = f.ReadString("yh", "yhmc", "").Replace("\0", "").Trim();
if (Sslbx == "手术申请单" || Sslbx == "冰冻申请单号")
{
string odbcsql = f.ReadString(Sslbx, "odbcsql", "Data Source=172.16.10.1;Initial Catalog=xsylzx;User Id=xrh;Password=xsrmyy18;");
string tqbblb = f.ReadString(Sslbx, "tqbblb", "0");
string debug = f.ReadString(Sslbx, "debug", "0");
string sqlstr = "select * from dbo.view_bdqpjcsqd WHERE registerid_int= '" + Ssbz.Trim() + "'";
DataTable dt_SQD = new DataTable();
string exp_db = "";
dt_SQD = db.Sql_DataAdapter(odbcsql, sqlstr, ref exp_db);
if (dt_SQD == null)
{
MessageBox.Show("数据库连接异常！" + exp_db);
return("0");
}
if (dt_SQD.Rows.Count <= 0)
{
MessageBox.Show("未查询到此申请序号记录！");
return("0");
}
//取收费je
if (debug == "1")
{
MessageBox.Show(exp_db);
}
//-返回xml----------------------------------------------------
try
{
string xml = "<?xml version=" + (char)34 + "1.0" + (char)34 + " encoding=" + (char)34 + "gbk" + (char)34 + "?>";
xml = xml + "<LOGENE>";
xml = xml + "<row ";
try
{
xml = xml + "病人编号=" + (char)34 + dt_SQD.Rows[0]["patientid_vchr"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病人编号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "就诊ID=" + (char)34 + dt_SQD.Rows[0]["iptimes_int"].ToString().Trim() + (char)34 + " ";
}
catch
{
xml = xml + "就诊ID=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "申请序号=" + (char)34 + dt_SQD.Rows[0]["registerid_int"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "申请序号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "住院号=" + (char)34 + dt_SQD.Rows[0]["PatientIpNo"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "住院号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "姓名=" + (char)34 + dt_SQD.Rows[0]["PatientName"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "姓名=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "性别=" + (char)34 + dt_SQD.Rows[0]["PatientSex"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "性别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "年龄=" + (char)34 + dt_SQD.Rows[0]["PatientAge"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "年龄=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "地址=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "地址=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "电话=" + (char)34 + dt_SQD.Rows[0]["TEL"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "电话=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病区=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病区=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "床号=" + (char)34 + dt_SQD.Rows[0]["PatientBedNo"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "床号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "身份证号=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "身份证号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "民族=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "民族=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "职业=" + (char)34 + dt_SQD.Rows[0]["PatientJob"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "职业=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检科室=" + (char)34 + dt_SQD.Rows[0]["PatientDept"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "送检科室=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检医生=" + (char)34 + dt_SQD.Rows[0]["SJYS"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "送检医生=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
xml = xml + "收费=" + (char)34 + "501" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "标本名称=" + (char)34 + dt_SQD.Rows[0]["BBMC"].ToString().Trim() + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "送检医院=" + (char)34 + "本院" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "医嘱项目=" + (char)34 + "" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "备用1=" + (char)34 + (char)34 + " ";
//----------------------------------------------------------
try
{
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee4)
{
log.WriteMyLog(ee4.Message);
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "费别=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "费别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病人类别=" + (char)34 + "住院" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病人类别=" + (char)34 + "" + (char)34 + " ";
}
xml = xml + "/>";
//----------------------------------------------------------
try
{
xml = xml + "<临床病史><![CDATA[" + dt_SQD.Rows[0]["BLZY"].ToString().Trim() + "]]></临床病史>";//.Replace("\"", """)
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "<临床病史><![CDATA[" + "" + "]]></临床病史>";
}
//----------------------------------------------------------
try
{
xml = xml + "<临床诊断><![CDATA[" + dt_SQD.Rows[0]["LCZD"].ToString().Trim() + "]]></临床诊断>";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "<临床诊断><![CDATA[" + "" + "]]></临床诊断>";
}
xml = xml + "</LOGENE>";
if (Debug == "1" && exp.Trim() != "")
{
log.WriteMyLog(exp.Trim());
}
return(xml);
}
catch (Exception e)
{
MessageBox.Show("提取信息出错，请重新操作");
log.WriteMyLog("xml解析错误---" + e.Message);
return("0");
}
}
if (Sslbx == "申请单号" || Sslbx == "常规病理申请单号")
{
string odbcsql = f.ReadString(Sslbx, "odbcsql", "Data Source=172.16.10.1;Initial Catalog=xsylzx;User Id=xrh;Password=xsrmyy18;");
string tqbblb = f.ReadString(Sslbx, "tqbblb", "0");
string debug = f.ReadString(Sslbx, "debug", "0");
string sqlstr = "select * from dbo.view_bljcsqd WHERE registerid_int= '" + Ssbz.Trim() + "'";
DataTable dt_SQD = new DataTable();
string exp_db = "";
dt_SQD = db.Sql_DataAdapter(odbcsql, sqlstr, ref exp_db);
if (dt_SQD == null)
{
MessageBox.Show("数据库连接异常！" + exp_db);
return("0");
}
if (dt_SQD.Rows.Count <= 0)
{
MessageBox.Show("未查询到此申请序号记录！");
return("0");
}
//取收费je
if (debug == "1")
{
MessageBox.Show(exp_db);
}
//-返回xml----------------------------------------------------
try
{
string xml = "<?xml version=" + (char)34 + "1.0" + (char)34 + " encoding=" + (char)34 + "gbk" + (char)34 + "?>";
xml = xml + "<LOGENE>";
xml = xml + "<row ";
try
{
xml = xml + "病人编号=" + (char)34 + dt_SQD.Rows[0]["patientid_vchr"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病人编号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "就诊ID=" + (char)34 + dt_SQD.Rows[0]["iptimes_int"].ToString().Trim() + (char)34 + " ";
}
catch
{
xml = xml + "就诊ID=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "申请序号=" + (char)34 + dt_SQD.Rows[0]["registerid_int"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "申请序号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "住院号=" + (char)34 + dt_SQD.Rows[0]["PatientIpNo"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "住院号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "姓名=" + (char)34 + dt_SQD.Rows[0]["PatientName"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "姓名=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "性别=" + (char)34 + dt_SQD.Rows[0]["PatientSex"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "性别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "年龄=" + (char)34 + dt_SQD.Rows[0]["PatientAge"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "年龄=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "地址=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "地址=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "电话=" + (char)34 + dt_SQD.Rows[0]["TEL"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "电话=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病区=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病区=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "床号=" + (char)34 + dt_SQD.Rows[0]["PatientBedNo"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "床号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "身份证号=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "身份证号=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "民族=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "民族=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "职业=" + (char)34 + dt_SQD.Rows[0]["PatientJob"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "职业=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检科室=" + (char)34 + dt_SQD.Rows[0]["PatientDept"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "送检科室=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "送检医生=" + (char)34 + dt_SQD.Rows[0]["SJYS"].ToString().Trim() + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "送检医生=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
xml = xml + "收费=" + (char)34 + "201" + (char)34 + " ";
//----------------------------------------------------------
///////////////////////////
string BBLB_XML = "";
if (tqbblb == "1")
{
BBLB_XML = "<BBLB>";
try
{
if (dt_SQD.Rows[0]["BBMC1"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW1"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "1" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC1"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW1"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC2"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW2"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "2" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC2"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW2"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC3"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW3"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "3" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC3"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW3"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC4"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW4"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "4" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC4"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW4"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC5"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW5"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "5" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC5"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW5"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC6"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW6"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "6" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC6"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW6"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC7"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW7"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "7" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC7"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW7"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
if (dt_SQD.Rows[0]["BBMC8"].ToString().Trim() != "" || dt_SQD.Rows[0]["CQBW8"].ToString().Trim() != "")
{
BBLB_XML = BBLB_XML + "<row ";
BBLB_XML = BBLB_XML + "F_BBXH=" + (char)34 + "8" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBTMH=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBMC=" + (char)34 + dt_SQD.Rows[0]["BBMC8"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_CQBW=" + (char)34 + dt_SQD.Rows[0]["CQBW8"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BZ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_LTSJ=" + (char)34 + dt_SQD.Rows[0]["LTSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_GDSJ=" + (char)34 + dt_SQD.Rows[0]["GDSJ"].ToString().Trim() + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSSJ=" + (char)34 + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_JSY=" + (char)34 + djr + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBZT=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_BBPJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJR=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "F_PJSJ=" + (char)34 + "" + (char)34 + " ";
BBLB_XML = BBLB_XML + "/>";
}
}
catch (Exception eee)
{
MessageBox.Show("获取标本列表信息异常：" + eee.Message);
tqbblb = "0";
}
BBLB_XML = BBLB_XML + "</BBLB>";
}
xml = xml + "标本名称=" + (char)34 + dt_SQD.Rows[0]["BBMC"].ToString().Trim() + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "送检医院=" + (char)34 + "本院" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "医嘱项目=" + (char)34 + "" + (char)34 + " ";
//----------------------------------------------------------
xml = xml + "备用1=" + (char)34 + (char)34 + " ";
//----------------------------------------------------------
try
{
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee4)
{
log.WriteMyLog(ee4.Message);
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "费别=" + (char)34 + "" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "费别=" + (char)34 + "" + (char)34 + " ";
}
//----------------------------------------------------------
try
{
xml = xml + "病人类别=" + (char)34 + "住院" + (char)34 + " ";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "病人类别=" + (char)34 + "" + (char)34 + " ";
}
xml = xml + "/>";
//----------------------------------------------------------
try
{
xml = xml + "<临床病史><![CDATA[" + dt_SQD.Rows[0]["SSSJ"].ToString().Trim() + "]]></临床病史>";//.Replace("\"", """)
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "<临床病史><![CDATA[" + "" + "]]></临床病史>";
}
//----------------------------------------------------------
try
{
xml = xml + "<临床诊断><![CDATA[" + dt_SQD.Rows[0]["LCZD"].ToString().Trim() + "]]></临床诊断>";
}
catch (Exception ee)
{
exp = exp + ee.ToString();
xml = xml + "<临床诊断><![CDATA[" + "" + "]]></临床诊断>";
}
if (tqbblb == "1")
{
xml = xml + BBLB_XML;
}
xml = xml + "</LOGENE>";
if (Debug == "1" && exp.Trim() != "")
{
log.WriteMyLog(exp.Trim());
}
return(xml);
}
catch (Exception e)
{
MessageBox.Show("提取信息出错，请重新操作");
log.WriteMyLog("xml解析错误---" + e.Message);
return("0");
}
}
else
{
MessageBox.Show("无此" + Sslbx);
return("0");
}
}
return("0");
}
/// <summary>
/// // @brlb ut_bz, --病人类别 0门诊 1住院 3体检
//@codetype ut_bz, --号码类型 1住院/门诊号指病历号，2卡号， 3PatientID
// --对应于his中的 patid(门诊),patid(住院)， 4CureNo对应于his,9发票号（门诊使用）
// --中的ghsjh (门诊),和syxh(住院)
// @code varchar(20) --号码，它的含义，由上面codetype指定
//exec usp_yjjk_getbrxx '1','4','285606'
//测试:
//his数据库 192.168.42.107\this4
//用户：sa/sql2k
//库：this4_0720
//存储过程：usp_yjjk_getbrxx
// @brlb ut_bz, --病人类别 0门诊 1住院 3体检
// @codetype ut_bz, --号码类型 1住院/门诊号指病历号，2卡号，
// --对应于his中的 patid(门诊),patid(住院)， 9发票号（门诊使用）
// --中的ghsjh (门诊),和syxh(住院)
// @code varchar(20) --号码，它的含义，由上面codetype指定
//patientID patientID
//HospNo 病员号 病历号
//patName 病人姓名
//Sex 性别 1 男，2女
//age+ageUnit 年龄
//WardOrReg 病人类别 0门诊 1住院 3体检
//ChargeType 费别
//CureNo 住院号/门诊号
//CardNo 卡号
//applyDept 科室 代码
//select name from YY_KSBMK where id ='409'
//ward 病区代码 ZY_BQDMK
//bedNo 床号
//applyDoctor 医生代码 YY_ZGBMK
//select name from YY_ZGBMK where id ='5358'
//clincDesc 临床诊断。
//IDNum 身份号
//Phone 电话
//Address 地址
//Zip
//Career 职业
//Nation 民族
//ToDoc
//sendNo
//Syxh 首页序号
//bqmc 病区
//yexh
//DeptName 科室名称
//clinicDesc 临床诊断
/// </summary>
/// <param name="Sslbx"></param>
/// <param name="Ssbz"></param>
/// <param name="Debug"></param>
/// <returns></returns>
public static string ptxml(string Sslbx, string Ssbz, string Debug)
{
if (Sslbx != "")
{
string odbcsql = f.ReadString(Sslbx, "odbcsql", "Data Source=192.168.42.107\\this4;Initial Catalog=THIS4_0720;User Id=sa;Password=sql2k;");
string brlb = "";
string codetype = "";
if (Sslbx == "门诊病历号")
{
brlb = "0";
codetype = "1";
}
if (Sslbx == "门诊号")
{
brlb = "0";
codetype = "4";
}
if (Sslbx == "卡号")
{
brlb = "0";
codetype = "2";
}
if (Sslbx == "发票号")
{
brlb = "0";
codetype = "9";
}
if (Sslbx == "住院病历号")
{
brlb = "1";
codetype = "1";
}
if (Sslbx == "住院号")
{
brlb = "1";
codetype = "4";
}
if (Sslbx == "体检号")
{
brlb = "3";
codetype = "1";
}
if (Sslbx == "体检卡号")
{
brlb = "3";
codetype = "2";
}
if (Sslbx == "体检发票号")
{
brlb = "3";
codetype = "9";
}
if (brlb == "")
{
MessageBox.Show("未设置此识别类型" + Sslbx); return("0");
}
DataTable dt = new DataTable();
string exec = "";
SqlDB_ZGQ sql = new SqlDB_ZGQ();
dt = sql.Sql_DataAdapter(odbcsql, "exec usp_yjjk_getbrxx '" + brlb + "','" + codetype + "','" + Ssbz.Trim() + "'", ref exec);
if (exec != "")
{
MessageBox.Show(exec);
return("0");
}
if (dt.Rows.Count == 0)
{
MessageBox.Show("未能查询到对应的数据记录！请确认" + Sslbx + "是否正确");
return("0");
}
//无数据集时对方返回 select "F","没有指定的条件！"
try
{
MessageBox.Show(dt.Rows[0]["Column2"].ToString().Trim());
return("0");
}
catch
{
}
int count = 0;
DataColumn dc0 = new DataColumn("序号");
dt.Columns.Add(dc0);
DataColumn dc_brlb = new DataColumn("病人类别");
dt.Columns.Add(dc_brlb);
for (int x = 0; x < dt.Rows.Count; x++)
{
dt.Rows[x][dt.Columns.Count - 2] = x;
//通过医生代码查询医生姓名
try
{
DataTable dt_ys = new DataTable();
dt_ys = sql.Sql_DataAdapter(odbcsql, "select top 1 name from YY_ZGBMK where id ='" + dt.Rows[x]["ApplyDoctor"].ToString().Trim() + "'", ref exec);
if (dt_ys.Rows.Count > 0)
{
dt.Rows[x]["ApplyDoctor"] = dt_ys.Rows[0]["name"].ToString().Trim();
}
}
catch
{
}
//DeptName为空的情况下，通过科室代码代码查询科室名称
if (dt.Rows[x]["DeptName"].ToString().Trim() == null || dt.Rows[x]["DeptName"].ToString().Trim() == "")
{
try
{
DataTable dt_ks = new DataTable();
dt_ks = sql.Sql_DataAdapter(odbcsql, "select top 1 name from YY_KSBMK where id ='" + dt.Rows[x]["ApplyDept"].ToString().Trim() + "'", ref exec);
if (dt_ks.Rows.Count > 0)
{
dt.Rows[x]["DeptName"] = dt_ks.Rows[0]["name"].ToString().Trim();
}
}
catch
{
}
}
// --病人类别 0门诊 1住院 3体检
dt.Rows[0]["病人类别"] = dt.Rows[0]["WardOrReg"].ToString().Trim();
if (dt.Rows[0]["WardOrReg"].ToString().Trim() == "1")
{
dt.Rows[0]["病人类别"] = "住院";
}
if (dt.Rows[count]["WardOrReg"].ToString().Trim() == "3")
{
dt.Rows[0]["病人类别"] = "体检";
}
if (dt.Rows[count]["WardOrReg"].ToString().Trim() == "0")
{
dt.Rows[0]["病人类别"] = "门诊";
}
}
// 多条数据显示选择窗体
if (dt.Rows.Count >= 1)
{
//dataGridView1显示样式
string xsys = f.ReadString(Sslbx, "xsys", "1");
//显示的列字段
string Columns = f.ReadString(Sslbx, "Columns", "HospNo,病人类别,PatName,Age,CureNo,CardNo,bqmc,BedNo,DeptName,ApplyDoctor,ClinicDesc");
//显示的列的别名
string ColumnsName = f.ReadString(Sslbx, "ColumnsName", "病历号,类别,姓名,年龄,住院号/门诊号,卡号,病区,床号,申请科室,申请医生,临床诊断");
//增加序号列
if (Columns.Trim() != "")
{
Columns = "序号," + Columns;
}
if (ColumnsName.Trim() != "")
{
ColumnsName = "序号," + ColumnsName;
}
//显示窗体
FRM_YZ_SELECT yc = new FRM_YZ_SELECT(dt, Columns, ColumnsName, xsys);
yc.ShowDialog();
string rtn2 = yc.F_XH;
if (rtn2.Trim() == "")
{
MessageBox.Show("未选择数据！");
return("0");
}
try
{
count = int.Parse(rtn2);
}
catch
{
MessageBox.Show("请重新选择！");
return("0");
}
}
try
{
string xml = "<?xml version=" + (char)34 + "1.0" + (char)34 + " encoding=" + (char)34 + "gbk" + (char)34 + "?>";
xml = xml + "<LOGENE>";
xml = xml + "<row ";
xml = xml + "病人编号=" + (char)34 + dt.Rows[count]["PatientID"].ToString().Trim() + (char)34 + " ";
xml = xml + "就诊ID=" + (char)34 + dt.Rows[count]["HospNo"].ToString().Trim() + "^" + dt.Rows[count]["CardNo"].ToString().Trim() + (char)34 + " ";
xml = xml + "申请序号=" + (char)34 + "" + (char)34 + " ";
if (dt.Rows[count]["WardOrReg"].ToString().Trim() == "1")
{
xml = xml + "门诊号=" + (char)34 + "" + (char)34 + " ";
xml = xml + "住院号=" + (char)34 + dt.Rows[count]["CureNo"].ToString().Trim() + (char)34 + " ";
}
else
{
xml = xml + "门诊号=" + (char)34 + dt.Rows[count]["CureNo"].ToString().Trim() + (char)34 + " ";
xml = xml + "住院号=" + (char)34 + "" + (char)34 + " ";
}
xml = xml + "姓名=" + (char)34 + dt.Rows[count]["PatName"].ToString().Trim() + (char)34 + " ";
string xb = dt.Rows[count]["Sex"].ToString().Trim();
if (xb == "2")
{
xb = "女";
}
if (xb == "1")
{
xb = "男";
}
xml = xml + "性别=" + (char)34 + xb + (char)34 + " ";
xml = xml + "年龄=" + (char)34 + dt.Rows[count]["Age"].ToString().Trim() + dt.Rows[count]["AgeUnit"].ToString().Trim() + (char)34 + " ";
xml = xml + "婚姻=" + (char)34 + "" + (char)34 + " ";
xml = xml + "地址=" + (char)34 + dt.Rows[count]["Address"].ToString().Trim() + (char)34 + " ";
xml = xml + "电话=" + (char)34 + dt.Rows[count]["Phone"].ToString().Trim() + (char)34 + " ";
xml = xml + "病区=" + (char)34 + dt.Rows[count]["bqmc"].ToString().Trim() + (char)34 + " ";
xml = xml + "床号=" + (char)34 + dt.Rows[count]["BedNo"].ToString().Trim() + (char)34 + " ";
xml = xml + "身份证号=" + (char)34 + dt.Rows[count]["IDNum"].ToString().Trim() + (char)34 + " ";
xml = xml + "民族=" + (char)34 + dt.Rows[count]["Nation"].ToString().Trim() + (char)34 + " ";
xml = xml + "职业=" + (char)34 + dt.Rows[count]["Career"].ToString().Trim() + (char)34 + " ";
xml = xml + "送检科室=" + (char)34 + dt.Rows[0]["DeptName"].ToString().Trim() + (char)34 + " ";
xml = xml + "送检医生=" + (char)34 + dt.Rows[0]["ApplyDoctor"].ToString().Trim() + (char)34 + " ";
xml = xml + "收费=" + (char)34 + "" + (char)34 + " ";
xml = xml + "标本名称=" + (char)34 + "" + (char)34 + " ";
xml = xml + "送检医院=" + (char)34 + "本院" + (char)34 + " ";
xml = xml + "医嘱项目=" + (char)34 + "" + (char)34 + " ";
xml = xml + "备用1=" + (char)34 + "" + (char)34 + " ";
xml = xml + "备用2=" + (char)34 + "" + (char)34 + " ";
xml = xml + "费别=" + (char)34 + dt.Rows[count]["ChargeType"].ToString().Trim() + (char)34 + " ";
xml = xml + "病人类别=" + (char)34 + dt.Rows[0]["病人类别"].ToString().Trim() + (char)34 + " ";
xml = xml + "/>";
xml = xml + "<临床病史><![CDATA[" + "" + "]]></临床病史>";
xml = xml + "<临床诊断><![CDATA[" + dt.Rows[count]["ClinicDesc"].ToString().Trim() + "]]></临床诊断>";
xml = xml + "</LOGENE>";
return(xml);
}
catch (Exception e)
{
MessageBox.Show("提取信息出现异常：" + e.Message);
return("0");
}
}
return("0");
}