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> 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 <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 <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 <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 <tabRes> getTab([FromBody] blpOpenPrm prm)
{
var model = new BorgWarnerMisSQLContext();
var testData = model.Database.SqlQuery <tabRes>($"EXECUTE dbo.QforBLPTabreNew @workNo='{prm.workNo}'").ToList();
return(testData);
}