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