YG-PVC-WCS/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("TASK_NO", "WCS任务号", 80),
                SuperGridUtil.Get_GridColumn("TASK_WMSNO", "WMS任务号", 80),
                SuperGridUtil.Get_GridColumn("task_comtypech", "任务类型", 80),
                SuperGridUtil.Get_GridColumn("task_wkstatusch", "任务状态", 100),
                SuperGridUtil.Get_GridColumn("TASK_SYSTYPE", "下发系统", 80),
                SuperGridUtil.Get_GridColumn("TASK_BOXBARCODE", "条码", 230),
                SuperGridUtil.Get_GridColumn("TASK_POSIDFROM", "起始地址", 80),
                SuperGridUtil.Get_GridColumn("TASK_POSIDCUR", "当前地址", 80),
                SuperGridUtil.Get_GridColumn("TASK_POSIDNEXT", "下个地址", 80),
                SuperGridUtil.Get_GridColumn("TASK_POSIDTO", "目的地址", 80),
                SuperGridUtil.Get_GridColumn("TASK_PRIORITY", "优先级", 60),
                SuperGridUtil.Get_GridColumn("TASK_WHID", "仓库", 100),
                SuperGridUtil.Get_GridColumn("TASK_SRMNO", "堆垛机编号", 80),
                SuperGridUtil.Get_GridColumn("TASK_FromTunnelNum", "起始巷道", 70),
                SuperGridUtil.Get_GridColumn("TASK_EndTunnelNum", "目的巷道", 70),
                SuperGridUtil.Get_GridColumn("TASK_ITEM7", "预分配巷道", 80),
                SuperGridUtil.Get_GridColumn("TASK_ITEM8", "AGV任务Id", 100),
                SuperGridUtil.Get_GridColumn("TASK_RGVNO", "RGV编号", 70),
                SuperGridUtil.Get_GridColumn("TASK_ADDUSERNO", "创建用户", 100),
                SuperGridUtil.Get_Datetime_GridColumn("TASK_ADDDATETIME", "创建时间", 130),
                SuperGridUtil.Get_GridColumn("TASK_EDITUSERNO", "修改用户", 100),
                SuperGridUtil.Get_Datetime_GridColumn("TASK_EDITDATETIME", "修改时间", 130),
                SuperGridUtil.Get_Datetime_GridColumn("TASK_EDITDATETIME", "完成时间", 130)
                //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("TASK_NO", "WCS任务号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "TASK_NO like '%{0}%'" };

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

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

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

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

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

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

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

            LCIList.Add(LCItemUtil.Add_ComboBoxEx("Task_ComType", "任务类型:", 20, null, SubmitMethods));
            TryCachHelper.TryExecute((db) =>
            {
                var dtsex = db.Queryable<WCS_DICTIONARY>().Where(v => v.DIC_PARENT_CODE == "TaskType").ToList();
                DataTable dt = new DataTable();
                DataRow dr;
                dt.Columns.Add("DIC_SORT");
                dt.Columns.Add("DIC_NAME");
                for (int i = 0; i < dtsex.Count; i++)
                {
                    dr = dt.NewRow();
                    dr["DIC_SORT"] = dtsex[i].DIC_SORT;
                    dr["DIC_NAME"] = dtsex[i].DIC_NAME;
                    dt.Rows.Add(dr);
                }
                LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "DIC_SORT", "DIC_NAME");
                LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "TASK_COMTYPE like '%{0}%'" };
            });


            LCIList.Add(LCItemUtil.Add_ComboBoxEx("task_wkstatusch", "任务状态:", 20, null, SubmitMethods));
            TryCachHelper.TryExecute((db) =>
            {
                var dtsex = db.Queryable<WCS_DICTIONARY>().Where(v => v.DIC_PARENT_CODE == "TaskStatus").ToList();
                DataTable dt = new DataTable();
                DataRow dr;
                dt.Columns.Add("DIC_SORT");
                dt.Columns.Add("DIC_NAME");
                for (int i = 0; i < dtsex.Count; i++)
                {
                    dr = dt.NewRow();
                    dr["DIC_SORT"] = dtsex[i].DIC_SORT;
                    dr["DIC_NAME"] = dtsex[i].DIC_NAME;
                    dt.Rows.Add(dr);
                }
                LCItemUtil.Refresh_LCItem(LCIList[LCIList.Count - 1], dt, "DIC_SORT", "DIC_NAME");
                LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "TASK_WKSTATUS 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.DIC_NAME task_comtypech,me.DIC_NAME task_wkstatusch from dbo.WCS_TASK_DIS t 
left join WCS_DICTIONARY m on t.task_comtype = m.DIC_SORT and m.DIC_PARENT_CODE = 'TaskType' 
left join WCS_DICTIONARY me on t.task_wkstatus = me.DIC_SORT and me.DIC_PARENT_CODE = 'TaskStatus' where 1=1 and TASK_WHID in('PVC原膜立库','PVC普通立库')";
            string _Orderby = "TASK_NO 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) 
        {

        }
    }
}