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

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmRCLDataCJ : FrmBase
    {
        private string[] plineCodes = { };
        public FrmRCLDataCJ()
        {
            InitializeComponent();
        }

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

            publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
            ultraGrid6.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid7.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid8.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private void FrmRCLDataCJ_Load(object sender, EventArgs e)
        {
            InitColumns();
            plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
            pipeQueryBase1.UpdateControl("收样时间");
        }

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

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

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

            //加载热处理制度
            DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.initRclInfo", new object[] { }, ob);
            if (ds != null && ds.Rows.Count > 0)
            {
                ultraRCL_INFO.DataSource = ds;
                ultraRCL_INFO.ValueMember = "RCL_INFO";
            }

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

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

        /// <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(publicUltraGridBase1, pipeShowBase1, "2");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");
                    }
                    break;
                case "Add":
                    AddCheckConsignRclInfo();
                    break;
                case "Update":
                    UpdateCheckConsignRclInfo();
                    break;
                case "Delete":
                    DeleteCheckConsignRclInfo();
                    break;
                case "Audit":
                    AuditCheckConsignRclInfo();
                    break;
                case "CancelAudit":
                    CancelAuditCheckConsignRclInfo();
                    break;
                case "Print":
                    Print();
                    break;
                    
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        
       

        
        //查询检验委托基本信息
        /// <summary>
        /// 查询检验委托基本信息
        /// </summary>
        /// <param name="publicUltraGridBase"></param>
        /// <param name="pipeShowBase"></param>
        /// <param name="flag"></param>
        private void QueryCheckConsignBase(PublicUltraGridBase publicUltraGridBase, PipeShowBase pipeShowBase, string flag)
        {
            try
            {
                ArrayList arrayList = pipeQueryBase1.GetQueryInfo(flag);
                arrayList.Add(plineCodes);
                publicUltraGridBase.QueryCheckConsignBase2("pipe.FrmRCLDataCJ", arrayList, this.ob);
                if (publicUltraGridBase.Ur == null || publicUltraGridBase.Ur.Activated == false)
                {
                    pipeShowBase.ShowBaseInfo(publicUltraGridBase.Ur);
                    if (publicUltraGridBase == publicUltraGridBase1)
                    {
                        dataTable2.Rows.Clear();
                        dataTable3.Rows.Clear();
                        dataTable4.Rows.Clear();
                    }
                    else if (publicUltraGridBase == publicUltraGridBase2)
                    {
                        dataTable6.Rows.Clear();
                        dataTable7.Rows.Clear();
                        dataTable8.Rows.Clear();
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        /// <summary>
        /// 增加列
        /// </summary>
        /// <param name="dt"></param>源DataTable
        /// <param name="dataTable"></param>需要增加的DataTable
        private void ShowColumns(DataTable dt, DataTable dataTable)
        {
            int dcNum = dataTable.Columns.Count;//清除列
            if (dcNum > 1)
            {
                for (int i = 0; i < dcNum - 1; i++)
                {
                    dataTable.Columns.RemoveAt(1);
                }
            }

            DataColumn dc;
            foreach (DataRow dr in dt.Rows)//增加列
            {
                try
                {
                    dc = new DataColumn(dr["PHY_CODE_MAX"].ToString());

                    dc.Caption = dr["PHY_NAME_MAX"].ToString();

                    dataTable.Columns.Add(dc);
                }
                catch
                {
                    continue;
                }
            }

            dc = new DataColumn("RCL_INFO");
            dc.Caption = "热处理制度";
         
            dataTable.Columns.Add(dc);
        }

        #region 未录入数据
        void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
            QueryCheckConsignDetail();
        }

        //查询检验委托明细信息
        private void QueryCheckConsignDetail()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                //arrayList.Add("2");//已接受
                arrayList.Add(publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.QueryCheckConsignDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    dataTable2.Rows.Clear();
                    int dcNum = dataTable2.Columns.Count;//清除列
                    if (dcNum > 1)
                    {
                        for (int i = 0; i < dcNum - 1; i++)
                        {
                            dataTable2.Columns.RemoveAt(1);
                        }
                    }

                    dataTable3.Rows.Clear();
                    dataTable4.Rows.Clear();
                    return;
                }

                ShowColumns(dt, dataTable2);

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

                dataTable2.Rows.Clear();//清除行
                dataTable3.Rows.Clear();//清除行
                dataTable4.Rows.Clear();//清除行

                DataRow newDr = dataTable2.NewRow();
                DataRow newDrCH;//淬火
                DataRow newDrHH;//回火
                foreach (DataRow dr in dt.Rows)
                {
                    if (row.IndexOf(dr["SAMPLE_NO"].ToString()) < 0)//判断是否有重复样管号,有则不增加行只增加对应的列
                    {
                        row += dr["SAMPLE_NO"].ToString() + " ";
                        newDr = dataTable2.NewRow();
                        newDr["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        newDr[dr["PHY_CODE_MAX"].ToString()] = dr["SAMPLE_COUNT"].ToString();
                        dataTable2.Rows.Add(newDr);

                        newDrCH = dataTable3.NewRow();
                        newDrCH["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        dataTable3.Rows.Add(newDrCH);

                        newDrHH = dataTable4.NewRow();
                        newDrHH["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        dataTable4.Rows.Add(newDrHH);
                    }
                    else
                    {
                        newDr[dr["PHY_CODE_MAX"].ToString()] = dr["SAMPLE_COUNT"].ToString();
                    }
                }
                //GridHelper.RefreshAndAutoSize(ultraGrid2);//刷新Grid

                ultraGrid2.DisplayLayout.Bands[0].Columns["RCL_INFO"].EditorComponent = ultraRCL_INFO;
                ultraGrid2.DataBind();//dataTable发生变化提交给ultraGrid
                ultraGrid2.DisplayLayout.Bands[0].Columns["RCL_INFO"].Width = 300;
            }
            catch
            {
                //MessageUtil.ShowError(ex.Message);
            }
        }

        //保存热处理制度录入数据
        private void AddCheckConsignRclInfo()
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index != 0)
                {
                    MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作！");
                    return;
                }

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

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

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

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailParams;//参数
                    ArrayList alCHECK_NO = new ArrayList();
                    ArrayList alCHECK_NO2 = new ArrayList();
                    foreach (DataRow dr in dataTable2.Rows)
                    {
                        foreach (DataColumn dc in dataTable2.Columns)
                        {
                            if (dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "" && dc.ColumnName != "RCL_INFO")//列不为SAMPLE_NO才增加
                            {
                                alDetailParams = new ArrayList();//增加明细表参数
                                alDetailParams.Add("3");
                                //alDetailParams.Add("2");//更新是否ISRCL状态位                            
                                alDetailParams.Add(dc.ColumnName);
                                alDetailParams.Add(dr["SAMPLE_NO"].ToString().Trim());
                                alDetailParams.Add(strCHECK_NO);
                                alDetail.Add(alDetailParams);
                            }
                        }
                    }

                    ArrayList alRclInfo = new ArrayList();
                    ArrayList alRclInfoParams;//参数

                    for (int i = 0; i < ultraGrid2.Rows.Count; i++)
                    {
                        alRclInfoParams = new ArrayList();

                        alRclInfoParams.Add(strCHECK_NO);//检验编号
                        alRclInfoParams.Add(ultraGrid2.Rows[i].Cells["SAMPLE_NO"].Text.Trim());//样管号
                        alRclInfoParams.Add(ultraGrid2.Rows[i].Cells["RCL_INFO"].Text.Trim());//热处理制度

                        alRclInfoParams.Add(UserInfo.GetUserName());//试验人
                        alRclInfoParams.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//试验时间
                        alRclInfoParams.Add(UserInfo.GetUserGroupText());//试验班组

                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["DEVICE_NAME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["DEVICE_NO_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["ZL_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["JR_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["CL_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["ZL_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["BW_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["CL_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid3.Rows[i].Cells["LQ_METHOD_CH"].Text.Trim());//

                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["DEVICE_NAME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["DEVICE_NO_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["ZL_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["JR_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["CL_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["ZL_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["BW_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["CL_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid4.Rows[i].Cells["LQ_METHOD_HH"].Text.Trim());//

                        alRclInfo.Add(alRclInfoParams);
                    }

                    alCHECK_NO.Add(strCHECK_NO);
                    alCHECK_NO2.Add(alCHECK_NO);

                    alAll.Add(alDetail);
                    alAll.Add(alRclInfo);
                    alAll.Add(alCHECK_NO2);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmRCLDataCJ.AddCheckConsignRclInfo",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase(publicUltraGridBase1, pipeShowBase1, "2");//isrcl

                    QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");

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

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

        private void ultraRCL_INFO_TextChanged(object sender, EventArgs e)
        {

        }

        private void ultraGrid3_CellChange(object sender, CellEventArgs e)
        {
            if (ultraGrid3.Rows.Count >= 1 && e.Cell.Row.Index == 0)
            {
                ultraGrid3.Update();
                for (int i = 0; i < ultraGrid3.Rows.Count; i++)
                {
                    if (e.Cell.Column.Key == "ZL_TEMP_CH")
                    {
                        ultraGrid3.Rows[i].Cells["ZL_TEMP_CH"].Value = ultraGrid3.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                        ultraGrid3.Rows[i].Cells["JR_TEMP_CH"].Value = ultraGrid3.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                        ultraGrid3.Rows[i].Cells["CL_TEMP_CH"].Value = ultraGrid3.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                    }
                    else
                    {
                        ultraGrid3.Rows[i].Cells[e.Cell.Column.Key].Value = ultraGrid3.Rows[0].Cells[e.Cell.Column.Key].Text.Trim();
                    }
                }
            }
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            if (ultraGrid4.Rows.Count >= 1 && e.Cell.Row.Index == 0)
            {
                ultraGrid4.Update();
                for (int i = 0; i < ultraGrid4.Rows.Count; i++)
                {
                    if (e.Cell.Column.Key == "ZL_TEMP_HH")
                    {
                        ultraGrid4.Rows[i].Cells["ZL_TEMP_HH"].Value = ultraGrid4.Rows[0].Cells["ZL_TEMP_HH"].Text.Trim();
                        ultraGrid4.Rows[i].Cells["JR_TEMP_HH"].Value = ultraGrid4.Rows[0].Cells["ZL_TEMP_HH"].Text.Trim();
                        ultraGrid4.Rows[i].Cells["CL_TEMP_HH"].Value = ultraGrid4.Rows[0].Cells["ZL_TEMP_HH"].Text.Trim();
                    }
                    else
                    {
                        ultraGrid4.Rows[i].Cells[e.Cell.Column.Key].Value = ultraGrid4.Rows[0].Cells[e.Cell.Column.Key].Text.Trim();
                    }
                }
            }
        }
        #endregion

        #region 已录入数据
        void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
        {
            pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
            QueryCheckConsignRclInfo();
        }

        //查询检验委托明细信息
        /// <summary>
        /// 查询检验委托明细信息
        /// </summary>
        private void QueryCheckConsignDetail2()
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                //arrayList.Add("3456");
                arrayList.Add(publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = ServerHelper.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.QueryCheckConsignDetail",
                        new Object[] { arrayList }, this.ob);

                if (dt.Rows.Count == 0)
                {
                    dataTable6.Rows.Clear();
                    int dcNum = dataTable6.Columns.Count;//清除列
                    if (dcNum > 1)
                    {
                        for (int i = 0; i < dcNum - 1; i++)
                        {
                            dataTable6.Columns.RemoveAt(1);
                        }
                    }

                    dataTable7.Rows.Clear();
                    dataTable8.Rows.Clear();
                    return;
                }

                ShowColumns(dt, dataTable6);

                DataColumn dc = new DataColumn("CHECK_NAME");
                dc.Caption = "试验人";
                dataTable6.Columns.Add(dc);
                dc = new DataColumn("CHECK_TIME");
                dc.Caption = "试验时间";
                dataTable6.Columns.Add(dc);

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

                dataTable6.Rows.Clear();//清除行
                dataTable7.Rows.Clear();//清除行
                dataTable8.Rows.Clear();//清除行

                DataRow newDr = dataTable6.NewRow();
                DataRow newDrCH;//淬火
                DataRow newDrHH;//回火
                foreach (DataRow dr in dt.Rows)
                {
                    if (row.IndexOf(dr["SAMPLE_NO"].ToString()) < 0)//判断是否有重复样管号,有则不增加行只增加对应的列
                    {
                        row += dr["SAMPLE_NO"].ToString() + " ";
                        newDr = dataTable6.NewRow();
                        newDr["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        newDr[dr["PHY_CODE_MAX"].ToString()] = dr["SAMPLE_COUNT"].ToString();
                        dataTable6.Rows.Add(newDr);

                        newDrCH = dataTable7.NewRow();
                        newDrCH["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        dataTable7.Rows.Add(newDrCH);

                        newDrHH = dataTable8.NewRow();
                        newDrHH["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
                        dataTable8.Rows.Add(newDrHH);
                    }
                    else
                    {
                        newDr[dr["PHY_CODE_MAX"].ToString()] = dr["SAMPLE_COUNT"].ToString();
                    }
                }
                ultraGrid6.DataBind();
              
                //GridHelper.RefreshAndAutoSize(ultraGrid6);//刷新Grid
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError(ex.Message);
            }
        }

        //查询检验委托明细信息
        /// <summary>
        /// 查询检验委托明细信息
        /// </summary>
        private void QueryCheckConsignRclInfo()
        {
            try
            {
                QueryCheckConsignDetail2();
                ArrayList arrayList = new ArrayList();
                arrayList.Add(publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim());

                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.QueryCheckConsignRclInfo",
                        new Object[] { arrayList }, this.ob);

                foreach (DataRow dr in dt.Rows)
                {
                    foreach (DataRow dr2 in dataTable6.Rows)
                    {
                        if (dr["SAMPLE_NO"].ToString() == dr2["SAMPLE_NO"].ToString())
                        {
                            dr2["RCL_INFO"] = dr["RCL_INFO"].ToString();
                            dr2["CHECK_NAME"] = dr["CHECK_NAME"].ToString();
                            dr2["CHECK_TIME"] = dr["CHECK_TIME"].ToString();
                        }
                    }

                    foreach (DataRow dr3 in dataTable7.Rows)//淬火信息
                    {
                        if (dr["SAMPLE_NO"].ToString() == dr3["SAMPLE_NO"].ToString())
                        {
                            dr3["ZL_TEMP_CH"] = dr["ZL_TEMP_CH"].ToString();
                            dr3["JR_TEMP_CH"] = dr["JR_TEMP_CH"].ToString();
                            dr3["CL_TEMP_CH"] = dr["CL_TEMP_CH"].ToString();
                            dr3["ZL_TIME_CH"] = dr["ZL_TIME_CH"].ToString();
                            dr3["BW_TIME_CH"] = dr["BW_TIME_CH"].ToString();
                            dr3["CL_TIME_CH"] = dr["CL_TIME_CH"].ToString();
                            dr3["LQ_METHOD_CH"] = dr["LQ_METHOD_CH"].ToString();
                            dr3["DEVICE_NAME_CH"] = dr["DEVICE_NAME_CH"].ToString();
                            dr3["DEVICE_NO_CH"] = dr["DEVICE_NO_CH"].ToString();
                        }
                    }

                    foreach (DataRow dr4 in dataTable8.Rows)//回火信息
                    {
                        if (dr["SAMPLE_NO"].ToString() == dr4["SAMPLE_NO"].ToString())
                        {
                            dr4["ZL_TEMP_HH"] = dr["ZL_TEMP_HH"].ToString();
                            dr4["JR_TEMP_HH"] = dr["JR_TEMP_HH"].ToString();
                            dr4["CL_TEMP_HH"] = dr["CL_TEMP_HH"].ToString();
                            dr4["ZL_TIME_HH"] = dr["ZL_TIME_HH"].ToString();
                            dr4["BW_TIME_HH"] = dr["BW_TIME_HH"].ToString();
                            dr4["CL_TIME_HH"] = dr["CL_TIME_HH"].ToString();
                            dr4["LQ_METHOD_HH"] = dr["LQ_METHOD_HH"].ToString();
                            dr4["DEVICE_NAME_HH"] = dr["DEVICE_NAME_HH"].ToString();
                            dr4["DEVICE_NO_HH"] = dr["DEVICE_NO_HH"].ToString();
                        }
                    }
                }

                ultraGrid6.DisplayLayout.Bands[0].Columns["RCL_INFO"].EditorComponent = ultraRCL_INFO;
                ultraGrid6.DisplayLayout.Bands[0].Columns["RCL_INFO"].PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);

                //GridHelper.RefreshAndAutoSize(ultraGrid6);//刷新Grid
                //GridHelper.RefreshAndAutoSize(ultraGrid7);//刷新Grid
                //GridHelper.RefreshAndAutoSize(ultraGrid8);//刷新Grid
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError(ex.Message);
            }
        }

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

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要修改的试样信息！");
                    return;
                }

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

                ArrayList alSelect = new ArrayList();
                alSelect.Add(strCHECK_NO);//检验编号

                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.QueryCheckConsignBaseDetaiLFlag",
    new Object[] { alSelect }, ob);//查询状态位

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                if (dt.Rows[0]["ISRCL"].ToString() == "4")
                {
                    MessageUtil.ShowTips("已审核的数据不允许修改！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    ultraGrid6.Update();
                    ultraGrid7.Update();
                    ultraGrid8.Update();

                    ArrayList alAll = new ArrayList();

                    ArrayList alDelete = new ArrayList();
                    ArrayList alDeleteParams = new ArrayList();//删除参数

                    alDeleteParams.Add(strCHECK_NO);
                    alDelete.Add(alDeleteParams);

                    ArrayList alRclInfo = new ArrayList();
                    ArrayList alRclInfoParams;//参数

                    for (int i = 0; i < ultraGrid6.Rows.Count; i++)
                    {
                        alRclInfoParams = new ArrayList();

                        alRclInfoParams.Add(strCHECK_NO);//检验编号
                        alRclInfoParams.Add(ultraGrid6.Rows[i].Cells["SAMPLE_NO"].Text.Trim());//样管号
                        alRclInfoParams.Add(ultraGrid6.Rows[i].Cells["RCL_INFO"].Text.Trim());//热处理制度

                        alRclInfoParams.Add(UserInfo.GetUserName());//试验人
                        alRclInfoParams.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//试验时间
                        alRclInfoParams.Add(UserInfo.GetUserGroupText());//试验班组

                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["DEVICE_NAME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["DEVICE_NO_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["ZL_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["JR_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["CL_TEMP_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["ZL_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["BW_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["CL_TIME_CH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid7.Rows[i].Cells["LQ_METHOD_CH"].Text.Trim());//

                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["DEVICE_NAME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["DEVICE_NO_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["ZL_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["JR_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["CL_TEMP_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["ZL_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["BW_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["CL_TIME_HH"].Text.Trim());//
                        alRclInfoParams.Add(ultraGrid8.Rows[i].Cells["LQ_METHOD_HH"].Text.Trim());//

                        alRclInfo.Add(alRclInfoParams);
                    }

                    alAll.Add(alDelete);
                    //alAll.Add(alDetail);
                    alAll.Add(alRclInfo);
                    PublicServer.SetData("com.steering.lims.data.pipe.FrmRCLDataCJ.UpdateCheckConsignRclInfo",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");

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

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

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

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要删除的试样信息！");
                    return;
                }

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

                ArrayList alSelect = new ArrayList();
                alSelect.Add(strCHECK_NO);//检验编号

                DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmRCLDataCJ.QueryCheckConsignBaseDetaiLFlag",
    new Object[] { alSelect }, ob);//查询状态位

                if (dt == null || dt.Rows.Count == 0)
                {
                    return;
                }
                if (dt.Rows[0]["ISRCL"].ToString() == "4")
                {
                    MessageUtil.ShowTips("已审核的数据不允许删除！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                {
                    ultraGrid6.Update();
                    ultraGrid7.Update();
                    ultraGrid8.Update();

                    ArrayList alAll = new ArrayList();

                    ArrayList alDetail = new ArrayList();
                    ArrayList alDetailParams;//参数
                    foreach (DataRow dr in dataTable6.Rows)
                    {
                        foreach (DataColumn dc in dataTable6.Columns)
                        {
                            if (dc.ColumnName != "SAMPLE_NO" && dr[dc.ColumnName].ToString().Trim() != "" && dc.ColumnName != "RCL_INFO")//列不为SAMPLE_NO才增加
                            {
                                alDetailParams = new ArrayList();//增加明细表参数
                                alDetailParams.Add("2");
                                alDetailParams.Add(dc.ColumnName);
                                alDetailParams.Add(dr["SAMPLE_NO"].ToString().Trim());
                                alDetailParams.Add(strCHECK_NO);
                                alDetail.Add(alDetailParams);
                            }
                        }
                    }

                    ArrayList alDelete = new ArrayList();
                    ArrayList alDeleteParams = new ArrayList();//删除参数

                    alDeleteParams.Add(strCHECK_NO);
                    alDelete.Add(alDeleteParams);

                    alAll.Add(alDetail);
                    alAll.Add(alDelete);

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmRCLDataCJ.DeleteCheckConsignRclInfo",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");

                    QueryCheckConsignBase(publicUltraGridBase1, pipeShowBase1, "2");

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

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

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

                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要审核的试样信息！");
                    return;
                }

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

                if (MessageUtil.ShowYesNoAndQuestion("是否确认审核？") == DialogResult.Yes)
                {
                    ultraGrid6.Update();
                    ultraGrid7.Update();
                    ultraGrid8.Update();

                    UltraGridRow ugr =  publicUltraGridBase2.Ug.ActiveRow;

                    ArrayList alAll = new ArrayList();
                    alAll.Add("4");
                    alAll.Add(UserInfo.GetUserName());
                    alAll.Add(UserInfo.GetUserOrder());
                    alAll.Add(UserInfo.GetUserGroup());
                    alAll.Add(strCHECK_NO);
                    //alAll.Add(ugr.Cells["SAMPLE_NO"].Value.ToString());

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmRCLDataCJ.AuditCheckConsignRclInfo",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");

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

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

        /// <summary>
        /// 取消审核
        /// </summary>
        private void CancelAuditCheckConsignRclInfo()
        {
            try
            {
               
                if (publicUltraGridBase2.Ur == null)
                {
                    MessageUtil.ShowWarning("请选择需要取消审核的试样信息！");
                    return;
                }
                if (!"已审核".Equals(publicUltraGridBase2.Ur.Cells["ISRCL_DESC"].Text.Trim()))
                {
                    MessageUtil.ShowWarning("请选择已审核的试样信息！");
                    return;
                }

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

                if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审核？") == DialogResult.Yes)
                {
                    ultraGrid6.Update();
                    ultraGrid7.Update();
                    ultraGrid8.Update();

                    UltraGridRow ugr = publicUltraGridBase2.Ug.ActiveRow;

                    ArrayList alAll = new ArrayList();
                    alAll.Add("3");
                    alAll.Add(strCHECK_NO);
                    //alAll.Add(ugr.Cells["SAMPLE_NO"].Value.ToString());

                    PublicServer.SetData("com.steering.lims.data.pipe.FrmRCLDataCJ.CancelAuditCheckConsignRclInfo",
                new Object[] { alAll }, this.ob);

                    QueryCheckConsignBase(publicUltraGridBase2, pipeShowBase2, "3456");

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

                    MessageUtil.ShowTips("取消审核成功！");
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
            }
        }


        /// <summary>
        /// 打印
        /// </summary>
        private void Print()
        {
            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=RepPipeGcHttReportTH.cpt&format=pdf&__embed__=true&CHECK_NO=" + strCHECK_NO;
            }
            else
            {
                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeGcHttReport.cpt&format=pdf&__embed__=true&CHECK_NO=" + strCHECK_NO;
            }

            FrmExcel fre = new FrmExcel(this.ob, strurl);

            fre.AutoSize = true;
            fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fre.WindowState = FormWindowState.Maximized;
            fre.Show();
        }

        #endregion

        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"))
                {
                    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("Close"))
                {
                    toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                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;
                }


            }
            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"))
                {
                    toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Close"))
                {
                    toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
                {
                    toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
                {
                    toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        private void ultraDEVICE_NAME_ValueChanged(object sender, EventArgs e)
        {
            ultraDEVICE_NO.Value = ultraDEVICE_NAME.Value;
        }

        private void ultraDEVICE_NO_ValueChanged(object sender, EventArgs e)
        {
            ultraDEVICE_NAME.Value = ultraDEVICE_NO.Value;
        }

        private void ultraGrid7_CellChange(object sender, CellEventArgs e)
        {
            if (ultraGrid7.Rows.Count > 1 && e.Cell.Row.Index == 0)
            {
                ultraGrid7.Update();


                for (int i = 0; i < ultraGrid7.Rows.Count; i++)
                {
                        if (e.Cell.Column.Key == "ZL_TEMP_CH")
                        {
                            ultraGrid7.Rows[i].Cells["ZL_TEMP_CH"].Value = ultraGrid7.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                            ultraGrid7.Rows[i].Cells["JR_TEMP_CH"].Value = ultraGrid7.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                            ultraGrid7.Rows[i].Cells["CL_TEMP_CH"].Value = ultraGrid7.Rows[0].Cells["ZL_TEMP_CH"].Text.Trim();
                        }
                        else
                        {
                            ultraGrid7.Rows[i].Cells[e.Cell.Column.Key].Value = ultraGrid7.Rows[0].Cells[e.Cell.Column.Key].Text.Trim();
                        }
                }
            }
        }
    }
}