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