public static string GetTJInfo(ODBCHelper cc, string Ssbz, string Debug)
{
OdbcCommand cmd = cc.GetOdbcStringCommond("select * from V_TJ_BRINFO where tjno = '" + Ssbz + "'");
DataSet ds = cc.ExecuteDataSet(cmd);
if (ds.Tables == null || ds.Tables.Count < 1)
{
return("0");
}
DataTable dt = ds.Tables[0];
if (dt == null || dt.Rows.Count < 1)
{
return("0");
}
LogeneXmlHelper lxp = new LogeneXmlHelper();
lxp.F_BRBH = dt.Rows[0]["tjno"] == null ? "" : dt.Rows[0]["tjno"].ToString().Trim();
lxp.F_XM = dt.Rows[0]["name"] == null ? "" : dt.Rows[0]["name"].ToString().Trim();
lxp.F_NL = dt.Rows[0]["age"] == null ? "" : dt.Rows[0]["age"].ToString().Trim();
lxp.F_XB = dt.Rows[0]["sex"] == null ? "" : dt.Rows[0]["sex"].ToString().Trim();
lxp.F_SJKS = dt.Rows[0]["department"] == null ? "" : dt.Rows[0]["department"].ToString().Trim();
lxp.F_ADDRESS = dt.Rows[0]["home_address"] == null ? "" : dt.Rows[0]["home_address"].ToString().Trim();
lxp.F_TELEPHONE = dt.Rows[0]["home_tel"] == null ? "" : dt.Rows[0]["home_tel"].ToString().Trim();
lxp.F_BRLB = "体检";
return(lxp.ReturnLogeneXML());
}
private static List <BBLB> TQBBLB(ODBCHelper bb, string Ssbz)
{
List <BBLB> bblbs = new List <BBLB>();
try
{
OdbcCommand cmd = bb.GetStoredProcCommond("{call pGetFunctionSampleByLabelIDForPathNet(?)}");
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, Ssbz);
OdbcDataAdapter sqlda = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
sqlda.Fill(ds);
if (ds.Tables == null || ds.Tables.Count < 1)
{
return(bblbs);
}
DataTable dt = ds.Tables[0];
if (dt == null || dt.Rows.Count < 1)
{
return(bblbs);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
BBLB bblb = new BBLB();
bblb.F_BBXH = (i + 1).ToString();
bblb.F_BBTMH = dt.Rows[i]["FunctionSampleLabelID"] == null ? "" : dt.Rows[i]["FunctionSampleLabelID"].ToString().Trim();
bblb.F_BBMC = dt.Rows[i]["SampleRemark"] == null ? "" : dt.Rows[i]["SampleRemark"].ToString().Trim();
bblb.F_LTSJ = dt.Rows[i]["SampleGatherDateTime"] == null ? "" : dt.Rows[i]["SampleGatherDateTime"].ToString().Trim();
bblb.F_JSSJ = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string jsy = f.ReadString("yh", "yhmc", "").Replace("\0", "");
bblb.F_JSY = jsy;
bblb.F_BBZT = "已接收";
bblbs.Add(bblb);
}
return(bblbs);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(bblbs);
}
}
private void button1_Click(object sender, EventArgs e)
{
string constring1 = f.ReadString("GDSY", "hisstring", "DSN=pathnet-his;UID=pathnetuser;PWD=userpathnet");
ODBCHelper bb = new ODBCHelper(constring1);
OdbcCommand cmd = bb.GetStoredProcCommond("{call pGetFunctionRequestForPathNet(?,?,?,?,?,?,?)}");
bb.AddInParameter(cmd, "@In_Flag", DbType.Int16, 3);
bb.AddInParameter(cmd, "@In_StartDate", DbType.DateTime, this.dateTimePicker1.Value);
bb.AddInParameter(cmd, "@In_EndDate", DbType.DateTime, this.dateTimePicker2.Value);
bb.AddInParameter(cmd, "@In_RequestDepartmentNos", DbType.String, ht[this.comboBox1.Text] == null ? "" : ht[this.comboBox1.Text] as string);
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, "");
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.DateTime, "");
bb.AddInParameter(cmd, "@In_SeqNo", DbType.Int32, "");
OdbcDataAdapter sqlda = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
sqlda.Fill(ds);
if (ds.Tables == null || ds.Tables.Count < 1)
{
return;
}
dt = ds.Tables[0];
if (dt == null || dt.Rows.Count < 1)
{
return;
}
DataTable dtbind = new DataTable();
dtbind.Columns.Add("PatientID");
dtbind.Columns.Add("PatientName");
dtbind.Columns.Add("PatientSex");
dtbind.Columns.Add("PatientAge");
dtbind.Columns.Add("RequestDepartmentName");
dtbind.Columns.Add("RequestDateTime");
dtbind.Columns.Add("FunctionRequestID");
foreach (DataRow dr in dt.Rows)
{
string brbh = dr["PatientID"] == null ? "" : dr["PatientID"].ToString();
string xm = dr["PatientName"] == null ? "" : dr["PatientName"].ToString();
string xb = dr["PatientSex"] == null ? "" : dr["PatientSex"].ToString();
string birthday = dt.Rows[0]["patientbirthday"] == null ? "" : dt.Rows[0]["patientbirthday"].ToString().Trim();
string nl = "";
if (birthday != "")
{
try
{
DateTime birth = DateTime.Parse(birthday);
nl = GDSY.CalculateAgeCorrect(birth, DateTime.Now).ToString();
}
catch
{
nl = "";
}
}
string sjks = dr["RequestDepartmentName"] == null ? "" : dr["RequestDepartmentName"].ToString();
string sqsj = dr["RequestDateTime"] == null ? "" : dr["RequestDateTime"].ToString();
string sqxh = dr["FunctionRequestID"] == null ? "" : dr["FunctionRequestID"].ToString();
dtbind.Rows.Add(brbh, xm, xb, nl, sjks, sqsj, sqxh);
}
this.dataGridView1.DataSource = dtbind;
}
private static string GetBBSQInfo(string Ssbz, string Debug, int Flag, string sftqbb)
{
string constring1 = f.ReadString("GDSY", "hisstring", "DSN=pathnethisgdsy;UID=pathnetuser;PWD=userpathnet;");
ODBCHelper bb = new ODBCHelper(constring1);
if (Flag == 4)
{
int a = 0;
if (int.TryParse(Ssbz, out a) == false)
{
Ssbz = Ssbz.Substring(4);
}
}
OdbcCommand cmd = bb.GetStoredProcCommond("{call pGetFunctionRequestForPathNet(?,?,?,?,?,?,?,?)}");
bb.AddInParameter(cmd, "@In_Flag", DbType.Int16, Flag);
bb.AddInParameter(cmd, "@In_StartDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_EndDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_RequestDepartmentNos", DbType.String, "");
if (Flag == 1)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, "");
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.DateTime, Ssbz.Substring(0, 10));
int mzls;
try
{
mzls = int.Parse(Ssbz.Substring(11));
}
catch
{
MessageBox.Show("请检查输入的门诊号格式是否正确！");
return("0");
}
bb.AddInParameter(cmd, "@In_SeqNo", DbType.Int32, mzls);
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, 0);
}
else if (Flag == 2)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, Ssbz);
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_SeqNo", DbType.Int32, 0);
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, 0);
}
else if (Flag == 4)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, "");
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_SeqNo", DbType.String, "");
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, Ssbz);
}
else
{
GDSYSQForm sqform = new GDSYSQForm();
if (sqform.DialogResult == DialogResult.OK)
{
return(sqform.rexml);
}
}
OdbcDataAdapter sqlda = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
sqlda.Fill(ds);
if (ds.Tables == null || ds.Tables.Count < 1)
{
return(GetBBInfo(bb, Ssbz, Debug, Flag, sftqbb));
}
DataTable dt = ds.Tables[0];
if (Debug == "1")
{
MessageBox.Show("查询到数据条数：" + dt.Rows.Count.ToString());
}
if (dt == null || dt.Rows.Count < 1)
{
return(GetBBInfo(bb, Ssbz, Debug, Flag, sftqbb));
}
GDSYUNIForm uniform = new GDSYUNIForm();
uniform.indt = dt;
if (uniform.ShowDialog() == DialogResult.OK)
{
DataRow outdr = uniform.outdr;
if (outdr == null)
{
return(GetBBInfo(bb, Ssbz, Debug, Flag, sftqbb));
}
//DataRow outdr = dt.Rows[0];
LogeneXmlHelper lxp = new LogeneXmlHelper();
lxp.F_ZYH = outdr["IPSeqNoText"] == null ? "" : outdr["IPSeqNoText"].ToString().Trim();
lxp.F_BRBH = outdr["PatientID"] == null ? "" : outdr["PatientID"].ToString().Trim();
//empiid存职业字段
lxp.F_ZY = GetEMPIID(lxp.F_BRBH);
lxp.F_CH = outdr["SickBedNo"] == null ? "" : outdr["SickBedNo"].ToString().Trim();
lxp.F_XM = outdr["PatientName"] == null ? "" : outdr["PatientName"].ToString().Trim();
lxp.F_XB = outdr["PatientSex"] == null ? "" : outdr["PatientSex"].ToString().Trim();
//string birth = outdr["PatientBirthDay"] == null ? "" : outdr["PatientBirthDay"].ToString().Trim();
//lxp.F_NL = CalculateAgeCorrect(DateTime.Parse(birth), DateTime.Now).ToString(); ;
lxp.F_NL = outdr["PatientAge"] == null ? "" : outdr["PatientAge"].ToString().Trim();
lxp.F_MZH = outdr["SeqNo"] == null ? "" : (outdr["SeqNo"].ToString().Trim() == "-1" ? " " : outdr["SeqNo"].ToString().Trim());
lxp.F_SJKS = outdr["RequestDepartmentName"] == null ? "" : outdr["RequestDepartmentName"].ToString().Trim();
lxp.F_SJYS = outdr["RequestEmployeeName"] == null ? "" : outdr["RequestEmployeeName"].ToString().Trim();
lxp.F_JZID = outdr["InPatientID"] == null ? "" : outdr["InPatientID"].ToString().Trim();
lxp.F_SQXH = outdr["FunctionRequestID"] == null ? "" : outdr["FunctionRequestID"].ToString().Trim();
lxp.F_YZXM = outdr["ItemName"] == null ? "" : outdr["ItemName"].ToString().Trim();
lxp.F_HY = outdr["Marriage"] == null ? "" : outdr["Marriage"].ToString();
lxp.F_ADDRESS = outdr["Address"] == null ? "" : outdr["Address"].ToString();
lxp.F_TELEPHONE = outdr["Phone"] == null ? "" : outdr["Phone"].ToString();
lxp.F_SFZH = outdr["IdentityCardNo"] == null ? "" : outdr["IdentityCardNo"].ToString();
lxp.F_MZ = outdr["RaceDesc"] == null ? "" : outdr["RaceDesc"].ToString();
// lxp.F_ZY = outdr["ProfessionDesc"] == null ? "" : outdr["ProfessionDesc"].ToString();
lxp.F_LCZD = outdr["diseaseName"] == null ? "" : outdr["diseaseName"].ToString();
lxp.F_BQ = outdr["IPDepartmentName"] == null ? "" : outdr["IPDepartmentName"].ToString();
if (Flag == 1)
{
lxp.F_BRLB = "门诊";
}
else if (Flag == 2)
{
lxp.F_BRLB = "住院";
}
if (sftqbb == "1")
{
lxp.BBLBLIST = TQBBLB(bb, Ssbz);
if (Debug == "1")
{
MessageBox.Show("标本数量：" + lxp.BBLBLIST.Count.ToString());
}
if (lxp.BBLBLIST == null)
{
MessageBox.Show("未查询到标本信息");
}
else
{
if (Debug == "1")
{
MessageBox.Show("返回XML：" + lxp.ReturnBBLBXML());
}
return(lxp.ReturnBBLBXML());
}
}
if (Debug == "1")
{
MessageBox.Show("返回XML：" + lxp.ReturnLogeneXML());
}
return(lxp.ReturnLogeneXML());
}
//GDSYMutiForm mutiform = new GDSYMutiForm();
//mutiform.indt = dt;
//if (mutiform.ShowDialog() == DialogResult.OK)
//{
// return mutiform.rexml;
//}
return(GetBBInfo(bb, Ssbz, Debug, Flag, sftqbb));
}
private static string GetBBInfo(ODBCHelper bb, string Ssbz, string Debug, int Flag, string sftqbb)
{
OdbcCommand cmd = bb.GetStoredProcCommond("{call pGETPatientInfoForPathNet(?,?,?,?,?)}");
bb.AddInParameter(cmd, "@In_Flag", DbType.Int16, Flag);
if (Flag == 1)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, "");
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.DateTime, Ssbz.Substring(0, 10));
int mzls;
try
{
mzls = int.Parse(Ssbz.Substring(11));
}
catch
{
MessageBox.Show("请检查输入的门诊号格式是否正确！");
return("0");
}
bb.AddInParameter(cmd, "@In_SeqNo", DbType.Int32, mzls);
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, 0);
}
else if (Flag == 2)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, Ssbz);
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_SeqNo", DbType.String, "");
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, 0);
}
else if (Flag == 4)
{
bb.AddInParameter(cmd, "@In_IPSeqNoText", DbType.String, "");
bb.AddInParameter(cmd, "@In_RegisterDate", DbType.String, "");
bb.AddInParameter(cmd, "@In_SeqNo", DbType.String, "");
bb.AddInParameter(cmd, "@In_FunctionSampleLabelID", DbType.Int32, Ssbz);
}
OdbcDataAdapter sqlda = new OdbcDataAdapter(cmd);
DataSet ds = new DataSet();
sqlda.Fill(ds);
if (ds.Tables == null || ds.Tables.Count < 1)
{
return("0");
}
DataTable dt = ds.Tables[0];
if (dt == null || dt.Rows.Count < 1)
{
return("0");
}
LogeneXmlHelper lxp = new LogeneXmlHelper();
lxp.F_ZYH = dt.Rows[0]["IPSeqNOText"] == null ? "" : dt.Rows[0]["IPSeqNOText"].ToString().Trim();
lxp.F_BRBH = dt.Rows[0]["patientid"] == null ? "" : dt.Rows[0]["patientid"].ToString().Trim();
//empiid存职业字段
lxp.F_ZY = GetEMPIID(lxp.F_BRBH);
lxp.F_CH = dt.Rows[0]["sickbedno"] == null ? "" : dt.Rows[0]["sickbedno"].ToString().Trim();
lxp.F_XM = dt.Rows[0]["patientname"] == null ? "" : dt.Rows[0]["patientname"].ToString().Trim();
string birthday = dt.Rows[0]["patientbirthday"] == null ? "" : dt.Rows[0]["patientbirthday"].ToString().Trim();
if (birthday != "")
{
try
{
DateTime birth = DateTime.Parse(birthday);
int nl = CalculateAgeCorrect(birth, DateTime.Now);
lxp.F_NL = nl.ToString() + "岁";
}
catch
{
lxp.F_NL = "";
}
}
lxp.F_XB = dt.Rows[0]["patientsex"] == null ? "" : dt.Rows[0]["patientsex"].ToString().Trim();
lxp.F_HY = dt.Rows[0]["marriage"] == null ? "" : dt.Rows[0]["marriage"].ToString().Trim();
lxp.F_SJKS = dt.Rows[0]["departmentname"] == null ? "" : dt.Rows[0]["departmentname"].ToString().Trim();
lxp.F_ADDRESS = dt.Rows[0]["address"] == null ? "" : dt.Rows[0]["address"].ToString().Trim();
lxp.F_TELEPHONE = dt.Rows[0]["phone"] == null ? "" : dt.Rows[0]["phone"].ToString().Trim();
switch (Flag)
{
case 1:
lxp.F_BRLB = "门诊";
break;
case 2:
lxp.F_BRLB = "住院";
break;
default:
lxp.F_BRLB = dt.Rows[0]["PatientTypeListName"] == null ? "" : dt.Rows[0]["PatientTypeListName"].ToString().Trim();
break;
}
if (sftqbb == "1")
{
if (Debug == "1")
{
MessageBox.Show("取标本列表");
}
lxp.BBLBLIST = TQBBLB(bb, Ssbz);
if (lxp.BBLBLIST == null)
{
MessageBox.Show("未查询到标本信息");
}
else
{
if (Debug == "1")
{
MessageBox.Show("返回XML：" + lxp.ReturnBBLBXML());
}
return(lxp.ReturnBBLBXML());
}
}
return(lxp.ReturnLogeneXML());
}
internal static string ptxml(string Sslbx, string Ssbz)
{
////钱龙接口 2017-11-10 修改zgq
string Debug = f.ReadString(Sslbx, "debug", "0");
string Msg = f.ReadString(Sslbx, "msg", "0");
string sftqbb = f.ReadString(Sslbx, "tqbblb", "1");
string rexml = "0";
if (Sslbx == "申请单")
{
return(GetSqd(Sslbx, Ssbz, sftqbb, Debug, Msg));
}
if (Sslbx == "标本号")
{
rexml = GetSqd(Sslbx, Ssbz, sftqbb, Debug, Msg);
if (rexml != "0")
{
return(rexml);
}
return(GetBBSQInfo(Ssbz, Debug, 4, sftqbb));
}
if (Sslbx == "住 院")
{
rexml = GetSqd(Sslbx, Ssbz, sftqbb, Debug, Msg);
if (rexml != "0")
{
return(rexml);
}
return(GetBBSQInfo(Ssbz, Debug, 2, "0"));
}
if (Sslbx == "门 诊")
{
rexml = GetSqd(Sslbx, Ssbz, sftqbb, Debug, Msg);
if (rexml != "0")
{
return(rexml);
}
return(GetBBSQInfo(Ssbz, Debug, 1, "0"));
}
if (Sslbx == "东川体检")
{
string constring2 = f.ReadString("GDSY", "tjstring", "DSN=pathnet;UID=pathnet;PWD=4s3c2a1p;");
ODBCHelper cc = new ODBCHelper(constring2);
return(GetTJInfo(cc, Ssbz, Debug));
}
if (Sslbx == "按申请查询")
{
GDSYSQForm sqform = new GDSYSQForm();
if (sqform.DialogResult == DialogResult.OK)
{
return(sqform.rexml);
}
else
{
MessageBox.Show("未选择有效的申请单");
return(rexml);
}
}
MessageBox.Show("无效的识别类型:" + Sslbx);
return(rexml);
}