using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using CoreFS.SA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinTabControl;
using Infragistics.Win.UltraWinToolbars;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Windows.Forms;

namespace Core.StlMes.Client.Qcm
{

    //.............
    // 创建人： cx      创建时间：2014年12月10日 12:03:45
    //.............

    public partial class FrmProPSCMSC2 : FrmBase
    {


        //用于计算可分离容器的大小。
        private int _splitterDistance = 0;
        private bool _groupBox2ExpandedChanged = false;

        private int _splitterDistance2 = 0;
        private bool _groupBox3ExpandedChanged = false;
        private bool _isShowN = false;

        //树形结构数据源
        public Dictionary<string, UltraGrid> _dicMscStation = new Dictionary<string, UltraGrid>();
        private DataTable _dtStd_Name_Style = null; //MSC所属的标准名称和标准协议。
        private DataTable _dtMscStation = null;
        private DataTable _dtMscProcess = null;
        private DataTable _dtClient = null;

        //二级工序下拉框
        private Dictionary<string, UltraComboEditor> _dicProcessC = new Dictionary<string, UltraComboEditor>();
        private Dictionary<string, UltraComboEditor> _dicProcessCount = new Dictionary<string, UltraComboEditor>();

        //用于非查询后导航。
        public string _pscCode = "";
        public string _mscPlineCode = "";
        private List<string> _listSelectNode = new List<string>();

        //交互标准相关页面
        //private ComStandPay _standPay = null;
        private CtrlMscChem _ctrlMscChem;

        public CtrlMscChem CtrlMscChem
        {
            get { return _ctrlMscChem; }
            set { _ctrlMscChem = value; }
        }
        private CtrlMscMaterial _ctrlMscMaterial;

        public CtrlMscMaterial CtrlMscMaterial
        {
            get { return _ctrlMscMaterial; }
            set { _ctrlMscMaterial = value; }
        }
        private CtrlMSCDetection _ctrlMscDetection;

        public CtrlMSCDetection CtrlMscDetection
        {
            get { return _ctrlMscDetection; }
            set { _ctrlMscDetection = value; }
        }
        private CtrlMscTolerances _ctrlMscTolerances;

        public CtrlMscTolerances CtrlMscTolerances
        {
            get { return _ctrlMscTolerances; }
            set { _ctrlMscTolerances = value; }
        }
        private CtrlMscProductWater _ctrlMscProductWater;

        public CtrlMscProductWater CtrlMscProductWater
        {
            get { return _ctrlMscProductWater; }
            set { _ctrlMscProductWater = value; }
        }
        private CtrlMSCStdProcess _ctrlMscStdProcess;

        public CtrlMSCStdProcess CtrlMscStdProcess
        {
            get { return _ctrlMscStdProcess; }
            set { _ctrlMscStdProcess = value; }
        }

        private ctrlFileDown _ctrlFileDown;

        //冶金规范GridRow

        public ControlMsc ControlMsc
        {
            get
            {
                return controlMsc1;
            }
            set
            {
                controlMsc1 = value;
            }
        }

        private string _dimaterCp = "";

        /// <summary>
        /// 接箍弹窗中的成品外径
        /// </summary>
        public string DimaterCp
        {
            get { return _dimaterCp; }
            set { _dimaterCp = value; }
        }
        private string _heightCp = "";

        /// <summary>
        /// 接箍弹窗中的成品壁厚
        /// </summary>
        public string HeightCp
        {
            get { return _heightCp; }
            set { _heightCp = value; }
        }

        private string _specCode = "";

        /// <summary>
        /// 合同中的其它规格。
        /// </summary>
        public string SpecCode
        {
            get { return _specCode; }
            set { _specCode = value; }
        }

        private string _ordLnPk = "abc";

        /// <summary>
        /// 合同行主键
        /// </summary>
        public string OrdLnPk
        {
            get { return _ordLnPk; }
            set { _ordLnPk = value; }
        }

        private string _custAlphaNo = "";

        /// <summary>
        /// alpha码，用于弹窗
        /// </summary>
        public string CustAlphaNo
        {
            get { return _custAlphaNo; }
            set { _custAlphaNo = value; }
        }

        private string _specialDesc = "";

        /// <summary>
        /// 技术特殊要求
        /// </summary>
        public string SpecialDesc
        {
            get { return _specialDesc; }
            set { _specialDesc = value; }
        }

        private string mscUseCode = "";

        public string MscUseCode
        {
            get { return mscUseCode; }
            set { mscUseCode = value; }
        }

        private bool? _isCraft = null;

        public bool? IsCraft
        {
            get { return _isCraft; }
            set { _isCraft = value; }
        }

        /// <summary>
        /// 数据权限
        /// </summary>
        public string[] DataPurviewIds
        {
            get { return this.ValidDataPurviewIds; }
            set { this.ValidDataPurviewIds = value; }
        }


        public FrmProPSCMSC2()
        {
            InitializeComponent();
            //ExceptionHelper.RegistException();
            _ctrlMscChem = new CtrlMscChem(ultraTabPageControl4);
            _ctrlMscMaterial = new CtrlMscMaterial(ultraTabPageControl5);
            _ctrlMscDetection = new CtrlMSCDetection(ultraTabPageControl9);
            _ctrlMscTolerances = new CtrlMscTolerances(ultraTabPageControl7);
            _ctrlMscProductWater = new CtrlMscProductWater(ultraTabPageControl10);
            _ctrlMscStdProcess = new CtrlMSCStdProcess(ultraTabPageControl3);
            _ctrlMscChem.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            _ctrlMscMaterial.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            _ctrlMscDetection.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            _ctrlMscTolerances.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            _ctrlMscProductWater.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            _ctrlMscStdProcess.BeforeRowInsert += new BeforeRowInsertEventHandler(_ctrlMscMaterial_BeforeRowInsert);
            ctrlMscBl1.UltraGrid1.AfterRowActivate += ctrlMscBl1_AfterRowActivate;
        }

        public void PopupLoad(string customInfo, OpeBase ob)
        {
            this.CustomInfo = customInfo;
            this.ob = ob;
            this.OnLoad(EventArgs.Empty);
        }

        void _ctrlMscMaterial_BeforeRowInsert(object sender, BeforeRowInsertEventArgs e)
        {
            if (controlMsc1.MscRow == null || controlMsc1.MscRow.GetValue("VALIDFLAG") == "")
            {
                e.Cancel = true;
            }
        }

        private void FrmProPSCMSC2_Load(object sender, EventArgs e)
        {
            _ctrlMscChem.Ob = this.ob;
            _ctrlMscMaterial.Ob = this.ob;
            _ctrlMscDetection.Ob = this.ob;
            _ctrlMscTolerances.Ob = this.ob;
            _ctrlMscProductWater.Ob = this.ob;
            _ctrlMscStdProcess.Ob = this.ob;

            _ctrlFileDown = new ctrlFileDown();
            _ctrlFileDown.FileChangeEvent += (a =>
            {
                ultraLabel1.Text = "图片文件:" + a;
            });
            _ctrlFileDown.FileDeleteEvent += (() =>
            {
                if (controlMsc1.GridMsc.ActiveRow == null) return;
                string msc = controlMsc1.GridMsc.GetActiveRowValue("MSC");
                string path = "Qcm/Msc/Appendix/" + msc + "/";
                string fileNames = "";
                foreach (var fileBean in _ctrlFileDown.List)
                {
                    if (fileNames == "")
                    {
                        fileNames = path + fileBean.getFileName();
                    }
                    else
                    {
                        fileNames += "#" + path + fileBean.getFileName();
                    }
                }
                ((DtMsc)controlMsc1.DtBaseQcm).SaveImgPath(fileNames);
            });
            _ctrlFileDown.Dock = DockStyle.Fill;
            ultraTabPageControl2.Controls.Add(_ctrlFileDown);
            _ctrlFileDown.BringToFront();

            this.IsLoadUserView = true;
            InitUserControl();
            LoadBaseDataMscPsc();
            LoadBaseDataProcedure();
            LoadBaseDataStandPay();
            _splitterDistance = splitContainer1.SplitterDistance;
            _splitterDistance2 = splitContainer2.SplitterDistance;
            cmbProduct.AutoCompleteMode = Infragistics.Win.AutoCompleteMode.SuggestAppend;
        }

        protected override void OnLoad(EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            try
            {
                //this.IsLoadUserView = true;
                base.OnLoad(e);
                //153, 189, 250
                ultraLabel1.Appearance.BackColor = Color.FromArgb(153, 189, 250);
                //InitUserControl();
                //LoadBaseDataMscPsc();
                //LoadBaseDataProcedure();
                //LoadBaseDataStandPay();
                //_splitterDistance = splitContainer1.SplitterDistance;
                //_splitterDistance2 = splitContainer2.SplitterDistance;
                //cmbProduct.AutoCompleteMode = Infragistics.Win.AutoCompleteMode.SuggestAppend;
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void InitUserControl()
        {
            controlMsc1.FrmProPscMsc2 = this;
            controlMsc1.MscLoad();
            controlMsc1.GridMsc.AfterRowActivate += new EventHandler(GridMsc_AfterRowActivate);
            ctrlMscBl1.FrmProPscMsc2 = this;
            ctrlMscBl1.MscBlLoad();
            ctrlMscJg1.FrmProPscMsc2 = this;
            ctrlMscJg1.MscJgLoad();
        }

        void GridMsc_AfterRowActivate(object sender, EventArgs e)
        {
            ControlAuthority(controlMsc1.GridMsc.ActiveRow.Cells["VALIDFLAG"].Value.ToString());
            if (ultraTabControl3.SelectedTab.Key == "IMG")
            {
                ShowMscImg();
            }
        }

        private void ControlAuthority(string validFlag)
        {
            //if (controlMsc1.GridMsc.ActiveRow.HasParent() == false)
            //{
            //    if (validFlag == "A")
            //    {
            //        ultraToolbarsManager1.Enabled = true;
            //    }
            //    else
            //    {
            //        ultraToolbarsManager1.Enabled = false;
            //    }
            //}
            //else
            //{
            //    ultraToolbarsManager1.Enabled = true;
            //}
        }

        private void ShowMscImg()
        {
            try
            {
                ((Form)this.TopLevelControl).Cursor = Cursors.WaitCursor;
                if (controlMsc1.GridMsc.ActiveRow == null) return;
                string msc = controlMsc1.GridMsc.GetActiveRowValue("MSC");
                string path = "Qcm/Msc/Appendix/" + msc + "/";
                //string path = ((DtMsc)controlMsc1.DtBaseQcm).QueryImgPath(msc);
                //path = path.Split('#')[0];
                //if (path == "") return;
                _ctrlFileDown.FilePath = Path.GetDirectoryName(path);
                //Bitmap img = QcmFile.FileDownLoad(path);
                //picBoxAppendix.Image = img;
            }
            catch (Exception ex)
            {
                LogHelper.WriteLogs("Core.StlMes.Client.Qcm.FrmProPSCMSC2.ShowMscImg", ex.Message + ex.StackTrace);
                MessageUtil.ShowWarning(ex.Message);
            }
            finally
            {
                ((Form)this.TopLevelControl).Cursor = Cursors.Default;
            }
        }

        private void FrmProPSCMSC2_Shown(object sender, EventArgs e)
        {
            try
            {
                UltraToolbarsManager tool = toolMenu;
                ToolBase t = tool.Toolbars[0].Tools[0];
                AddToolToToolBarsManager("ckbDeleteFilter", toolMenu);
                SetMscTools();
                _isShowN = true;

                splitContainer1.SplitterDistance = 270;
            }
            catch { };
        }

        private void AddToolToToolBarsManager(string controlName, UltraToolbarsManager ultraToolbarsManager)
        {
            ControlContainerTool container = new ControlContainerTool(controlName);
            container.ControlName = controlName;
            container.Control = ckbDeleteFilter;

            ToolBase[] tools = new ToolBase[ultraToolbarsManager.Tools.Count];

            for (int i = 0; i < ultraToolbarsManager.Tools.Count; i++)
            {
                tools[i] = ultraToolbarsManager.Tools[i];
            }
            ultraToolbarsManager.Tools.Clear();
            for (int i = 0; i < tools.Length; i++)
            {
                if (tools[i].Key.ToUpper() == "CLOSE")
                {
                    ultraToolbarsManager.Tools.Add(container);
                    ultraToolbarsManager.Tools.Add(tools[i]);
                    ultraToolbarsManager.Toolbars[0].Tools.AddTool(controlName);
                    ultraToolbarsManager.Toolbars[0].Tools.AddTool(tools[i].Key);
                    ultraToolbarsManager.Toolbars[0].Tools[controlName].InstanceProps.IsFirstInGroup = true;
                    ultraToolbarsManager.Toolbars[0].Tools[tools[i].Key].InstanceProps.IsFirstInGroup = true;
                }
                else
                {
                    ultraToolbarsManager.Tools.Add(tools[i]);
                    ultraToolbarsManager.Toolbars[0].Tools.AddTool(tools[i].Key);
                    ultraToolbarsManager.Toolbars[0].Tools[tools[i].Key].InstanceProps.IsFirstInGroup = true;
                }
            }
        }

        private void SetMscTools()
        {
            if (toolMenu == null) return;
            toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["UpdateMsc"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Save"].InstanceProps.Visible = DefaultableBoolean.False;
            toolMenu.Toolbars[0].Tools["UpdateEs"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["UpdateBs"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["UpdateCs"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Resume"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Refresh"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Group"].InstanceProps.Visible = DefaultableBoolean.False;
            toolMenu.Toolbars[0].Tools["ckbDeleteFilter"].InstanceProps.Visible = DefaultableBoolean.True;
            toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
        }

        private void SetProcedureTools()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        private void SetJGTools()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["保存拧接"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["删除拧接"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        private void SetBLTools()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        private void SetStandPayTools1()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        private void SetStandPayTools2()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        //private void SetStandPayTools3()
        //{
        //    ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
        //    ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
        //    ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["取消分组"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
        //    ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
        //    ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = false;
        //    ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = true;
        //    ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = true;
        //}

        private void SetImgTools()
        {
            ultraToolbarsManager1.Toolbars[0].Tools["新增"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["修改"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["作废"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["恢复"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["分组"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["接箍码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["备料码维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["上传附件图片"].SharedProps.Visible = true;
            ultraToolbarsManager1.Toolbars[0].Tools["复制"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["粘贴"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["刷新"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["规格维护"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["复制基础MSC制程"].SharedProps.Visible = false;
            ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = false;
        }

        private void LoadBaseDataMscPsc()
        {
            QcmBaseInfo.Fill_ProducJx(cmbProduct, ob, true);
            controlMsc1.LoadBaseData();
        }

        private void LoadBaseDataStandPay()
        {
            if (ultraGrid1.ActiveRow != null && ControlMsc.MscRow != null)
            {
                string alpha = ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString();
                string psc = ultraGrid1.ActiveRow.Cells["PSC"].Value.ToString();
                _ctrlMscChem.RefreshData();
                _ctrlMscMaterial.RefreshData();
                _ctrlMscDetection.RefreshData();
                _ctrlMscTolerances.RefreshData();
                _ctrlMscProductWater.RefreshData();
                _ctrlMscStdProcess.RefreshData();

                //_standPay.RefreshChemStand(alpha, psc);
                //_standPay.RefreshComMSCStdDetection(alpha, psc);
                //_standPay.RefreshMaterialStand(alpha, psc);
                //_standPay.RefreshProductWater(alpha, psc);
                //_standPay.RefreshTolerancesStand(alpha, psc);
                //_standPay.RefreshComMSCStdProcess(alpha, psc);
            }
        }

        private void LoadBaseDataProcedure()
        {
            CreateProcessCCmb();
        }

        private void CreateProcessCCmb()
        {
            DataTable dt = MscBase_Process.QueryProcessC(this);
            DataTable dtProcess = MscBase_Process.QueryProcess(this);
            _dicProcessC.Clear();
            _dicProcessCount.Clear();
            UltraComboEditor cmbNo = new UltraComboEditor();
            cmbNo.Visible = false;
            cmbNo.DisplayStyle = Infragistics.Win.EmbeddableElementDisplayStyle.WindowsVista;
            _dicProcessC.Add("NoValue", cmbNo);
            foreach (DataRow dr in dtProcess.Rows)
            {
                DataTable dt2 = dt.Copy();
                UltraComboEditor cmb = new UltraComboEditor();
                cmb.DropDownListWidth = -1;
                string processCode = dr["PROCESS_CODE"].ToString();
                dt2.DefaultView.RowFilter = "PROCESS_CDOE = '" + processCode + "'";
                cmb.DataSource = dt2;
                cmb.ValueMember = "PROCESS_CDOE_C";
                cmb.DisplayMember = "PROCESS_DESC_C";
                cmb.Visible = false;
                ClsBaseInfo.SetComboItemHeight(cmb);
                this.Controls.Add(cmb);
                _dicProcessC.Add(processCode, cmb);

                CreateProcessCountCmb(dr);
            }

            //绑定ComboBox
            foreach (UltraGridRow row in ultraGrid5.Rows)
            {
                BindProcessCToGrid5(row);
            }
        }

        private void CreateProcessCountCmb(DataRow dr)
        {
            UltraComboEditor cmb = new UltraComboEditor();
            string processCode = dr["PROCESS_CODE"].ToString();
            DataTable dtCount = new DataTable();
            dtCount.Columns.AddRange(new DataColumn[] { new DataColumn("ID") });
            int maxCount = int.Parse(dr["MAX_COUNT"].ToString());
            for (int i = 0; i < maxCount; i++)
            {
                dtCount.Rows.Add((i + 1).ToString());
            }
            cmb.DataSource = dtCount;
            cmb.ValueMember = "ID";
            cmb.Visible = false;
            this.Controls.Add(cmb);
            _dicProcessCount.Add(processCode, cmb);
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Add":
                    Add();
                    break;
                case "UpdateMsc":
                    Update2();
                    break;
                case "UpdateBs":
                    SubmitAuditCom_Msc();
                    break;
                case "UpdateEs":
                    SubmitModify();
                    break;
                case "UpdateCs":
                    AuditCom_Msc();
                    break;
                case "SubMitAuditNk":
                    SubMitAuditNk();
                    break;
                case "AuditNk":
                    AuditNk();
                    break;
                case "SubMitModifyNk":
                    SubMitModifyNk();
                    break;
                case "Delete":
                    Deleted();
                    break;
                case "Resume":
                    Resume();
                    break;
                case "Refresh":
                    LoadBaseDataMscPsc();
                    break;
                case "Close":
                    Close2();
                    break;
            }
        }

        private void Add()
        {
            if (ultraTabControl1.SelectedTab.Key == "MSC")
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CorePscSelect.doQueryForbiddenOrder", new object[] { ControlMsc.MscRow.Cells["MSC"].Value.ToString() }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    if (Convert.ToDecimal(dt.Rows[0][0].ToString()) == 1)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion(ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "标准："+ dt.Rows[0][1].ToString() + "已禁止合同录入，请确认是否新增！") == DialogResult.No) return;
                    }
                }
                bool result = InsertCom_Msc();
                if (result == true)
                {
                    LoadBaseDataMscPsc();
                    LoadBaseDataStandPay();
                }
            }
        }

        private void Update2()
        {
            if (ultraTabControl1.SelectedTab.Key == "MSC")
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CorePscSelect.doQueryForbiddenOrder", new object[] { ControlMsc.MscRow.Cells["MSC"].Value.ToString() }, this.ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    if (Convert.ToDecimal(dt.Rows[0][0].ToString()) == 1)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion(ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "标准：" + dt.Rows[0][1].ToString() + "已禁止合同录入，请确认是否修改！") == DialogResult.No) return;
                    }
                }
                bool result = UpdateCom_Msc();
            }
        }

        private void Deleted()
        {
            switch (ultraTabControl1.SelectedTab.Key)
            {
                case "MSC":
                    bool result = DeleteCom_Msc();
                    break;
            }
        }

        private void Resume()
        {
            switch (ultraTabControl1.SelectedTab.Key)
            {
                case "MSC":
                    bool result = ResumeCom_Msc();
                    break;
            }
        }

        private void Close2()
        {
            this.Close();
        }

        private void Query()
        {
            if (AskIsDropStandPay() == true)
            {
                ClearAll();
                QueryCom_Psc();
            }
        }

        private void QueryCom_Psc()
        {
            DataTable dt = MscPsc.Query(this);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
            //GridHelper.RefreshAndAutoSize(ultraGrid1);

            //设置包含非无效的冶金规范码的行显示黄色。
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                Color defaultColor = ultraGrid1.DisplayLayout.Override.RowSelectorAppearance.BackColor;
                if (row.GetValue("HAVE_MSC") == "True")
                {
                    row.RowSelectorAppearance.BackColor = Color.Cornsilk;
                    row.RowSelectorAppearance.BackColor2 = Color.FromArgb(255, 255, 128);
                    row.RowSelectorAppearance.BackGradientStyle = GradientStyle.Vertical;
                }
                else
                {
                    row.RowSelectorAppearance.BackColor = defaultColor;
                    row.RowSelectorAppearance.BackColor2 = defaultColor;
                    row.RowSelectorAppearance.BackGradientStyle = GradientStyle.Vertical;
                }
            }
            //ultraGrid1.DisplayLayout.Bands[0].Override.RowSelectorAppearance.BackColor = Color.FromArgb(255,255,128);
        }

        private void QueryCom_Msc()
        {
            ControlMsc.Query();
        }

        private void QueryTreeViewData()
        {
            _dtStd_Name_Style = MscBase_Std.Query(this);
            _dtMscProcess = MscBase_Process.QueryMscProcess(this);
            _dtMscStation = MscMsc_Station.Query(this);
            _dtClient = MscStd_R_Cust.Query(this);
        }

        public void QueryCom_Msc_BackLog()
        {
            DataTable dt = MscMsc_BackLog.Query(this);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable4, true);
            GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid4, "AUTO_CRAFT");
            _dicMscStation.Clear();
            WriteTxtToGrid4Button();
        }

        public void QueryCom_Base_Process()
        {
            DataTable dt = MscBase_Process.Query(this);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable5, true);
        }

        public void RefreshMscProcess()
        {
            MscBase_Process.RefreshMscProcess(this);
        }

        private void QueryGrade(string msc, string msc_Pline)
        {
            dataTable2.Clear();
            dataTable1.Clear();
            ArrayList list = new ArrayList();
            list.Add(msc);
            list.Add(msc_Pline);
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC2.queryGrade",
                new Object[] { list }, ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, false);

            foreach (var row in ultraGrid7.Rows)
            {
                row.Cells["DELETE"].Value = "删除";
            }

            list.Add(msc);
            list.Add(msc_Pline);
            DataTable dt2 = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC2.queryGradeRSpec",
                new object[] { list }, ob);
            GridHelper.CopyDataToDatatable(ref dt2, ref dataTable2, false);
            WriteTxtToGrid7Button();
            GridHelper.RefreshAndAutoSize(ultraGrid7);
        }

        public void QueryJG_PL()
        {
            try
            {
                ((Form)ultraTabControl3.TopLevelControl).Cursor = Cursors.WaitCursor;
                if (ultraTabControl3.SelectedTab.Key == "JG")
                {
                    ctrlMscJg1.Query();
                }
                else
                {
                    ctrlMscBl1.Query();
                }
            }
            finally
            {
                ((Form)ultraTabControl3.TopLevelControl).Cursor = Cursors.Default;
            }

        }

        private void QueryMscRJg()
        {
            ControlMsc.QueryMscRJg();
        }

        private void QueryStandPay(string standPayName)
        {
            if (ultraGrid1.ActiveRow == null && ControlMsc.MscRow == null) return;
            ((Form)ultraTabControl3.TopLevelControl).Cursor = Cursors.WaitCursor;
            ultraTabControl1.Tabs["MSC"].Selected = true;
            ultraTabControl3.Tabs["STAND_PAY"].Selected = true;
            switch (standPayName)
            {
                case "成分标准":
                    ultraTabControl2.Tabs["ChemStand"].Selected = true;
                    break;
                case "理化标准":
                    ultraTabControl2.Tabs["MaterialStand"].Selected = true;
                    break;
                case "公差标准":
                    ultraTabControl2.Tabs["TolerancesStand"].Selected = true;
                    break;
                case "探伤标准":
                    ultraTabControl2.Tabs["ComMSCStdDetection"].Selected = true;
                    break;
                case "水压标准":
                    ultraTabControl2.Tabs["ProductWater"].Selected = true;
                    break;
                case "加工标准":
                    ultraTabControl2.Tabs["ComMSCStdProcess"].Selected = true;
                    break;
            }
            ((Form)ultraTabControl3.TopLevelControl).Cursor = Cursors.Default;
        }

        private void WriteTxtToGrid4Button()
        {
            foreach (UltraGridRow row in ultraGrid4.Rows)
            {
                row.Cells["BTN1"].Value = "维护";
                row.Cells["BTN1"].Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
            }
            ultraGrid4.UpdateData();
        }

        private void WriteTxtToGrid7Button()
        {
            foreach (UltraGridRow row in ultraGrid7.Rows)
            {
                row.SetValue("BTN", "维护");
                row.Cells["BTN"].Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
            }
            ultraGrid7.UpdateData();
        }

        private bool InsertCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.Add();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.Add);
                LoadBaseDataMscPsc();
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private void InsertComMscBackLog()
        {
            bool result = MscMsc_BackLog.Insert(this);

            if (result == true)
            {
                SaveGrid4Code();
                SaveTreeViewNode();

                _dicMscStation.Clear();
                QueryCom_Msc_BackLog();
                MoveToGrid4OldSite("Insert");
                QueryCom_Base_Process();
                RefreshMscProcess();
                LoadDataToTree();
                DisplayProcessPath();
                MoveToTreeViewOldSite();
            }
        }

        private bool UpdateCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.Modify();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.Modify);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private void UpdateComMscBackLog()
        {
            bool result = MscMsc_BackLog.Update(this);

            if (result == true)
            {
                SaveGrid4Code();
                SaveTreeViewNode();

                lblStationPath.Text = "";
                _dicMscStation.Clear();
                QueryTreeViewData();
                LoadDataToTree();
                QueryCom_Msc_BackLog();
                QueryCom_Base_Process();
                RefreshMscProcess();
                MoveToGrid4OldSite("");
                MoveToTreeViewOldSite();
            }
        }

        private bool DeleteCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.Delete();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.Delete);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool ResumeCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.Resume();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.Resume);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool AuditCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.Audit();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.FillMsc();
                ControlMsc.MoveToGrid2OldSite(ActionType.Audit);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool SubmitAuditCom_Msc()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.SubMitAudit();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.SubMitAudit);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool SubmitModify()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.SubMitModify();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.SubMitModify);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool SubMitAuditNk()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.SubMitAuditNk();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.SubMitAudit2);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool SubMitModifyNk()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.SubMitModifyNk();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.SubMitModify2);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool AuditNk()
        {
            ControlMsc.SaveGrid2Code();
            bool result = ControlMsc.AuditNk();
            if (result == true)
            {
                QueryCom_Msc();
                ControlMsc.MoveToGrid2OldSite(ActionType.SubMitModify2);
                QueryTreeViewData();
                LoadDataToTree();
            }
            return result;
        }

        private bool DeleteComMscBackLog()
        {
            bool result = MscMsc_BackLog.Delete(this);
            if (result == true)
            {
                QueryCom_Msc_BackLog();
            }
            return result;
        }

        private bool ResumeComMscBackLog()
        {
            bool result = MscMsc_BackLog.Resume(this);
            if (result == true)
            {
                QueryCom_Msc_BackLog();
            }
            return result;
        }

        private void SaveGrid4Code()
        {
            if (ultraGrid4.ActiveRow != null)
            {
                _mscPlineCode = ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString();
            }
            else
            {
                _mscPlineCode = "NoValue";
            }
        }

        private void SaveTreeViewNode()
        {
            //int level = treeMsc.SelectedNode.Level;
            //string name = treeMsc.SelectedNode.Name;
            //_listSelectNode.IndexOf(name, level);
        }

        private void MoveToGrid4OldSite(string strAction)
        {
            if (strAction == "Insert")
            {
                DataRow[] drs = dataTable4.Select("CREATE_NAME = '" + UserInfo.GetUserName() + "'", "MSC_PLINE DESC");
                if (drs.Length > 0)
                {
                    string msc_Pline = drs[0]["MSC_PLINE"].ToString();
                    UltraGridRow[] rows = GridHelper.GetRowsWithKey(ultraGrid4,
                            new string[] { "MSC_PLINE" }, new string[] { msc_Pline });
                    if (rows.Length > 0)
                    {
                        rows[0].Activate();
                    }
                }
            }
            else
            {
                UltraGridRow[] rows = GridHelper.GetRowsWithKey(ultraGrid4,
                                new string[] { "MSC_PLINE" }, new string[] { _mscPlineCode });
                if (rows.Length > 0)
                {
                    rows[0].Activate();
                }
            }
            ultraGrid4.UpdateData();
            _mscPlineCode = "";
        }

        private void MoveToTreeViewOldSite()
        {
            //TreeNode node = null;
            //for (int i = 0; i < _listSelectNode.Count; i++)
            //{
            //    if (i == 0)
            //    {
            //        node = treeMsc.Nodes[_listSelectNode[i]];
            //    }
            //    else
            //    {
            //        node = node.Nodes[_listSelectNode[i]];
            //        if (i == _listSelectNode.Count - 1)
            //        {
            //            treeMsc.SelectedNode = node;
            //        }
            //    }
            //}
        }

        public void LoadDataToTree()
        {
            QueryTreeViewData();
            DisplayMsc();
            treeMsc.ImageList = new ImageList();
            treeMsc.ImageList.Images.Add("img1", Properties.Resources._02);
            treeMsc.ImageList.Images.Add("img2", Properties.Resources._03);
            treeMsc.Nodes.Clear();
            if (ControlMsc.GridMsc.ActiveRow == null) return;
            treeMsc.BeginUpdate();
            LoadClientToTree();
            LoadStdName_StyleToTree();
            LoadMscBackLogToTree();
            treeMsc.EndUpdate();

            //没业务含义，仅用来使树形结构的Scroll显示正常。
            if (treeMsc.Nodes.Count > 0)
            {
                TreeNode node = new TreeNode(" ");
                node.Name = "ForAutoScroll";
                treeMsc.Nodes[treeMsc.Nodes.Count - 1].Nodes.Add(node);
                treeMsc.Nodes[treeMsc.Nodes.Count - 1].Expand();
                treeMsc.Nodes[treeMsc.Nodes.Count - 1].Collapse();
                treeMsc.Nodes[treeMsc.Nodes.Count - 1].Nodes.Remove(node);
                treeMsc.Update();
            }
        }

        private void LoadClientToTree()
        {
            if (ControlMsc.MscRow == null) return;
            if (ControlMsc.MscRow.Cells["OLD_USE_CODE"].Value == null || ControlMsc.MscRow.Cells["OLD_USE_CODE"].Value.ToString() == "")
            {
                return;
            }
            TreeNode node = new TreeNode("客户");
            node.ImageKey = "img1";
            node.SelectedImageKey = "img1";
            node.Name = "CLIENT";
            node.Tag = "Client";
            treeMsc.Nodes.Add(node);
            foreach (DataRow dr in _dtClient.Rows)
            {
                TreeNode node2 = new TreeNode(dr["CUST_NAME"].ToString());
                node2.ImageKey = "img2";
                node2.SelectedImageKey = "img2";
                node2.Name = "CUST_CODE";
                node.Nodes.Add(node2);
            }
        }

        private void LoadStdName_StyleToTree()
        {
            LoadStdName_StyleToTree1(treeMsc.Nodes);
            //LoadStdName_StyleToTree2(treeMsc.Nodes);
        }

        private void LoadStdName_StyleToTree1(TreeNodeCollection nodes)
        {
            DataTable mscItem = ClsBaseInfo.GetComBaseInfo("4030", ob);
            foreach (DataRow row in mscItem.Rows)
            {
                string name = row["BASENAME"].ToString();
                string code = row["BASECODE"].ToString();
                if (nodes.ContainsKey(name)) continue;
                TreeNode node = new TreeNode(name);
                node.ImageKey = "img1";
                node.SelectedImageKey = "img1";
                node.Name = code;
                node.Tag = "MscItem";
                nodes.Add(node);
            }
        }

        private void LoadStdName_StyleToTree2(TreeNodeCollection nodes)
        {
            foreach (TreeNode subNode in nodes)
            {
                if (_dtStd_Name_Style != null && _dtStd_Name_Style.Rows.Count > 0
                     && subNode.Tag != null && subNode.Tag.ToString() == "MscItem")
                {
                    string stdName = _dtStd_Name_Style.Rows[0]["STD_NAME"].ToString();
                    string stdStyleName = _dtStd_Name_Style.Rows[0]["STD_STYLE_NAME"].ToString();
                    string codeStdNameStyle = stdName + (stdStyleName == "" ? "" : "-" + stdStyleName);
                    TreeNode node = new TreeNode(codeStdNameStyle);
                    node.ImageKey = "img2";
                    node.SelectedImageKey = "img2";
                    node.Name = "";
                    subNode.Nodes.Add(node);
                }

                if (ControlMsc.MscRow != null && subNode.Tag != null
                        && subNode.Tag.ToString() == "MscItem")
                {
                    string alpha = ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString();
                    if (alpha != "")
                    {
                        TreeNode node = new TreeNode("Alpha");
                        node.ImageKey = "img2";
                        node.SelectedImageKey = "img2";
                        node.Name = "";
                        subNode.Nodes.Add(node);
                    }
                }
            }
        }

        private void LoadMscItemToTree()
        {
            var nodes = treeMsc.Nodes;
            DataTable mscItem = ClsBaseInfo.GetComBaseInfo("4030", ob);
            foreach (DataRow row in mscItem.Rows)
            {
                string name = row["BASENAME"].ToString();
                string code = row["BASECODE"].ToString();
                if (nodes.ContainsKey(name)) continue;
                TreeNode node = new TreeNode(name);
                node.ImageKey = "img1";
                node.SelectedImageKey = "img1";
                node.Name = code;
                node.Tag = "MscItem";
                nodes.Add(node);
            }

            //DataTable dtItem = (DataTable)ControlMscItem.UltCmbMscItem.DataSource;
            //foreach (DataRow row in ControlMscItem.DataTableMscItem.Rows)
            //{
            //    if (row["VALIDFLAG"].ToString() == "0") continue;

            //    string codeItem = row["ITEM"].ToString(); //BASENAME
            //    string codeItemC = row["ITEM_C"].ToString();
            //    if (treeMsc.Nodes.ContainsKey(codeItem) == false)
            //    {
            //        string nameItem = "";
            //        DataRow[] rowsItem = dtItem.Select("BASECODE = '" + codeItem + "'");
            //        if (rowsItem.Length == 0)
            //        {
            //            continue;
            //        }
            //        nameItem = rowsItem[0]["BASENAME"].ToString();
            //        TreeNode nodeMscItem = new TreeNode(nameItem);
            //        nodeMscItem.ImageKey = "img1";
            //        nodeMscItem.SelectedImageKey = "img1";
            //        nodeMscItem.Name = codeItem;
            //        nodeMscItem.Tag = "MscItem";
            //        treeMsc.Nodes.Add(nodeMscItem);

            //        if (ControlMscItem.UltCmbDic_ItemC.ContainsKey(codeItem) == false) continue;
            //        DataTable dtItemC = (DataTable)ControlMscItem.UltCmbDic_ItemC[codeItem].DataSource;
            //        string nameItemC = "";
            //        DataRow[] rowsItemC	= dtItemC.Select("BASECODE = '" + codeItemC + "'");
            //        if(rowsItemC.Length == 0)
            //        {
            //            continue;
            //        }
            //        nameItemC = rowsItemC[0]["BASENAME"].ToString();
            //        TreeNode nodeMscItemC = new TreeNode(nameItemC);
            //        nodeMscItemC.ImageKey = "img2";
            //        nodeMscItemC.SelectedImageKey = "img2";
            //        nodeMscItemC.Name = codeItemC;
            //        nodeMscItem.Nodes.Add(nodeMscItemC);

            //    }
            //    else
            //    {
            //        if (ControlMscItem.UltCmbDic_ItemC.ContainsKey(codeItem) == false) continue;
            //        DataTable dtItemC = (DataTable)ControlMscItem.UltCmbDic_ItemC[codeItem].DataSource;
            //        string nameItemC = "";
            //        DataRow[] rows = dtItemC.Select("BASECODE = '" + codeItemC + "'");
            //        if(rows.Length == 0)
            //        {
            //            continue;
            //        }
            //        nameItemC = rows[0]["BASENAME"].ToString();
            //        TreeNode nodeMscItemC = new TreeNode(nameItemC);
            //        nodeMscItemC.ImageKey = "img2";
            //        nodeMscItemC.SelectedImageKey = "img2";
            //        nodeMscItemC.Name = codeItemC;
            //        treeMsc.Nodes[codeItem].Nodes.Add(nodeMscItemC);
            //    }
            //}
        }

        private void LoadMscBackLogToTree()
        {
            AddMscBackLogNode1(treeMsc.Nodes);
            AddMscBackLogNode2(treeMsc.Nodes);
            AddMscBackLogNode3(treeMsc.Nodes);
        }

        private void AddMscBackLogNode1(TreeNodeCollection nodes)
        {
            foreach (DataRow dr in dataTable4.Rows)
            {
                TreeNode node = new TreeNode("全程途径产线号" + dr["MSC_PLINE"].ToString());
                node.ImageKey = "img1";
                node.SelectedImageKey = "img1";
                node.Name = dr["MSC_PLINE"].ToString();
                node.Tag = "MscPline";
                nodes.Add(node);
            }
        }

        private void AddMscBackLogNode2(TreeNodeCollection nodes)
        {
            if (_dtMscProcess == null) return;
            foreach (DataRow dr in _dtMscProcess.Rows)
            {
                TreeNode node = new TreeNode(dr["PROCESS_DESC"].ToString());
                node.ImageKey = "img2";
                node.SelectedImageKey = "img2";
                node.Name = dr["PROCESS_CODE"].ToString();
                string msc_Pline = dr["MSC_PLINE"].ToString();
                if (nodes.ContainsKey(msc_Pline) == false) continue;
                nodes[msc_Pline].Nodes.Add(node);
            }
        }

        private void AddICToNode(TreeNodeCollection nodes, string iC, DataRow dr)
        {
            foreach (string str in dr[iC].ToString().Split(','))
            {
                if (str == "") return;
                TreeNode node = new TreeNode(str);
                node.ImageKey = "img2";
                node.SelectedImageKey = "img2";
                node.Name = str;
                node.Tag = iC;
                string msc_Pline = dr["MSC_PLINE"].ToString();
                string process_Code = dr["PROCESS_CODE"].ToString();
                if (nodes.ContainsKey(msc_Pline) == false) continue;
                if (nodes[msc_Pline].Nodes.ContainsKey(process_Code) == false) continue;
                nodes[msc_Pline].Nodes[process_Code].Nodes.Add(node);
            }
        }

        private void AddMscBackLogNode3(TreeNodeCollection nodes)
        {
            //添加内控标准
            foreach (DataRow dr in _dtMscProcess.Rows)
            {
                AddICToNode(nodes, "CIC", dr);
                AddICToNode(nodes, "PIC", dr);
                AddICToNode(nodes, "SIC", dr);
                AddICToNode(nodes, "DIC", dr);
                AddICToNode(nodes, "WIC", dr);
                AddICToNode(nodes, "GIC", dr);
            }

            //添加工序点
            if (_dtMscStation == null) return;
            foreach (DataRow dr in _dtMscStation.Rows)
            {
                TreeNode node = new TreeNode(dr["STATION_DESC"].ToString());
                node.ImageKey = "img2";
                node.SelectedImageKey = "img2";
                node.Name = dr["STATION_CODE"].ToString();
                string msc_Pline = dr["MSC_PLINE"].ToString();
                string process_Code = dr["PROCESS_CODE"].ToString();
                if (nodes.ContainsKey(msc_Pline) == false) continue;
                if (nodes[msc_Pline].Nodes.ContainsKey(process_Code) == false) continue;
                nodes[msc_Pline].Nodes[process_Code].Nodes.Add(node);
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.WaitCursor;
            ClearAll();
            QueryCom_Msc();
            QueryMscRJg();
            ControlMsc.FillMsc();
            ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.Default;
        }

        private void ClearAll()
        {
            ControlMsc.DataTableMscRJg.Clear();
            ControlMsc.DataTableMsc.Clear();
            ctrlMscJg1.DtJG.Clear();
            ctrlMscJg1.DtBL.Clear();
            ctrlMscBl1.DataTableBl.Clear();
            treeMsc.Nodes.Clear();
            dataTable4.Clear();
            dataTable5.Clear();
            _dicMscStation.Clear();
            dataTable2.Clear();
            dataTable1.Clear();
            ClearStandPay();
            lblMsc.Text = "";
            lblStationPath.Text = "";
        }

        public void HiddenTabWithStyle()
        {
            if (ControlMsc.GridMsc.ActiveRow.HasParent() == false)
            {
                string mscStyle = ControlMsc.MscRow.Cells["MSC_STYLE"].Value.ToString();
                if (mscStyle == "A")
                {
                    ultraTabControl3.Tabs["JG"].Visible = false;
                    ultraTabControl3.Tabs["BL"].Visible = false;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = true;
                    ultraTabControl3.Tabs["IMG"].Visible = false;
                }
                else if (mscStyle == "B")
                {
                    ultraTabControl3.Tabs["JG"].Visible = true;
                    ultraTabControl3.Tabs["BL"].Visible = false;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = true;
                    ultraTabControl3.Tabs["IMG"].Visible = false;
                }
                else if (mscStyle == "C")
                {
                    ultraTabControl3.Tabs["JG"].Visible = true;
                    ultraTabControl3.Tabs["BL"].Visible = true;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = false;
                    ultraTabControl3.Tabs["IMG"].Visible = true;
                }
                else if (mscStyle == "D")
                {
                    ultraTabControl3.Tabs["JG"].Visible = true;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = false;
                    ultraTabControl3.Tabs["BL"].Visible = false;
                    ultraTabControl3.Tabs["IMG"].Visible = false;
                }
                else if (mscStyle == "E")
                {
                    ultraTabControl3.Tabs["JG"].Visible = false;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = false;
                    ultraTabControl3.Tabs["BL"].Visible = true;
                    ultraTabControl3.Tabs["IMG"].Visible = false;
                }
                else
                {
                    ultraTabControl3.Tabs["JG"].Visible = true;
                    ultraTabControl3.Tabs["BL"].Visible = true;
                    ultraTabControl3.Tabs["STAND_PAY"].Visible = true;
                    ultraTabControl3.Tabs["IMG"].Visible = false;
                }
            }
            else
            {
                ultraTabControl3.Tabs["JG"].Visible = false;
                ultraTabControl3.Tabs["BL"].Visible = false;
                ultraTabControl3.Tabs["STAND_PAY"].Visible = false;
                ultraTabControl3.Tabs["IMG"].Visible = false;
            }
        }

        private void ultraGrid2_BeforeRowInsert(object sender, BeforeRowInsertEventArgs e)
        {
            if (ultraGrid1.ActiveRow == null)
            {
                e.Cancel = true;
            }
        }

        public void ControlGridEdit(InitializeRowEventArgs e, List<string> listNoEdit, List<string> listDrop)
        {
            if (e.Row.Cells.Exists("CHK") == false) return;
            if (e.Row.Cells["CHK"].Value.ToString() == "True")
            {
                foreach (UltraGridCell cell in e.Row.Cells)
                {
                    if (cell.Column.Header.Caption == "选择") continue;
                    if (listNoEdit.Contains(cell.Column.Header.Caption))
                    {
                        cell.Activation = Activation.ActivateOnly;
                    }
                    else if (listDrop.Contains(cell.Column.Header.Caption))
                    {
                        cell.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                        cell.Activation = Activation.AllowEdit;
                    }
                    else
                    {
                        cell.Activation = Activation.AllowEdit;
                    }
                }
            }
            else
            {
                foreach (UltraGridCell cell in e.Row.Cells)
                {
                    if (cell.Column.Header.Caption == "选择") continue;
                    if (listDrop.Contains(cell.Column.Header.Caption))
                    {
                        cell.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;
                        cell.Activation = Activation.ActivateOnly;
                    }
                    else
                    {
                        cell.Activation = Activation.ActivateOnly;
                    }
                }
            }
        }

        public void SetColor(InitializeRowEventArgs e)
        {
            if (e.Row.Cells["VALIDFLAG"].Value.ToString() == "0"
                 || e.Row.Cells["VALIDFLAG"].Value.ToString() == "D")
            {
                e.Row.Appearance.ForeColor = Color.Red;
            }
            else
            {
                e.Row.Appearance.ForeColor = Color.Black;
            }
        }

        private void ultraGrid3_BeforeRowInsert(object sender, BeforeRowInsertEventArgs e)
        {
            if (ControlMsc.MscRow == null || ControlMsc.MscRow.Cells["MSC"].Value.ToString() == "")
            {
                e.Cancel = true;
            }
        }

        private void ultraGrid3_AfterRowInsert(object sender, RowEventArgs e)
        {
            string msc = ControlMsc.MscRow.Cells["MSC"].Value.ToString();
            e.Row.Cells["MSC"].Value = msc;
            //ultraGrid3.UpdateData();
            //if (ultraGrid3.Rows.Count == 1)
            //{
            //    e.Row.Cells["CHK"].Value = true;
            //    ultraGrid3.DisplayLayout.Bands[0].AddNew();
            //}

        }

        private void ultraGrid3_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key == "ITEM")
            {
                e.Cell.Row.Cells["ITEM_C"].Value = "";
            }
        }

        private void ultraExpandableGroupBox2_ExpandedStateChanged(object sender, EventArgs e)
        {
            _groupBox2ExpandedChanged = true;
            if (ultraExpandableGroupBox2.Expanded == false)
            {
                splitContainer1.SplitterDistance = 20;
            }
            else
            {
                splitContainer1.SplitterDistance = _splitterDistance;
            }
            _groupBox2ExpandedChanged = false;
        }

        private void splitContainer1_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (_groupBox2ExpandedChanged == false)
            {
                _splitterDistance = splitContainer1.SplitterDistance;
                if (splitContainer1.SplitterDistance >= 1)
                {
                    ultraExpandableGroupBox2.Expanded = true;
                }
            }

            if (SplitContainer1.Panel2Collapsed)
            {
                ultraExpandableGroupBox2.Visible = false;
            }
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            ((Form)ultraGrid4.TopLevelControl).Cursor = Cursors.WaitCursor;
            QueryCom_Base_Process();
            RefreshMscProcess();
            string msc = ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString();
            string msc_Pline = ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString();
            QueryGrade(msc, msc_Pline);
            DisplayProcessPath();
            _dicMscStation.Clear();
            ((Form)ultraGrid4.TopLevelControl).Cursor = Cursors.Default;
        }

        private void ultraGrid5_ClickCellButton(object sender, CellEventArgs e)
        {
            if (controlMsc1.GridMsc.ActiveRow == null) return;
            if (e.Cell.Row.Cells["CHK"].Value.ToString() == "True")
            {
                if (e.Cell.Column.Key == "BTN")
                {
                    if (e.Cell.Row.GetValue("PROCESS_CODE_C") == "")
                    {
                        MessageUtil.ShowWarning("请选择二级工序！");
                        e.Cell.Activate();
                        return;
                    }

                    DataTable dtMsc = GetMscTabByMsc(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), ob);
                    //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
                    //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
                    //{
                    //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！");
                    //    return;
                    //}

                    FrmPscStationSelect frmPscStationSelect;
                    try
                    {
                        ((Form)ultraGrid5.TopLevelControl).Cursor = Cursors.WaitCursor;
                        frmPscStationSelect = new FrmPscStationSelect(this, e.Cell.Row);
                    }
                    finally
                    {
                        ((Form)ultraGrid5.TopLevelControl).Cursor = Cursors.Default;
                    }

                    DialogResult result = frmPscStationSelect.ShowDialog();
                    if (result == DialogResult.OK)
                    {
                        SaveMscStation(frmPscStationSelect.ultraGridSta, e.Cell.Row.Cells["PROCESS_CODE"].Value.ToString());
                        e.Cell.Row.SetValue("PROCESS_SEQ_OLD", e.Cell.Row.GetValue("ICOUNT"));
                        e.Cell.Row.SetValue("PROCESS_CODE_C_OLD", e.Cell.Row.GetValue("PROCESS_CODE_C"));
                    }
                }
                else if (e.Cell.Column.Key == "BTN2")
                {
                    if (e.Cell.Row.Cells["CHK"].Value.ToString() == "False")
                    {
                        MessageUtil.ShowWarning("请勾选工序后，再进行内控维护！");
                        return;
                    }
                    //msc为空表示未工序为保存
                    if (e.Cell.Row.GetValue("MSC") == "")
                    {
                        MessageUtil.ShowWarning("请保存制程后，再进行内控维护！！");
                        return;
                    }
                    DataTable dtMsc = GetMscTabByMsc(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), ob);
                    //if (dtMsc.Rows[0]["UNIT_CODE_PROCESS"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
                    //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
                    //{
                    //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC_PROCESS"].ToString() + "]科室维护的，您没有权限！");
                    //    return;
                    //}
                    string processCode = e.Cell.Row.Cells["PROCESS_CODE"].Value.ToString();
                    string processName = e.Cell.Row.Cells["PROCESS_DESC"].Value.ToString();
                    string productCode = ultraGrid1.ActiveRow.GetValue("PRODUCCODE");
                    string productName = ultraGrid1.ActiveRow.GetValue("PRODUCNAME");
                    string steelCode = ultraGrid1.ActiveRow.GetValue("STEELCODE");
                    string steelName = ultraGrid1.ActiveRow.GetValue("STEELNAME");
                    string psc = ultraGrid1.ActiveRow.GetValue("PSC");
                    string msc = ultraGrid4.ActiveRow == null ? "" : ultraGrid4.ActiveRow.GetValue("MSC");
                    string mscPline = ultraGrid4.ActiveRow == null ? "" : ultraGrid4.ActiveRow.GetValue("MSC_PLINE");
                    string stdCode = ultraGrid1.ActiveRow.GetValue("STD_CODE");
                    string stdStyle = ultraGrid1.ActiveRow.GetValue("STD_STYLE");
                    ArrayList gradeList = new ArrayList();
                    ArrayList gradeNameList = new ArrayList();
                    foreach (UltraGridRow row in ultraGrid7.Rows)
                    {
                        gradeList.Add(row.Cells["GRADECODE"].Value.ToString());
                        gradeNameList.Add(row.Cells["GRADENAME"].Value.ToString());
                    }

                    StandardNChoice standardNChoice = new StandardNChoice(productCode, productName,
                        gradeList, gradeNameList, processCode, processName, msc, mscPline, steelCode, steelName,
                        stdCode, stdStyle, _ordLnPk, psc, ob);
                    AddICList(standardNChoice.Cics, ultraGrid5.ActiveRow.Cells["CIC"].Value.ToString());
                    AddICList(standardNChoice.Pics, ultraGrid5.ActiveRow.Cells["PIC"].Value.ToString());
                    AddICList(standardNChoice.Sics, ultraGrid5.ActiveRow.Cells["SIC"].Value.ToString());
                    AddICList(standardNChoice.Dics, ultraGrid5.ActiveRow.Cells["DIC"].Value.ToString());
                    AddICList(standardNChoice.Wics, ultraGrid5.ActiveRow.Cells["WIC"].Value.ToString());
                    AddICList(standardNChoice.Gics, ultraGrid5.ActiveRow.Cells["GIC"].Value.ToString());
                    standardNChoice.ShowDialog();
                    ultraGrid5.ActiveRow.Cells["CIC"].Value = GetICsFromList(standardNChoice.Cics);
                    ultraGrid5.ActiveRow.Cells["PIC"].Value = GetICsFromList(standardNChoice.Pics);
                    ultraGrid5.ActiveRow.Cells["SIC"].Value = GetICsFromList(standardNChoice.Sics);
                    ultraGrid5.ActiveRow.Cells["DIC"].Value = GetICsFromList(standardNChoice.Dics);
                    ultraGrid5.ActiveRow.Cells["WIC"].Value = GetICsFromList(standardNChoice.Wics);
                    ultraGrid5.ActiveRow.Cells["GIC"].Value = GetICsFromList(standardNChoice.Gics);
                    ultraGrid5.UpdateData();

                    //FrmStandarNSub frmStandarNSub = new FrmStandarNSub(processCode, processName, gradeList,
                    //    productCode, productName, msc, mscPline, steelCode, steelName, ob);
                    //frmStandarNSub.ob = this.ob;
                    //AddICList(frmStandarNSub.StrCics, ultraGrid5.ActiveRow.Cells["CIC"].Value.ToString());
                    //AddICList(frmStandarNSub.StrPics, ultraGrid5.ActiveRow.Cells["PIC"].Value.ToString());
                    //AddICList(frmStandarNSub.StrSics, ultraGrid5.ActiveRow.Cells["SIC"].Value.ToString());
                    //AddICList(frmStandarNSub.StrDics, ultraGrid5.ActiveRow.Cells["DIC"].Value.ToString());
                    //AddICList(frmStandarNSub.StrWics, ultraGrid5.ActiveRow.Cells["WIC"].Value.ToString());
                    //AddICList(frmStandarNSub.StrGics, ultraGrid5.ActiveRow.Cells["GIC"].Value.ToString());
                    //DialogResult result = frmStandarNSub.ShowDialog();
                    ////DataTable dtStationType = MscMsc_Station.GetStationType(msc, mscPline, processCode, ob);
                    //if (result == DialogResult.OK)
                    //{
                    //    ultraGrid5.ActiveRow.Cells["CIC"].Value = GetICsFromList(frmStandarNSub.StrCics);
                    //    ultraGrid5.ActiveRow.Cells["PIC"].Value = GetICsFromList(frmStandarNSub.StrPics);
                    //    ultraGrid5.ActiveRow.Cells["SIC"].Value = GetICsFromList(frmStandarNSub.StrSics);
                    //    ultraGrid5.ActiveRow.Cells["DIC"].Value = GetICsFromList(frmStandarNSub.StrDics);
                    //    ultraGrid5.ActiveRow.Cells["WIC"].Value = GetICsFromList(frmStandarNSub.StrWics);
                    //    ultraGrid5.ActiveRow.Cells["GIC"].Value = GetICsFromList(frmStandarNSub.StrGics);

                    //    //if (dtStationType.Select("STATION_TYPE = '403201'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["CIC"].Value = GetICsFromList(frmStandarNSub.StrCics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["CIC"].Value = "";
                    //    //}
                    //    //if (dtStationType.Select("STATION_TYPE = '403202'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["PIC"].Value = GetICsFromList(frmStandarNSub.StrPics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["PIC"].Value = "";
                    //    //}
                    //    //if (dtStationType.Select("STATION_TYPE = '403203'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["SIC"].Value = GetICsFromList(frmStandarNSub.StrSics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["SIC"].Value = "";
                    //    //}
                    //    //if (dtStationType.Select("STATION_TYPE = '403204'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["DIC"].Value = GetICsFromList(frmStandarNSub.StrDics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["DIC"].Value = "";
                    //    //}
                    //    //if (dtStationType.Select("STATION_TYPE = '403205'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["WIC"].Value = GetICsFromList(frmStandarNSub.StrWics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["WIC"].Value = "";
                    //    //}
                    //    //if (dtStationType.Select("STATION_TYPE = '403208'").Length > 0)
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["GIC"].Value = GetICsFromList(frmStandarNSub.StrGics);
                    //    //}
                    //    //else
                    //    //{
                    //    //    ultraGrid5.ActiveRow.Cells["GIC"].Value = "";
                    //    //}

                    //}
                }
                else if (e.Cell.Column.Key == "BTN3")
                {
                    if (ultraGrid4.ActiveRow == null)
                    {
                        MessageUtil.ShowWarning("新增制程后再维护工艺参数");
                        return;
                    }
                    string msc = ultraGrid4.ActiveRow.GetValue("MSC");
                    string mscPline = ultraGrid4.ActiveRow.GetValue("MSC_PLINE");
                    string processCode = ultraGrid5.ActiveRow.GetValue("PROCESS_CODE");
                    PopupMscCraft popupMscCraft = new PopupMscCraft(msc, mscPline, processCode, ob);
                    popupMscCraft.ShowDialog();
                }
            }
            else
            {
                MessageUtil.ShowWarning("请选择记录后再进行维护操作！");
            }
        }

        private void AddICList(List<string> list, string strICs)
        {
            string[] strAryICs = strICs.Split(',');
            foreach (string str in strAryICs)
            {
                list.Add(str);
            }
        }

        private string GetICsFromList(List<string> list)
        {
            string iCs = "";
            foreach (string str in list)
            {
                iCs += iCs == "" ? str : ("," + str);
            }
            return iCs;
        }

        private void ultraGrid5_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            ControlGrid5Edit(e);
            BindProcessCToGrid5(e.Row);
            e.Row.SetValue("BTN", "维护");
            e.Row.SetValue("BTN2", "维护");
            e.Row.SetValue("BTN3", "维护");
        }

        private void ControlGrid5Edit(InitializeRowEventArgs e)
        {
            List<string> listNoEdit = new List<string>();
            listNoEdit.Add("工序点维护");
            listNoEdit.Add("工序点代码");
            listNoEdit.Add("工序名称");
            listNoEdit.Add("工序顺序号");
            listNoEdit.Add("工序类型");
            listNoEdit.Add("生产");
            listNoEdit.Add("等待");
            listNoEdit.Add("批量等待");
            List<string> listDrop = new List<string>();
            listDrop.Add("二级工序");
            listDrop.Add("工序循环次数");
            ControlGridEdit(e, listNoEdit, listDrop);
        }

        private void BindProcessCToGrid5(UltraGridRow row)
        {
            string processCode = row.GetValue("PROCESS_CODE");
            if (_dicProcessC.ContainsKey(processCode))
            {
                row.Cells["PROCESS_CODE_C"].EditorComponent = _dicProcessC[processCode];
            }
            else if (_dicProcessC.ContainsKey("NoValue"))
            {
                row.Cells["PROCESS_CODE_C"].EditorComponent = _dicProcessC["NoValue"];
            }
            if (_dicProcessCount.ContainsKey(processCode))
            {
                row.Cells["ICOUNT"].EditorComponent = _dicProcessCount[processCode];
            }
            else if (_dicProcessC.ContainsKey("NoValue"))
            {
                row.Cells["ICOUNT"].EditorComponent = _dicProcessC["NoValue"];
            }
        }

        private void SaveMscStation(UltraGrid ultraGridSta, string process_Code)
        {
            ultraGridSta.UpdateData();
            if (_dicMscStation.ContainsKey(process_Code))
            {
                _dicMscStation[process_Code] = ultraGridSta;
            }
            else
            {
                _dicMscStation.Add(process_Code, ultraGridSta);
            }

        }

        private void treeMsc_AfterSelect(object sender, TreeViewEventArgs e)
        {
            //e.Action == TreeViewAction.
            if (e.Node.Tag == null) return;
            string tag = e.Node.Tag.ToString();
            if (tag == "MscPline")
            {
                ultraTabControl1.Tabs["MSC"].Selected = true;
                ultraTabControl3.Tabs["PROCEDURE"].Selected = true;
                UltraGridRow[] rows = GridHelper.GetRowsWithKey(ultraGrid4,
                    new string[] { "MSC_PLINE" }, new string[] { e.Node.Name });
                if (rows.Length > 0)
                {
                    rows[0].Activate();
                }
            }
            else if (tag == "MscItem")
            {
                if (ultraTabControl3.Tabs["STAND_PAY"].Visible == false) return;
                QueryStandPay(e.Node.Text);
            }
            else if (tag == "CIC" || tag == "PIC" || tag == "SIC" || tag == "DIC" || tag == "WIC" || tag == "GIC")
            {
                ShowStandPayN(e);
            }
            treeMsc.SelectedNode = null;
        }

        private void ShowStandPayN(TreeViewEventArgs e)
        {
            string tag = e.Node.Tag.ToString();
            if (tag == "CIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "ChemStand", ob);
                mscStandPayN.ShowDialog();
            }
            else if (tag == "PIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "MaterialStand", ob);
                mscStandPayN.ShowDialog();
            }
            else if (tag == "SIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "TolerancesStand", ob);
                mscStandPayN.ShowDialog();
            }
            else if (tag == "DIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "ComMSCStdDetection", ob);
                mscStandPayN.ShowDialog();
            }
            else if (tag == "WIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "ProductWater", ob);
                mscStandPayN.ShowDialog();
            }
            else if (tag == "GIC")
            {
                MscStandPayN mscStandPayN = new MscStandPayN(e.Node.Name, "ComMSCStdProcess", ob);
                mscStandPayN.ShowDialog();
            }
        }

        private static DataTable GetMscTabByMsc(string msc, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC2.getComMscByMsc",
                new object[] { msc }, ob);
            return dt;
        }

        private void ultraGrid4_ClickCellButton(object sender, CellEventArgs e)
        {
            if (ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString() == "")
            {
                MessageUtil.ShowWarning("请先新增该制程后，再进行维护！");
                return;
            }
            string msc = controlMsc1.ultraGrid2.ActiveRow.HasParent() ? controlMsc1.ultraGrid2.ActiveRow.ParentRow.GetValue("MSC") :
                controlMsc1.ultraGrid2.ActiveRow.GetValue("MSC");
            DataTable dtMsc = GetMscTabByMsc(msc, ob);


            if (e.Cell.Column.Key == "BTN1")
            {
                if (ultraGrid4.GetActiveRowValue("VALIDFLAG") == "1")
                {
                    //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
                    //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
                    //{
                    //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！");
                    //    return;
                    //}

                    EditGrade();
                    EditGradeRSpec();
                }
                else
                {
                    MessageUtil.ShowWarning("只有录入状态的制程，才能进行钢种维护！");
                    return;
                }
            }
            else if (e.Cell.Column.Key == "BTN2")
            {
                //if (dtMsc.Rows[0]["UNIT_CODE_PROCESS"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
                //&& CoreUserInfo.UserInfo.GetUserID() != "admin")
                //{
                //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC_PROCESS"].ToString() + "]科室维护的，您没有权限！");
                //    return;
                //}

                //string mscPline = ultraGrid4.GetActiveRowValue("MSC_PLINE");
                //PopupMscCraft popup = new PopupMscCraft(e.Cell.Row.GetValue("MSC"), mscPline, ob);
                //popup.ShowDialog();
            }
            else if (e.Cell.Column.Key == "COPY_MSC_PLINE")
            {
                controlMsc1.CopyMsc = msc;
                CopyMscPline = ultraGrid4.GetActiveRowValue("MSC_PLINE");
            }
        }

        private void EditGrade()
        {
            string msc = ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString();
            string msc_Pline = ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString();

            PopupProductGrade popupGrade;
            try
            {
                ((Form)ultraGrid4.TopLevelControl).Cursor = Cursors.WaitCursor;
                popupGrade = new PopupProductGrade(msc, msc_Pline, ob);
            }
            finally
            {
                ((Form)ultraGrid4.TopLevelControl).Cursor = Cursors.Default;
            }

            DialogResult result = popupGrade.ShowDialog();
            if (result == DialogResult.OK)
            {
                QueryGrade(msc, msc_Pline);
            }
        }

        private void EditGradeRSpec()
        {
            string msc = ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString();
            string msc_Pline = ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString();
            PopupGrandeRSpec popupGradeRSpec = new PopupGrandeRSpec(msc, msc_Pline, "", ob);
            DialogResult result = popupGradeRSpec.ShowDialog();
            QueryGrade(msc, msc_Pline);
        }

        private void EditJGCode()
        {
            string msc = ControlMsc.MscRow.Cells["MSC"].Value.ToString();
            string msc_desc = ControlMsc.MscRow.Cells["OLD_MSC_DESC"].Value.ToString();
            string alpha = ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString();
            string stdName = ultraGrid1.ActiveRow.Cells["STD_NAME"].Value.ToString();
            string stdCode = ultraGrid1.ActiveRow.Cells["STD_CODE"].Value.ToString();
            string stdType = ultraGrid1.ActiveRow.Cells["STD_STYLE_DESC"].Value.ToString();
            string steel = ultraGrid1.ActiveRow.Cells["STEELNAME"].Value.ToString();
            string steelCode = ultraGrid1.GetActiveRowValue("STEELCODE");
            string psc = ultraGrid1.ActiveRow.Cells["PSC"].Value.ToString();

            JGCodeManage jgcm;
            try
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.WaitCursor;
                jgcm = new JGCodeManage(ob, msc, msc_desc, alpha, stdName, stdCode, stdType, steel,
                _dimaterCp, _heightCp, _custAlphaNo, _specialDesc, _ordLnPk, steelCode);
            }
            finally
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.Default;
            }
            DialogResult result = jgcm.ShowDialog();

            QueryJG_PL();
            QueryMscRJg();
        }

        private void EditBLCode()
        {
            string msc = ControlMsc.MscRow.Cells["MSC"].Value.ToString();
            string msc_desc = ControlMsc.MscRow.Cells["OLD_MSC_DESC"].Value.ToString();
            string alpha = ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString();
            string stdName = ultraGrid1.ActiveRow.Cells["STD_NAME"].Value.ToString();
            string stdType = ultraGrid1.ActiveRow.Cells["STD_STYLE_DESC"].Value.ToString();
            string steel = ultraGrid1.ActiveRow.Cells["STEELCODE"].Value.ToString();

            BLCodeManage blcm;
            try
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.WaitCursor;
                BLCodeManageParms blCodeParms = new BLCodeManageParms();
                blCodeParms.Ob = ob;
                blCodeParms.Msc = msc;
                blCodeParms.Msc_desc = msc_desc;
                blCodeParms.Alpha = alpha;
                blCodeParms.StdName = stdName;
                blCodeParms.StdType = stdType;
                blCodeParms.Steels = new string[] { steel };
                blCodeParms.SaveType = "3";
                blCodeParms.Dimater = _dimaterCp;
                blCodeParms.Height = _heightCp;
                blCodeParms.SpecCode = _specCode;
                blCodeParms.OrdLnPk = _ordLnPk;
                blcm = new BLCodeManage(blCodeParms);
            }
            finally
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.Default;
            }

            //blcm.Size = this.Size;
            DialogResult result = blcm.ShowDialog();

            if (result == DialogResult.OK)
            {
                QueryJG_PL();
            }
        }

        public void DisplayProcessPath()
        {
            lblStationPath.Text = "";
            if (ultraGrid4.ActiveRow == null) return;
            if (_dtMscProcess == null) return;
            if (_dtMscStation == null) return;

            DataRow[] drs = _dtMscProcess.Select("MSC = '" + ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString() + "'"
                                + " AND MSC_PLINE = '" + ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString() + "'");
            List<int[]> descList = new List<int[]>();
            int current = 0;
            int rowNum = 0;
            int width = 0;
            foreach (DataRow proRow in drs)
            {

                DataRow[] drs2 = _dtMscStation.Select("MSC = '" + ultraGrid4.ActiveRow.Cells["MSC"].Value.ToString() + "'"
                                    + " AND MSC_PLINE = '" + ultraGrid4.ActiveRow.Cells["MSC_PLINE"].Value.ToString() + "'"
                                    + " AND PROCESS_CODE = '" + proRow["PROCESS_CODE"].ToString() + "'");

                foreach (DataRow drSta in drs2)
                {
                    //string stationDesc = "<span style=\"color:#3366ff;\">"
                    //+ drSta["STATION_DESC"].ToString() + "</span>";
                    string stationDesc = drSta["STATION_DESC"].ToString();
                    if (lblStationPath.Text == "")
                    {
                        //lblStationPath.Value += stationDesc;
                        ////width = drSta["STATION_DESC"].ToString().Length * 2 * 7;
                        //width = TextRenderer.MeasureText(drSta["STATION_DESC"].ToString(), new Font("宋体", 12)).Width;
                        lblStationPath.Text += stationDesc;
                        descList.Add(new int[] { current, stationDesc.Length });
                        current += stationDesc.Length;
                    }
                    else
                    {
                        //width += TextRenderer.MeasureText("->" + drSta["STATION_DESC"].ToString(), new Font("宋体", 12)).Width;
                        //if (width / lblStationPath.Width <= rowNum)
                        //{
                        //    lblStationPath.Value += "->" + stationDesc;
                        //}
                        //else
                        //{
                        //    lblStationPath.Value += "->" + stationDesc + "<br/>";
                        //    rowNum++;
                        //}

                        lblStationPath.Text += "->" + stationDesc;
                        current += 2;
                        descList.Add(new int[] { current, stationDesc.Length });
                        current += stationDesc.Length;
                    }



                }
            }

            foreach (int[] select in descList)
            {
                lblStationPath.Select(select[0], select[1]);
                lblStationPath.SelectionColor = Color.Blue;
                lblStationPath.SelectionFont = new Font("宋体", 12);
                if (select[0] != 0)
                {
                    lblStationPath.Select(select[0] - 2, 2);
                    lblStationPath.SelectionColor = Color.Black;
                    lblStationPath.SelectionFont = new Font("宋体", 12);
                }
            }

            if (lblStationPath.Text == "")
            {
                lblStationPath.Text = "无";
            }
        }

        private void DisplayMsc()
        {
            if (ControlMsc.MscRow == null || ControlMsc.MscRow.Cells["MSC"].Value == null)
            {
                lblMsc.Text = "";
                return;
            }
            lblMsc.Text = ControlMsc.MscRow.Cells["MSC"].Value.ToString();
        }

        private void ultraGrid4_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            SetColor(e);
        }

        private void DisplayStandPay_ChemStand()
        {
            //_standPay.LoadStandPay("1", "ChemStand");
            //if (ControlMsc.MscRow == null)
            //{
            //    _standPay.LoadStandPay("1", "ChemStand");
            //}
            //else
            //{
            //    if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //    {
            //        _standPay.LoadStandPay("1", "ChemStand");
            //    }
            //    else
            //    {
            //        _standPay.LoadStandPay("3", "ChemStand");
            //    }
            //}
        }

        private void DisplayStandPay_MaterialStand()
        {
            //_standPay.LoadStandPay("1", "MaterialStand");
            //if (ControlMsc.MscRow == null)
            //{
            //    _standPay.LoadStandPay("1", "MaterialStand");
            //}
            //else
            //{
            //    if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //    {
            //        _standPay.LoadStandPay("1", "MaterialStand");
            //    }
            //    else
            //    {
            //        _standPay.LoadStandPay("3", "MaterialStand");
            //    }
            //}
        }

        private void DisplayStandPay_TolerancesStand()
        {
            //_standPay.LoadStandPay("1", "TolerancesStand");
            //if (ControlMsc.MscRow == null)
            //{
            //    _standPay.LoadStandPay("1", "TolerancesStand");
            //}
            //else
            //{
            //    if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //    {
            //        _standPay.LoadStandPay("1", "TolerancesStand");
            //    }
            //    else
            //    {
            //        _standPay.LoadStandPay("3", "TolerancesStand");
            //    }
            //}
        }

        private void DisplayStandPay_ComMSCStdDetection()
        {
            //_standPay.LoadStandPay("1", "ComMSCStdDetection");
            //if (ControlMsc.MscRow == null)
            //{
            //    _standPay.LoadStandPay("1", "ComMSCStdDetection");
            //}
            //else
            //{
            //    if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //    {
            //        _standPay.LoadStandPay("1", "ComMSCStdDetection");
            //    }
            //    else
            //    {
            //        _standPay.LoadStandPay("3", "ComMSCStdDetection");
            //    }
            //}
        }

        private void DisplayStandPay_ProductWater()
        {
            //_standPay.LoadStandPay("1", "ProductWater");
            //if (ControlMsc.MscRow == null)
            //{
            //    _standPay.LoadStandPay("1", "ProductWater");
            //}
            //else
            //{
            //    if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //    {
            //        _standPay.LoadStandPay("1", "ProductWater");
            //    }
            //    else
            //    {
            //        _standPay.LoadStandPay("3", "ProductWater");
            //    }
            //}
        }

        private void DisplayStandPay_ComMSCStdProcess()
        {
            //_standPay.LoadStandPay("1", "ComMSCStdProcess");
        }

        void FrmProPSCMSC2_AfterRowInsert(object sender, RowEventArgs e)
        {
            if (ControlMsc.MscRow == null || ControlMsc.MscRow.Cells["MSC"].Value.ToString() == "") return;
            InsertStandPay_Stand(e);
            //if (ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() == "")
            //{
            //    InsertStandPay_Stand(e);
            //}
            //else
            //{
            //    InserStandPay_Alpha(e);
            //}
        }

        private void InsertStandPay_Stand(RowEventArgs e)
        {
            if (e.Row.HasParent()) return;
            if (e.Row.Band.Columns.Exists("MSC"))
            {
                e.Row.Cells["MSC"].Value = ControlMsc.MscRow.Cells["MSC"].Value;
            }
            else
            {
                return;
            }
            //if (e.Row.Band.Columns.Exists("PSC_DESC"))
            //{
            //    e.Row.Cells["PSC_DESC"].Value = ultraGrid1.ActiveRow.Cells["PSC_DESC"].Value;
            //}
            string producHead = ultraGrid1.GetActiveRowValue("PRODUC_HEAD");
            DataTable dt = (DataTable)((UltraComboEditor)e.Row.Band.Columns["MSC"].EditorComponent).DataSource;
            if (e.Row.Band.Columns.Exists("WIC"))
            {
                DataRow[] drs = dt.Select("NAME = '" + ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "'");
                string[] str = drs[0]["ID"].ToString().Split('@');
                e.Row.Cells["PSC"].Value = str[1];
                e.Row.Cells["PSC_DESC"].Value = str[2];
                e.Row.Cells["PRODUCNAME"].Value = str[3];
                e.Row.Cells["STDSTYLE"].Value = str[7];
                e.Row.Cells["STD_NAME"].Value = str[4];
                e.Row.Cells["STEELNAME"].Value = str[5];
                e.Row.Cells["STD_STYLE_DESC"].Value = str[6];
                e.Row.Cells["STEELCODE"].Value = str[8];
                e.Row.Cells["STD_CODE"].Value = str[9];
            }
            else if (e.Row.Band.Columns.Exists("PIC"))
            {
                DataRow[] drs = dt.Select("NAME = '" + ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "'");
                string[] str = drs[0]["ID"].ToString().Split('@');
                e.Row.Cells["PSC"].Value = str[1];
                e.Row.Cells["PSC_DESC"].Value = str[2];
                e.Row.Cells["PRODUCNAME"].Value = str[3];
                e.Row.Cells["STDSTYLE"].Value = str[7];
                e.Row.Cells["STD_NAME"].Value = str[4];
                e.Row.Cells["STEELNAME"].Value = str[5];
                e.Row.Cells["STD_STYLE_DESC"].Value = str[6];
            }
            else
            {
                DataRow[] drs = dt.Select("MSC = '" + ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "'");
                if (drs.Length > 0)
                {
                    e.Row.Cells["PSC"].Value = drs[0][2];
                    e.Row.Cells["PSC_DESC"].Value = drs[0][3];
                    e.Row.Cells["PRODUCNAME"].Value = drs[0][4];
                    if (e.Row.Cells.Exists("STD_NAME_B"))
                    {
                        e.Row.Cells["STD_NAME_B"].Value = drs[0][5];
                    }
                    else
                    {
                        e.Row.Cells["STD_NAME"].Value = drs[0][5];
                    }
                    e.Row.Cells["STEELNAME"].Value = drs[0][6];
                    e.Row.Cells["STD_STYLE_DESC"].Value = drs[0][7];
                    e.Row.Cells["STDSTYLE"].Value = drs[0][8];
                }
            }
            e.Row.SetValue("PRODUC_HEAD", producHead);
        }

        private void InserStandPay_Alpha(RowEventArgs e)
        {
            if (e.Row.HasParent()) return;

            //STD_NAME_NK
            if (e.Row.Band.Columns.Exists("STD_CODE_NK"))
            {
                if (e.Row.Band.Columns["STD_CODE_NK"].EditorComponent != null)
                {
                    e.Row.Cells["STD_CODE_NK"].Value = ControlMsc.MscRow.Cells["USE_CODE"].Value;
                    DataTable dt = (DataTable)((UltraComboEditor)e.Row.Band.Columns["STD_CODE_NK"].EditorComponent).DataSource;
                    DataRow[] drs = dt.Select("STD_CODE = '" + ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() + "'");
                    if (drs.Length > 0)
                    {
                        e.Row.Cells["STD_NAME_NK"].Value = drs[0]["STD_NAME"].ToString();
                        e.Row.Cells["STDSTYLE"].Value = drs[0][2].ToString();
                    }
                }
                else
                {
                    e.Row.Cells["STD_NAME_NK"].Value = ControlMsc.MscRow.Cells["USE_DESC"].Value;
                    DataTable dt = (DataTable)((UltraComboEditor)e.Row.Band.Columns["STD_NAME_NK"].EditorComponent).DataSource;
                    DataRow[] drs = dt.Select("NAME = '" + ControlMsc.MscRow.Cells["USE_DESC"].Value.ToString() + "'");
                    if (drs.Length > 0)
                    {
                        string[] str = drs[0]["ID"].ToString().Split('@');
                        e.Row.Cells["STD_CODE_NK"].Value = str[0];
                        e.Row.Cells["STDSTYLE"].Value = str[1];
                    }
                }
            }
            else if (e.Row.Band.Columns.Exists("STD_CODE"))
            {
                e.Row.Cells["STD_CODE"].Value = ControlMsc.MscRow.Cells["USE_CODE"].Value;
                DataTable dt = (DataTable)((UltraComboEditor)e.Row.Band.Columns["STD_CODE"].EditorComponent).DataSource;
                DataRow[] drs = dt.Select("STD_CODE = '" + ControlMsc.MscRow.Cells["USE_CODE"].Value.ToString() + "'");
                if (drs.Length > 0)
                {
                    e.Row.Cells["STD_NAME"].Value = drs[0][1].ToString();
                    e.Row.Cells["STDSTYLE"].Value = drs[0][2].ToString();
                }
            }
        }

        private void ControlStandPayEdit(UltraGrid grid)
        {
            string displayTable = grid.DataMember;
            if (grid.DisplayLayout.Bands[displayTable].Columns.Exists("PSC"))
            {
                grid.DisplayLayout.Bands[displayTable].Columns["PSC"].CellActivation = Activation.ActivateOnly;
            }
            if (grid.DisplayLayout.Bands[displayTable].Columns.Exists("PSC_DESC"))
            {
                grid.DisplayLayout.Bands[displayTable].Columns["PSC_DESC"].CellActivation = Activation.ActivateOnly;
            }
            if (grid.DisplayLayout.Bands[displayTable].Columns.Exists("STD_NAME_NK"))
            {
                grid.DisplayLayout.Bands[displayTable].Columns["STD_NAME_NK"].CellActivation = Activation.ActivateOnly;
            }
            else if (grid.DisplayLayout.Bands[displayTable].Columns.Exists("STD_NAME"))
            {
                grid.DisplayLayout.Bands[displayTable].Columns["STD_NAME"].CellActivation = Activation.ActivateOnly;
            }
        }

        void FrmProPSCMSC2_BeforeRowInsert(object sender, BeforeRowInsertEventArgs e)
        {

        }

        public void ClearStandPay()
        {
            ClearStandPay(ultraTabPageControl4, new string[] { "ultraGrid1" });
            ClearStandPay(ultraTabPageControl5, new string[] { "ultraGrid1" });
            ClearStandPay(ultraTabPageControl7, new string[] { "ultraGrid1" });
            ClearStandPay(ultraTabPageControl9, new string[] { "ultraGrid1" });
            ClearStandPay(ultraTabPageControl10, new string[] { "ultraGrid1" });
        }

        private void ClearStandPay(System.Windows.Forms.Control control, string[] strGrids)
        {
            foreach (string strGrid in strGrids)
            {
                System.Windows.Forms.Control[] controls = control.Controls.Find(strGrid, true);
                if (controls.Length > 0)
                {
                    UltraGrid grid = (UltraGrid)controls[0];
                    DataSet ds = (DataSet)grid.DataSource;
                    foreach (DataTable dt in ds.Tables)
                    {
                        if (dt.TableName == grid.DataMember) continue;
                        dt.Rows.Clear(); //前提条件： DataSet中的两表关系改为级联删除。
                    }
                    ds.Tables[grid.DataMember].Rows.Clear();
                }
            }
        }

        private void btnJG_Click(object sender, EventArgs e)
        {

        }

        private void btnBL_Click(object sender, EventArgs e)
        {

        }

        private void splitContainer2_SplitterMoved(object sender, SplitterEventArgs e)
        {

        }

        private void ultraToolbarsManager1_ToolClick(object sender, ToolClickEventArgs e)
        {
            if (ultraGrid1.ActiveRow == null || ControlMsc.MscRow == null) return;
            string psc = ultraGrid1.ActiveRow.Cells["PSC"].Value.ToString();
            switch (e.Tool.Key)
            {
                case "新增":
                    InsertComMscBackLog();
                    break;
                case "修改":
                    UpdateComMscBackLog();
                    break;
                case "保存":
                    if (ultraTabControl3.SelectedTab != null)
                    {
                        DataTable dt = null;
                        switch (ultraTabControl3.SelectedTab.Key)
                        {
                            case "JG":
                                dt = ServerHelper.GetData("com.steering.pss.sale.order.CorePscSelect.doQueryForbiddenOrder", new object[] { ControlMsc.MscRow.Cells["MSC"].Value.ToString() }, this.ob);
                                if (dt != null && dt.Rows.Count > 0)
                                {
                                    if (Convert.ToDecimal(dt.Rows[0][0].ToString()) == 1)
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion(ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "标准：" + dt.Rows[0][1].ToString() + "已禁止合同录入，请确认是否保存！") == DialogResult.No) return;
                                    }
                                }
                                if (CheckAuthority() == false) return;
                                ctrlMscJg1.Save();
                                QueryCom_Msc();
                                QueryMscRJg();
                                break;
                            case "STAND_PAY":
                                if (ultraTabControl2.SelectedTab != null)
                                {
                                    dt = ServerHelper.GetData("com.steering.pss.sale.order.CorePscSelect.doQueryForbiddenOrder", new object[] { ControlMsc.MscRow.Cells["MSC"].Value.ToString() }, this.ob);
                                    if (dt != null && dt.Rows.Count > 0)
                                    {
                                        if (Convert.ToDecimal(dt.Rows[0][0].ToString()) == 1)
                                        {
                                            if (MessageUtil.ShowYesNoAndQuestion(ControlMsc.MscRow.Cells["MSC"].Value.ToString() + "标准：" + dt.Rows[0][1].ToString() + "已禁止合同录入，请确认是否保存！") == DialogResult.No) return;
                                        }
                                    }
                                    switch (ultraTabControl2.SelectedTab.Key)
                                    {
                                        case "ChemStand":
                                            //_standPay.SaveChemStand(alpha, psc);
                                            _ctrlMscChem.Save();
                                            break;
                                        case "MaterialStand":
                                            //_standPay.SaveMaterialStand(alpha, psc);
                                            _ctrlMscMaterial.Save();
                                            break;
                                        case "TolerancesStand":
                                            //_standPay.SaveTolerancesStand(alpha, psc);
                                            _ctrlMscTolerances.Save();
                                            break;
                                        case "ComMSCStdDetection":
                                            //_standPay.SaveComMSCStdDetection(alpha, psc);
                                            _ctrlMscDetection.Save();
                                            break;
                                        case "ProductWater":
                                            //_standPay.SaveProductWater(alpha, psc);
                                            _ctrlMscProductWater.Save();
                                            break;
                                        case "ComMSCStdProcess":
                                            //_standPay.SaveComMSCStdProcess(alpha, psc);
                                            _ctrlMscStdProcess.Save();
                                            break;
                                    }
                                }
                                break;
                        }
                    }

                    break;
                case "作废":

                    switch (ultraTabControl3.SelectedTab.Key)
                    {
                        case "PROCEDURE":
                            DeleteComMscBackLog();
                            break;
                        case "JG":
                            ctrlMscJg1.Delete();
                            break;
                        case "STAND_PAY":
                            if (ultraTabControl2.SelectedTab == null) return;
                            switch (ultraTabControl2.SelectedTab.Key)
                            {
                                case "PROCEDURE":
                                    DeleteComMscBackLog();
                                    break;
                                case "ChemStand":
                                    //_standPay.DeleteChemStand(alpha, psc);
                                    _ctrlMscChem.Delete();
                                    break;
                                case "MaterialStand":
                                    //_standPay.DeleteMaterialStand(alpha, psc);
                                    _ctrlMscMaterial.Delete();
                                    break;
                                case "TolerancesStand":
                                    //_standPay.DeleteTolerancesStand(alpha, psc);
                                    _ctrlMscTolerances.Delete();
                                    break;
                                case "ComMSCStdDetection":
                                    //_standPay.DeleteComMSCStdDetection(alpha, psc);
                                    _ctrlMscDetection.Delete();
                                    break;
                                case "ProductWater":
                                    //_standPay.DeleteProductWater(alpha, psc);
                                    _ctrlMscProductWater.Delete();
                                    break;
                                case "ComMSCStdProcess":
                                    //_standPay.DeleteComMSCStdProcess(alpha, psc);
                                    _ctrlMscStdProcess.Delete();
                                    break;
                            }
                            break;
                            //case "IMG":
                            //    string msc = controlMsc1.GridMsc.GetActiveRowValue("MSC");
                            //    string oldPath = ((DtMsc)controlMsc1.DtBaseQcm).QueryImgPath(msc);
                            //    if (oldPath == "")
                            //    {
                            //        MessageUtil.ShowWarning("没有可删除的图片！");
                            //        return;
                            //    }
                            //    if (MessageUtil.ShowYesNoAndQuestion("是否确认删除附件图片？") == System.Windows.Forms.DialogResult.No)
                            //    {
                            //        return;
                            //    }
                            //    FileHelper.Delete(oldPath);
                            //    ((DtMsc)controlMsc1.DtBaseQcm).SaveImgPath("");//删除数据库附件图片路径
                            //    MessageUtil.ShowTips("删除成功！");
                            //    break;
                    }

                    break;
                case "恢复":

                    switch (ultraTabControl3.SelectedTab.Key)
                    {
                        case "PROCEDURE":
                            ResumeComMscBackLog();
                            break;
                        case "STAND_PAY":
                            if (ultraTabControl2.SelectedTab == null) return;
                            switch (ultraTabControl2.SelectedTab.Key)
                            {
                                case "PROCEDURE":
                                    ResumeComMscBackLog();
                                    break;
                                case "ChemStand":
                                    //_standPay.ResumeChemStand(alpha, psc);
                                    _ctrlMscChem.Resume();
                                    break;
                                case "MaterialStand":
                                    //_standPay.ResumeMaterialStand(alpha, psc);
                                    _ctrlMscMaterial.Resume();
                                    break;
                                case "TolerancesStand":
                                    //_standPay.ResumeTolerancesStand(alpha, psc);
                                    _ctrlMscTolerances.Resume();
                                    break;
                                case "ComMSCStdDetection":
                                    //_standPay.ResumeComMSCStdDetection(alpha, psc);
                                    _ctrlMscDetection.Resume();
                                    break;
                                case "ProductWater":
                                    //_standPay.ResumeProductWater(alpha, psc);
                                    _ctrlMscProductWater.Resume();
                                    break;
                                case "ComMSCStdProcess":
                                    //_standPay.ResumeComMSCStdProcess(alpha, psc);
                                    _ctrlMscStdProcess.Resume();
                                    break;
                            }
                            break;
                    }

                    break;
                case "分组":
                    if (ultraTabControl2.SelectedTab != null)
                    {
                        switch (ultraTabControl2.SelectedTab.Key)
                        {
                            case "ChemStand":
                                _ctrlMscChem.Group();
                                break;
                            case "MaterialStand":
                                //_standPay.GroupMaterialStand(alpha, psc);
                                _ctrlMscMaterial.Group();
                                break;
                            case "ComMSCStdProcess":
                                //_standPay.GroupComMSCStdProcess(alpha, psc);
                                _ctrlMscStdProcess.Group();
                                break;
                            case "ComMSCStdDetection":
                                //_standPay.GroupComMSCStdDetection(alpha, psc);
                                _ctrlMscDetection.Group();
                                break;
                            case "TolerancesStand":
                                _ctrlMscTolerances.Group();
                                break;
                        }
                    }
                    switch (ultraTabControl3.SelectedTab.Key)
                    {
                        case "BL":
                            if (CheckAuthority() == false) return;
                            ctrlMscBl1.Group();
                            break;
                    }
                    break;
                case "取消分组":
                    if (ultraTabControl2.SelectedTab == null) return;
                    switch (ultraTabControl2.SelectedTab.Key)
                    {
                        case "ChemStand":
                            _ctrlMscChem.CancelGroup();
                            break;
                        case "ComMSCStdProcess":
                            //_standPay.CancelGroupComMSCStdProcess(alpha, psc);
                            _ctrlMscStdProcess.CancelGroup();
                            break;
                        case "MaterialStand":
                            //_standPay.CancelGroupMaterialStand(alpha, psc);
                            _ctrlMscMaterial.CancelGroup();
                            break;
                        case "ComMSCStdDetection":
                            //_standPay.CancelGroupComMSCStdDetection(alpha, psc);
                            _ctrlMscDetection.CancelGroup();
                            break;
                        case "TolerancesStand":
                            _ctrlMscTolerances.CancelGroup();
                            break;
                    }
                    break;
                case "接箍码维护":
                case "备料码维护":
                    if (ControlMsc.MscRow == null)
                    {
                        MessageUtil.ShowWarning("选择一条冶金规范码后，再进行操作！");
                        return;
                    }
                    if (ControlMsc.MscRow.Cells["MSC"].Value.ToString() == "")
                    {
                        MessageUtil.ShowWarning("请新增该条冶金规范后，再进行操作！");
                        return;
                    }
                    if (CheckAuthority() == false) return;
                    if (e.Tool.Key == "接箍码维护")
                    {
                        EditJGCode();
                    }
                    else
                    {
                        EditBLCode();
                        BlSpecManage();
                    }
                    break;
                case "保存拧接":
                    ctrlMscJg1.SaveTorque();
                    break;
                case "删除拧接":
                    ctrlMscJg1.DeleteTorque();
                    break;
                case "上传附件图片":
                    try
                    {
                        if (CheckAuthority() == false) return;
                        DataTable dtMsc = GetMscTabByMsc(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), ob);
                        //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
                        //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
                        //{
                        //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！");
                        //    return;
                        //}
                        string msc = controlMsc1.GridMsc.GetActiveRowValue("MSC");
                        string path = "Qcm/Msc/Appendix/" + msc + "/";

                        List<FileBean> list = new List<FileBean>();
                        FileBean bean = new FileBean();
                        OpenFileDialog file = new OpenFileDialog();
                        file.Multiselect = true;
                        file.Title = "选择需要上传的图片";
                        file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp";
                        DialogResult drStat;
                        drStat = file.ShowDialog();

                        if (drStat == DialogResult.OK)
                        {
                            foreach (string fileName in file.FileNames)
                            {
                                bean = new FileBean();
                                string filena = System.IO.Path.GetFileName(fileName);
                                if (filena.Contains(" "))
                                {
                                    MessageUtil.ShowWarning("上传的图片名称不能包含空格！");
                                    return;
                                }
                                if (filena.Contains("°"))
                                {
                                    MessageUtil.ShowWarning("上传的图片名称不能包含特殊符号【°】");
                                    return;
                                }
                                bean.setFileName(filena);
                                bean.setPathName(path);
                                bean.setFile(FileHelper.FileToArray(fileName));
                                list.Add(bean);
                            }
                            bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
                            if (isSuccess)
                            {
                                ShowMscImg();
                                string fileNames = "";
                                foreach (var fileBean in _ctrlFileDown.List)
                                {
                                    if (fileNames == "")
                                    {
                                        fileNames = path + fileBean.getFileName();
                                    }
                                    else
                                    {
                                        fileNames += "#" + path + fileBean.getFileName();
                                    }
                                }
                                ((DtMsc)controlMsc1.DtBaseQcm).SaveImgPath(fileNames);
                                MessageBox.Show("上传成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
                            }
                            else
                            {
                                MessageUtil.ShowWarning("上传失败，请重试！");
                            }
                        }

                        //string path = QcmFile.FlileUpload("Qcm/Msc/Appendix");
                        //string oldPath = ((DtMsc)controlMsc1.DtBaseQcm).QueryImgPath(msc);
                        //if (oldPath != "")
                        //{
                        //    FileHelper.Delete(oldPath);
                        //}
                    }
                    catch (Exception ex) { MessageUtil.ShowError(ex.Message); }
                    break;
                case "复制":
                    if (ultraTabControl2.SelectedTab == null) return;
                    switch (ultraTabControl2.SelectedTab.Key)
                    {
                        case "ChemStand":
                            //_standPay.CopyChemStand();
                            _ctrlMscChem.Copy();
                            break;
                        case "MaterialStand":
                            //_standPay.CopyMaterialStand();
                            _ctrlMscMaterial.Copy();
                            break;
                        case "TolerancesStand":
                            //_standPay.CopyTolerancesStand();
                            _ctrlMscTolerances.Copy();
                            break;
                        case "ComMSCStdDetection":
                            //_standPay.CopyComMSCStdDetection();
                            _ctrlMscDetection.Copy();
                            break;
                        case "ProductWater":
                            //_standPay.CopyProductWater();
                            _ctrlMscProductWater.Copy();
                            break;
                        case "ComMSCStdProcess":
                            //_standPay.CopyComMSCStdProcess();
                            _ctrlMscStdProcess.Copy();
                            break;
                    }
                    break;
                case "粘贴":
                    if (ultraTabControl2.SelectedTab == null) return;
                    switch (ultraTabControl2.SelectedTab.Key)
                    {
                        case "ChemStand":
                            //_standPay.PasteChemStand();
                            _ctrlMscChem.Paste();
                            break;
                        case "MaterialStand":
                            //_standPay.PasteMaterialStand();
                            _ctrlMscMaterial.Paste();
                            break;
                        case "TolerancesStand":
                            //_standPay.PasteTolerancesStand();
                            _ctrlMscTolerances.Paste();
                            break;
                        case "ComMSCStdDetection":
                            //_standPay.PasteComMSCStdDetection();
                            _ctrlMscDetection.Paste();
                            break;
                        case "ProductWater":
                            //_standPay.PasteProductWater();
                            _ctrlMscProductWater.Paste();
                            break;
                        case "ComMSCStdProcess":
                            //_standPay.PasteComMSCStdProcess();
                            _ctrlMscStdProcess.Paste();
                            break;
                    }
                    break;
                case "刷新":
                    switch (ultraTabControl3.SelectedTab.Key)
                    {
                        case "PROCEDURE":
                            LoadBaseDataProcedure();
                            break;
                        case "STAND_PAY":
                            LoadBaseDataStandPay();
                            break;
                    }
                    break;
                case "规格维护":
                    BlSpecManage();
                    break;
                case "复制基础MSC制程":
                    CopyBackLog();
                    break;
                case "保存模板":
                    _ctrlMscMaterial.SaveTemplate();
                    break;
            }
        }

        String copyMscPline;

        public String CopyMscPline
        {
            get { return copyMscPline; }
            set { copyMscPline = value; }
        }

        public void CopyBackLog()
        {
            bool result = MscMsc_BackLog.CopyBackLog(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), this, ControlMsc.CopyMsc, CopyMscPline);
            if (result)
            {
                SaveGrid4Code();
                lblStationPath.Text = "";
                _dicMscStation.Clear();
                QueryTreeViewData();
                LoadDataToTree();
                QueryCom_Msc_BackLog();
                QueryCom_Base_Process();
                RefreshMscProcess();
                MoveToGrid4OldSite("");
                MoveToTreeViewOldSite();
                ControlMsc.CopyMsc = "";
                CopyMscPline = "";
            }
        }

        private bool CheckAuthority()
        {
            if (controlMsc1.GridMsc.ActiveRow == null) return false;
            DataTable dtMsc = GetMscTabByMsc(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), ob);
            //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
            //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
            //{
            //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！");
            //    return false;
            //}

            return true;
        }

        private void BlSpecManage()
        {
            if (controlMsc1.ultraGrid2.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择一条冶金规范码！");
                return;
            }
            if (controlMsc1.ultraGrid2.ActiveRow.GetValue("MSC") == "")
            {
                MessageUtil.ShowWarning("请先保存冶金规范码！");
                return;
            }
            if (CheckAuthority() == false) return;
            ComMscRBlSpecEntity mscRBlSpec = new ComMscRBlSpecEntity();
            mscRBlSpec.Msc = controlMsc1.ultraGrid2.GetActiveRowValue("MSC");
            PopupMscRBlSpec popup;
            try
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.WaitCursor;
                popup = new PopupMscRBlSpec(mscRBlSpec, ob);
            }
            finally
            {
                ((Form)ultraGrid1.TopLevelControl).Cursor = Cursors.Default;
            }

            popup.ShowDialog();
        }


        private void ultraTabControl2_SelectedTabChanged(object sender, SelectedTabChangedEventArgs e)
        {
            if (e.Tab == null) return;
            ultraTabControl2.TopLevelControl.Cursor = Cursors.WaitCursor;
            switch (e.Tab.Key)
            {
                case "ChemStand":
                case "TolerancesStand":
                case "ComMSCStdDetection":
                case "ProductWater":
                case "MaterialStand":
                case "ComMSCStdProcess":
                    DisplayAndQueryStandPay();
                    break;
            }
            ultraTabControl2.TopLevelControl.Cursor = Cursors.Default;
        }

        public void DisplayAndQueryStandPay()
        {
            string msc = "Null";
            string codeJg = "";
            if (ultraGrid1.ActiveRow != null && ControlMsc.MscRow != null && ControlMsc.MscRow.Cells["MSC"].Value.ToString() != "")
            {
                msc = ControlMsc.MscRow.Cells["MSC"].Value.ToString();
                if (ControlMsc.GridMsc.ActiveRow.HasParent())
                {
                    codeJg = ControlMsc.GridMsc.GetActiveRowValue("CODE_JG");
                }
            }

            if (ultraTabControl2.SelectedTab == null || ultraTabControl3.SelectedTab == null) return;

            if (ultraTabControl3.SelectedTab.Key == "STAND_PAY")
            {
                switch (ultraTabControl2.SelectedTab.Key)
                {
                    case "ChemStand":
                        SetStandPayTools2();
                        //DisplayStandPay_ChemStand();
                        //_standPay.SetChemStandMscCondition(msc, codeJg);
                        //_standPay.QueryChemStand(alpha, psc);
                        //_standPay.ExpandChemStandGrid();
                        _ctrlMscChem.ShowGrid(msc, this.ob);
                        _ctrlMscChem.Query(msc, codeJg);
                        _ctrlMscChem.ExpandFirstRow();
                        //ShowStandPayExpress("ChemStand");
                        break;
                    case "TolerancesStand":
                        SetStandPayTools2();
                        //DisplayStandPay_TolerancesStand();
                        //_standPay.SetTolerancesStandardCondition(msc, codeJg);
                        //_standPay.QueryTolerancesStand(alpha, psc);
                        //_standPay.ExpandTolerancesStandGrid();
                        _ctrlMscTolerances.ShowGrid(msc, this.ob);
                        _ctrlMscTolerances.Query(msc, codeJg);
                        _ctrlMscTolerances.ExpandFirstRow();
                        //ShowStandPayExpress("TolerancesStand");
                        break;
                    case "ComMSCStdDetection":
                        SetStandPayTools2();
                        //DisplayStandPay_ComMSCStdDetection();
                        //_standPay.SetComMSCStdDetectionCondition(msc, codeJg);
                        //_standPay.QueryComMSCStdDetection(alpha, psc);
                        //_standPay.ExpandComMSCStdDetectionGrid();
                        _ctrlMscDetection.ShowGrid(msc, this.ob);
                        _ctrlMscDetection.Query(msc, codeJg);
                        _ctrlMscDetection.ExpandFirstRow();
                        //ShowStandPayExpress("ComMSCStdDetection");
                        break;
                    case "ProductWater":
                        SetStandPayTools1();
                        //DisplayStandPay_ProductWater();
                        //_standPay.SetWaterPressureStandCondition(msc, codeJg);
                        //_standPay.QueryProductWater(alpha, psc);
                        //_standPay.ExpandProductWaterGrid();
                        _ctrlMscProductWater.ShowGrid(msc, _ordLnPk, this.ob);
                        _ctrlMscProductWater.Query(msc, codeJg);
                        _ctrlMscProductWater.ExpandFirstRow();
                        //ShowStandPayExpress("ProductWater");
                        break;
                    case "MaterialStand":
                        SetStandPayTools2();
                        //DisplayStandPay_MaterialStand();
                        //_standPay.SetMaterialStandardCondition(msc, codeJg);
                        //_standPay.QueryMaterialStand(alpha, psc);
                        //_standPay.ExpandMaterialStandGrid();
                        _ctrlMscMaterial.ShowGrid(msc, _ordLnPk, this.ob);
                        _ctrlMscMaterial.Query(msc, codeJg);
                        _ctrlMscMaterial.ExpandFirstRow();
                        ultraToolbarsManager1.Toolbars[0].Tools["保存模板"].SharedProps.Visible = true;
                        //ShowStandPayExpress("MaterialStand");
                        break;
                    case "ComMSCStdProcess":
                        SetStandPayTools2();
                        //DisplayStandPay_ComMSCStdProcess();
                        //_standPay.SetComMSCStdProcessCondition(msc, codeJg);
                        //_standPay.QueryComMSCStdProcess(alpha, psc);
                        //_standPay.ExpandComMSCStdProcess();
                        _ctrlMscStdProcess.ShowGrid(msc, this.ob);
                        _ctrlMscStdProcess.Query(msc, codeJg);
                        _ctrlMscStdProcess.ExpandFirstRow();
                        //ShowStandPayExpress("ComMSCStdProcess");
                        break;
                }
            }
        }

        //private void ShowStandPayExpress(string standPay)
        //{
        //    switch(standPay)
        //    {
        //        case "ProductWater":
        //            lblStandPayExpress.Text = "试验压力(公式)";
        //            lblStandPayExpress.Location = new Point(lblStandPayExpress2.Location.X - lblStandPayExpress.Width - 2, lblStandPayExpress.Location.Y);
        //            lblStandPayExpress2.Text = " f-水压系数，YS-最小屈服强度，D:规定外径，t:规定壁厚";
        //            break;
        //        case "MaterialStand":
        //            lblStandPayExpress.Text = "复合标准公式";
        //            lblStandPayExpress.Location = new Point(lblStandPayExpress2.Location.X - lblStandPayExpress.Width - 2, lblStandPayExpress.Location.Y);
        //            lblStandPayExpress2.Text = @"Axc-拉伸试样面积，^-冥次方(例:5的3次方表示为:5^3)，t-规定壁厚\r\nC-碳当量，Value-附加标准符号";
        //            break;
        //        case "TolerancesStand":
        //            lblStandPayExpress.Text = "标准公式";
        //            lblStandPayExpress.Location = new Point(lblStandPayExpress2.Location.X - lblStandPayExpress.Width - 2, lblStandPayExpress.Location.Y);
        //            lblStandPayExpress2.Text = "t-壁厚 D-外径 L-长度";
        //            break;
        //        default:
        //            lblStandPayExpress.Text = "";
        //            lblStandPayExpress2.Text = "";
        //            break;
        //    }
        //}

        private void ultraTabControl1_SelectedTabChanged(object sender, SelectedTabChangedEventArgs e)
        {
            switch (e.Tab.Key)
            {
                case "MSC":
                    SetMscTools();
                    break;
            }
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid4.UpdateData();
        }

        private void ultraTabControl3_SelectedTabChanged(object sender, SelectedTabChangedEventArgs e)
        {
            if (e.Tab == null) return;
            switch (e.Tab.Key)
            {
                case "STAND_PAY":
                    if (ultraTabControl2.SelectedTab == null) return;
                    SelectedTabChangedEventArgs eventArgs = new SelectedTabChangedEventArgs(ultraTabControl2.SelectedTab, ultraTabControl2.SelectedTab);
                    ultraTabControl2_SelectedTabChanged(null, eventArgs);
                    //ShowStandPayExpress(ultraTabControl2.SelectedTab.Key);
                    break;
                case "PROCEDURE":
                    try
                    {
                        ((Form)this.TopLevelControl).Cursor = Cursors.WaitCursor;
                        SetProcedureTools();
                        QueryCom_Msc_BackLog();
                        QueryCom_Base_Process();
                        RefreshMscProcess();
                        DisplayProcessPath();
                    }
                    finally
                    {
                        ((Form)this.TopLevelControl).Cursor = Cursors.Default;
                    }
                    //ShowStandPayExpress("");
                    break;
                case "JG":
                    SetJGTools();
                    QueryJG_PL();
                    //ShowStandPayExpress("");
                    break;
                case "BL":
                    SetBLTools();
                    QueryJG_PL();
                    //ShowStandPayExpress("");
                    break;
                case "IMG":
                    SetImgTools();
                    ShowMscImg();
                    break;
            }
            ultraTabControl3.Update();
        }

        private void ultraGrid5_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid5.UpdateData();
            DataTable dtProcessC = MscMsc_BackLog.QueryComBaseProcessCByPk(ultraGrid5.GetActiveRowValue("PROCESS_CODE_C"), this);
            if (dtProcessC.Rows.Count > 0)
            {
                ultraGrid5.SetActiveRowValue("MINUTE_PRODUCT", dtProcessC.Rows[0]["MINUTE_PRODUCT"].ToString());
                ultraGrid5.SetActiveRowValue("MINUTE_WAITE", dtProcessC.Rows[0]["MINUTE_WAITE"].ToString());
                ultraGrid5.SetActiveRowValue("MINUTE_PRODUCT_OUT", dtProcessC.Rows[0]["MINUTE_PRODUCT_OUT"].ToString());
                ultraGrid5.SetActiveRowValue("MINUTE_WAITE_OUT", dtProcessC.Rows[0]["MINUTE_WAITE_OUT"].ToString());
                ultraGrid5.SetActiveRowValue("BATCH_WAITE", dtProcessC.Rows[0]["BATCH_WAITE"].ToString());
                ultraGrid5.SetActiveRowValue("BATCH_WAITE_OUT", dtProcessC.Rows[0]["BATCH_WAITE_OUT"].ToString());
                ultraGrid5.UpdateData();
            }
        }

        private void ultraGrid7_ClickCellButton(object sender, CellEventArgs e)
        {
            if (controlMsc1.GridMsc.ActiveRow == null) return;
            DataTable dtMsc = GetMscTabByMsc(controlMsc1.GridMsc.ActiveRow.GetValue("MSC"), ob);
            //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != CoreUserInfo.UserInfo.GetDeptid()
            //    && CoreUserInfo.UserInfo.GetUserID() != "admin")
            //{
            //    MessageUtil.ShowWarning("该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！");
            //    return;
            //}
            string msc = ultraGrid4.GetActiveRowValue("MSC");
            string mscPline = ultraGrid4.GetActiveRowValue("MSC_PLINE");
            string gradeCode = ultraGrid7.GetActiveRowValue("GRADECODE");
            if (e.Cell.Column.Key == "BTN")
            {
                if (ultraGrid4.GetActiveRowValue("VALIDFLAG") == "1")
                {

                    PopupGrandeRSpec popuGradeRSpec = new PopupGrandeRSpec(msc, mscPline, gradeCode, ob);
                    //popuGradeRSpec.Size = this.Size;
                    popuGradeRSpec.ShowDialog();
                    QueryGrade(msc, mscPline);
                }
                else
                {
                    MessageUtil.ShowWarning("只有录入状态的制程，才能维护钢种规格范围！");
                    return;
                }
            }
            else if (e.Cell.Column.Key == "DELETE")
            {
                DataTable dtIsUsedGrade = ServerHelper.GetData("com.steering.pss.qcm.CoreInnerMSCRGRD2.isUsedGrade",
                        new object[] { msc, mscPline, gradeCode }, ob);
                if (dtIsUsedGrade.Rows.Count > 0)
                {
                    MessageUtil.ShowWarning("钢种[" + ultraGrid7.GetActiveRowValue("GRADENAME") + "]已被该制程下的内控标准使用，不能删除！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认删除钢种？") == System.Windows.Forms.DialogResult.No)
                {
                    return;
                }
                DtMsc.DeletePlineGrade(msc, mscPline, gradeCode, ob);
                MessageUtil.ShowTips("删除成功！");
                QueryGrade(msc, mscPline);
            }
        }

        private void splitContainer3_SplitterMoved(object sender, SplitterEventArgs e)
        {
            if (splitContainer3.Panel2Collapsed)
            {
                ultraToolbarsManager1.Toolbars[0].Visible = false;
            }
            else
            {
                ultraToolbarsManager1.Toolbars[0].Visible = true;
            }
        }


        private void cmbProduct_ValueChanged(object sender, EventArgs e)
        {
            //string productName = cmbProduct.Text.Trim();
            //DataTable dt = (DataTable)cmbProduct.DataSource;
            //dt.DefaultView.RowFilter = "PRODUC_JX LIKE '%" + cmbProduct.Text.Trim() + "%'";
            //cmbProduct.DroppedDown = false;
            //cmbProduct.Update();
            //cmbProduct.Refresh();
            //cmbProduct.Update();
            //cmbProduct.RefreshList();
            //cmbProduct.DropDown();
            //cmbProduct.SelectionLength = 0;
            //cmbProduct.SelectionStart = cmbProduct.Text.Length;
            //cmbProduct.ValueList.ResetItemHeight();
            //cmbProduct.Refresh();
            //cmbProduct.Update();
            //cmbProduct.RefreshList();
            //cmbProduct.SetBounds(cmbProduct.Left, cmbProduct.Top, cmbProduct.Width, 400);
        }

        private string ultraTab3Key = "";
        private void ultraTabControl3_SelectedTabChanging(object sender, SelectedTabChangingEventArgs e)
        {
            if (ultraTab3Key == "STAND_PAY")
            {
                if (AskIsDropStandPay() == false) e.Cancel = true;
            }
            if (e.Tab != null)
            {
                ultraTab3Key = e.Tab.Key;
            }
            else
            {
                ultraTab3Key = "";
            }
        }

        private bool IsStandPayChange(out string standPayItem)
        {
            standPayItem = "";
            int chemChangeCnt = _ctrlMscChem.ChemDataTable1.Rows.Cast<DataRow>().Where(
                    a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            chemChangeCnt += _ctrlMscChem.ChemDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (chemChangeCnt > 0)
            {
                standPayItem = "成分";
                return true;
            }
            int materialChangeCnt = _ctrlMscMaterial.MaterialDataTable1.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            materialChangeCnt += _ctrlMscMaterial.MaterialDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (materialChangeCnt > 0)
            {
                standPayItem = "理化";
                return true;
            }
            int tolerancesCnt = _ctrlMscTolerances.TolerancesDataTable1.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            tolerancesCnt += _ctrlMscTolerances.TolerancesDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (tolerancesCnt > 0)
            {
                standPayItem = "公差";
                return true;
            }
            int detectionChangeCnt = _ctrlMscDetection.DetectionDataTable1.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            detectionChangeCnt += _ctrlMscDetection.DetectionDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (detectionChangeCnt > 0)
            {
                standPayItem = "探伤";
                return true;
            }
            int waterChangeCnt = _ctrlMscProductWater.WaterDataTable1.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            tolerancesCnt += _ctrlMscProductWater.WaterDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (waterChangeCnt > 0)
            {
                standPayItem = "水压";
                return true;
            }
            int processChangeCnt = _ctrlMscStdProcess.ProcessDataTable1.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            processChangeCnt += _ctrlMscStdProcess.ProcessDataTable2.Rows.Cast<DataRow>().Where(
                a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
            if (processChangeCnt > 0)
            {
                standPayItem = "加工";
                return true;
            }
            return false;
        }

        private void RejectStadPayChange()
        {
            _ctrlMscChem.ChemDataTable1.RejectChanges();
            _ctrlMscChem.ChemDataTable2.RejectChanges();
            _ctrlMscDetection.DetectionDataTable2.RejectChanges();
            _ctrlMscDetection.DetectionDataTable1.RejectChanges();
            _ctrlMscMaterial.MaterialDataTable1.RejectChanges();
            _ctrlMscMaterial.MaterialDataTable2.RejectChanges();
            _ctrlMscProductWater.WaterDataTable2.RejectChanges();
            _ctrlMscProductWater.WaterDataTable1.RejectChanges();
            _ctrlMscStdProcess.ProcessDataTable2.RejectChanges();
            _ctrlMscStdProcess.ProcessDataTable1.RejectChanges();
            _ctrlMscTolerances.TolerancesDataTable2.RejectChanges();
            _ctrlMscTolerances.TolerancesDataTable1.RejectChanges();
        }

        public bool AskIsDropStandPay()
        {
            string standPayItem = "";
            if (IsStandPayChange(out standPayItem))
            {
                DialogResult dlResult = MessageUtil.ShowYesNoAndQuestion(standPayItem + "有数据更改，是否放弃编辑？");
                if (dlResult == DialogResult.No)
                {
                    return false;
                }
                else
                {
                    RejectStadPayChange();
                    return true;
                }
            }
            return true;
        }

        private void ultraTabControl2_SelectedTabChanging(object sender, SelectedTabChangingEventArgs e)
        {
            if (AskIsDropStandPay() == false) e.Cancel = true;
        }

        private void ultraGrid1_BeforeRowDeactivate(object sender, CancelEventArgs e)
        {
            if (AskIsDropStandPay() == false) e.Cancel = true;
        }

        private void FrmProPSCMSC2_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (AskIsDropStandPay() == false) e.Cancel = true;
        }

        private void lblStationPath_KeyDown(object sender, KeyEventArgs e)
        {
            //if (e.Control)
            //{
            //    if (e.KeyCode == Keys.A)
            //    {
            //        lblStationPath.sele;
            //    }
            //}
        }

        private void craftImg_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid4.ActiveRow;
            string filePath = "Qcm/Craft_PL/" + row.GetValue("MSC") + "/" + row.GetValue("MSC_PLINE");
            Assembly dll = Assembly.LoadFrom(Application.StartupPath + "\\Core.StlMes.Client.SaleOrder.dll");
            Type type = dll.GetType("Core.StlMes.Client.SaleOrder.dlgOrderAskDown");
            object dlgOrderAskDown = Activator.CreateInstance(type, this.ob, filePath);

            Type typeFileDown = Assembly.LoadFrom(Application.StartupPath + "\\Core.StlMes.Client.SaleComm.dll").GetType(
                "Core.StlMes.Client.SaleComm.ctrlFileDown");
            if (e.Button.Key.ToLower().Equals("select"))
            {
                Form form = (Form)dlgOrderAskDown;
                form.ShowDialog();
                object ctrlFileDown = type.GetProperty("CtrlFileDown1").GetValue(dlgOrderAskDown, null);

                List<FileBean> list = (List<FileBean>)typeFileDown.GetProperty("List").GetValue(ctrlFileDown, null);
                if (list.Count == 0)
                {
                    row.Cells["CRAFT_PATH"].Value = "";
                    row.Cells["CRAFT_PATH"].Tag = "";
                }
                else
                {
                    row.Cells["CRAFT_PATH"].Value = "存在工艺文件";
                    row.Cells["CRAFT_PATH"].Tag = filePath;
                }
                MscMsc_BackLog.UpdateCraftPath(this);
            }
            if (e.Button.Key.ToLower().Equals("choice"))
            {
                if (row.GetValue("MSC_PLINE") == "")
                {
                    MessageUtil.ShowWarning("请先新增制程后，再上传工艺文件！");
                    return;
                }
                bool isUpload = FlileUploadcomm.FlileUpload(filePath);
                if (isUpload)
                {
                    Form form = (Form)dlgOrderAskDown;
                    form.ShowDialog();
                    object ctrlFileDown = type.GetProperty("CtrlFileDown1").GetValue(dlgOrderAskDown, null);

                    List<FileBean> list = (List<FileBean>)typeFileDown.GetProperty("List").GetValue(ctrlFileDown, null);
                    if (list.Count == 0)
                    {
                        row.Cells["CRAFT_PATH"].Value = "";
                        row.Cells["CRAFT_PATH"].Tag = "";
                    }
                    else
                    {
                        row.Cells["CRAFT_PATH"].Value = "存在工艺文件";
                        row.Cells["CRAFT_PATH"].Tag = filePath;
                    }
                    MscMsc_BackLog.UpdateCraftPath(this);
                }
            }
            ultraGrid4.UpdateData();
            ultraGrid4.Refresh();
        }

        private void ultraTextEditor1_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            PopupTextBox popupText = new PopupTextBox(ultraGrid5.ActiveCell.Value.ToString(), 4000);
            if (popupText.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                ultraGrid5.ActiveCell.Value = popupText.TextInfo.Trim();
            }
        }

        private void ultraTextEditor16_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            var row = ultraGrid5.ActiveRow;
            string msc = ultraGrid4.GetActiveRowValue("MSC");
            string mscPline = ultraGrid4.GetActiveRowValue("MSC_PLINE");
            string process = row.GetValue("PROCESS_CODE");

            if (e.Button.Key == "Show")
            {
                string downPath = "";
                if (row.GetValue("PROCESS_FILE") != "")
                {
                    downPath = row.GetValue("PROCESS_FILE").Substring(0, row.GetValue("PROCESS_FILE").LastIndexOf('/') + 1);
                }
                FormFileDown down = new FormFileDown(ob, downPath);
                down.ShowDialog();
                if (down.CtrlFileDown1.List.Count == 0)
                {
                    MscMsc_BackLog.UpdateProcessFile("", msc, mscPline, process, ob);
                    row.Cells["PROCESS_FILE_NAME"].Value = "";
                    row.Cells["PROCESS_FILE"].Value = "";
                }
            }
            else if (e.Button.Key == "Upload")
            {
                if (msc == "")
                {
                    MessageUtil.ShowWarning("请保存制程后，上传工艺贴图！");
                    return;
                }
                if (ultraGrid5.GetActiveRowValue("MSC") == "")
                {
                    MessageUtil.ShowWarning("请先保存" + ultraGrid5.GetActiveRowValue("PROCESS_DESC") + "工序！");
                    return;
                }

                string path = "Qcm/Msc/ProcessFile/" + msc + mscPline + process + "/";
                var serverFileList = FileHelper.Download(row.GetValue("PROCESS_FILE"));
                //if (serverFileList != null && serverFileList.Count > 0)
                //{
                //    MessageUtil.ShowWarning("该记录已存在一份文件，请删除后再重新上传！");
                //    return;
                //}

                List<FileBean> list = new List<FileBean>();
                FileBean bean = new FileBean();
                OpenFileDialog file = new OpenFileDialog();
                file.Filter = "图片文件(*.jpg);(*.gif);(*.png);(*.bmp)|*.jpg;*.gif;*.png;*.bmp";
                file.Title = "选择需要上传的图片";
                file.Multiselect = false;
                DialogResult drStat;
                drStat = file.ShowDialog();

                if (drStat == DialogResult.OK)
                {
                    string filePath = file.FileName;
                    string fileName = System.IO.Path.GetFileName(filePath);
                    if (fileName.Contains(" "))
                    {
                        MessageUtil.ShowWarning("上传的图片名称不能包含空格！");
                        return;
                    }
                    if (fileName.Contains("°"))
                    {
                        MessageUtil.ShowWarning("上传的图片名称不能包含特殊符号【°】");
                        return;
                    }
                    bean = new FileBean();
                    bean.setFileName(fileName);
                    bean.setPathName(path);
                    bean.setFile(FileHelper.FileToArray(filePath));
                    list.Add(bean);
                    bool isSuccess = Core.Mes.Client.Comm.Server.FileHelper.Upload(list);
                    if (isSuccess)
                    {
                        row.Cells["PROCESS_FILE"].Value = path + fileName;
                        row.Cells["PROCESS_FILE_NAME"].Value = fileName;
                        row.Update();
                        MscMsc_BackLog.UpdateProcessFile(row.GetValue("PROCESS_FILE"), msc, mscPline, process, ob);
                        MessageUtil.ShowTips("上传成功！");

                    }
                    else
                    {
                        MessageUtil.ShowTips("上传失败,请重试！");
                    }
                }
            }
        }

        void ctrlMscBl1_AfterRowActivate(object sender, EventArgs e)
        {
            DataTable dt = DtMscRBlSpec.GetGroupBlInfo(ctrlMscBl1.UltraGrid1.GetActiveRowValue("msc"), ctrlMscBl1.UltraGrid1.GetActiveRowValue("GROUP_NUM"),
                ctrlMscBl1.UltraGrid1.GetActiveRowValue("PSC_BL"), ob);
            GridHelper.CopyDataToDatatable(dt, dataTable6, true);
        }

        private void ultraTextEditor8_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            if (ultraGrid2.ActiveCell.Column.Key == "SPEC_NAME")
            {
                string specs = ultraGrid2.GetActiveRowValue("SPEC_CODE");
                PopupSpecificationsBasics popup = new PopupSpecificationsBasics(specs, ob);
                DialogResult result = popup.ShowDialog();
                if (result == DialogResult.OK)
                {
                    string specCodes = "";
                    string specDescs = "";
                    foreach (string[] strs in popup.ChoiceSpecs)
                    {
                        if (specCodes == "")
                        {
                            specCodes += strs[0];
                            specDescs += strs[1];
                        }
                        else
                        {
                            specCodes += ";" + strs[0];
                            specDescs += ";" + strs[1];
                        }
                    }
                }
            }
            else if (ultraGrid2.ActiveCell.Column.Key == "MODEL_DESC")
            {
                UltraGridRow row = this.ultraGrid2.DisplayLayout.ActiveRow;
                FrmModel frms = new FrmModel();
                frms.Desc = row.Cells["Model_Desc"].Value.ToString();
                frms.FrmOb = ob;
                frms.ShowDialog();
            }
            ultraGrid1.ActiveRow.Update();
        }
    }
}