public async override Task <PagedResultDto <SlotDto> > GetAll(PagedResultRequestMESDto input)
{
var query = MESPagedResult.GetMESPagedResult(input, _repositorySlot.GetAll());
var tasksCount = await query.CountAsync();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = query.PageBy(input).ToList();
return(new PagedResultDto <SlotDto>(tasksCount, taskList.MapTo <List <SlotDto> >()));
}
public override async Task <PagedResultDto <RoleDto> > GetAll(PagedResultRequestMESDto input)
{
var query = MESPagedResult.GetMESPagedResult <Role>(input, _roleRepository.GetAll());
var tasksCount = await query.CountAsync();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = query.PageBy(input).Include(r => r.Org).ToList();
return(new PagedResultDto <RoleDto>(tasksCount, taskList.MapTo <List <RoleDto> >()));
}
public async Task <PagedResultDto <ReelMoveLogDto> > GetAllAsync(string reelMoveMethodId, PagedResultRequestMESDto input)
{
input.RequestMESDtos.Add(new RequestMESDto()
{
PropertyName = "ReelMoveMethodId", Operation = Operation.Equal, LinkOperation = LinkOperation.And, QueryValue = reelMoveMethodId
});
var query = MESPagedResult.GetMESPagedResult <ReelMoveLog>(input, _repositoryReelMoveLog.GetAllIncluding(s => s.CreatorUser));
var tasksCount = await query.CountAsync();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = query.PageBy(input).ToList();
return(new PagedResultDto <ReelMoveLogDto>(tasksCount, taskList.MapTo <List <ReelMoveLogDto> >()));
}
public PagedResultDto <BOMDto> GetItemsById(string Id, PagedResultRequestMESDto input)
{
// 查询
// var query = _repository.GetAll().Where(m => m.ProductId == Id);
var query = config.CreateMapper().Map <List <BOM>, List <BOMDto> >(
_repository.GetAll().Where(m => m.ProductId == Id).ToList());
var res = MESPagedResult.GetMESPagedResult <BOMDto>(input, query.AsQueryable());
var tasksCount = res.Count();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = res.PageBy(input).ToList();
return(new PagedResultDto <BOMDto>(tasksCount, res.ToList()));
}
public async override Task <PagedResultDto <ProductDto> > GetAll(PagedResultRequestMESDto input)
{
// 查询 添加组件查询
// var query = _repositoryMPN.GetAll().Where(m => m.MPNHierarchy == MPNHierarchy.组件);
input.RequestMESDtos.Add(new RequestMESDto()
{
LinkOperation = LinkOperation.And, Operation = Operation.Equal, PropertyName = "MPNHierarchy", QueryValue = 0
});
//获取总数
var query = MESPagedResult.GetMESPagedResult <MPN>(input, _repositoryMPN.GetAll());
var tasksCount = await query.CountAsync();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = query.PageBy(input).Include(b => b.Customer).ToList();
return(new PagedResultDto <ProductDto>(tasksCount, config.CreateMapper().Map <List <MPN>, List <ProductDto> >(taskList)));
}
public async Task <PagedResultDto <ReadyMBillDetailedReportDto> > GetAllAsync(string readyBillId, PagedResultRequestMESDto input)
{
var resS = await
Task.Factory.StartNew(() =>
{
// 获取输入备料单的记账备料单
var readyBill = _repositoryReadyMBill.FirstOrDefault(readyBillId);
if (readyBill == null)
{
return(new PagedResultDto <ReadyMBillDetailedReportDto>(0, new List <ReadyMBillDetailedReportDto>()));
}
// 获取筛选条件中的 备料单 合集
var readyBills = _repositoryReadyMBill.GetAll().Where(s => s.ReReadyMBillId == readyBill.ReReadyMBillId).Include(r => r.WorkBills).ThenInclude(s => s.WorkBill).ToList();
// 查询记账备料单的相信信息
var ReadyMBillds = _repositoryReadyMBilld.GetAll().Where(s => readyBills.Select(r => r.Id).Contains(s.ReadyMBillId)).ToList();
var toList = new Func <IEnumerable <IEnumerable <string> >, string>(i =>
{
var list = new List <string>();
foreach (var item in i)
{
foreach (var str in item)
{
list.Add(str);
}
}
return(string.Join('|', list.Distinct()));
});
// 分组
var res = ReadyMBillds.GroupBy(r => r.PartNoId).Select(s => new ReadyMBillDetailedReportDto()
{
ReReadyMBillId = readyBill.ReReadyMBillId,
WorkBillIds = toList(readyBills.Select(r => r.WorkBills).Select(w => w.Select(wo => wo.WorkBillId + ":" + wo.Qty)).Distinct()),
Products = toList(readyBills.Select(r => r.WorkBills).Select(w => w.Select(wo => wo.WorkBill.ProductId)).Distinct()),
Lines = toList(readyBills.Select(r => r.WorkBills).Select(w => w.Select(wo => wo.WorkBill.LineId)).Distinct()),
DemandQty = s.Sum(r => r.Qty),
SendQty = s.Sum(r => r.SendQty),
PartNoId = s.Key,
FollowQty = s.Sum(r => r.FollowQty),
ReadyMBillIds = string.Join('|', readyBills.Select(r => r.Id)),
ReelMoveMethodId = s.FirstOrDefault().ReelMoveMethodId,
ReturnQty = s.Sum(r => r.ReturnQty),
MoreSendQty = s.Sum(r => r.SendQty) - s.Sum(r => r.Qty) - s.Sum(r => r.ReturnQty),
NoFollowQty = s.Sum(r => r.SendQty) - s.Sum(r => r.FollowQty),
RealSendQty = s.Sum(r => r.SendQty) - s.Sum(r => r.ReturnQty)
});
var query = MESPagedResult.GetMESPagedResult <ReadyMBillDetailedReportDto>(input, res.AsQueryable());
var tasksCount = query.Count();
//默认的分页方式
//var taskList = query.Skip(input.SkipCount).Take(input.MaxResultCount).ToList();
//ABP提供了扩展方法PageBy分页方式
var taskList = query.PageBy(input).ToList();
return(new PagedResultDto <ReadyMBillDetailedReportDto>(tasksCount, taskList));
});
return(resS);
}
