/// <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 <DeviceSelectReturns> DeviceSelect(DeviceSelectParam jsondata)
{
return(await _agitationServices.DeviceSelect(jsondata));
}
/// <summary>
/// 设备文本改变监听事件
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <AgitationModel> GetLookMH(DeviceSelectParam model)
{
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);
return(await base.SqlQuerySingleAsync <AgitationModel>(strLookMH, new { }));
}
