public OrderListRS GetOrders(OrderListRQ rq)
{
if (rq == null || rq.pageIndex <= 0 || rq.pageSize <= 0)
{
return new OrderListRS {
total = 0, list = null
}
}
;
return(_service.GetOrders(rq));
}
/// <summary>
/// 订单管理列表
/// </summary>
/// <param name="rq"></param>
/// <returns></returns>
public OrderListRS GetOrders(OrderListRQ rq)
{
var result = new OrderListRS {
total = 0, list = null
};
var sql = string.Empty; //"select * from [Order] where 1=1 ";
if (!string.IsNullOrWhiteSpace(rq.paraName))
{
sql += string.Format(" (ProName like '%{0}%' or ProductName like '%{0}%') ", rq.paraName);
}
var user = Order.FindAll(sql, "Id desc", null, (rq.pageIndex - 1) * rq.pageSize, rq.pageSize);
var query = (from a in user.ToList()
select new
{
a.Id,
a.FinishedOn,
a.InvId,
a.InvName,
a.InvTelePhone,
a.Number,
a.OrderPrice,
a.ProductId,
a.ProductName,
a.ProId,
a.ProName,
a.SaleId,
a.SaleName,
a.Status,
a.CreatedByName,
a.CreatedOn,
a.ModifiedByName,
a.ModifiedOn,
});
query = query.OrderByDescending(q => q.ModifiedOn).ThenByDescending(q => q.Id);
result.total = Order.FindAll(sql, null, null, 0, 0).Count; //query.Count();
if (result.total == 0)
{
return(result);
}
result.list = query.Select(a => new OrderListItemRS
{
Id = a.Id,
FinishedOn = a.FinishedOn,
InvId = a.InvId,
InvName = a.InvName,
InvTelePhone = a.InvTelePhone,
Number = a.Number,
OrderPrice = a.OrderPrice,
ProductId = a.ProductId,
ProductName = a.ProductName,
ProId = a.ProId,
ProName = a.ProName,
SaleId = a.SaleId,
SaleName = a.SaleName,
Status = a.Status,
CreatedOn = a.CreatedOn,
CreatedByName = a.CreatedByName,
ModifiedByName = a.ModifiedByName,
ModifiedOn = a.ModifiedOn
}).ToList();
return(result);
}
