public List <blpStoreRes> delBGD([FromBody] BGDeditPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"execute QforBGDDelete @bgNo='{prm.bgNo}'").ToList();
return(testData);
}
public List <blpStoreRes> editCfm([FromBody] BGDeditPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"execute QforBGDEdit @bgNo='{prm.bgNo}',@prodDate='{prm.prodDate}',@clsDate='{prm.clsDate}',@cls='{prm.cls}',@workMan='{prm.workMan}',@testStime='{prm.testStime}',@testEtime='{prm.testEtime}',@workStime='{prm.workStime}',@workEtime='{prm.workEtime}',@planStime='{prm.planStime}',@unplanStime='{prm.unplanStime}',@doneNum='{prm.doneNum}',@passNum='{prm.passNum}',@failNum='{prm.failNum}',@lf='{prm.lf}',@jf='{prm.jf}',@df='{prm.df}',@gf='{prm.gf}',@dcl='{prm.dcl}',@prodMan='{prm.prodMan}',@repassNum='{prm.repassNum}'").ToList();
return(testData);
}
