MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmChemONHDataManage.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 System.Collections;
using Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using System.Net;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.钢管实验管理;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmChemONHDataManage : FrmBase
    {
        public FrmChemONHDataManage()
        {
            InitializeComponent();
        }

        private string[] arrId;//数据权限
        private string[] arrId2;//数据权限
        private string[] plineCodes = { };
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            publicUltraGridBase1.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;

            publicUltraGridBase2.Ug.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;
        }

        private void FrmChemONHDataManage_Load(object sender, EventArgs e)
        {
            arrId2 = new string[] { "002001007010", "002023003001" };//化学
            arrId = this.ValidDataPurviewIds;
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            //pipeQueryBase1.visbleCom();
            pipeQueryBase1.UpdateControl("收样时间");
            pipeQueryBase1.ShowControlSampleNo();
            InitColumns();

        }

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

            string[] arrColumnsBase = new string[] { "CHECK_NO", "SAMPLE_NO", "FLAG_SH", "HEAT_NO", "STOVE_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "ISPRODUCER_DESC", "SPEC_REQ", "FLAG", "FLAG_DESC", "REMARK", "PIPE_SIZE", "CRAFT_FILE_NO", "CRAFT_PATH", "PROCESS_STATUS", "CHECK_COUNT", "SUPPLY_UNIT" };
            string[] arrCaptionBase = new string[] { "检验编号", "样管号", "审核状态", "炉号", "熔炼炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "是否监制", "特殊要求", "标志位", "标志位", "备注", "规格", "工艺文件号", "工艺文件路径", "工艺状态", "样管个数", "制造商" };
            publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", "STOVE_NO" }, true);
            publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列

            publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
            publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", "FLAG_SH" }, true);
            publicUltraGridBase2.setOtherColumnReadOnly(null);//可编辑列

            string[] arrColumns = new string[] { "SAMPLE_NO", "ANA_O", "ANA_N", "ANA_H", "ANA_Al", "ANA_AlN", "STDMIN_O", "STDMIN_N", "STDMIN_H", "STDMAX_O", "STDMAX_N", "STDMAX_H" };
            string[] arrCaption = new string[] { "样管号", "O", "N", "H", "Al", "AlN", "O标准范围下限", "N标准范围下限", "H标准范围下限", "O标准范围上限", "N标准范围上限", "H标准范围上限" };

            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable2);
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "ANA_O", "ANA_N", "ANA_H" });

            PublicPipeAndOutdec.InitColumns(arrColumns, arrCaption, dataTable5);
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid5, new string[] { "ANA_O", "ANA_N", "ANA_H" });

            //加载试验设备
            DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.initCheckEquipment", new object[] { arrId }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ultraONH_DEVICE_NAME.DataSource = dt;
                ultraONH_DEVICE_NAME.ValueMember = "DEVICE_NO";
                ultraONH_DEVICE_NAME.DisplayMember = "DEVICE_NAME";

                ultraONH_DEVICE_NO.DataSource = dt;
                ultraONH_DEVICE_NO.ValueMember = "DEVICE_NO";
                ultraONH_DEVICE_NO.DisplayMember = "DEVICE_NO";
            }

            //加载试验方法
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.initCheckMethod", new object[] { arrId }, ob);
            if (ds != null && ds.Rows.Count > 0)
            {
                cmbChemMethodName.DataSource = ds;
                cmbChemMethodName.ValueMember = "CHECK_METHOD_NO";
            }

            
            //加载试验人、审核人
            DataTable userDt = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.doQueryUser", new object[] { arrId, arrId2 }, ob);
            if (userDt != null && userDt.Rows.Count > 0)
            {
                ultraONH_CHECK_NAME.DataSource = userDt;
                ultraONH_CHECK_NAME.ValueMember = "USERID";

                ultraAUDIT_NAME.DataSource = userDt;
                ultraAUDIT_NAME.ValueMember = "USERID";
            }

            //加载设备运行记录受控编号
            DataTable lxDt = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.initMeeting", new Object[] { "10012402%" }, ob);
            if (lxDt.Rows.Count > 0 && lxDt != null)
            {
                ultraLabelYX.Text = "设备运行记录：" + lxDt.Rows[0][0].ToString();
            }

            //加载交接班记录受控编号
            DataTable jjDt = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.initMeeting", new Object[] { "100126%" }, ob);
            if (jjDt.Rows.Count > 0 && jjDt != null)
            {
                ultraLabelJJ.Text = "交接班记录：" + jjDt.Rows[0][0].ToString();
            }
        }

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

            QueryCheckConsignDetail();
            doQueryLgChem(publicUltraGridBase1.Ur);//查询熔炼成分信息

            string diveName = "";//试样采集设备
            DataTable dsDiveName = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemONHDataManage.doQueryDiveName", new object[] { publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim() }, ob);
            if (dsDiveName.Rows.Count > 0)
            {
                diveName = dsDiveName.Rows[0][0].ToString();
            }

            this.txtSamDiveName.Text = diveName;
        }

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

            QueryChemONHAuditResult();

            string diveName = "";//试样采集设备
            DataTable dsDiveName = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemONHDataManage.doQueryDiveName", new object[] { publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim() }, ob);
            if (dsDiveName.Rows.Count > 0)
            {
                diveName = dsDiveName.Rows[0][0].ToString();
            }

            this.txtSamDiveName_LOG.Text = diveName;
        }

        /// <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)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "345");
                    }
                    break;
                case "Add":
                    AddChemONHAuditResult();
                    break;
                case "Update":
                    UpdateChemONHAuditResult();
                    break;
                case "Delete":
                    DeleteChemONHAuditResult();
                    break;
                case "Audit":
                    AuditData();
                    break;
                case "CancelAudit":
                    cancelAudit();
                    break;
                case "Print":
                    RepLimsPipeChemONHResult();
                    break;
                case "UpFile":
                    UpFile();
                    break;
                case "Export":
                    ExportData();
                    break;
                case "StdSteelNo":
                    doStdSteelNo();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        /// <summary>
        /// 标钢信息
        /// </summary>
        private void doStdSteelNo()
        {
            this.publicUltraGridBase2.Ug.UpdateData();
            UltraGridRow uRow = this.publicUltraGridBase2.Ug.ActiveRow;
            if (uRow == null) return;

            FrmChemDataManageNewSon labDateParm = new FrmChemDataManageNewSon(uRow.Cells["CHECK_NO"].Text.Trim(),"ONH", this.ob);
            labDateParm.ShowDialog();
        }

        /// <summary>
        /// 审核
        /// </summary>
        private void AuditData()
        {
            publicUltraGridBase2.Ug.UpdateData();
            UltraGridRow uRow = this.publicUltraGridBase2.Ug.ActiveRow;
            if (uRow == null) return;
            string checkNo = uRow.Cells["CHECK_NO"].Text.ToString();
            //string isProducer = uRow.Cells["ISPRODUCER"].Text.ToString();
            //if (isProducer == "1")
            //{
            //    if (MessageUtil.ShowYesNoAndQuestion("有监制，是否打印？") == DialogResult.Yes)
            //    {
            //        RepLimsPipeChemONHResult();
            //    }
            //}
            
            float OMin = 0.00f;
            float OMax = 0.00f;
            float NMin = 0.00f;
            float NMax = 0.00f;
            float HMin = 0.00f;
            float HMax = 0.00f;
            foreach (DataRow dr in dataTable5.Rows)
            {
                OMin = float.Parse(dr["STDMIN_O"].ToString3());
                OMax = float.Parse(dr["STDMAX_O"].ToString3());
                NMin = float.Parse(dr["STDMIN_N"].ToString3());
                NMax = float.Parse(dr["STDMAX_N"].ToString3());
                HMin = float.Parse(dr["STDMIN_H"].ToString3());
                HMax = float.Parse(dr["STDMAX_H"].ToString3());

                if (OMin > 0 && float.Parse(dr["ANA_O"].ToString3()) < OMin)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("O元素低于标准范围下限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
                if (OMax > 0 && float.Parse(dr["ANA_O"].ToString3()) > OMax)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("O元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
                if (NMin > 0 && float.Parse(dr["ANA_N"].ToString3()) < NMin)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("N元素低于标准范围下限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
                if (NMax > 0 && float.Parse(dr["ANA_N"].ToString3()) > NMax)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("N元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
                if (HMin > 0 && float.Parse(dr["ANA_H"].ToString3()) < HMin)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("H元素低于标准范围下限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
                if (HMax > 0 && float.Parse(dr["ANA_H"].ToString3()) > HMax)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("H元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                    {
                        return;
                    }
                }
            }

            PublicServer.SetData("com.steering.lims.data.pipe.FrmChemONHDataManage.auditResult",
                new Object[] { checkNo,this.UserInfo.GetUserName() }, this.ob);
            MessageUtil.ShowTips("审核成功!");
            UpFile(checkNo);
            QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "34");
        }

        /// <summary>
        /// 取消审核
        /// </summary>
        private void cancelAudit()
        {
            publicUltraGridBase2.Ug.UpdateData();
            UltraGridRow uRow = this.publicUltraGridBase2.Ug.ActiveRow;
            if (uRow == null) return;
            string checkNo = uRow.Cells["CHECK_NO"].Text.ToString();


            PublicServer.SetData("com.steering.lims.data.pipe.FrmChemONHDataManage.cancelAuditResult",
                new Object[] { checkNo }, this.ob);
            MessageUtil.ShowTips("取消审核成功!");
            
            QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "34");
        }

        //查询检验委托加工信息
        /// <summary>
        /// 查询检验委托加工信息
        /// </summary>
        /// <param name="publicUltraGridBase"></param>
        /// <param name="strFlag"></param>
        private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
        {
            try
            {
                ArrayList al = pipeQueryBase1.GetQueryInfo(strFlag);

                publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("pipe.FrmChemONHDataManage", al, this.ob, this.ValidDataPurviewIds != null ? this.ValidDataPurviewIds : new string[] { UserInfo.GetDeptid() }, plineCodes);

                if (publicUltraGridBase.Ur == null || publicUltraGridBase.Ur.Activated == false)
                {
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        dataTable2.Rows.Clear();
                    }
                    else
                    {
                        dataTable5.Rows.Clear();
                        txtONH_CHECK_TEMP_LOG.Text = "";
                        ultraONH_DEVICE_NO_LOG.Text = "";
                        ultraONH_DEVICE_NAME_LOG.Text = "";
                        ultraONH_CHECK_NAME_LOG.Text = "";
                        ultraONH_CHECK_SHIFT_LOG.Text = "";
                        ultraONH_CHECK_CLASS_LOG.Text = "";
                        txtREMARK_LOG.Text = "";
                        cmbContent1.Text = "";
                        txtCHECK_HUMIDITY_LOG.Text = "";
                        ultraCHECK_TIME_LOG.Text = "";
                        ultraAUDIT_TIME_LOG.Text = "";
                        txtSamDiveName_LOG.Text = "";
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询检验委托明细信息
        /// <summary>
        /// 查询检验委托明细信息
        /// </summary>
        private void QueryCheckConsignDetail()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                //arrayList.Add("");QueryCheckConsignDetail
                arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());
                arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());
                arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemONHDataManage.QueryCheckConsignChemDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    return;
                }

                ShowColumns(dt, dataTable2, ultraGrid2);

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

        private void ShowColumns(DataTable dt, DataTable dataTable, UltraGrid ultraGrid)
        {
            dataTable.Rows.Clear();//清除行

            string row = "";//存放所有样管号判断是否有重复样管号

            DataRow newDr = dataTable.NewRow();
            foreach (DataRow dr in dt.Rows)
            {
                if (row.IndexOf(dr["SAMPLE_NO"].ToString()) < 0)//判断是否有重复样管号,没有则增加行
                {
                    row += dr["SAMPLE_NO"].ToString() + " ";
                    newDr = dataTable.NewRow();
                    newDr["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();

                    if (dr["CHEM_NAME"].ToString() == "O")
                    {
                        newDr["ANA_O"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_O"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_O"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "N")
                    {
                        newDr["ANA_N"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_N"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_N"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "H")
                    {
                        newDr["ANA_H"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_H"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_H"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "Al")
                    {
                        newDr["ANA_Al"] = dr["QUOTE_VALUE"].ToString();
                    }
                    dataTable.Rows.Add(newDr);
                }
                else
                {
                    if (dr["CHEM_NAME"].ToString() == "O")
                    {
                        newDr["ANA_O"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_O"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_O"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "N")
                    {
                        newDr["ANA_N"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_N"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_N"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "H")
                    {
                        newDr["ANA_H"] = dr["QUOTE_VALUE"].ToString();
                        newDr["STDMIN_H"] = dr["STDMIN"].ToString();
                        newDr["STDMAX_H"] = dr["STDMAX"].ToString();
                    }
                    else if (dr["CHEM_NAME"].ToString() == "Al")
                    {
                        newDr["ANA_Al"] = dr["QUOTE_VALUE"].ToString();
                    }
                }
            }
            if (dataTable.Columns.Contains("ANA_Al") && dataTable.Columns.Contains("ANA_H"))
            {
                for (int i = 0; i < dataTable.Rows.Count; i++)
                {
                    if (!string.IsNullOrWhiteSpace(dataTable.Rows[i]["ANA_Al"].ToString2())
                        && !string.IsNullOrWhiteSpace(dataTable.Rows[i]["ANA_N"].ToString2()))
                    {
                        dataTable.Rows[i]["ANA_ALN"] = (Double.Parse(dataTable.Rows[i]["ANA_Al"].ToString2()) / Double.Parse(dataTable.Rows[i]["ANA_N"].ToString2())).ToString("f3");
                    }
                }
            }
            if (dt.Select("CHEM_NAME = 'O'").Length > 0)
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_O"].Hidden = false;
            }
            else
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_O"].Hidden = true;
            }
            if (dt.Select("CHEM_NAME = 'N'").Length > 0)
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_N"].Hidden = false;
            }
            else
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_N"].Hidden = true;
            }
            if (dt.Select("CHEM_NAME = 'H'").Length > 0)
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_H"].Hidden = false;
            }
            else
            {
                ultraGrid.DisplayLayout.Bands[0].Columns["ANA_H"].Hidden = true;
            }
            ultraGrid.DisplayLayout.Bands[0].Columns["ANA_Al"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMIN_O"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMAX_O"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMIN_N"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMAX_N"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMIN_H"].Hidden = true;
            ultraGrid.DisplayLayout.Bands[0].Columns["STDMAX_H"].Hidden = true;
            ultraGrid.DataBind();
        }

        //保存ONH录入数据
        /// <summary>
        /// 保存ONH录入数据
        /// </summary>
        private void AddChemONHAuditResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作！");
                    return;
                }

                if (publicUltraGridBase1.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择需要新增的检验信息！");
                    return;
                }

                if(!checkData())//验证录入数据
                {
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    ultraGrid2.UpdateData();

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

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();//检验信息详细表list
                    ArrayList alAuditResult = new ArrayList();//化学信息list

                    ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                    ArrayList alAuditParams = new ArrayList();//化学信息参数list

                    int quoteIndex = 0;//报出值位数
                    float OMin = 0.00f;
                    float OMax = 0.00f;
                    float NMin = 0.00f;
                    float NMax = 0.00f;
                    float HMin = 0.00f;
                    float HMax = 0.00f;
                    foreach (DataRow dr in dataTable2.Rows)
                    {
                        OMin = float.Parse(dr["STDMIN_O"].ToString3());
                        OMax = float.Parse(dr["STDMAX_O"].ToString3());
                        NMin = float.Parse(dr["STDMIN_N"].ToString3());
                        NMax = float.Parse(dr["STDMAX_N"].ToString3());
                        HMin = float.Parse(dr["STDMIN_H"].ToString3());
                        HMax = float.Parse(dr["STDMAX_H"].ToString3());

                        if (OMin > 0 && float.Parse(dr["ANA_O"].ToString3()) < OMin)
                        {
                            if(MessageUtil.ShowYesNoAndQuestion("O元素低于标准范围下限，是否继续新增？") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        if (OMax > 0 && float.Parse(dr["ANA_O"].ToString3()) > OMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("O元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        if (NMin > 0 && float.Parse(dr["ANA_N"].ToString3()) < NMin)
                        {
                            if(MessageUtil.ShowYesNoAndQuestion("N元素低于标准范围下限，是否继续新增？")== DialogResult.No)
                            {
                                return;
                            }
                        }
                        if (NMax > 0 && float.Parse(dr["ANA_N"].ToString3()) > NMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("N元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        if (HMin > 0 && float.Parse(dr["ANA_H"].ToString3()) < HMin)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("H元素低于标准范围下限，是否继续新增？") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        if (HMax > 0 && float.Parse(dr["ANA_H"].ToString3()) > HMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("H元素高于标准范围上限，是否继续新增？") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        //试验方法
                        string chemMethodCode = this.cmbChemMethodName.CheckedItems.Select(p => p.DataValue.ToString()).Aggregate((a, b) => a + (a == "" ? "" : ",") + b);
                        string chemMethodName = this.cmbChemMethodName.CheckedItems.Select(p => p.DisplayText.ToString()).Aggregate((a, b) => a + (a == "" ? "" : ",") + b);

                        alDetailParams = new ArrayList();
                        //alDetailParams.Add(UserInfo.GetDeptid());//部门ID
                        alDetailParams.Add(txtONH_CHECK_TEMP.Text.Trim());
                        alDetailParams.Add(ultraONH_DEVICE_NO.Text.Trim()); //试验设备
                        alDetailParams.Add(ultraONH_DEVICE_NAME.Text.Trim());
                        alDetailParams.Add(chemMethodCode); //试验方法
                        alDetailParams.Add(chemMethodName);
                        alDetailParams.Add(txtREMARK.Text.Trim());
                        alDetailParams.Add(cmbContent.Text.Trim());
                        alDetailParams.Add(ultraONH_CHECK_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : ultraONH_CHECK_NAME.Text.Trim());//试验人
                        alDetailParams.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//试验时间
                        alDetailParams.Add(ultraONH_CHECK_SHIFT.Text.Trim() == "" ? UserInfo.GetUserOrderText() : ultraONH_CHECK_SHIFT.Text.Trim());//试验班次
                        alDetailParams.Add(ultraONH_CHECK_CLASS.Text.Trim() == "" ? UserInfo.GetUserGroupText() : ultraONH_CHECK_CLASS.Text.Trim());//试验班组
                        alDetailParams.Add(ultraAUDIT_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : ultraAUDIT_NAME.Text.Trim());//审核人
                        alDetailParams.Add(txtCHECK_HUMIDITY.Text.Trim());
                        alDetailParams.Add("3");//录入标志位
                        alDetailParams.Add("2");//控制必须为已收样标志位
                        alDetailParams.Add("ONH");
                        alDetailParams.Add(dr["SAMPLE_NO"].ToString());
                        alDetailParams.Add(strCHECK_NO);//修改明细表
                        alDetail.Add(alDetailParams);

                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_O"].Column.Hidden && !(double.Parse(dr["ANA_O"].ToString3()) > 0))
                        {
                            MessageUtil.ShowTips("O元素值必须大于0!");
                            return;
                        }
                        quoteIndex = dr["ANA_O"].ToString3().Length - dr["ANA_O"].ToString3().IndexOf('.') - 1;//报出值小数位数
                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_O"].Column.Hidden && quoteIndex != 4)
                        {
                            MessageUtil.ShowTips("O元素值必须报出四位小数!");
                            return;
                        }

                        alAuditParams = new ArrayList();//O
                        alAuditParams.Add(dr["ANA_O"].ToString());
                        alAuditParams.Add(dr["ANA_O"].ToString());
                        alAuditParams.Add("O");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);


                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_N"].Column.Hidden && !(double.Parse(dr["ANA_N"].ToString3()) > 0))
                        {
                            MessageUtil.ShowTips("N元素值必须大于0!");
                            return;
                        }
                        quoteIndex = dr["ANA_N"].ToString3().Length - dr["ANA_N"].ToString3().IndexOf('.') - 1;//报出值小数位数
                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_N"].Column.Hidden && quoteIndex != 4)
                        {
                            MessageUtil.ShowTips("N元素值必须报出四位小数!");
                            return;
                        }

                        alAuditParams = new ArrayList();//N
                        alAuditParams.Add(dr["ANA_N"].ToString());
                        alAuditParams.Add(dr["ANA_N"].ToString());
                        alAuditParams.Add("N");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);

                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_H"].Column.Hidden && !(double.Parse(dr["ANA_H"].ToString3()) > 0))
                        {
                            MessageUtil.ShowTips("H元素绝对值必须大于0!");
                            return;
                        }
                        quoteIndex = dr["ANA_H"].ToString3().Length - dr["ANA_H"].ToString3().IndexOf('.') - 1;//报出值小数位数
                        if (!this.ultraGrid2.ActiveRow.Cells["ANA_H"].Column.Hidden && quoteIndex != 5)
                        {
                            MessageUtil.ShowTips("H元素值必须报出五位小数!");
                            return;
                        }

                        alAuditParams = new ArrayList();//H
                        alAuditParams.Add(dr["ANA_H"].ToString());
                        alAuditParams.Add(dr["ANA_H"].ToString());
                        alAuditParams.Add("H");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);
                    }

                    alAll.Add(alDetail);
                    alAll.Add(alAuditResult);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmChemONHDataManage.AddChemONHAuditResult",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");

                    //QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);

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

        private bool checkData()
        {
            if (this.txtONH_CHECK_TEMP.Text =="")
            {
                MessageUtil.ShowTips("请输入环境温度!");
                return false;
            }
            if (this.ultraONH_DEVICE_NO.Text == "")
            {
                MessageUtil.ShowTips("请选择试验设备!");
                return false;
            }
            if (this.ultraONH_DEVICE_NAME.Text == "")
            {
                MessageUtil.ShowTips("请选择试验设备!");
                return false;
            }
            if (this.ultraONH_CHECK_NAME.Text == "")
            {
                MessageUtil.ShowTips("请选择试验人!");
                return false;
            }
            if (this.ultraONH_CHECK_SHIFT.Text == "")
            {
                MessageUtil.ShowTips("请选择试验班次!");
                return false;
            }
            if (this.ultraONH_CHECK_CLASS.Text == "")
            {
                MessageUtil.ShowTips("请选择试验班组!");
                return false;
            }
            if (this.ultraAUDIT_NAME.Text == "")
            {
                MessageUtil.ShowTips("请选择审核人!");
                return false;
            }
            if (this.txtCHECK_HUMIDITY.Text == "")
            {
                MessageUtil.ShowTips("请输入环境湿度!");
                return false;
            }
            if (this.cmbChemMethodName.CheckedItems.Count() == 0)
            {
                MessageUtil.ShowTips("请选择试验方法!");
                return false;
            }
            
            return true;
        }

        private void btnConfirm_Click(object sender, EventArgs e)
        {
            if (publicUltraGridBase1.Ur != null && publicUltraGridBase1.Ur.Activated == true)
            {
                if (splitContainer1.Panel2Collapsed)
                {
                    splitContainer1.Panel2Collapsed = false;
                }
                else
                {
                    splitContainer1.Panel2Collapsed = true;
                }
            }
        }

        private void btnConfirm_LOG_Click(object sender, EventArgs e)
        {
            if (publicUltraGridBase2.Ur != null && publicUltraGridBase2.Ur.Activated == true)
            {
                if (splitContainer2.Panel2Collapsed)
                {
                    splitContainer2.Panel2Collapsed = false;
                }
                else
                {
                    splitContainer2.Panel2Collapsed = true;
                }
            }
        }

        //查询检验委托明细信息
        /// <summary>
        /// 查询检验委托明细信息
        /// </summary>
        private void QueryChemONHAuditResult()
        {
            try
            {
                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();

                ArrayList arrayList = new ArrayList();
                //arrayList.Add("");
                arrayList.Add(strCHECK_NO);
                arrayList.Add(strCHECK_NO);
                arrayList.Add(strCHECK_NO);
                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemONHDataManage.QueryCheckConsignChemDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    dataTable5.Rows.Clear();
                    return;
                }
                ShowColumns(dt, dataTable5, ultraGrid5);

                ArrayList arrayList1 = new ArrayList();
                //arrayList.Add("");
                arrayList1.Add(strCHECK_NO);
                DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemONHDataManage.QueryCheckConsignDetailNew",
                        new Object[] { arrayList1 }, this.ob);
                if (ds.Rows.Count > 0)
                {
                    txtONH_CHECK_TEMP_LOG.Text = ds.Rows[0]["CHECK_TEMP"].ToString();
                    ultraONH_DEVICE_NO_LOG.Text = ds.Rows[0]["DEVICE_NO"].ToString();
                    ultraONH_DEVICE_NAME_LOG.Text = ds.Rows[0]["DEVICE_NAME"].ToString();
                    ultraONH_CHECK_NAME_LOG.Text = ds.Rows[0]["CHECK_NAME"].ToString();
                    ultraONH_CHECK_SHIFT_LOG.Text = ds.Rows[0]["CHECK_SHIFT"].ToString();
                    ultraONH_CHECK_CLASS_LOG.Text = ds.Rows[0]["CHECK_CLASS"].ToString();
                    txtREMARK_LOG.Text = ds.Rows[0]["REMARK"].ToString();
                    cmbContent1.Text = ds.Rows[0]["CONTENT"].ToString();
                    txtCHECK_HUMIDITY_LOG.Text = ds.Rows[0]["CHECK_HUMIDITY"].ToString();
                    ultraAUDIT_NAME_LOG.Text = ds.Rows[0]["AUDIT_NAME"].ToString();
                    cmbChemMethodName_LOG.Text = ds.Rows[0]["FORMUAL_NAME"].ToString();
                    ultraCHECK_TIME_LOG.Text = ds.Rows[0]["CHECK_TIME"].ToString();
                    ultraAUDIT_TIME_LOG.Text = ds.Rows[0]["AUDIT_TIME"].ToString();
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }

        //修改ONH录入数据
        /// <summary>
        /// 修改ONH录入数据
        /// </summary>
        private void UpdateChemONHAuditResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有在已录入数据页才能进行修改操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择需要修改的检验信息！");
                    return;
                }
                ultraGrid5.UpdateData();

                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
                ArrayList AList = new ArrayList();
                AList.Add(strCHECK_NO);
                AList.Add("");
                AList.Add("ONH");
                DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryDetailFlag", new object[] { AList }, ob);
                if (ds != null && ds.Rows.Count > 0)
                {
                    if (int.Parse(ds.Rows[0]["FLAG"].ToString3()) > 3)
                    {
                        MessageUtil.ShowWarning("已审核的数据不能修改！");
                        return;
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    

                    //ArrayList alAll = new ArrayList();

                    //ArrayList alDetail = new ArrayList();//检验信息详细表list
                    ArrayList alAuditResult = new ArrayList();//化学信息list

                    //ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                    ArrayList alAuditParams = new ArrayList();//化学信息参数list

                    foreach (DataRow dr in dataTable5.Rows)
                    {
                        //alDetailParams = new ArrayList();
                        //alDetailParams.Add(txtONH_CHECK_TEMP.Text.Trim());
                        //alDetailParams.Add(ultraONH_DEVICE_NO.Text.Trim());
                        //alDetailParams.Add(ultraONH_DEVICE_NAME.Text.Trim());
                        //alDetailParams.Add(txtREMARK.Text.Trim());
                        //alDetailParams.Add(ultraONH_CHECK_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : ultraONH_CHECK_NAME.Text.Trim());//试验人
                        ////alDetailParams.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//试验时间
                        //alDetailParams.Add(ultraONH_CHECK_CLASS.Text.Trim() == "" ? UserInfo.GetUserGroupText() : ultraONH_CHECK_CLASS.Text.Trim());//试验班组
                        //alDetailParams.Add("3");//录入标志位
                        //alDetailParams.Add("ONH");
                        //alDetailParams.Add(dr["SAMPLE_NO"].ToString());
                        //alDetailParams.Add(strCHECK_NO);//修改明细表
                        //alDetail.Add(alDetailParams);

                        alAuditParams = new ArrayList();//O
                        alAuditParams.Add(dr["ANA_O"].ToString());
                        alAuditParams.Add(dr["ANA_O"].ToString());
                        alAuditParams.Add("O");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);

                        alAuditParams = new ArrayList();//N
                        alAuditParams.Add(dr["ANA_N"].ToString());
                        alAuditParams.Add(dr["ANA_N"].ToString());
                        alAuditParams.Add("N");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);

                        alAuditParams = new ArrayList();//H
                        alAuditParams.Add(dr["ANA_H"].ToString());
                        alAuditParams.Add(dr["ANA_H"].ToString());
                        alAuditParams.Add("H");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);
                    }

                    //alAll.Add(alDetail);
                    //alAll.Add(alAuditResult);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmChemONHDataManage.UpdateChemONHAuditResult",
                new Object[] { alAuditResult }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, "CHECK_NO", strCHECK_NO);

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

        //删除ONH录入数据
        /// <summary>
        /// 删除ONH录入数据
        /// </summary>
        private void DeleteChemONHAuditResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有在已录入数据页才能进行删除操作！");
                    return;
                }

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择需要删除的检验信息！");
                    return;
                }
                ultraGrid5.UpdateData();

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

                ArrayList AList = new ArrayList();
                AList.Add(strCHECK_NO);
                AList.Add("");
                AList.Add("ONH");
                DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryDetailFlag", new object[] { AList }, ob);
                if (ds != null && ds.Rows.Count > 0)
                {
                    if (int.Parse(ds.Rows[0]["FLAG"].ToString3()) > 3)
                    {
                        MessageUtil.ShowWarning("已审核的数据不能删除！");
                        return;
                    }
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {

                    ArrayList alAll = new ArrayList();
                    ArrayList alDetail = new ArrayList();//检验信息详细表list
                    ArrayList alAuditResult = new ArrayList();//化学信息list

                    ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
                    ArrayList alAuditParams = new ArrayList();//化学信息参数list

                    foreach (DataRow dr in dataTable5.Rows)
                    {
                        alDetailParams = new ArrayList();
                        alDetailParams.Add("");
                        alDetailParams.Add("");
                        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("3");
                        alDetailParams.Add("ONH");
                        alDetailParams.Add(dr["SAMPLE_NO"].ToString());
                        alDetailParams.Add(strCHECK_NO);//修改明细表
                        alDetail.Add(alDetailParams);

                        alAuditParams = new ArrayList();//O
                        alAuditParams.Add("");
                        alAuditParams.Add("");
                        alAuditParams.Add("O");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);

                        alAuditParams = new ArrayList();//N
                        alAuditParams.Add("");
                        alAuditParams.Add("");
                        alAuditParams.Add("N");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);

                        alAuditParams = new ArrayList();//H
                        alAuditParams.Add("");
                        alAuditParams.Add("");
                        alAuditParams.Add("H");
                        alAuditParams.Add(dr["SAMPLE_NO"].ToString());
                        alAuditParams.Add(strCHECK_NO);
                        alAuditResult.Add(alAuditParams);
                    }

                    alAll.Add(alDetail);
                    alAll.Add(alAuditResult);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmChemONHDataManage.DeleteChemONHAuditResult",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");

                    //QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");

                    PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, "CHECK_NO", strCHECK_NO);

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

        //ONH打印
        /// <summary>
        /// ONH打印
        /// </summary>
        private void RepLimsPipeChemONHResult()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有在已录入数据才能进行打印！");
                    return;
                }

                this.Cursor = Cursors.WaitCursor;

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请点击选择您要打印的检验信息！");
                    return;
                }

                string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
                string strSUPPLY_UNIT = publicUltraGridBase2.Ur.Cells["SUPPLY_UNIT"].Text.Trim();
                string strurl = "";
                if (strSUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
                {
                     strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeChemAnalysisReportTH.cpt&op=view&CHECK_NO=" + strCHECK_NO;
                }
                else
                {
                     strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeChemAnalysisReport.cpt&op=view&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 = "化学成分ONH报告";
                fBug.Show();
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        //查询上传的PDF文件
        /// <summary>
        /// 查询上传的PDF文件
        /// </summary>
        private void SelectFile(string filePathNew)
        {
            dlgOrderAskDown down = new dlgOrderAskDown(this.ob, filePathNew);
            down.DeleteButton.Visible = false;
            down.ShowDialog();
        }

        /// <summary>
        /// 查询熔炼成分
        /// </summary>
        /// <param name="uRow"></param>
        private void doQueryLgChem(UltraGridRow uRow)
        {
            //if (ultraGrid1.DataSource != null)
            //{
            //    ((DataTable)ultraGrid1.DataSource).Clear();
            //}
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.doQueryLgChem", new object[] { uRow.Cells["STOVE_NO"].Text }, ob);
            GridHelper.CopyDataToDatatable(ds, this.dataTable9, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid1);

            //DataTable dt = ultraGrid2.DataSource as DataTable;

            //if (ds.Rows.Count > 0)
            //{
            //    for (int i = ds.Columns.Count - 1; i >= 0; i--)
            //    {
            //        if (ds.Columns[i].ColumnName.Equals("SAMPLE_NO"))
            //        {
            //            ds.Columns[i].Caption = "式样号";
            //        }
            //        if (ds.Columns[i].ColumnName.Equals("ASN"))
            //        {
            //            ds.Columns[i].ColumnName = "As";
            //        }
            //        else
            //        {
            //            if (ds.Columns[i].ColumnName.Length == 2)
            //            {
            //                ds.Columns[i].ColumnName = ds.Columns[i].ColumnName.Substring(0, 1) + ds.Columns[i].ColumnName.Substring(1, 1).ToLower();
            //            }
            //        }
            //        //if (!dt.Columns.Contains(ds.Columns[i].ColumnName))
            //        //{
            //        //    ds.Columns.Remove(ds.Columns[i].ColumnName);
            //        //}
            //    }
            //    ultraGrid1.DataSource = ds;
            //    GridHelper.RefreshAndAutoSize(ultraGrid1);
            //}
            //else
            //{
            //    ultraGrid1.DataSource = null;
            //}


        }

        //上传
        /// <summary>
        /// 上传
        /// </summary>
        private void UpFile()
        {
            
            string checkNo = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
            string strSUPPLY_UNIT = publicUltraGridBase2.Ur.Cells["SUPPLY_UNIT"].Text.Trim();
            string cpt = "";
            if (strSUPPLY_UNIT.Equals("江苏天淮钢管有限公司"))
            {
                cpt = "RepPipeChemAnalysisReportTH.cpt";
            }
            else
            {
                cpt = "RepPipeChemAnalysisReport.cpt";
            }
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
                MessageUtil.ShowTips("还有未审核试样组,不允许上传报告!");
                return;
            }

            WebClient webClient = new WebClient();
            List<FileBean> listPdf = new List<FileBean>();

            string filePathNew = ""; //报告目录

            if (UpLoadHandle.Upload(checkNo, cpt, "huaxue", out filePathNew))
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
                ccp.MethodName = "updatePipeReport";
                ccp.ServerParams = new object[] { checkNo, "", "", "HUAXUE_PATH", filePathNew };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnInfo.Equals("上传成功!"))
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        SelectFile(filePathNew);
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                }
            }
            else
            {
                MessageUtil.ShowError("系统生成PDF失败，请稍后再试！");
                return;
            }
        }

        private void UpFile(string checkNo)
        {

            //string checkNo = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.doQueryIsAudit", new object[] { checkNo, arrId }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
               // MessageUtil.ShowTips("还有未审核试样组,不允许上传报告!");
                return;
            }

            WebClient webClient = new WebClient();
            List<FileBean> listPdf = new List<FileBean>();

            string filePathNew = ""; //报告目录

            if (UpLoadHandle.Upload(checkNo, "RepPipeChemAnalysisReport.cpt", "huaxue", out filePathNew))
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.lims.data.pipe.FrmLabDateParm";
                ccp.MethodName = "updatePipeReport";
                ccp.ServerParams = new object[] { checkNo, "", "", "HUAXUE_PATH", filePathNew };
                ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    if (ccp.ReturnInfo.Equals("上传成功!"))
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        SelectFile(filePathNew);
                    }
                    else
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                    }
                }
            }
            else
            {
                MessageUtil.ShowError("系统生成PDF失败，请稍后再试！");
                return;
            }
        }

        /// <summary>
        /// 导出
        /// </summary>
        private void ExportData()
        {
            if (this.ultraTabControl1.Tabs[0].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridBase1.Ug, "未录入数据");
            }
            else if (this.ultraTabControl1.Tabs[1].Active)
            {
                GridHelper.ulGridToExcel(publicUltraGridBase2.Ug, "已录入数据");
            }
        }

        private void ultraONH_DEVICE_NO_ValueChanged(object sender, EventArgs e)
        {
            ultraONH_DEVICE_NAME.Value = ultraONH_DEVICE_NO.Value;
        }

        private void ultraONH_DEVICE_NAME_ValueChanged(object sender, EventArgs e)
        {
            ultraONH_DEVICE_NO.Value = ultraONH_DEVICE_NAME.Value;
        }

        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("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                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"))
                {
                    this.toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    this.toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    this.toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Close"))
                {
                    this.toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("StdSteelNo"))
                {
                    this.toolMenu.Toolbars[0].Tools["StdSteelNo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Update"))
                {
                    toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
                {
                    this.toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    this.toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Print"))
                {
                    this.toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    this.toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Close"))
                {
                    this.toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("StdSteelNo"))
                {
                    this.toolMenu.Toolbars[0].Tools["StdSteelNo"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        private void ultraLabel20_Click(object sender, EventArgs e)
        {
           
        }

        private void FrmChemONHDataManage_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null || toolMenu.Toolbars == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("Update"))
            {
                this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
            {
                this.toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
            {
                toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
            {
                toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("StdSteelNo"))
            {
                toolMenu.Toolbars[0].Tools["StdSteelNo"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }
    }
}