//导出数据到Excel protected void lBtnToExcel_Click(object sender, EventArgs e) { //获取数据并填充到数据表 using (var da = new v_ppc_lot_card_join_orderTableAdapter()) { //检测session中保存的查询条件 object obj = Session["lot_card_print_where_content"]; string str = string.Empty; if (obj != null && obj.ToString().Length > 0) { str = obj.ToString(); } //获取前1万行数据 var tab = da.GetPagedData(0, 10000, str, "order by [id] desc", false); //设置列标题 string[] titleCol = ("序号,批量卡序号,是补料单,订单序号,pnl数量,首部门,备注," + "录入员,录入时间,修改时间").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(); } } }
//导出数据到Excel protected void lBtnToExcel_Click(object sender, EventArgs e) { //获取数据并填充到数据表 using (var da = new v_ppc_lot_card_join_orderTableAdapter()) { //检测session中保存的查询条件 object obj = Session["lot_card_mgr_supplement_where_content"]; string str = string.Empty; if (obj != null && obj.ToString().Length > 0) { str = obj.ToString(); } //获取前1万行数据 var tab = da.GetPagedData(0, 10000, str, "order by [id] desc", true); //设置列标题 string[] titleCol = ("序号,批量卡序号,是补料单,订单序号,pnl数量,首部门,备注," + "录入员,录入时间,修改时间,状况,良率,生产编号,pnl长,pnl宽,pnl面积," + "客户名称,客户料号,批量卡编号,批量卡pcs数,批量卡pcs面积," + "开料pnl数,开料pnl面积,pnl含pcs数,开料pcs数,仓存pcs数" + "落单日期,需求日期,生产日期,已交货pcs数,已交货pcs面积," + "欠出货pcs数,欠出货pcs面积,事业部,销售单号,特殊流程,SMT备注,FPC单价,SMT单价," + "批次号,规格,备品数量,覆盖膜,投料率").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(); } } }
//导出数据到Excel protected void lBtnToExcel_Click(object sender, EventArgs e) { //获取数据并填充到数据表 using (var da = new v_ppc_lot_card_join_orderTableAdapter()) { //检测session中保存的查询条件 object obj = Session["lot_card_mgr_supplement_where_content"]; string str = string.Empty; if (obj != null && obj.ToString().Length > 0) { str = obj.ToString(); } //获取前1万行数据 var tab = da.GetPagedData(0, 10000, str, "order by [id] desc", true); //设置列标题 string[] titleCol = ("序号,订单序号,lot卡号,lot卡月份,lot卡序号,是补料单,pnl长,pnl宽,pnl含pcs数,pnl数," + "总pcs数,pnl面积,总pnl面积,首部门名称,备注,录入员,录入时间,修改时间," + "起始lot卡号,结束lot卡号,状态,良率,生产编号,pcs面积,客户名称,客户编号," + "订单编号,订单pcs数量,订单pcs面积,仓存pcs数,下单日期,需求日期,生产日期," + "已交pcs数,已交pcs面积,未交pcs数,未交pcs面积,订单备注").Split(','); //设置表名称 string titleTab = "补料lot卡清单"; //临时文件名称 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(); } } }