public LineStatistics GetStatisticsByLine(int lineId)
{
IntegramMESDataContext db = new IntegramMESDataContext();
var statistic = db.IWS_SP_GetProductionCurrentStatistics().FirstOrDefault();
if (lineId == 1)
{
return new LineStatistics
{
FTT = (double)statistic.FirstRowFTT,
Performance = (int)statistic.FrontPerformance,
Production = (int)statistic.FirstRowProduction,
Repairs = (int)statistic.FirstRowRepairs,
RollingTarget = (int)statistic.FrontRollingTarget,
RollingTargetPercent = (int)statistic.RearRollingTargetPercent,
WAPProduction = (int)statistic.WAPProduction,
TotalShiftLoadsShipped = (int)statistic.TotalShiftLoadsShipped,
TotalLoadsShipped = (int)statistic.TotalLoadsShipped,
ShipBank = (int)statistic.ShipBank,
FrontCleanLoads = (int)statistic.FrontCleanLoads,
Inventory = statistic.FrontInventory,
RearCleanLoads = (int)statistic.RearCleanLoads,
AGVCount = statistic.FirstRowAgvCount,
AGVCountVariance = statistic.FirstRowAgvVariance,
};
}
else if (lineId == 2)
{
return new LineStatistics
{
FTT = (double)statistic.SecondRowFTT,
Performance = (int)statistic.RearPerformance,
Production = (int)statistic.SecondRowProduction,
Repairs = (int)statistic.SecondRowRepairs,
RollingTarget = (int)statistic.RearRollingTarget,
RollingTargetPercent = (int)statistic.RearRollingTargetPercent,
WAPProduction = (int)statistic.WAPProduction,
TotalShiftLoadsShipped = (int)statistic.TotalShiftLoadsShipped,
TotalLoadsShipped = (int)statistic.TotalLoadsShipped,
ShipBank = (int)statistic.ShipBank,
FrontCleanLoads = (int)statistic.FrontCleanLoads,
RearCleanLoads = (int)statistic.RearCleanLoads,
Inventory = statistic.RearInventory,
AGVCount = statistic.SecondRowAgvCount,
AGVCountVariance = statistic.SecondRowAgvVariance,
};
}
else if (lineId == 3)
{
return new LineStatistics
{
FTT = (double)statistic.ThirdRowFTT,
Performance = (int)statistic.RearPerformance,
Production = (int)statistic.ThirdRowProduction,
Repairs = (int)statistic.ThirdRowRepairs,
RollingTarget = (int)statistic.RearRollingTarget,
RollingTargetPercent = (int)statistic.RearRollingTargetPercent,
WAPProduction = (int)statistic.WAPProduction,
TotalShiftLoadsShipped = (int)statistic.TotalShiftLoadsShipped,
TotalLoadsShipped = (int)statistic.TotalLoadsShipped,
ShipBank = (int)statistic.ShipBank,
FrontCleanLoads = (int)statistic.FrontCleanLoads,
RearCleanLoads = (int)statistic.RearCleanLoads,
Inventory = statistic.RearInventory,
AGVCount = statistic.ThirdRowAgvCount,
AGVCountVariance = statistic.ThirdRowAgvVariance,
};
}
return null;
}
public IWS_SP_GetProductionCurrentStatisticsResult GetCurrentStatistic()
{
IntegramMESDataContext db = new IntegramMESDataContext();
var statistic = db.IWS_SP_GetProductionCurrentStatistics().FirstOrDefault();
return statistic;
}