/// <summary> /// 打印 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPrint_Click(object sender, EventArgs e) { string sql = "select to_char(t.record_time,'yyyy-mm-dd') as 日期,to_char(t.record_time,'HH24:mi') as 时间,t.heart_val as 心电示波值,t.bz as 心电示波情况,t.sing_name as 签字 from t_heart_pic t where t.pid='" + pid + "'"; DataSet ds = App.GetDataSet(sql); DataSet dss = new DataSet(); if (ds != null) { ArrayList lists = new ArrayList(); lists.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Class_Heart_PIC hpic = new Class_Heart_PIC(); hpic.Date = ds.Tables[0].Rows[i]["日期"].ToString(); hpic.Time = ds.Tables[0].Rows[i]["时间"].ToString(); hpic.Value_val = ds.Tables[0].Rows[i]["心电示波值"].ToString(); hpic.BZ = ds.Tables[0].Rows[i]["心电示波情况"].ToString(); hpic.Create_Name = ds.Tables[0].Rows[i]["签字"].ToString(); lists.Add(hpic); } Class_Heart_PIC[] PIC_obj = new Class_Heart_PIC[lists.Count]; for (int j = 0; j < lists.Count; j++) { PIC_obj[j] = new Class_Heart_PIC(); PIC_obj[j] = (Class_Heart_PIC)lists[j]; } dss = App.ObjectArrayToDataSet(PIC_obj); } frmHeart_PIC_Print pic = new frmHeart_PIC_Print(dss, pname, p_section, bed_no, pid, ""); pic.ShowDialog(); }
private void refersh() { string sql = "select to_char(t.record_time,'yyyy-mm-dd') as 日期,to_char(t.record_time,'HH24:mi') as 时间,t.heart_val as 结果值,t.sing_name as 签名,t.bz as 心电示波情况 from t_heart_pic t where t.pid='" + pid + "'order by t.record_time"; DataSet ds = App.GetDataSet(sql); ArrayList lists = new ArrayList(); lists.Clear(); if (ds != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { flgView.Rows.Add(); Class_Heart_PIC hpic = new Class_Heart_PIC(); hpic.Date = ds.Tables[0].Rows[i]["日期"].ToString(); hpic.Time = ds.Tables[0].Rows[i]["时间"].ToString(); hpic.Value_val = ds.Tables[0].Rows[i]["结果值"].ToString(); hpic.BZ = ds.Tables[0].Rows[i]["心电示波情况"].ToString(); hpic.Create_Name = ds.Tables[0].Rows[i]["签名"].ToString(); lists.Add(hpic); flgView[1 + i, 0] = hpic.Date; flgView[1 + i, 1] = hpic.Time; flgView[1 + i, 2] = hpic.Value_val; flgView[1 + i, 3] = hpic.BZ; flgView[1 + i, 4] = hpic.Create_Name; string date = Convert.ToDateTime(hpic.Date + " " + hpic.Time).ToString(); string RowSelcolor = isExisitDate(date); if (RowSelcolor != "0" && RowSelcolor != "first") { flgView.Rows[i + 1].StyleNew.BackColor = Color.Red; } } //Class_Heart_PIC[] PIC_obj=new Class_Heart_PIC[lists.Count]; //for (int j = 0; j < lists.Count; j++) //{ // PIC_obj[j] = new Class_Heart_PIC(); // PIC_obj[j] = (Class_Heart_PIC)lists[j]; //} //DataSet ds = App.ObjectArrayToDataSet(PIC_obj); } }