public void DeptCostTotal_Rpt_AddCol(HIS.ZY_BLL.CostItemType cit) { DataTable dt = null; HIS.ZY_BLL.ExecDeptAndUserReport edau = new HIS.ZY_BLL.ExecDeptAndUserReport(); edau.costItemType = cit; dt = edau.GetAddCol; DataColumn dc = null; for (int i = 0; i < dt.Rows.Count; i++) { dc = new DataColumn(dt.Rows[i][0].ToString(), typeof(string), null, MappingType.Element); DeptCostTotal_Rpt.Columns.Add(dc); } }
/// <summary> /// 执行科室医生收入统计 /// </summary> /// <param name="type">0按执行科室统计1按开发科室统计</param> /// <param name="Bdate">开始日期</param> /// <param name="Edate">结束日期</param> /// <param name="cis">统计方式</param> /// <param name="cit">统计类型</param> public void BindDeptItemData(int type, DateTime Bdate, DateTime Edate, HIS.ZY_BLL.CostItemStyle cis, HIS.ZY_BLL.CostItemType cit) { try { HIS.ZY_BLL.ReportStat reportData = null; if (type == 0) { reportData = new HIS.ZY_BLL.ExecDeptAndUserReport(); } else if (type == 1) { reportData = new HIS.ZY_BLL.PresDeptAndDocReport(); } else if (type == 2) { reportData = new HIS.ZY_BLL.PresDocReport(); } reportData.Bdate = Bdate; reportData.Edate = Edate; reportData.costItemType = cit; reportData.costItemStyle = cis; DataTable[] dt = reportData.GetReportData(); DataTable dtFee = dt[0]; //得到所有费用 DataTable dtDept = dt[1]; //得到统计的科室 decimal SumDec = 0; for (int i = 0; i < dtDept.Rows.Count; i++) //循环所有科室 { DataRow dr = DeptCostTotal_Rpt.NewRow(); decimal dec = 0; if (type != 2) { dr[0] = BaseData.GetDeptName(dtDept.Rows[i][0].ToString()); dr[1] = BaseData.GetUserName(dtDept.Rows[i][1].ToString()); // add for (int m = 3; m < DeptCostTotal_Rpt.Columns.Count; m++) //循环费用列 { for (int j = 0; j < dtFee.Rows.Count; j++) //循环所有费用 { if (dtDept.Rows[i][0].ToString() == dtFee.Rows[j]["CURRDEPTCODE"].ToString() && dtDept.Rows[i][1].ToString() == dtFee.Rows[j]["CHARGECODE"].ToString()) { if (dtFee.Rows[j]["itemname"].ToString() == DeptCostTotal_Rpt.Columns[m].ColumnName) { dec += Convert.ToDecimal(dtFee.Rows[j]["TOLAL_FEE"]); dr[m] = Convert.ToDecimal(dtFee.Rows[j]["TOLAL_FEE"]).ToString("0.00"); continue;//找到对应费用项目退出循环 } } } } } else { dr[0] = ""; //BaseData.GetDeptName(dtDept.Rows[i][0].ToString()); dr[1] = BaseData.GetUserName(dtDept.Rows[i][0].ToString()); // add for (int m = 3; m < DeptCostTotal_Rpt.Columns.Count; m++) //循环费用列 { for (int j = 0; j < dtFee.Rows.Count; j++) //循环所有费用 { if (dtDept.Rows[i][0].ToString() == dtFee.Rows[j]["CHARGECODE"].ToString()) { if (dtFee.Rows[j]["itemname"].ToString() == DeptCostTotal_Rpt.Columns[m].ColumnName) { dec += Convert.ToDecimal(dtFee.Rows[j]["TOLAL_FEE"]); dr[m] = Convert.ToDecimal(dtFee.Rows[j]["TOLAL_FEE"]).ToString("0.00"); continue;//找到对应费用项目退出循环 } } } } } SumDec += dec; dr[2] = dec.ToString("0.00"); DeptCostTotal_Rpt.Rows.Add(dr); } //添加合计 if (dtDept.Rows.Count > 0) { DataRow dr = DeptCostTotal_Rpt.NewRow(); dr[0] = ""; dr[1] = "合计"; dr[2] = SumDec.ToString("0.00");//合计全部 for (int m = 3; m < DeptCostTotal_Rpt.Columns.Count; m++) { decimal dec = 0; for (int n = 0; n < DeptCostTotal_Rpt.Rows.Count; n++) { dec += Convert.ToDecimal(DeptCostTotal_Rpt.Rows[n][m] == DBNull.Value ? 0 : DeptCostTotal_Rpt.Rows[n][m]); } dr[m] = dec.ToString("0.00");//合计每个项目 } DeptCostTotal_Rpt.Rows.Add(dr); } } catch (System.Exception e) { throw new Exception(e.Message); } }