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