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