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); }