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