private List <updateList> CreateListRoll() { List <updateList> AVO3data = new List <updateList>(); DateTime dtTMP = DateTime.Now.AddDays(-100); using (l2dataAVO3Entities dbContext = new l2dataAVO3Entities()) { AVO3data = dbContext.sv_Web_RollProdLine. Where(p => p.DateCreate > dtTMP && p.LocalId != " "). OrderByDescending(p => p.DateCreate). Select(p => new updateList() { NumberLocalRoll = p.LocalId, NumberRoll = p.GlobalId + " ( " + p.LocalId + " )", LengthRoll = p.Length, WeightRoll = p.Weight.Value, WidthRoll = p.Width.Value, ThicknessRoll = p.Thickness.Value, DateCreate = (DateTime)p.DateCreate, Status = p.Status }).ToList(); } return(AVO3data); }
private List <StartFinish> LoadTimeProduction(string LocalNumber) { List <StartFinish> List = new List <StartFinish>(); List.Add(new StartFinish { DateStart = DateTime.Now.AddMinutes(-1), DateFinish = DateTime.Now }); using (l2dataAVO3Entities dbContext = new l2dataAVO3Entities()) { List = dbContext.sv_Web_TimeProduction. Where(p => p.LocalId == LocalNumber). Select(p => new StartFinish() { DateStart = (DateTime)p.DateCreate, DateFinish = (DateTime)p.DateProduction, NStend = p.GlobalId, ThStend = (decimal)p.Thickness, WidStend = (decimal)p.Width }).ToList(); ViewBag.StrNStend = List.ElementAt(0).NStend; ViewBag.StrThStend = List.ElementAt(0).ThStend.ToString(); ViewBag.StrWidStend = List.ElementAt(0).WidStend.ToString(); } return(List); }
private List <StartFinish> LoadTimeProductionOTM(string LocalNumber) { List <OTMParametrs> ListOTMParam = new List <OTMParametrs>(); string _tmpLocId = LocalNumber.Remove(6, LocalNumber.Length - 6); int _tmpNumOTM = Convert.ToInt32(LocalNumber.Remove(0, LocalNumber.Length - 1)); using (l2dataAVO3Entities dbContext = new l2dataAVO3Entities()) { ListOTMParam = dbContext.sp_web_LoadDetalOTM(_tmpLocId, _tmpNumOTM). Select(p => new OTMParametrs() { LocalId = p.LocalId, NumberOTM = (int)p.NumberOTM, Defect = p.Defect, LengthOffSet = (decimal)p.LengthOffSet, DefectLength = (decimal)p.DefectLength, DTEvents = (DateTime)p.DTEvents, DTCreateRoll = (DateTime)p.DTCreateRoll, DTProductionRoll = (DateTime)p.DTProductionRoll }).ToList(); } List <StartFinish> List = new List <StartFinish>(); List.Add(new StartFinish { DateStart = DateTime.Now.AddMinutes(-1), DateFinish = DateTime.Now }); using (l2l3interactionEntities dbContext = new l2l3interactionEntities()) { List = dbContext.sp_WebP_LoadAVO3DTEventsOTM(ListOTMParam.ElementAt(0).DTCreateRoll, ListOTMParam.ElementAt(0).DTProductionRoll, ListOTMParam.ElementAt(0).LengthOffSet, ListOTMParam.ElementAt(0).DefectLength). Select(p => new StartFinish() { DateStart = (DateTime)p.Start, DateFinish = (DateTime)p.Finish }).ToList(); } return(List); }
private List <StendList> loadRolInStend(string NStend) { List <StendList> list = new List <StendList>(); using (l2dataAVO3Entities dbContext = new l2dataAVO3Entities()) { list = dbContext.sp_web_RollInStend(NStend) .Select(p => new StendList { NInStend = p.NInStend, NStend = p.Stend, NRoll = p.LocalId, Length = p.Length, Weight = (decimal)p.Weight, Thickness = (decimal)p.Thickness, DateCreate = p.DateCreate, DateProduction = (DateTime)p.DateProduction, }).ToList(); } return(list); }
private List <AlldataList> CreateList() { List <AlldataList> AllData = new List <AlldataList>(); List <updateList> AVO3data = new List <updateList>(); List <updateList> AVO4data = new List <updateList>(); List <updateList> AVO5data = new List <updateList>(); DateTime dtTMP = DateTime.Now.AddHours(-1200); using (l2dataAVO3Entities dbContext = new l2dataAVO3Entities()) { AVO3data = dbContext.sv_Web_RollProdLine. Where(p => p.DateCreate > dtTMP). OrderByDescending(p => p.DateCreate). Take(10). //Аналог TOP 10 в SQL Select(p => new updateList() { NumberLocalRoll = p.LocalId, NumberRoll = p.GlobalId + " ( " + p.LocalId + " )", LengthRoll = p.Length, WeightRoll = p.Weight.Value, WidthRoll = p.Width.Value, ThicknessRoll = p.Thickness.Value, DateCreate = (DateTime)p.DateCreate, Status = p.Status }).ToList(); } using (l2dataAVO4Entities dbContext = new l2dataAVO4Entities()) { AVO4data = dbContext.sv_Web_RollProdLine. Where(p => p.DateCreate > dtTMP). OrderByDescending(p => p.DateCreate). Take(10). //Аналог TOP 10 в SQL Select(p => new updateList() { NumberLocalRoll = p.LocalId, NumberRoll = p.GlobalId + " ( " + p.LocalId + " )", LengthRoll = p.Length, WeightRoll = p.Weight.Value, WidthRoll = p.Width.Value, ThicknessRoll = p.Thickness.Value, DateCreate = (DateTime)p.DateCreate, Status = p.Status }).ToList(); } using (l2dataAVO5Entities dbContext = new l2dataAVO5Entities()) { AVO5data = dbContext.sv_Web_RollProdLine. Where(p => p.DateCreate > dtTMP). OrderByDescending(p => p.DateCreate). Take(10). //Аналог TOP 10 в SQL Select(p => new updateList() { NumberLocalRoll = p.LocalId, NumberRoll = p.GlobalId + " ( " + p.LocalId + " )", LengthRoll = p.Length, WeightRoll = p.Weight.Value, WidthRoll = p.Width.Value, ThicknessRoll = p.Thickness.Value, DateCreate = (DateTime)p.DateCreate, Status = p.Status }).ToList(); } for (int i = 0; i <= 9; i++) { AllData.Add(new AlldataList { AVO3_NumberLocalRoll = AVO3data.ElementAt(i).NumberLocalRoll, AVO3_NumberRoll = AVO3data.ElementAt(i).NumberRoll, AVO3_LengthRoll = AVO3data.ElementAt(i).LengthRoll, AVO3_WeightRoll = AVO3data.ElementAt(i).WeightRoll, AVO3_WidthRoll = AVO3data.ElementAt(i).WidthRoll, AVO3_ThicknessRoll = AVO3data.ElementAt(i).ThicknessRoll, AVO3_DateCreate = AVO3data.ElementAt(i).DateCreate, AVO3_Status = AVO3data.ElementAt(i).Status, AVO4_NumberLocalRoll = AVO4data.ElementAt(i).NumberLocalRoll, AVO4_NumberRoll = AVO4data.ElementAt(i).NumberRoll, AVO4_LengthRoll = AVO4data.ElementAt(i).LengthRoll, AVO4_WeightRoll = AVO4data.ElementAt(i).WeightRoll, AVO4_WidthRoll = AVO4data.ElementAt(i).WidthRoll, AVO4_ThicknessRoll = AVO4data.ElementAt(i).ThicknessRoll, AVO4_DateCreate = AVO4data.ElementAt(i).DateCreate, AVO4_Status = AVO4data.ElementAt(i).Status, AVO5_NumberLocalRoll = AVO5data.ElementAt(i).NumberLocalRoll, AVO5_NumberRoll = AVO5data.ElementAt(i).NumberRoll, AVO5_LengthRoll = AVO5data.ElementAt(i).LengthRoll, AVO5_WeightRoll = AVO5data.ElementAt(i).WeightRoll, AVO5_WidthRoll = AVO5data.ElementAt(i).WidthRoll, AVO5_ThicknessRoll = AVO5data.ElementAt(i).ThicknessRoll, AVO5_DateCreate = AVO5data.ElementAt(i).DateCreate, AVO5_Status = AVO5data.ElementAt(i).Status }); } return(AllData); }