/// <summary>
///获取全部出货牌信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <List <DeviceSelectReturns> > GetShipCartAll(DeviceSelectReturns model)
{
string strLookMH = string.Format(@"select t.shipment_no,t.package_id from T_MES_MACHINE_USEINFO t where t.TECHNOLOGY='{0}'", model.TECHNOLOGY);
var res = (await pmes.GetSqlDataAsync(strLookMH)).DataToXml <DeviceSelectReturns>();
return(res);
}
/// <summary>
/// 设备文本选择监听事件
/// </summary>
/// <param name="model">{device_sn}</param>
/// <returns>[]</returns>
public async Task <DeviceSelectReturns> DeviceSelect(DeviceSelectParam model)
{
DeviceSelectReturns dr = new DeviceSelectReturns();
string strLookMH = string.Format(@"SELECT T.PACKAGE_ID,T.TECHNOLOGY,T.ENGINEER,T.GROUP_NAME,T.SHIPMENT_NO,T.FORMULA_NO,T.SOLID_CONTENT,T.REQUIREMENT,T.INPUT_SUM ,T.STIR_SUM,T.OUT_QTY,T.USER_NAME,T.TYPE_NAME from T_MES_MACHINE_USEINFO t where t.device_no='{0}' and t.statue=0", model.device_sn);
//var res = await base.SqlQuery<DeviceSelectReturns>(strLookMH);
var res = (await pmes.GetSqlDataAsync(strLookMH)).DataToXml <DeviceSelectReturns>();
if (res.Count > 0)
{
//获取组别相关的Package列表
GroupKeyPressParam getPackges = new GroupKeyPressParam()
{
groupName = res[0].GROUP_NAME, moNumber = res[0].TECHNOLOGY, productType = model.productType
};
res[0].PACKAGE_IDS = (await _dal.GetLook(getPackges)).SelectByItem <AgitationModel, GroupKeyPressReturns>(m => m.package_id, m => m.packagenumber, m => m.cell_model, m => m.engineer).FindAll(m => m.packagenumber == res[0].TECHNOLOGY);
return(res[0]);
}
else
{
return(dr);
}
}
public async Task <List <DeviceSelectReturns> > GetShipCartAll(DeviceSelectReturns model)
{
return(await _agitationServices.GetShipCartAll(model));
}
