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