MES_Client/TGMES/Core.StlMes.Client.Qcm/FrmChemStandard.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Qcm.model;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Windows.Forms;

namespace Core.StlMes.Client.Qcm
{
    /// <summary>
    /// 化学成分标准
    /// </summary>
    public partial class FrmChemStandard : FrmBase
    {
        private bool isPasting = false;

        /// <summary>
        /// 成分索引号 
        /// </summary>
        private string cic = "";

        public string Cic
        {
            get { return cic; }
            set { cic = value; }
        }

        private string msc = "";

        public string Msc
        {
            get { return msc; }
            set { msc = value; }
        }

        //如果接箍为字符串空，会在SQL语句中新增接箍等于空的条件，所以单页面默认了个不为空的值。
        private string codeJg = "DefaultValue";

        public string CodeJg
        {
            get { return codeJg; }
            set { codeJg = value; }
        }

        private string stdCode = "";

        public string StdCode
        {
            get { return stdCode; }
            set { stdCode = value; }
        }

        private ArrayList steelCodes = new ArrayList();

        public ArrayList SteelCodes
        {
            get { return steelCodes; }
            set { steelCodes = value; }
        }

        private string produccodeNk = "";

        public string ProduccodeNk
        {
            get { return produccodeNk; }
            set { produccodeNk = value; }
        }

        private string steelcodeNk = "";

        public string SteelcodeNk
        {
            get { return steelcodeNk; }
            set { steelcodeNk = value; }
        }

        private string processCodeNk = "";

        public string ProcessCodeNk
        {
            get { return processCodeNk; }
            set { processCodeNk = value; }
        }

        private string modelCode = "";

        public string ModelCode
        {
            get { return modelCode; }
            set { modelCode = value; }
        }

        private string acceptBid = "";

        public string AcceptBid
        {
            get { return acceptBid; }
            set { acceptBid = value; }
        }

        //提示信息信息
        private string errMessage = "";
        //判断是否勾选记录
        //public int isSelect = 0;
        //是否展开
        private bool _isEx = false;
        //定位行
        private string _cic = "";
        private UltraComboEditor[] ultras = new UltraComboEditor[13];
        public FrmChemStandard()
        {
            //F1 F2功能
            IsLoadUserView = true;
            InitializeComponent();
            ExceptionHelper.RegistException();
        }

        public void PopupLoad(string customInfo, OpeBase ob)
        {
            this.CustomInfo = customInfo;
            this.ob = ob;
            FrmChemStandard_Load(null, null);
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;
                case "Save":
                    DoSave();
                    break;
                case "Delete":
                    DoDeleteOrResume(true);
                    break;
                case "Resume":
                    DoDeleteOrResume(false);
                    break;
                case "Copy":
                    Copy();
                    break;
                case "Paste":
                    isPasting = true;
                    try
                    {
                        Paste();
                    }
                    finally
                    {
                        isPasting = false;
                    }
                    break;
                case "Refresh":
                    InitDrop();
                    break;
                case "Group":
                    Group();
                    break;
                case "CancelGroup":
                    CancelGroup();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 复制
        /// </summary>
        private void Copy()
        {
            if (ultraGrid1.ActiveRow == null)
            {
                MessageUtil.ShowWarning("请选择记录后，再进行操作！");
                return;
            }
            ultraGrid1.UpdateData();
            DataTable copyTab = dataTable1.Copy();
            DataTable copyTab2 = dataTable2.Copy();
            copyTab.Clear();
            copyTab2.Clear();
            if (ultraGrid1.ActiveRow.HasParent())
            {
                foreach (UltraGridRow row in ultraGrid1.ActiveRow.ParentRow.ChildBands[0].Rows)
                {
                    if (row.GetValue("CHC") != "True") continue;
                    DataRow dr = copyTab.NewRow();
                    CopyRowToRow(((DataRowView)row.ListObject).Row, dr);
                    copyTab.Rows.Add(dr);
                }
            }
            else
            {
                foreach (UltraGridRow row in ultraGrid1.ActiveRow.ChildBands[0].Rows)
                {
                    DataRow dr = copyTab.NewRow();
                    CopyRowToRow(((DataRowView)row.ListObject).Row, dr);
                    copyTab.Rows.Add(dr);
                }
                DataRow dr2 = copyTab2.NewRow();
                CopyRowToRow(((DataRowView)ultraGrid1.ActiveRow.ListObject).Row, dr2);
                copyTab2.Rows.Add(dr2);
            }

            DataTable[] copyTabs = new DataTable[] { copyTab, copyTab2 };
            Clipboard.SetData("Cic", copyTabs);
        }

        private void CopyRowToRow(DataRow srcRow, DataRow desRow)
        {
            for (int i = 0; i < srcRow.Table.Columns.Count; i++)
            {
                string columnName = srcRow.Table.Columns[i].ColumnName;
                desRow[columnName] = srcRow[columnName];
            }
        }

        /// <summary>
        /// 粘贴
        /// </summary>
        private void Paste()
        {
            DataTable[] copyTabs = (DataTable[])Clipboard.GetData("Cic");
            if (copyTabs == null)
            {
                MessageUtil.ShowWarning("没有数据，请复制后再进行操作！");
                return;
            }
            DataTable copyTab = copyTabs[0];
            DataTable copyTab2 = copyTabs[1];
            if (copyTab == null || copyTab.Rows.Count == 0)
            {
                MessageUtil.ShowWarning("没有数据，请复制后再进行操作！");
                return;
            }
            dataTable1.BeginInit();
            string cic = "";
            UltraGridRow rowParent;
            if (ultraGrid1.ActiveRow.HasParent())
            {
                //if (ultraGrid1.ActiveRow.ParentRow.ChildBands[0].Rows.Count > 0)
                //{
                //    MessageUtil.ShowWarning("该记录下存在子记录，不能进行粘贴操作！");
                //    return;
                //}
                cic = ultraGrid1.ActiveRow.ParentRow.GetValue("CIC");
                rowParent = ultraGrid1.ActiveRow.ParentRow;
            }
            else
            {
                //if (ultraGrid1.ActiveRow.ChildBands[0].Rows.Count > 0)
                //{
                //    MessageUtil.ShowWarning("该记录下存在子记录，不能进行粘贴操作！");
                //    return;
                //}
                cic = ultraGrid1.GetActiveRowValue("CIC");
                rowParent = ultraGrid1.ActiveRow;
            }
            List<string> notCopyColumns = new List<string>();
            notCopyColumns.AddRange("CHC", "CREATE_TIME", "CREATE_NAME", "UPDATE_TIME", "UPDATE_NAME",
                "DELETE_TIME", "DELETE_NAME", "VALIDFLAG", "CIC", "MSC", "PSC_DESC", "PSC", "STDSTYLE", "STD_NAME_B",
                "PRODUCNAME", "STEELNAME", "STD_CODE_NK", "STD_NAME_NK", "PROCESS_CODE", "PROCESS_DESC", "STD_STYLE_DESC",
                "GRADECODE", "GRADENAME", "PRODUCCODE_NK", "PRODUCNAME_NK", "STEELCODE_NK", "STEELNAME_NK", "XH");

            if (CustomInfo == "2")
            {
                //内控子记录不要限制规格。
                notCopyColumns.AddRange("SIZE_CODE2", "SIZE_NAME2", "SIZE_MIN_SIGN2", "SIZE_MIN2", "SIZE_MAX_SIGN2",
                    "SIZE_MAX2", "SIZE_CODE", "SIZE_NAME", "SIZE_MIN_SIGN", "SIZE_MIN", "SIZE_MAX_SIGN", "SIZE_MAX",
                    "SPEC_JG", "SPEC_JG_DESC");
            }

            if (copyTab2.Rows.Count > 0)
            {
                DataRow drParent = ((DataRowView)rowParent.ListObject).Row;
                foreach (DataColumn column in dataTable2.Columns)
                {
                    string columnName = column.ColumnName;
                    if (notCopyColumns.Contains(columnName) == true) continue;
                    drParent[columnName] = copyTab2.Rows[0][columnName];
                }
            }

            foreach (DataRow row in copyTab.Rows)
            {
                DataRow tempRow = dataTable1.NewRow();
                foreach (DataColumn column in dataTable1.Columns)
                {
                    string columnName = column.ColumnName;
                    if (notCopyColumns.Contains(columnName) == true) continue;
                    if (!copyTab.Columns.Contains(columnName)) continue;
                    tempRow[columnName] = row[columnName];
                }
                tempRow["CIC"] = cic;
                dataTable1.Rows.Add(tempRow);
            }
            dataTable1.EndInit();
            if (copyTab.Rows.Count > 0 && ultraGrid1.ActiveRow != null)
            {
                ultraGrid1.ActiveRow.ExpandAll();
            }
            ultraGrid1.UpdateData();
        }

        /// <summary>
        /// 根据交付 内控 Alpha 分别隐藏不同列
        /// </summary>
        private void HideColumn()
        {
            if (CustomInfo == "1")
            {
                //内控标准名称
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CODE_NK"].Hidden = true;
                //适用工序
                ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_DESC"].Hidden = true;
                //适用钢种
                ultraGrid1.DisplayLayout.Bands[0].Columns["GRADENAME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STEELNAME_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["MODEL_DESC_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCCODE_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCNAME_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Groups[0].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Groups[1].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_D"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_D"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_H"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_H"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_D_SIGN"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_D_SIGN"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_H_SIGN"].Hidden = true;
                //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_H_SIGN"].Hidden = true;
                this.ultraCheckStd.Text = "标准名称";
            }
            if (CustomInfo == "2" || CustomInfo == "4")
            {
                //产品规范描述
                ultraGrid1.DisplayLayout.Bands[0].Columns["PSC_DESC"].Hidden = true;
                //冶金规范码
                ultraGrid1.DisplayLayout.Bands[0].Columns["MSC"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_NAME_B"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCNAME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STEELNAME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_STYLE_DESC"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SMELTING_CNT"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCT_CNT"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["RATE"].Hidden = true;
                if (CustomInfo == "2")
                {
                    ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CODE_NK"].Header.Caption = "内控管理编号";
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_CODE2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_CODE2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_NAME2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_NAME2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN_SIGN2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN_SIGN2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX_SIGN2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX_SIGN2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX2"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX2"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_CODE"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_CODE"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_NAME"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_NAME"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN_SIGN"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN_SIGN"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MIN"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX_SIGN"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX_SIGN"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SIZE_MAX"].CellActivation = Activation.ActivateOnly;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SPEC_JG"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[1].Columns["SPEC_JG"].CellActivation = Activation.ActivateOnly;
                }
                InnerChange();
                if (CustomInfo == "4")
                {
                    ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CODE"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_D"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_D"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_H"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_H"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_D_SIGN"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_D_SIGN"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MIN_H_SIGN"].Hidden = true;
                    //ultraGrid1.DisplayLayout.Bands[0].Columns["MAX_H_SIGN"].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Groups[0].Hidden = true;
                    ultraGrid1.DisplayLayout.Bands[0].Groups[1].Hidden = true;
                }
                ultraCheckMSC.Visible = false;
                ultraTextMSC.Visible = false;
            }
            if (CustomInfo == "3")
            {

                //产品规范描述
                ultraGrid1.DisplayLayout.Bands[0].Columns["PSC_DESC"].Hidden = true;
                //冶金规范码
                ultraGrid1.DisplayLayout.Bands[0].Columns["MSC"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_NAME_B"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCNAME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STEELNAME"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_STYLE_DESC"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CODE"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_DESC"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["STEELNAME_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["MODEL_DESC_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCCODE_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCNAME_NK"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["SMELTING_CNT"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Columns["PRODUCT_CNT"].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Groups[0].Hidden = true;
                ultraGrid1.DisplayLayout.Bands[0].Groups[1].Hidden = true;
                ultraCheckMSC.Visible = false;
                ultraTextMSC.Visible = false;
            }
        }

        /// <summary>
        /// 初始化数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmChemStandard_Load(object sender, EventArgs e)
        {
            HideColumn();
            InitDrop();
        }

        public void PopupRefresh()
        {
            UltraGridBand ugb = ultraGrid1.DisplayLayout.Bands[0];
            if (CustomInfo == "1")
            {
                //冶金规范码
                QcmBaseQuery.NitializeMSC(ultras[10], false, this.ob, msc);
                QcmBaseQuery.BindColumn(ultras[10], "MSC", ugb);
            }
        }

        /// <summary>
        /// 初始化下拉框
        /// </summary>
        private void InitDrop()
        {
            for (int i = 0; i < ultras.Length; i++)
            {
                ultras[i] = new UltraComboEditor();
                Controls.Add(ultras[i]);
                ultras[i].Visible = false;
                ultras[i].DropDownListWidth = -1;
            }
            //主表
            UltraGridBand ugb = ultraGrid1.DisplayLayout.Bands[0];
            //从表
            UltraGridBand ugbC = ultraGrid1.DisplayLayout.Bands[1];
            QcmBaseQuery.NitializeSignMin(ultraComSignMin);
            QcmBaseQuery.NitializeSignMax(ultraComSignMax);
            ClsBaseInfo.FillComBaseInfo(ultraComboEditor1, "4086", ob, false);
            DataTable dtRate = (DataTable)ultraComboEditor1.DataSource;
            dtRate.DefaultView.RowFilter = "BASECODE IN ('408602', '408603')";
            //下限
            QcmBaseQuery.NitializeSignMin(ultras[0]);
            //标准范围下限符号
            QcmBaseQuery.BindColumn(ultras[0], "STDMIN_SIGN", ugbC);
            //上限
            QcmBaseQuery.NitializeSignMax(ultras[1]);
            //标准范围上限符号
            QcmBaseQuery.BindColumn(ultras[1], "STDMAX_SIGN", ugbC);
            //化学元素描述
            QcmBaseQuery.NitializeChemicalElement(ultras[2], true, this.ob);
            QcmBaseQuery.BindColumn(ultras[2], "CHEM_CODE", ugbC);
            //结箍
            QcmBaseQuery.NitializeJG(ultras[3], true, this.ob);
            QcmBaseQuery.BindColumn(ultras[3], "SPEC_JG", ugbC);
            //限制元素下限符号
            QcmBaseQuery.BindColumn(ultras[0], "ELE_MIN_SIGN", ugbC);
            //限制规格(一)下限符号
            QcmBaseQuery.BindColumn(ultras[0], "SIZE_MIN_SIGN2", ugbC);
            //限制规格(二)下限符号
            QcmBaseQuery.BindColumn(ultras[0], "SIZE_MIN_SIGN", ugbC);
            //限制元素上限符号
            QcmBaseQuery.BindColumn(ultras[1], "ELE_MAX_SIGN", ugbC);
            //限制规格(一)上限符号
            QcmBaseQuery.BindColumn(ultras[1], "SIZE_MAX_SIGN2", ugbC);
            //限制规格(二)上限符号
            QcmBaseQuery.BindColumn(ultras[1], "SIZE_MAX_SIGN", ugbC);
            //限制规格（一）
            QcmBaseQuery.NitializeLimitSpecifications(ultras[5], true, this.ob);
            QcmBaseQuery.BindColumn(ultras[5], "SIZE_CODE2", ugbC);
            //限制规格（二）
            QcmBaseQuery.BindColumn(ultras[5], "SIZE_CODE", ugbC);
            if (CustomInfo == "1")
            {
                //成分偏差
                QcmBaseQuery.NitializeChemBias(ultras[6], true, this.ob);
                QcmBaseQuery.BindColumn(ultras[6], "STD_CODE", ugb);
                //冶金规范码
                QcmBaseQuery.NitializeMSC(ultras[10], false, this.ob, msc);
                QcmBaseQuery.BindColumn(ultras[10], "MSC", ugb);
            }
            if (CustomInfo == "2" || CustomInfo == "3" || CustomInfo == "4")
            {
                //标准名称
                if (CustomInfo == "2")
                {
                    QcmBaseQuery.NitializeInnerStandard(ultras[7], false, this.ob);
                    //成分偏差
                    QcmBaseQuery.NitializeChemBias(ultras[6], true, this.ob);
                    QcmBaseQuery.BindColumn(ultras[6], "STD_CODE", ugb);
                }
                else if (CustomInfo == "3")
                    QcmBaseQuery.NitializeAlphaStandard(ultras[7], false, this.ob);
                else
                    QcmBaseQuery.NitializeOtherStandard(ultras[7], false, this.ob);
                QcmBaseQuery.BindColumn(ultras[7], "STD_CODE_NK", ugb);
                //工序
                QcmBaseQuery.NitializeProcess(ultras[8], true, this.ob);
                QcmBaseQuery.BindColumn(ultras[8], "PROCESS_CODE", ugb);
                //钢种
                //QcmBaseQuery.NitializeGrade(ultras[9], true, this.ob);
                //QcmBaseQuery.BindColumn(ultras[9], "GRADECODE", ugb);

            }
            //限制元素
            QcmBaseQuery.NitializeChemicalElement(ultras[11], true, this.ob);
            QcmBaseQuery.BindColumn(ultras[11], "ELE_CODE", ugbC);
            //替代元素
            QcmBaseQuery.BindColumn(ultras[0], "REP_MIN_SIGN", ugbC);
            QcmBaseQuery.BindColumn(ultras[1], "REP_MAX_SIGN", ugbC);
            QcmBaseQuery.BindColumn(ultras[2], "REP_CODE", ugbC);

            QcmBaseQuery.NitializeProductBigType(ultras[12], false, ob);
            QcmBaseQuery.BindColumn(ultras[12], "PRODUC_HEAD", ugb);

        }

        private void Group()
        {
            //PopupGroup
            ultraGrid1.UpdateData();
            List<String> index = new List<string>();
            string cic = "";
            foreach (var pRow in ultraGrid1.Rows)
            {
                foreach (var cRow in pRow.ChildBands[0].Rows)
                {
                    if (cRow.GetValue("CHC").ToLower() == "true")
                    {
                        if (cRow.GetValue("VALIDFLAG") == "")
                        {
                            MessageUtil.ShowWarning("请先保存选择的记录！");
                            return;
                        }
                        index.Add(cRow.GetValue("INDEX_SEQ"));
                        cic = pRow.GetValue("CIC");
                    }
                }
                if (index.Count > 0) break;
            }
            if (index.Count == 0)
            {
                MessageUtil.ShowWarning("请选择从记录！");
                return;
            }

            PopupGroup popup = new PopupGroup();
            if (popup.ShowDialog() != System.Windows.Forms.DialogResult.OK)
            {
                return;
            }
            ServerHelper.SetData("com.steering.pss.qcm.CoreChemStandard.group",
                new object[] { index, cic, popup.NumGroupNum.Value.ToString3() }, ob);
            MessageUtil.ShowTips("分组成功！");
            _isEx = true;
            _cic = cic;
            DoQuery();
        }

        private void CancelGroup()
        {
            List<String> index = new List<string>();
            string cic = "";
            foreach (var pRow in ultraGrid1.Rows)
            {
                foreach (var cRow in pRow.ChildBands[0].Rows)
                {
                    if (cRow.GetValue("CHC").ToLower() == "true")
                    {
                        index.Add(cRow.GetValue("INDEX_SEQ"));
                        cic = pRow.GetValue("CIC");
                    }
                }
                if (index.Count > 0) break;
            }
            if (index.Count == 0)
            {
                MessageUtil.ShowWarning("请选择从记录！");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认取消分组？") == System.Windows.Forms.DialogResult.OK)
            {
                return;
            }
            ServerHelper.SetData("com.steering.pss.qcm.CoreChemStandard.cancelGroup",
                new object[] { index, cic }, ob);
            MessageUtil.ShowTips("取消分组成功！");
            _cic = cic;
            _isEx = true;
            DoQuery();
        }


        /// <summary>
        /// 查询条件
        /// </summary>
        /// <returns></returns>
        private ArrayList GetQueryData()
        {
            ArrayList list = new ArrayList();
            //标准名称
            string stdName = "";
            if (ultraCheckStd.Checked)
                stdName = ultraTextStd.Text.Trim();
            list.Add(stdName);
            //冶金规范码
            string msc = "";
            if (ultraCheckMSC.Checked)
            {
                msc = ultraTextMSC.Text.Trim();
            }
            list.Add(msc);
            //是否包含无效
            string valid = "1";
            if (ultraCheckValid.Checked)
                valid = "0";
            list.Add(valid);
            list.Add(stdCode);
            return list;
        }

        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
            //查询交付标准、内控标准或者Alpha
            ArrayList QueryConditon = GetQueryData();
            //主表查询
            dataTable1.Clear();
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getCoreChemStandard",
                new Object[] { QueryConditon, CustomInfo, cic, msc, codeJg, steelCodes, produccodeNk, steelcodeNk, processCodeNk, modelCode }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable2, true);
            //从表查询
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getCoreChemStandardC",
                new Object[] { QueryConditon, CustomInfo, cic, msc, codeJg, steelCodes, produccodeNk, steelcodeNk, processCodeNk, modelCode }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt1, ref this.dataTable1, true);
            //不同颜色区分是否有效数据
            QcmBaseCommon.SetGridColor(ultraGrid1, "VALIDFLAG", "无效");
            QcmBaseCommon.SetUltraGridNoEdit(ultraGrid1);
            UltraGridBand bc = ultraGrid1.DisplayLayout.Bands[0];
            UltraGridBand bcC = ultraGrid1.DisplayLayout.Bands[1];
            UltraGridColumn[] col = new UltraGridColumn[] { bc.Columns["MEMO"],bc.Columns["MSC"], bc.Columns["STD_CODE_NK"] ,
            bcC.Columns["ISCHECK"],bcC.Columns["ISJUDGE"],bcC.Columns["ISQUOTE"],bc.Columns["MODEL_DESC"],
            bcC.Columns["COMPLEX_TYPE"],bcC.Columns["STDMIN"],bcC.Columns["STDMAX"]};
            //GridHelper.RefreshAndAutoSizeExceptRows(ultraGrid1, col);
            //isSelect = 0;
            //定位行和展开行
            UltraGridRow[] rows1 = GridHelper.GetRowsWithKey(ultraGrid1, new string[] { "CIC" }, new string[] { _cic });
            if (rows1.Length > 0)
            {
                rows1[0].Activate();
                if (_isEx)
                    rows1[0].ExpandAll();
            }
            _isEx = false;
            _cic = "";
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                ultraGrid1.UpdateData();
                DataView dv = new DataView(dataTable1);
                DataTable newdt = dv.ToTable(false, "CIC", "CHEM_NAME");
                DataRow[] dr = newdt.Select("CIC='" + ugr.Cells["CIC"].Value.ToString() + "'", "");
                ugr.Cells["COUNT"].Value = newdt.AsEnumerable().Where(a => a["CIC"].ToString() == ugr.Cells["CIC"].Value.ToString()).Distinct(new DataRowComparer()).Count();
                ugr.Cells["CHKNK"].Value = "选择";
            }
            ultraGrid1.UpdateData();
            dataTable1.AcceptChanges();
            dataTable2.AcceptChanges();
            //清空复制数据
            //_copyedRows.Clear();
        }

        private void DoQuery1()
        {
            //查询交付标准、内控标准或者Alpha
            ArrayList QueryConditon = GetQueryData();
            //主表查询
            dataTable1.Clear();
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getComChemNK",
                new Object[] { msc }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable2, true);
            //从表查询
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getComChemNKC",
                new Object[] { msc }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt1, ref this.dataTable1, true);
            //不同颜色区分是否有效数据
            QcmBaseCommon.SetGridColor(ultraGrid1, "VALIDFLAG", "无效");
            QcmBaseCommon.SetUltraGridNoEdit(ultraGrid1);
            UltraGridBand bc = ultraGrid1.DisplayLayout.Bands[0];
            UltraGridBand bcC = ultraGrid1.DisplayLayout.Bands[1];
            UltraGridColumn[] col = new UltraGridColumn[] { bc.Columns["MEMO"],bc.Columns["MSC"], bc.Columns["STD_CODE_NK"] ,
            bcC.Columns["ISCHECK"],bcC.Columns["ISJUDGE"],bcC.Columns["ISQUOTE"],bc.Columns["MODEL_DESC"],
            bcC.Columns["COMPLEX_TYPE"],bcC.Columns["STDMIN"],bcC.Columns["STDMAX"]};
            //GridHelper.RefreshAndAutoSizeExceptRows(ultraGrid1, col);
            //isSelect = 0;
            //定位行和展开行
            UltraGridRow[] rows1 = GridHelper.GetRowsWithKey(ultraGrid1, new string[] { "CIC" }, new string[] { _cic });
            if (rows1.Length > 0)
            {
                rows1[0].Activate();
                if (_isEx)
                    rows1[0].ExpandAll();
            }
            _isEx = false;
            _cic = "";
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                ultraGrid1.UpdateData();
                DataView dv = new DataView(dataTable1);
                DataTable newdt = dv.ToTable(false, "CIC", "CHEM_NAME");
                DataRow[] dr = newdt.Select("CIC='" + ugr.Cells["CIC"].Value.ToString() + "'", "");
                ugr.Cells["COUNT"].Value = newdt.AsEnumerable().Where(a => a["CIC"].ToString() == ugr.Cells["CIC"].Value.ToString()).Distinct(new DataRowComparer()).Count();
            }
            ultraGrid1.UpdateData();
            dataTable1.AcceptChanges();
            dataTable2.AcceptChanges();
            //清空复制数据
            //_copyedRows.Clear();
        }

        public void QueryPurchaseAgreement(string stdCodeNk)
        {
            dataTable1.Clear();
            dataTable2.Clear();
            DataTable dtP = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getPurchaseAgreementCic",
                new object[] { stdCodeNk }, ob);
            GridHelper.CopyDataToDatatable(ref dtP, ref this.dataTable2, true);
            DataTable dtC = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getPurchaseAgreementChem",
                new object[] { stdCodeNk }, ob);
            GridHelper.CopyDataToDatatable(ref dtC, ref this.dataTable1, true);
            QcmBaseCommon.SetGridColor(ultraGrid1, "VALIDFLAG", "无效");
            QcmBaseCommon.SetUltraGridNoEdit(ultraGrid1);
        }

        private int GetGridSelectCount()
        {
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (row.Cells["CHC"].Value.ToString() == "True")
                {
                    return 1;
                }
                UltraGridRow[] rows = GridHelper.GetRowsWithKey(row.ChildBands[0],
                    new string[] { "CHC" }, new string[] { "True" });
                if (rows.Length > 0)
                {
                    return 1;
                }
            }
            return 0;
        }

        private DataRow GetComBaseStdRowByPk(string stdCode)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComStandard.getComBaseStdByPk",
                new object[] { stdCode }, ob);
            return dt.Rows[0];
        }



        /// <summary>
        /// 保存
        /// </summary>
        private void DoSave()
        {
            try
            {
                ultraGrid1.UpdateData();
            }
            catch (Exception)
            {

                MessageBox.Show("数据不合法，请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            DataRow comBaseStdRow = null;
            string style = "G";
            if (CustomInfo == "2")
            {
                comBaseStdRow = GetComBaseStdRowByPk(stdCode);
                if (comBaseStdRow["ACCEPT_BID"].ToString() == "1")
                {
                    style = "N";
                }
                else
                {
                    style = "L";
                }
            }
            if (CustomInfo == "3")
                style = "K";
            if (CustomInfo == "4")
                style = "S";

            if (GetGridSelectCount() == 0)
            {
                MessageBox.Show("请选择记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            if (CustomInfo == "2")
            {
                /*if (comBaseStdRow["ACCEPT_BID"].ToString() == "1" && comBaseStdRow["UNIT_CODE"].ToString() != UserInfo.GetDeptid()
                    && UserInfo.GetUserID() != "admin" && UserInfo.GetUserID() != "longjinhua")
                {
                    MessageUtil.ShowWarning("该记录只有[" + comBaseStdRow["UNIT_DESC"].ToString() + "]的成员才能操作！");
                    return;
                }*/

                //限制同一钢种下的成分数
                var groupRows = ultraGrid1.Rows.Where(a => a.GetValue("CHC") == "True" && a.GetValue("VALIDFLAG") == "").GroupBy(
                a => new { gradeCode = a.GetValue("GRADECODE"), gradeName = a.GetValue("GRADENAME") }).Select(
                a => new { gradeCode = a.Key.gradeCode, gradeName = a.Key.gradeName, cnt = a.Count() });
                foreach (var groupRow in groupRows)
                {
                    int cnt = FrmStandarNSub.GetSameGradeCnt(groupRow.gradeCode, stdCode, ob);
                    if (cnt + groupRow.cnt > 9)
                    {
                        MessageUtil.ShowWarning("钢种：" + groupRow.gradeName + " 已存在" + cnt + "条成分内控，" + "新增成分内控" + groupRow.cnt + "条，总数大于9条，无法新增！");
                        return;
                    }
                }

                //验证碳当量
                foreach (var pRow in ultraGrid1.Rows)
                {
                    var chkRowsC = pRow.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True");
                    if (chkRowsC.Count() == 0) continue;
                    //var groupSeqRows = pRow.ChildBands[0].Rows.GroupBy(a => a.GetValue("GROUP_SEQ"));
                    //foreach (var groupRow in groupSeqRows)
                    //{
                    //    var ce2Rows = groupRow.Where(a => a.GetValue("CHEM_CODE") == "C030" || a.GetValue("CHEM_CODE") == "C053"
                    //        || a.GetValue("CHEM_CODE") == "C060");
                    //    var cePRows = groupRow.Where(a => a.GetValue("CHEM_CODE") == "C031");
                    //    if (ce2Rows.Count() > 0 && cePRows.Count() > 0 && ce2Rows.Where(a => a.GetValue("ELE_CODE") != "").Count() == 0
                    //        && cePRows.Where(a => a.GetValue("ELE_CODE") != "").Count() == 0)
                    //    {
                    //        MessageUtil.ShowWarning("成分索引：" + pRow.GetValue("CIC") + "包含两种碳当量元素，必须维护限制元素！");
                    //        pRow.Activate();
                    //        return;
                    //    }
                    //}

                    //var cRows = pRow.ChildBands[0].Rows.Where(a => (a.GetValue("CHEM_CODE") == "C030" || a.GetValue("CHEM_CODE") == "C053"
                    //    || a.GetValue("CHEM_CODE") == "C060") || a.GetValue("CHEM_CODE") == "C031");
                    //if (cRows.Count() > 1 && cRows.Where(a => a.GetValue("ELE_CODE") != "").Count() == 0)
                    //{

                    //}
                }

                // 验证成分项目是否重复
                //var pRows = ultraGrid1.Rows;
                //foreach (var row in pRows)
                //{
                //    var chkRowsC = row.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True");
                //    if (chkRowsC.Count() == 0) continue;
                //    var groupRowsC = row.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True" || a.GetValue("VALIDFLAG") != "").GroupBy(
                //        a => a.GetValue("CHEM_CODE")).Select(a => a.Key).ToList();

                //    //验证保存的索引码是否重复
                //    var pRows2 = pRows.Where(a => a.GetValue("CIC") != row.GetValue("CIC") && a.GetValue("GRADECODE") == row.GetValue("GRADECODE"));
                //    foreach (var row2 in pRows2)
                //    {
                //        var chkRowsC2 = row2.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True");
                //        if (chkRowsC2.Count() == 0) continue;
                //        var groupRowsC2 = row2.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True" || a.GetValue("VALIDFLAG") != "").GroupBy(
                //            a => a.GetValue("CHEM_CODE")).Select(a => a.Key).ToList();

                //        if (groupRowsC2.Count() == groupRowsC.Count())
                //        {
                //            bool isSame = true;
                //            foreach (var groupRowC in groupRowsC)
                //            {
                //                if (!groupRowsC2.Contains(groupRowC))
                //                {
                //                    isSame = false;
                //                }
                //            }
                //            if (isSame)
                //            {
                //                MessageUtil.ShowWarning("成分索引码：" + row.GetValue("CIC") + "与" + row2.GetValue("CIC") + "中的成分项目重复！");
                //                return;
                //            }
                //        }
                //    }

                //    // 验证是否与数据库中的重复
                //    CoreClientParam ccp = new CoreClientParam();
                //    ccp.ServerName = "com.steering.pss.qcm.CoreChemStandard";
                //    ccp.MethodName = "getChemByGrade";
                //    ccp.ServerParams = new object[] { groupRowsC, stdCode, row.GetValue("GRADECODE"), row.GetValue("CIC"), "保存" };
                //    ccp = ob.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal);
                //    if (ccp.ReturnObject.ToString2() != "")
                //    {
                //        MessageUtil.ShowWarning(ccp.ReturnObject.ToString2());
                //        return;
                //    }
                //}
            }

            ArrayList baseData = new ArrayList();
            ArrayList childData = new ArrayList();
            for (int i = 0; i < ultraGrid1.Rows.Count; i++)
            {
                DataRow cicRow = null;
                UltraGridRow ugr = ultraGrid1.Rows[i];
                //主表操作
                if (Convert.ToBoolean(ugr.Cells["CHC"].Value))
                {
                    if (ugr.GetValue("VALIDFLAG") != "")
                    {
                        cicRow = GetMscCicByCic(ugr.GetValue("CIC"));
                    }

                    if (comBaseStdRow != null && comBaseStdRow["ACCEPT_BID"].ToString() == "0" && cicRow != null)
                    {
                        string[] units = ClsBaseInfo.GetUnitByUserName(cicRow["CREATE_NAME"].ToString(), ob, "002001007", "002001001", "002023005");
                        /*if (units[0] != UserInfo.GetDeptid() && UserInfo.GetUserID() != "admin")
                        {
                            MessageUtil.ShowWarning("该记录只有[" + units[1] + "]才能操作！");
                            ugr.Activate();
                            return;
                        }*/
                    }
                    StdCicObject com = GetBaseData(ugr, cicRow);
                    if (com == null)
                    {
                        MessageBox.Show(errMessage, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    _cic = com.Cic;
                    baseData.Add(JSONFormat.Format(com));
                }
                //从表操作
                if (ugr.HasChild())
                {
                    if (ugr.Cells["VALIDFLAG"].Value.ToString().Equals("") && !Convert.ToBoolean(ugr.Cells["CHC"].Value))
                    {
                        MessageBox.Show("请选择主记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    for (int j = 0; j < ugr.ChildBands[0].Rows.Count; j++)
                    {
                        UltraGridRow ugrc = ugr.ChildBands[0].Rows[j];
                        if (Convert.ToBoolean(ugrc.Cells["CHC"].Value))
                        {
                            if (ugr.GetValue("VALIDFLAG") != "")
                            {
                                cicRow = GetMscCicByCic(ugr.GetValue("CIC"));
                            }

                            if (comBaseStdRow != null && comBaseStdRow["ACCEPT_BID"].ToString() == "0" && cicRow != null)
                            {
                                string[] units = ClsBaseInfo.GetUnitByUserName(cicRow["CREATE_NAME"].ToString(), ob, "002001007", "002001001", "002023005");
                                /*if (units[0] != UserInfo.GetDeptid() && UserInfo.GetUserID() != "admin")
                                {
                                    MessageUtil.ShowWarning("该记录只有[" + units[1] + "]才能操作！");
                                    ugrc.Activate();
                                    return;
                                }*/
                            }

                            //验证是否被计划使用
                            //if (CustomInfo == "2")
                            //{
                            //    string plnMsg = FrmStandardN.CheckPlnCic(ugr.GetValue("CIC"), ob);
                            //    if (plnMsg != "")
                            //    {
                            //        MessageUtil.ShowWarning(plnMsg);
                            //        ugrc.Activate();
                            //        return;
                            //    }
                            //}
                            StdChemObject comc = GetChildData(ugrc, cicRow);
                            if (comc == null)
                            {
                                MessageBox.Show(errMessage, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                return;
                            }
                            _cic = comc.Cic;
                            _isEx = true;
                            childData.Add(JSONFormat.Format(comc));
                        }
                    }
                }
            }
            if (MessageBox.Show("是否保存选择记录?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            if (baseData.Count > 0 || childData.Count > 0)
            {
                int count = ServerHelper.SetData("com.steering.pss.qcm.CoreChemStandard.saveCoreChemStandard",
                    new Object[] { baseData, childData, style }, this.ob);
                if (count > 0)
                {
                    MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    DoQuery();
                }

            }

        }

        /// <summary>
        /// 删除或者恢复
        /// </summary>
        /// <param name="flag"></param>
        private void DoDeleteOrResume(Boolean flag)
        {
            try
            {
                ultraGrid1.UpdateData();
            }
            catch (Exception)
            {

                MessageBox.Show("数据不合法，请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (GetGridSelectCount() == 0)
            {
                MessageBox.Show("请选择记录", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DataRow comBaseStdRow = null;
            if (CustomInfo == "2")
            {
                comBaseStdRow = GetComBaseStdRowByPk(stdCode);
                /*if (comBaseStdRow["ACCEPT_BID"].ToString() == "1" && comBaseStdRow["UNIT_CODE"].ToString() != UserInfo.GetDeptid()
                    && UserInfo.GetUserID() != "admin")
                {
                    MessageUtil.ShowWarning("该记录只有[" + comBaseStdRow["UNIT_DESC"].ToString() + "]的成员才能" + (flag ? "作废" : "恢复") + "！");
                    return;
                }*/

                if (!flag)
                {
                    //限制同一钢种下的成分数
                    var groupRows = ultraGrid1.Rows.Where(a => a.GetValue("CHC") == "True" && a.GetValue("VALIDFLAG") == "无效").GroupBy(
                    a => new { gradeCode = a.GetValue("GRADECODE"), gradeName = a.GetValue("GRADENAME") }).Select(
                    a => new { gradeCode = a.Key.gradeCode, gradeName = a.Key.gradeName, cnt = a.Count() });
                    foreach (var groupRow in groupRows)
                    {
                        int cnt = FrmStandarNSub.GetSameGradeCnt(groupRow.gradeCode, stdCode, ob);
                        if (cnt + groupRow.cnt > 9)
                        {
                            MessageUtil.ShowWarning("钢种：" + groupRow.gradeName + " 已存在" + cnt + "条成分内控，" + "恢复成分内控" + groupRow.cnt + "条，总数大于9条，无法恢复！");
                            return;
                        }
                    }

                    // 验证成分项目是否重复
                    var pRows = ultraGrid1.Rows;
                    foreach (var row in pRows)
                    {
                        var chkRowsC = row.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True");
                        if (chkRowsC.Count() == 0) continue;
                        var groupRowsC = row.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True" || a.GetValue("VALIDFLAG") != "无效").GroupBy(
                            a => a.GetValue("CHEM_CODE")).Select(a => a.Key).ToList();

                        //验证保存的索引码是否重复
                        var pRows2 = pRows.Where(a => a.GetValue("CIC") != row.GetValue("CIC") && a.GetValue("GRADECODE") == row.GetValue("GRADECODE"));
                        foreach (var row2 in pRows2)
                        {
                            var chkRowsC2 = row2.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True");
                            if (chkRowsC2.Count() == 0) continue;
                            var groupRowsC2 = row2.ChildBands[0].Rows.Where(a => a.GetValue("CHC") == "True" || a.GetValue("VALIDFLAG") != "无效").GroupBy(
                                a => a.GetValue("CHEM_CODE")).Select(a => a.Key).ToList();

                            if (groupRowsC2.Count() == groupRowsC.Count())
                            {
                                bool isSame = true;
                                foreach (var groupRowC in groupRowsC)
                                {
                                    if (!groupRowsC2.Contains(groupRowC))
                                    {
                                        isSame = false;
                                    }
                                }
                                if (isSame)
                                {
                                    MessageUtil.ShowWarning("恢复后的成分索引码：" + row.GetValue("CIC") + "与" + row2.GetValue("CIC") + "中的成分项目重复，无法恢复！");
                                    return;
                                }
                            }
                        }

                        // 验证是否与数据库中的重复
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "com.steering.pss.qcm.CoreChemStandard";
                        ccp.MethodName = "getChemByGrade";
                        ccp.ServerParams = new object[] { groupRowsC, stdCode, row.GetValue("GRADECODE"), row.GetValue("CIC"), "恢复" };
                        ccp = ob.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnObject.ToString2() != "")
                        {
                            MessageUtil.ShowWarning(ccp.ReturnObject.ToString2());
                            return;
                        }
                    }
                }
            }

            ArrayList baseList = new ArrayList();
            ArrayList childList = new ArrayList();
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHC"].Value.ToString()))
                {
                    if (CheckAuthority(ugr) == false)
                    {
                        MessageUtil.ShowWarning(errMessage);
                        return;
                    }
                    DataRow rowCic = null;
                    if (ugr.GetValue("VALIDFLAG") != "")
                    {
                        rowCic = GetMscCicByCic(ugr.GetValue("CIC"));
                    }
                    if (comBaseStdRow != null && comBaseStdRow["ACCEPT_BID"].ToString() == "0" && rowCic != null)
                    {
                        string[] units = ClsBaseInfo.GetUnitByUserName(rowCic["CREATE_NAME"].ToString(), ob, "002001007", "002001001", "002023005");
                        /*if (units[0] != UserInfo.GetDeptid() && UserInfo.GetUserID() != "admin")
                        {
                            MessageUtil.ShowWarning("该记录只有[" + units[1] + "]才能操作！");
                            ugr.Activate();
                            return;
                        }*/
                    }
                    //验证是否被计划使用
                    //if (CustomInfo == "2")
                    //{
                    //    string plnMsg = FrmStandardN.CheckPlnCic(ugr.GetValue("CIC"), ob);
                    //    if (plnMsg != "")
                    //    {
                    //        MessageUtil.ShowWarning(plnMsg);
                    //        ugr.Activate();
                    //        return;
                    //    }
                    //}
                    if (CheckDataParent(ugr, rowCic, flag) == false)
                    {
                        return;
                    }
                    if (CheckRows(ugr) && flag)
                    {
                        MessageBox.Show("无效记录不能作废！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    if (ugr.Cells["VALIDFLAG"].Value.ToString().Equals("提交审核") || ugr.Cells["VALIDFLAG"].Value.ToString().Equals("已审核"))
                    {
                        MessageBox.Show("提交审核或已审核记录不能作废！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    if (!CheckRows(ugr) && !flag)
                    {
                        MessageBox.Show("有效记录不能恢复！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }
                    StdCicObject com = new StdCicObject();
                    com.Cic = ugr.Cells["CIC"].Value.ToString();
                    com.DeleteName = UserInfo.GetUserName();
                    baseList.Add(JSONFormat.Format(com));
                    if (flag && ugr.HasChild())
                    {
                        if (MessageBox.Show("所对应子记录都将作废！", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                        {
                            return;
                        }
                        foreach (UltraGridRow ugrC in ugr.ChildBands[0].Rows)
                        {
                            StdChemObject comC = new StdChemObject();
                            comC.Cic = ugrC.Cells["CIC"].Value.ToString();
                            comC.IndexSeq = ugrC.Cells["INDEX_SEQ"].Value.ToString();
                            comC.DeleteName = UserInfo.GetUserName();
                            childList.Add(JSONFormat.Format(comC));
                        }
                    }
                    _cic = ugr.Cells["CIC"].Value.ToString();
                }
                //如果主表行拥有子项
                if (ugr.HasChild())
                {
                    foreach (UltraGridRow ugrC in ugr.ChildBands[0].Rows)
                    {
                        //如果子项被勾选
                        if (Convert.ToBoolean(ugrC.Cells["CHC"].Value.ToString()))
                        {
                            DataRow rowCic = null;
                            if (ugr.GetValue("VALIDFLAG") != "")
                            {
                                rowCic = GetMscCicByCic(ugr.GetValue("CIC"));
                            }
                            if (comBaseStdRow != null && comBaseStdRow["ACCEPT_BID"].ToString() == "0" && rowCic != null)
                            {
                                string[] units = ClsBaseInfo.GetUnitByUserName(rowCic["CREATE_NAME"].ToString(), ob, "002001007", "002001001", "002023005");
                                /*if (units[0] != UserInfo.GetDeptid() && UserInfo.GetUserID() != "admin")
                                {
                                    MessageUtil.ShowWarning("该记录只有[" + units[1] + "]才能操作！");
                                    ugrC.Activate();
                                    return;
                                }*/
                            }

                            //验证是否被计划使用
                            //if (CustomInfo == "2")
                            //{
                            //    string plnMsg = FrmStandardN.CheckPlnCic(ugr.GetValue("CIC"), ob);
                            //    if (plnMsg != "")
                            //    {
                            //        MessageUtil.ShowWarning(plnMsg);
                            //        ugrC.Activate();
                            //        return;
                            //    }
                            //}

                            if (CheckAuthority(ugrC) == false)
                            {
                                MessageUtil.ShowWarning(errMessage);
                                return;
                            }
                            if (!flag && CheckRows(ugrC.ParentRow) && !Convert.ToBoolean(ugrC.ParentRow.Cells["CHC"].Value))
                            {
                                MessageBox.Show("请选择主记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                return;
                            }
                            if (CheckRows(ugrC) && flag)
                            {
                                MessageBox.Show("无效记录不能作废", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                return;
                            }
                            if (!CheckRows(ugrC) && !flag)
                            {
                                MessageBox.Show("有效记录不能恢复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                                return;
                            }
                            if (flag)
                            {
                                if (ugr.Cells["VALIDFLAG"].Value.ToString() != ""
                                    && ugrC.ParentRow.Cells["VALIDFLAG"].Value.ToString() != "录入状态"
                                    && ugrC.ParentRow.Cells["VALIDFLAG"].Value.ToString() != "无效")
                                {
                                    MessageUtil.ShowWarning("主记录为提交审核或已审核状态时，无法作废");
                                    return;
                                }
                            }
                            StdChemObject comC = new StdChemObject();
                            comC.Cic = ugrC.Cells["CIC"].Value.ToString();
                            comC.IndexSeq = ugrC.Cells["INDEX_SEQ"].Value.ToString();
                            comC.DeleteName = UserInfo.GetUserName();
                            childList.Add(JSONFormat.Format(comC));
                            _cic = ugr.Cells["CIC"].Value.ToString();
                            _isEx = true;
                        }
                    }
                }
            }
            if (MessageBox.Show("是否" + (flag ? "作废" : "恢复") + "选择记录", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            if (baseList.Count > 0 || childList.Count > 0)
            {
                int count = ServerHelper.SetData("com.steering.pss.qcm.CoreChemStandard.deleteOrResume", new Object[] { baseList, childList, flag }, this.ob);
                if (count > 0)
                {
                    DoQuery();
                    MessageBox.Show((flag ? "作废" : "恢复") + "成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
                }
            }
        }


        /// <summary>
        /// 行记录是否有效
        /// </summary>
        /// <param name="ugr"></param>
        /// <returns></returns>
        private bool CheckRows(UltraGridRow ugr)
        {
            if (ugr.Cells["VALIDFLAG"].Value.ToString().Equals("无效"))
                return true;
            else
                return false;
        }

        private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {
            string style = "";
            if (CustomInfo == "1")
                style = "G";
            if (CustomInfo == "2")
                style = "N";
            if (CustomInfo == "3")
                style = "K";
            if (CustomInfo == "4")
                style = "S";
            UltraGridRow ugr = ultraGrid1.DisplayLayout.ActiveRow;
            if (!ugr.HasParent()) //主表自动填充主键（成分索引号）
            {
                string sic = "";
                int temp = 0;
                for (int i = 0; i < ultraGrid1.Rows.Count - 1; i++)
                {
                    string str = ultraGrid1.Rows[i].Cells["CIC"].Value.ToString().Substring(4, 6);
                    if (Convert.ToInt32(str) > temp)
                        temp = Convert.ToInt32(str);
                }
                sic = "CIC" + style + string.Format("{0:000000}", temp + 1);
                ugr.Cells["CIC"].Value = sic;
                //ugr.Cells["COUNT"].Value = "0";
            }
            else
            {
                ugr.Cells["ISCHECK"].Value = true;
                ugr.Cells["ISJUDGE"].Value = true;
                ugr.Cells["ISQUOTE"].Value = true;
            }
            //增加行如果没有勾选则不可编辑
            if (!Convert.ToBoolean(ugr.Cells["CHC"].Value))
            {
                for (int i = 0; i < ugr.Cells.Count; i++)
                {
                    if (!ugr.Cells[i].Column.Key.Equals("CHC"))
                        ugr.Cells[i].Activation = Activation.ActivateOnly;
                    if (ugr.Cells[i].Column.Key.Equals("CHKNK"))
                        ugr.Cells["CHKNK"].Value = "选择";
                }
            }
            e.Row.Update();
        }
        /// <summary>
        /// 单元格值变化事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            if (e.Cell.Column.Key.Equals("STDMIN") || e.Cell.Column.Key.Equals("STDMAX") || e.Cell.Column.Key.Equals("STDMIN")
                || e.Cell.Column.Key.Equals("ELE_MIN") || e.Cell.Column.Key.Equals("ELE_MAX") || e.Cell.Column.Key.Equals("SIZE_MIN2") ||
                e.Cell.Column.Key.Equals("SIZE_MIN") || e.Cell.Column.Key.Equals("SIZE_MAX2") || e.Cell.Column.Key.Equals("SIZE_MAX"))
                return;
            ultraGrid1.UpdateData();
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            if (e.Cell.Column.Key.Equals("CHEM_CODE"))         /// 成分下拉框操作
            {
                ugr.Cells["CHEM_NAME"].Value = ugr.Cells["CHEM_CODE"].Text;
                string chemCode = ugr.Cells["CHEM_CODE"].Value.ToString();
                DataRow[] dr = ((DataTable)ultras[2].DataSource).Select("CHEM_CODE ='" + chemCode + "'");
                if (dr.Length > 0)
                {
                    ugr.Cells["XH"].Value = Convert.ToInt32(dr[0][0].ToString().Substring(1));
                    ugr.Cells["CHEM_TYPE"].Value = dr[0][2];
                    ugr.Cells["CHEM_FORMULA"].Value = dr[0][3];
                }
                else
                {
                    ugr.Cells["CHEM_NAME"].Value = "";
                    ugr.Cells["CHEM_TYPE"].Value = "";
                    ugr.Cells["CHEM_FORMULA"].Value = "";
                }
            }
            if (e.Cell.Column.Key.Equals(""))     //接箍操作
            {
                ugr.Cells["SPEC_JG_DESC"].Value = ugr.Cells["SPEC_JG"].Text;
            }
            if (e.Cell.Column.Key.Equals("MSC"))//冶金规范码
            {
                string msc = ugr.Cells["MSC"].Value.ToString();
                DataRow[] dr = ((DataTable)ultras[10].DataSource).Select("MSC='" + msc + "'");
                if (dr.Length > 0)
                {
                    ugr.Cells["PSC"].Value = dr[0][2];
                    ugr.Cells["PSC_DESC"].Value = dr[0][3];
                    ugr.Cells["PRODUCNAME"].Value = dr[0][4];
                    ugr.Cells["STD_NAME_B"].Value = dr[0][5];
                    ugr.Cells["STEELNAME"].Value = dr[0][6];
                    ugr.Cells["STD_STYLE_DESC"].Value = dr[0][7];
                    ugr.Cells["STDSTYLE"].Value = dr[0][8];
                }

            }
            if (e.Cell.Column.Key.Equals("SIZE_CODE2"))           //限制规格描述一
            {
                ugr.Cells["SIZE_NAME2"].Value = ugr.Cells["SIZE_CODE2"].Text;
                string code2 = ugr.Cells["SIZE_CODE2"].Value.ToString();
                string code = ugr.Cells["SIZE_CODE"].Value.ToString();
                if (!code2.Equals("") && !code.Equals("") && code.Equals(code2))
                {
                    MessageBox.Show("请重新选择限制规格<一>：限制规格", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    ugr.Cells["SIZE_NAME2"].Value = "";
                    ugr.Cells["SIZE_CODE2"].Value = "";
                    return;
                }
                if (ugr.Cells["SIZE_CODE2"].Value.ToString() == "")
                {
                    ugr.Cells["SIZE_MIN_SIGN2"].Value = "";
                    ugr.Cells["SIZE_MIN2"].Value = "";
                    ugr.Cells["SIZE_MAX_SIGN2"].Value = "";
                    ugr.Cells["SIZE_MAX2"].Value = "";
                }
            }

            if (e.Cell.Column.Key.Equals("SIZE_CODE"))           //限制规格描述二
            {
                ugr.Cells["SIZE_NAME"].Value = ugr.Cells["SIZE_CODE"].Text;
                string code2 = ugr.Cells["SIZE_CODE2"].Value.ToString();
                string code = ugr.Cells["SIZE_CODE"].Value.ToString();
                if (!code2.Equals("") && !code.Equals("") && code.Equals(code2))
                {
                    MessageBox.Show("请重新选择限制规格<二>：限制规格", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ugr.Cells["SIZE_NAME"].Value = "";
                    ugr.Cells["SIZE_CODE"].Value = "";
                    return;
                }

                if (ugr.Cells["SIZE_CODE"].Value.ToString() == "")
                {
                    ugr.Cells["SIZE_MIN_SIGN"].Value = "";
                    ugr.Cells["SIZE_MIN"].Value = "";
                    ugr.Cells["SIZE_MAX_SIGN"].Value = "";
                    ugr.Cells["SIZE_MAX"].Value = "";
                }
            }

            if (e.Cell.Column.Key.Equals("ELE_CODE"))           //限制元素描述
            {
                ugr.Cells["ELE_NAME"].Value = ugr.Cells["ELE_CODE"].Text;
                if (ugr.Cells["ELE_CODE"].Value.ToString() == "")
                {
                    ugr.Cells["ELE_MIN_SIGN"].Value = "";
                    ugr.Cells["ELE_MIN"].Value = "";
                    ugr.Cells["ELE_MAX_SIGN"].Value = "";
                    ugr.Cells["ELE_MAX"].Value = "";
                    ugr.Update();
                }
            }

            if (e.Cell.Column.Key.Equals("REP_CODE"))           //替代元素描述
            {
                ugr.Cells["REP_NAME"].Value = ugr.Cells["REP_CODE"].Text;
                if (ugr.Cells["REP_CODE"].Value.ToString() == "")
                {
                    ugr.Cells["REP_MIN_SIGN"].Value = "";
                    ugr.Cells["REP_MIN"].Value = "";
                    ugr.Cells["REP_MAX_SIGN"].Value = "";
                    ugr.Cells["REP_MAX"].Value = "";
                    ugr.Cells["REP_VAL"].Value = "";

                }
            }

            if (e.Cell.Column.Key.Equals("CHC"))                //
            {
                Activation activation = Activation.ActivateOnly;
                if (Convert.ToBoolean(e.Cell.Value))
                {
                    activation = Activation.AllowEdit;
                    //isSelect += 1;
                }
                //else
                //isSelect -= 1;
                CellsCollection cells = e.Cell.Row.Cells;
                for (int i = 0; i < cells.Count; i++)
                {
                    if (!cells[i].Column.Key.Equals("CHC"))
                    {
                        e.Cell.Row.Cells[i].Activation = activation;
                    }
                }
            }

            if (e.Cell.Column.Key.Equals("GRADECODE"))       //钢种下拉框操作
            {
                ugr.Cells["GRADENAME"].Value = ugr.Cells["GRADECODE"].Text;
            }

            if (e.Cell.Column.Key.Equals("PROCESS_CODE"))   //工序下拉框选择
            {
                ugr.Cells["PROCESS_DESC"].Value = ugr.Cells["PROCESS_CODE"].Text;
            }

            if (e.Cell.Column.Key.Equals("ISCHECK"))   //是否检验
            {
                if (!Convert.ToBoolean(e.Cell.Value.ToString()))
                {
                    ugr.Cells["ISJUDGE"].Value = false;
                    //ugr.Cells["ISQUOTE"].Value = false;
                }
            }

            if (e.Cell.Column.Key.Equals("ISJUDGE"))
            {
                if (Convert.ToBoolean(ugr.Cells["ISJUDGE"].Value.ToString()))
                {
                    ugr.Cells["ISCHECK"].Value = true;
                }
            }

            if (e.Cell.Column.Key.Equals("STD_CODE_NK"))   //内控标准选择
            {
                string stdCode = ugr.Cells["STD_CODE_NK"].Value.ToString();
                ugr.Cells["STD_NAME_NK"].Value = ugr.Cells["STD_CODE_NK"].Text;
                DataRow[] dr = ((DataTable)ultras[7].DataSource).Select("STD_CODE='" + stdCode + "'");
                if (dr.Length > 0)
                {
                    ugr.Cells["STDSTYLE"].Value = dr[0][2];
                }
            }

            ultraGrid1.ActiveRow.Update();
            ultraGrid1.UpdateData();
        }


        /// <summary>
        /// 从表数据
        /// </summary>
        /// <param name="ugr">UltraGridRow</param>
        /// <returns></returns>
        private StdChemObject GetChildData(UltraGridRow ugr, DataRow rowCic)
        {
            if (CheckAuthority(ugr) == false) return null;

            if (rowCic != null && (rowCic["VALIDFLAG"].ToString() == "2" || rowCic["VALIDFLAG"].ToString() == "3"))
            {
                errMessage = "主记录为提交审核或已审核状态时，无法修改";
                return null;
            }
            string cic = ugr.Cells["CIC"].Value.ToString().Trim();
            string indexSeq = ugr.Cells["INDEX_SEQ"].Value.ToString().Trim();
            string chemName = ugr.Cells["CHEM_NAME"].Value.ToString().Trim();
            if (chemName.Equals(""))
            {
                errMessage = "请选择化学元素描述";
                return null;
            }
            string chemCode = ugr.Cells["CHEM_CODE"].Value.ToString().Trim();

            string wholeBacklog = ugr.Cells["CHEM_TYPE"].Value.ToString().Trim();
            if (wholeBacklog.Equals("单一元素"))
                wholeBacklog = "A";
            else
                wholeBacklog = "B";
            string chemFormula = ugr.Cells["CHEM_FORMULA"].Value.ToString().Trim();
            string isCheck = ugr.Cells["ISCHECK"].Value.ToString().Trim();
            if (Convert.ToBoolean(isCheck))
            {
                isCheck = "1";
            }
            else isCheck = "0";
            string isjudge = ugr.Cells["ISJUDGE"].Value.ToString().Trim();
            if (Convert.ToBoolean(isjudge))
            {
                isjudge = "1";
            }
            else isjudge = "0";
            string isquote = ugr.Cells["ISQUOTE"].Value.ToString().Trim();
            if (Convert.ToBoolean(isquote))
            {
                isquote = "1";
            }
            else isquote = "0";
            string complexType = ugr.Cells["COMPLEX_TYPE"].Value.ToString().Trim();
            if (Convert.ToBoolean(complexType))
            {
                complexType = "1";
            }
            else
            {
                complexType = "0";
            }
            string stdminSign = ugr.Cells["STDMIN_SIGN"].Value.ToString().Trim();
            string stdMin = ugr.Cells["STDMIN"].Value.ToString().Trim();
            string stdmaxSign = ugr.Cells["STDMAX_SIGN"].Value.ToString().Trim();
            string stdMax = ugr.Cells["STDMAX"].Value.ToString().Trim().Trim();
            if (!stdminSign.Equals(""))
            {
                if (stdMin.Equals(""))
                {
                    errMessage = "请输入标准范围下限值";
                    return null;
                }
                if (complexType.Equals("0"))
                {
                    if (!StringUtil.IsNumber(stdMin))
                    {
                        errMessage = "标准范围下限值请输入数字";
                        return null;
                    }
                }
                else
                {
                    if (!QcmBaseCommon.CheckElement(stdMin, this.ob))
                    {
                        errMessage = "标准范围下限值输入公式不合法，请重新输入";
                        return null;
                    }
                }
            }
            else
            {
                if (!stdMin.Equals(""))
                {
                    errMessage = "请选择标准范围下限符号";
                    return null;
                }
            }
            if (stdminSign.Equals("=") && !stdmaxSign.Equals(""))
            {
                errMessage = "标准范围下限符号为'=',不能选择上限符号";
                return null;
            }

            if (isjudge.Equals("1") && stdminSign.Equals("") && stdmaxSign.Equals(""))
            {
                errMessage = "请选择标准范围下限符号或者上限符号";
                return null;
            }
            if (!stdmaxSign.Equals(""))
            {
                if (stdMax.Equals(""))
                {
                    errMessage = "请输入标准范围上限值";
                    return null;
                }
                if (complexType.Equals("0"))
                {
                    if (!StringUtil.IsNumber(stdMax))
                    {
                        errMessage = "标准范围上限值请输入数字";
                        return null;
                    }
                }
                else
                {
                    if (!QcmBaseCommon.CheckElement(stdMin, this.ob))
                    {
                        errMessage = "标准范围上限值输入公式不合法，请重新输入";
                    }
                }
            }
            else
            {
                if (!stdMax.Equals(""))
                {
                    errMessage = "请选择标准范围上限符号";
                    return null;
                }
            }
            if (complexType.Equals("0") && !stdMin.Equals("") && !stdMax.Equals(""))  //&& double.Parse(stdMin) > double.Parse(stdMax)
            {
                int i = QcmBaseInfo.CheckStdData(stdminSign, stdmaxSign, stdMin, stdMax);
                if (i == 0)
                {
                    errMessage = "输入的数据不完整";
                    return null;
                }
                if (i == 1)
                {
                    errMessage = "标准范围下限值与上限值相等，上下限符号请选择<=和>=";
                    return null;
                }
                if (i == 2)
                {
                    errMessage = "标准范围下限值不能大于上限值";
                    return null;
                }
            }
            string stdTarget = ugr.Cells["STDTARGET"].Value.ToString().Trim();
            string modelCode = ugr.Cells["MODEL_CODE"].Value.ToString().Trim();
            string modelDesc = ugr.Cells["MODEL_DESC"].Value.ToString().Trim();
            string stdMemo = ugr.Cells["STDMEMO"].Value.ToString().Trim();
            string ele_code = ugr.Cells["ELE_CODE"].Value.ToString().Trim();
            string ele_name = ugr.Cells["ELE_NAME"].Value.ToString().Trim();
            string ele_min_sign = ugr.Cells["ELE_MIN_SIGN"].Value.ToString().Trim();
            string ele_min = ugr.Cells["ELE_MIN"].Value.ToString().Trim();
            string ele_max_sign = ugr.Cells["ELE_MAX_SIGN"].Value.ToString().Trim();
            string ele_max = ugr.Cells["ELE_MAX"].Value.ToString().Trim();

            string repcode = ugr.Cells["REP_CODE"].Value.ToString().Trim();
            string repname = ugr.Cells["REP_NAME"].Value.ToString().Trim();
            string repminsign = ugr.Cells["REP_MIN_SIGN"].Value.ToString().Trim();
            string repmin = ugr.Cells["REP_MIN"].Value.ToString().Trim();
            string repmaxsign = ugr.Cells["REP_MAX_SIGN"].Value.ToString().Trim();
            string repmax = ugr.Cells["REP_MAX"].Value.ToString().Trim();
            string repval = ugr.Cells["REP_VAL"].Value.ToString().Trim();

            string size_code2 = ugr.Cells["SIZE_CODE2"].Value.ToString().Trim();
            string size_name2 = ugr.Cells["SIZE_NAME2"].Value.ToString().Trim();
            string size_min_sign2 = ugr.Cells["SIZE_MIN_SIGN2"].Value.ToString().Trim();
            string size_min2 = ugr.Cells["SIZE_MIN2"].Value.ToString().Trim();
            string size_max_sign2 = ugr.Cells["SIZE_MAX_SIGN2"].Value.ToString().Trim();
            string size_max2 = ugr.Cells["SIZE_MAX2"].Value.ToString().Trim();
            string size_code = ugr.Cells["SIZE_CODE"].Value.ToString().Trim();
            string size_name = ugr.Cells["SIZE_NAME"].Value.ToString().Trim();
            string size_min_sign = ugr.Cells["SIZE_MIN_SIGN"].Value.ToString().Trim();
            string size_min = ugr.Cells["SIZE_MIN"].Value.ToString().Trim();
            string size_max_sign = ugr.Cells["SIZE_MAX_SIGN"].Value.ToString().Trim();
            string size_max = ugr.Cells["SIZE_MAX"].Value.ToString().Trim();
            string specJG = ugr.Cells["SPEC_JG"].Value.ToString().Trim();
            string specJGDesc = ugr.Cells["SPEC_JG_DESC"].Value.ToString().Trim();
            if (ele_min_sign.Equals("=") && !ele_max_sign.Equals(""))
            {
                errMessage = "限制元素下限符号为'=',不能选择上限符号";
                return null;
            }
            if (size_min_sign2.Equals("=") && !size_max_sign2.Equals(""))
            {
                errMessage = "限制规格（一）下限符号为'=',不能选择上限符号";
                return null;
            }
            if (size_min_sign.Equals("=") && !size_max_sign.Equals(""))
            {
                errMessage = "限制规格（二）下限符号为'=',不能选择上限符号";
                return null;
            }

            if (repminsign.Equals("=") && !repmaxsign.Equals(""))
            {
                errMessage = "替代元素下限符号为'=',不能选择上限符号";
                return null;
            }

            if (!ele_name.Equals(""))
            {
                if (ele_name.Equals(chemName))
                {
                    errMessage = "化学元素描述不能与限制元素描述相同";
                    return null;
                }
                if (ele_min_sign.Equals("") && ele_max_sign.Equals(""))
                {
                    errMessage = "请选择限制元素上限符号或者下限符号";
                    return null;
                }
                if (!ele_min_sign.Equals("") && ele_min.Equals(""))
                {
                    errMessage = "请输入限制元素下限值";
                    return null;
                }
                if (ele_min_sign.Equals("") && !ele_min.Equals(""))
                {
                    errMessage = "请选择限制元素下限符号";
                    return null;
                }
                if (!ele_max_sign.Equals("") && ele_max.Equals(""))
                {
                    errMessage = "请输入限制元素上限值";
                    return null;
                }
                if (ele_max_sign.Equals("") && !ele_max.Equals(""))
                {
                    errMessage = "请选择限制元素上限符号";
                    return null;
                }
                if (!ele_max.Equals("") && !StringUtil.IsNumber(ele_max))
                {
                    errMessage = "限制元素上限值请输入数字";
                    return null;
                }
                if (!ele_min.Equals("") && !StringUtil.IsNumber(ele_min))
                {
                    errMessage = "限制元素下限值请输入数字";
                    return null;
                }
                if (!ele_max_sign.Equals("") && !ele_min_sign.Equals("")) //&& Convert.ToInt32(ele_min) > Convert.ToInt32(ele_max)
                {
                    int i = QcmBaseInfo.CheckStdData(ele_min_sign, ele_max_sign, ele_min, ele_max);
                    if (i == 0)
                    {
                        errMessage = "输入的数据不完整";
                        return null;
                    }
                    if (i == 1)
                    {
                        errMessage = "限制元素下限值与上限值相等，上下限符号请选择<=和>=";
                        return null;
                    }
                    if (i == 2)
                    {
                        errMessage = "限制元素下限值不能大于上限值";
                        return null;
                    }
                }
            }
            else
            {
                if (!ele_max_sign.Equals("") || !ele_min_sign.Equals("") || !ele_min.Equals("") || !ele_max.Equals(""))
                {
                    errMessage = "请选择限制元素描述";
                    return null;
                }
            }
            //-------------------新增的7个字段-----------------------------------------
            if (!repname.Equals(""))
            {
                if (repname.Equals(chemName))
                {
                    errMessage = "化学元素描述不能与替代元素描述相同";
                    return null;
                }
                if (repminsign.Equals("") && repmaxsign.Equals(""))
                {
                    errMessage = "请选择替代元素上限符号或者下限符号";
                    return null;
                }
                if (!repminsign.Equals("") && repmin.Equals(""))
                {
                    errMessage = "请输入替代元素下限值";
                    return null;
                }
                if (repminsign.Equals("") && !repmin.Equals(""))
                {
                    errMessage = "请选择替代元素下限符号";
                    return null;
                }
                if (!repmaxsign.Equals("") && repmax.Equals(""))
                {
                    errMessage = "请输入替代元素上限值";
                    return null;
                }
                if (repmaxsign.Equals("") && !repmax.Equals(""))
                {
                    errMessage = "请选择替代元素上限符号";
                    return null;
                }
                if (!repmax.Equals("") && !StringUtil.IsNumber(repmax))
                {
                    errMessage = "替代元素上限值请输入数字";
                    return null;
                }
                if (!repmin.Equals("") && !StringUtil.IsNumber(repmin))
                {
                    errMessage = "替代元素下限值请输入数字";
                    return null;
                }
                if (!repmaxsign.Equals("") && !repminsign.Equals("")) //&& Convert.ToInt32(repmin) > Convert.ToInt32(repmax)
                {
                    int i = QcmBaseInfo.CheckStdData(repminsign, repmaxsign, repmin, repmax);
                    if (i == 0)
                    {
                        errMessage = "输入的数据不完整";
                        return null;
                    }
                    if (i == 1)
                    {
                        errMessage = "替代元素下限值与上限值相等，上下限符号请选择<=和>=";
                        return null;
                    }
                    if (i == 2)
                    {
                        errMessage = "替代元素下限值不能大于上限值";
                        return null;
                    }

                }
            }
            else
            {
                if (!repmaxsign.Equals("") || !repminsign.Equals("") || !repmin.Equals("") || !repmax.Equals(""))
                {
                    errMessage = "请选择替代元素描述";
                    return null;
                }
            }
            //----------------新增的7个字段处理结束-------------


            if (!specJGDesc.Equals("") && !specJGDesc.Equals("-1"))
            {
                if (!size_name.Equals("") || !size_name2.Equals(""))
                {
                    errMessage = "存在接箍描述，不能选择限制规格（一）或者（二）";
                    return null;
                }
            }
            if (!size_name.Equals("") || !size_name2.Equals(""))
            {
                if (!specJGDesc.Equals("") && !specJGDesc.Equals("-1"))
                {
                    errMessage = "存在限制规格(一)或者限制规格(二)，不能选择接箍描述";
                    return null;
                }

            }
            if (!size_name2.Equals(""))
            {
                if (size_min_sign2.Equals("") && size_max_sign2.Equals(""))
                {
                    errMessage = "请选择限制规格(一)下限符号或者上限符号";
                    return null;
                }
                if (!size_min_sign2.Equals("") && size_min2.Equals(""))
                {
                    errMessage = "请输入限制规格(一)下限值";
                    return null;
                }
                if (size_min_sign2.Equals("") && !size_min2.Equals(""))
                {
                    errMessage = "请选择限制规格(一)下限符号";
                    return null;
                }
                if (!size_max_sign2.Equals("") && size_max2.Equals(""))
                {
                    errMessage = "请输入限制规格(一)下限值";
                    return null;
                }
                if (size_max_sign2.Equals("") && !size_max2.Equals(""))
                {
                    errMessage = "请选择限制规格(一)下限符号";
                    return null;
                }
                if (!size_max2.Equals("") && !StringUtil.IsNumber(size_max2))
                {
                    errMessage = "限制规格(一)上限值请输入数字";
                    return null;
                }
                if (!size_min2.Equals("") && !StringUtil.IsNumber(size_min2))
                {
                    errMessage = "限制规格(一)下限值请输入数字";
                    return null;
                }
                if (!size_max2.Equals("") && !size_min2.Equals("")) //&& Convert.ToDouble(size_min2) > Convert.ToDouble(size_max2)
                {
                    int i = QcmBaseInfo.CheckStdData(size_min_sign2, size_max_sign2, size_min2, size_max2);
                    if (i == 0)
                    {
                        errMessage = "输入的数据不完整";
                        return null;
                    }
                    if (i == 1)
                    {
                        errMessage = "限制规格(一)下限值与上限值相等，上下限符号请选择<=和>=";
                        return null;
                    }
                    if (i == 2)
                    {
                        errMessage = "限制规格(一)下限值不能大于上限值";
                        return null;
                    }
                }

            }
            else
            {
                if (!size_min_sign2.Equals("") || !size_max2.Equals("") || !size_max2.Equals("") || !size_min2.Equals(""))
                {
                    errMessage = "请选择限制规格(一)描述";
                    return null;
                }
            }
            if (!size_name.Equals(""))
            {
                if (size_min_sign.Equals("") && size_max_sign.Equals(""))
                {
                    errMessage = "请选择限制规格(二)下限符号或者上限符号";
                    return null;
                }
                if (!size_min_sign.Equals("") && size_min.Equals(""))
                {
                    errMessage = "请输入限制规格(二)下限值";
                    return null;
                }
                if (size_min_sign.Equals("") && !size_min.Equals(""))
                {
                    errMessage = "请选择限制规格(二)下限符号";
                    return null;
                }
                if (!size_max_sign.Equals("") && size_max.Equals(""))
                {
                    errMessage = "请输入限制规格(二)下限值";
                    return null;
                }
                if (size_max_sign.Equals("") && !size_max.Equals(""))
                {
                    errMessage = "请选择限制规格(二)下限符号";
                    return null;
                }
                if (!size_max.Equals("") && !StringUtil.IsNumber(size_max))
                {
                    errMessage = "限制规格(二)上限值请输入数字";
                    return null;
                }
                if (!size_min.Equals("") && !StringUtil.IsNumber(size_min))
                {
                    errMessage = "限制规格(二)下限值请输入数字";
                    return null;
                }
                if (!size_max.Equals("") && !size_min.Equals("")) //&& Convert.ToDouble(size_min) > Convert.ToDouble(size_max)
                {
                    int i = QcmBaseInfo.CheckStdData(size_min_sign, size_max_sign, size_min, size_max);
                    if (i == 0)
                    {
                        errMessage = "输入的数据不完整";
                        return null;
                    }
                    if (i == 1)
                    {
                        errMessage = "限制规格(二)下限值与上限值相等，上下限符号请选择<=和>=";
                        return null;
                    }
                    if (i == 2)
                    {
                        errMessage = "限制规格(二)下限值不能大于上限值";
                        return null;
                    }
                }

            }
            else
            {
                if (!size_min_sign.Equals("") || !size_max.Equals("") || !size_max.Equals("") || !size_min.Equals(""))
                {
                    errMessage = "请选择限制规格(二)描述";
                    return null;
                }
            }
            if (!size_name.Equals("") && !size_name2.Equals("") && size_name.Equals(size_name2))
            {
                errMessage = "限制规格(二)描述不能与限制规格(一)描述相同";
                return null;
            }
            string createName = UserInfo.GetUserName();
            string updateName = UserInfo.GetUserName();
            string createTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            string validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            //if (validflag.Equals("无效"))
            //{
            //    errMessage = "无效记录不能保存";
            //    return null;
            //}
            StdChemObject com = new StdChemObject();
            com.Cic = cic;
            com.IndexSeq = indexSeq;
            com.ChemCode = chemCode;
            com.ChemName = chemName;
            com.ChemType = wholeBacklog;
            com.ChemFormula = chemFormula;
            com.IsCheck = isCheck;
            com.Isjudge = isjudge;
            com.IsQuote = isquote;
            com.ComplexType = complexType;
            com.StdMinSign = stdminSign;
            if (stdMin.TryParseDecimal())
            {
                if (stdMin.StartsWith(".")) stdMin = "0" + stdMin;
            }
            com.StdMin = stdMin;
            com.StdMaxSign = stdmaxSign;
            if (stdMax.TryParseDecimal())
            {
                if (stdMax.StartsWith(".")) stdMax = "0" + stdMax;
            }
            com.StdMax = stdMax;
            com.StdTarget = stdTarget;
            com.ModelCode = modelCode;
            com.ModelDesc = modelDesc;
            com.StdMemo = stdMemo;
            com.EleCode = ele_code;
            com.EleName = ele_name;
            com.EleMinSign = ele_min_sign;
            if (ele_min.TryParseDecimal())
            {
                if (ele_min.StartsWith(".")) ele_min = "0" + ele_min;
            }
            com.EleMin = ele_min;
            com.EleMaxSign = ele_max_sign;
            if (ele_max.TryParseDecimal())
            {
                if (ele_max.StartsWith(".")) ele_max = "0" + ele_max;
            }
            com.EleMax = ele_max;
            com.SizeCode2 = size_code2;
            com.SizeName2 = size_name2;
            com.SizeMinSign2 = size_min_sign2;
            com.SizeMin2 = size_min2;
            com.SizeMaxSign2 = size_max_sign2;
            com.SizeMax2 = size_max2;
            com.SizeCode = size_code;
            com.SizeName = size_name;
            com.SizeMinSign = size_min_sign;
            if (size_min.TryParseDecimal())
            {
                if (size_min.StartsWith(".")) size_min = "0" + size_min;
            }
            com.SizeMin = size_min;
            com.SizeMaxSign = size_max_sign;
            if (size_max.TryParseDecimal())
            {
                if (size_max.StartsWith(".")) size_max = "0" + size_max;
            }
            com.SizeMax = size_max;
            com.SpecJg = specJG;
            com.SpecJgDesc = specJGDesc;
            com.CreateName = createName;
            com.UpdateName = updateName;
            com.CreateTime = createTime;
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString();
            com.RepMaxSign = repmaxsign;
            com.RepMin = repmin;
            com.RepMinSign = repminsign;
            com.RepMax = repmax;
            com.RepName = repname;
            com.RepCode = repcode;
            com.RepVal = repval;

            return com;
        }

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

        private string GetMscByCic(string cic)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getMscCicByCic",
                new object[] { cic }, ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["MSC"].ToString();
            }
            else
            {
                return "";
            }
        }

        /// <summary>
        /// 通过主键查询成分
        /// </summary>
        /// <param name="cic"></param>
        /// <returns></returns>
        private DataRow GetMscCicByCic(string cic)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreChemStandard.getMscCicByCic",
                new object[] { cic }, ob);
            if (dt.Rows.Count == 0)
            {
                return null;
            }
            else
            {
                return dt.Rows[0];
            }
        }

        private bool CheckAuthority(UltraGridRow row)
        {
            if (CustomInfo == "1")
            {
                string mscOld;
                if (row.GetValue("VALIDFLAG") != "")
                {
                    mscOld = GetMscByCic(row.GetValue("CIC"));
                }
                else
                {
                    mscOld = row.HasParent() ? row.ParentRow.GetValue("MSC") : row.GetValue("MSC");
                }
                DataTable dtMsc = GetMscTabByMsc(mscOld);
                //if (dtMsc.Rows[0]["UNIT_CODE"].ToString() != UserInfo.GetDeptid() && UserInfo.GetUserID() != "admin")
                //{
                //    errMessage = "该条记录对应的冶金规范是[" + dtMsc.Rows[0]["UNIT_DESC"].ToString() + "]科室维护的，您没有权限！";
                //    row.Activate();
                //    return false;
                //}
            }
            return true;
        }

        /// <summary>
        /// 主项数据
        /// </summary>
        /// <param name="ugr">UltraGridRow</param>
        /// <returns></returns>
        private StdCicObject GetBaseData(UltraGridRow ugr, DataRow cicRow)
        {
            StdCicObject com = new StdCicObject();
            com.Cic = ugr.Cells["CIC"].Value.ToString().Trim();
            com.Psc = ugr.Cells["PSC"].Value.ToString().Trim();
            com.Msc = ugr.Cells["MSC"].Value.ToString();
            if (CustomInfo == "1" && com.Msc.Equals(""))
            {
                errMessage = "请选择冶金规范码";
                return null;
            }
            if (CheckAuthority(ugr) == false) return null;
            com.StdsStyle = ugr.Cells["STDSTYLE"].Value.ToString().Trim();
            if (com.StdsStyle.Equals("订货标准"))
                com.StdsStyle = "G";
            else if (com.StdsStyle.Equals("协议标准"))
                com.StdsStyle = "X";
            else if (com.StdsStyle.Equals("Alpha"))
                com.StdsStyle = "K";
            else if (com.StdsStyle.Equals("内控"))
                com.StdsStyle = "N";
            else if (com.StdsStyle.Equals("试验标准"))
                com.StdsStyle = "S";
            else
                com.StdsStyle = "P";
            com.StdCodeNk = ugr.Cells["STD_CODE_NK"].Value.ToString().Trim();
            com.StdNameNk = ugr.Cells["STD_NAME_NK"].Value.ToString().Trim();
            if (CustomInfo != "1" && com.StdNameNk.Equals(""))
            {
                errMessage = "请选择标准名称";
                return null;
            }

            com.ProcessCode = ugr.Cells["PROCESS_CODE"].Value.ToString().Trim();
            com.ProcessDesc = ugr.Cells["PROCESS_DESC"].Value.ToString().Trim();
            com.GradeCode = ugr.Cells["GRADECODE"].Value.ToString().Trim();
            com.GradeName = ugr.Cells["GRADENAME"].Value.ToString().Trim();
            com.StdCode = ugr.Cells["STD_CODE"].Value.ToString().Trim();
            com.StdName = ugr.Cells["STD_CODE"].Text;
            com.CreateName = UserInfo.GetUserName();
            com.CreateTime = ugr.Cells["CREATE_TIME"].Value.ToString().Trim();
            com.UpdateName = UserInfo.GetUserName();
            com.Memo = ugr.Cells["MEMO"].Value.ToString();
            com.Validflag = ugr.Cells["VALIDFLAG"].Value.ToString().Trim();
            com.ModelCode = ugr.Cells["MODEL_CODE"].Value.ToString();
            com.ModelDesc = ugr.Cells["MODEL_DESC"].Value.ToString();
            com.ProducHead = ugr.GetValue("PRODUC_HEAD");
            com.CodeJg = codeJg == "DefaultValue" ? "" : codeJg;
            com.SteelcodeNk = ugr.GetValue("STEELCODE_NK");
            com.SteelnameNk = ugr.GetValue("STEELNAME_NK");
            com.ModelCodeNk = ugr.GetValue("MODEL_CODE_NK");
            com.ModelNameNk = ugr.GetValue("MODEL_DESC_NK");
            com.ProduccodeNk = ugr.GetValue("PRODUCCODE_NK");
            com.ProducnameNk = ugr.GetValue("PRODUCNAME_NK");
            com.SmeltingCnt = ugr.GetValue("SMELTING_CNT");
            com.ProductCnt = ugr.GetValue("PRODUCT_CNT");
            com.MinD = ugr.GetValue("MIN_D");
            com.MaxD = ugr.GetValue("MAX_D");
            com.MinH = ugr.GetValue("MIN_H");
            com.MaxH = ugr.GetValue("MAX_H");
            com.MinDSign = ugr.GetValue("MIN_D_SIGN");
            com.MaxDSign = ugr.GetValue("MAX_D_SIGN");
            com.MinHSign = ugr.GetValue("MIN_H_SIGN");
            com.MaxHSign = ugr.GetValue("MAX_H_SIGN");
            com.Rate = ugr.GetValue("RATE");

            //if (CustomInfo == "2" && ugr.GetValue("PRODUCCODE_NK") == "")
            //{
            //    errMessage = "请选择品名！";
            //    return null;
            //}
            if (CustomInfo == "1" && com.Msc.EndsWith("000"))
            {
                if (com.SmeltingCnt == "")
                {
                    errMessage = "请输入熔炼成分套数！";
                    ugr.SetCellActive("SMELTING_CNT");
                    return null;
                }
                if (com.ProductCnt == "")
                {
                    errMessage = "请输入成品成分套数！";
                    ugr.SetCellActive("PRODUCT_CNT");
                    return null;
                }
                if (com.Rate == "")
                {
                    errMessage = "请选择成品取样频率！";
                    ugr.SetCellActive("RATE");
                    return null;
                }
            }
            if (CustomInfo == "2")
            {
                if (com.GradeCode == "")
                {
                    errMessage = "请选择钢种！";
                    ugr.SetCellActive("GRADENAME");
                    return null;
                }
                else if (com.GradeCode.Split(';').Length >= 2)
                {
                    errMessage = "成分内控只能维护一个适用钢种！";
                    ugr.SetCellActive("GRADENAME");
                    return null;
                }

                if (com.MinDSign != "" && com.MinD == "")
                {
                    errMessage = "请输入外径下限值！";
                    ugr.SetCellActive("MIN_D");
                    return null;
                }
                else if (com.MinDSign == "" && com.MinD != "")
                {
                    errMessage = "请选择外径下限符号！";
                    ugr.SetCellActive("MIN_D_SIGN");
                    return null;
                }
                else if (com.MaxDSign != "" && com.MaxD == "")
                {
                    errMessage = "请输入外径上限值！";
                    ugr.SetCellActive("MAX_D");
                    return null;
                }
                else if (com.MaxDSign == "" && com.MaxD != "")
                {
                    errMessage = "请选择外径上限符号！";
                    ugr.SetCellActive("MAX_D_SIGN");
                    return null;
                }
                else if (com.MinHSign != "" && com.MinH == "")
                {
                    errMessage = "请输入壁厚下限值！";
                    ugr.SetCellActive("MIN_H");
                    return null;
                }
                else if (com.MinHSign == "" && com.MinH != "")
                {
                    errMessage = "请选择壁厚下限符号！";
                    ugr.SetCellActive("MIN_H_SIGN");
                    return null;
                }
                else if (com.MaxHSign != "" && com.MaxH == "")
                {
                    errMessage = "请输入壁厚上限值！";
                    ugr.SetCellActive("MAX_H");
                    return null;
                }
                else if (com.MaxHSign == "" && com.MaxH != "")
                {
                    errMessage = "请选择壁厚上限符号！";
                    ugr.SetCellActive("MAX_H_SIGN");
                    return null;
                }
                else if (com.MinDSign == "=" && com.MaxDSign != "")
                {
                    errMessage = "外径下限符号为等号时，不能存在外径上限符号和外径上限值！";
                    ugr.SetCellActive("MAX_D_SIGN");
                    return null;
                }
                else if (com.MinHSign == "=" && com.MaxHSign != "")
                {
                    errMessage = "壁厚下限符号为等号时，不能存在壁厚上限符号和壁厚上限值！";
                    ugr.SetCellActive("MAX_H_SIGN");
                    return null;
                }
                else if (com.MinD != "" && com.MaxD != ""
                    && decimal.Parse(com.MinD) >= decimal.Parse(com.MaxD))
                {
                    errMessage = "外径下限值不能大于等于外径上限值！";
                    ugr.SetCellActive("MIN_D");
                    return null;
                }
                else if (com.MinH != "" && com.MaxH != ""
                    && decimal.Parse(com.MinH) >= decimal.Parse(com.MaxH))
                {
                    errMessage = "壁厚下限值不能大于等于壁厚上限值！";
                    ugr.SetCellActive("MIN_H");
                    return null;
                }
            }
            //if (com.Validflag.Equals("无效"))
            //{
            //    errMessage = "无效记录不能保存";
            //    return null;
            //}
            //界面上简单的验证了下 当这个界面打开很久以后 可能有些记录的状态发生了变化 会不准确 不过不影响 
            //因为在Update SQL语句里面加了限制条件（这两个状态的都无法修改！）。
            if (cicRow != null && (cicRow["VALIDFLAG"].ToString() == "2" || cicRow["VALIDFLAG"].ToString() == "3"))
            {
                errMessage = "提交审核或已审核的记录不能修改";
                return null;
            }
            return com;
        }

        private bool CheckDataParent(UltraGridRow ugr, DataRow rowCic, bool flag)
        {
            if (!flag)
            {
                if (CustomInfo == "2")
                {
                    if (rowCic["GRADECODE"].ToString() == "")
                    {
                        MessageUtil.ShowWarning("请选择钢种并保存后，再恢复记录！");
                        return false;
                    }
                    else if (rowCic["GRADECODE"].ToString().Split(';').Length >= 2)
                    {
                        MessageUtil.ShowWarning("成分内控只能维护一个适用钢种，请保留一个适用钢种并保存后，再恢复记录！");
                        return false;
                    }

                }
            }
            return true;
        }

        FrmChemStandard _frmChemStandard = null;

        /// <summary>
        /// 扣型选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_ClickCellButton(object sender, CellEventArgs e)
        {

            if (e.Cell.Column.Key.Equals("MODEL_DESC") && Convert.ToBoolean(ultraGrid1.DisplayLayout.ActiveRow.Cells["CHC"].Value))
            {
                UltraGridRow row = this.ultraGrid1.DisplayLayout.ActiveRow;
                FrmModel frms = new FrmModel();
                frms.Desc = row.Cells["MODEL_DESC"].Value.ToString();
                frms.FrmOb = this.ob;
                frms.ShowDialog();
                row.Cells["MODEL_CODE"].Value = frms.Code;
                row.Cells["MODEL_DESC"].Value = frms.Desc;
            }
            if (e.Cell.Column.Key.ToUpper().Equals("COUNT") && e.Cell.Row.Cells["CHC"].Value.ToString() == "True")
            {
                UltraGridRow ugr = ultraGrid1.ActiveRow;
                List<string> list = new List<string>();
                FrmChemPopup fcp = new FrmChemPopup();
                if (ugr.ChildBands[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ugr.ChildBands[0].Rows.Count; i++)
                    {
                        list.Add(ugr.ChildBands[0].Rows[i].Cells["CHEM_CODE"].Value.ToString());
                    }
                }
                fcp.Ob = this.ob;
                fcp.ChenList = list;
                fcp.ShowDialog();
            }
            if (e.Cell.Column.Key.Equals("CHKNK"))
            {
                UltraGridRow ugr = ultraGrid1.ActiveRow;
                _frmChemStandard = new FrmChemStandard();
                _frmChemStandard.PopupLoad("3", ob);
                _frmChemStandard.UltraPanel1.Visible = false;
                _frmChemStandard.ultraToolbarsManager1.Visible = true;
                _frmChemStandard.Msc = msc;
                _frmChemStandard.CodeJg = "";
                _frmChemStandard.DoQuery1();
                if (_frmChemStandard.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {

                    DataRow CurRow, NewRow;
                    for (int i = 0; i < _frmChemStandard.dataTable1.Rows.Count; i++)
                    {
                        CurRow = _frmChemStandard.dataTable1.Rows[i];
                        NewRow = dataTable1.NewRow();
                        if (!_frmChemStandard.Ids.Contains(CurRow["CIC"].ToString2()))
                        {
                            continue;
                        }

                        for (int j = 0; j < _frmChemStandard.dataTable1.Columns.Count; j++)
                        {
                            try
                            {
                                if (dataTable1.Columns.Contains(_frmChemStandard.dataTable1.Columns[j].ColumnName))
                                {

                                    if (_frmChemStandard.dataTable1.Columns[j].ColumnName == "CIC")
                                    {
                                        NewRow[_frmChemStandard.dataTable1.Columns[j].ColumnName] = ultraGrid1.ActiveRow.GetValue("CIC");
                                    }
                                    else
                                    {
                                        NewRow[_frmChemStandard.dataTable1.Columns[j].ColumnName] = CurRow[j];
                                    }
                                }
                            }
                            catch { }
                        }

                        dataTable1.Rows.Add(NewRow);
                    }
                    ultraGrid1.UpdateData();
                    ultraGrid1.ActiveRow.ExpandAll();
                } 
            }
        }

        /// <summary>
        /// 编辑区 产品规范描述
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ChcPsc_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckMSC.Checked)
                ultraTextMSC.Enabled = true;
            else
                ultraTextMSC.Enabled = false;
        }

        private void ultraCheckStd_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckStd.Checked)
                ultraTextStd.Enabled = true;
            else
                ultraTextStd.Enabled = false;
        }

        private void ultraGrid1_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;
            e.RestoreOriginalValue = true;
            e.StayInEditMode = true;
            MessageBox.Show("数据不合法，请重新输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if (isPasting)
            {
                e.Row.SetValue("CHC", "True");
            }
        }

        /// <summary>
        /// 2015-07-15 PDY
        /// </summary>
        private void InnerChange()
        {
            ultraGrid1.DisplayLayout.Bands[1].Columns["UnboundColumn2"].Header.Caption = "内控标准";
            ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_CODE"].CellActivation = Activation.ActivateOnly;
            ultraGrid1.DisplayLayout.Bands[0].Columns["STD_CODE_NK"].CellActivation = Activation.ActivateOnly;
            ultraGrid1.DisplayLayout.Bands[0].Columns["MODEL_DESC"].Hidden = true;
        }

        private void ultraTextEditor1_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            if (ultraGrid1.ActiveCell.Column.Key == "PROCESS_DESC")
            {
                string processCodes = ultraGrid1.ActiveRow.GetValue("PROCESS_CODE");
                ChoiceProcessPopup choiceProcessPopup = new ChoiceProcessPopup(processCodes, this.ob);
                if (choiceProcessPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComStandard.getProcessByStdCode",
                        new object[] { this.stdCode }, ob);
                    string stdProcessCodes = dt.Rows[0]["PROCESS_CODE"].ToString();
                    string[] processCodesAry = choiceProcessPopup.ProcessCodes.Split(',');
                    for (int i = 0; i < processCodesAry.Length; i++)
                    {
                        if (!stdProcessCodes.Contains(processCodesAry[i].Trim()))
                        {
                            DataTable dtBaseProcess = ServerHelper.GetData("com.steering.pss.qcm.ComStandard.getProcessDescByCode",
                                new object[] { processCodesAry[i].Trim() }, ob);
                            string processDesc = dtBaseProcess.Rows[0]["PROCESS_DESC"].ToString();
                            MessageUtil.ShowWarning("该标准下不包含工序" + processDesc + ", 不能选择!");
                            return;
                        }
                    }
                    ultraGrid1.ActiveRow.SetValue("PROCESS_CODE", choiceProcessPopup.ProcessCodes);
                    ultraGrid1.ActiveRow.SetValue("PROCESS_DESC", choiceProcessPopup.ProcessDescs);
                }
            }
            else if (ultraGrid1.ActiveCell.Column.Key == "STEELNAME_NK")
            {
                FrmRepSteel frmSteel = new FrmRepSteel();
                frmSteel.Text = "钢级选择";
                frmSteel.Ob1 = this.ob;
                frmSteel.Code = ultraGrid1.ActiveRow.GetValue("STEELCODE_NK");
                if (frmSteel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid1.ActiveRow.SetValue("STEELCODE_NK", frmSteel.Code);
                    ultraGrid1.ActiveRow.SetValue("STEELNAME_NK", frmSteel.Desc);
                }
            }
            else if (ultraGrid1.ActiveCell.Column.Key == "MODEL_DESC_NK")
            {
                FrmModel frmModel = new FrmModel();
                frmModel.FrmOb = this.ob;
                frmModel.Code = ultraGrid1.ActiveRow.GetValue("MODEL_CODE_NK");
                frmModel.Desc = ultraGrid1.ActiveCell.Value.ToString();
                if (frmModel.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid1.ActiveRow.SetValue("MODEL_CODE_NK", frmModel.Code);
                    ultraGrid1.ActiveRow.SetValue("MODEL_DESC_NK", frmModel.Desc);
                }
            }
            else if (ultraGrid1.ActiveCell.Column.Key == "PRODUCNAME_NK")
            {
                PopupProductName popupProductName = new PopupProductName(
                    ultraGrid1.ActiveRow.GetValue("PRODUCCODE_NK"), ob);
                if (popupProductName.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid1.ActiveRow.SetValue("PRODUCCODE_NK", popupProductName.ProductCodes);
                    ultraGrid1.ActiveRow.SetValue("PRODUCNAME_NK", popupProductName.ProductNames);
                }
            }
            else if (ultraGrid1.ActiveCell.Column.Key == "GRADENAME")
            {
                string gradeCodes = ultraGrid1.ActiveRow.GetValue("GRADENAME");
                FrmGradeChoice frmGradeChoice = new FrmGradeChoice(gradeCodes, ob);
                if (frmGradeChoice.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid1.ActiveRow.SetValue("GRADECODE", frmGradeChoice.GradeCodes);
                    ultraGrid1.ActiveRow.SetValue("GRADENAME", frmGradeChoice.GradeNames);
                }
            }
        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows)
            {
                ugr.Cells["CHC"].Value = true;
                Activation activation = Activation.ActivateOnly;
                if (Convert.ToBoolean(ugr.Cells["CHC"].Value))
                {
                    activation = Activation.AllowEdit;
                    //isSelect += 1;
                }
                //else
                //isSelect -= 1;
                CellsCollection cells = ugr.Cells;
                for (int i = 0; i < cells.Count; i++)
                {
                    if (!cells[i].Column.Key.Equals("CHC"))
                    {
                        ugr.Cells[i].Activation = activation;
                    }
                }
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "查询":
                    DoQuery1();
                    break;
                case "确认选择":
                    Choice();
                    break;
            }
        }

        private DataRow[] rows;

        public DataRow[] Rows
        {
            get { return rows; }
            set { rows = value; }
        }

        List<string> ids;
        public List<string> Ids
        {
            get { return ids; }
            set { ids = value; }
        }

        private void Choice()
        {
            ultraGrid1.UpdateData();
            int count = ultraGrid1.Rows.Where(a => Convert.ToBoolean(a.GetValue("CHC"))).Count();
            if (count > 1)
            {
                MessageUtil.ShowTips("请选择一条数据！");
                return;
            }
            foreach (UltraGridRow ugr in ultraGrid1.Rows.Where(a => Convert.ToBoolean(a.GetValue("CHC"))))
            {
                //从表操作
                if (ugr.HasChild())
                {
                    Ids = ugr.ChildBands[0].Rows.Select(p => p.GetValue("CIC")).ToList();
                    Rows = dataTable1.Select("CIC IN ('" + string.Join("','", Ids) + "')");
                }
            }
            this.DialogResult = System.Windows.Forms.DialogResult.OK;
        }
    }
}