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