public PagedListModel <Machine_YieldDTO> QueryMachine_Yields(Machine_YieldDTO searchModel, Page page)
{
int totalcount;
var result = machine_YieldRepository.QueryMachine_Yields(searchModel, page, out totalcount).ToList();
var bd = new PagedListModel <Machine_YieldDTO>(totalcount, result);
return(bd);
}
public ActionResult QueryMachine_Yields(Machine_YieldDTO search, Page page)
{
search.Plant_Organization_UID = GetPlantOrgUid();
var apiUrl = string.Format("MachineYieldReport/QueryMachine_YieldsAPI");
HttpResponseMessage responMessage = APIHelper.APIPostAsync(search, page, apiUrl);
var result = responMessage.Content.ReadAsStringAsync().Result;
return(Content(result, "application/json"));
}
public IHttpActionResult ExportMachineReprotAPI(int plantId, int optypeId, int funplantId, string customer, string station, string machine_ID)
{
var searchModel = new Machine_YieldDTO();
searchModel.Plant_Organization_UID = plantId;
searchModel.BG_Organization_UID = optypeId;
searchModel.FunPlant_Organization_UID = funplantId;
searchModel.PIS_Customer_Name = customer;
searchModel.PIS_Station_Name = station;
searchModel.Machine_ID = machine_ID;
var bus = machineYieldReportService.ExportMachineReprot(searchModel);
return(Ok(bus));
}
public static List <Machine_YieldDTO> SetMachine_YieldDTOs(List <MachineYield> MachineYields, List <Machine_YieldDTO> machine_YieldDTOs, int Machine_Station_UID, DateTime startTime, DateTime endTime)
{
foreach (var item in MachineYields)
{
Machine_YieldDTO tempMachine_YieldDTO = new Machine_YieldDTO();
tempMachine_YieldDTO.Machine_Station_UID = Machine_Station_UID;
tempMachine_YieldDTO.Machine_ID = item.Machine;
tempMachine_YieldDTO.InPut_Qty = item.Input;
tempMachine_YieldDTO.NG_Qty = item.NG;
tempMachine_YieldDTO.NG_Point_Qty = item.NGP;
tempMachine_YieldDTO.StarTime = startTime;
tempMachine_YieldDTO.EndTime = endTime;
tempMachine_YieldDTO.Created_Date = DateTime.Now;
machine_YieldDTOs.Add(tempMachine_YieldDTO);
}
return(machine_YieldDTOs);
}
public List <Machine_YieldDTO> ExportMachineReprot(Machine_YieldDTO searchModel)
{
var result = machine_YieldRepository.ExportMachineReprot(searchModel);
return(result.ToList());
}
public IQueryable <Machine_YieldDTO> QueryMachine_Yields(Machine_YieldDTO searchModel, Page page, out int totalcount)
{
var query = from machine_Yield in DataContext.Machine_Yield
select new Machine_YieldDTO
{
Machine_Yield_UID = machine_Yield.Machine_Yield_UID,
Machine_Station_UID = machine_Yield.Machine_Station_UID,
Machine_ID = machine_Yield.Machine_ID,
InPut_Qty = machine_Yield.InPut_Qty,
NG_Qty = machine_Yield.NG_Qty,
NG_Point_Qty = machine_Yield.NG_Point_Qty,
StarTime = machine_Yield.StarTime,
EndTime = machine_Yield.EndTime,
Yield_Qty = machine_Yield.Yield_Qty,
Yield = machine_Yield.Yield,
NO_Yield = machine_Yield.NO_Yield,
Created_Date = machine_Yield.Created_Date,
MES_Customer_Name = machine_Yield.Machine_Station.Machine_Customer.MES_Customer_Name,
PIS_Customer_Name = machine_Yield.Machine_Station.Machine_Customer.PIS_Customer_Name,
MES_Station_Name = machine_Yield.Machine_Station.MES_Station_Name,
PIS_Station_Name = machine_Yield.Machine_Station.PIS_Station_Name,
Machine_Customer_UID = machine_Yield.Machine_Station.Machine_Customer.Machine_Customer_UID,
Plant_Organization_UID = machine_Yield.Machine_Station.Plant_Organization_UID,
BG_Organization_UID = machine_Yield.Machine_Station.BG_Organization_UID,
FunPlant_Organization_UID = machine_Yield.Machine_Station.FunPlant_Organization_UID,
Plant_Organization = machine_Yield.Machine_Station.System_Organization.Organization_Name,
BG_Organization = machine_Yield.Machine_Station.System_Organization1.Organization_Name,
FunPlant_Organization = machine_Yield.Machine_Station.System_Organization2.Organization_Name
};
if (searchModel.Plant_Organization_UID != 0)
{
query = query.Where(m => m.Plant_Organization_UID == searchModel.Plant_Organization_UID);
}
if (searchModel.BG_Organization_UID != 0)
{
query = query.Where(m => m.BG_Organization_UID == searchModel.BG_Organization_UID);
}
if (searchModel.FunPlant_Organization_UID != null && searchModel.FunPlant_Organization_UID != 0)
{
query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID);
}
if (searchModel.Machine_Customer_UID != 0)
{
query = query.Where(m => m.Machine_Customer_UID == searchModel.Machine_Customer_UID);
}
if (searchModel.Machine_Station_UID != 0)
{
query = query.Where(m => m.Machine_Station_UID == searchModel.Machine_Station_UID);
}
if (!string.IsNullOrWhiteSpace(searchModel.MES_Customer_Name))
{
query = query.Where(m => m.MES_Customer_Name == searchModel.MES_Customer_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.PIS_Customer_Name))
{
query = query.Where(m => m.PIS_Customer_Name == searchModel.PIS_Customer_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.MES_Station_Name))
{
query = query.Where(m => m.MES_Station_Name == searchModel.MES_Station_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.PIS_Station_Name))
{
query = query.Where(m => m.PIS_Station_Name == searchModel.PIS_Station_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.Machine_ID))
{
query = query.Where(m => m.Machine_ID == searchModel.Machine_ID);
}
if (searchModel.StarTime != null)
{
query = query.Where(m => m.StarTime >= searchModel.StarTime);
}
if (searchModel.EndTime != null)
{
// DateTime nextTime = searchModel.EndTime.Value.Date.AddDays(1);
query = query.Where(m => m.EndTime <= searchModel.EndTime);
}
query = query.Where(m => m.Machine_ID != "" && m.Machine_ID != null);
//totalcount = query.Count();
//query = query.OrderByDescending(m => m.Created_Date).GetPage(page);
//return query;
//分组求和；
//var querysum = from item in query
var querysum = from item in query.ToList()
group item by new { weno = item.Machine_Station_UID, wename = item.Machine_ID } into g
select new Machine_YieldDTO()
{
Machine_Station_UID = g.Select(o => o.Machine_Station_UID).First(),
Machine_ID = g.Select(o => o.Machine_ID).First(),
InPut_Qty = g.Sum(o => o.InPut_Qty),
NG_Qty = g.Sum(o => o.NG_Qty),
NG_Point_Qty = g.Sum(o => o.NG_Point_Qty),
MES_Customer_Name = g.Select(o => o.MES_Customer_Name).First(),
PIS_Customer_Name = g.Select(o => o.PIS_Customer_Name).First(),
MES_Station_Name = g.Select(o => o.MES_Station_Name).First(),
PIS_Station_Name = g.Select(o => o.PIS_Station_Name).First(),
Machine_Customer_UID = g.Select(o => o.Machine_Customer_UID).First(),
Plant_Organization_UID = g.Select(o => o.Plant_Organization_UID).First(),
BG_Organization_UID = g.Select(o => o.BG_Organization_UID).First(),
FunPlant_Organization_UID = g.Select(o => o.FunPlant_Organization_UID).First(),
Plant_Organization = g.Select(o => o.Plant_Organization).First(),
BG_Organization = g.Select(o => o.BG_Organization).First(),
FunPlant_Organization = g.Select(o => o.FunPlant_Organization).First()
};
//求和的结果查询出来，之后再求算良率，不良率，良品数等。
var queryreturn = SetMachine_YieldDTO(querysum.ToList());
totalcount = queryreturn.Count();
queryreturn = queryreturn.OrderByDescending(m => m.Machine_Station_UID).GetPage(page);
return(queryreturn);
}
public List <Machine_YieldDTO> ExportMachineReprot(Machine_YieldDTO searchModel)
{
var query = from machine_Yield in DataContext.Machine_Yield
select new Machine_YieldDTO
{
Machine_Yield_UID = machine_Yield.Machine_Yield_UID,
Machine_Station_UID = machine_Yield.Machine_Station_UID,
Machine_ID = machine_Yield.Machine_ID,
InPut_Qty = machine_Yield.InPut_Qty,
NG_Qty = machine_Yield.NG_Qty,
NG_Point_Qty = machine_Yield.NG_Point_Qty,
StarTime = machine_Yield.StarTime,
EndTime = machine_Yield.EndTime,
Yield_Qty = machine_Yield.Yield_Qty,
Yield = machine_Yield.Yield,
NO_Yield = machine_Yield.NO_Yield,
Created_Date = machine_Yield.Created_Date,
MES_Customer_Name = machine_Yield.Machine_Station.Machine_Customer.MES_Customer_Name,
PIS_Customer_Name = machine_Yield.Machine_Station.Machine_Customer.PIS_Customer_Name,
MES_Station_Name = machine_Yield.Machine_Station.MES_Station_Name,
PIS_Station_Name = machine_Yield.Machine_Station.PIS_Station_Name,
Machine_Customer_UID = machine_Yield.Machine_Station.Machine_Customer.Machine_Customer_UID,
Plant_Organization_UID = machine_Yield.Machine_Station.Plant_Organization_UID,
BG_Organization_UID = machine_Yield.Machine_Station.BG_Organization_UID,
FunPlant_Organization_UID = machine_Yield.Machine_Station.FunPlant_Organization_UID
};
if (searchModel.Plant_Organization_UID != 0)
{
query = query.Where(m => m.Plant_Organization_UID == searchModel.Plant_Organization_UID);
}
if (searchModel.BG_Organization_UID != 0)
{
query = query.Where(m => m.BG_Organization_UID == searchModel.BG_Organization_UID);
}
if (searchModel.FunPlant_Organization_UID != null && searchModel.FunPlant_Organization_UID != 0)
{
query = query.Where(m => m.FunPlant_Organization_UID == searchModel.FunPlant_Organization_UID);
}
if (searchModel.Machine_Customer_UID != 0)
{
query = query.Where(m => m.Machine_Customer_UID == searchModel.Machine_Customer_UID);
}
if (!string.IsNullOrWhiteSpace(searchModel.MES_Customer_Name))
{
query = query.Where(m => m.MES_Customer_Name == searchModel.MES_Customer_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.PIS_Customer_Name))
{
query = query.Where(m => m.PIS_Customer_Name == searchModel.PIS_Customer_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.MES_Station_Name))
{
query = query.Where(m => m.MES_Station_Name == searchModel.MES_Station_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.PIS_Station_Name))
{
query = query.Where(m => m.PIS_Station_Name == searchModel.PIS_Station_Name);
}
if (!string.IsNullOrWhiteSpace(searchModel.Machine_ID))
{
query = query.Where(m => m.Machine_ID == searchModel.Machine_ID);
}
if (searchModel.StarTime != null)
{
query = query.Where(m => m.StarTime >= searchModel.StarTime);
}
if (searchModel.EndTime != null)
{
DateTime nextTime = searchModel.EndTime.Value.Date.AddDays(1);
query = query.Where(m => m.EndTime < nextTime);
}
return(query.ToList());
}
