/// <summary>
/// 打胶加载页面获取对应设备信息
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <MessageModel <List <GlueLoadReturns> > > GlueLoad(GlueLoadParam jsondata)
{
MessageModel <List <GlueLoadReturns> > message = new MessageModel <List <GlueLoadReturns> >();
message.response = (await _dal.GlueLoad(jsondata)).SelectByItem <GlueModel, GlueLoadReturns>(m => m.device_sn);
message.success = true;
message.msg = "";
return(message);
}
/// <summary>
///
/// </summary>
/// <param name="jsondata">设备编号</param>
/// <returns></returns>
public async Task <List <GlueModel> > GetGlueModel(GlueLoadParam jsondata)
{
string strLookMH = string.Format(@"select t.shipment_no shipCard, t.input_sum, t.out_qty outQTY, t.USER_NAME, s.item_value
from T_MES_MACHINE_USEINFO t, t_mes_stir_info s
where t.device_no = '{0}'
and t.statue = 0
and s.shipment_no = t.shipment_no
and s.item_name = '溶液名称'", jsondata.device_sn);
return(await base.SqlQuery <GlueModel>(strLookMH));
}
/// <summary>
/// 打胶页面加载设备信息
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <List <GlueModel> > GlueLoad(GlueLoadParam jsondata)
{
var result = await base.SqlQuery <GlueModel>(@"select h.device_sn, h.device_id, s1.work_stationname
from t_smo_workstationdevice w,
t_co_device h,
t_co_device d1,
t_smo_workstationdevice w1,
t_smo_workstation s1
where w.device_id = h.device_id
and w.work_stationid = s1.work_stationid
and d1.device_id = w1.device_id
and w1.work_stationid = s1.work_stationid
and d1.device_sn = @device_sn", new { device_sn = jsondata.device_sn });
return(result);
}
public async Task <MessageModel <List <GlueLoadReturns> > > DeviceLoad(GlueLoadParam jsondata)
{
return(await _glueServices.GlueLoad(jsondata));
}
/// <summary>
/// 获取设备正在作业出货牌信息
/// </summary>
/// <param name="jsondata"></param>
/// <returns></returns>
public async Task <List <DeviceSelectChangesReturns> > DeviceSelectChanges(GlueLoadParam jsondata)
{
return((await _dal.GetGlueModel(jsondata)).SelectByItem <GlueModel, DeviceSelectChangesReturns>(m => m.shipCard, m => m.input_sum, m => m.outQTY, m => m.USER_NAME, m => m.item_value));
}
