//导出数据到Excel
protected void lBtnToExcel_Click(object sender, EventArgs e)
{
//获取数据并填充到数据表
using (var da = new t_scrap_record_mrbTableAdapter())
{
//检测session中保存的查询条件
object obj = Session["dept_scrap_record_where_content"];
string str = string.Empty;
if (obj != null && obj.ToString().Length > 0)
{
str = obj.ToString();
}
//部门名称
string scrapDeptName = string.Empty;
if (chkThisDeptOnly.Checked)
{
scrapDeptName = Session["dept_name"].ToString();
}
//获取前1万行数据
var tab = da.GetPagedData(str, "order by [id] desc", scrapDeptName, 0, 10000);
//设置列标题
string[] titleCol =
("序号,部门名称,lot卡号,生产编号,pnl报废数,pcs报废数," +
"扣取部门余数,报废属于部门,报废原因,类型,备注,录入员,录取时间,修改时间").Split(',');
//设置表名称
string titleTab = "部门报废记录";
//临时文件名称
string fileName = titleTab + DateTime.Now.ToString("yyMMddHHmmss") + ".xls";
//执行导出数据到excel
bool isSuccess = ydPublicMethod.DataTable2Excel(tab, titleCol, ref fileName, titleTab);
//如果成功则跳转到指定页面
if (isSuccess)
{
Response.Redirect(fileName);
//停止加载后续内容
Response.End();
}
}
}
