YG-PVC-WCS/WCS_Client/Frm/MBtn_AgvTask/MBtn_SCANN.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_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.Frm
{
    public partial class MBtn_SCANN : Form
    {
        public MBtn_SCANN()
        {
            InitializeComponent();
            InitFrm();
        }
        private void InitFrm()
        {
            List<GridColumn> GCList = new List<GridColumn>()
            {
                SuperGridUtil.Get_GridColumn("SCANN_STATIONNO", "扫码输送线", 100),
                SuperGridUtil.Get_GridColumn("SCANN_BARCODE", "当前扫码信息", 200),
                SuperGridUtil.Get_GridColumn("SCANN_SEQUENCE", "顺序", 80),
                SuperGridUtil.Get_GridColumn("SCANN_PLCNAME", "所属PLC", 80),
                SuperGridUtil.Get_GridColumn("SCANN_STARTADDRESS", "扫码起点索引", 120),
                SuperGridUtil.Get_GridColumn("SCANN_LENGTH", "扫码长度", 100),
                //SuperGridUtil.Get_GridColumn("SCANN_VALIDTIMEINTERVAL", "扫码有效时长", 140),
                SuperGridUtil.Get_GridColumn("SCANN_UPDATETIME", "扫码时间", 150),
                SuperGridUtil.Get_CheckBoxX_GridColumn("SCANN_ISUSED", "是否启用", 100)
            };
            List<LayoutControlItem> LCIList = new List<LayoutControlItem>();

            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "刷新", 80, 30, SubmitMethods));
            if (CurrentHelper.User.Use_RoleId == 1)
            {
                LCIList.Add(LCItemUtil.Add_ButtonX("btn_Enable", "启用", 80, 30, SubmitMethods));
                LCIList.Add(LCItemUtil.Add_ButtonX("btn_Stop", "停用", 80, 30, SubmitMethods));
            }
            uC_QueryPage1.Init_QueryPage(30, 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 TOP 1000 [SCANN_ID]
      ,[SCANN_STATIONNO]
      ,[SCANN_BARCODE]
      ,[SCANN_SEQUENCE]
      ,[SCANN_PLCNAME]
      ,[SCANN_STARTADDRESS]
      ,[SCANN_LENGTH]
      ,[SCANN_DB_ID]
      ,[SCANN_VALIDTIMEINTERVAL]
      ,[SCANN_UPDATETIME]
      ,SCANN_ISUSED
  FROM [YONGGUAN_WCS].[dbo].[WCS_SCANN] ";
            string _Orderby = "SCANN_ID asc";

            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_Enable")
            {
                DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
                if (dt == null || dt.Rows.Count == 0)
                {
                    MessageUtil.ShowTips("请选择配置信息。");
                    return;
                }
                string convNo = dt.Rows[0]["SCANN_STATIONNO"].ToString();
                var result = MessageUtil.ShowYesNoAndWarning(string.Format("扫码入口[{0}]确定要启用吗？", convNo));
                if (result == DialogResult.Yes)
                {
                    string msg = BaseWorkflow.ScanConvInfoSet(convNo, true);
                    MessageUtil.ShowTips(msg);
                    uC_QueryPage1.RefreshData(1, 0);
                }
            }
            else if (LCName == "btn_Stop")
            {
                DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
                if (dt == null || dt.Rows.Count == 0)
                {
                    MessageUtil.ShowTips("请选择配置信息。");
                    return;
                }
                string convNo = dt.Rows[0]["SCANN_STATIONNO"].ToString();
                var result = MessageUtil.ShowYesNoAndWarning(string.Format("扫码入口[{0}]确定要禁用吗？", convNo));
                if (result == DialogResult.Yes)
                {
                    string msg = BaseWorkflow.ScanConvInfoSet(convNo, false);
                    MessageUtil.ShowTips(msg);
                    uC_QueryPage1.RefreshData(1, 0);
                }
            }
        }
        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)
        {

        }
    }
}