Example #1
0
        /// <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();
        }
Example #2
0
        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);
            }
        }