public string CancelDownMachine(string strDialysisDate, string strCardId)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(strDialysisDate, strCardId);
if (model.DIALYSISSTATE == "0" || model.DIALYSISSTATE == "1")
{
return("该患者还未进行上机操作！");
}
else if (model.DIALYSISSTATE == "5")
{
return("该患者已总审，不允许再进行取消下机操作！");
}
model.DIALYSISSTATE = "2";
model.DOWNMACHINESTATE = "0";
model.DOWNMACHINENURSEID = "";
model.DOWNMACHINENURSENAME = "";
if (this.NurseDetailLogic.DownMachine(model, model.DOWNMACHINENURSEID, model.DOWNMACHINENURSENAME) < 0)
{
return("患者取消下机失败！");
}
else
{
this.NurseDetailLogic.UpdateDialysisAppointplan(model);
strReturn = "取消下机成功！";
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "CancelDownMachine", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
/// <summary>
/// 透析患者上机操作
/// </summary>
/// <param name="model"></param>
/// <param name="strUpMachineNurseId"></param>
/// <param name="strUpMachineNurseName"></param>
/// <returns></returns>
public int UpMachine(HdisModels.Nurse.NurseDetail model, string strUpMachineNurseId, string strUpMachineNurseName)
{
string sql = string.Empty;
sql = @"insert into hdis_nur_detail (cardid,seqid,testdate,dialysisstate,departmentid,departmentname,areaid,areaname,
patientid,bedid,bedname,machineid,machinename,upmachinetime,upmachinenurseid,upmachinenursename,upmachinestate,classes)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',sysdate,'{13}','{14}','{15}','{16}')";
try
{
sql = string.Format(sql, model.CARDID, model.SEQID, model.TESTDATE, model.DIALYSISSTATE, model.Patient.DEPARTMENTID, model.Patient.DEPARTMENTNAME,
model.AREAID, model.AREANAME, model.Patient.PATIENTID, model.BEDID, model.BEDNAME, model.MACHINEID,
model.MACHINENAME, strUpMachineNurseId, strUpMachineNurseName, model.UPMACHINESTATE, model.CLASSES);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
public string ConfirmDialysisEnd(string cardId, string testDate, string strDialysisSummary)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(testDate, cardId);
if (model.DIALYSISSTATE != "3")
{
return("该患者非透析后患者无法确认！");
}
HdisModels.Nurse.NurseDetail nurseDetail = new HdisModels.Nurse.NurseDetail();
nurseDetail = this.NurseDetailLogic.GetDialysisSummary(testDate, cardId);
if (nurseDetail != null)
{
string[] afterInfo = { nurseDetail.DIALYSISSUMMARY, nurseDetail.TREATMENTDURATION, nurseDetail.DoctorDetail.FACTSFILTRATIONQUANTITY, nurseDetail.DoctorDetail.AFTERWEIGHT, nurseDetail.LESSENWEIGHT, nurseDetail.DoctorDetail.TEMPERATURE, nurseDetail.DoctorDetail.PULSE, nurseDetail.DoctorDetail.SPRESSURE, nurseDetail.DoctorDetail.DPRESSURE, nurseDetail.DoctorDetail.BREATHING, nurseDetail.HEARTRATE };
for (int i = 0; i < afterInfo.Length; i++)
{
if (afterInfo[i] == "")
{
return("请填写完整透后记录并保存");
}
}
}
if (QueryPuntureNurse(cardId, testDate) == "")
{
return("请填写完整透后记录并保存");
}
if (QueryTreamentNurse(cardId, testDate) == "")
{
return("请填写完整透后记录并保存");
}
this.NurseDetailLogic.EditNurConfirmState(cardId, testDate);
this.NurseDetailLogic.EditAppointConfirmState(cardId, testDate);
this.DoctorDetailLogic.EditDocConfirmState(cardId, testDate);
string[] itemInfo = strDialysisSummary.Split('|');
model.UPMACHINENURSENAME = NurseDetailLogic.QueryUpMachineNurseName(cardId, testDate);
model.TREATMENTDURATION = itemInfo[0];
model.FACTSFILTRATIONQUANTITY = itemInfo[1];
model.AFTERWEIGHT = itemInfo[2];
model.LESSENWEIGHT = itemInfo[3];
model.DoctorDetail.TEMPERATURE = itemInfo[4];
model.DoctorDetail.PULSE = itemInfo[5];
model.HEARTRATE = itemInfo[6];
model.DoctorDetail.BREATHING = itemInfo[7];
model.DoctorDetail.SPRESSURE = itemInfo[8];
model.DoctorDetail.DPRESSURE = itemInfo[9];
model.DIALYSISSUMMARY = itemInfo[10];
this.PrintPatAfterInfo.SavePatResult(model);
strReturn = "成功确认！";
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "confirmDialysisEnd", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
public string DownMachine(string strDialysisDate, string strCardId, string strDownMachineNurseId, string strDownMachineNurseName)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(strDialysisDate, strCardId);
if (model.DIALYSISSTATE == "0" || model.DIALYSISSTATE == "1")
{
return("该患者还未进行上机操作！");
}
else if (model.DIALYSISSTATE == "3")
{
return("该患者已进行过下机操作！");
}
else if (model.DIALYSISSTATE == "4" || model.DIALYSISSTATE == "5")
{
return("该患者已完成透析，不允许再进行下机操作！");
}
model.DIALYSISSTATE = "3";
model.DOWNMACHINESTATE = "1";
if (this.NurseDetailLogic.DownMachine(model, strDownMachineNurseId, strDownMachineNurseName) < 0)
{
return("患者下机失败！");
}
else
{
this.NurseDetailLogic.UpdateDialysisAppointplan(model);
strReturn = "下机成功！";
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "DownMachine", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
public string SavePuntureAndTreamentNurse(string CARDID, string TESTDATE, string PUNCTURENURSE, string TREAMENTNURSE, string OPERATETIME)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(TESTDATE, CARDID);
if (model.DIALYSISSTATE == "4")
{
strReturn = "保存失败，该患者已被护士确认！";
return(strReturn);
}
else if (model.DIALYSISSTATE == "5")
{
strReturn = "保存失败，该患者已总审！";
return(strReturn);
}
if (PersonLogic.SavePuntureAndTreamentNurse(CARDID, TESTDATE, PUNCTURENURSE, TREAMENTNURSE, OPERATETIME) == -1)
{
strReturn = "保存失败";
}
else
{
strReturn = "保存成功";
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "SavePuntureAndTreamentNurse", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
/// <summary>
/// XML透后护士记录
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static string DialysisSummaryForXml(HdisModels.Nurse.NurseDetail nurDetail)
{
string strReturn = string.Empty;
using (System.IO.StringWriter stringWriter = new StringWriter(new StringBuilder()))
{
XmlSerializer xmlSerializer = new XmlSerializer(typeof(HdisModels.Nurse.NurseDetail));
xmlSerializer.Serialize(stringWriter, nurDetail);
strReturn = stringWriter.ToString();
}
return(strReturn);
}
public string QueryBaseInfo(string cardId, string testDate)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(testDate, cardId);
strReturn = HdisCommon.Fuction.BaseInfoForXml(model);
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "QueryBaseInfo", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
public string SaveDialysisSummary(string strDialysisDate, string strCardId, string strDialysisSummary)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail model = new HdisModels.Nurse.NurseDetail();
model = this.NurseDetailLogic.QueryCurrentPatientInfo(strDialysisDate, strCardId);
if (model.DIALYSISSTATE == "0" || model.DIALYSISSTATE == "1")
{
strReturn = "保存失败，该患者还未进行透析操作！";
return(strReturn);
}
if (model.DIALYSISSTATE == "2")
{
strReturn = "保存失败，该患者还未完成透析操作！";
return(strReturn);
}
if (model.DIALYSISSTATE == "4")
{
strReturn = "保存失败，该患者已被护士确认！";
return(strReturn);
}
else if (model.DIALYSISSTATE == "5")
{
strReturn = "保存失败，该患者已总审，不允许再填写透后记录！";
return(strReturn);
}
string[] itemInfo = strDialysisSummary.Split('|');
model.TREATMENTDURATION = itemInfo[0];
model.FACTSFILTRATIONQUANTITY = itemInfo[1];
model.AFTERWEIGHT = itemInfo[2];
model.LESSENWEIGHT = itemInfo[3];
model.DoctorDetail.TEMPERATURE = itemInfo[4];
model.DoctorDetail.PULSE = itemInfo[5];
model.HEARTRATE = itemInfo[6];
model.DoctorDetail.BREATHING = itemInfo[7];
model.DoctorDetail.SPRESSURE = itemInfo[8];
model.DoctorDetail.DPRESSURE = itemInfo[9];
model.DIALYSISSUMMARY = itemInfo[10];
if (this.NurseDetailLogic.SaveDialysisSummary(model) < 0)
{
strReturn = "保存失败！";
}
else
{
strReturn = "保存成功！";
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "SaveDialysisSummary", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
public string QueryDialysisSummary(string testDate, string cardId)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail nurseDatail = new HdisModels.Nurse.NurseDetail();
nurseDatail = this.NurseDetailLogic.GetDialysisSummary(testDate, cardId);
if (nurseDatail != null)
{
strReturn = HdisCommon.Fuction.DialysisSummaryForXml(nurseDatail);
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "QueryDialysisSummary", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
/// <summary>
/// 保存透析小结
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SaveDialysisSummary(HdisModels.Nurse.NurseDetail model)
{
string sql = string.Empty;
sql = @"update hdis_nur_detail a set
a.dialysissummary='{2}',
factsfiltrationquantity ='{3}',
treatmentduration ='{4}',
afterweight ='{5}',
lessenweight ='{6}',
temperature ='{7}',
spressure ='{8}',
dpressure ='{9}',
pulse ='{10}',
breathing ='{11}',
heartrate ='{12}'
where testdate='{0}' and cardid='{1}'";
try
{
sql = string.Format(sql, model.TESTDATE, model.CARDID,
model.DIALYSISSUMMARY,
model.FACTSFILTRATIONQUANTITY,
model.TREATMENTDURATION,
model.AFTERWEIGHT,
model.LESSENWEIGHT,
model.DoctorDetail.TEMPERATURE,
model.DoctorDetail.SPRESSURE,
model.DoctorDetail.DPRESSURE,
model.DoctorDetail.PULSE,
model.DoctorDetail.BREATHING,
model.HEARTRATE
);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch (Exception ex)
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 查询透析小结
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public HdisModels.Nurse.NurseDetail GetDialysisSummary(string TESTDATE, string CARDID)
{
HdisModels.Nurse.NurseDetail nurseDetail = new HdisModels.Nurse.NurseDetail();
string sql = string.Empty;
sql = @"select * from hdis_nur_detail t where t.testdate='{0}' and t.cardid='{1}'";
sql = string.Format(sql, TESTDATE, CARDID);
try
{
if (this.ExecSQLQuery(sql) < 0)
{
return(null);
}
if (this.Reader.Read())
{
nurseDetail.DIALYSISSUMMARY = this.Reader["DIALYSISSUMMARY"].ToString();
nurseDetail.TREATMENTDURATION = this.Reader["TREATMENTDURATION"].ToString();
nurseDetail.DoctorDetail.FACTSFILTRATIONQUANTITY = this.Reader["FACTSFILTRATIONQUANTITY"].ToString();
nurseDetail.DoctorDetail.AFTERWEIGHT = this.Reader["AFTERWEIGHT"].ToString();
nurseDetail.LESSENWEIGHT = this.Reader["LESSENWEIGHT"].ToString();
nurseDetail.DoctorDetail.TEMPERATURE = this.Reader["TEMPERATURE"].ToString();
nurseDetail.DoctorDetail.PULSE = this.Reader["PULSE"].ToString();
nurseDetail.DoctorDetail.SPRESSURE = this.Reader["SPRESSURE"].ToString();
nurseDetail.DoctorDetail.DPRESSURE = this.Reader["DPRESSURE"].ToString();
nurseDetail.DoctorDetail.BREATHING = this.Reader["BREATHING"].ToString();
nurseDetail.HEARTRATE = this.Reader["HEARTRATE"].ToString();
return(nurseDetail);
}
return(null);
}
catch (Exception ex)
{
return(null);
}
finally
{
this.Reader.Close();
this.oracleDb.CloseDB();
}
}
public string AddDialysisRecord(string strDialysisDate, string strCardId, string loginId, string loginName)
{
lock (typeof(HdisService))
{
string strReturn = string.Empty;
HdisModels.Nurse.NurseDetail NurseDetailModel = new HdisModels.Nurse.NurseDetail();
NurseDetailModel = this.NurseDetailLogic.QueryCurrentPatientInfo(strDialysisDate, strCardId);
switch (NurseDetailModel.DIALYSISSTATE)
{
case "0":
case "1":
return("该患者还未开始上机透析，不允许添加透析结果！");
case "2":
{
HdisModels.Proc.ProcResult ProcResult = new HdisModels.Proc.ProcResult();
ProcResult.CARDID = NurseDetailModel.CARDID;
ProcResult.SEQID = NurseDetailModel.SEQID;
ProcResult.TESTDATE = NurseDetailModel.TESTDATE;
ProcResult.RESULTSEQ = ProcResultLogic.GetResultSeq();
ProcResult.BEDID = NurseDetailModel.BEDID;
ProcResult.MACHINEID = NurseDetailModel.MACHINEID;
ProcResult.NURSEID = loginId;
ProcResult.NURSENAME = loginName;
this.ProcResultLogic.SaveDialysisResult(ProcResult);
strReturn = ProcResult.RESULTSEQ;
break;
}
case "3":
case "4":
case "5":
return("该患者已透析，不允许添加透析结果！");
}
HdisCommon.Log.Logging("{0}.{1} ：{2}", "HdisService", "AddDialysisRecord", "strReturn[" + strReturn + "]");
return(strReturn);
}
}
/// <summary>
/// 更新新透析计划时间表
/// hdis_pat_appoint_plan
/// </summary>
/// <param name="model">护士实体</param>
/// <returns></returns>
public int UpdateDialysisAppointplan(HdisModels.Nurse.NurseDetail model)
{
string sql = string.Empty;
sql = @"update hdis_pat_appoint_plan a set a.dialysisstate='{2}' where a.appointdate='{0}' and a.cardid='{1}'";
try
{
sql = string.Format(sql, model.TESTDATE, model.CARDID, model.DIALYSISSTATE);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 透析患者取消上机
/// </summary>
/// <param name="model">护士实体</param>
/// <returns></returns>
public int CancelUpMachine(HdisModels.Nurse.NurseDetail model)
{
string sql = string.Empty;
sql = @"delete hdis_nur_detail where testdate='{0}' and cardid='{1}'";
try
{
sql = string.Format(sql, model.TESTDATE, model.CARDID);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 透析患者下机
/// 透析患者取消下机
/// </summary>
/// <param name="model">护士主表实体</param>
/// <param name="strNurseId">操作护士编码</param>
/// <param name="strNurseName">操作护士名称</param>
/// <returns></returns>
public int DownMachine(HdisModels.Nurse.NurseDetail model, string strNurseId, string strNurseName)
{
string sql = string.Empty;
sql = @"update hdis_nur_detail a set a.downmachinestate= '{2}',a.downmachinenurseid= '{3}',a.downmachinenursename= '{4}',
a.dialysisstate= '{5}',a.downmachinetime= sysdate where testdate='{0}' and cardid='{1}'";
try
{
sql = string.Format(sql, model.TESTDATE, model.CARDID, model.DOWNMACHINESTATE, strNurseId, strNurseName, model.DIALYSISSTATE);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 保存透析小结
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int SavePatResult(HdisModels.Nurse.NurseDetail model)
{
string sql = string.Empty;
sql = @"insert into HDIS_PRINT_AFTERINFO(
AFTERCARDID,
AFTERSEQID,
AFTERTESTDATE,
AFTERDIALYSISSTATE,
AFTERAREANAME,
AFTERPATIENTID,
AFTERMEMO,
AFTERBEDID,
AFTERBEDNAME,
AFTERMACHINEID,
AFTERMACHINENAME,
AFTERUPMACHINETIME,
AFTERUPMACHINESTATE,
AFTERDOWNMACHINETIME,
AFTERDOWNMACHINESTATE,
AFTERUPMACHINENURSEID,
AFTERUPMACHINENURSENAME,
AFTERDOWNMACHINENURSEID,
AFTERDOWNMACHINENURSENAME,
AFTERCLASSES,
AFTERDIALYSISSUMMARY,
AFTERAFTERWEIGHT,
AFTERFACTSFILTRATIONQUANTITY,
AFTERTREATMENTDURATION,
AFTERLESSENWEIGHT,
AFTERTEMPERATURE,
AFTERSPRESSURE,
AFTERDPRESSURE,
AFTERPULSE,
AFTERBREATHING,
AFTERHEARTRATE
)
values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',to_date('{11}','yyyy-MM-dd hh24:mi:ss'),'{12}',to_date('{13}','yyyy-MM-dd hh24:mi:ss'),'{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}')";
try
{
sql = string.Format(sql,
model.CARDID,
model.SEQID,
model.TESTDATE,
model.DIALYSISSTATE,
model.AREANAME,
model.Patient.PATIENTID,
model.MEMO,
model.BEDID,
model.BEDNAME,
model.MACHINEID,
model.MACHINENAME,
model.UPMACHINETIME,
model.UPMACHINESTATE,
model.DOWNMACHINETIME,
model.DOWNMACHINESTATE,
model.UPMACHINENURSEID,
model.UPMACHINENURSENAME,
model.DOWNMACHINENURSEID,
model.DOWNMACHINENURSENAME,
model.CLASSES,
model.DIALYSISSUMMARY,
model.AFTERWEIGHT,
model.FACTSFILTRATIONQUANTITY,
model.TREATMENTDURATION,
model.LESSENWEIGHT,
model.DoctorDetail.TEMPERATURE,
model.DoctorDetail.SPRESSURE,
model.DoctorDetail.DPRESSURE,
model.DoctorDetail.PULSE,
model.DoctorDetail.BREATHING,
model.HEARTRATE
);
if (this.ExecSQL(sql) == -1)
{
return(-1);
}
return(1);
}
catch (Exception ex)
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 通过透析日期查询当日的透析患者列表
/// </summary>
/// <param name="strTestDate"></param>
/// <returns></returns>
public List <HdisModels.Nurse.NurseDetail> QueryPatientListByTestDate(string strTestDate, string strSigninState)
{
List <HdisModels.Nurse.NurseDetail> list = new List <HdisModels.Nurse.NurseDetail>();
HdisModels.Nurse.NurseDetail model = null;
string sql = string.Empty;
sql = @"select * from hdis_pat_appoint_plan a
left join hdis_pat_patientinfo b on a.cardid = b.cardid
where a.appointdate = '{0}' and (a.signinstate = '{1}' or '{1}'='ALL') order by a.maketime";
sql = string.Format(sql, strTestDate, strSigninState);
try
{
if (this.ExecSQLQuery(sql) == -1)
{
return(list);
}
while (this.Reader.Read())
{
model = new HdisModels.Nurse.NurseDetail();
model.CARDID = this.Reader["CARDID"].ToString();
model.SEQID = this.Reader["CARDID"].ToString() + this.DialysisSeqFillZero(this.Reader["DIALYSISTIMES"].ToString());
try
{
model.TESTDATE = Convert.ToDateTime(this.Reader["APPOINTDATE"]).ToString("yyyy-MM-dd");
}
catch
{ }
model.DIALYSISSTATE = this.Reader["DIALYSISSTATE"].ToString();
model.Patient.PATIENTID = this.Reader["PATIENTID"].ToString();
model.Patient.PATIENTNAME = this.Reader["PATIENTNAME"].ToString();
model.Patient.PATIENTSEX = this.Reader["PATIENTSEX"].ToString();
model.Patient.PATIENTAGE = this.Reader["PATIENTAGE"].ToString();
model.Patient.PATIENTTYPE = this.Reader["PATIENTTYPE"].ToString();
try
{
model.Patient.FIRSTDATE = DateTime.Parse(this.Reader["FIRSTDATE"].ToString());
}
catch
{ }
model.Patient.TELPHONE = this.Reader["TELPHONE"].ToString();
model.Patient.CELLPHONE = this.Reader["CELLPHONE"].ToString();
model.Patient.ADDRESS = this.Reader["ADDRESS"].ToString();
model.Patient.ABOBLOODTYPE = this.Reader["ABOBLOODTYPE"].ToString();
model.Patient.RHBLOODTYPE = this.Reader["RHBLOODTYPE"].ToString();
model.Patient.MEDICARETYPE = this.Reader["MEDICARETYPE"].ToString();
model.Patient.IDCARD = this.Reader["IDCARD"].ToString();
model.Patient.NATIONAL = this.Reader["NATIONAL"].ToString();
model.Patient.NATIVEPLACE = this.Reader["NATIVEPLACE"].ToString();
model.Patient.COMPANY = this.Reader["COMPANY"].ToString();
model.Patient.CCANDHPI = this.Reader["CCANDHPI"].ToString();
model.Patient.PASTHISTORY = this.Reader["PASTHISTORY"].ToString();
model.Patient.ALLERGIES = this.Reader["ALLERGIES"].ToString();
model.Patient.FAMILYHISTORY = this.Reader["FAMILYHISTORY"].ToString();
model.Patient.HOSPITALAREAID = this.Reader["HOSPITALAREAID"].ToString();
model.Patient.HOSPITALAREANAME = this.Reader["HOSPITALAREANAME"].ToString();
model.Patient.DEPARTMENTID = this.Reader["DEPARTMENTID"].ToString();
model.Patient.DEPARTMENTNAME = this.Reader["DEPARTMENTNAME"].ToString();
model.Patient.SPECIALPATIENTTYPE = this.Reader["SPECIALPATIENTTYPE"].ToString();
model.SIGNINSTATE = this.Reader["SIGNINSTATE"].ToString();
model.AREAID = this.Reader["AREAID"].ToString();
model.AREANAME = this.Reader["AREANAME"].ToString();
model.BEDID = this.Reader["BEDID"].ToString();
model.BEDNAME = this.Reader["BEDNAME"].ToString();
model.CLASSES = this.Reader["CLASSES"].ToString();
model.DIALYSISMODE = this.Reader["DIALYSISMODE"].ToString();
model.DIALYZER = this.Reader["DIALYZER"].ToString();
list.Add(model);
}
return(list);
}
catch
{
return(list);
}
finally
{
this.oracleDb.CloseReader();
this.oracleDb.CloseDB();
}
}
/// <summary>
/// 通过透析号查询当前患者信息
/// </summary>
/// <param name="strTestDate">预约时间/透析时间</param>
/// <param name="strCardId">透析号</param>
/// <returns></returns>
public HdisModels.Nurse.NurseDetail QueryCurrentPatientInfo(string strTestDate, string strCardId)
{
HdisModels.Nurse.NurseDetail model = null;
string sql = string.Empty;
sql = @"select b.dialysistimes as dialysistimes_real,a.*,b.*,C.*,d.machineid as Machineid1,d.machinename as machinename1 from hdis_pat_appoint_plan a
left join hdis_pat_patientinfo b on a.cardid = b.cardid
left join hdis_nur_detail c on a.cardid=c.cardid and a.appointdate=c.testdate
,hdis_com_bedandmachine d
where a.bedid=d.bedid and a.appointdate = '{0}' and a.cardid='{1}'";
sql = string.Format(sql, strTestDate, strCardId);
try
{
if (this.ExecSQLQuery(sql) < 0)
{
return(null);
}
if (this.Reader.Read())
{
model = new HdisModels.Nurse.NurseDetail();
model.CARDID = this.Reader["CARDID"].ToString();
model.SEQID = this.Reader["CARDID"].ToString() + this.DialysisSeqFillZero(this.Reader["DIALYSISTIMES_REAL"].ToString());
try
{
model.TESTDATE = Convert.ToDateTime(this.Reader["APPOINTDATE"]).ToString("yyyy-MM-dd");
}
catch
{ }
model.DIALYSISSTATE = this.Reader["DIALYSISSTATE"].ToString();
model.Patient.PATIENTID = this.Reader["PATIENTID"].ToString();
model.Patient.PATIENTNAME = this.Reader["PATIENTNAME"].ToString();
model.Patient.PATIENTSEX = this.Reader["PATIENTSEX"].ToString();
model.Patient.PATIENTAGE = this.Reader["PATIENTAGE"].ToString();
model.Patient.PATIENTTYPE = this.Reader["PATIENTTYPE"].ToString();
try
{
model.Patient.FIRSTDATE = DateTime.Parse(this.Reader["FIRSTDATE"].ToString());
}
catch
{ }
model.Patient.TELPHONE = this.Reader["TELPHONE"].ToString();
model.Patient.CELLPHONE = this.Reader["CELLPHONE"].ToString();
model.Patient.ADDRESS = this.Reader["ADDRESS"].ToString();
model.Patient.ABOBLOODTYPE = this.Reader["ABOBLOODTYPE"].ToString();
model.Patient.RHBLOODTYPE = this.Reader["RHBLOODTYPE"].ToString();
model.Patient.MEDICARETYPE = this.Reader["MEDICARETYPE"].ToString();
model.Patient.IDCARD = this.Reader["IDCARD"].ToString();
model.Patient.NATIONAL = this.Reader["NATIONAL"].ToString();
model.Patient.NATIVEPLACE = this.Reader["NATIVEPLACE"].ToString();
model.Patient.COMPANY = this.Reader["COMPANY"].ToString();
model.Patient.CCANDHPI = this.Reader["CCANDHPI"].ToString();
model.Patient.PASTHISTORY = this.Reader["PASTHISTORY"].ToString();
model.Patient.ALLERGIES = this.Reader["ALLERGIES"].ToString();
model.Patient.FAMILYHISTORY = this.Reader["FAMILYHISTORY"].ToString();
model.Patient.HOSPITALAREAID = this.Reader["HOSPITALAREAID"].ToString();
model.Patient.HOSPITALAREANAME = this.Reader["HOSPITALAREANAME"].ToString();
model.Patient.DEPARTMENTID = this.Reader["DEPARTMENTID"].ToString();
model.Patient.DEPARTMENTNAME = this.Reader["DEPARTMENTNAME"].ToString();
model.Patient.SPECIALPATIENTTYPE = this.Reader["SPECIALPATIENTTYPE"].ToString();
model.AREAID = this.Reader["AREAID"].ToString();
model.AREANAME = this.Reader["AREANAME"].ToString();
model.BEDID = this.Reader["BEDID"].ToString();
model.BEDNAME = this.Reader["BEDNAME"].ToString();
model.CLASSES = this.Reader["CLASSES"].ToString();
model.DIALYSISMODE = this.Reader["DIALYSISMODE"].ToString();
model.DIALYZER = this.Reader["DIALYZER"].ToString();
model.MACHINEID = this.Reader["machineid1"].ToString();
model.MACHINENAME = this.Reader["machinename1"].ToString();
model.SIGNINSTATE = this.Reader["signinstate"].ToString();
}
return(model);
}
catch
{
return(null);
}
finally
{
this.oracleDb.CloseReader();
this.oracleDb.CloseDB();
}
}
