public ResultJSON <List <SalesPlan> > GetByPager(int page, int pageSize, SalesPlanType type, bool isLeader) { List <SalesPlan> list; if (type == SalesPlanType.水上加油)//客户要求“水上部”的人同时可以看到机油类的数据 { if (isLeader) { list = r.LoadPageList(page, pageSize, out int rCount, true, false, s => s.SalesPlanType == type || s.SalesPlanType == SalesPlanType.水上机油).OrderByDescending(s => s.Id).ToList(); } else { list = r.LoadPageList(page, pageSize, out int rCount, true, false, s => (s.SalesPlanType == type || s.SalesPlanType == SalesPlanType.水上机油) && s.CreatedBy == UserName).OrderByDescending(s => s.Id).ToList(); } } else { if (isLeader) { list = r.LoadPageList(page, pageSize, out int rCount, true, false, s => s.SalesPlanType == type).OrderByDescending(s => s.Id).ToList(); } else { list = r.LoadPageList(page, pageSize, out int rCount, true, false, s => s.SalesPlanType == type && s.CreatedBy == UserName).OrderByDescending(s => s.Id).ToList(); } } return(new ResultJSON <List <SalesPlan> > { Code = 0, Data = list }); }
/// <summary> /// 获取是否完工状态的获取水上或陆上订单列表 /// </summary> /// <param name="startPage">第N页</param> /// <param name="pageSize">每页记录</param> /// <param name="isFinished">是否已施工完成</param> /// <returns></returns> public List <Order> GetIncludeProduct(SalesPlanType orderType, int startPage, int pageSize, bool isFinished) { if (isFinished) { return(LoadPageList(startPage, pageSize, out int count, true, false, o => o.State == OrderState.已完成 && o.OrderType == orderType).Include(o => o.Product).Include(o => o.Client).ToList()); } else { return(LoadPageList(startPage, pageSize, out int count, true, false, o => o.State != OrderState.已完成 && o.OrderType == orderType).Include(o => o.Product).Include(o => o.Client).ToList()); } }
/// <summary> /// 根据订单类型获取所有订单列表 /// </summary> /// <param name="orderType">订单类型,水上/陆上/机油</param> /// <param name="startPage">第N页</param> /// <param name="pageSize">每页记录</param> /// <returns></returns> public List <Order> GetIncludeProduct(SalesPlanType orderType, int startPage, int pageSize) { return(LoadPageList(startPage, pageSize, out int count, true, false, o => o.OrderType == orderType).Include(o => o.Product).ToList()); }
/// <summary> /// 取得最近的订单model /// </summary> /// <param name="ordertype">水上|陆上|机油</param> /// <returns></returns> public Order GetLastOrder(SalesPlanType ordertype) { return(_dbContext.Orders.Where(o => o.OrderType == ordertype).OrderByDescending(o => o.Id).FirstOrDefault()); }