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;
}
