YG-OPP-WCS-Client/WCS_Client/Frm/MBtn_Monitor/FrmEquMsg.cs

using DevComponents.DotNetBar.Layout;
using DevComponents.DotNetBar.SuperGrid;
using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using WCS_Client.UC;
using WCS_Client.Utility;

namespace WCS_Client.Frm
{
    public partial class FrmEquMsg : Form
    {
        public FrmEquMsg()
        {
            InitializeComponent();
            InitFrm();
        }

        private void InitFrm()
        {
            List<GridColumn> GCList = new List<GridColumn>()
            {
                 SuperGridUtil.Get_GridColumn("CODE", "设备编号", 80),
                SuperGridUtil.Get_GridColumn("NAME", "设备名称", 200),
                SuperGridUtil.Get_GridColumn("PLCCODE", "plc编号", 100),
                SuperGridUtil.Get_GridColumn("PLCNAME", "plc名称", 140),
                SuperGridUtil.Get_GridColumn("IP", "plc 地址", 200),
            };
            List<LayoutControlItem> LCIList = new List<LayoutControlItem>();
            LCIList.Add(LCItemUtil.Add_TextboxX("CODE", "设备编号:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.CODE like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_TextboxX("NAME", "设备名称:", 20, SubmitMethods, null));
            LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "a.NAME like '%{0}%'" };

            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods));
            LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods));
            //LCIList.Add(LCItemUtil.Add_ButtonX("updateEquNotes", "修改备注", 100, 30, SubmitMethods));

            uC_QueryPage1.Init_QueryPage(30, true, true, "", GCList, LCIList, QueryPageDataMethodsms, RefreshRoleMethodsms, DoubleClikMethod, null, ClikMethod);
            CommonShow.ShowProcessing("正在处理中，请稍候...", this, (obj) =>
            {
                uC_QueryPage1.RefreshData(1, 0);
            }, null);
        }

        private PageData QueryPageDataMethodsms(int PageIndex, int PageSize)
        {

            string _SQLText = string.Format(@"select a.CODE,a.NAME,b.DBCODE,c.PLCCODE,d.NAME PLCNAME,d.IP from WCS_DEVICE a left join 
WCS_DEVICEPROTOCOL b on b.DEVICECODE=a.CODE
left join WCS_DATABLOCK c on c.CODE=b.DBCODE
left join WCS_PLC d on d.CODE=c.PLCCODE
where DBCODE not like '%521%' and DBCODE not like '%523%' and DBCODE not like '%537%' AND a.CODE NOT like 'BCR%'");
            string _Orderby = "a.CODE asc";

            PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, 3000);
            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();
            }
            else if (LCName == "updateEquNotes")
            {
                DataTable dt = this.uC_QueryPage1.SCGrid_GetChkRows();
                if (dt == null || dt.Rows.Count == 0)
                {
                    MessageUtil.ShowTips("请选择配置信息。");
                    return;
                }
                var frmupdate = new Frm.MBtn_Monitor.FrmUpdateEquMsg(dt.Rows[0]);
                frmupdate.ShowDialog();
                uC_QueryPage1.RefreshData(1, 0);
            }
        }

        private void RefreshRoleMethodsms(bool ChkValue)
        {
        }

        private void DoubleClikMethod(DataRow dr)
        {
            Current.RefreshData();
            string code = dr["CODE"].ToString();
            //var pack = eqpData.deviceDataPack;

            //if (code.Contains("SRM"))
            //{
            //}
            //else if (code.Contains("BCR"))
            //{
            //}
            //else if (code.Contains("RGV"))
            //{
            //}
            //else
            //{
            //}

            FrmEquMsg_dtl Frm = new FrmEquMsg_dtl(code);
            Frm.Show();
        }

        private void ClikMethod(DataRow dr)
        {
            try
            {
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips(ex.Message);
            }
        }
    }
}