public void ExportArrorOrderExcel() { string json = string.Empty; DataTable _dt = new DataTable(); DataTable dtHZ = new DataTable(); OrderMasterQuery query = new OrderMasterQuery(); try { 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)); if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.first_time = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["timestart"])); } if (!string.IsNullOrEmpty(Request.Params["timeend"])) { query.last_time = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["timeend"])); } _OrderMasterMgr = new OrderMasterMgr(connectionString); query.IsPage = false; int totalCount = 0; _dt = _OrderMasterMgr.ArrorOrderList(query, out totalCount); if (!System.IO.Directory.Exists(Server.MapPath(excelPath))) { System.IO.Directory.CreateDirectory(Server.MapPath(excelPath)); } for (int i = 0; i < _dt.Rows.Count; i++) { DataRow dr = dtHZ.NewRow(); dr["訂單編號"] = _dt.Rows[i]["order_id"]; dr["訂單狀態"] = _dt.Rows[i]["remark"]; dr["細項編號"] = _dt.Rows[i]["detail_id"]; dr["父商品編號"] = _dt.Rows[i]["parent_id"]; dr["組合包編號"] = _dt.Rows[i]["pack_id"]; dr["組合方式"] = _dt.Rows[i]["modeName"]; switch (_dt.Rows[i]["item_mode"].ToString()) { case "0": dr["細項類型"] = "一般商品"; break; case "1": dr["細項類型"] = "父商品"; break; case "2": dr["細項類型"] = "子商品"; break; } dr["數量"] = _dt.Rows[i]["cout"]; dtHZ.Rows.Add(dr); } if (dtHZ.Rows.Count > 0) { string fileName = DateTime.Now.ToString("異常訂單表_yyyyMMddHHmmss") + ".xls"; MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, ""); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } else { Response.Write("匯出數據不存在"); } } 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,totalCount:0,data:[]}"; } }
public HttpResponseBase ArrorOrderList() { string json = string.Empty; DataTable _dt = new DataTable(); OrderMasterQuery query = new OrderMasterQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 try { if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.first_time = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["timestart"])); } if (!string.IsNullOrEmpty(Request.Params["timeend"])) { query.last_time = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["timeend"])); } int totalCount = 0; _OrderMasterMgr = new OrderMasterMgr(connectionString); _dt = _OrderMasterMgr.ArrorOrderList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd"; json = "{success:true,'msg':'user',totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, Formatting.Indented, timeConverter) + "}";//返回json數據 } 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }