MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/外委实验管理/FrmOutdecChemDataManage.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    //临时标钢修约规则保存在BASE_CHEM_STDSTEEL_SELECT_TEMP表
    public partial class FrmOutdecChemDataManage : FrmBase
    {
        private string[] arrId;//数据权限
        private string[] plineCodes = { };

        //private OutdecCheckconsignDetailEntity checkDetal = new OutdecCheckconsignDetailEntity();

        public FrmOutdecChemDataManage()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            //ultraGrid2.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            //ultraGrid3.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid4.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            //ultraGrid5.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid5.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid6.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid6.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid8.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
            ///ultraGrid8.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            //ultraGrid9.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid9.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid10.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid10.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框

            //ultraGrid11.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid11.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;

            //ultraGrid12.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
            //ultraGrid12.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmOutdecChemDataManage_Load(object sender, EventArgs e)
        {
            //arrId = this.ValidDataPurviewIds;//获取数据权限
            arrId = new string[] { "002001007010" };//化学项目
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            InitColumns();
            //BindInitRow();

            publicDataCJBase1.visibleDampness();
            publicDataCJBase2.visibleDampness();
        }

        private void InitColumns()
        {
            outdecShowBase1.ChangeLabel();
            outdecShowBase2.ChangeLabel();

            publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
            publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);

            publicUltraGridBase1.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
            publicUltraGridBase2.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);

            string[] arrColumnsBase = new string[] { "CHEM_NAME", "SELECT_STEEL_NO", "STD_STEEL_STD_VALUE", "STD_STEEL_PROCESS_VALUE", "ROUND_VALUE", "PROCESS_VALUE", "AUDIT_VALUE", "QUOTE_VALUE" };
            string[] arrCaptionBase = new string[] { "元素", "选择标钢", "标钢标准值", "标钢实测值", "标钢修约值", "采集值", "处理值", "报出值" };
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable2);
            //PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, null, true);
            //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "AUDIT_VALUE", "STD_STEEL_PROCESS_VALUE", "QUOTE_VALUE" });

            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable4);
            //PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid4, null, true);
            //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid4, new string[] { "AUDIT_VALUE" });
        }

        void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            publicDataCJBase1.ClearAll();
            outdecShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);//获取显示区详细信息

           // QueryCheckConsignChemDetailInfo();//获取显示区化学详细信息

            string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
            string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

            ArrayList list = new ArrayList();
            list.Add(strSAMPLE_NO);
            list.Add(strCHECK_NO);
            //中间化学成分详细信息
            DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemDetail",new Object[] { list }, ob);
            GridHelper.CopyDataToDatatable( dt,  this.dataTable1, true);

            //设备信息
            ArrayList listDetail = new ArrayList();
            listDetail.Add(strSAMPLE_NO);
            listDetail.Add(strCHECK_NO);
            listDetail.Add("HX");
            DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemCheckConsignDetail",
new Object[] { listDetail }, ob);
            OutdecCheckconsignDetailEntity checkDetal = new OutdecCheckconsignDetailEntity();
            checkDetal.CheckName = dtDetail.Rows[0]["CHECK_NAME"].ToString();
            checkDetal.CheckTime = dtDetail.Rows[0]["CHECK_TIME"].ToString();
            checkDetal.CheckShift = dtDetail.Rows[0]["CHECK_SHIFT"].ToString();
            checkDetal.CheckClass = dtDetail.Rows[0]["CHECK_CLASS"].ToString();
            checkDetal.DeviceNo = dtDetail.Rows[0]["DEVICE_NO"].ToString();
            checkDetal.DeviceName = dtDetail.Rows[0]["DEVICE_NAME"].ToString();
            checkDetal.CheckTemp = dtDetail.Rows[0]["CHECK_TEMP"].ToString();
            checkDetal.Remark = dtDetail.Rows[0]["REMARK"].ToString();
            checkDetal.AuditName = dtDetail.Rows[0]["AUDIT_NAME"].ToString();
            checkDetal.AuditTime = dtDetail.Rows[0]["AUDIT_TIME"].ToString();
            checkDetal.CheckDampness = dtDetail.Rows[0]["CHECK_DAMPNESS"].ToString();

            publicDataCJBase2.UpdateDateForPrama(checkDetal);
        }

        void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            publicDataCJBase2.ClearAll();
            outdecShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);//获取显示区详细信息

            //QueryCheckConsignChemDetailInfo_LOG();//获取显示区化学详细信息
            string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
            string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();

            ArrayList list = new ArrayList();
            list.Add(strSAMPLE_NO);
            list.Add(strCHECK_NO);
            
            //中间化学成分详细信息
            DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemDetail", new Object[] { list }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable3, true);

            //设备信息
            ArrayList listDetail = new ArrayList();
            listDetail.Add(strSAMPLE_NO);
            listDetail.Add(strCHECK_NO);
            listDetail.Add("HX");
            DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemCheckConsignDetail",
new Object[] { listDetail }, ob);
            OutdecCheckconsignDetailEntity checkDetal = new OutdecCheckconsignDetailEntity();
            checkDetal.CheckName = dtDetail.Rows[0]["CHECK_NAME"].ToString();
            checkDetal.CheckTime = dtDetail.Rows[0]["CHECK_TIME"].ToString();
            checkDetal.CheckShift = dtDetail.Rows[0]["CHECK_SHIFT"].ToString();
            checkDetal.CheckClass = dtDetail.Rows[0]["CHECK_CLASS"].ToString();
            checkDetal.DeviceNo = dtDetail.Rows[0]["DEVICE_NO"].ToString();
            checkDetal.DeviceName = dtDetail.Rows[0]["DEVICE_NAME"].ToString();
            checkDetal.CheckTemp = dtDetail.Rows[0]["CHECK_TEMP"].ToString();
            checkDetal.Remark = dtDetail.Rows[0]["REMARK"].ToString();
            checkDetal.AuditName = dtDetail.Rows[0]["AUDIT_NAME"].ToString();
            checkDetal.AuditTime = dtDetail.Rows[0]["AUDIT_TIME"].ToString();
            checkDetal.CheckDampness = dtDetail.Rows[0]["CHECK_DAMPNESS"].ToString();

            publicDataCJBase2.UpdateDateForPrama(checkDetal);

        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //新增、修改修约值、审核、删除、退出
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QueryCheckConsignBase();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBase_LOG();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        RepLimsOutdecChemResultQuery();
                    }
                    break;
                case "Add":
                    AddChemAuditResult();
                    break;
                case "Update":
                    UpdateChemAuditResult();
                    break;
                case "Delete":
                    DeleteChemAuditResult();
                    break;
                case "Select_Temp":
                    QueryCheckConsignChemDetailInfo_Temp();
                    break;
                case "Check":
                    CheckIsValid();
                    break;
                case "Print":
                    RepLimsOutdecChemResultQuote();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        #region 未处理数据
        //查询检验委托加工信息
        /// <summary>
        /// 查询检验委托加工信息
        /// </summary>
        private void QueryCheckConsignBase()
        {
            try
            {
                ArrayList al = outdecQueryBase1.GetQueryInfo("2");
                //al.Insert(0, "2");
                publicUltraGridBase1.QueryCheckConsignBaseDetail_Distinct("outdec.FrmOutdecChemDataManage", al, this.ob, arrId, plineCodes);

                if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
                {
                    dataTable2.Rows.Clear();
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托化学明细信息
        /// <summary>
        /// 查询检验委托化学明细信息
        /// </summary>
        private void QueryCheckConsignChemDetailInfo_Temp()
        {
            try
            {
                dataTable2.Rows.Clear();

                //加入处理元素信息
                QueryCheckConsignDetail();

                //加入标钢实测值和标准值,需要判断标钢实测值与元素实测值的时间间距不超过限定时间否则无效

                QueryChemStdSteelInfo_Temp();

                //加入元素实测值
                QueryChemProcessResult();

                //加入元素标准值
                //QueryCheckConsignChemDetail();
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托化学明细信息
        /// <summary>
        /// 查询检验委托化学明细信息
        /// </summary>
        private void QueryCheckConsignChemDetailInfo()
        {
            try
            {
                dataTable2.Rows.Clear();

                //加入处理元素信息
                QueryCheckConsignDetail();

                //加入标钢实测值和标准值,需要判断标钢实测值与元素实测值的时间间距不超过限定时间否则无效

                QueryChemStdSteelInfo();

                //加入元素实测值
                QueryChemProcessResult();

                //加入元素标准值
                //QueryCheckConsignChemDetail();
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询处理元素信息
        /// <summary>
        /// 查询处理元素信息
        /// </summary>
        private void QueryCheckConsignDetail()
        {
            string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
            string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

            //加入处理元素信息
            ArrayList alElements = new ArrayList();
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strCHECK_NO);

            DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryCheckConsignChemDetail",
new Object[] { alElements }, ob);
            if (dtDetail == null || dtDetail.Rows.Count == 0)
            {
                return;
            }
            DataRow dr;
            DataRow[] arrDr;
            foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' '))
            {
                arrDr = dtDetail.Select("CHEM_NAME = '" + strChem + "'");
                if (arrDr.Length > 0)
                {
                    dr = dataTable2.NewRow();
                    dr["CHEM_NAME"] = strChem;
                    dr["AUDIT_VALUE"] = arrDr[0]["AUDIT_VALUE"];//C\S要赋值审核值、人工录入
                    dr["QUOTE_VALUE"] = arrDr[0]["AUDIT_VALUE"];
                    dataTable2.Rows.Add(dr);
                    //dr["AUDIT_PROCESS"]
                }
            }
            foreach (UltraGridRow ur in ultraGrid2.Rows)
            {
                if (ur.Cells["CHEM_NAME"].Text.Trim() == "C" || ur.Cells["CHEM_NAME"].Text.Trim() == "S")
                {
                    ur.Cells["AUDIT_VALUE"].Activation = Activation.AllowEdit;
                }
                else
                {
                    ur.Cells["AUDIT_VALUE"].Activation = Activation.ActivateOnly;
                }
            }
        }

        //查询标钢修约信息
        /// <summary>
        /// 查询标钢修约信息
        /// </summary>
        private void QueryChemStdSteelInfo()
        {
            string strSTEEL_NO = publicUltraGridBase1.Ur.Cells["STEEL_GRADE_NO"].Text.Trim();

            //加入标钢信息
            ArrayList alElements = new ArrayList();
            alElements.Add(strSTEEL_NO);
            DataTable dtStdSteel = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemStdSteelInfo",
new Object[] { alElements }, ob);
            if (dtStdSteel == null || dtStdSteel.Rows.Count == 0)
            {
                return;
            }
            string strPro;
            string strStd;
            foreach (DataRow dr in dataTable2.Rows)
            {
                foreach (DataRow drStd in dtStdSteel.Rows)
                {
                    //&& drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1"
                    if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1")
                    {
                        //如果没有修约规则但是有实测值要显示出来
                        dr["SELECT_STEEL_NO"] = drStd["SELECT_STEEL_NO"].ToString();

                        strStd = drStd["STD_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢标准值

                        strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值

                        try
                        {
                            dr["STD_STEEL_STD_VALUE"] = strStd;
                            dr["STD_STEEL_PROCESS_VALUE"] = strPro;

                            decimal pro = Convert.ToDecimal(strPro != "" ? strPro : "0");
                            decimal std = Convert.ToDecimal(strStd != "" ? strStd : "0");
                            if (std == 0 && pro == 0)
                            {
                                dr["ROUND_VALUE"] = "";
                            }
                            else
                            {
                                dr["ROUND_VALUE"] = std - pro;
                            }
                        }
                        catch
                        {
                            break;
                        }
                        break;
                    }
                    else if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "0")
                    {
                        strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值
                        dr["STD_STEEL_PROCESS_VALUE"] = strPro;
                        dr["ROUND_VALUE"] = "";
                    }
                }
            }
        }

        //查询标钢修约信息
        /// <summary>
        /// 查询标钢修约信息
        /// </summary>
        private void QueryChemStdSteelInfo_Temp()
        {
            string strSTEEL_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

            //加入标钢信息
            ArrayList alElements = new ArrayList();
            alElements.Add(strSTEEL_NO);
            DataTable dtStdSteel = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemStdSteelInfo_Temp",
new Object[] { alElements }, ob);
            if (dtStdSteel == null || dtStdSteel.Rows.Count == 0)
            {
                return;
            }
            string strPro;
            string strStd;
            foreach (DataRow dr in dataTable2.Rows)
            {
                foreach (DataRow drStd in dtStdSteel.Rows)
                {
                    if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1")
                    {
                        dr["SELECT_STEEL_NO"] = drStd["SELECT_STEEL_NO"].ToString();

                        strStd = drStd["STD_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢标准值

                        strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值

                        try
                        {
                            dr["STD_STEEL_STD_VALUE"] = strStd;
                            dr["STD_STEEL_PROCESS_VALUE"] = strPro;

                            decimal pro = Convert.ToDecimal(strPro != "" ? strPro : "0");
                            decimal std = Convert.ToDecimal(strStd != "" ? strStd : "0");
                            if (std == 0 && pro == 0)
                            {
                                dr["ROUND_VALUE"] = "";
                            }
                            else
                            {
                                dr["ROUND_VALUE"] = std - pro;
                            }
                        }
                        catch
                        {
                            break;
                        }
                        break;
                    }
                }
            }
        }

        //查询化学实测值
        /// <summary>
        /// 查询化学实测值
        /// </summary>
        private void QueryChemProcessResult()
        {
            //加入元素实测值
            string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
            string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

            ArrayList alElements = new ArrayList();
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strSAMPLE_NO);
            alElements.Add(strCHECK_NO);

            DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemProcessResult",
new Object[] { alElements }, ob);
            if (dtDetail == null || dtDetail.Rows.Count == 0)
            {
                return;
            }
            foreach (DataRow dr in dataTable2.Rows)
            {
                foreach (DataRow drDetail in dtDetail.Rows)
                {
                    if (dtDetail.Columns.Contains("ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true)
                    {
                        try
                        {
                            decimal round = Convert.ToDecimal(dr["ROUND_VALUE"].ToString() != "" ? dr["ROUND_VALUE"].ToString() : "0");//标钢修约值

                            string strPro = drDetail["ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();
                            decimal process = Convert.ToDecimal(strPro != "" ? strPro : "0");//过程值

                            dr["PROCESS_VALUE"] = strPro;//加入采集值

                            if (dr["CHEM_NAME"].ToString() != "C" && dr["CHEM_NAME"].ToString() != "S")//CS结果从CS录入界面传过来
                            {
                                if (strPro == "")//采集值为空， 处理值也为空
                                {
                                    dr["AUDIT_VALUE"] = "";
                                    dr["QUOTE_VALUE"] = "";
                                }
                                else
                                {
                                    //if (dr["CHEM_NAME"].ToString() == "C" || dr["CHEM_NAME"].ToString() == "S")
                                    //{
                                    //    dr["AUDIT_VALUE"] = strPro;
                                    //    dr["QUOTE_VALUE"] = strPro;
                                    //}
                                    //else
                                    //{
                                    dr["AUDIT_VALUE"] = round + process;
                                    dr["QUOTE_VALUE"] = round + process;
                                    //}
                                }
                            }
                            else
                            {
                                if (dr["AUDIT_VALUE"].ToString() == "")
                                {
                                    dr["AUDIT_VALUE"] = strPro;
                                    dr["QUOTE_VALUE"] = strPro;
                                }
                            }
                        }
                        catch
                        {
                            //continue;
                        }
                    }
                    break;
                }
            }
        }

        //查询化学标准值
        /// <summary>
        /// 查询化学标准值
        /// </summary>
        private void QueryCheckConsignChemDetail()
        {

        }

        //检查是否有效
        /// <summary>
        /// 检查是否有效
        /// </summary>
        private void CheckIsValid()
        {
            try
            {
                //检查修约规则

                //先判断是否选择了标钢
                ultraGrid2.UpdateData();
                foreach (DataRow dr in dataTable1.Rows)
                {
                    if (dr["CHEM_NAME"].ToString() != "C" && dr["CHEM_NAME"].ToString() != "S")
                    {
                        if (dr["SELECT_STEEL_NO"].ToString() == "")
                        {
                            MessageUtil.ShowTips(dr["CHEM_NAME"].ToString() + "没有对应的修约规则！");
                            return;
                        }
                        if (dr["STD_STEEL_STD_VALUE"].ToString() == "")
                        {
                            MessageUtil.ShowTips("标钢" + dr["SELECT_STEEL_NO"].ToString() + "的元素" + dr["CHEM_NAME"].ToString() + "没有维护标准值！");
                            return;
                        }
                    }

                    if (double.Parse(dr["STD_STEEL_STD_VALUE"].ToString3()) - double.Parse(dr["STD_STEEL_PROCESS_VALUE"].ToString3()) != double.Parse(dr["ROUND_VALUE"].ToString3()))
                    {
                        MessageUtil.ShowTips( dr["CHEM_NAME"].ToString() + "元素的标钢实测值有问题");
                        return;
                    }

                    if (double.Parse(dr["QUOTE_VALUE"].ToString3()) - double.Parse(dr["PROCESS_VALUE"].ToString3()) != double.Parse(dr["ROUND_VALUE"].ToString3()))
                    {
                        MessageUtil.ShowTips(dr["CHEM_NAME"].ToString() + "元素的报出值有问题");
                        return;
                    }
                }
            }
            catch
            {

            }
        }

        //保存审核结果
        /// <summary>
        /// 保存审核结果
        /// </summary>
        private void AddChemAuditResult()
        {
            try
            {
                if (dataTable1 == null || dataTable1.Rows.Count == 0)
                {
                    return;
                }
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowWarning("只有在未处理数据页才能进行新增操作！");
                    return;
                }
                if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要新增的试样信息！");
                    return;
                }
                //string strAddChem = CheckIsValid();
                //if (strAddChem != "")
                //{
                //    MessageUtil.ShowWarning(strAddChem);
                //    return;
                //}

                //先判断状态位
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                    string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
                    string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();//检验信息详细表list 
                    ArrayList alDetailParams = new ArrayList();//检验信息详细表list
                    alDetailParams.Add(publicDataCJBase1.StrTemp);
                    alDetailParams.Add(publicDataCJBase1.StrCheckDampness);
                    alDetailParams.Add(publicDataCJBase1.StrDevice_No);
                    alDetailParams.Add(publicDataCJBase1.StrDevice_Name);
                    alDetailParams.Add(publicDataCJBase1.StrRemark);
                    alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);//班次
                    alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
                    alDetailParams.Add(publicDataCJBase1.StrTime == "" ? strTime : publicDataCJBase1.StrTime);//录入时间
                    alDetailParams.Add(publicDataCJBase1.StrAuditName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrAuditName);//审核人
                    alDetailParams.Add(publicDataCJBase1.StrAuditTime == "" ? strTime : publicDataCJBase1.StrAuditTime);//审核时间

                    alDetailParams.Add("4");//录入标志位改为审核标志位
                    alDetailParams.Add("2");
                    alDetailParams.Add("HX");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    ArrayList alProcessResult = new ArrayList();//化学信息list
                    ArrayList alProcessResultParams = new ArrayList();//化学信息list
                    ultraGrid2.UpdateData();
                    foreach (DataRow dr in dataTable1.Rows)
                    {
                        alProcessResultParams = new ArrayList();
                        alProcessResultParams.Add(dr["SELECT_STEEL_NO"].ToString());
                        alProcessResultParams.Add(dr["STD_STEEL_STD_VALUE"].ToString());
                        alProcessResultParams.Add(dr["STD_STEEL_PROCESS_VALUE"].ToString());
                        alProcessResultParams.Add(dr["ROUND_VALUE"].ToString());
                        alProcessResultParams.Add(dr["PROCESS_VALUE"].ToString());
                        //alProcessResultParams.Add(dr["AUDIT_VALUE"].ToString());
                        alProcessResultParams.Add(dr["QUOTE_VALUE"].ToString());
                        alProcessResultParams.Add(dr["TECHNICAL_STANDARD"].ToString()); //技术标准
                        
                        alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
                        alProcessResultParams.Add(strSAMPLE_NO);
                        alProcessResultParams.Add(strCHECK_NO);
                        alProcessResult.Add(alProcessResultParams);
                    }

                    alAll.Add(alDetail);
                    alAll.Add(alProcessResult);

                    PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.AddChemAuditResult",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase();

                    QueryCheckConsignBase_LOG();

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        private void btnSelect_Temp_Click(object sender, EventArgs e)
        {
            if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
            {
                MessageUtil.ShowWarning("请选择需要选择临时标钢修约规则的试样信息！");
                return;
            }
            WinBaseChemStdSteelSelect_Temp pc = new WinBaseChemStdSteelSelect_Temp(this.ob);
            pc.StrCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
            pc.StrSAMPLE_NAME = publicUltraGridBase1.Ur.Cells["SAMPLE_NAME"].Text.Trim();
            pc.StrSTEEL_NO = publicUltraGridBase1.Ur.Cells["STEEL_GRADE_NO"].Text.Trim();
            pc.ShowDialog();
        }
        #endregion

        #region 已处理数据
        //查询检验委托加工信息
        /// <summary>
        /// 查询检验委托加工信息
        /// </summary>
        private void QueryCheckConsignBase_LOG()
        {
            try
            {
                ArrayList al = outdecQueryBase1.GetQueryInfo("345");
                publicUltraGridBase2.QueryCheckConsignBaseDetail_Distinct("outdec.FrmOutdecChemDataManage", al, this.ob, arrId, plineCodes);

                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
                {
                    dataTable4.Rows.Clear();
                }

            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托化学明细信息
        /// <summary>
        /// 查询检验委托化学明细信息
        /// </summary>
        private void QueryCheckConsignChemDetailInfo_LOG()
        {
            try
            {
                dataTable4.Rows.Clear();
                //加入元素实测值
                string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();

                ArrayList alElements = new ArrayList();
                alElements.Add(strSAMPLE_NO);
                alElements.Add(strSAMPLE_NO);
                alElements.Add(strSAMPLE_NO);
                alElements.Add(strCHECK_NO);

                DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryCheckConsignChemDetail",
    new Object[] { alElements }, ob);
                if (dtDetail == null || dtDetail.Rows.Count == 0)
                {
                    return;
                }
                //DataRow dr;
                DataRow[] arrDr;
                foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' '))
                {
                    arrDr = dtDetail.Select("CHEM_NAME = '" + strChem + "'");
                    if (arrDr != null && arrDr.Length == 1)
                    {
                        //dr = dataTable4.NewRow();
                        dataTable4.ImportRow(arrDr[0]);
                    }
                }
                foreach (UltraGridRow ur in ultraGrid4.Rows)
                {
                    if (ur.Cells["CHEM_NAME"].Text.Trim() == "C" || ur.Cells["CHEM_NAME"].Text.Trim() == "S")
                    {
                        ur.Cells["AUDIT_VALUE"].Activation = Activation.AllowEdit;
                    }
                    else
                    {
                        ur.Cells["AUDIT_VALUE"].Activation = Activation.ActivateOnly;
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //修改结果
        /// <summary>
        /// 修改结果
        /// </summary>
        private void UpdateChemAuditResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有在已处理数据页才能进行修改操作！");
                    return;
                }
                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要修改的试样信息！");
                    return;
                }
                if (dataTable3 == null || dataTable3.Rows.Count == 0)
                {
                    return;
                }
                //先修改状态位

                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                    string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
                    string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();

                    ArrayList alIs = new ArrayList();
                    alIs.Add(strSAMPLE_NO);
                    alIs.Add(strCHECK_NO);

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();//检验信息详细表list 
                    ArrayList alDetailParams = new ArrayList();//检验信息详细表list
                    //修改基础信息
                    alDetailParams.Add(publicDataCJBase2.StrTemp);
                    alDetailParams.Add(publicDataCJBase2.StrCheckDampness);
                    alDetailParams.Add(publicDataCJBase2.StrDevice_No);
                    alDetailParams.Add(publicDataCJBase2.StrDevice_Name);
                    alDetailParams.Add(publicDataCJBase2.StrRemark);
                    alDetailParams.Add(publicDataCJBase2.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase2.StrShift);//班次
                    alDetailParams.Add(publicDataCJBase2.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase2.StrClass);//班组
                    alDetailParams.Add(publicDataCJBase2.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase2.StrName);//录入人
                    alDetailParams.Add(publicDataCJBase2.StrTime == "" ? strTime : publicDataCJBase2.StrTime);//录入时间
                    alDetailParams.Add(publicDataCJBase2.StrAuditName == "" ? UserInfo.GetUserName() : publicDataCJBase2.StrAuditName);//审核人
                    alDetailParams.Add(publicDataCJBase2.StrAuditTime == "" ? strTime : publicDataCJBase2.StrAuditTime);//审核时间
                    alDetailParams.Add("4");//录入标志位改为审核标志位
                    alDetailParams.Add("4");
                    alDetailParams.Add("HX");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    ArrayList alProcessResult = new ArrayList();//化学信息list
                    ArrayList alProcessResultParams = new ArrayList();//化学信息list
                    ultraGrid4.UpdateData();
                    foreach (DataRow dr in dataTable3.Rows)
                    {
                        alProcessResultParams = new ArrayList();
                        alProcessResultParams.Add(dr["SELECT_STEEL_NO"].ToString());
                        alProcessResultParams.Add(dr["STD_STEEL_STD_VALUE"].ToString());
                        alProcessResultParams.Add(dr["STD_STEEL_PROCESS_VALUE"].ToString());
                        alProcessResultParams.Add(dr["ROUND_VALUE"].ToString());
                        alProcessResultParams.Add(dr["PROCESS_VALUE"].ToString());
                        //alProcessResultParams.Add(dr["AUDIT_VALUE"].ToString());
                        alProcessResultParams.Add(dr["QUOTE_VALUE"].ToString());
                        alProcessResultParams.Add(dr["TECHNICAL_STANDARD"].ToString()); //技术标准
                        alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
                        alProcessResultParams.Add(strSAMPLE_NO);
                        alProcessResultParams.Add(strCHECK_NO);
                        alProcessResult.Add(alProcessResultParams);

                    }

                    alAll.Add(alDetail);
                    alAll.Add(alProcessResult);

                    PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.UpdateChemAuditResult",
                new Object[] { alIs, alAll }, this.ob);

                    QueryCheckConsignBase_LOG();
                    //QueryCheckConsignBase();

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

                    MessageUtil.ShowTips("修改成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        //删除结果
        /// <summary>
        /// 删除结果
        /// </summary>
        private void DeleteChemAuditResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有在已处理数据页才能进行删除操作！");
                    return;
                }
                if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
                {
                    MessageUtil.ShowWarning("请选择需要删除的试样信息！");
                    return;
                }
                if (dataTable3 == null || dataTable3.Rows.Count == 0)
                {
                    return;
                }
                //先修改状态位

                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    //string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                    string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
                    string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
                    ArrayList alIs = new ArrayList();
                    alIs.Add(strSAMPLE_NO);
                    alIs.Add(strCHECK_NO);

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();//检验信息详细表list 
                    ArrayList alDetailParams = new ArrayList();//检验信息详细表list
                    //删除基础信息都置为空
                    alDetailParams.Add("");
                    alDetailParams.Add("");
                    alDetailParams.Add("");
                    alDetailParams.Add("");
                    alDetailParams.Add("");
                    alDetailParams.Add("");
                    alDetailParams.Add("");//班组
                    alDetailParams.Add("");//录入人
                    alDetailParams.Add("");//录入时间
                    alDetailParams.Add("");//审核人
                    alDetailParams.Add("");//审核时间
                    alDetailParams.Add("2");//录入标志位 
                    alDetailParams.Add("4");
                    alDetailParams.Add("HX");
                    alDetailParams.Add(strSAMPLE_NO);
                    alDetailParams.Add(strCHECK_NO);
                    alDetail.Add(alDetailParams);

                    ArrayList alProcessResult = new ArrayList();//化学信息list
                    ArrayList alProcessResultParams = new ArrayList();//化学信息list
                    ultraGrid4.UpdateData();
                    foreach (DataRow dr in dataTable3.Rows)
                    {
                        alProcessResultParams = new ArrayList();
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add("");
                        alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
                        alProcessResultParams.Add(strSAMPLE_NO);
                        alProcessResultParams.Add(strCHECK_NO);
                        alProcessResult.Add(alProcessResultParams);
                    }

                    alAll.Add(alDetail);
                    alAll.Add(alProcessResult);

                    PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.DeleteChemAuditResult",
                new Object[] { alIs, alAll }, this.ob);

                    QueryCheckConsignBase_LOG();
                    QueryCheckConsignBase();

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });

                    MessageUtil.ShowTips("删除成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
            }
        }

        #endregion

        private void RepLimsOutdecChemResultQuery()
        {
            try
            {
                ArrayList arrayList = outdecQueryBase1.GetQueryInfo();

                string strurl = "";
                //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
                //{
                //    strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepLimsOutdecChemResultQuery.cpt&bypagesize=false" + "&START_DATE=" + arrayList[0].ToString() + "&END_DATE=" + arrayList[1].ToString() + "&STEEL_GRADE_NO=" + arrayList[2].ToString() + "&SAMPLE_NAME=" + arrayList[5].ToString() + "&CHECK_NO=" + arrayList[8].ToString();

                //}
                //else
                //{
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsOutdecChemResultQuery.cpt&bypagesize=false" + "&START_DATE=" + arrayList[0].ToString() + "&END_DATE=" + arrayList[1].ToString() + "&STEEL_GRADE_NO=" + arrayList[2].ToString() + "&SAMPLE_NAME=" + arrayList[5].ToString() + "&CHECK_NO=" + arrayList[8].ToString();
                //}
                webBrowser1.Url = new Uri(strurl);
                this.webBrowser1.ScriptErrorsSuppressed = true;//屏蔽脚本错误
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        /// <summary>
        /// 打印
        /// </summary>
        private void RepLimsOutdecChemResultQuote()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowTips("只有选择了已处理数据页才能进行打印操作！");
                    return;
                }
                this.Cursor = Cursors.WaitCursor;
                UltraGridRow ugr = publicUltraGridBase2.Ur;
                if (ugr == null)
                {
                    MessageUtil.ShowWarning("请选择您要打印的报告单！");
                    return;
                }
                string strCHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();

                string strurl = "";
                
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsOutdecChemResult.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;
                FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
                fBug.AutoSize = true;
                fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fBug.WindowState = FormWindowState.Maximized;
                fBug.Text = "化学成分报告单";
                fBug.Show();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void FrmOutdecChemDataManage_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
                {
                    toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
                {
                    toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Check"))
                {
                    toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }

        private void ultraGrid2_ClickCellButton(object sender, CellEventArgs e)
        {
            this.ultraGrid2.UpdateData();
            if (e.Cell.Column.Key == "SELECT_STEEL_NO")
            {
                string ename = e.Cell.Row.Cells["CHEM_NAME"].Value.ToString();
                FrmChemStdSteelDialog orderZg = new FrmChemStdSteelDialog(ename,this.ob);
                orderZg.ShowDialog();
                BaseChemStdsteelInfoEntity slmEntity = orderZg.SlmEntity;
                if (slmEntity == null)
                {
                    return;
                }
                e.Cell.Row.Cells["SELECT_STEEL_NO"].Value = slmEntity.SampleNo;
                e.Cell.Row.Cells["STD_STEEL_STD_VALUE"].Value = slmEntity.Evalue;
            }
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            this.ultraGrid2.UpdateData();
            if (e.Cell.Column.Key == "STD_STEEL_PROCESS_VALUE")  //实测值
            {
                if (!e.Cell.Row.Cells["STD_STEEL_PROCESS_VALUE"].Value.ToString().Equals(""))
                {
                    //修约值 = 标准值 - 实测值
                    e.Cell.Row.Cells["ROUND_VALUE"].Value = Math.Round(double.Parse(e.Cell.Row.Cells["STD_STEEL_STD_VALUE"].Value.ToString3()) - double.Parse(e.Cell.Row.Cells["STD_STEEL_PROCESS_VALUE"].Value.ToString3()),3);
                }
                
            }

            if (e.Cell.Column.Key == "PROCESS_VALUE")  //采集值
            {
                if (!e.Cell.Row.Cells["ROUND_VALUE"].Value.ToString().Equals(""))
                {
                    //报出值 =  采集值  + 修约值
                    e.Cell.Row.Cells["QUOTE_VALUE"].Value = Math.Round(double.Parse(e.Cell.Row.Cells["PROCESS_VALUE"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["ROUND_VALUE"].Value.ToString3()), 3);
                }
                
            }
        }

        private void ultraGrid4_ClickCellButton(object sender, CellEventArgs e)
        {
            this.ultraGrid4.UpdateData();
            if (e.Cell.Column.Key == "SELECT_STEEL_NO")
            {
                string ename = e.Cell.Row.Cells["CHEM_NAME"].Value.ToString();
                FrmChemStdSteelDialog orderZg = new FrmChemStdSteelDialog(ename, this.ob);
                orderZg.ShowDialog();
                BaseChemStdsteelInfoEntity slmEntity = orderZg.SlmEntity;
                if (slmEntity == null)
                {
                    return;
                }
                e.Cell.Row.Cells["SELECT_STEEL_NO"].Value = slmEntity.SampleNo;
                e.Cell.Row.Cells["STD_STEEL_STD_VALUE"].Value = slmEntity.Evalue;
            }
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            this.ultraGrid4.UpdateData();
            if (e.Cell.Column.Key == "STD_STEEL_PROCESS_VALUE")  //实测值
            {
                if (!e.Cell.Row.Cells["STD_STEEL_PROCESS_VALUE"].Value.ToString().Equals(""))
                {
                    //修约值 = 标准值 - 实测值
                    e.Cell.Row.Cells["ROUND_VALUE"].Value = Math.Round(double.Parse(e.Cell.Row.Cells["STD_STEEL_STD_VALUE"].Value.ToString3()) - double.Parse(e.Cell.Row.Cells["STD_STEEL_PROCESS_VALUE"].Value.ToString3()),3);
                }
               
            }

            if (e.Cell.Column.Key == "PROCESS_VALUE")  //采集值
            {
                if (!e.Cell.Row.Cells["ROUND_VALUE"].Value.ToString().Equals(""))
                {
                    //报出值 =  采集值  + 修约值
                    e.Cell.Row.Cells["QUOTE_VALUE"].Value = Math.Round(double.Parse(e.Cell.Row.Cells["PROCESS_VALUE"].Value.ToString3()) + double.Parse(e.Cell.Row.Cells["ROUND_VALUE"].Value.ToString3()),3);
                }
                
            }
        }
    }
}