/// <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)); }