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