public string GetOnlineOrderData()
{
StringBuilder strData = new StringBuilder();
try
{
if (string.IsNullOrWhiteSpace(Request.Params["Query"]))
{
return(strData.ToString());
}
int page = string.IsNullOrEmpty(Request.Params["page"]) ? 0 : int.Parse(Request.Params["page"]);
int rows = string.IsNullOrEmpty(Request.Params["rows"]) ? 0 : int.Parse(Request.Params["rows"]);
List <BWYGateMapping> gates = BWYGateMappingServices.QueryAll();
int total = 0;
List <OnlineOrder> result = OnlineOrderServices.QueryPage(GetOnlineOrderCondition(), page, rows, out total);
var obj = from p in result
select new
{
OrderID = p.OrderID.ToString(),
PKName = p.PKName,
PlateNo = p.PlateNo,
Amount = p.Amount,
MonthNum = p.OrderType == OnlineOrderType.MonthCardRecharge ? p.MonthNum.ToString() : string.Empty,
PayerNickName = p.PayerNickName,
SyncResultTimes = p.SyncResultTimes,
LastSyncResultTime = p.LastSyncResultTime != DateTime.MinValue ? p.LastSyncResultTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
RefundOrderId = p.RefundOrderId,
Remark = p.Remark,
OrderType = (int)p.OrderType,
OrderTypeDes = p.OrderType.GetDescription(),
Status = (int)p.Status,
StatusDes = p.Status.GetDescription(),
OrderTime = p.OrderTime.ToString("yyyy-MM-dd HH:mm:ss"),
RealPayTime = p.RealPayTime != DateTime.MinValue ? p.RealPayTime.ToString("yyyy-MM-dd HH:mm:ss") : string.Empty,
BWYParkingName = GetBWYParkingName(p.ExternalPKID, gates)
};
strData.Append("{");
strData.Append("\"total\":" + total + ",");
strData.Append("\"rows\":" + JsonHelper.GetJsonString(obj) + ",");
strData.Append("\"index\":" + page);
strData.Append("}");
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "查询微信订单信息失败");
}
return(strData.ToString());
}