public DataTable GetPaiban(paibanModel pb, string tableName)
{
string SQL_PAIBAN = "select * from " + tableName + " where patid='" + pb.PATID + "'";
string INSERT = string.Format(SQL_PAIBAN);
return(GetDataTable(INSERT));
}
public int InsertPaiban(paibanModel pb, string tableName)
{
string SQL_PAIBAN = "insert into " + tableName + " (PatientNo,applyid,Cardno, PatZhuYuanID,IsZhuYuan, Patname,Patage,Patsex,patWeight,patHeight,patdpm,Pattmd,Oname,Odate,ApplyDate,os,OsNo,OA1,OA2,OA3,OA1No,OA2No,OA3No,Amethod,Patbedno,patid,asae,operaddress,ostate,oroom,ap1,ap2,ap3,sn1,sn2,on1,on2)"
+ "values('" + pb.PatientNo + "','" + pb.applyID + "','" + pb.cardNO + "','" + pb.zhuyuanNO + "','" + pb.IsZhuYuan + "','" + pb.patName + "','" + pb.patage + "','" + pb.patsex + "','" + pb.Weight + "','" + pb.Height + "','" + pb.patdpm + "','" + pb.SQZD + "','" + pb.Oname + "','" + pb.Odate + "','" + pb.ApplyDate + "',"
+ "'" + pb.OS + "','" + pb.OsNo + "','" + pb.OA1 + "','" + pb.OA2 + "','" + pb.OA3 + "','" + pb.OA1No + "','" + pb.OA2No + "','" + pb.OA3No + "','" + pb.MZFA + "','" + pb.BedNo + "','" + pb.PATID + "','" + pb.ASAE + "','" + pb.operAddress + "','0','','','','','','','','')";
string INSERT = string.Format(SQL_PAIBAN);
SaveLog(INSERT);
return(ExecuteNonQuery(INSERT));
}
public int UpdatePaibanAll(paibanModel pb, string tableName)
{
string SQL_PAIBAN = "Update " + tableName + " set PatientNo='" + pb.PatientNo + "',applyid='" + pb.applyID + "',Cardno='" + pb.cardNO + "', PatZhuYuanID='" + pb.zhuyuanNO + "',"
+ "IsZhuYuan='" + pb.IsZhuYuan + "', Patname='" + pb.patName + "',Patage='" + pb.patage + "',Patsex='" + pb.patsex + "',patWeight='" + pb.Weight + "',"
+ "patHeight='" + pb.Height + "',patdpm='" + pb.patdpm + "',Pattmd='" + pb.SQZD + "',Oname='" + pb.Oname + "',os='" + pb.OS + "',Odate='" + pb.Odate + "',ApplyDate='" + pb.ApplyDate + "',"
+ "OsNo='" + pb.OsNo + "',OA1='" + pb.OA1 + "',OA2='" + pb.OA2 + "',OA3='" + pb.OA3 + "',OA1No='" + pb.OA1No + "',OA2No='" + pb.OA2No + "',OA3No='" + pb.OA3No + "',"
+ "Amethod='" + pb.MZFA + "',Patbedno='" + pb.BedNo + "',asae='" + pb.ASAE + "',operaddress='" + pb.operAddress + "' where patid='" + pb.PATID + "'";
string INSERT = string.Format(SQL_PAIBAN);
SaveLog(INSERT);
return(ExecuteNonQuery(INSERT));
}
public static paibanModel toDataBae(string sHL7)
{
//把HL7分成段
string Old = sHL7;
if (Old.Contains("ARQ|"))
{
Old = Old.Replace("ARQ|", "\nARQ|");
}
if (Old.Contains("PID|"))
{
Old = Old.Replace("PID|", "\nPID|");
}
if (Old.Contains("PV1|"))
{
Old = Old.Replace("PV1|", "\nPV1|");
}
if (Old.Contains("AIS|"))
{
Old = Old.Replace("AIS|", "\nAIS|");
}
if (Old.Contains("OBX|1|"))
{
Old = Old.Replace("OBX|1|", "\nOBX|1|");
}
if (Old.Contains("OBX|2|"))
{
Old = Old.Replace("OBX|2|", "\nOBX|2|");
}
if (Old.Contains("AIP|"))
{
Old = Old.Replace("AIP|", "\nAIP|");
}
if (Old.Contains("DG1|"))
{
Old = Old.Replace("DG1|", "\nDG1|");
}
if (Old.Contains("RGS|"))
{
Old = Old.Replace("RGS|", "\nRGS|");
}
string[] sHL7Lines = Old.Split('\n');
paibanModel pb = new paibanModel();
#region HIS平台提供信息解析
for (int i = 0; i < sHL7Lines.Length; i++)
{
// 判断是否空行
if (sHL7Lines[i].Contains("ARQ|"))
{
string[] sList = sHL7Lines[i].Split('|');
pb.PATID = sList[1].Replace("^", "");
string[] dateList = sList[11].Split('^');
DateTime dtOdate = DateTime.ParseExact(dateList[0].Replace("^", "").Trim().Substring(0, 8), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
pb.Odate = dtOdate;
DateTime dtApplyDate = DateTime.ParseExact(dateList[1].Replace("^", ""), "yyyyMMddHHmmss", System.Globalization.CultureInfo.CurrentCulture);
pb.ApplyDate = dtApplyDate;
string[] nameList = sList[5].Split('^');
if (nameList.Length > 1)
{
pb.MZFA = nameList[1];
}
}
if (sHL7Lines[i].Contains("PID|"))
{
pb.PidInfo = sHL7Lines[i];
string[] sList = sHL7Lines[i].Split('|');
pb.PatientNo = sList[2].Split('^')[0];
string[] idList = sList[3].Split('~');
pb.applyID = idList[0].Split('^')[0];
pb.zhuyuanNO = idList[1].Split('^')[0];
pb.cardNO = idList[2].Split('^')[0];
string[] nameList = sList[5].Split('^');
pb.patName = nameList[1];
string str = sList[7].Trim().Substring(0, 8);
DateTime now = DateTime.Today;
DateTime bday = DateTime.ParseExact(str, "yyyyMMdd", null);
int age = now.Year - bday.Year;
pb.patage = age.ToString();
string[] sexList = sList[8].Split('^');
pb.patsex = sexList[0];
if (pb.patsex == "M")
{
pb.patsex = "男";
}
else
{
pb.patsex = "女";
}
//pb.patMinZu = sList[22].Split('^')[1];
}
if (sHL7Lines[i].Contains("OBX|1|"))
{
string[] sList = sHL7Lines[i].Split('|');
pb.Weight = sList[5];
}
if (sHL7Lines[i].Contains("OBX|2|"))
{
string[] sList = sHL7Lines[i].Split('|');
pb.Height = sList[5];
}
if (sHL7Lines[i].Contains("PV1|"))
{
pb.Pv1Info = sHL7Lines[i];
string[] sList = sHL7Lines[i].Split('|');
if (sList[2] == "I")
{
pb.IsZhuYuan = "1";
}
else if (sList[2] == "O")
{
pb.IsZhuYuan = "0";
}
else
{
pb.IsZhuYuan = "0";
pb.ASAE = "1";
}
string[] bedList = sList[3].Split('^');
pb.BedNo = bedList[4];
string[] dpmList = bedList[3].Split('&');
pb.patdpm = dpmList[1];
if (bedList[0].Trim().Length > 6)
{
pb.operAddress = bedList[0].Trim().Substring(0, 6);
}
else
{
pb.operAddress = bedList[0].Trim();
}
pb.applyID = sList[19];
}
if (sHL7Lines[i].Contains("DG1|"))
{
string[] sList = sHL7Lines[i].Split('|');
pb.SQZD = sList[4];
}
if (sHL7Lines[i].Contains("AIS|"))
{
string[] sList = sHL7Lines[i].Split('|');
string[] nameList = sList[3].Split('^');
pb.OperNo = nameList[0];
pb.Oname = nameList[1];
}
if (sHL7Lines[i].Contains("AIP|1|"))
{
string[] sList = sHL7Lines[i].Split('|');
string[] osList = sList[3].Split('^');
try
{
pb.OsNo = osList[0];
pb.OS = osList[2];
}
catch (Exception)
{
pb.OsNo = string.Empty;
pb.OS = string.Empty;
}
}
if (sHL7Lines[i].Contains("AIP|7|"))
{
string[] sList = sHL7Lines[i].Split('|');
string[] osList = sList[3].Split('^');
try
{
pb.OA1No = osList[0];
pb.OA1 = osList[2];
}
catch (Exception)
{
pb.OA1No = string.Empty;
pb.OA1 = string.Empty;
}
}
if (sHL7Lines[i].Contains("AIP|8|"))
{
string[] sList = sHL7Lines[i].Split('|');
string[] osList = sList[3].Split('^');
try
{
pb.OA2No = osList[0];
pb.OA2 = osList[2];
}
catch (Exception)
{
pb.OA2No = string.Empty;
pb.OA2 = string.Empty;
}
}
if (sHL7Lines[i].Contains("AIP|9|"))
{
string[] sList = sHL7Lines[i].Split('|');
string[] osList = sList[3].Split('^');
try
{
pb.OA3No = osList[0];
pb.OA3 = osList[2];
}
catch (Exception)
{
pb.OA3No = string.Empty;
pb.OA3 = string.Empty;
}
}
}
#endregion
return(pb);
}