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 GCList = new List() { 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 LCIList = new List(); 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); } } } }