/// <summary>
/// 查询透析结果
/// </summary>
/// <param name="model">患者基本信息实体</param>
/// <returns></returns>
public List <HdisModels.Proc.ProcResult> QueryDialysisResultList(string cardid, string testdate)
{
List <HdisModels.Proc.ProcResult> list = new List <HdisModels.Proc.ProcResult>();
HdisModels.Proc.ProcResult model = null;
string sql = string.Empty;
sql = @"select * from hdis_proc_result a where a.cardid='{0}' and a.testdate='{1}' order by a.resultseq";
try
{
sql = string.Format(sql, cardid, testdate);
if (this.ExecSQLQuery(sql) < 0)
{
return(null);
}
while (this.Reader.Read())
{
model = new HdisModels.Proc.ProcResult();
model.CARDID = this.Reader["CARDID"].ToString();
model.TESTDATE = this.Reader["TESTDATE"].ToString();
model.SEQID = this.Reader["SEQID"].ToString();
model.RESULTSEQ = this.Reader["RESULTSEQ"].ToString();
model.BEDID = this.Reader["BEDID"].ToString();
model.MACHINEID = this.Reader["MACHINEID"].ToString();
model.SPO2 = this.Reader["SPO2"].ToString();
model.SPRESSURE = this.Reader["SPRESSURE"].ToString();
model.DPRESSURE = this.Reader["DPRESSURE"].ToString();
model.PULSE = this.Reader["PULSE"].ToString();
model.HEPARIN = this.Reader["HEPARIN"].ToString();
model.BLOODFOLW = this.Reader["BLOODFOLW"].ToString();
model.ARTERIALPRESSURE = this.Reader["ARTERIALPRESSURE"].ToString();
model.VENOUSPRESSURE = this.Reader["VENOUSPRESSURE"].ToString();
model.TRANSMEMBRANEPRESSURE = this.Reader["TRANSMEMBRANEPRESSURE"].ToString();
model.ULTRAFILTRATIONVOLUME = this.Reader["ULTRAFILTRATIONVOLUME"].ToString();
model.RESULTTIME = Convert.ToDateTime(this.Reader["RESULTTIME"]);
model.NURSEID = this.Reader["NURSEID"].ToString();
model.NURSENAME = this.Reader["NURSENAME"].ToString();
list.Add(model);
}
return(list);
}
catch (Exception ex)
{
return(list);
}
finally
{
this.oracleDb.CloseReader();
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>
/// 保存透析结果行
/// </summary>
/// <param name="model">透析结果实体</param>
/// <returns></returns>
public int SaveDialysisResult(HdisModels.Proc.ProcResult model)
{
string sql = string.Empty;
sql = @"insert into hdis_proc_result(cardid,testdate,seqid,resultseq,bedid,machineid,nurseid,nursename,resulttime) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',to_date('{8}','yyyy-MM-dd hh24:mi:ss'))";
try
{
sql = string.Format(sql, model.CARDID, model.TESTDATE, model.SEQID,
model.RESULTSEQ, model.BEDID, model.MACHINEID, model.NURSEID, model.NURSENAME, model.RESULTTIME);
if (this.ExecSQL(sql) < 0)
{
return(-1);
}
return(1);
}
catch
{
return(-1);
}
finally
{
this.oracleDb.CloseDB();
}
}
