private DataTable GetDtAuditorDataBind(string chkType, int depID, int pageIndex) { int year = common.IntSafeConvert(CurrentYear); lashow.Text = ""; topTb.Visible = true; int RecordCount = 0; DataTable dt = null; if (cbBIProType.Checked)//按项目类型汇总 { Div1.Visible = false; topTb.Visible = true; repBudget.Visible = true; repBudget1.Visible = false; dt = BGBudItemsManager.GetSummaryBudInfoPager(chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt = GetProtypeDt(dt); hidtotal.Value = total.ToString(); } else if (ddlDep.SelectedValue == "0")//按部门汇总 { Div1.Visible = true; topTb.Visible = false; repBudget.Visible = false; repBudget1.Visible = true; dt = BGBudItemsManager.GetSummaryBudInfoPager(chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt.Columns.Add("IsRed"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["IsRed"] = "0"; } dt = GetGroupByDeptDt(dt); } else//选择部门查询 { Div1.Visible = false; topTb.Visible = true; repBudget.Visible = true; repBudget1.Visible = false; dt = BGBudItemsManager.GetApplyReimburByDepIDPager(depID, chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt.Columns.Add("IsRed"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["IsRed"] = "0"; } } return(GetByDeptDt(dt)); }
/// <summary> /// 根据部门ID绑定 /// </summary> /// <param name="depID"></param> private void AuditorDataBind(string chkType, int depID, int year, int pageIndex) { lashow.Text = ""; topTb.Visible = true; int RecordCount = 0; DataTable dt = null; // if (DateTime.Now>Convert.ToDateTime( CurrentYear+"-07"+"-01")) // { // year += 1; // } if (cbBIProType.Checked)//按项目类型汇总 { Div1.Visible = false; topTb.Visible = true; repBudget.Visible = true; repBudget1.Visible = false; dt = BGBudItemsManager.GetSummaryBudInfoPager(chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt = GetProtypeDt(dt); hidtotal.Value = total.ToString(); } else if (ddlDep.SelectedValue == "0")//按部门汇总 { Div1.Visible = true; topTb.Visible = false; repBudget.Visible = false; repBudget1.Visible = true; dt = BGBudItemsManager.GetSummaryBudInfoPager(chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt = GetGroupByDeptDt(dt); } else//选择部门查询 { Div1.Visible = false; topTb.Visible = true; repBudget.Visible = true; repBudget1.Visible = false; dt = BGBudItemsManager.GetApplyReimburByDepIDPager(depID, chkType, pageIndex, BudgetPager.PageSize, out RecordCount, year); dt.Columns.Add("IsRed"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["IsRed"] = "0"; } dt = GetByDeptDt(dt); } if (dt.Rows.Count < 1) { lashow.Text = "没有查询到数据。"; if (repBudget.Visible) { repBudget.DataSource = dt; repBudget.DataBind(); } else { repBudget1.DataSource = dt; repBudget1.DataBind(); } } else if (repBudget1.Visible) { BudgetPager.RecordCount = RecordCount; repBudget1.DataSource = dt; repBudget1.DataBind(); } else { BudgetPager.RecordCount = RecordCount; repBudget.DataSource = dt; repBudget.DataBind(); } }