/// <summary>
/// 获取礼品预约单列表
/// </summary>
/// <param name="skey"></param>
/// <param name="status"></param>
/// <param name="page"></param>
/// <param name="pagesize"></param>
/// <returns></returns>
public QueryPageModel <GiftsOrderDtoModel> GetMyOrderList(string skey = "", GiftOrderInfo.GiftOrderStatus?status = null, int page = 1, int pagesize = 10)
{
if (CurrentUser == null)
{
throw new HimallException("错误的用户信息");
}
int rows = pagesize;
GiftsOrderQuery query = new GiftsOrderQuery();
query.skey = skey;
if (status != null)
{
if ((int)status != 0)
{
query.status = status;
}
}
query.UserId = CurrentUser.Id;
query.PageSize = rows;
query.PageNo = page;
var orderdata = _iGiftsOrderService.GetOrders(query);
List <GiftOrderInfo> orderlist = orderdata.Models.ToList();
//_iGiftsOrderService.OrderAddUserInfo(orderlist);
var result = orderlist.ToList();
Mapper.CreateMap <GiftOrderInfo, GiftsOrderDtoModel>();
Mapper.CreateMap <GiftOrderItemInfo, GiftsOrderItemDtoModel>();
List <GiftsOrderDtoModel> pagedata = new List <GiftsOrderDtoModel>();
foreach (var item in result)
{
item.Address = ClearHtmlString(item.Address);
item.CloseReason = ClearHtmlString(item.CloseReason);
item.UserRemark = ClearHtmlString(item.UserRemark);
var tmpordobj = Mapper.Map <GiftsOrderDtoModel>(item);
tmpordobj.Items = new List <GiftsOrderItemDtoModel>();
foreach (var subitem in item.Himall_GiftOrderItem)
{
var tmporditemobj = Mapper.Map <GiftsOrderItemDtoModel>(subitem);
tmporditemobj.DefaultImage = HimallIO.GetRomoteProductSizeImage(tmporditemobj.ImagePath, 1, ImageSize.Size_150.GetHashCode());
tmpordobj.Items.Add(tmporditemobj);
}
pagedata.Add(tmpordobj);
}
QueryPageModel <GiftsOrderDtoModel> pageresult = new QueryPageModel <GiftsOrderDtoModel>();
pageresult.Total = orderdata.Total;
pageresult.Models = pagedata;
return(pageresult);
}
/// <summary>
/// 获取订单计数
/// </summary>
/// <param name="status"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int GetOrderCount(GiftOrderInfo.GiftOrderStatus?status, long userId = 0)
{
var sql = DbFactory.Default.Get <GiftOrderInfo>();
if (status.HasValue)
{
sql.Where(d => d.OrderStatus == status.Value);
}
if (userId != 0)
{
sql.Where(d => d.UserId == userId);
}
return(sql.Count());
}
public JsonResult OrderList(string skey, GiftOrderInfo.GiftOrderStatus?status, int rows, int page)
{
GiftsOrderQuery query = new GiftsOrderQuery();
query.skey = skey;
query.status = status;
query.PageSize = rows;
query.PageNo = page;
var orderdata = _iGiftsOrderService.GetOrders(query);
List <GiftOrderInfo> orderlist = orderdata.Models.ToList();
_iGiftsOrderService.OrderAddUserInfo(orderlist);
var datalist = orderlist.Select(d =>
{
var orditem = d.Himall_GiftOrderItem.FirstOrDefault();
return(new GiftOrderPageModel
{
Id = d.Id,
OrderStatus = d.OrderStatus,
UserId = d.UserId,
UserRemark = ClearHtmlString(d.UserRemark),
ShipTo = d.ShipTo,
CellPhone = d.CellPhone,
TopRegionId = d.TopRegionId,
RegionId = d.RegionId,
RegionFullName = d.RegionFullName,
Address = ClearHtmlString(d.Address),
ExpressCompanyName = d.ExpressCompanyName,
ShipOrderNumber = d.ShipOrderNumber,
ShippingDate = d.ShippingDate,
OrderDate = d.OrderDate,
FinishDate = d.FinishDate,
TotalIntegral = d.TotalIntegral,
CloseReason = ClearHtmlString(d.CloseReason),
FirstGiftId = orditem.GiftId,
FirstGiftName = ClearHtmlString(orditem.GiftName),
FirstGiftBuyQuantity = orditem.Quantity,
UserName = d.UserName
});
});
var result = new { rows = datalist.ToList(), total = orderdata.Total };
return(Json(result));
}
public JsonResult OrderList(string skey, GiftOrderInfo.GiftOrderStatus?status, int rows, int page)
{
GiftsOrderQuery giftsOrderQuery = new GiftsOrderQuery()
{
skey = skey,
status = status,
PageSize = rows,
PageNo = page
};
PageModel <GiftOrderInfo> orders = orderser.GetOrders(giftsOrderQuery);
List <GiftOrderInfo> list = orders.Models.ToList();
orderser.OrderAddUserInfo(list);
IEnumerable <GiftOrderPageModel> giftOrderPageModels = list.Select <GiftOrderInfo, GiftOrderPageModel>((GiftOrderInfo d) => {
GiftOrderItemInfo giftOrderItemInfo = d.ChemCloud_GiftOrderItem.FirstOrDefault();
return(new GiftOrderPageModel()
{
Id = d.Id,
OrderStatus = d.OrderStatus,
UserId = d.UserId,
UserRemark = ClearHtmlString(d.UserRemark),
ShipTo = d.ShipTo,
CellPhone = d.CellPhone,
TopRegionId = d.TopRegionId,
RegionId = d.RegionId,
RegionFullName = d.RegionFullName,
Address = ClearHtmlString(d.Address),
ExpressCompanyName = d.ExpressCompanyName,
ShipOrderNumber = d.ShipOrderNumber,
ShippingDate = d.ShippingDate,
OrderDate = d.OrderDate,
FinishDate = d.FinishDate,
TotalIntegral = d.TotalIntegral,
CloseReason = ClearHtmlString(d.CloseReason),
FirstGiftId = giftOrderItemInfo.GiftId,
FirstGiftName = ClearHtmlString(giftOrderItemInfo.GiftName),
FirstGiftBuyQuantity = giftOrderItemInfo.Quantity,
UserName = d.UserName
});
});
var variable = new { rows = giftOrderPageModels.ToList(), total = orders.Total };
return(Json(variable));
}
public ActionResult OrderList(string skey, GiftOrderInfo.GiftOrderStatus?status, int page = 1)
{
int num = 12;
GiftsOrderQuery giftsOrderQuery = new GiftsOrderQuery()
{
skey = skey
};
if (status.HasValue && status.Value != 0)
{
giftsOrderQuery.status = status;
}
giftsOrderQuery.UserId = new long?(base.CurrentUser.Id);
giftsOrderQuery.PageSize = num;
giftsOrderQuery.PageNo = page;
PageModel <GiftOrderInfo> orders = orderser.GetOrders(giftsOrderQuery);
PagingInfo pagingInfo = new PagingInfo()
{
CurrentPage = page,
ItemsPerPage = num,
TotalItems = orders.Total
};
PagingInfo pagingInfo1 = pagingInfo;
List <GiftOrderInfo> list = orders.Models.ToList();
if (list.Count > 0)
{
ViewBag.pageInfo = pagingInfo1;
orderser.OrderAddUserInfo(list);
List <GiftOrderInfo> giftOrderInfos = list.ToList();
foreach (GiftOrderInfo giftOrderInfo in giftOrderInfos)
{
giftOrderInfo.Address = ClearHtmlString(giftOrderInfo.Address);
giftOrderInfo.CloseReason = ClearHtmlString(giftOrderInfo.CloseReason);
giftOrderInfo.UserRemark = ClearHtmlString(giftOrderInfo.UserRemark);
}
return(View(giftOrderInfos));
}
else
{
return(RedirectToAction("Error", "UserIntegral"));
}
}
/// <summary>
/// 获取预约单计数
/// </summary>
/// <param name="status"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int GetOrderCount(GiftOrderInfo.GiftOrderStatus?status, long userId = 0)
{
int result = 0;
var sql = Context.GiftOrderInfo.AsQueryable();
if (status.HasValue)
{
sql = sql.Where(d => d.OrderStatus == status.Value);
}
if (userId != 0)
{
sql = sql.Where(d => d.UserId == userId);
}
try
{
result = sql.Count();
}
catch (Exception ex)
{
result = 0;
}
return(result);
}
public ActionResult OrderList(string skey, GiftOrderInfo.GiftOrderStatus?status, int page = 1)
{
int rows = 12;
GiftsOrderQuery query = new GiftsOrderQuery();
query.skey = skey;
if (status != null)
{
if ((int)status != 0)
{
query.status = status;
}
}
query.UserId = CurrentUser.Id;
query.PageSize = rows;
query.PageNo = page;
var orderdata = _iGiftsOrderService.GetOrders(query);
PagingInfo info = new PagingInfo
{
CurrentPage = page,
ItemsPerPage = rows,
TotalItems = orderdata.Total
};
List <GiftOrderInfo> orderlist = orderdata.Models.ToList();
ViewBag.pageInfo = info;
_iGiftsOrderService.OrderAddUserInfo(orderlist);
var result = orderlist.ToList();
foreach (var item in result)
{
item.Address = ClearHtmlString(item.Address);
item.CloseReason = ClearHtmlString(item.CloseReason);
item.UserRemark = ClearHtmlString(item.UserRemark);
}
return(View(result));
}
public static int GetOrderCount(GiftOrderInfo.GiftOrderStatus?status, long userId = 0)
{
return(Service.GetOrderCount(status, userId));
}