ECS/frm/frmWorkTaskSrh.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
//using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace ECS.frm
{
    public partial class frmWorkTaskSrh : Form
    {
        public JobControl JobCtl;

        public frmWorkTaskSrh(JobControl jobCtl)
        {
            InitializeComponent();
            JobCtl = jobCtl;

            dataGridView1.AutoGenerateColumns = false;
            PagingUC.PagingUC.Get_Paging += new PagingUC.PagingUC.GetPaging(Paging);
        }

        private void frmWorkTaskSrh_Load(object sender, EventArgs e)
        {
            RefreshDgv();

            dtp_DOPTDATEstart.Value = DateTime.Now.AddMonths(-1);
            cBNOPTTYPE.SelectedIndex = 0;
            cBNWKSTATUS.SelectedIndex = 0;
        }

        private void RefreshDgv()
        {
            dv1.DataSource = GetTaskData();
            Other.FormatDgv(dv1);
        }

        private DataTable GetTaskData()
        {
            string strM = "Select nWorkId  工控指令, cSysType  下发系统, cPosIdFrom  源仓位, cPosIdTo  目标仓位, nPalletId  托盘代号, ";
            strM += "CASE nOptType WHEN 1 THEN '整盘入库' WHEN 2 THEN '补充入库' WHEN 3 THEN '整盘出库' WHEN 4 THEN '分拣出库' WHEN 5 THEN '空盘入库' ";
            strM += "WHEN 6 THEN '空盘出库' WHEN 7 THEN '移库' WHEN 8 THEN '盘库' END  工控类型, nOptStation  操作台号,nPri  优先级, ";
            //strM += "cWHId  库别,CASE nWkStatus WHEN 0 THEN '未下发' WHEN 1 THEN '已下发' WHEN 2 THEN '开始执行' WHEN 99 THEN '执行完毕' END  工控进程 ";
            strM += "CASE nWkStatus when 1 then '等待执行' when 2 then '提升机入库响应' when 3 then '堆垛机出库响应' when 4 then 'HS/RGV出库响应' when 6 then '到达分拣口' when 15 then 'RGV(2/4)入库响应' when 16 then '操作台入库响应' ";
            strM += "when 17 then 'RGV(1/3)入库响应' when 18 then '堆垛机入库叉取' when 99 then '已完成' when 104 then '空取' when 105 then '重入' when 106 then '已删除' ";
            strM += "when 107 then '托盘出错' when 108 then '货位出错' end 工控进程 ";
            strM += "FROM  TWB_WorkTask WHERE nWkStatus>0 and nWkStatus<99";
            strM += "order by nWkStatus desc,nPRI desc,nWorkId asc ";

            return SQLHelper.ExecuteDs(strM).Tables[0];
        }

        private void btnDel_Click(object sender, EventArgs e)
        {
            #region

            if (dv1.SelectedRows.Count <= 0) return;
            if (Login.lgUserClass.Equals("0"))