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