private List <updateList> CreateListRoll()
{
List <updateList> AVO5data = new List <updateList>();
DateTime dtTMP = DateTime.Now.AddDays(-100);
using (l2dataAVO5Entities dbContext = new l2dataAVO5Entities())
{
AVO5data = 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(AVO5data);
}
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 (l2dataAVO5Entities dbContext = new l2dataAVO5Entities())
{
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 (l2dataAVO5Entities dbContext = new l2dataAVO5Entities())
{
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_LoadAVO5DTEventsOTM(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 (l2dataAVO5Entities dbContext = new l2dataAVO5Entities())
{
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);
}
