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.Linq;
using System.Windows.Forms;
using WCS.Entity.Protocol;
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)
        {
            var pack = eqpData.deviceDataPack;
            if (pack is null)
            {
                MessageBox.Show("该设备无数据。");
                return;
            }          

            TryCachHelper.TryExecute((db) =>
            {
                string equName = dr["CODE"].ToString();
                DataTable dt = null;
                if (pack.SCDatas.Datas.Any(p => p.Code == equName))
                {
                    var rgvdata = pack.SCDatas;//堆垛机数据
                    var plcItem = pack.SCDatas.Datas.Where(o => o.Code == equName).FirstOrDefault();
                    if (plcItem == null)
                    {
                        MessageBox.Show("该设备无数据。");
                        return;
                    }
                    dt = plcItem.GetAttributesDataTable();
                }
                else if (pack.RGVDatas.Datas.Any(p => p.Code == equName))
                {
                    var rgvdata = pack.RGVDatas;//RGV数据
                    var plcItem = pack.RGVDatas.Datas.Where(o => o.Code == equName).FirstOrDefault();
                    if (plcItem == null)
                    {
                        MessageBox.Show("该设备无数据。");
                        return;
                    }
                    dt = plcItem.GetAttributesDataTable();
                }
                else
                {
                    if (pack.StationDatas.Datas.Any(p => p.Code == equName))
                    {
                        var convdata = pack.StationDatas;//输送机数据
                        var plcItem = pack.StationDatas.Datas.Where(o => o.Code == equName).FirstOrDefault();
                        if (plcItem == null)
                        {
                            MessageBox.Show("该设备无数据。");
                            return;
                        }
                        dt = plcItem.GetAttributesDataTable();
                    }
                }
                if (dt == null)
                    return;
                string QeuMsg = null;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    for (int j = 1; j < dt.Columns.Count; j++)
                    {
                        if (j == 1)
                            QeuMsg += "[" + dt.Rows[i][0].ToString() + "]" + "\r\n" + dt.Rows[i][j] + ":";
                        else
                            QeuMsg += dt.Rows[i][j];
                    }
                    QeuMsg += "\r\n";
                }
                textBox1.Text = QeuMsg;
            });



            //try
            //{
            //}
            //catch (Exception ex)
            //{
            //    MessageUtil.ShowTips(ex.Message);
            //}
        }
    }
}