/// <summary>
/// /获取记录单数据集
/// </summary>
/// <returns></returns>
public DataSet GetNusersRecords(ref string diagnose)
{
try
{
ShowDatas(ref diagnose);
//日期
string TempDate = null;
//时间
string time = null;
//RefleshEnterLines();
Class_Nurse_records[] Nusers_objs = new Class_Nurse_records[nusers_Print.Count];
for (int i = 0; i < nusers_Print.Count; i++)
{
Nusers_objs[i] = new Class_Nurse_records();
Nusers_objs[i] = (Class_Nurse_records)nusers_Print[i];
Nusers_objs[i].Age = Convert.ToString(i / 11);
}
DataSet ds = App.ObjectArrayToDataSet(Nusers_objs);
return(ds
);
}
catch
{
return(null);
}
}
//打印显示表格数据
public void ShowDatas(ref string diagnose)
{
//清空Nusers集合中的数据
nusers_Print.Clear();
string date = dtpDate.Value.ToString("yyyy-MM-dd");
string sql_set = "select to_char(t.measure_time,'yyyy-mm-dd') as DATEVAL,to_char(t.measure_time,'hh24:mi:ss.ff9') as TIMERVAR,t.item_code,a.item_name,a.item_attribute,t.item_value,t.c_state,t.other_name,a.item_type,t.status_measure,t.creat_id,d.user_name,t.diagnose_name from t_nurse_record t " +
" left join t_nurse_record_dict a on a.item_code=t.item_code left join T_DATA_CODE b on a.item_attribute=b.id inner " +
" join T_ACCOUNT_USER c on t.creat_id=c.account_id inner join T_USERINFO d on d.user_id=c.user_id where RECORD_TYPE in ('D',null) and patient_Id=" + cboPatientName.SelectedValue.ToString() + " and to_char(t.measure_time,'yyyy-MM-dd')='" + date + "' order by t.measure_time asc";//" order by t.measure_time asc";
string sql_time = "select distinct to_char(t.measure_time,'yyyy-mm-dd') as DATEVAL,to_char(t.measure_time,'hh24:mi:ss.ff9') as TIMERVAR from t_nurse_record t where RECORD_TYPE in ('D',null) and t.patient_Id=" + cboPatientName.SelectedValue.ToString() + " order by DATEVAL,TIMERVAR";
//时间集合
DataSet ds_time_sets = App.GetDataSet(sql_time);
DataSet ds_value_sets = App.GetDataSet(sql_set);
DataTable dt_time = ds_time_sets.Tables[0];
DataTable dt_sets = ds_value_sets.Tables[0];
if (dt_sets.Rows[0]["diagnose_name"] != null)
{
diagnose = dt_sets.Rows[0]["diagnose_name"].ToString();
}
if (dt_time != null)
{
for (int i = 0; i < dt_time.Rows.Count; i++)
{
string DateVale = Convert.ToDateTime(dt_time.Rows[i]["DATEVAL"].ToString()).ToString("yyyy-MM-dd");
string TimeValue = dt_time.Rows[i]["TIMERVAR"].ToString();
//危重的相关记录集合
DataRow[] dt_sets_rows_byconditions = dt_sets.Select("DATEVAL='" + DateVale + "' and TIMERVAR='" + TimeValue + "'");
//入量
DataRow[] inrows = dt_sets.Select("item_type=96 and DATEVAL='" + DateVale + "' and TIMERVAR='" + TimeValue + "'");
//出量
DataRow[] outrows = dt_sets.Select("item_type=97 and DATEVAL='" + DateVale + "' and TIMERVAR='" + TimeValue + "'");
//吸氧
DataRow[] oxygenrows = dt_sets.Select("item_type=927 and DATEVAL='" + DateVale + "' and TIMERVAR='" + TimeValue + "'");
//管路情况
DataRow[] gulurows = dt_sets.Select("item_type=932 and DATEVAL='" + DateVale + "' and TIMERVAR='" + TimeValue + "'");
//计算食品药品吸氧管路情况哪个输入的数量最多
int maxrow = MaxRowCount(inrows.Length, outrows.Length, oxygenrows.Length, gulurows.Length);
if (maxrow == 0)
{
maxrow = 1;
}
for (int k = 0; k < maxrow; k++)
{
Class_Nurse_records temp = new Class_Nurse_records();
temp.Date = DateVale;
temp.Time = TimeValue;
//非多例项
if (k == 0)
{
//入量
if (k < inrows.Length && inrows.Length > 0)
{
if (inrows[k]["other_name"].ToString() != "")
{
temp.R_item_name = inrows[k]["other_name"].ToString();
temp.R_item_count = inrows[k]["item_value"].ToString();
}
else
{
temp.R_item_name = inrows[k]["item_name"].ToString();
temp.R_item_count = inrows[k]["item_value"].ToString();
}
}
//出量
if (k < outrows.Length && outrows.Length > 0)
{
if (outrows[k]["other_name"].ToString() != "")
{
//temp.C_item_name = outrows[k]["other_name"].ToString();
//temp.C_item_count = outrows[k]["item_value"].ToString();
}
else
{
//temp.C_item_name = outrows[k]["item_name"].ToString();
//temp.C_item_count = outrows[k]["item_value"].ToString();
}
}
for (int j = 0; j < dt_sets_rows_byconditions.Length; j++)
{
if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "体温")
{
temp.Temperature = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
else if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "意识")
{
//temp.Idea = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
else if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "脉搏")
{
temp.Pulse = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
else if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "呼吸")
{
temp.Breathe = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
else if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "血氧饱和度")
{
temp.Bp_saturation = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
else if (dt_sets_rows_byconditions[j]["item_name"].ToString() == "血压")
{
temp.Blood_pressure = dt_sets_rows_byconditions[j]["item_value"].ToString();
}
temp.Pathograhy = dt_sets_rows_byconditions[j]["status_measure"].ToString();
temp.Signature = dt_sets_rows_byconditions[j]["user_name"].ToString();
}
}
else
{
//入量
if (k < inrows.Length && inrows.Length > 0)
{
if (inrows[k]["other_name"].ToString() != "")
{
temp.R_item_name = inrows[k]["other_name"].ToString();
temp.R_item_count = inrows[k]["item_value"].ToString();
}
else
{
temp.R_item_name = inrows[k]["item_name"].ToString();
temp.R_item_count = inrows[k]["item_value"].ToString();
}
}
//出量
if (k < outrows.Length && outrows.Length > 0)
{
if (outrows[k]["other_name"].ToString() != "")
{
//temp.C_item_name = outrows[k]["other_name"].ToString();
//temp.C_item_count = outrows[k]["item_value"].ToString();
//temp.C_state = outrows[k]["c_state"].ToString();
}
else
{
//temp.C_item_name = outrows[k]["item_name"].ToString();
//temp.C_item_count = outrows[k]["item_value"].ToString();
//temp.C_state = outrows[k]["c_state"].ToString();
}
}
}
temp.Date = Valite(temp.Date);
temp.Temperature = Valite(temp.Temperature);
temp.Pulse = Valite(temp.Pulse);
temp.Breathe = Valite(temp.Breathe);
temp.Blood_pressure = Valite(temp.Blood_pressure);
//病情记录
temp.Pathograhy = App.ToSBC(Valite(temp.Pathograhy));
temp.Bp_saturation = Valite(temp.Bp_saturation);
//temp.Pupil_left = Valite(temp.Pupil_left);
//temp.Pupil_right = Valite(temp.Pupil_right);
temp.R_item_name = Valite(temp.R_item_name);
temp.R_item_count = Valite(temp.R_item_count);
//temp.C_item_name = Valite(temp.C_item_name);
//temp.C_item_count = Valite(temp.C_item_count);
temp.Time = StringFormat(temp.Time);
nusers_Print.Add(temp);
}
}
}
}
