/// <summary>
/// 每日出貨總表
/// </summary>
/// <returns>每日出貨數據列表</returns>
public HttpResponseBase EveryDayShipmentList()
{
string json = string.Empty;
List<OrderMasterQuery> listOrderMaster = new List<OrderMasterQuery>();
List<OrderMasterQuery> newlistOrderMaster = new List<OrderMasterQuery>();
OrderMasterQuery query = new OrderMasterQuery();
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["orderDatePayStartTime"]))
{
query.order_date_pay_startTime = Convert.ToDateTime(Request.Params["orderDatePayStartTime"]);
}
if (!string.IsNullOrEmpty(Request.Params["orderDatePayEndTime"]))
{
query.order_date_pay_endTime = Convert.ToDateTime(Request.Params["orderDatePayEndTime"]);
}
if (!string.IsNullOrEmpty(Request.Params["delays"]))
{
query.delay = int.Parse(Request.Params["delays"]);
}
int totalCount = 0;
listOrderMaster = _orderMasterMgr.GetShipmentList(query, out totalCount);
for (int i = 0; i < listOrderMaster.Count; i++)
{
if (listOrderMaster[i].combined_mode >= 1 && listOrderMaster[i].item_mode == 1) //將組合商品篩選掉
{
//listOrderMaster.RemoveAt(i);
}
else
{
newlistOrderMaster.Add(listOrderMaster[i]);
}
}
for (int i = 0; i < newlistOrderMaster.Count; i++)
{
newlistOrderMaster[i].product_name = newlistOrderMaster[i].product_name + newlistOrderMaster[i].product_spec_name;
for (int j = 0; j < i; j++)
{
if (newlistOrderMaster.Count > 0)
{
if (newlistOrderMaster[j].OrderId == newlistOrderMaster[i].OrderId)
{
newlistOrderMaster[i].OrderId = 0;
if (newlistOrderMaster[j].MoneyCollectDate == newlistOrderMaster[i].MoneyCollectDate)
{
newlistOrderMaster[i].MoneyCollectDate = DateTime.MinValue;
}
if (newlistOrderMaster[j].OrderDatePay == newlistOrderMaster[i].OrderDatePay)
{
newlistOrderMaster[i].OrderDatePay = DateTime.MinValue;
}
if (newlistOrderMaster[j].freight_set == newlistOrderMaster[i].freight_set)
{
newlistOrderMaster[i].freight_set = 0;
}
if (newlistOrderMaster[j].order_name == newlistOrderMaster[i].order_name)
{
newlistOrderMaster[i].order_name = "";
}
if (newlistOrderMaster[j].delivery_name == newlistOrderMaster[i].delivery_name)
{
newlistOrderMaster[i].delivery_name = "";
}
if (newlistOrderMaster[j].type == newlistOrderMaster[i].type)
{
newlistOrderMaster[i].type = 0;
}
if (newlistOrderMaster[j].deliver_id == newlistOrderMaster[i].deliver_id)
{
newlistOrderMaster[i].deliver_id = 0;
}
if (newlistOrderMaster[j].vendor_name_simple == newlistOrderMaster[i].vendor_name_simple)
{
newlistOrderMaster[i].vendor_name_simple = "";
}
if (newlistOrderMaster[j].Order_Status == newlistOrderMaster[i].Order_Status)
{
newlistOrderMaster[i].Order_Status = 999;
}
if (newlistOrderMaster[j].delivery_status == newlistOrderMaster[i].delivery_status)
{
newlistOrderMaster[j].delivery_status = 999;
}
if (newlistOrderMaster[j].note_order == newlistOrderMaster[i].note_order)
{
newlistOrderMaster[i].note_order = "";
}
}
}
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(newlistOrderMaster, Formatting.Indented, timeConverter) + "}";
}
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,msg:0}";
}
this.Response.Clear();
this.Response.Write(json.ToString());
this.Response.End();
return this.Response;
}
