public List <prodRes> BGDprod([FromBody] prodPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <prodRes>($"EXECUTE dbo.QforProdStart @workNo='{prm.workNo}',@workMan='{prm.workman}',@cGroup='{prm.cgroup}',@startTime='{prm.workStime}',@prodTime='{prm.prodStime}'").ToList();
return(testData);
}
public List <prodQueryRes> prodChart([FromBody] prodPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var p1 = prm.date;
var p2 = prm.dateunit;
var p3 = prm.status;
var testData = model.Database.SqlQuery <prodQueryRes>($"EXECUTE dbo.QforTopIssueProd @date='{p1}',@dateunit='{p2}',@status='{p3}'").ToList();
return(testData);
}