private DataTable m_mthCreatTable() { DataTable ret = new DataTable(); ret.Columns.Add("姓名", typeof(String)); if (this.m_objViewer.strType == "0") { ret.Columns.Add("有效发票数", typeof(String)); } ret.Columns.Add("合计", typeof(String)); DataTable dt_Temp; objSvc.m_mthReportColumns(out dt_Temp, "0068"); if (dt_Temp.Rows.Count > 0) { for (int i = 0; i < dt_Temp.Rows.Count; i++) { ret.Columns.Add(dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(), typeof(String)); } DataRow dr = ret.NewRow(); dr["姓名"] = "收费员姓名"; if (this.m_objViewer.strType == "0") { dr["有效发票数"] = "有效发票数"; } dr["合计"] = "合计"; for (int i = 0; i < dt_Temp.Rows.Count; i++) { dr[dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim()] = dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(); } ret.Rows.Add(dr); } return(ret); }
private DataTable m_mthCreatTable() { DataTable ret = new DataTable(); ret.Columns.Add("姓名", typeof(String)); ret.Columns.Add("合计", typeof(String)); ret.Columns.Add("处方量", typeof(String)); clsSingleWorkLoadSubItem_VO[] objSubArr = null; DataTable dt_Temp; objSvc.m_mthReportColumns(out dt_Temp, "0005"); if (dt_Temp.Rows.Count > 0) { for (int i = 0; i < dt_Temp.Rows.Count; i++) { ret.Columns.Add(dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(), typeof(String)); } DataRow dr = ret.NewRow(); dr["姓名"] = "医生姓名"; dr["处方量"] = "处方量"; if (this.m_objViewer.radioButton4.Checked) { dr["姓名"] = "科室姓名"; } dr["合计"] = "合计"; for (int i = 0; i < dt_Temp.Rows.Count; i++) { dr[dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim()] = dt_Temp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(); } ret.Rows.Add(dr); } return(ret); }
/// <summary> /// 生成表结构 /// </summary> public void m_mthCreatTable() { Mydt.Columns.Clear(); Mydt = new DataTable(); Mydt.Columns.Add("名称", typeof(String)); Mydt.Columns.Add("合计", typeof(String)); Mydt.Columns.Add("正方", typeof(String)); Mydt.Columns.Add("副方", typeof(String)); Mydt.Columns.Add("就诊人数", typeof(String)); Mydt.Columns.Add("药品让利", typeof(string)); Mydt.Columns.Add("材料让利", typeof(string)); DataTable dtTemp; long ret = objSvc.m_mthReportColumns(out dtTemp, "0066"); if (ret > 0 && dtTemp.Rows.Count > 0) { DataColumn dtcol; for (int i = 0; i < dtTemp.Rows.Count; i++) { dtcol = new DataColumn(); dtcol.DataType = typeof(System.String); dtcol.DefaultValue = 0; dtcol.ColumnName = dtTemp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(); this.Mydt.Columns.Add(dtcol); } drTitle = Mydt.NewRow(); drTitle["名称"] = "分组名称"; drTitle["合计"] = "合计"; drTitle["正方"] = "正方数"; drTitle["副方"] = "副方数"; drTitle["就诊人数"] = "就诊人数"; drTitle["药品让利"] = "药品让利"; drTitle["材料让利"] = "材料让利"; for (int i = 0; i < dtTemp.Rows.Count; i++) { drTitle[dtTemp.Rows[i]["GROUPNAME_CHR"].ToString().Trim()] = dtTemp.Rows[i]["GROUPNAME_CHR"].ToString().Trim(); } Mydt.Rows.Add(drTitle); } }