public List <gydelRes> newTab([FromBody] gyeditPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <gydelRes>($"execute dbo.QforGYAdd @wlNo='{prm.wlNo}',@station='{prm.station}',@planCT='{prm.planCT}',@wlDesc='{prm.wlDesc}',@opac='{prm.opAc}',@oprTxt='{prm.oprTxt}',@bNum='{prm.bNum}',@cGroup='{prm.cGroup}',@type='{prm.type}',@stdVal='{prm.stdVal}',@binCap='{prm.binCap}',@bchNum='{prm.bchNum}',@prt='{prm.prt}',@subsidy='{prm.subsidy}',@coeff='{prm.coeff}'").ToList();
return(testData);
}
public List <BGDViewRes> BGDView([FromBody] BGDViewPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <BGDViewRes>($"select * from qforOrderDailySheetAS where 加工单元='{prm.line}' and cast(班次日期 as date) between cast(dbo.dateTransfer('{prm.pdateS}') as date) and cast(dbo.dateTransfer('{prm.pdateE}') as date) order by 班次日期 desc").ToList();
return(testData);
}
public List <blpStoreRes> closeOrd([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforCloseOrder @workNo='{prm.workNo}'").ToList();
return(testData);
}
public List <sbInfoRes> sbInfo([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <sbInfoRes>($"select 设备编号, 设备名称 from tblEquipmentInformation where 使用区域='{prm.workNo}' ORDER BY 设备编号").ToList();
return(testData);
}
public List <clsInfoRes> clsInfo([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <clsInfoRes>($"select 班组名称 from tblShift where 所属车间='{prm.workNo}'").ToList();
return(testData);
}
public List <blpStoreRes> adCfm([FromBody] adCfmPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforAndonComfirm @cfmMan='{prm.cfmMan}',@workNo='{prm.workNo}',@qType='{prm.qtype}'").ToList();
return(testData);
}
public List <bgdRes> BGDInfo([FromBody] bgdPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <bgdRes>($"EXECUTE dbo.QforGetBGDInfo @workNo='{prm.workNo}'").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);
}
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 <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> BGClose([FromBody] bgClosePrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <stopRes>($"EXECUTE dbo.QforBGDClose @bgNo='{prm.workNo}',@testT='{prm.testT}',@startT='{prm.startT}'").ToList();
return(testData);
}
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 <currRes> currOrd([FromBody] currPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <currRes>($"EXECUTE dbo.QforCurrOrder @station='{prm.prodLine}' ").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);
}
public List <adLogTabRes> reNewAdtab([FromBody] adLogPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <adLogTabRes>($"EXECUTE dbo.QforRenewAndonLog @workNo='{prm.workNo}',@qType='{prm.qType}'").ToList();
return(testData);
}
public List <tabRes> getTab([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <tabRes>($"EXECUTE dbo.QforBLPTabreNew @workNo='{prm.workNo}'").ToList();
return(testData);
}
public List <blpStoreRes> adResolve([FromBody] adResolvePrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforAndonResolve @solveMan='{prm.solveMan}',@workNo='{prm.workNo}',@qType='{prm.qtype}',@tmpSolve='{prm.tmpSolve}',@fReason='{prm.freason}',@plan='{prm.plan}',@planfnsDate='{prm.planfnsDate}'").ToList();
return(testData);
}
public List <zlOpenRes> zlAndonOpen([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <zlOpenRes>($"EXECUTE dbo.QforZLAndonOpen @workNo='{prm.workNo}'").ToList();
return(testData);
}
public List <empInfoRes> empInfo([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <empInfoRes>($"execute dbo.QforEmployeeSrh @line='{prm.workNo}'").ToList();
return(testData);
}
public List <blpStoreRes> zlAndonCfm([FromBody] zlCfmPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforZLAndon @workNo='{prm.workNo}',@order='{prm.order}',@fillMan='{prm.fillMan}',@Dpt='{prm.dpt}',@Cls='{prm.cls}',@Num='{prm.num}',@wlNo='{prm.wlNo}',@wlDesc='{prm.wlDesc}',@pos='{prm.pos}',@qDesc='{prm.qDesc}',@repassNum='{prm.rePsnum}',@sbNo='{prm.sbNo}',@reason='{prm.reason}',@tips='{prm.tips}',@andonMan='{prm.andonMan}'").ToList();
return(testData);
}
public List <empInfoRes> optr2Info()
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <empInfoRes>("SELECT [Name] as name,[Password] as pwd FROM tblemployees WHERE(Job=N'MT' or Job=N'ME') order by [Name]").ToList();
return(testData);
}
public List <allRes> allOrdDisp([FromBody] currPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <allRes>($"select * from qforAllOrderDisplay where 生产单元='{prm.prodLine}'").ToList();
return(testData);
}
public List <dptInfoRes> dptInfo()
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <dptInfoRes>("select 部门代码, 部门名称 from tblDept").ToList();
return(testData);
}
public List <blpStoreRes> sbAndonCfm([FromBody] sbCfmPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforSBAndon @workNo='{prm.workNo}',@priority='{prm.priority}',@sbStop='{prm.sbStop}',@sbMan='{prm.sbMan}',@sbDpt='{prm.sbDpt}',@sbNo='{prm.sbNo}',@sbName='{prm.sbName}',@station='{prm.station}',@qPart='{prm.qPart}',@qType='{prm.qType}',@qDesc='{prm.qDesc}',@sbSafe='{prm.sbSafe}'").ToList();
return(testData);
}
public List <gzPInfoRes> gzPInfo()
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <gzPInfoRes>("select 故障部位 from tblMalfunctionPosition").ToList();
return(testData);
}
public List <blpStoreRes> othAndonCfm([FromBody] othAndonPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <blpStoreRes>($"EXECUTE dbo.QforWebAndon @workNo='{prm.workNo}',@andonMan='{prm.adMan}',@andonType='{prm.adType}',@station='{prm.adStation}',@andonStop='{prm.adStop}',@andonsbNo='{prm.adsbNo}',@andonQdesc='{prm.adQdesc}'").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);
}
public List <reNewAdRes> reNewADLog([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <reNewAdRes>($"EXECUTE dbo.QforRenewAndonCount @workNo='{prm.workNo}'").ToList();
return(testData);
}
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 <gydelRes> GYdelete([FromBody] gydelPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <gydelRes>($"execute dbo.QforGYdelete @wlNo='{prm.wlNo}'").ToList();
return(testData);
}