/// <summary> /// 取出一个时间点下相关病人集合的所有体温单相关节点记录 /// </summary> /// <param name="Table"></param> /// <param name="datatype"></param> /// <param name="nodename"></param> /// <param name="patientids"></param> /// <returns></returns> public Hashtable QueryDataStoreVitalSignByAllIndex1Data(string Table, string datatype, string nodename, string patientids, string recorddate) { Hashtable DataStoreVitalSignHashtable = new Hashtable(); string strSql = ""; if (this.Sql.GetSql("Management.DataFile.QueryDataStoreVitalSignByAllIndex1Data", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, Table, datatype, nodename, patientids, recorddate); } catch { this.Err = "参数传入错误!"; return(null); } if (this.ExecQuery(strSql) == -1) { return(null); } Neusoft.HISFC.Models.Nurse.DataStoreVitalSign DataStoreVitalSign = null; while (this.Reader.Read()) { DataStoreVitalSign = new Neusoft.HISFC.Models.Nurse.DataStoreVitalSign(); DataStoreVitalSign.NodeName = this.Reader[0].ToString(); DataStoreVitalSign.NodeValue = this.Reader[1].ToString(); DataStoreVitalSign.RecordDate = (DateTime)this.Reader[2]; DataStoreVitalSign.Index1 = this.Reader[3].ToString(); //将得到的列表进行数据整理 if (DataStoreVitalSignHashtable.ContainsKey(DataStoreVitalSign.Index1)) { ArrayList DataStoreVitalSignArrayList = (ArrayList)DataStoreVitalSignHashtable[DataStoreVitalSign.Index1]; DataStoreVitalSignArrayList.Add(DataStoreVitalSign); DataStoreVitalSignHashtable[DataStoreVitalSign.Index1] = DataStoreVitalSignArrayList; } else { ArrayList DataStoreVitalSignArrayListnew = new ArrayList(); DataStoreVitalSignArrayListnew.Add(DataStoreVitalSign); DataStoreVitalSignHashtable[DataStoreVitalSign.Index1] = DataStoreVitalSignArrayListnew; } } this.Reader.Close(); return(DataStoreVitalSignHashtable); }
/// <summary> /// 取出此病人的所有体温单数据 /// </summary> /// <param name="Table"></param> /// <param name="datatype"></param> /// <param name="inpatientNo"></param> /// <returns></returns> public Hashtable QueryDataStoreVitalSignByIndex1(string Table, string datatype, string inpatientNo) { Hashtable DataStoreVitalSignHashTable = new Hashtable(); string strSql = ""; if (this.Sql.GetSql("Management.DataFile.QueryDataStoreVitalSignByIndex1", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, Table, datatype, inpatientNo); } catch { this.Err = "参数传入错误!"; return(null); } if (this.ExecQuery(strSql) == -1) { return(null); } Neusoft.HISFC.Models.Nurse.DataStoreVitalSign DataStoreVitalSign = null; ArrayList recordDateList = new ArrayList(); ArrayList AllDateList = new ArrayList(); while (this.Reader.Read()) { DataStoreVitalSign = new Neusoft.HISFC.Models.Nurse.DataStoreVitalSign(); DataStoreVitalSign.NodeName = this.Reader[0].ToString(); DataStoreVitalSign.NodeValue = this.Reader[1].ToString(); DataStoreVitalSign.RecordDate = (DateTime)this.Reader[2]; if (DataStoreVitalSign.NodeName == "检查时间") { recordDateList.Add(DataStoreVitalSign.RecordDate); } AllDateList.Add(DataStoreVitalSign); } this.Reader.Close(); DataStoreVitalSignHashTable.Add("AllDateList", AllDateList); DataStoreVitalSignHashTable.Add("recordDateList", recordDateList); return(DataStoreVitalSignHashTable); }
/// <summary> /// 数据库中取出病人集合的所有记录时间记录 /// </summary> /// <param name="Table"></param> /// <param name="datatype"></param> /// <param name="nodename"></param> /// <param name="patientids"></param> /// <returns></returns> public ArrayList QueryDataStoreVitalSignByRecordDate(string Table, string datatype, string nodename, string patientids) { ArrayList DataStoreVitalSignArrayList = new ArrayList(); string strSql = ""; if (this.Sql.GetSql("Management.DataFile.QueryDataStoreVitalSignByRecordDate", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, Table, datatype, nodename, patientids); } catch { this.Err = "参数传入错误!"; return(null); } if (this.ExecQuery(strSql) == -1) { return(null); } Neusoft.HISFC.Models.Nurse.DataStoreVitalSign DataStoreVitalSign = null; while (this.Reader.Read()) { DataStoreVitalSign = new Neusoft.HISFC.Models.Nurse.DataStoreVitalSign(); DataStoreVitalSign.NodeName = this.Reader[0].ToString(); DataStoreVitalSign.NodeValue = this.Reader[1].ToString(); DataStoreVitalSign.RecordDate = (DateTime)this.Reader[2]; DataStoreVitalSignArrayList.Add(DataStoreVitalSign); } this.Reader.Close(); return(DataStoreVitalSignArrayList); }