public void GetIlocReportList() { string json = string.Empty; string fileName = "主料位商品摘除報表_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; ProductQuery prod = new ProductQuery(); prod.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 prod.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 try { if (!string.IsNullOrEmpty(Request.Params["search"])) { prod.vendor_name_simple = Request.Params["search"]; } _IiplasMgr = new IplasMgr(mySqlConnectionString); int totalCount = 0; DataTable store = _IiplasMgr.GetIlocReportList(prod, out totalCount); DataTable dtHZ = new DataTable(); string newExcelName = string.Empty; dtHZ.Columns.Add("主料位", typeof(String)); dtHZ.Columns.Add("商品編號", typeof(string)); dtHZ.Columns.Add("品號", typeof(String)); dtHZ.Columns.Add("品名", typeof(String)); dtHZ.Columns.Add("規格", typeof(String)); dtHZ.Columns.Add("廠商", typeof(String)); dtHZ.Columns.Add("條碼", typeof(String)); dtHZ.Columns.Add("商品分類", typeof(String)); dtHZ.Columns.Add("庫存", typeof(String)); foreach (DataRow item in store.Rows) { DataRow dr = dtHZ.NewRow(); dr[0] = item["loc_id"]; dr[1] = item["product_id"]; dr[2] = item["item_id"]; dr[3] = item["Product_Name"]; dr[4] = item["prod_sz"]; dr[5] = item["vendor_name_simple"]; dr[6] = " " + item["upc_id"]; dr[7] = item["parameterName"]; dr[8] = item["product_qty"]; dtHZ.Rows.Add(dr); } MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "主料位商品摘除報表" + "_" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,data:[]}"; } }