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 Frm_ALARAMRE : Form { public Frm_ALARAMRE() { InitializeComponent(); InitFrm(); } private void InitFrm() { List GCList = new List() { //SuperGridUtil.Get_GridColumn("ALARAMR_EQUNO", "设备编号", 80), //SuperGridUtil.Get_GridColumn("ALARAMR_EQUTYPE", "设备类型", 100), //SuperGridUtil.Get_GridColumn("ALARAMR_ALARAMNO", "故障代码", 100), //SuperGridUtil.Get_GridColumn("ALARAMR_ALARAMMSG", "故障信息", 400), //SuperGridUtil.Get_Datetime_GridColumn("ALARAMR_ALARAMSTARTTIME", "报警时间", 200), //SuperGridUtil.Get_Datetime_GridColumn("ALARAMR_ALARAMENDTIME", "结束时间", 200) SuperGridUtil.Get_GridColumn("DEVICECODE", "设备编号", 100), SuperGridUtil.Get_GridColumn("DEVICENAME", "设备名称", 120), SuperGridUtil.Get_GridColumn("ALARAMMSG", "故障信息", 300), SuperGridUtil.Get_Datetime_GridColumn("ALARAMSTARTTIME", "报警时间", 200), SuperGridUtil.Get_Datetime_GridColumn("ALARAMENDTIME", "结束时间", 200), SuperGridUtil.Get_GridColumn("FAULTTIME", "故障时间(秒)", 100) }; List LCIList = new List(); LCIList.Add(LCItemUtil.Add_TextboxX("DEVICECODE", "设备编号:", 20, SubmitMethods, null)); LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "DEVICECODE like '%{0}%'" }; LCIList.Add(LCItemUtil.Add_TextboxX("DEVICENAME", "设备名称:", 20, SubmitMethods, null)); LCIList[LCIList.Count - 1].Tag = new LCWhereInfo() { QWhereText = "DEVICENAME like '%{0}%'" }; LCIList.Add(LCItemUtil.Add_ButtonX("btn_QDB", "查询", 80, 30, SubmitMethods)); LCIList.Add(LCItemUtil.Add_ButtonX("btn_QClear", "重置", 80, 30, SubmitMethods)); uC_QueryPage1.Init_QueryPage(30, true, true, "", GCList, LCIList, QueryPageDataMethodsms, RefreshRoleMethodsms, null, null, null); CommonShow.ShowProcessing("正在处理中,请稍候...", this, (obj) => { uC_QueryPage1.RefreshData(1, 0); }, null); } private PageData QueryPageDataMethodsms(int PageIndex, int PageSize) { string _SQLText = string.Format(@"select * from ( select '设备报警' TYPE, m.ID,m.DEVICECODE,n.NAME DEVICENAME,m.SCAlarm alarm,m.FRAME ALARAMSTARTTIME, (select top 1 b.UPDATETIME from WCS_SRM537 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID) ALARAMENDTIME,'' as ALARAMMSG ,datediff(second,m.UPDATETIME,(select top 1 b.UPDATETIME from WCS_SRM537 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID)) as FAULTTIME from WCS_SRM537 m left join WCS_DEVICE n on m.DEVICECODE=n.CODE union all select '设备报警' TYPE, m.ID,m.DEVICECODE,n.NAME DEVICENAME,m.Fault alarm,m.FRAME ALARAMSTARTTIME,(select top 1 b.UPDATETIME from WCS_RGV523 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID) ALARAMENDTIME,'' as ALARAMMSG ,datediff(second,m.UPDATETIME,(select top 1 b.UPDATETIME from WCS_RGV523 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID)) as FAULTTIME from WCS_RGV523 m left join WCS_DEVICE n on m.DEVICECODE=n.CODE union all select '设备报警' TYPE, m.ID,m.DEVICECODE,n.NAME DEVICENAME,m.Alarm alarm,m.FRAME ALARAMSTARTTIME, (select top 1 b.UPDATETIME from WCS_STATION523 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID) ALARAMENDTIME,'' as ALARAMMSG ,datediff(second,m.UPDATETIME,(select top 1 b.UPDATETIME from WCS_STATION523 b left join WCS_DEVICE g on b.DEVICECODE=g.CODE where b.id>m.ID)) as FAULTTIME from WCS_STATION523 m left join WCS_DEVICE n on m.DEVICECODE=n.CODE) as deviceinfo WHERE 1=1 and alarm>0"); string _Orderby = "ALARAMSTARTTIME desc"; PageData pd = BaseWorkflow.QueryPageData(_SQLText, _Orderby, uC_QueryPage1.GetQueryWhere(), PageIndex, 1000); 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(); } } private void RefreshRoleMethodsms(bool ChkValue) { } } }