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