XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/FrmPotStatusTrack.cs

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();
        }

        /// <summary>
        /// 初始化铁包
        /// </summary>
        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)
            {
            }
        }

       
        /// <summary>
        /// 启动线程主程序
        /// </summary>
        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;     // 控制刷新数据线程循环的标志  
        /// <summary>
        /// 线程
        /// </summary>
        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);
                }
            }
        }

        /// <summary>
        /// 显示铁水信息
        /// </summary>
        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;
        }

    }
}