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();
}
}