C1FlexGrid 表格的应用

1.  设置表格的表头

C1FlexGrid flgView = new C1FlexGrid();

/// <summary>
/// 表头设置
/// </summary>
private void SetTable()
{
    flgView.Cols.Count = 38;
    flgView.Rows.Count = 2;

    // 设置固定行
    flgView.Rows.Fixed = 2;

    // 格式不清除,翻页后表格显示格式将异常
    flgView.MergedRanges.Clear();
}

2.  呈现数据

/// <summary>
/// 显示交接班报告区
/// </summary>
internal void Handovers_ShowDate()
{
    SetTable();
    try
    {
       // 查询交班记录中当天所有记录
        // 查询不重复的病人号
        // 整合整个表格的显示,同一病人的多行数据,其中第一列进行合并
        string sql1 = string.Format(@"select t.*,p.patient_name,p.gender_code,p.age,p.age_unit,b.bed_no,p.in_time from t_handovers_records_icu t
            inner join t_in_patient p on t.patient_id=p.id inner join t_sickbedinfo b on p.sick_bed_id = b.bed_id where t.measure_time
            like '%{0}%' and Sickarea_name='{1}' order by t.patient_id,t.measure_time", dtpDate.Value.ToString("yyyy-MM-dd"),
            App.UserAccount.CurrentSelectRole.Sickarea_name);
        DataSet dsHandoversRecord = App.GetDataSet(sql1);
        if (dsHandoversRecord == null || dsHandoversRecord.Tables[0].Rows.Count == 0)
        {
            goto Cell;
        }
        string sql2 = string.Format(@"select distinct(t.patient_id) from t_handovers_records_icu t
            where t.measure_time like '%{0}%' and Sickarea_name='{1}'", dtpDate.Value.ToString("yyyy-MM-dd"),
            App.UserAccount.CurrentSelectRole.Sickarea_name);
        DataSet dsPids = App.GetDataSet(sql2);

        DataTable dtRecord = dsHandoversRecord.Tables[0];
        DataTable dtPid = dsPids.Tables[0];
        foreach (DataRow drPid in dtPid.Rows)
        {
            int min = 0;
            int max = 0;
            DataRow[] rows = dtRecord.Select("patient_id=" + drPid["patient_id"]);
            for (int i = 0; i < rows.Length; i++)
            {
                Row c1Row = flgView.Rows.Add();
                if (i == 0)
                {
                    min = c1Row.Index; // 新增行的小行号
                  }
                if (i == rows.Length - 1)
                {
                    max = c1Row.Index; // 新增行的大行号
                  }
              c1Row[1] = rows[i]["CLASS_COUNT"];          // 班次
                c1Row[2] = rows[i]["IN_TIME"];              // 入院时间
                c1Row[3] = rows[i]["WARM_BOX"];             // 暖箱
                c1Row[4] = rows[i]["TEMPERATURE"];          // 体温
                c1Row[5] = rows[i]["PULSE"];                // 脉搏
                c1Row[6] = rows[i]["BREATH"];               // 呼吸
                c1Row[7] = rows[i]["BLOOD_PRESSURE"];       // 血压
                c1Row[8] = rows[i]["SPO2"];                 // SPO2
              c1Row[9] = rows[i]["OXYGEN_WAY"];           // 吸氧方式
                c1Row[10] = rows[i]["OXYGEN_FLOW"];         // 氧流量
                c1Row[11] = rows[i]["MIND"];                // 神志
                c1Row[12] = rows[i]["SPIRIT_REACTION"];     // 精神反应
                c1Row[13] = rows[i]["PUPIL"];               // 瞳孔
                c1Row[14] = rows[i]["COMPLEXION"];          // 面色
                c1Row[15] = rows[i]["COUGH"];               // 咳喘
                c1Row[16] = rows[i]["VOMIT"];               // 呕吐
                c1Row[17] = rows[i]["TWITCH"];              // 抽搐
                c1Row[18] = rows[i]["SKIN"];                // 皮肤
                c1Row[19] = rows[i]["ABDOMINAL"];           // 腹部
                c1Row[20] = rows[i]["UMBILICAL"];           // 脐部
                c1Row[21] = rows[i]["HIP"];                 // 臀部
                c1Row[22] = rows[i]["DIET"];                // 饮食
                c1Row[23] = rows[i]["SHIT"];                // 大便
                c1Row[24] = rows[i]["URINATE"];             // 小便
                c1Row[25] = rows[i]["FUKE"];                // 敷科

              // 导管护理 (胃管26,尿管27,引流管28,其他29)
              string sTemp = rows[i]["NURSING_CATHETERS"].ToString();
              if (sTemp.Length != 0)
              {
                  string[] strs = sTemp.Split(';');
                  foreach (string s in strs)
                  {
                      string str = "";
                      if (s.Contains("胃管"))
                      {
                          str = s.Substring(s.IndexOf("胃管") + 3);
                          c1Row[26] = str;
                      }
                      else if (s.Contains("尿管"))
                      {
                          str = s.Substring(s.IndexOf("尿管") + 3);
                          c1Row[27] = str;
                      }
                      else if (s.Contains("引流"))
                      {
                          str = s.Substring(s.IndexOf("引流") + 3);
                          c1Row[28] = str;
                      }
                      else
                      {
                          c1Row[29] = s;
                      }
                  }
              }
              else
              {
                  c1Row[26] = "";
                  c1Row[27] = "";
                  c1Row[28] = "";
                  c1Row[29] = "";
              }

            c1Row[30] = rows[i]["OXYGEN_CONCENTRATION"];    // 氧浓度
              c1Row[31] = rows[i]["BREATH_FREQUENCY"];        // 呼吸频率
              c1Row[32] = rows[i]["BREATHE_TIME"];            // 吸气时间
              c1Row[33] = rows[i]["CPAP"];                     // CPAP
            c1Row[34] = rows[i]["PEEP"];                     // PEEP
            c1Row[35] = rows[i]["PIP"];                      // PIP
            c1Row[36] = rows[i]["STATUS_MEASURE"];           // 病情及处理
              c1Row[37] = rows[i]["ID"];                       // 主表ID列
           }

            // 合并表格的第一列数据(床号,姓名,性别,年龄,诊断)
            string sBedNo = rows[0]["bed_no"].ToString();
            string sName = rows[0]["patient_name"].ToString();
            string sSex = rows[0]["gender_code"].ToString().Equals("0") ? "男" : "女";
            string sAge = rows[0]["age"].ToString() + rows[0]["age_unit"].ToString();
            string sqlDiagnose = string.Format(@"select t.diagnose_name from t_diagnose_item t where t.patient_id ={0} and t.diagnose_type=403 order by t.create_time", drPid["patient_id"].ToString());
            string sDiagnose = App.ReadSqlVal(sqlDiagnose, 0, "diagnose_name");
            C1.Win.C1FlexGrid.CellRange cr = flgView.GetCellRange(min, 0, max, 0);
            cr.Data = string.Format("{0}\n{1}\n{2}", sBedNo + " " + sName, sSex + " " + sAge, sDiagnose);
            cr.StyleNew.TextAlign = TextAlignEnum.LeftCenter;
            flgView.MergedRanges.Add(cr);
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("出错了,原因是:" + ex.Message);
    }
Cell:
    CellUnit();
}

3.  单元格合并，设置字体居中模式

/// <summary>
/// 交接班报告区单元格合并和设置
/// </summary>
private void CellUnit()
{
    flgView.AllowMerging = C1.Win.C1FlexGrid.AllowMergingEnum.Custom;
    flgView.Cols.Fixed = 0;

    #region 设置表头单元格合并及文字
    C1.Win.C1FlexGrid.CellRange cr;
    cr = flgView.GetCellRange(0, 0, 1, 0);
    cr.Data = "床号\n姓名\n性别\n年龄\n诊断";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 1, 1, 1);
    cr.Data = "班" + "\r\n" + "次";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 2, 1, 2);
    cr.Data = "入" + "\r\n" + "院" + "\r\n" + "时" + "\r\n" + "间";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 3, 1, 3);
    cr.Data = "暖\n箱";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 4, 0, 7);
    cr.Data = "生命体征";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 4, 1, 4);
    cr.Data = "T\n℃";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 5, 1, 5);
    cr.Data = "P" + "\r\n" + "次" + "\r\n" + "/" + "\r\n" + "分";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 6, 1, 6);
    cr.Data = "R" + "\r\n" + "次" + "\r\n" + "/" + "\r\n" + "分";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 7, 1, 7);
    cr.Data = "BP" + "\r\n" + "mm" + "\r\n" + "Hg";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 8, 1, 8);
    cr.Data = "SPO\n2%";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 9, 1, 9);
    cr.Data = "吸\n氧\n方\n式"; ;
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 10, 1, 10);
    cr.Data = "氧\n流\n量\nml/\n分";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 11, 1, 11);
    cr.Data = "神\n志";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 12, 1, 12);
    cr.Data = "精\n神\n反\n应";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 13, 1, 13);
    cr.Data = "瞳\n孔";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 14, 1, 14);
    cr.Data = "面\n色";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 15, 1, 15);
    cr.Data = "咳\n嗽";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 16, 1, 16);
    cr.Data = "呕\n吐";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 17, 1, 17);
    cr.Data = "抽\n搐";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 18, 1, 18);
    cr.Data = "皮\n肤";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 19, 1, 19);
    cr.Data = "腹\n部";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 20, 1, 20);
    cr.Data = "脐\n部";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 21, 1, 21);
    cr.Data = "臀\n部";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 22, 1, 22);
    cr.Data = "饮\n食";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 23, 1, 23);
    cr.Data = "大\n便";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 24, 1, 24);
    cr.Data = "小\n便";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 25, 1, 25);
    cr.Data = "敷\n科";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 26, 0, 29);
    cr.Data = "导管护理";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 26, 1, 26);
    cr.Data = "胃\n管";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 27, 1, 27);
    cr.Data = "尿\n管";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 28, 1, 28);
    cr.Data = "引\n流\n管";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(1, 29, 1, 29);
    cr.Data = "其\n他";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 30, 1, 30);
    cr.Data = "氧\n浓\n度\n%";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 31, 1, 31);
    cr.Data = "呼\n吸\n频\n率\n次\n/\n分";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 32, 1, 32);
    cr.Data = "吸\n气\n时\n间\n/\n秒";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 33, 1, 33);
    cr.Data = "CPAP\ncmH2O";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 34, 1, 34);
    cr.Data = "PEEP\ncmH2O";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 35, 1, 35);
    cr.Data = "PIP\ncmH2O";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 36, 1, 36);
    cr.Data = "病情及处理";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);

    cr = flgView.GetCellRange(0, 37, 1, 37);
    cr.Data = "报告表ID";
    cr.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
    flgView.MergedRanges.Add(cr);
    #endregion

    flgView.AutoSizeCols();
    flgView.AutoSizeRows();
    flgView.Cols[36].Width = 300;
    flgView.Cols[37].Visible = false;
    flgView.AllowEditing = false;
}