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 FrmEquMsg : Form { public FrmEquMsg() { InitializeComponent(); InitFrm(); } private void InitFrm() { List GCList = new List() { SuperGridUtil.Get_GridColumn("Equ_No", "设备编号", 80), SuperGridUtil.Get_GridColumn("Equ_PlcName", "PLC名称", 100), SuperGridUtil.Get_GridColumn("Equ_Area", "设备区域", 100), SuperGridUtil.Get_GridColumn("Equ_Type", "设备类型", 100), SuperGridUtil.Get_GridColumn("Equ_BarCode", "条码", 100), SuperGridUtil.Get_GridColumn("Equ_SystemStatus", "系统状态", 100), SuperGridUtil.Get_GridColumn("Equ_WorkMode", "工作模式", 100), SuperGridUtil.Get_GridColumn("Equ_AlaramsMsg", "报警消息", 500), //SuperGridUtil.Get_GridColumn("PLC_NOTES", "说明", 200), SuperGridUtil.Get_GridColumn("Equ_Notes", "备注", 200) }; List LCIList = new List(); LCIList.Add(LCItemUtil.Add_TextboxX("STA_EQUIPMENTNO", "设备编号:", 20, SubmitMethods, null)); LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Equ_No like '%{0}%'" }; LCIList.Add(LCItemUtil.Add_TextboxX("STA_PLCNAME", "PLC名称:", 20, SubmitMethods, null)); LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "Equ_PlcName 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 [Equ_No],[Equ_Sequence],[Equ_Area],[Equ_PlcName],[Equ_Type],[Equ_BarCode],[Equ_AlaramsMsg],a.Equ_SystemStatus,a.Equ_WorkMode,a.Equ_Notes FROM [dbo].[WCS_EQUIPMENTINFO] a left join dbo.WCS_PLC b on a.Equ_PlcName=b.PLC_NAME where Equ_Area='A' "); string _Orderby = "Equ_No 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 plc_name = dr["Equ_PlcName"].ToString(); string equ_no = dr["Equ_No"].ToString(); //var plc = Current.PlcSet.FirstOrDefault(v => v.PLC_NAME == plc_name); //var equ = plc.WCS_EquipmentInfoSet.FirstOrDefault(v => v.Equ_No == equ_no); //string result = string.Empty; //DataTable dt = null; //if (equ.Equ_Type == EquipmentType.srm.ToString()) //{ // result = equ.EquSignal_Srm.ToJson(); // dt = equ.EquSignal_Srm.GetAttributesDataTable(); //} //else if (equ.Equ_Type == EquipmentType.rgv.ToString()) //{ // result = equ.EquSignal_Rgv.ToJson(); // dt = equ.EquSignal_Rgv.GetAttributesDataTable(); //} //else if (equ.Equ_Type == EquipmentType.conveyor.ToString()) //{ // result = equ.EquSignal_Conv.ToJson(); // dt = equ.EquSignal_Conv.GetAttributesDataTable(); //} FrmEquMsg_dtl Frm = new FrmEquMsg_dtl(equ_no); Frm.Show(); } private void ClikMethod(DataRow dr) { try { Current.RefreshData(); string plc_name = dr["Equ_PlcName"].ToString(); string equ_no = dr["Equ_No"].ToString(); var plc = Current.PlcSet.FirstOrDefault(v => v.PLC_NAME == plc_name); var equ = plc.WCS_EquipmentInfoSet.FirstOrDefault(v => v.Equ_No == equ_no); string result = string.Empty; if (equ.Equ_Type == EquipmentType.srm.ToString()) result = equ.EquSignal_Srm.ToJson(); else if (equ.Equ_Type == EquipmentType.rgv.ToString()) result = equ.EquSignal_Rgv.ToJson(); else if (equ.Equ_Type == EquipmentType.conveyor.ToString()) result = equ.EquSignal_Conv.ToJson(); string QeuMsg = null; //string wcs_task_no =dr["STA_DATA"].ToString(); string[] msg = result.Split(','); for (int i = 0; i < msg.Count(); i++) { QeuMsg += msg[i] + "\r\n"; } textBox1.Text = QeuMsg; } catch (Exception ex) { MessageUtil.ShowTips(ex.Message); } } } }