public List <blpStoreRes> BLPAdd([FromBody] blpStorePrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforBLPAdd @workNo='{prm.workNo}',@tabID='{prm.tabID}',@tabwlNo='{prm.tabwlNo}',@tabwlDesc='{prm.tabwlDesc}',@tabNum='{prm.tabNum}',@tabPos='{prm.tabPos}',@tabFDesc='{prm.tabFDesc}',@tabRPsNum='{prm.tabRPsNum}',@tabPreason='{prm.tabPreason}',@tabTip='{prm.tabTip}'").ToList();
return(testData);
}
public List <blpStoreRes> BLPstore([FromBody] blpStorePrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforBLPStore @workNo='{prm.workNo}',@wlNo='{prm.wlNo}',@wlDesc='{prm.wlDesc}',@pLine='{prm.pLine}',@man='{prm.man}',@date='{prm.date}',@Dpart='{prm.Dpart}',@Cgroup='{prm.Cgroup}',@bgNo='{prm.bgNo}',@tabID='{prm.tabID}',@tabwlNo='{prm.tabwlNo}',@tabwlDesc='{prm.tabwlDesc}',@tabNum='{prm.tabNum}',@tabPos='{prm.tabPos}',@tabFDesc='{prm.tabFDesc}',@tabRPsNum='{prm.tabRPsNum}',@tabPreason='{prm.tabPreason}',@tabTip='{prm.tabTip}'").ToList();
return(testData);
}
