public List <logRes> stopLog([FromBody] stopPrm prm) { var model = new BorgWarnerMisSQLContext(); var testData = model.Database.SqlQuery <logRes>($"select * from qforStopLog where 报工编号='{prm.workNo}'").ToList(); return(testData); }
public List <stopRes> pContinue([FromBody] stopPrm prm) { var model = new BorgWarnerMisSQLContext(); var testData = model.Database.SqlQuery <stopRes>($"EXECUTE dbo.QforPContinue @workNo='{prm.workNo}',@stopTime='{prm.stopEnd}'").ToList(); return(testData); }
public List <stopRes> unPlanStop([FromBody] stopPrm prm) { var model = new BorgWarnerMisSQLContext(); var testData = model.Database.SqlQuery <stopRes>($"EXECUTE dbo.QforUnPlanStop @workNo='{prm.workNo}',@stopType='{prm.stopType}',@stopsType='{prm.stopsType}',@sbNo='{prm.sbNo}',@stopDesc='{prm.stopDesc}',@sMan='{prm.sMan}',@sStart='{prm.stopBegin}'").ToList(); return(testData); }