public CombinationBiaoData GetBiaosByZhanggui(long lastId) { var rv = new CombinationBiaoData(); using(var db = DbContextFactory.CreateDbContext()) { var xiake = db.Xiakes.FirstOrDefault(a => a.XiakeName == Thread.CurrentPrincipal.Identity.Name); IQueryable<Biao> biaos = db.Biaos.Where(a => a.Zhanggui.Id == xiake.Id).OrderByDescending(a => a.Id); if(lastId != 0) biaos = biaos.Where(a => a.Id < lastId); rv.TotalCount = biaos.Count(); biaos = biaos.Take(DomainDefinition.PAGE_SIZE); var biaodatas = biaos.Select(item => new BiaoData() { ID = item.Id, Details = item.Details, GoodsId = item.GoodsId, IsSaleOver = item.IsSaleOver, CreateTime = item.CreateTime, PlanCount = item.PlanCount, Price = item.Price, DianpuName = item.Dianpu.Name, BangpaiType = item.Bangpai, RealCount = item.RealCount, IsEnable = item.IsEnable, Sku = item.Sku, SearchWord = item.SearchWord, Salary = item.Salary, YqBindPhone = item.YqBindPhone, YqBindSfz = item.YqBindSfz, YqManualCheck = item.YqManualCheck, YqMonthCount = item.YqMonthCount, YqRegisterDate = item.YqRegisterDate, YqCheckRegDate = item.YqCheckRegDate, YqUserLevel = item.YqUserLevel, YqWeekCount = item.YqWeekCount , Steps = item.Steps, Running = item.Running, Finished = item.Finished, AllowXiakeType = item.AllowXiakeType, MaxFinishDaysForOldCustomer = item.MaxFinishDaysForOldCustomer, RejectOneBiaoju = item.RejectOneBiaoju }); rv.Items.AddRange(biaodatas); rv.IsLoadedAllData = rv.Items.Count < DomainDefinition.PAGE_SIZE; } return rv; }
public CombinationBiaoData SearchBiaosByMengzhu(BangpaiType[] bangpaiTypes, DateTime startTime, DateTime endTime, string xiakeName, bool isTimeRangeRequired, bool isFinished, long lastId) { var result = new CombinationBiaoData(); using (var db = DbContextFactory.CreateDbContext()) { IQueryable<Biao > biaos = db.Biaos.Include(a=>a.Dianpu).OrderByDescending(a => a.Id); if (!string.IsNullOrEmpty(xiakeName)) { biaos = biaos.Where(a => a.Zhanggui.XiakeName.Equals(xiakeName)); } else { if (lastId != 0) { biaos = biaos .Where(a => a.Id < lastId); } biaos = biaos.Where(a => bangpaiTypes.Contains(a.Bangpai)); if (isTimeRangeRequired) { biaos = biaos.Where(a => a.CreateTime >= startTime && a.CreateTime <= endTime); } } if(isFinished == true) { biaos = biaos.Where(a => a.Finished >= a.PlanCount); } if (lastId == 0) { result.TotalCount = biaos.Count(); } biaos = biaos.Take(DomainDefinition.PAGE_SIZE); foreach (var item in biaos) { var x = new BiaoData() { ID = item.Id, Details = item.Details, GoodsId = item.GoodsId, IsSaleOver = item.IsSaleOver, CreateTime = item.CreateTime, PlanCount = item.PlanCount, Price = item.Price, DianpuName = item.Dianpu.Name, BangpaiType = item.Bangpai, RealCount = item.RealCount, IsEnable = item.IsEnable, Sku = item.Sku, SearchWord = item.SearchWord, Salary = item.Salary, YqBindPhone = item.YqBindPhone, YqBindSfz = item.YqBindSfz, YqManualCheck = item.YqManualCheck, YqMonthCount = item.YqMonthCount, YqRegisterDate = item.YqRegisterDate, YqCheckRegDate = item.YqCheckRegDate, YqUserLevel = item.YqUserLevel, YqWeekCount = item.YqWeekCount, Steps = item.Steps, Running = item.Running, Finished = item.Finished, AllowXiakeType = item.AllowXiakeType, MaxFinishDaysForOldCustomer = item.MaxFinishDaysForOldCustomer, RejectOneBiaoju = item.RejectOneBiaoju }; result.Items.Add(x); } if (result.Items.Count < DomainDefinition.PAGE_SIZE) { result.IsLoadedAllData = true; } } return result; }
public CombinationBiaoData GetBiaosByBiaoju (long lastId) { using(var db = DbContextFactory.CreateDbContext()) { var rv = new CombinationBiaoData(); IQueryable<Biao> biaos = null; if (lastId == 0) biaos = db.Biaos.Include(a => a.Dianpu).OrderByDescending(a => a.Id).Where(a=>a.IsEnable == true).Take(DomainDefinition.PAGE_SIZE); else biaos = db.Biaos.Where(a => a.Id < lastId).Include(a => a.Dianpu).Where(a => a.IsEnable == true).Take(DomainDefinition.PAGE_SIZE); foreach (var item in biaos) { var biao = new BiaoData() { ID = item.Id, Details = item.Details, IsSaleOver = item.IsSaleOver, CreateTime = item.CreateTime , PlanCount = item.PlanCount, Price = item.Price, BangpaiType = item.Bangpai, RealCount = item.RealCount, SearchWord = item.SearchWord, Salary = item.Salary, YqBindPhone = item.YqBindPhone, YqBindSfz = item.YqBindSfz, YqManualCheck = item.YqManualCheck, YqMonthCount = item.YqMonthCount, YqRegisterDate = item.YqRegisterDate, YqUserLevel = item.YqUserLevel, YqWeekCount = item.YqWeekCount, YqCheckRegDate = item.YqCheckRegDate, Steps = item.Steps , IsEnable = item.IsEnable, Running = item.Running, Finished = item.Finished, AllowXiakeType = item.AllowXiakeType, MaxFinishDaysForOldCustomer = item.MaxFinishDaysForOldCustomer, RejectOneBiaoju = item.RejectOneBiaoju }; rv.Items.Add(biao); } rv.IsLoadedAllData = rv.Items.Count < DomainDefinition.PAGE_SIZE; return rv; } }