//edit by xiangwang0413w 2014/10/20 /// <summary> /// 庫存資料匯出(單一商品) /// </summary> /// <param name="query">查詢條件</param> /// <returns>excel文件</returns> public ActionResult ExportProduct(QueryVerifyCondition query, int exportFlag, string cols) { try { #region 查詢條件 query.category_id = query.category_id == 2 ? 0 : query.category_id; query.date_type = query.date_type ?? ""; if (!string.IsNullOrEmpty(query.time_start)) query.time_start = CommonFunction.GetPHPTime(Convert.ToDateTime(query.time_start).ToString("yyyy/MM/dd 00:00:00")).ToString(); else query.time_start = ""; if (!string.IsNullOrEmpty(query.time_end)) query.time_end = CommonFunction.GetPHPTime(Convert.ToDateTime(query.time_end).ToString("yyyy/MM/dd 23:59:59")).ToString(); else query.time_end = ""; #endregion _productMgr = new ProductMgr(connectionString); string xmlPath = string.Empty; switch (exportFlag) { case 1://庫存資料匯出(單一商品) xmlPath = "../XML/ProductStock.xml"; break; case 2: //商品資料匯出 xmlPath = "../XML/ProductInfo.xml"; break; case 3://商品價格匯出 xmlPath = "../XML/ProductPrice.xml"; break; case 4: xmlPath = "../XML/ItemPrice.xml"; break; case 5://預購商品匯出 (沒有這個XML只是使用公用方法以防報錯)guodong1130w 2015/9/21 xmlPath = "../XML/ProductInfo.xml"; break; } MemoryStream ms = _productMgr.ExportProductToExcel(query, exportFlag, cols, Server.MapPath(xmlPath));//根據查詢條件和xml路徑得到excel文件流 return File(ms.ToArray(), "application/-excel", DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"); } 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); return Content("export errer"); } }