public List <catePrm> category([FromBody] queryPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var p1 = prm.dateunit;
var s = prm.start;
var e = prm.end;
var stats = prm.stus;
var testData = model.Database.SqlQuery <catePrm>($"EXECUTE dbo.QforAndonCategoryPie @dateunit='{p1}',@start='{s}',@end='{e}',@status='{stats}'").ToList();
return(testData);
}
public List <AndonHourRate> hourRate([FromBody] queryPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var p1 = prm.dateunit;
var s = prm.start;
var e = prm.end;
var stats = prm.stus;
var testData = model.Database.SqlQuery <AndonHourRate>($"EXECUTE dbo.QforHourRate @dateunit='{p1}',@starttime='{s}',@endtime='{e}',@status='{stats}'").ToList();
return(testData);
}
