YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Task/FrmWCS_TaskDIS.cs

using DevComponents.DotNetBar.Layout;
using DevComponents.DotNetBar.SuperGrid;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using WCS.Data.Models;
using WCS_Client;
using WCS_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.Frm
{
    public partial class FrmWCS_TaskDIS : Form
    {
        int wcs_task_no = 0;
        public FrmWCS_TaskDIS()
        {
            InitializeComponent();
            InitFrm();
        }
        private void InitFrm() 
        {
            List<GridColumn> GCList = new List<GridColumn>()
            {
                SuperGridUtil.Get_GridColumn("ID", "任务ID号", 80),
                SuperGridUtil.Get_GridColumn("WMSTASK", "WMS任务号", 80),
                SuperGridUtil.Get_GridColumn("TaskGroupKey", "任务组编号", 140),
                SuperGridUtil.Get_GridColumn("task_comtypech", "任务类型", 80),
                SuperGridUtil.Get_GridColumn("task_wkstatusch", "任务状态", 100),
                SuperGridUtil.Get_GridColumn("BARCODE", "条码", 160),
                SuperGridUtil.Get_GridColumn("ADDRFROM", "起始地址", 100),
                SuperGridUtil.Get_GridColumn("ADDRCURRENT", "当前地址", 80),
                SuperGridUtil.Get_GridColumn("ADDRNEXT", "下个地址", 80),
                SuperGridUtil.Get_GridColumn("ADDRTO", "目的地址", 100),
                SuperGridUtil.Get_GridColumn("Position", "目标产线", 100),//ADDRline
                SuperGridUtil.Get_GridColumn("DEVICE", "堆垛机编号", 80),
                SuperGridUtil.Get_GridColumn("TUNNEL", "巷道", 70),
                SuperGridUtil.Get_GridColumn("Priority", "优先级", 60),
                SuperGridUtil.Get_GridColumn("PALLETTYPE", "托盘类型", 80),
                //SuperGridUtil.Get_GridColumn("TASK_RGVNO", "RGV编号", 70),
                SuperGridUtil.Get_GridColumn("GROUPTASK", "分组编号", 80),
                SuperGridUtil.Get_GridColumn("AgvTask", "AGV任务号", 100),
                SuperGridUtil.Get_GridColumn("TASK_ADDUSERNO", "创建用户", 100),
                SuperGridUtil.Get_Datetime_GridColumn("CREATETIME", "创建时间", 130),
                SuperGridUtil.Get_Datetime_GridColumn("STARTTIME", "开始时间", 130),
                SuperGridUtil.Get_Datetime_GridColumn("ENDTIME", "结束时间", 130),
                SuperGridUtil.Get_GridColumn("UPDATEUSER", "修改用户", 100),
                SuperGridUtil.Get_Datetime_GridColumn("UPDATETIME", "修改时间", 130),
                SuperGridUtil.Get_GridColumn("PRODLINE", "产线", 100),
                SuperGridUtil.Get_GridColumn("SCSTATION", "站台号", 100),
               // SuperGridUtil.Get_GridColumn("SonTrayColorNo", "子托盘颜色", 100),
               // SuperGridUtil.Get_GridColumn("TASK_WEIGHT", "箱子重量", 100),
               //SuperGridUtil.Get_GridColumn("TASK_STACKINGTYPE", "垛型", 100)
                //SuperGridUtil.Get_CheckBoxX_GridColumn("Task_IsInventory", "是否盘点任务", 80),
                //SuperGridUtil.Get_CheckBoxX_GridColumn("Task_IsEmptyBox", "是否空箱", 80),
            };
            List<LayoutControlItem> LCIList = new List<LayoutControlItem>();

            LCIList.Add(LCItemUtil.Add_TextboxX("ID", "WCS任务号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ID like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("WMSTASK", "WMS任务号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.WMSTASK like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("TaskGroupKey", "任务组编号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.TaskGroupKey like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("BARCODE", "条码:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.BARCODE like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("ADDRFROM", "起始地址:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ADDRFROM like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("ADDRCURRENT", "当前地址:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ADDRCURRENT like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("ADDRNEXT", "下个地址:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ADDRNEXT like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("ADDRTO", "目的地址:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.ADDRTO like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("Position", "目标产线:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Position like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("DEVICE", "堆垛机编号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.DEVICE like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_ComboBoxEx("TYPE", "任务类型:", 10, null, SubmitMethods));
            TryCachHelper.TryExecute((db) =>
            {

                var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "TYPE").ToList();
                DataTable dt = new DataTable();
                DataRow dr;
                dt.Columns.Add("MEP_MAPPINGNO");
                dt.Columns.Add("MEP_MAPPINGCHNAME");
                for (int i = 0; i < dtsex.Count; i++)
                {
                    dr = dt.NewRow();
                    dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
                    dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
                    dt.Rows.Add(dr);
                }
                LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
                LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.TYPE like '%{0}%'" };
            });

            LCIList.Add(LCItemUtil.Add_ComboBoxEx("ZONE", "区域:", 15, null, SubmitMethods));
            TryCachHelper.TryExecute((db) =>
            {
                var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "ZONE").ToList();
                DataTable dt = new DataTable();
                DataRow dr;
                dt.Columns.Add("MEP_MAPPINGNO");
                dt.Columns.Add("MEP_MAPPINGCHNAME");
                for (int i = 0; i < dtsex.Count; i++)
                {
                    dr = dt.NewRow();
                    switch (dtsex[i].MEP_MAPPINGNO)
                    {
                        case 1:
                            dr["MEP_MAPPINGNO"] = ".ADDRTO IN ('G1561','G1538','G1574','G1509','G1469')";
                            break;
                        case 2:
                            dr["MEP_MAPPINGNO"] = ".ADDRFROM IN ('1157','1158')";
                            break;
                        case 3:
                            dr["MEP_MAPPINGNO"] = ".ADDRFROM IN ('3052','3053','3005','3004')";
                            break;
                        case 4:
                            dr["MEP_MAPPINGNO"] = ".ADDRFROM IN ('1028','1029')";
                            break;
                        case 5:
                            dr["MEP_MAPPINGNO"] = ".ADDRFROM IN ('1386','1387','1435','1436')";
                            break;
                        case 6:
                            dr["MEP_MAPPINGNO"] = ".ADDRTO IN ('G1340')";
                            break;
                    }
                    dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
                    dt.Rows.Add(dr);
                }
                LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
                LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t {0}" };
            });


            LCIList.Add(LCItemUtil.Add_ComboBoxEx("STATUS", "任务状态:", 15, null, SubmitMethods));
            TryCachHelper.TryExecute((db) =>
            {

                var dtsex = db.Queryable<WCS_MAPPINGENTRY>().Where(v => v.MEP_MAPPINGTYPE == "STATUS").ToList();
                DataTable dt = new DataTable();
                DataRow dr;
                dt.Columns.Add("MEP_MAPPINGNO");
                dt.Columns.Add("MEP_MAPPINGCHNAME");
                for (int i = 0; i < dtsex.Count; i++)
                {
                    dr = dt.NewRow();
                    dr["MEP_MAPPINGNO"] = dtsex[i].MEP_MAPPINGNO;
                    dr["MEP_MAPPINGCHNAME"] = dtsex[i].MEP_MAPPINGCHNAME;
                    dt.Rows.Add(dr);
                }
                LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "MEP_MAPPINGNO", "MEP_MAPPINGCHNAME");
                LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "t.STATUS like '%{0}%'" };
            });


            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods));
            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));

            uC_QueryPage1.Init_QueryPage(86, true, true, "", GCList, LCIList, QueryPageDataMethods, RefreshRoleMethods, DoubleClikMethod, null, null);
            uC_QueryPage1.ClearLCItemValue();
            CommonShow.ShowProcessing("正在处理中，请稍候...", this, (obj) =>
            {
                uC_QueryPage1.RefreshData(1, 0);
            }, null);
        }
        private PageData QueryPageDataMethods(int PageIndex, int PageSize)
        {
            string _SQLText = @"select t.*,m.MEP_MAPPINGCHNAME task_comtypech,me.MEP_MAPPINGCHNAME task_wkstatusch,REPLACE(Position, 'Opp_205_', '') AS Position from (SELECT A.ID,A.ADDRFROM,A.ADDRNEXT,A.ADDRTO,A.AgvTask,A.BARCODE,A.CREATETIME,A.DEVICE,A.DOCID,A.ENABLED,A.ENDTIME,A.FLOOR,A.FULLQTY,A.HEIGHT,
A.PRODLINE,A.ManualRemarks,A.PALLETTYPE,A.Priority,A.SRMSTATION,A.STARTTIME,A.STATUS,A.TaskGroupKey,A.TUNNEL,A.TYPE,A.UPDATETIME,A.UPDATEUSER,
A.UPLOADED,A.WMSTASK
FROM WCS_TASK A
UNION SELECT B.ID,B.ADDRFROM,B.ADDRNEXT,B.ADDRTO,B.AgvTask,B.BARCODE,B.CREATETIME,B.DEVICE,B.DOCID,B.ENABLED,B.ENDTIME,B.FLOOR,B.FULLQTY,B.HEIGHT,
B.PRODLINE,B.ManualRemarks,B.PALLETTYPE,B.Priority,B.SRMSTATION,B.STARTTIME,B.STATUS,B.TaskGroupKey,B.TUNNEL,B.TYPE,B.UPDATETIME,B.UPDATEUSER,
B.UPLOADED,B.WMSTASK
FROM WCS_TASK_OLD B) t 
left join WCS_MAPPINGENTRY m on t.TYPE = m.MEP_MAPPINGNO and m.MEP_MAPPINGTYPE = 'TYPE' 
left join WCS_MAPPINGENTRY me on t.STATUS = me.MEP_MAPPINGNO and me.MEP_MAPPINGTYPE = 'STATUS'
left join WCS_AGVTASK a on a.ID=t.AgvTask 
where 1=1 and t.STATUS > 98 ";
            string _Orderby = "CREATETIME desc ";

            PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, PageSize);
            return pd;
        }
        private void SubmitMethods(string LCName) 
        {
            if (LCName == "btn_QDB")
            {
                uC_QueryPage1.RefreshData();
            }
            else if (LCName == "btn_QClear")
            {
                uC_QueryPage1.ShowOpaqueLayer();
                uC_QueryPage1.ClearLCItemValue();
                uC_QueryPage1.RefreshData(1, 0);
                uC_QueryPage1.HideOpaqueLayer();
            }
        }
        private void DoubleClikMethod(DataRow dr)
        {
            wcs_task_no = Convert.ToInt32(dr["TASK_NO"].ToString());
            FrmWCS_TaskDIS_DTL Frm = new FrmWCS_TaskDIS_DTL(wcs_task_no);
            Frm.Show();
        }
        private void RefreshRoleMethods(bool ChkValue) 
        {

        }
    }
}