/// <summary> /// 生成指令 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SendOrder_Click(object sender, EventArgs e) { try { // 获取清单号 if (DGcommand.SelectedItem == null) { Notice.Show("请选择需要生成指令的清单!", "提示", 3, MessageBoxIcon.Info); return; } string wcs = (DGcommand.SelectedItem as DataRowView).Row[0].ToString(); // 获取 请求执行 的任务对应的 ITEM 资讯 String sql = String.Format(@"select * from WCS_TASK_ITEM where STATUS in ('{1}','{2}') and WCS_NO = '{0}' order by CREATION_TIME", wcs, ItemStatus.请求执行, ItemStatus.任务中); DataTable dtitem = DataControl._mMySql.SelectAll(sql); if (DataControl._mStools.IsNoData(dtitem)) { Notice.Show("无可生成指令的任务!", "错误", 3, MessageBoxIcon.Error); return; } List <WCS_TASK_ITEM> itemList = dtitem.ToDataList <WCS_TASK_ITEM>(); // 遍历处理任务 foreach (WCS_TASK_ITEM item in itemList) { _TASK.CreateAndAddTaskList(item); } RefreshData(); GetDGitemInfo(); Notice.Show("生成完成!", "完成", 3, MessageBoxIcon.Success); } catch (Exception ex) { Notice.Show("生成失败: " + ex.ToString(), "错误", 3, MessageBoxIcon.Error); } }