public PagerInfo <SaleDto> GetPagedList(GetSaleOrderQueryRequest request, int uid)
{
var filter = Mapper.Map <GetSaleOrderQueryRequest, SaleOrderFilter>(request);
var pagerRequest = new Domain.PagerRequest(request.Page ?? 1, request.PageSize ?? 10);
if (request.EndDate != null || request.StartDate != null)
{
var daterange = new DateRangeFilter {
EndDateTime = request.EndDate, StartDateTime = request.StartDate
};
filter.DateRange = daterange;
}
int total;
var datas = _saleOrderRepository.GetPagedList(pagerRequest, out total, filter, (SaleOrderSortOrder)(request.SortOrder ?? 0));
var dto = Mapper.Map <List <SalesOrderModel>, List <SaleDto> >(datas);
var pagerdto = new PagerInfo <SaleDto>(pagerRequest, total)
{
Datas = dto
};
return(pagerdto);
}
public IHttpActionResult GetNoPickupSaleOrders([FromUri] GetSaleOrderQueryRequest request, [UserId] int uid, [UserProfile] UserProfile userProfile)
{
return(GetList4OldApi(request, uid, userProfile));
//request.ArrangeParams();
//return DoFunction(() =>
//{
// var saleDtos = _saleOrderService.QuerySaleOrders(request, uid);
// return new PageResult<SaleDto>(saleDtos, saleDtos.Count);
//});
}
private IHttpActionResult GetList4OldApi(GetSaleOrderQueryRequest request, int uid, UserProfile userProfile)
{
IHttpActionResult httpActionResult;
var result = CheckDataRoleAndArrangeParams(request, userProfile, out httpActionResult);
if (!result)
{
return(httpActionResult);
}
var dto = _salesOrderService.GetPagedList(request, uid);
var pageResult = new PageResult <SaleDto>(dto.Datas, dto.TotalCount);
return(RetrunHttpActionResult(pageResult));
}
public IHttpActionResult GetList([FromUri] GetSaleOrderQueryRequest request, [UserId] int uid, [UserProfile] UserProfile userProfile)
{
if (request == null)
{
request = new GetSaleOrderQueryRequest();
}
IHttpActionResult httpActionResult;
var result = CheckDataRoleAndArrangeParams(request, userProfile, out httpActionResult);
if (!result)
{
return(httpActionResult);
}
var dto = _salesOrderService.GetPagedList(request, uid);
return(RetrunHttpActionResult(dto));
}
public IList <SaleDto> QuerySaleOrders(GetSaleOrderQueryRequest request, int uid)
{
using (var db = new YintaiHZhouContext())
{
var user =
db.OPC_AuthUsers.Where(x => x.Id == uid)
.Join(db.OPC_OrgInfos, u => u.OrgId, o => o.OrgID, (u, o) => new { user = u, org = o })
.FirstOrDefault();
if (user == null)
{
throw new OpcException("未授权的用户");
}
if (user.user.IsSystem)
{
throw new NotImplementedException();
}
Expression <Func <OPC_Sale, bool> > whereCondition =
sale => sale.CreatedDate > request.StartDate && sale.CreatedDate < request.EndDate;
if (!string.IsNullOrEmpty(request.SaleOrderNo))
{
whereCondition = whereCondition.And(sale => sale.SaleOrderNo == request.SaleOrderNo);
}
if (!string.IsNullOrEmpty(request.OrderNo))
{
whereCondition = whereCondition.And(sale => sale.OrderNo == request.OrderNo);
}
return
(db.OPC_Sales.Where(whereCondition)
.Join(db.Sections.Where(s => s.StoreId == user.org.StoreOrSectionID)
.Join(db.Stores, s => s.StoreId, x => x.Id, (section, store) => new { section, store }), o => o.SectionId, s => s.section.Id, (o, s) => new { o, store = s })
.Join(db.OrderTransactions, o => o.o.OrderNo, ot => ot.OrderNo, (o, ot) => new { o, ot })
.Join(db.PaymentMethods, ot => ot.ot.PaymentCode, pm => pm.Code, (ot, pm) => new SaleDto()
{
Id = ot.o.o.Id,
OrderNo = ot.o.o.OrderNo,
SaleOrderNo = ot.o.o.SaleOrderNo,
SalesType = ot.o.o.SalesType,
ShipViaId = ot.o.o.ShipViaId,
Status = ot.o.o.Status,
ShippingCode = ot.o.o.ShippingCode,
ShippingFee = ot.o.o.ShippingFee.HasValue ? ot.o.o.ShippingFee.Value : 0m,
ShippingStatus = ot.o.o.ShippingStatus,
ShippingStatusName = ot.o.o.ShippingStatus.HasValue ? ((EnumSaleOrderStatus)ot.o.o.ShippingStatus.Value).GetDescription() : String.Empty,
ShippingRemark = ot.o.o.ShippingRemark,
SellDate = ot.ot.CreateDate,
IfTrans = ot.o.o.IfTrans.HasValue && ot.o.o.IfTrans.Value ? "是" : "否",
TransStatus = ot.o.o.TransStatus.HasValue && ot.o.o.TransStatus.Value == 1 ? "调拨" : String.Empty,
SalesAmount = ot.o.o.SalesAmount,
SalesCount = ot.o.o.SalesCount,
CashStatus = ot.o.o.CashStatus,
CashNum = ot.o.o.CashNum,
CashDate = ot.o.o.CashDate,
SectionId = ot.o.o.SectionId,
PrintTimes = ot.o.o.PrintTimes,
Remark = ot.o.o.Remark,
RemarkDate = ot.o.o.RemarkDate,
//CreatedDate = ot.o.CreatedDate,
//CreatedUser = ot.o.CreatedUser,
//UpdatedDate = ot.o.UpdatedDate.Value,
//UpdatedUser = ot.o.UpdatedUser.Value,
StatusName = ((EnumSaleOrderStatus)ot.o.o.Status).GetDescription(),
CashStatusName = ot.o.o.CashStatus.HasValue ? ((EnumCashStatus)ot.o.o.CashStatus).GetDescription() : string.Empty,
StoreName = ot.o.store.store.Name,
//InvoiceSubject = ot.o.o.
SectionName = ot.o.store.section.Name,
TransNo = ot.ot.TransNo,
}).ToList());
}
}
