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:[]}";
}
}
