public List <FTTset> FTTchartQuery([FromBody] queryParam prm)
{
var model = new BorgWarnerMisSQLContext();
var p1 = prm.prodLine;
var p2 = prm.dateUnit;
var s = prm.start.Date;
var e = prm.end.Date;
var testData = model.Database.SqlQuery <FTTset>($"EXECUTE dbo.QforFTT @prodline='{p1}',@du='{p2}',@start='{s}',@end='{e}'").ToList();
return(testData);
}
public List <OEEset> OEEchartQuery([FromBody] queryParam prm)
{
var model = new BorgWarnerMisSQLContext();
var p1 = prm.prodLine;
var p2 = prm.dateUnit;
var s = prm.start.Date;
var e = prm.end.Date;
var testData = model.Database.SqlQuery <OEEset>($"EXECUTE dbo.QforOEE @prodline='{p1}',@du='{p2}',@start='{s}',@end='{e}'") /*.Where(te=>te.日期>= prm.start && te.日期 <= prm.end )*/.ToList();
return(testData);
}
