private void AddCombBox() { try { // 任务类型 CBitemid.Items.Add(ItemId.固定辊台正向 + " - " + ItemId.GetItemIdName(ItemId.固定辊台正向)); CBitemid.Items.Add(ItemId.固定辊台反向 + " - " + ItemId.GetItemIdName(ItemId.固定辊台反向)); CBitemid.Items.Add(ItemId.摆渡车正向 + " - " + ItemId.GetItemIdName(ItemId.摆渡车正向)); CBitemid.Items.Add(ItemId.摆渡车反向 + " - " + ItemId.GetItemIdName(ItemId.摆渡车反向)); CBitemid.Items.Add(ItemId.运输车正向 + " - " + ItemId.GetItemIdName(ItemId.运输车正向)); CBitemid.Items.Add(ItemId.运输车反向 + " - " + ItemId.GetItemIdName(ItemId.运输车反向)); CBitemid.Items.Add(ItemId.行车取货 + " - " + ItemId.GetItemIdName(ItemId.行车取货)); CBitemid.Items.Add(ItemId.行车放货 + " - " + ItemId.GetItemIdName(ItemId.行车放货)); CBitemid.Items.Add(ItemId.摆渡车复位 + " - " + ItemId.GetItemIdName(ItemId.摆渡车复位)); CBitemid.Items.Add(ItemId.摆渡车定位固定辊台 + " - " + ItemId.GetItemIdName(ItemId.摆渡车定位固定辊台)); CBitemid.Items.Add(ItemId.摆渡车定位运输车 + " - " + ItemId.GetItemIdName(ItemId.摆渡车定位运输车)); CBitemid.Items.Add(ItemId.运输车定位 + " - " + ItemId.GetItemIdName(ItemId.运输车定位)); CBitemid.Items.Add(ItemId.运输车复位1 + " - " + ItemId.GetItemIdName(ItemId.运输车复位1)); CBitemid.Items.Add(ItemId.运输车复位2 + " - " + ItemId.GetItemIdName(ItemId.运输车复位2)); CBitemid.Items.Add(ItemId.运输车对接定位 + " - " + ItemId.GetItemIdName(ItemId.运输车对接定位)); CBitemid.Items.Add(ItemId.行车轨道定位 + " - " + ItemId.GetItemIdName(ItemId.行车轨道定位)); CBitemid.Items.Add(ItemId.行车库存定位 + " - " + ItemId.GetItemIdName(ItemId.行车库存定位)); CBitemid.Items.Add(ItemId.行车复位 + " - " + ItemId.GetItemIdName(ItemId.行车复位)); } catch (Exception e) { Notice.Show(e.Message, "错误", 3, MessageBoxIcon.Error); } }
/// <summary> /// 异常日志 /// </summary> /// <param name="item"></param> /// <param name="order"></param> /// <param name="err"></param> /// <returns></returns> public String GetLogMessE(WCS_TASK_ITEM item, byte[] order, String err) { String message = String.Format(@"【Error】{0}({1}):WCS单号[ {2} ],ID[ {3} ],设备号[ {4} ],异常信息[ {5} ].", ItemId.GetItemIdName(item.ITEM_ID), item.ITEM_ID, item.WCS_NO, item.ID, item.DEVICE, err); return(message); }
/// <summary> /// 发送命令日志 /// </summary> /// <param name="item"></param> /// <param name="order"></param> /// <returns></returns> public String GetLogMess(WCS_TASK_ITEM item, byte[] order) { String ORDER = DataControl._mStools.BytetToString(order); String message = String.Format(@"【SendOrder】{0}({1}):WCS单号[ {2} ],ID[ {3} ],设备号[ {4} ],来源[ {5} ],目标[ {6} ],指令[ {7} ].", ItemId.GetItemIdName(item.ITEM_ID), item.ITEM_ID, item.WCS_NO, item.ID, item.DEVICE, item.LOC_FROM, item.LOC_TO, ORDER); return(message); }
private void UpdateTask() { String sql = String.Format(@"select * From wcs_task_item where id = '{0}'", _ID); DataTable dt = DataControl._mMySql.SelectAll(sql); if (DataControl._mStools.IsNoData(dt)) { Notice.Show("异常:找不到资讯!", "错误", 3, MessageBoxIcon.Error); this.Close(); } WCS_TASK_ITEM item = dt.ToDataEntity <WCS_TASK_ITEM>(); // 锁定 TBwcsno.Text = item.WCS_NO; TBlocfrom.Text = item.LOC_FROM; TBlocto.Text = item.LOC_TO; CBitemid.Text = item.ITEM_ID + " - " + ItemId.GetItemIdName(item.ITEM_ID); TBwcsno.IsEnabled = false; CBitemid.IsEnabled = false; AddCombBoxForDev(item.DEVICE, item.STATUS); BTNuse.Content = "更新"; _DEV = item.DEVICE; }
private void GetDGitemInfo() { try { if (string.IsNullOrWhiteSpace(wcsNO)) { return; } // 清空数据 dt = null; DGitem.ItemsSource = null; sql = String.Format(@"select WCS_NO WCS清单号,ITEM_ID 作业类型,DEVICE 绑定设备号,LOC_FROM 来源,LOC_TO 目的, (case when STATUS = 'N' then '不可执行' when STATUS = 'Q' then '请求执行' when STATUS = 'W' then '任务中' when STATUS = 'R' then '交接中' when STATUS = 'E' then '出现异常' when STATUS = 'Y' then '完成任务' when STATUS = 'X' then '失效' else '' end) 作业状态,CREATION_TIME 创建时间,ID from wcs_task_item where WCS_NO = '{0}' order by ID desc", wcsNO); // 获取数据 dt = DataControl._mMySql.SelectAll(sql); DGitem.ItemsSource = dt.DefaultView; // 中文释义 foreach (DataRowView dr in DGitem.ItemsSource) { dr.Row[1] = ItemId.GetItemIdName(dr.Row[1].ToString()); } } catch (Exception ex) { throw ex; } }