XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgJobMgt/02脱硫站作业管理/.svn/text-base/frmBfIron.cs.svn-base

using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using System.Threading;
using System.Collections;
using CoreFS.CA06;
using Core.Mes.Client.Common;
using Core.LgMes.Client.Comm;
using System.Diagnostics;
using System.IO;


namespace Core.LgMes.Client.LgJobMgt
{
    public partial class frmBfIron : frmStyleBase
    {

        private Thread _getDataThread;              // 取数据线程
        private bool _bIfGetData = true;             // 控制取数据线程循环的标志
        private string[] ArrayIronRow = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存铁运进铁数据 
        private string[] ArrayIronRow2 = new string[20] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存混铁炉进铁数据 
        private string[] ArrayIronRow3 = new string[25] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存混铁炉出铁数据 
        private string[] ArrayIronRow4 = new string[25] { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; //保存发送到转炉铁水数据 



        private string _strSendSucceededForBof1 = "";
        private string _strSendSucceededForBof2 = "";
        private string _strSendSucceededForBof3 = "";
        private string _strSendSucceededForHmp1 = "";
        private string _strSendSucceededForHmp2 = "";
        private string _strHmp1No = "";
        private string _strHmp2No = "";
        private bool blModify = false;

        #region formload
        public frmBfIron()
        {
            InitializeComponent();
            CheckForIllegalCrossThreadCalls = false;

        }

        private void frmBfIron_Load(object sender, EventArgs e)
        {
            try
            {
                this.dtpBegin.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
                this.dtpEnd.Text = System.DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";

                dtpBegin.Enabled = false;
                dtpEnd.Enabled = false;
                cboShift.Enabled = false;
                ultratxtBfNo.Enabled = false;

                CStaticMethod.SetUltraGridStyle(ultragridInIronEdit, 1);  //设置样式
                ultragridInIron.DisplayLayout.CaptionVisible = Infragistics.Win.DefaultableBoolean.True;
                User = this.UserInfo.GetUserName();//操作人;
                SetUserControlDelegate();
                ultraDataSource6.Rows.Add(new object[] { "", "", "", null, "", "", "", "", "", "", "", "", "" });

                timer1_Tick(null, new EventArgs());
                this.timer1.Start();
                GetInIronData();
                StartUpThread();
                setbutton("1");
                setucInIron("1");
                SetColumnModeShift(ultragridInIronEdit);
                SetColumnModeGroup(ultragridInIronEdit);
                //SetColumnModequxiang();

                SetColumnModeShift(ultragridInIron);
                SetColumnModeGroup(ultragridInIron);


                //ultragridBfIron.Rows[0].Cells["FOLDPOTWGT"].Hidden = true;
                //GetElementData();
            }
            catch
            { }
        }
        #endregion

        #region Thread Handle

        /// <summary>
        /// 启动线程主程序
        /// </summary>
        private void StartUpThread()
        {
            ThreadStart ts = new ThreadStart(GetDataThread);
            _getDataThread = new Thread(ts);
            _getDataThread.Name = "GetDataThread ";

            _getDataThread.Start();
        }
        private string User = "";
        /// <summary>
        /// 取数据线程程序
        /// </summary>
        private void GetDataThread()
        {
            while (_bIfGetData)
            {
                if (!this.On_Off_Thread)//this.On_Off_Thread
                {
                    System.Threading.Thread.Sleep(5000);
                    continue;
                }
                try
                {
                    //GetInIronData();
                    // GetRealData();
                    //GetCVTHeatno();
                    Thread.Sleep(10000);
                }
                catch { }
            }
        }
        #endregion

        #region dataevent



        /// <summary>
        /// 铁运进铁数据  ultraGrid2
        /// </summary>
        private void GetInIronData()
        {
            string strErr = "";
            string strBeginTime = "";
            string strEndTime = "";
            string strShiftCode = "";
            string strBfNo = "";

            try
            {
                //进铁时间
                if (chkInIronDate.Checked)
                {
                    strBeginTime = Convert.ToDateTime(dtpBegin.Value).ToString("yyyy-MM-dd HH:mm:ss");
                    strEndTime = Convert.ToDateTime(dtpEnd.Value).ToString("yyyy-MM-dd HH:mm:ss");
                }
                else
                {
                    strBeginTime = (DateTime.Now.AddHours(-6)).ToString("yyyy-MM-dd HH:mm:ss");
                    strEndTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
                }

                //班次
                if (chkShift.Checked)
                    strShiftCode = cboShift.Value.ToString();
                else
                    strShiftCode = "0";


                if (chkBfNo.Checked && !string.IsNullOrEmpty(ultratxtBfNo.Text.Trim()))
                    strBfNo = ultratxtBfNo.Text.Trim();
                else
                    strBfNo = "";

                ArrayList arry = new ArrayList();
                arry.Add("GetInIronData.Select");//此ID为XML文件ID
                arry.Add(strBeginTime);
                arry.Add(strEndTime);
                arry.Add(strShiftCode);
                arry.Add(strShiftCode);
                arry.Add(strBfNo);
                arry.Add(strBfNo);
                arry.Add(strBfNo);

                CommonClientToServer ccTos = new CommonClientToServer();
                ccTos.ob = this.ob;
                //查询高炉铁水信息
                DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob",
                                                         "GetInIronData", arry, out strErr);

                if (strErr == "" && ds != null)
                {
                    ultraDataSource2.Rows.Clear();
                    if (ds.Tables.Count > 0)
                    {
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            ultraDataSource2.Rows.Add(new object[] {
                                                               dr["MISID"].ToString(),
                                                               dr["STOVEID"].ToString(),
                                                               dr["STOVETIME"].ToString(),       
                                                               dr["TAPHOLENO"].ToString(),
                                                               dr["TFPOTID"].ToString(),
                                                               dr["TFPOTTAREWGT"].ToString(),
                                                               dr["TFPOTGROSSWGT"].ToString(),
                                                               dr["TFPOTWGT"].ToString(),
                                                               dr["IRONTEMPERATURE"].ToString(),
                                                               dr["CHECKNO"].ToString(),
                                                               dr["C"].ToString(),   
                                                               dr["MN"].ToString(),
                                                               dr["S"].ToString(),
                                                               dr["P"].ToString(),
                                                               dr["SI"].ToString(),
                                                               dr["Sn"].ToString(),
                                                               dr["As"].ToString(),
                                                               dr["Cu"].ToString(),
                                                               dr["Cr"].ToString(),
                                                               dr["HSTAPHOLETIME"].ToString(),
                                                               dr["ARRIVETIME"].ToString(), 
                                                               dr["shiftcode"].ToString().Substring(1,1),
                                                               dr["shiftcode"].ToString().Substring(0,1),                                                                        
                                                               dr["OPTPERSONNEL"].ToString(), 
                                                               dr["OPERATIONDATE"].ToString(),                                                                
                                                               dr["MEMO"].ToString(), 
                                                               dr["molirnsource"].ToString(),
                                                               dr["C_P"].ToString(),   
                                                               dr["MN_P"].ToString(),
                                                               dr["S_P"].ToString(),
                                                               dr["P_P"].ToString(),
                                                               dr["SI_P"].ToString(),
                                                               dr["Sn_P"].ToString(),
                                                               dr["As_P"].ToString(),
                                                               dr["Cu_P"].ToString(),
                                                               dr["Cr_P"].ToString(),
                                                               dr["RSWGT"].ToString(),
                                                               dr["BFIRONTEMTURE"].ToString(),
                                                               dr["IRONTEMPERATURE2"].ToString()
                                                        });
                        }
                    }
                }
                else
                    MessageBox.Show("铁运进铁详细信息查询失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch
            { }

        }

        private void RefreshHighheatNo()
        {
            int nFurnaceNo = 0;
            try
            {
                string strErr = "";

                if (this.rdoFNo1.Checked) nFurnaceNo = 9;
                if (this.rdoFNo2.Checked) nFurnaceNo = 10;
                if (this.radioButton1.Checked) nFurnaceNo = 0;
                ArrayList arry = new ArrayList();
                arry.Add("GetBfIronInfo.Select");//此ID为XML文件ID
                arry.Add(nFurnaceNo);
                arry.Add(nFurnaceNo);

                CommonClientToServer ccTos = new CommonClientToServer();
                ccTos.ob = this.ob;
                //查询高炉铁水信息
                DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob",
                                                         "GetBfIronInfo", arry, out strErr);
                int intIndex = 0;
                if (strErr == "" && ds != null)
                {
                    ultradsBfIron.Rows.Clear();
                    if (ds.Tables.Count > 0)
                    {
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            ultradsBfIron.Rows.Add(new object[] {
                                                               dr["ID_"].ToString(),
                                                               dr["STOVEID"].ToString(),
                                                               dr["STOVETIME"].ToString(),       
                                                               dr["TAPHOLENO"].ToString(),
                                                               dr["TFPOTID"].ToString(),
                                                               dr["TFPOTTAREWGT"].ToString(),
                                                               dr["TFPOTGROSSWGT"].ToString(),
                                                               dr["TFPOTWGT"].ToString(),
                                                               dr["TFIRONTEMP"].ToString(),
                                                               dr["C"].ToString(),   
                                                               dr["MN"].ToString(),
                                                               dr["S"].ToString(),
                                                               dr["P"].ToString(),
                                                               dr["SI"].ToString(), 
                                                               dr["Sn"].ToString(),
                                                               dr["As"].ToString(),
                                                               dr["Cu"].ToString(),
                                                               dr["Cr"].ToString(),
                                                               dr["Ti"].ToString(),
                                                               dr["STATUS"].ToString().Trim()=="0"?"未确认":(dr["STATUS"].ToString().Trim()=="3"?"已确认":"异常"),
                                                               dr["HSTAPHOLETIME"].ToString(), 
                                                               dr["ASSAYDATE"].ToString(), 
                                                               dr["HEATNO"].ToString(), 
                                                               dr["CHECKNO"].ToString(),                                                                
                                                        });

                            if (ultragridBfIron.Rows[intIndex].Cells["STATUS"].Value.ToString() == "已确认")
                                ultragridBfIron.Rows[intIndex].Cells["STATUS"].Appearance.BackColor = Color.LawnGreen;
                            intIndex++;
                        }
                    }
                }
            }
            catch { return; }
        }

        private void InsertBFIronData()
        {
            string strSqlID = "";         //sqlId
            string strErr = "";           //错误信息   

            if (string.IsNullOrEmpty(ultragridInIronEdit.Rows[0].Cells["HighNo"].Text)) 
            {
                MessageBox.Show("高炉号不可为空,请输入高炉号!");
                return;
            }

            if (ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动")
            {
                strSqlID = "InsertBFIronData.Insert"; //SQLID 
                Hashtable ht = new Hashtable();

                ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["HighNo"].Text);  //高炉炉号
                ht.Add("I2", ultragridInIronEdit.Rows[0].Cells["stovetime"].Text);  //高炉炉次  
                ht.Add("I3", ultragridInIronEdit.Rows[0].Cells["tapholeno"].Text);  //出铁口
                ht.Add("I4", ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text);  //铁罐罐号
                ht.Add("I5", ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text);  //铁罐皮重      
                ht.Add("I6", ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text);  //铁罐毛重 
                ht.Add("I7", ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text);  //铁水重量
                ht.Add("I8", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text);  //铁水温度
                ht.Add("I9", ultragridInIronEdit.Rows[0].Cells["checkno"].Text);  //铁水成分检验号
                ht.Add("I10", ultragridInIronEdit.Rows[0].Cells["C"].Text); //C
                ht.Add("I11", ultragridInIronEdit.Rows[0].Cells["Mn"].Text); //MN  
                ht.Add("I12", ultragridInIronEdit.Rows[0].Cells["S"].Text); //S
                ht.Add("I13", ultragridInIronEdit.Rows[0].Cells["P"].Text); //P
                ht.Add("I14", ultragridInIronEdit.Rows[0].Cells["Si"].Text); //SI 
                ht.Add("I15", ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Text); //高炉出铁时间
                ht.Add("I16", ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text); //入厂时间
                ht.Add("I17", ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text)); //班次班别
                ht.Add("I18", ultragridInIronEdit.Rows[0].Cells["MEMO"].Text); //备注
                ht.Add("I19", User); //操作人员
                ht.Add("I20", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //操作时间
                ht.Add("I21", ultragridInIronEdit.Rows[0].Cells["RsWgt"].Text);  //回炉钢水 改为铁包废钢
                ht.Add("I22", ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Text);  //高炉铁水温度
                ht.Add("I23", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag);  //高炉铁水温度序号
                ht.Add("I24", ultragridInIronEdit.Rows[0].Cells["Sn"].Text); //Sn 
                ht.Add("I25", ultragridInIronEdit.Rows[0].Cells["As"].Text); //As 
                ht.Add("I26", ultragridInIronEdit.Rows[0].Cells["Cu"].Text); //Cu 
                ht.Add("I27", ultragridInIronEdit.Rows[0].Cells["Cr"].Text); //Cr 
                ht.Add("I28", ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Text); //平台温度2
                ht.Add("O1", "");
                ht.Add("O2", "");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;

                CoreClientParam ccp = ccTs.ExecuteProcedureFunctionsCCP("Core.LgMes.Server.LgJobMgt.ClassHmpJob",
                                                "InsertBFIronData", strSqlID, ht, out strErr);

                ArrayList alReturn = ccp.ReturnObject as ArrayList;

                if (strErr == "" && alReturn[3] == null)
                    MessageBox.Show("高炉铁水信息确认成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                else
                    MessageBox.Show("高炉铁水信息确认失败！" + alReturn[3], "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                strSqlID = "UpdateBFIronData.Update"; //SQLID 
                Hashtable ht = new Hashtable();

                ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["HighNo"].Text);  //高炉炉号
                ht.Add("I2", ultragridInIronEdit.Rows[0].Cells["stovetime"].Text);  //高炉炉次  
                ht.Add("I3", ultragridInIronEdit.Rows[0].Cells["tapholeno"].Text);  //出铁口
                ht.Add("I4", ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text);  //铁罐罐号
                ht.Add("I5", ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text);  //铁罐皮重      
                ht.Add("I6", ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text);  //铁罐毛重 
                ht.Add("I7", ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text);  //铁水重量
                ht.Add("I8", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text);  //铁水温度
                ht.Add("I9", ultragridInIronEdit.Rows[0].Cells["checkno"].Text);  //铁水成分检验号
                ht.Add("I10", ultragridInIronEdit.Rows[0].Cells["C"].Text); //C
                ht.Add("I11", ultragridInIronEdit.Rows[0].Cells["Mn"].Text); //MN  
                ht.Add("I12", ultragridInIronEdit.Rows[0].Cells["S"].Text); //S
                ht.Add("I13", ultragridInIronEdit.Rows[0].Cells["P"].Text); //P
                ht.Add("I14", ultragridInIronEdit.Rows[0].Cells["Si"].Text); //SI      
                ht.Add("I15", ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Text); //高炉出铁时间
                ht.Add("I16", ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text); //入厂时间
                ht.Add("I17", ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text)); //班次班别
                ht.Add("I18", ultragridInIronEdit.Rows[0].Cells["MEMO"].Text); //备注
                ht.Add("I19", User); //操作人员
                ht.Add("I20", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //操作时间
                ht.Add("I21", ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text);  //进铁序号
                ht.Add("I22", ultragridInIronEdit.Rows[0].Cells["RsWgt"].Text);  //回炉钢水 改为铁包废钢
                ht.Add("I23", ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Text);  //高炉铁水温度
                ht.Add("I24", ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag);  //高炉铁水温度序号
                ht.Add("I25", ultragridInIronEdit.Rows[0].Cells["Sn"].Text); //Sn 
                ht.Add("I26", ultragridInIronEdit.Rows[0].Cells["As"].Text); //As 
                ht.Add("I27", ultragridInIronEdit.Rows[0].Cells["Cu"].Text); //Cu 
                ht.Add("I28", ultragridInIronEdit.Rows[0].Cells["Cr"].Text); //Cr 
                ht.Add("I29", ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Text); //平台温度2
                ht.Add("O1", "");
                ht.Add("O2", "");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;

                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob",
                                                "UpdateBFIronData", strSqlID, ht, out strErr);

                if (strErr == "")
                    MessageBox.Show("高炉铁水信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                else
                    MessageBox.Show("高炉铁水信息修改失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        #endregion

        #region gridevent

        private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            if (e.Row != null)
            {
                if (e.Row.Cells["STATUS"].Value.ToString() == "已确认")
                {
                    MessageBox.Show("铁水已经确认，不能重复确认！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
            }

            if (blModify == false)
            {
                setbutton("2");
                setucInIron("2");

                string shiftgroup = CStaticMethod.GetCurrentClass(this.ob);

                Infragistics.Win.UltraWinGrid.UltraGridRow aRow = e.Row;

                try
                {
                    SetMisnoNoEdite();
                    ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "自动";
                    ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = DateTime.Now;
                    ultragridInIronEdit.Rows[0].Cells["Group"].Value = ConvertShift("1", shiftgroup);
                    ultragridInIronEdit.Rows[0].Cells["Shift"].Value = ConvertShift("2", shiftgroup);
                    ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = e.Row.Cells["STOVEID"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["tapholeno"].Value = e.Row.Cells["tapholeno"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["stovetime"].Value = e.Row.Cells["stovetime"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Value = e.Row.Cells["tfirontemp"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = "";

                    //ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value != System.DBNull.Value ? e.Row.Cells["C"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value != System.DBNull.Value ? e.Row.Cells["SI"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value != System.DBNull.Value ? e.Row.Cells["MN"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value != System.DBNull.Value ? e.Row.Cells["P"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["S"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value != System.DBNull.Value ? e.Row.Cells["Sn"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value != System.DBNull.Value ? e.Row.Cells["As"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["Cu"].Value != System.DBNull.Value ? e.Row.Cells["Cu"].Text : "0";
                    //ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["Cr"].Value != System.DBNull.Value ? e.Row.Cells["Cr"].Text : "0";

                    ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value.ToString().Length > 0 ? e.Row.Cells["C"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value.ToString().Length > 0 ? e.Row.Cells["SI"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value.ToString().Length > 0 ? e.Row.Cells["MN"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value.ToString().Length > 0 ? e.Row.Cells["P"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value.ToString().Length > 0 ? e.Row.Cells["S"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value.ToString().Length > 0 ? e.Row.Cells["Sn"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value.ToString().Length > 0 ? e.Row.Cells["As"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["Cu"].Value.ToString().Length > 0 ? e.Row.Cells["Cu"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["Cr"].Value.ToString().Length > 0 ? e.Row.Cells["Cr"].Text : "0";

                    ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = e.Row.Cells["TFPOTID"].Value != System.DBNull.Value ? e.Row.Cells["TFPOTID"].Text : "";
                    ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = e.Row.Cells["tfpottarewgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpottarewgt"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = e.Row.Cells["tfpotgrosswgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotgrosswgt"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = e.Row.Cells["tfpotwgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotwgt"].Text : "0";
                    ultragridInIronEdit.Rows[0].Cells["checkno"].Value = e.Row.Cells["checkno"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Value = e.Row.Cells["hstapholetime"].Text.ToString();
                    ultragridInIronEdit.Rows[0].Cells["RsWgt"].Value = "0";
                }
                catch
                { }
            }
            else
            {
                ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = e.Row.Cells["STOVEID"].Text.Substring(0, 1);
                ultragridInIronEdit.Rows[0].Cells["C"].Value = e.Row.Cells["C"].Value != System.DBNull.Value ? e.Row.Cells["C"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Si"].Value = e.Row.Cells["SI"].Value != System.DBNull.Value ? e.Row.Cells["SI"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Mn"].Value = e.Row.Cells["MN"].Value != System.DBNull.Value ? e.Row.Cells["MN"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["P"].Value = e.Row.Cells["P"].Value != System.DBNull.Value ? e.Row.Cells["P"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["S"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["S"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Sn"].Value = e.Row.Cells["Sn"].Value != System.DBNull.Value ? e.Row.Cells["Sn"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["As"].Value = e.Row.Cells["As"].Value != System.DBNull.Value ? e.Row.Cells["As"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Cu"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["Cu"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Cr"].Value = e.Row.Cells["S"].Value != System.DBNull.Value ? e.Row.Cells["Cr"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = e.Row.Cells["TFPOTID"].Value != System.DBNull.Value ? e.Row.Cells["TFPOTID"].Text : "";
                ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = e.Row.Cells["tfpottarewgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpottarewgt"].Text : "";
                ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = e.Row.Cells["tfpotgrosswgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotgrosswgt"].Text : "";
                ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = e.Row.Cells["tfpotwgt"].Value != System.DBNull.Value ? e.Row.Cells["tfpotwgt"].Text : "";
                ultragridInIronEdit.Rows[0].Cells["RsWgt"].Value = "0";
            }
        }
        /// <summary>
        /// 取相关数据到编辑区 铁运进铁数据
        ///  </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            Infragistics.Win.UltraWinGrid.UltraGridRow aRow = ultragridInIron.ActiveRow;
            if (aRow == null) return;
            if (ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动") return;
            try
            {
                ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = aRow.Cells["MISID"].Text;
                ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = aRow.Cells["STOVEID"].Text;
                ultragridInIronEdit.Rows[0].Cells["STOVETIME"].Value = aRow.Cells["STOVETIME"].Text;
                ultragridInIronEdit.Rows[0].Cells["TAPHOLENO"].Value = aRow.Cells["TAPHOLENO"].Text;
                ultragridInIronEdit.Rows[0].Cells["BFIRONTEMTURE"].Value = aRow.Cells["BFIRONTEMTURE"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["BFIRONTEMTURE"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = aRow.Cells["IRONTEMPERATURE"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["IRONTEMPERATURE"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Value = aRow.Cells["TFPOTGROSSWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTGROSSWGT"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Value = aRow.Cells["TFPOTTAREWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTTAREWGT"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = aRow.Cells["TFPOTWGT"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTWGT"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = aRow.Cells["TFPOTID"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["TFPOTID"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = aRow.Cells["ARRIVETIME"].Text;
                ultragridInIronEdit.Rows[0].Cells["Group"].Value = aRow.Cells["group"].Text;
                ultragridInIronEdit.Rows[0].Cells["Shift"].Value = aRow.Cells["Shift"].Text;
                ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Value = aRow.Cells["molirnsource"].Text;
                ultragridInIronEdit.Rows[0].Cells["checkno"].Value = aRow.Cells["checkno"].Text.ToString();
                ultragridInIronEdit.Rows[0].Cells["hstapholetime"].Value = aRow.Cells["hstapholetime"].Text.ToString();
                ultragridInIronEdit.Rows[0].Cells["RSWGT"].Value = aRow.Cells["RSWGT"].Text.ToString();
                ultragridInIronEdit.Rows[0].Cells["IRONTEMPERATURE2"].Value = aRow.Cells["IRONTEMPERATURE2"].Text.ToString();

                ultragridInIronEdit.Rows[0].Cells["C"].Value = aRow.Cells["C"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["C"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Si"].Value = aRow.Cells["SI"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["SI"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Mn"].Value = aRow.Cells["MN"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["MN"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["P"].Value = aRow.Cells["P"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["P"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["S"].Value = aRow.Cells["S"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["S"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Sn"].Value = aRow.Cells["Sn"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Sn"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["As"].Value = aRow.Cells["As"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["As"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Cu"].Value = aRow.Cells["Cu"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Cu"].Text : "0";
                ultragridInIronEdit.Rows[0].Cells["Cr"].Value = aRow.Cells["Cr"].Value.ToString() != System.DBNull.Value.ToString() ? aRow.Cells["Cr"].Text : "0";

            }
            catch { }

        }

        /// <summary>
        /// 铁运进铁设置初始数据
        /// </summary>
        private void SetGridNewIronData()
        {
            ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "自动";
            ultragridInIronEdit.Rows[0].Cells["HighNo"].Value = "";
            ultragridInIronEdit.Rows[0].Cells["InIronTime"].Value = DateTime.Now;
            ultragridInIronEdit.Rows[0].Cells["Group"].Value = ConvertShift("1", CStaticMethod.GetCurrentClass(this.ob));
            ultragridInIronEdit.Rows[0].Cells["Shift"].Value = ConvertShift("2", CStaticMethod.GetCurrentClass(this.ob));

            ultragridInIronEdit.Rows[0].Cells["GuanNo"].Value = "";
            ultragridInIronEdit.Rows[0].Cells["LdKongWeight"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["LdMaoWeight"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["C"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["Si"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["Mn"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["P"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["S"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["As"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["Sn"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["Cu"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["Cr"].Value = "0";
            ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Value = this.Text.Substring(0, 1);
            ultragridInIronEdit.Rows[0].Cells["RSWGT"].Value = "0";
        }

        private void ucInIron1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            float flPZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["LdKongWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["LdKongWeight"].Text : "0");
            float flMZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Text : "0");
            float flJZ = Convert.ToSingle(ultragridBfIron.Rows[0].Cells["IronWeight"].Text != System.DBNull.Value.ToString() ? ultragridBfIron.Rows[0].Cells["IronWeight"].Text : "0");
            switch (e.Cell.Column.Key)
            {
                case "LdMaoWeight":
                    {
                        try
                        {
                            if (flPZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ);
                            else if (flJZ > 0) ultragridBfIron.Rows[0].Cells["LdKongWeight"].Value = Convert.ToString(flMZ - flJZ);
                            else if (flPZ > 0 && flJZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ);
                        }
                        catch { }
                        break;
                    }
                case "LdKongWeight":
                    {
                        try
                        {
                            if (flMZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ);
                            else if (flJZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flPZ + flJZ);
                            else if (flMZ > 0 && flJZ > 0) ultragridBfIron.Rows[0].Cells["IronWeight"].Value = Convert.ToString(flMZ - flPZ);
                        }
                        catch { }
                        break;
                    }
                case "IronWeight":
                    {
                        try
                        {
                            if (flPZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flJZ + flPZ);
                            else if (flMZ > 0) ultragridBfIron.Rows[0].Cells["LdKongWeight"].Value = Convert.ToString(flMZ - flJZ);
                            else if (flMZ > 0 && flPZ > 0) ultragridBfIron.Rows[0].Cells["LdMaoWeight"].Value = Convert.ToString(flJZ + flPZ);
                        }
                        catch { }
                        break;
                    }
            }


        }


        /// <summary>
        /// editbutton事件的委托
        /// </summary>
        private void SetUserControlDelegate()
        {
            ultragridBfIron.CellChange += new Infragistics.Win.UltraWinGrid.CellEventHandler(ucInIron1_CellChange);
        }
        #endregion

        #region function

        private string ConvertShift(string flag, string shift)
        {
            string StrReturn = "";
            if (flag == "1" & shift != "" & shift != null)
            {
                switch (shift.Substring(0, 1))
                {
                    case "1":
                        StrReturn = "白";
                        break;
                    case "2":
                        StrReturn = "中";
                        break;
                    case "3":
                        StrReturn = "夜";
                        break;

                }



            }
            else if (flag == "2" & shift.Length > 1)
            {
                switch (shift.Substring(1, 1))
                {
                    case "1":
                        StrReturn = "甲";
                        break;
                    case "2":
                        StrReturn = "乙";
                        break;
                    case "3":
                        StrReturn = "丙";
                        break;
                    case "4":
                        StrReturn = "丁";
                        break;
                }

            }
            else if (flag == "3" & shift != "")
            {
                switch (shift.Trim())
                {
                    case "白":
                        StrReturn = "1";
                        break;
                    case "中":
                        StrReturn = "2";
                        break;
                    case "夜":
                        StrReturn = "3";
                        break;
                }

            }
            else if (flag == "4" & shift != "")
            {
                switch (shift.Trim())
                {
                    case "甲":
                        StrReturn = "1";
                        break;
                    case "乙":
                        StrReturn = "2";
                        break;
                    case "丙":
                        StrReturn = "3";
                        break;
                    case "丁":
                        StrReturn = "4";
                        break;
                }

            }

            return StrReturn;
        }

        /// <summary>
        /// 设置班组下拉框
        /// </summary>
        /// <param name="Grid"></param>
        private void SetColumnModeGroup(Infragistics.Win.UltraWinGrid.UltraGridBase Grid)
        {
            DataTable dt = new DataTable();
            dt.TableName = "JIALIAO";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "1";
            dr["BCNA"] = "白";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "2";
            dr["BCNA"] = "中";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "3";
            dr["BCNA"] = "夜";
            dt.Rows.Add(dr);

            JJBStaticFunction.SetGridDropDownListCell("Group", 0, "班次", 60, Grid, dt, "BCBM", "BCNA");
        }
        /// <summary>
        /// 设置班组下拉框
        /// </summary>
        /// <param name="Grid"></param>
        private void SetColumnModeShift(Infragistics.Win.UltraWinGrid.UltraGridBase Grid)
        {
            DataTable dt = new DataTable();
            dt.TableName = "JIALIAO";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "1";
            dr["BCNA"] = "甲";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "2";
            dr["BCNA"] = "乙";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "3";
            dr["BCNA"] = "丙";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "4";
            dr["BCNA"] = "丁";
            dt.Rows.Add(dr);


            JJBStaticFunction.SetGridDropDownListCell("Shift", 0, "班组", 60, Grid, dt, "BCBM", "BCNA");
        }
        /// <summary>
        /// 设置去向
        /// </summary>
        private void SetColumnModequxiang()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JIALIAO";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "1";
            dr["BCNA"] = "1#混铁炉";
            dt.Rows.Add(dr);
            //dr = dt.NewRow();
            //dr["BCBM"] = "2";
            //dr["BCNA"] = "2#混铁炉";
            //dt.Rows.Add(dr);



            //Core.LgMes.Client.LgIntegrationQuery.JJBStaticFunction.SetGridDropDownListCell("IronQuxiang", 0, "铁水去向", 135, ucInIron1.ultraGrid1, dt, "BCBM", "BCNA");
        }
        /// <summary>
        /// 设置去向
        /// </summary>
        private void SetColumnModeOutquxiang()
        {
            DataTable dt = new DataTable();
            dt.TableName = "JIALIAO";
            DataColumn dc = new DataColumn("BCBM", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            dc = new DataColumn("BCNA", Type.GetType("System.String"));
            dt.Columns.Add(dc);
            DataRow dr = dt.NewRow();
            dr["BCBM"] = "1";
            dr["BCNA"] = "1#转炉";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "2";
            dr["BCNA"] = "2#转炉";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "3";
            dr["BCNA"] = "3#转炉";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr["BCBM"] = "4";
            dr["BCNA"] = "1#预处理";
            dt.Rows.Add(dr);
            //dr = dt.NewRow();
            //dr["BCBM"] = "5";
            // dr["BCNA"] = "2#预处理";
            // dt.Rows.Add(dr);


            //Core.LgMes.Client.LgIntegrationQuery.JJBStaticFunction.SetGridDropDownListCellEdit("IronQuxiang", 0, "铁水去向", 100, ucHtOutIron1.ultraGrid1, dt, "BCBM", "BCNA");
        }
        /// <summary>
        /// 序号栏锁定
        /// </summary>
        private void SetMisnoNoEdite()
        {
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue;
        }
        /// <summary>
        /// 序号栏锁定
        /// </summary>
        private void SetMisnoNoEdite2()
        {
            ultragridBfIron.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridBfIron.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = System.Drawing.SystemColors.ActiveBorder;
        }

        private void timer1_Tick(object sender, EventArgs e)
        {

            RefreshHighheatNo();
            // GetCVTHeatno();

        }
        /// <summary>
        /// 设置铁运进铁 按钮状态
        /// 
        /// </summary>
        /// <param name="flag"></param>
        private void setbutton(string flag)
        {
            switch (flag)
            {
                case "1":
                    this.ToolBarItemEnable(this, "Query", true);
                    this.ToolBarItemEnable(this, "Add", true);
                    this.ToolBarItemEnable(this, "Update", true);
                    this.ToolBarItemEnable(this, "Del", true);
                    this.ToolBarItemEnable(this, "Save", false);
                    this.ToolBarItemEnable(this, "Cancel", false);
                    this.ToolBarItemEnable(this, "Exit", true);

                    break;
                case "2":
                    this.ToolBarItemEnable(this, "Query", true);
                    this.ToolBarItemEnable(this, "Add", false);
                    this.ToolBarItemEnable(this, "Update", false);
                    this.ToolBarItemEnable(this, "Del", false);
                    this.ToolBarItemEnable(this, "Save", true);
                    this.ToolBarItemEnable(this, "Cancel", true);
                    this.ToolBarItemEnable(this, "Exit", true);
                    break;
            }
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    GetInIronData();
                    break;
                case "Add":
                    setbutton("2");
                    setucInIron("2");
                    SetMisnoNoEdite();
                    SetGridNewIronData();
                    break;
                case "Update":
                    blModify = true;
                    setbutton("2");
                    setucInIron("2");
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue;
                    //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.LightBlue;
                    //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    //ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightBlue;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightBlue;
                    //.DisplayLayout.Bands[0].Columns["Temptrue"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    //ultragridInIronEdit.DisplayLayout.Bands[0].Columns["Temptrue"].CellAppearance.BackColor = Color.LightBlue;
                    break;
                case "Del":
                    DelBfIronInData();
                    break;
                case "Save":
                    if (CheckData() == false)
                    {
                        MessageBox.Show(this, "输入的数据不完整或错误，请检查！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return;
                    }

                    InsertBFIronData();
                    GetInIronData();
                    break;
                case "Cancel":
                    setbutton("1");
                    setucInIron("1");
                    ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "";
                    ultraGrid2_AfterRowActivate(null, null);
                    blModify = false;
                    break;
                case "Send":
                    frmSendIron frmSIron = new frmSendIron();
                    frmSIron.ob = this.ob;
                    frmSIron.StartPosition = FormStartPosition.CenterParent;
                    frmSIron.ShowDialog();
                    break;
                case "Exit":
                    this.Close();
                    break;
                case "Export":
                    ExportDataWithSaveDialog(ref this.ultragridInIron, "铁运进铁");
                    break;
                default:
                    break;

            }
        }
        /// <summary>
        /// 设置 ucInIron Grid的读写状态
        /// 1:NoEDIT 2:ALLOWEDIT
        /// </summary>
        /// <param name="flag"></param>
        private void setucInIron(string flag)
        {
            switch (flag)
            {
                case "1":
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[27].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[28].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[29].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

                    ultragridInIronEdit.DisplayLayout.Override.CellAppearance.BackColor = Color.LightBlue;
                    break;
                case "2":
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[27].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[28].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Bands[0].Columns[29].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                    ultragridInIronEdit.DisplayLayout.Override.CellAppearance.BackColor = Color.White;

                    break;
            }

        }

        private static bool IsDouble(string AValue)
        {
            try
            {
                Convert.ToDouble(AValue);
                return true;
            }
            catch
            {
                return false;
            }
        }
        /// <summary>
        /// 数据CHECK
        /// </summary>
        /// <returns></returns>
        private bool CheckData()
        {


            if (ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Value = "0";
            if (ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Value = "0";
            if (ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["IronWeight"].Value = "0";
            if (ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["C"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["C"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["Si"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Si"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["Mn"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Mn"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["P"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["P"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["S"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["S"].Value = "";

            if (ultragridInIronEdit.Rows[0].Cells["Sn"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Sn"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["As"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["As"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["Cu"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Cu"].Value = "";
            if (ultragridInIronEdit.Rows[0].Cells["Cr"].Text.Trim().Length == 0)
                ultragridInIronEdit.Rows[0].Cells["Cr"].Value = "";

            //if (!IsDouble(ucInIron1.ultraGrid1.Rows[0].Cells["Temptrue"].Text))
            //{
            //    return false;
            //}
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["C"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Si"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Mn"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["P"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["S"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Sn"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["As"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Cu"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["Cr"].Text))
            {
                return false;
            }

            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text))
            {
                return false;
            }

            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text))
            {
                return false;
            }

            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text))
            {
                return false;
            }
            if (!IsDouble(ultragridInIronEdit.Rows[0].Cells["RSWGT"].Text))
            {
                return false;
            }
            return true;
        }


        /// <summary>
        /// 取铁运进铁的数据 到数组
        /// </summary>
        private void GetGridData()
        {
            try
            {

                ArrayIronRow[0] = ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text;
                ArrayIronRow[1] = ultragridInIronEdit.Rows[0].Cells["HighNo"].Text;
                ArrayIronRow[2] = ConvertShift("3", ultragridInIronEdit.Rows[0].Cells["Group"].Text) + ConvertShift("4", ultragridInIronEdit.Rows[0].Cells["shift"].Text);
                ArrayIronRow[3] = ultragridInIronEdit.Rows[0].Cells["InIronTime"].Text;
                ArrayIronRow[4] = ultragridInIronEdit.Rows[0].Cells["Temptrue"].Text;
                ArrayIronRow[5] = ultragridInIronEdit.Rows[0].Cells["GuanNo"].Text;
                ArrayIronRow[6] = ultragridInIronEdit.Rows[0].Cells["LDKongWeight"].Text;
                ArrayIronRow[7] = ultragridInIronEdit.Rows[0].Cells["LDMaoWeight"].Text;
                ArrayIronRow[8] = ultragridInIronEdit.Rows[0].Cells["IronWeight"].Text;
                ArrayIronRow[9] = ultragridInIronEdit.Rows[0].Cells["HighNo"].Text;
                ArrayIronRow[10] = ultragridInIronEdit.Rows[0].Cells["C"].Text;
                ArrayIronRow[11] = ultragridInIronEdit.Rows[0].Cells["Si"].Text;
                ArrayIronRow[12] = ultragridInIronEdit.Rows[0].Cells["Mn"].Text;
                ArrayIronRow[13] = ultragridInIronEdit.Rows[0].Cells["P"].Text;
                ArrayIronRow[14] = ultragridInIronEdit.Rows[0].Cells["S"].Text;
                ArrayIronRow[15] = ultragridInIronEdit.Rows[0].Cells["As"].Text;
                ArrayIronRow[16] = ultragridInIronEdit.Rows[0].Cells["IronQuxiang"].Text;
                ArrayIronRow[17] = User;
                ArrayIronRow[18] = ultragridInIronEdit.Rows[0].Cells["RSWGT"].Text;

                ArrayIronRow[19] = ultragridInIronEdit.Rows[0].Cells["Sn"].Text;
                ArrayIronRow[20] = ultragridInIronEdit.Rows[0].Cells["Cu"].Text;
                ArrayIronRow[21] = ultragridInIronEdit.Rows[0].Cells["Cr"].Text;
            }
            catch { }


        }

        #endregion

        #region buttonevent


        private void ulbtnAdd_Click(object sender, EventArgs e)
        {
            setbutton("2");
            setucInIron("2");
            SetMisnoNoEdite();
            SetGridNewIronData();

        }

        private void ulbtnEdit_Click(object sender, EventArgs e)
        {
            blModify = true;
            setbutton("2");
            setucInIron("2");
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[0].CellAppearance.BackColor = Color.LightBlue;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.LightBlue;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightBlue;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
            ultragridInIronEdit.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightBlue;
        }

        private void DelBfIronInData()
        {
            if (ultragridInIronEdit.ActiveRow == null || ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text == "自动") return;
            if (MessageBox.Show(this, "您确定要删除【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】铁运进铁信息？", "提示",
                MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return;
            try
            {
                string strErr = "";
                string strSqlID = "DeleteBFIronData.Delete"; //SQLID 
                Hashtable ht = new Hashtable();

                ht.Add("I1", ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text);  //进铁序号
                ht.Add("O1", "");
                ht.Add("O2", "");

                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;

                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.LgJobMgt.ClassHmpJob",
                                                "DeleteBFIronData", strSqlID, ht, out strErr);

                if (strErr == "")
                    MessageBox.Show("高炉铁水【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                else
                    MessageBox.Show("高炉铁水【" + ultragridInIronEdit.Rows[0].Cells["InIronNo"].Text + "】信息删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);


            }
            catch (Exception ee)
            {
                string s = ee.Message;
            }

            GetInIronData();
        }

        private void ulbtnSave_Click(object sender, EventArgs e)
        {
            if (CheckData() == false)
            {
                MessageBox.Show(this, "输入的数据不完整或错误，请检查！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            InsertBFIronData();
            GetInIronData();

        }

        private void ulbtnCancel_Click(object sender, EventArgs e)
        {
            setbutton("1");
            setucInIron("1");
            ultragridInIronEdit.Rows[0].Cells["InIronNo"].Value = "";
            ultraGrid2_AfterRowActivate(null, null);
            blModify = false;

        }

        private void ulbtnRef_Click(object sender, EventArgs e)
        {
            GetInIronData();

        }


        #endregion

        /// <summary>
        /// 获取铁包包龄
        /// </summary>
        /// <param name="strIronwrapID"></param>
        /// <returns></returns>
        private int GetIronwrapAge(string strIronwrapID, out string strStatus)
        {
            string strErr = "";
            int intIronAge = 0;
            string _strStatus = "";
            object obj = null;// ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                         "Core.LgMes.Server.lgJobMgt.classIronJob",
            //                                         "GetIronwrapAge", new object[] { "res_mis_taphole", strIronwrapID }, out strErr);
            if (strErr == "")
            {

                DataSet ds = (DataSet)obj;
                if (ds.Tables.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        intIronAge = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                        _strStatus = ds.Tables[0].Rows[0]["STATUS"].ToString();
                    }
                }
            }
            strStatus = _strStatus;
            return intIronAge;
        }

        private void ultraGrid4_KeyDown(object sender, KeyEventArgs e)
        {
            //if (e.KeyCode != Keys.Enter)
            //    return;

            //ultraGrid4.UpdateData();
            //string keyStr = ultraGrid4.ActiveCell.Column.Key;
            //double valueStr = 0;
            //string strFindName = "";
            //string strErr = "";
            //if (keyStr == "AllInrion" || keyStr == "OutIronAll" || keyStr == "ZhiDuiAll")
            //{
            //    if (keyStr == "AllInrion") strFindName = "IMPORTIRONTOTAL";
            //    if (keyStr == "OutIronAll") strFindName = "EXPORTIRONTOTAL";
            //    if (keyStr == "ZhiDuiAll") strFindName = "SKIPIRONTOTAL";
            //    try
            //    {
            //        if (ultraGrid4.ActiveCell.Value.ToString() != "")
            //        {
            //            valueStr = Convert.ToDouble(ultraGrid4.ActiveCell.Value);
            //            object obj = null;// ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                //             "Core.LgMes.Server.lgJobMgt.classIronJob",
            //                                  //           "StatIronWeight", new object[] { this.Text.Substring(0, 1), strFindName, 0, valueStr, 2 }, out strErr);
            //            if (strErr == "")
            //                ultraGrid4.ActiveCell.Value = valueStr;
            //            else
            //                MessageBox.Show("修改数据失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            //        }
            //    }
            //    catch (Exception ex)
            //    {
            //        string Msg = ex.Message;
            //        MessageBox.Show("输入数据格式错误，请改正！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //    }
            //}
        }

        private void HeatNo_HudwId_Exist(string strID)
        {
            string strErr = "";
            string strGw = "";
            if (strID.Substring(0, 1) == "H")
                strGw = strID.Substring(0, 2);
            else
                strGw = strID.Substring(2, 1);

            string obj = "";// (string)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
            //                                       "Core.LgMes.Server.lgJobMgt.classIronJob",
            //                                     "HeatNo_HudwId_Exist", new object[] { strID }, out strErr);
            if (strErr == "")
            {
                switch (strGw)
                {
                    case "H1":
                        _strSendSucceededForHmp1 = obj;
                        break;
                    case "H2":
                        _strSendSucceededForHmp2 = obj;
                        break;
                    case "1":
                        _strSendSucceededForBof1 = obj;
                        break;
                    case "2":
                        _strSendSucceededForBof2 = obj;
                        break;
                    case "3":
                        _strSendSucceededForBof3 = obj;
                        break;
                    default:
                        break;
                }
            }
        }

        private void ultrabtHRef_Click(object sender, EventArgs e)
        {
            RefreshHighheatNo();  //手动刷新高炉铁水信息
        }

        private void chkInIronDate_CheckedChanged(object sender, EventArgs e)
        {
            CheckBox chkMain = (CheckBox)sender;
            if (chkMain.Name == "chkShift")
            {
                cboShift.Enabled = chkMain.Checked;
                cboShift.Value = 0;
            }
            else if (chkMain.Name == "chkInIronDate")
            {
                dtpBegin.Enabled = chkMain.Checked;
                dtpEnd.Enabled = chkMain.Checked;
            }
            else if (chkMain.Name == "chkBfNo")
                ultratxtBfNo.Enabled = chkMain.Checked;
        }

        private void ultratxtBfNo_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            ultratxtBfNo.Text = "";
        }

        private void ultragridInIron_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            if (ultragridInIron.ActiveRow != null)
            {
                frmSendIron frmSIron = new frmSendIron();
                frmSIron.ob = this.ob;
                frmSIron.strKR_Charge_NO = ultragridInIron.ActiveRow.Cells["MISID"].Value.ToString();
                frmSIron.StartPosition = FormStartPosition.CenterParent;
                frmSIron.ShowDialog();
            }
        }


        /// <summary>
        /// 通过穿入的sql返回数据集
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        private DataSet returnCommonDataSet(string sqlStr)
        {
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            CoreClientParam CCP_Query = new CoreClientParam();
            CCP_Query.ServerName = "Core.LgMes.Server.Common.ComDBExecute";
            CCP_Query.MethodName = "doSimpleQuery";
            CCP_Query.ServerParams = new object[] { sqlStr };
            CCP_Query.SourceDataTable = dt;
            try
            {
                this.ExecuteQueryToDataTable(CCP_Query, CoreInvokeType.Internal);
                ds.Tables.Add(dt);
            }
            catch
            {

            }


            return ds;


        }





        private void ultragridInIronEdit_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "Temptrue") // 温度
            {
                frmBfIronTemp frm = new frmBfIronTemp();
                frm.Location = CStaticMethod.GetChildWindowLocation(frm.Size);
                frm.ob = this.ob;
                frm.ShowDialog();

                if (frm._strHeatProcessNo != "")
                {
                    ultragridInIronEdit.Rows[0].Cells["Temptrue"].Value = frm._strPTIronTemp;
                    ultragridInIronEdit.Rows[0].Cells["Temptrue"].Tag = frm._strHeatProcessNo;

                }

            }
        }

        /// <summary>
        /// 导出excel
        /// </summary>
        /// <param name="ultGrid"></param>
        /// <param name="strFileName"></param>
        public void ExportDataWithSaveDialog(ref Infragistics.Win.UltraWinGrid.UltraGrid ultGrid, string strFileName)
        {
            try
            {
                if (ultGrid.Rows.Count == 0) return;

                if (strFileName.Length == 0)
                    strFileName = "未命名";

                SaveFileDialog dlg = new SaveFileDialog();
                dlg.Title = "保存";
                dlg.OverwritePrompt = true;
                dlg.Filter = "Excel文件(*.xls)|*.xls";
                dlg.AddExtension = true;
                dlg.FileName = strFileName;
                if (dlg.ShowDialog() == DialogResult.OK)
                {
                    strFileName = dlg.FileName;

                    this.ultraGridExcelExporter1.Export(ultGrid, strFileName);


                    //2012-04-10何晓晴修改导出功能

                    if (MessageBox.Show("数据导出成功！\r\n需要打开所导出文件吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        ultraGridExcelExporter1.Export(ultGrid, strFileName);

                        ProcessStartInfo p = new ProcessStartInfo(strFileName);
                        p.WorkingDirectory = Path.GetDirectoryName(strFileName);
                        Process.Start(p);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }


    }

}