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