private void AuditorDataBind(int depID, string yearmonth)
{
DataTable dt = null;
if (depID == 0)
{
dt = BGApplyReimburManager.GetApplyReimburAll(yearmonth);
}
else
{
dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);
}
if (dt.Rows.Count > 0)
{
btnexport.Enabled = true;
}
else
{
string message = "没有查询到数据";
Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
btnexport.Enabled = false;
}
RepLeaderQuery.DataSource = dt;
RepLeaderQuery.DataBind();
}
protected void btnexport_Click(object sender, EventArgs e)
{
string yearmonth = ddlyear.Text.Trim() + "-" + ddlmonth.Text.Trim();
depID = Utils.IntSafeConvert(ddlDep.SelectedValue);
DataTable dt;
if (depID == 0)
{
dt = BGApplyReimburManager.GetApplyReimburAllExport(yearmonth);
}
else
{
dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);
}
if (dt != null && dt.Rows.Count > 0)
{
MemoryStream ms = ExcelRender.RenderToExcelSetHead(dt, "申请时间#报销单号#上报单位#经办人#金额#事由#申请单状态");
Response.ContentType = "application/xls";
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("报销单历史查询.xls", System.Text.Encoding.UTF8));
Response.BinaryWrite(ms.ToArray());
Response.End();
}
else
{
this.Response.Write("<script>alert('无数据不允许导出')</script>");
}
}
private void AuditorDataBind(int depID, string yearmonth)
{
DataTable dt = BGApplyReimburManager.GetApplyReimburSByDepID(depID, yearmonth);
if (dt.Rows.Count <= 0)
{
string message = "没有查询到数据";
Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
}
else
{
repReiStaQue.DataSource = dt;
repReiStaQue.DataBind();
}
}
