public async Task <Array> GetDialyListByFMOInterID(ICMODailyGetAllInput input)
{
var query = Repository.GetAll().Where(p => p.FMOInterID == input.FMOInterID);
var linq = from a in query
select new { a.FDate, a.FMachineID, a.FPlanAuxQty, a.FCommitAuxQty };
var data = await linq.ToListAsync();
return(data.ToArray());
}
public async Task <PagedResultDto <ICMODailyDto> > GetAll(ICMODailyGetAllInput input)
{
var query = from a in context.ICMODaily
select a;
var count = query.Count();
var data = await query.OrderBy(input.Sorting).PageBy(input).ToListAsync();
var list = data.MapTo <List <ICMODailyDto> >();
return(new PagedResultDto <ICMODailyDto>(count, list));
}
/// <summary>
/// 任务派工界面列表接口
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PagedResultDto <VW_ICMODailyDto> > GetAll(ICMODailyGetAllInput input)
{
var query = VRepository.GetAll();
var count = await query.CountAsync();
query = string.IsNullOrEmpty(input.Sorting)
? query.OrderBy(p => p.日期).PageBy(input)
: query.OrderBy(input.Sorting).PageBy(input);
var data = await query.ToListAsync();
var list = data.MapTo <List <VW_ICMODailyDto> >();
return(new PagedResultDto <VW_ICMODailyDto>(count, list));
}
/// <summary>
/// 任务排产主界面点击“排产”后调用接口
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <List <VW_Group_ICMODailyDto> > GetDailyListByFMOInterID(ICMODailyGetAllInput input)
{
try
{
var query = GrRepository.GetAll().Where(p => p.FMOInterID == input.FMOInterID);
var data = await query.ToListAsync();
return(data.MapTo <List <VW_Group_ICMODailyDto> >());
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public async Task <MOBillPlanDetail> GetMOBillPlanDetail(ICMODailyGetAllInput input)
{
var context = Repository.GetDbContext() as ProductionPlanMySqlDbContext;
//按FMOInterID汇总计划排产数和派工数
var query = from daily in context.ICMODaily
join disp in context.ICMODispBill on daily.FID equals disp.FSrcID into g1
from a in g1.DefaultIfEmpty()
where daily.FMOInterID == input.FMOInterID
group new { daily.FMOInterID, daily.FPlanAuxQty, a.FCommitAuxQty } by daily.FMOInterID
into s
select new MOBillPlanDetail()
{
FMOInterID = s.Key,
TotalPlan = s.Sum(item => item.FPlanAuxQty),
TotalCommit = s.Sum(item => item.FCommitAuxQty)
};
var header = await query.SingleOrDefaultAsync();
if (header == null)
{
return(new MOBillPlanDetail()
{
FMOInterID = input.FMOInterID, TotalCommit = 0, TotalPlan = 0
});
}
//按天汇总排产计划数和派工数
var details = await(from daily in context.ICMODaily
join disp in context.ICMODispBill on daily.FID equals disp.FSrcID into g1
from a in g1.DefaultIfEmpty()
where daily.FMOInterID == header.FMOInterID
group new { daily.FDate, daily.FPlanAuxQty, a.FCommitAuxQty } by daily.FDate
into s
select new MOBillPlanDay()
{
FDate = s.Key,
DayCommit = s.Sum(item => item.FCommitAuxQty),
DayPlan = s.Sum(item => item.FPlanAuxQty)
}).OrderBy(p => p.FDate).ToListAsync();
header.Details = details;
return(header);
}
public async Task <Array> GetDialyQtyListByFMOInterID(ICMODailyGetAllInput input)
{
var query = Repository.GetAll().Where(p => p.FMOInterID == input.FMOInterID);
var context = Repository.GetDbContext() as ProductionPlanMySqlDbContext;
var querygroup = from daily in context.ICMODaily
join disp in context.ICMODispBill on daily.FID equals disp.FSrcID into g1
from a1 in g1.DefaultIfEmpty()
select a1;
var linq = from a in query
select new { a.FDate, a.FMachineID, a.FPlanAuxQty, a.FCommitAuxQty };
var data = await linq.ToListAsync();
var data2 = await querygroup.ToListAsync();
return(data2.ToArray());
}