XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/.svn/text-base/FrmIronPotTrack.cs.svn-base

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 Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.lgIntegrationQuery
{
    public partial class FrmIronPotTrack : Core.Mes.Client.Common.frmStyleBase
    {
        public FrmIronPotTrack()
        {
            InitializeComponent();
        }

        private void FrmIronPotTrack_Load(object sender, EventArgs e)
        {
            checkBox1.Checked = false;
            numericUpDown1.Enabled = false;
            checkBox2.Checked = false;
            cmb_gowhere.Enabled = false;
            InitPotInfo();
            timer1_Tick(null, new EventArgs());
            this.timer1.Start();
        }

        DataSet ds = new DataSet();
        /// <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("GetIronPotInfo.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);
                 
                ValueList vl = new ValueList();

                foreach (DataRow dr in dt.Rows) 
                {
                    vl.ValueListItems.Add(dr["LADLEID"].ToString(), dr["LADLEID"].ToString());
                }
                cmb_ironid.ValueList = vl;

                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() });
                            GD17_1.Rows[intIndex].Hidden = true;
                            GD16_1.Rows[intIndex].Hidden = true;
                            GD15_1.Rows[intIndex].Hidden = true;
                            GD14_1.Rows[intIndex].Hidden = true;
                            GD13_1.Rows[intIndex].Hidden = true;
                            GD17_2.Rows[intIndex].Hidden = true;
                            GD16_2.Rows[intIndex].Hidden = true;
                            GD15_2.Rows[intIndex].Hidden = true;
                            GD14_2.Rows[intIndex].Hidden = true;
                            GD13_2.Rows[intIndex].Hidden = true;
                            FG1.Rows[intIndex].Hidden = true;
                            ZG1.Rows[intIndex].Hidden = true;
                            NGW1.Rows[intIndex].Hidden = true;
                            BGW1.Rows[intIndex].Hidden = true;
                            TLZ1.Rows[intIndex].Hidden = true;

                            HK1.Rows[intIndex].Hidden = true;
                            YSQ1.Rows[intIndex].Hidden = true;
                            DXQ1.Rows[intIndex].Hidden = true;
                            intIndex++;
                        }
                    }
                }
            }
            catch{ }
        }

        public static void proc_Statics(ref UltraGrid ultraGrid, ArrayList alistColumns, bool clearExists, string strFormat)
        {
            try
            {
                if (alistColumns == null)
                {
                    return;
                }

                UltraGridBand band = ultraGrid.DisplayLayout.Bands[0];
                if (clearExists)
                    band.Summaries.Clear();

                SummarySettings summary = null;

                UltraGridColumn cl = null;
                foreach (UltraGridColumn column in ultraGrid.DisplayLayout.Bands[0].Columns)
                {
                    if (column.ToString() == "第二炼钢厂转炉生产调度表")
                    {
                        if (column.RowLayoutColumnInfo.OriginX == 1)
                        {
                            cl = column;
                            break;
                        }
                    }
                    else
                    {
                        if (column.RowLayoutColumnInfo.OriginX == 0)
                        {
                            cl = column;
                            break;
                        }
                    }
                }

                summary = band.Summaries.Add(SummaryType.Count, cl);
                summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                summary.DisplayFormat = "合计：";

                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                summary.Appearance.FontData.Bold = DefaultableBoolean.True;

                if (string.IsNullOrEmpty(strFormat.Trim()))
                {
                    strFormat = " {0:############0.00}";
                }
                for (int i = 0; i < alistColumns.Count; i++)
                {
                    try
                    {
                        summary = band.Summaries.Add(SummaryType.Sum, band.Columns[alistColumns[i].ToString()]);
                        summary.SummaryDisplayArea = SummaryDisplayAreas.BottomFixed;
                        summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
                        summary.DisplayFormat = strFormat;

                        summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
                        summary.Appearance.TextVAlign = Infragistics.Win.VAlign.Middle;
                        summary.Appearance.FontData.Bold = DefaultableBoolean.True;
                        summary.Appearance.ForeColor = Color.DarkBlue;
                        summary.Appearance.BackColor = Color.White;
                    }
                    catch { }
                }

                band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
            }
            catch { }
        }

        /// <summary>
        /// 显示铁水信息
        /// </summary>
        private void GetPotStatusData()
        {
            try
            {
                try
                {
                    //转炉状态显示
                    ArrayList arryBof = new ArrayList();
                    ArrayList sqlListBof = new ArrayList();
                    string strWhereBof = " and 1=1 ";

                    arryBof.Add("GetBofTrackInfo.select");
                    sqlListBof.Add(strWhereBof);

                    //调用服务端方法
                    CoreClientParam CCP_LgEtsBof = new CoreClientParam();
                    DataTable dtBof = new DataTable();
                    CCP_LgEtsBof.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                    CCP_LgEtsBof.MethodName = "doQuery";
                    CCP_LgEtsBof.ServerParams = new object[] { arryBof, sqlListBof };
                    CCP_LgEtsBof.SourceDataTable = dtBof;
                    this.ExecuteQueryToDataTable(CCP_LgEtsBof, CoreInvokeType.Internal);

                    if (dtBof != null && dtBof.Rows.Count > 0)
                    {
                        for (int iRow = 0; iRow < dtBof.Rows.Count; iRow++)
                        {
                            DataRow dr = dtBof.Rows[iRow];
                            if (dr["OBJECTPOS"].ToString() == "BOF01_DEVICE") 
                            {
                                if (dr["CHANGEENDTIME"].ToString() == "Y")
                                    pbCvtDev1.Image = imageListBof.Images[2];
                                else 
                                {
                                    pbCvtDev1.Image = imageListBof.Images[1];
                                }
                            }
                            if (dr["OBJECTPOS"].ToString() == "BOF01_BACK")
                            {
                                pbCvtDev1.Image = imageListBof.Images[3];
                            }

                            if (dr["OBJECTPOS"].ToString() == "BOF02_DEVICE")
                            {
                                if (dr["CHANGEENDTIME"].ToString() == "Y")
                                    pbCvtDev2.Image = imageListBof.Images[2];
                                else
                                {
                                    pbCvtDev2.Image = imageListBof.Images[1];
                                }
                            }
                            if (dr["OBJECTPOS"].ToString() == "BOF02_BACK")
                            {
                                pbCvtDev2.Image = imageListBof.Images[3];
                            }
                        }
                    }
                    else 
                    {
                        pbCvtDev1.Image = imageListBof.Images[0];
                        pbCvtDev2.Image = imageListBof.Images[0];
                    }
                }catch{}


                DataTable dtIronData = null;
                string strWhere = " where 1=1 ";
                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();

                arry.Add("GetIronPotStatusInfo.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);

                if (dt != null && dt.Rows.Count > 0)
                {
                    this.dataTable1.Rows.Clear();

                    DataRow dr;
                    for (int iRow = 0; iRow < dt.Rows.Count; iRow++)
                    {
                        dr = this.dataTable1.NewRow();
                        for (int jCol = 0; jCol < dt.Columns.Count; jCol++)
                        {
                            try
                            {
                                if (this.dataTable1.Columns.Contains(dt.Columns[jCol].ColumnName))
                                    dr[dt.Columns[jCol].ColumnName] = Convert.ToString(dt.Rows[iRow][jCol]);
                            }
                            catch { }
                        }
                        this.dataTable1.Rows.Add(dr);
                    }
                }

                try
                {
                    ArrayList alistColumns = new ArrayList();
                    ArrayList alistFormat = new ArrayList();


                    alistColumns.Add("CN");

                    alistFormat.Add(" {0:############0.0}");

                    proc_Statics(ref ultraGrid1, alistColumns, true, " {0:############0.0}");


                }
                catch { }
                //绑定扩展栏铁包数据
                /*DataRow[] drList = dt.Select("FGWEIGHT IS NOT NULL");

                DataTable dt1 = new DataTable();
                dt1.Columns.Add(new DataColumn("LADLEID", typeof(String)));
                dt1.Columns.Add(new DataColumn("LOCATION", typeof(String)));
                dt1.Columns.Add(new DataColumn("FGWEIGHT", typeof(String)));

                foreach (DataRow dr in drList)
                {
                    dt1.ImportRow(dr);
                }
                this.dataTable1.Clear();
                if (dt1 != null && dt1.Rows.Count > 0)
                {
                    this.dataTable1.Rows.Clear();

                    if (dt1.Rows.Count == 0) return;

                    DataRow dr;
                    for (int iRow = 0; iRow < dt1.Rows.Count; iRow++)
                    {
                        dr = this.dataTable1.NewRow();
                        for (int jCol = 0; jCol < dt1.Columns.Count; jCol++)
                        {
                            try
                            {
                                if (this.dataTable1.Columns.Contains(dt1.Columns[jCol].ColumnName))
                                    dr[dt1.Columns[jCol].ColumnName] = Convert.ToString(dt1.Rows[iRow][jCol]);
                            }
                            catch { }
                        }
                        this.dataTable1.Rows.Add(dr);
                    }
                }*/
                //铁水信息
                dtIronData = dt;
                if (dtIronData != null)
                {
                    if (dtIronData.Rows.Count > 0)
                    {
                        foreach (DataRow drIron in dtIronData.Rows)
                        {
                            //10#高炉13辊道
                            for (int i = 0; i < GD13_1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD13_1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉13辊道")
                                    {
                                        GD13_1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0]; 
                                        GD13_1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD13_1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉14辊道
                            for (int i = 0; i < GD14_1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD14_1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉14辊道")
                                    {
                                        GD14_1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD14_1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD14_1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉15辊道
                            for (int i = 0; i < GD15_1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD15_1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉15辊道")
                                    {
                                        GD15_1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD15_1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD15_1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉16辊道
                            for (int i = 0; i < GD16_1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD16_1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉16辊道")
                                    {
                                        GD16_1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD16_1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD16_1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉17辊道
                            for (int i = 0; i < GD17_1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD17_1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉17辊道")
                                    {
                                        GD17_1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD17_1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD17_1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉13辊道
                            for (int i = 0; i < GD13_2.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD13_2.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉13辊道")
                                    {
                                        GD13_2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD13_2.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD13_2.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉14辊道
                            for (int i = 0; i < GD14_2.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD14_2.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉14辊道")
                                    {
                                        GD14_2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD14_2.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD14_2.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉15辊道
                            for (int i = 0; i < GD15_2.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD15_2.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉15辊道")
                                    {
                                        GD15_2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD15_2.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD15_2.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉16辊道
                            for (int i = 0; i < GD16_2.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD16_2.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉16辊道")
                                    {
                                        GD16_2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD16_2.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD16_2.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉17辊道
                            for (int i = 0; i < GD17_2.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD17_2.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉17辊道")
                                    {
                                        GD17_2.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        GD17_2.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD17_2.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //废钢区域
                            for (int i = 0; i < FG1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == FG1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "废钢区域")
                                    {
                                        FG1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        FG1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        FG1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //重罐区域(空)
                            for (int i = 0; i < ZG1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == ZG1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "重罐区域(空)")
                                    {
                                        ZG1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        ZG1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        ZG1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //1#工位
                            for (int i = 0; i < NGW1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == NGW1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "1#工位")
                                    {
                                        NGW1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        NGW1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        NGW1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //2#工位
                            for (int i = 0; i < BGW1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == BGW1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "2#工位")
                                    {
                                        BGW1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        BGW1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        BGW1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //重罐区域(重)
                            for (int i = 0; i < TLZ1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == TLZ1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "重罐区域(重)")
                                    {
                                        TLZ1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[0];
                                        TLZ1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        TLZ1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            

                            //10#高炉13辊道备用
                            for (int i = 0; i < GD13_1_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD13_1_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉13辊道备用")
                                    {
                                        GD13_1_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD13_1_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD13_1_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉14辊道备用
                            for (int i = 0; i < GD14_1_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD14_1_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉14辊道备用")
                                    {
                                        GD14_1_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD14_1_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD14_1_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉15辊道备用
                            for (int i = 0; i < GD15_1_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD15_1_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉15辊道备用")
                                    {
                                        GD15_1_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD15_1_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD15_1_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉16辊道备用
                            for (int i = 0; i < GD16_1_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD16_1_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉16辊道备用")
                                    {
                                        GD16_1_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD16_1_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD16_1_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //10#高炉17辊道备用
                            for (int i = 0; i < GD17_1_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD17_1_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "10#高炉17辊道备用")
                                    {
                                        GD17_1_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD17_1_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD17_1_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉13辊道备用
                            for (int i = 0; i < GD13_2_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD13_2_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉13辊道备用")
                                    {
                                        GD13_2_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD13_2_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD13_2_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉14辊道备用
                            for (int i = 0; i < GD14_2_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD14_2_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉14辊道备用")
                                    {
                                        GD14_2_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD14_2_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD14_2_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉15辊道备用
                            for (int i = 0; i < GD15_2_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD15_2_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉15辊道备用")
                                    {
                                        GD15_2_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD15_2_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD15_2_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉16辊道备用
                            for (int i = 0; i < GD16_2_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD16_2_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉16辊道备用")
                                    {
                                        GD16_2_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD16_2_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD16_2_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //9#高炉17辊道备用
                            for (int i = 0; i < GD17_2_BACK.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == GD17_2_BACK.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "9#高炉17辊道备用")
                                    {
                                        GD17_2_BACK.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        GD17_2_BACK.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        GD17_2_BACK.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }


                            //烘烤区域
                            for (int i = 0; i < HK1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == HK1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "烘烤区域")
                                    {
                                        HK1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        HK1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        HK1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //养护区
                            for (int i = 0; i < YSQ1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == YSQ1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "养护区")
                                    {
                                        YSQ1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        YSQ1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        YSQ1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //维修区
                            for (int i = 0; i < WXQ1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == WXQ1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "维修区")
                                    {
                                        WXQ1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        WXQ1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        WXQ1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                            //待修区
                            for (int i = 0; i < DXQ1.Rows.Count; i++)
                            {
                                if (drIron["LADLEID"].ToString() == DXQ1.Rows[i].Cells[0].Value.ToString())
                                {
                                    if (drIron["LOCATION"].ToString() == "待修区")
                                    {
                                        DXQ1.Rows[i].Cells[0].Appearance.ImageBackground = imageList1.Images[1];
                                        DXQ1.Rows[i].Hidden = false;
                                    }
                                    else
                                    {
                                        DXQ1.Rows[i].Hidden = true;
                                    }
                                    break;
                                }
                            }
                        }
                    }
                }
            }
            catch 
            {
                
            }

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string strErr = "";
            try
            {
                if (string.IsNullOrEmpty(cmb_ironid.Text.Trim())) 
                {
                    MessageBox.Show("请选取铁包号后再进行更新");
                    return;
                }
                string ironid = cmb_ironid.Text.Trim();
                string gowhere = cmb_gowhere.Text.Trim() == "" ? "台下" : cmb_gowhere.Text.Trim();
                double fgweight = 0;
                string sql = " update DEV_IB_BASE_INFO set ";
                if (!checkBox1.Checked && !checkBox2.Checked) 
                {
                    MessageBox.Show("请选中去向或者废钢重量后再进行更新");
                    return;
                }
                if (checkBox2.Checked)
                {
                    if (checkBox1.Checked && string.IsNullOrEmpty(cmb_gowhere.Text.Trim()))
                    {
                        MessageBox.Show("移动到台下时不可选中废钢进行更新，请取消废钢选项");
                        return;
                    }
                    if (MessageBox.Show("确认将" + ironid + "#铁包移动到" + gowhere + "?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        gowhere = cmb_gowhere.Text.Trim();
                    }
                    
                }
                if (checkBox1.Checked)
                {
                    if (MessageBox.Show("确认给" + ironid + "#铁包添加废钢？", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        fgweight = double.Parse(numericUpDown1.Value.ToString());
                    }
                }



                if (checkBox2.Checked && !checkBox1.Checked) 
                {
                    if (string.IsNullOrEmpty(cmb_gowhere.Text.Trim()))
                    {
                        sql += " location = '" + gowhere + "',fgweight = '0'";
                    }
                    else 
                    {
                        sql += " location = '" + gowhere + "'";
                    }
                }
                    
                if (checkBox1.Checked && !checkBox2.Checked)
                    sql += " fgweight = '" + fgweight + "'";
                if (checkBox2.Checked && checkBox1.Checked)
                    sql += " location = '" + gowhere + "',fgweight = '" + fgweight + "'";
                sql += " where ladleid = '" + ironid + "'";
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                // DataSet ds = 
                cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                        "ExcuteNoParameter", sql, out strErr);
                if (string.IsNullOrEmpty(strErr)) 
                {
                    MessageBox.Show("更新成功");
                    /*位置变换日志记录*/
                    string loc = "";
                    if (gowhere.Contains("高炉") && !gowhere.Contains("备用"))
                        loc = "1";
                    else if(gowhere.Contains("高炉") && gowhere.Contains("备用"))
                        loc = "1.5";
                    else if(gowhere.Contains("烘烤"))
                        loc = "2";
                    else if(gowhere.Contains("重罐区域(重)"))
                        loc = "3";
                    else if(gowhere.Contains("重罐区域(空)"))
                        loc = "3.5";
                    else if (gowhere.Contains("工位"))
                        loc = "4";
                    else if (gowhere.Contains("废钢"))
                        loc = "5";
                    else if (gowhere.Contains("养护"))
                        loc = "6";
                    else if (gowhere.Contains("维修"))
                        loc = "7";
                    else if (gowhere.Contains("待修"))
                        loc = "8";

                    if (!string.IsNullOrEmpty(loc))
                    {
                        string insertSql = "INSERT INTO DEV_IB_RUN_INFO(LADLEID, LOCATION, LOCATIONCODE) "
                            + " VALUES ('" + ironid + "','" + gowhere + "','" + loc + "')";

                        cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                            "ExcuteNoParameter", insertSql, out strErr);
                    }
                    GetPotStatusData();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("更新失败:" + strErr + ";" + ex.Message + "");
                return;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            GetPotStatusData();
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBox1.Checked)
                numericUpDown1.Enabled = true;
            else
                numericUpDown1.Enabled = false;
        }

        private void GD17_1_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 GD16_1_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 GD15_1_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 GD14_1_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 GD13_1_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 GD17_2_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 GD16_2_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 GD15_2_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 GD14_2_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 GD13_2_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 FG1_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 ZG1_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 NGW1_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 BGW1_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 TLZ1_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 checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            if (checkBox2.Checked)
                cmb_gowhere.Enabled = true;
            else
                cmb_gowhere.Enabled = false;
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            GetPotStatusData();
        }

        private void GD17_1_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD16_1_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD15_1_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD14_1_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD13_1_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD17_2_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD16_2_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD15_2_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD14_2_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void GD13_2_BACK_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void ZL4_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void ZL5_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void HK1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void YSQ1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void WXQ1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }

        private void DXQ1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Override.RowSelectors = DefaultableBoolean.True;
            e.Layout.Override.RowSelectorNumberStyle = RowSelectorNumberStyle.VisibleIndex;
            e.Layout.Override.RowSelectorWidth = 1;//没找到取消行号的方法，将行号的宽度设置为最小
        }


    }
}