public async Task <IntroduceDTO> GetMaterialSummary(DateTime date, string storId)
{
var result = new IntroduceDTO();
result.Total = await this.GetIQueryable().SumAsync(w => w.Num);
if (!storId.IsNullOrEmpty())
{
result.Storage = await this.GetIQueryable().Where(w => w.StorId == storId).SumAsync(w => w.Num);
}
return(result);
}
public async Task <IntroduceDTO> GetOutStorageSummary(DateTime date, string storId)
{
var startTime = date.Date;
var endTime = startTime.AddDays(1);
var result = new IntroduceDTO();
result.Total = await Db.GetIQueryable <TD_OutStorage>().Where(w => w.Status == 1 && w.OutTime >= startTime && w.OutTime < endTime).SumAsync(w => w.OutNum);
if (!storId.IsNullOrEmpty())
{
result.Storage = await Db.GetIQueryable <TD_OutStorage>().Where(w => w.Status == 1 && w.StorageId == storId).Where(w => w.OutTime >= startTime && w.OutTime < endTime).SumAsync(w => w.OutNum);
}
return(result);
}
