using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Collections; using CoreFS.CA06; using System.Threading; using System.Diagnostics; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; namespace Core.LgMes.Client.lgIntegrationQuery { public partial class FrmPotStatusTrack : Core.Mes.Client.Common.frmStyleBase { DataSet ds = new DataSet(); public FrmPotStatusTrack() { InitializeComponent(); } private void FrmPotStatusTrack_Load(object sender, EventArgs e) { InitPotInfo(); // 启动线程 StartUpThread(); //GetPotStatusData(); } /// /// 初始化铁包 /// private void InitPotInfo() { string strErr = ""; int intIndex = 0; string strWhere = " where 1=1 "; try { ArrayList arry = new ArrayList(); ArrayList sqlList = new ArrayList(); arry.Add("frmPotInfo.select"); sqlList.Add(strWhere); //调用服务端方法 CoreClientParam CCP_LgEts = new CoreClientParam(); DataTable dt = new DataTable(); CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; CCP_LgEts.MethodName = "doQuery"; CCP_LgEts.ServerParams = new object[] { arry, sqlList }; CCP_LgEts.SourceDataTable = dt; this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); ds.Tables.Add(dt); if (strErr == "" && ds != null) { ultraDataSource1.Rows.Clear(); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ultraDataSource1.Rows.Add(new object[] { dr["LADLEID"].ToString() }); ultraGrid1.Rows[intIndex].Hidden = true; ultraGrid2.Rows[intIndex].Hidden = true; ultraGrid3.Rows[intIndex].Hidden = true; ultraGrid4.Rows[intIndex].Hidden = true; ultraGrid5.Rows[intIndex].Hidden = true; ultraGrid6.Rows[intIndex].Hidden = true; ultraGrid7.Rows[intIndex].Hidden = true; ultraGrid8.Rows[intIndex].Hidden = true; ultraGrid9.Rows[intIndex].Hidden = true; ultraGrid10.Rows[intIndex].Hidden = true; ultraGrid11.Rows[intIndex].Hidden = true; ultraGrid12.Rows[intIndex].Hidden = true; ultraGrid13.Rows[intIndex].Hidden = true; intIndex++; } } } } catch (Exception ex) { } } /// /// 启动线程主程序 /// private void StartUpThread() { ThreadStart ts = new ThreadStart(RefreshDataThread); _refreshDataThread = new Thread(ts); _refreshDataThread.Name = "刷新数据线程"; _refreshDataThread.Start(); } public bool On_Off_Thread = true; //线程是否启动 public Thread _refreshDataThread; //定义线程 public bool _bIfRefreshData = true; // 控制刷新数据线程循环的标志 /// /// 线程 /// private void RefreshDataThread() { while (_bIfRefreshData) { if (!this.On_Off_Thread)//this.On_Off_Thread { System.Threading.Thread.Sleep(5000); continue; } try { GetPotStatusData(); Thread.Sleep(5000); } catch (Exception ex) { Trace.WriteLine(ex.Message); } } } /// /// 显示铁水信息 /// private void GetPotStatusData() { try { DataTable dtIronData = null; int rowsSY = 0; int rowsBW = 0; int rowsBY = 0; int rowsWX = 0; string strWhere = " where 1=1 "; ArrayList arry = new ArrayList(); ArrayList sqlList = new ArrayList(); arry.Add("GetPotStatusInfo.Select"); sqlList.Add(strWhere); //调用服务端方法 CoreClientParam CCP_LgEts = new CoreClientParam(); DataTable dt = new DataTable(); CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery"; CCP_LgEts.MethodName = "doQuery"; CCP_LgEts.ServerParams = new object[] { arry, sqlList }; CCP_LgEts.SourceDataTable = dt; this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal); //铁水信息 dtIronData = dt; if (dtIronData != null) { if (dtIronData.Rows.Count > 0) { foreach (DataRow drIron in dtIronData.Rows) { //钢包使用 for (int i = 0; i < ultraGrid1.Rows.Count; i++) { if (drIron["LADLEID"].ToString() == ultraGrid1.Rows[i].Cells[0].Value.ToString()) { if (drIron["NOWPOSITION"].ToString() == "在用") { rowsSY++; if (rowsSY > 10) { ultraGrid7.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0]; ultraGrid7.Rows[i].Hidden = false; ultraGrid1.Rows[i].Hidden = true; } else { ultraGrid1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0]; ultraGrid1.Rows[i].Hidden = false; ultraGrid7.Rows[i].Hidden = true; } } else { ultraGrid1.Rows[i].Hidden = true; ultraGrid7.Rows[i].Hidden = true; } break; } } //钢包保温 for (int i = 0; i < ultraGrid2.Rows.Count; i++) { if (drIron["LADLEID"].ToString() == ultraGrid2.Rows[i].Cells[0].Value.ToString()) { if (drIron["NOWPOSITION"].ToString() == "待用" || drIron["NOWPOSITION"].ToString() == "保温") { rowsBW++; if (rowsBW > 10) { ultraGrid6.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid6.Rows[i].Hidden = false; ultraGrid2.Rows[i].Hidden = true; } else { ultraGrid2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid2.Rows[i].Hidden = false; ultraGrid6.Rows[i].Hidden = true; } } else { ultraGrid2.Rows[i].Hidden = true; ultraGrid6.Rows[i].Hidden = true; } break; } } //钢包烘烤 for (int i = 0; i < ultraGrid3.Rows.Count; i++) { if (drIron["LADLEID"].ToString() == ultraGrid3.Rows[i].Cells[0].Value.ToString()) { if (drIron["NOWPOSITION"].ToString() == "烘烤") { if (drIron["OVENID"].ToString() =="1") { ultraGrid3.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid3.Rows[i].Hidden = false; } else if (drIron["OVENID"].ToString() == "2") { ultraGrid10.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid10.Rows[i].Hidden = false; } else if (drIron["OVENID"].ToString() == "3") { ultraGrid11.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid11.Rows[i].Hidden = false; } else if (drIron["OVENID"].ToString() == "4") { ultraGrid12.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid12.Rows[i].Hidden = false; } else { ultraGrid13.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid13.Rows[i].Hidden = false; } //ultraGrid3.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; //ultraGrid3.Rows[i].Hidden = false; } else { ultraGrid3.Rows[i].Hidden = true; ultraGrid10.Rows[i].Hidden = true; ultraGrid11.Rows[i].Hidden = true; ultraGrid12.Rows[i].Hidden = true; ultraGrid13.Rows[i].Hidden = true; } break; } } //钢包备用 for (int i = 0; i < ultraGrid4.Rows.Count; i++) { if (drIron["LADLEID"].ToString() == ultraGrid4.Rows[i].Cells[0].Value.ToString()) { if (drIron["NOWPOSITION"].ToString() == "备用") { rowsBY++; if (rowsBY > 10) { ultraGrid8.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid8.Rows[i].Hidden = false; ultraGrid4.Rows[i].Hidden = true; } else { ultraGrid4.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid4.Rows[i].Hidden = false; ultraGrid8.Rows[i].Hidden = true; } } else { ultraGrid4.Rows[i].Hidden = true; ultraGrid8.Rows[i].Hidden = true; } break; } } //钢包维修 for (int i = 0; i < ultraGrid5.Rows.Count; i++) { if (drIron["LADLEID"].ToString() == ultraGrid5.Rows[i].Cells[0].Value.ToString()) { if (drIron["NOWPOSITION"].ToString() == "维修") { rowsWX++; if (rowsWX > 10) { ultraGrid9.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid9.Rows[i].Hidden = false; ultraGrid5.Rows[i].Hidden = true; } else { ultraGrid5.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1]; ultraGrid5.Rows[i].Hidden = false; ultraGrid9.Rows[i].Hidden = true; } } else { ultraGrid5.Rows[i].Hidden = true; ultraGrid9.Rows[i].Hidden = true; } break; } } } } } } catch { } } //取消行号 private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法,将行号的宽度设置为最小 } private void ultraGrid2_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法,将行号的宽度设置为最小 } private void ultraGrid3_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid4_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid5_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid6_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid7_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid8_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid9_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid10_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid11_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid12_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } private void ultraGrid13_InitializeLayout(object sender, InitializeLayoutEventArgs e) { e.Layout.Override.RowSelectors = DefaultableBoolean.True; e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex; e.Layout.Override.RowSelectorWidth = 1; } } }