/// <summary>
/// 查询package计划
/// </summary>
/// <param name="model">moNumber,groupName,strType</param>
/// <returns></returns>
public async Task <List <AgitationModel> > GetLook(GroupKeyPressParam model)
{
string strLook = string.Format(@"select pa.package_id,
pa.packagenumber,
pa.group_no,
pa.cell_model,
pa.Plan_Fe_Number,
pa.engineer
from t_co_package pa
where pa.packagenumber = '{0}'
and pa.group_no='{1}'
and pa.polarity='{2}'", model.moNumber, model.groupName, model.productType.Substring(0, 2));
return(await base.SqlQuery <AgitationModel>(strLook, new { }));
}
/// <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);
}
}
/// <summary>
/// 组别回车监听事件
/// </summary>
/// <param name="model">{moNumber,groupName,productType}</param>
/// <returns>{}</returns>
public async Task <MessageModel <List <GroupKeyPressReturns> > > GroupKeyPress(GroupKeyPressParam model)
{
MessageModel <List <GroupKeyPressReturns> > message = new MessageModel <List <GroupKeyPressReturns> >();
message.msg = "查无该Package计划，请确认！";
message.success = false;
var result = (await _dal.GetLook(model)).SelectByItem <AgitationModel, GroupKeyPressReturns>(m => m.package_id, m => m.packagenumber, m => m.engineer, m => m.cell_model);
if (result.Count > 0)
{
message.success = true;
message.msg = "";
message.response = result;
}
return(message);
}
public async Task <MessageModel <List <GroupKeyPressReturns> > > GroupKeyPress(GroupKeyPressParam jsondata)
{
return(await _agitationServices.GroupKeyPress(jsondata));
}
