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

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
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.Drawing;
using System.Linq;
using System.Windows.Forms;

namespace Core.StlMes.Client.Qcm
{
    /// <summary>
    /// 成分内控标准管理
    /// </summary>
    public partial class frmInnerMSCRGRD : FrmBase
    {
        private string errMesage = "";
        //成分基础表数据
        private DataTable dtChem = null;
        //扣型基础表数据
        //private DataTable dtModel = null;
        //接箍码基础表数据
        private DataTable dtSCJG = null;
        //钢种管理基础表数据
        private DataTable dtGrade = null;
        //标准基础表数据
        private DataTable dtBaseStd = null;
        //工序基础表数据
        private DataTable dtProcess = null;
        //成分索引号数字部分
        private int _cic = 1;
        //成分索引号与序号
        private Dictionary<string, int> _diction = new Dictionary<string, int>();
        public frmInnerMSCRGRD()
        {
            InitializeComponent();
            this.StartPosition = FormStartPosition.Manual;
            this.Location = new Point(210, 220);
        }
        private OpeBase _ob;

        public OpeBase SetOb
        {
            get { return _ob; }
            set { _ob = value; }
        }

        private string msc;

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

        private string msc_pline;

        public string Msc_pline
        {
            get { return msc_pline; }
            set { msc_pline = value; }
        }


        private string namerd;

        public string NameOrd
        {
            get { return namerd; }
            set { namerd = value; }
        }


        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {


            string valid = "1";
            if (this.chkValid.Checked)
            {
                valid = "0";
            }
            ArrayList list = QueryCondition();
            list.Add(valid);

            //主表查询
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreInnerChemcs.getCoreInnerChemcs", new Object[] { list }, this._ob);
            dataTable2.Clear();
            GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
            //从表查询
            list.Clear();
            list.Add(valid);
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.qcm.CoreInnerChemcs.getComMSCStdChem", new Object[] { list }, this._ob);
            dt1 = FilterTable(dt, dt1);
            GridHelper.CopyDataToDatatable(ref dt1, ref this.dataTable2, true);
            //不同颜色区分是否有效数据
            Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
            Infragistics.Win.UltraWinGrid.UltraGridRow row1 = null;
            for (int i = 0; i < ultraGridMSCRGRD.Rows.Count; i++)
            {
                row = ultraGridMSCRGRD.Rows[i];
                if (!row.Cells["VALIDFLAGNAME"].Value.ToString().Equals("有效"))
                {
                    row.Appearance.ForeColor = Color.Red;

                }
                else
                {
                    row.Appearance.ForeColor = Color.Black;
                }
                for (int j = 0; j < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows.Count; j++)
                {
                    row1 = ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j];
                    if (!row1.Cells["VALIDFLAGNAME"].Value.ToString().Equals("有效"))
                        row1.Appearance.ForeColor = Color.Red;
                }
            }
            //初始化序号与索引号
            _diction = new Dictionary<string, int>();
            _cic = 1;
            SetUltraGridNoEdit();
        }
        /// <summary>
        /// 过滤子表
        /// </summary>
        /// <param name="dt1"></param>
        /// <param name="dt2"></param>
        /// <returns></returns>
        private DataTable FilterTable(DataTable dt1, DataTable dt2)
        {

            if (dt1 != null && dt1.Rows.Count > 0 && dt2 != null)
            {
                for (int i = 0; i < dt2.Rows.Count; i++)
                {
                    string cic = dt2.Rows[i]["CIC"].ToString();
                    DataRow[] dr = dt1.Select("CIC='" + cic + "'");
                    if (dr == null || dr.Length == 0)
                        dt2.Rows[i].Delete();

                }
                return dt2;
            }
            return null;
        }
        /// <summary>
        /// 查询条件
        /// </summary>
        /// <returns></returns>
        private ArrayList QueryCondition()
        {
            ArrayList list = new ArrayList();
            string standName = "";
            if (this.ultraCheckStand.Checked)
                standName = this.NStandName.Text.Trim();
            string processName = "";
            if (this.ultraCheckProcess.Checked)
                processName = this.ProcessName.Text.Trim();
            string gradeName = "";
            if (this.ultraCheckGrade.Checked)
                gradeName = this.GradeName.Text.Trim();
            list.Add(standName);
            list.Add(processName);
            list.Add(gradeName);
            return list;
        }

        /// <summary>
        /// 从表字段
        /// </summary>
        /// <param name="i">主表行号</param>
        /// <param name="j">从表行号</param>
        /// <returns></returns>
        private ArrayList GetChildData(int i, int j)
        {
            ArrayList listChild = new ArrayList();
            UltraGridRow rows = ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j];
            string cic = rows.Cells["CIC"].Text.Trim().ToString();
            string indexSeq = rows.Cells["INDEX_SEQ"].Text.Trim().ToString();
            string chem_code = rows.Cells["CHEM_CODE"].Text.Trim().ToString();
            if (chem_code.Length == 0)
            {
                errMesage = "请选择成分描述";
                return null;
            }
            string chem_name = rows.Cells["CHEM_NAME"].Text.Trim().ToString();
            string whole_backlog = rows.Cells["WHOLE_BACKLOG"].Text.Trim().ToString();
            if (whole_backlog.Equals("单一元素"))
                whole_backlog = "A";
            else
                whole_backlog = "B";
            string chem_formula = rows.Cells["CHEM_FORMULA"].Text.Trim().ToString();
            string ischeck = rows.Cells["ISCHECK"].Text.Trim().ToString();
            if (Convert.ToBoolean(ischeck))
                ischeck = "1";
            else
                ischeck = "0";
            string stdmin_sign = rows.Cells["STDMIN_SIGN"].Text.Trim().ToString();
            string stdmin = rows.Cells["STDMIN"].Text.Trim().ToString();
            if (!stdmin_sign.Equals(""))
            {
                if (stdmin.Equals(""))
                {
                    errMesage = "存在下限符号，下限值不能空";
                    return null;
                }
                if (!StringUtil.IsNumber(stdmin))
                {
                    errMesage = "下限值必须是数字";
                    return null;
                }

            }
            if (stdmin_sign.Equals("") && !stdmin.Equals(""))
            {
                errMesage = "存在下限值，必须有下限符号";
                return null;
            }
            string stdmax_sign = rows.Cells["STDMAX_SIGN"].Text.Trim().ToString();
            string stdmax = rows.Cells["STDMAX"].Text.Trim().ToString();
            if (!stdmax_sign.Equals(""))
            {
                if (stdmax.Equals(""))
                {
                    errMesage = "存在上限符号，下限值不能空";
                    return null;
                }
                if (!StringUtil.IsNumber(stdmax))
                {
                    errMesage = "上限值必须是数字";
                    return null;
                }

            }
            if (stdmax_sign.Equals("") && !stdmax.Equals(""))
            {
                errMesage = "存在上限值，必须有上限符号";
                return null;
            }
            if (!stdmin.Equals("") && !stdmax.Equals("") && double.Parse(stdmax) < double.Parse(stdmin))
            {
                errMesage = "下限值不能大于上限值";
                return null;
            }
            string stdtarget = rows.Cells["STDTARGET"].Text.Trim().ToString();
            string model_code = rows.Cells["MODEL_CODE"].Text.Trim().ToString();
            string model_desc = rows.Cells["MODEL_DESC"].Text.Trim().ToString();
            string stdmemo = rows.Cells["STDMEMO"].Text.Trim().ToString();
            string spec_jg = rows.Cells["SPEC_JG"].Text.Trim().ToString();
            string spec_jg_desc = rows.Cells["SPEC_JG_DESC"].Text.Trim().ToString();
            string createName = UserInfo.GetUserName();
            listChild.Add(cic);
            listChild.Add(Int32.Parse(indexSeq));
            listChild.Add(chem_code);
            listChild.Add(chem_name);
            listChild.Add(whole_backlog);
            listChild.Add(chem_formula);
            listChild.Add(ischeck);
            listChild.Add(stdmin_sign);
            listChild.Add(stdmin);
            listChild.Add(stdmax_sign);
            listChild.Add(stdmax);
            listChild.Add(stdtarget);
            listChild.Add(model_code);
            listChild.Add(model_desc);
            listChild.Add(stdmemo);
            listChild.Add(spec_jg);
            listChild.Add(spec_jg_desc);
            listChild.Add(createName);
            return listChild;
        }


        /// <summary>
        /// 主表字段
        /// </summary>
        /// <param name="i">主表行号</param>
        /// <returns></returns>
        private ArrayList GetBaseData(int i)
        {
            ArrayList listBase = new ArrayList();
            string cic = ultraGridMSCRGRD.Rows[i].Cells["CIC"].Text.Trim().ToString();
            if (cic.Equals(""))
            {
                errMesage = "请选择记录";
                return null;
            }
            string msc = "MSC";
            string stdstyle = ultraGridMSCRGRD.Rows[i].Cells["STDSTYLE"].Text.Trim().ToString();
            if (stdstyle.Length == 0)
            {
                errMesage = "标准类型不能为空";
                return null;
            }
            if (stdstyle.Equals("内控"))
                stdstyle = "N";
            else
                return null;
            string stdcodenk = ultraGridMSCRGRD.Rows[i].Cells["STD_CODE_NK"].Text.Trim().ToString();
            string std_name_nk = ultraGridMSCRGRD.Rows[i].Cells["STD_NAME_NK"].Text.Trim().ToString();
            string whole_backlog_2 = ultraGridMSCRGRD.Rows[i].Cells["WHOLE_BACKLOG_2"].Text.Trim().ToString();
            string process_desc = ultraGridMSCRGRD.Rows[i].Cells["PROCESS_DESC"].Text.Trim().ToString();
            string gradecode = ultraGridMSCRGRD.Rows[i].Cells["GRADECODE"].Text.Trim().ToString();
            string gradename = ultraGridMSCRGRD.Rows[i].Cells["GRADENAME"].Text.Trim().ToString();
            string std_code = ultraGridMSCRGRD.Rows[i].Cells["STD_CODE"].Text.Trim().ToString();
            string std_name = ultraGridMSCRGRD.Rows[i].Cells["STD_NAME"].Text.Trim().ToString();
            string createName = UserInfo.GetUserName();
            string memo = ultraGridMSCRGRD.Rows[i].Cells["MEMO"].Text.Trim().ToString();
            listBase.Add(cic);
            listBase.Add(msc);
            listBase.Add(stdstyle);
            listBase.Add(stdcodenk);
            listBase.Add(std_name_nk);
            listBase.Add(whole_backlog_2);
            listBase.Add(process_desc);
            listBase.Add(gradecode);
            listBase.Add(gradename);
            listBase.Add(std_code);
            listBase.Add(std_name);
            listBase.Add(createName);
            listBase.Add(memo);
            return listBase;
        }

        private void frmInnerChemcs_Load(object sender, EventArgs e)
        {
            InitAllDownList();
        }


        /// <summary>
        /// 初始化下限符号
        /// </summary>
        private void InitStdminSign()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("STDMIN_SIGN");
            DataRow dr1 = dt.NewRow();
            dr1["STDMIN_SIGN"] = ">";
            DataRow dr2 = dt.NewRow();
            dr2["STDMIN_SIGN"] = ">=";
            DataRow dr3 = dt.NewRow();
            dr3["STDMIN_SIGN"] = "=";
            DataRow dr4 = dt.NewRow();
            dr4["STDMIN_SIGN"] = "";
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            dt.Rows.Add(dr4);
            ultraStdmin.DataSource = dt;
            ultraStdmin.DisplayMember = "STDMIN_SIGN";

        }
        /// <summary>
        /// 初始化上限符号
        /// </summary>
        private void InitStdmaxSign()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("STDMAX_SIGN");
            DataRow dr1 = dt.NewRow();
            dr1["STDMAX_SIGN"] = "<";
            DataRow dr2 = dt.NewRow();
            dr2["STDMAX_SIGN"] = "<=";
            DataRow dr3 = dt.NewRow();
            dr3["STDMAX_SIGN"] = "";
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            ultraStdmax.DataSource = dt;
            ultraStdmax.DisplayMember = "STDMAX_SIGN";

        }

        /// <summary>
        /// 初始化所有下拉框
        /// </summary>
        private void InitAllDownList()
        {
            try
            {


                //下限
                InitStdminSign();
                //上限
                InitStdmaxSign();
                //成分代码
                InitDropList(ref dtChem, ultraChem, "com.steering.pss.qcm.ComBaseQuery.getCombaseChemA", "CHEM_NAME");
                //结箍码
                InitDropList(ref dtSCJG, ultraSCJG, "com.steering.pss.qcm.ComBaseQuery.getComMSCJG", "SPEC_JG_DESC");
                //钢种代码
                InitDropList(ref dtGrade, ultraGride, "com.steering.pss.qcm.ComBaseQuery.geComBaseGrade", "GRADENAME");
                //标准
                InitDropList(ref dtBaseStd, ultraBaseStd, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdN", "STD_NAME");
                //工序
                InitDropList(ref dtProcess, ultraProcess, "com.steering.pss.qcm.ComBaseQuery.geComBaseProcess", "PROCESS_DESC");
                //查询条件初始不可用
                this.NStandName.Enabled = false;
                this.GradeName.Enabled = false;
                this.ProcessName.Enabled = false;

            }
            catch (Exception)
            {


            }
        }

        /// <summary>
        /// 初始下拉框
        /// </summary>
        /// <param name="dt">数据表</param>
        /// <param name="uce">下拉框</param>
        /// <param name="methodId">方法名</param>
        /// <param name="desc">描述</param>
        /// <param name="code">代码</param>
        private void InitDropList(ref DataTable dt, UltraComboEditor uce, string methodId, string desc)
        {
            dt = ServerHelper.GetData(methodId, null, this._ob);
            DataRow dr = dt.NewRow();
            dt.Rows.Add(dr);
            if (dt != null && dt.Rows.Count > 0)
            {
                uce.DataSource = dt;
                uce.Text = desc;
                uce.DisplayMember = desc;

            }
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            try
            {
                ultraGridMSCRGRD.UpdateData();
                if (e.Cell.Column.Key.Equals("CHEM_NAME"))         /// 成分下拉框操作
                {
                    string chemCode = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["CHEM_NAME"].Text.ToString();
                    DataRow[] dr = dtChem.Select("CHEM_NAME = '" + chemCode + "'");

                    if (dr != null)
                    {
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["CHEM_CODE"].Value = dr[0]["CHEM_CODE"].ToString();
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["WHOLE_BACKLOG"].Value = dr[0]["CHEM_TYPE"].ToString();
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["CHEM_FORMULA"].Value = dr[0]["CHEM_FORMULA"].ToString();
                    }
                }
                if (e.Cell.Column.Key.Equals("GRADENAME"))       //钢种下拉框操作
                {

                    string gradeCode = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["GRADENAME"].Text.ToString();
                    DataRow[] dr = dtGrade.Select("GRADENAME = '" + gradeCode + "'");

                    if (dr != null)
                    {

                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["GRADECODE"].Value = dr[0]["GRADECODE"].ToString();
                    }

                }
                if (e.Cell.Column.Key.Equals("SPEC_JG_DESC"))     //接箍下拉框操作
                {

                    string specjg = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["SPEC_JG_DESC"].Text.ToString();
                    DataRow[] dr = dtSCJG.Select("SPEC_JG_DESC = '" + specjg + "'");

                    if (dr != null)
                    {

                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["SPEC_JG"].Value = dr[0]["SPEC_JG"].ToString();
                    }
                }
                if (e.Cell.Column.Key.Equals("PROCESS_DESC"))   //工序下拉框选择
                {

                    string processCode = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["PROCESS_DESC"].Text.ToString();
                    DataRow[] dr = dtProcess.Select("PROCESS_DESC = '" + processCode + "'");

                    if (dr != null)
                    {
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["WHOLE_BACKLOG_2"].Value = dr[0]["PROCESS_CODE"].ToString();
                    }
                }
                if (e.Cell.Column.Key.Equals("STD_NAME_NK"))   //标准下拉框选择
                {
                    string stdCode = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["STD_NAME_NK"].Text.ToString();
                    DataRow[] dr = dtBaseStd.Select("STD_NAME = '" + stdCode + "'");

                    if (dr != null)
                    {
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["STD_CODE_NK"].Value = dr[0]["STD_CODE"].ToString();
                        this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["STDSTYLE"].Value = dr[0]["STDSTYLE"].ToString();
                    }
                }
                if (e.Cell.Column.Key.Equals("CHC"))
                {
                    for (int i = 0; i < ultraGridMSCRGRD.Rows.Count; i++)
                    {

                        if (Convert.ToBoolean(ultraGridMSCRGRD.Rows[i].Cells["CHC"].Value))
                        {

                            for (int j = 0; j < ultraGridMSCRGRD.Rows[i].Cells.Count - 1; j++)
                            {

                                ultraGridMSCRGRD.Rows[i].Cells[j].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                            }

                        }
                        else
                        {
                            for (int j = 0; j < ultraGridMSCRGRD.Rows[i].Cells.Count - 1; j++)
                            {

                                ultraGridMSCRGRD.Rows[i].Cells[j].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                            }
                        }
                        if (ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows.Count > 0)
                        {
                            for (int j = 0; j < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows.Count; j++)
                            {
                                if (Convert.ToBoolean(ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells["CHC"].Value))
                                {

                                    for (int k = 0; k < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells.Count - 3; k++)
                                    {
                                        ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells[k].Activation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
                                    }
                                }
                                else
                                {
                                    for (int k = 0; k < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells.Count - 3; k++)
                                    {
                                        ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells[k].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                                    }
                                }
                            }
                        }

                    }


                }
            }
            catch (Exception)
            {


            }

        }
        /// <summary>
        /// 让ultragrid不可编辑
        /// </summary>
        private void SetUltraGridNoEdit()
        {
            for (int i = 0; i < ultraGridMSCRGRD.Rows.Count; i++)
            {



                for (int j = 0; j < ultraGridMSCRGRD.Rows[i].Cells.Count - 1; j++)
                {

                    ultraGridMSCRGRD.Rows[i].Cells[j].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                }

                if (ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows.Count > 0)
                {
                    for (int j = 0; j < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows.Count; j++)
                    {

                        for (int k = 0; k < ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells.Count - 3; k++)
                        {
                            ultraGridMSCRGRD.Rows[i].ChildBands[0].Rows[j].Cells[k].Activation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                        }

                    }
                }

            }
        }
        /// <summary>
        /// 标准名称
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraCheckStand_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckStand.Checked)
                this.NStandName.Enabled = true;
            else
                this.NStandName.Enabled = false;

        }
        /// <summary>
        /// 适用工序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraCheckProcess_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckProcess.Checked)
                this.ProcessName.Enabled = true;
            else
                this.ProcessName.Enabled = false;
        }
        /// <summary>
        /// 钢种
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraCheckGrade_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckGrade.Checked)
                this.GradeName.Enabled = true;
            else
                this.GradeName.Enabled = false;
        }

        /// <summary>
        ///   ultraGrid插入一行事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {
            UltraGridRow ugr = this.ultraGridMSCRGRD.DisplayLayout.ActiveRow;
            if (ugr == null)
                return;
            if (!ugr.HasParent()) //主表自动填充主键（成分索引号）
            {
                string cic = "";
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreInnerChemcs.selectMaxComMSCStdChem", null, this._ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    cic = dt.Rows[0][0].ToString();
                    if (!cic.Equals(""))
                    {
                        int cicN = int.Parse(cic.Substring(4, 6));
                        if (cicN > _cic)
                        {
                            cic = "CICN" + string.Format("{0:000000}", cicN + 1);
                            _cic = cicN + 1;
                        }
                        else
                        {
                            cic = "CICN" + string.Format("{0:000000}", _cic + 1);
                            _cic = _cic + 1;
                        }


                    }

                }
                else
                {
                    cic = "CICN" + string.Format("{0:000000}", _cic);
                    _cic = _cic + 1;
                }


                ugr.Cells["CIC"].Value = cic;

            }
            else      //从表自动填充主键(序号)
            {
                string sicKey = ugr.Cells["CIC"].Text;
                int indexSeq = 1;
                if (!_diction.Keys.Contains(sicKey))
                { _diction.Add(sicKey, indexSeq); }

                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreInnerChemcs.selectMaxComMSCStdChemC", new Object[] { sicKey }, this._ob);
                if (dt != null && dt.Rows.Count > 0)
                {
                    string indexSeqStr = dt.Rows[0]["INDEX_SEQ"].ToString();
                    if (!indexSeqStr.Equals(""))
                    {
                        int number = int.Parse(indexSeqStr);
                        if (number > _diction[sicKey])
                        {
                            indexSeq = number + 1;
                            _diction[sicKey] = number + 1;
                        }
                        else
                        {
                            indexSeq = _diction[sicKey] + 1;
                            _diction[sicKey] += 1;
                        }
                    }
                }
                else
                {
                    indexSeq = _diction[sicKey];
                    _diction[sicKey] = indexSeq + 1;
                }
                ugr.Cells["INDEX_SEQ"].Value = indexSeq.ToString();
                this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["ISCHECK"].Value = "false";
            }

        }


        public void SetModelText(string code, string desc)
        {

            this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["MODEL_CODE"].Value = code;
            this.ultraGridMSCRGRD.DisplayLayout.ActiveRow.Cells["MODEL_DESC"].Value = desc;
        }

        private void buttonQUERY_Click(object sender, EventArgs e)
        {
            DoQuery();
        }

        private void buttonEsc_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void buttonInsert_Click(object sender, EventArgs e)
        {
            add();
        }

        public void add()
        {
            #region 全程工序与钢种关系表
            ultraGridMSCRGRD.UpdateData();
            foreach (UltraGridRow ugrs in this.ultraGridMSCRGRD.Rows)
            {
                /*msc, msc_pline, cic, gradecode, gradename, assortment_code,
             assortment_name, std_code, std_name, create_name, create_time,
             validflag, memo*/
                if (ugrs.Cells["CHC"].Value.ToString().ToLower() == "true")
                {
                    string valname = ugrs.Cells["VALIDFLAGNAME"].Value.ToString();
                    if (valname.Equals("有效"))
                    {
                        valname = "1";
                    }
                    else
                    {
                        valname = "0";
                    }
                    DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_GRADE_ROWS", new Object[] { this.msc, this.msc_pline, ugrs.Cells["CIC"].Value.ToString() }, this._ob);
                    if (dt.Rows.Count > 0)
                    {
                        MessageBox.Show(ugrs.Cells["CIC"].Value.ToString() + " 已经维护！");
                        return;
                    }
                    ArrayList parm = new ArrayList();
                    parm.Add(this.msc);
                    parm.Add(this.msc_pline);
                    parm.Add(ugrs.Cells["CIC"].Value.ToString());
                    parm.Add(ugrs.Cells["GRADECODE"].Value.ToString() == "" ? " " : ugrs.Cells["GRADECODE"].Value.ToString());
                    parm.Add(ugrs.Cells["GRADENAME"].Value.ToString() == "" ? " " : ugrs.Cells["GRADENAME"].Value.ToString());
                    parm.Add(ugrs.Cells["GRADECODE"].Value.ToString() == "" ? " " : ugrs.Cells["GRADECODE"].Value.ToString());
                    parm.Add(ugrs.Cells["GRADENAME"].Value.ToString() == "" ? " " : ugrs.Cells["GRADENAME"].Value.ToString());
                    parm.Add(ugrs.Cells["STD_CODE_NK"].Value.ToString() == "" ? " " : ugrs.Cells["STD_CODE_NK"].Value.ToString());
                    parm.Add(ugrs.Cells["STD_NAME_NK"].Value.ToString() == "" ? " " : ugrs.Cells["STD_NAME_NK"].Value.ToString());
                    parm.Add(namerd);
                    parm.Add(valname);
                    parm.Add(ugrs.Cells["MEMO"].Value.ToString());


                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.pss.qcm.CoreFrmProPSCMSC";
                    ccp.MethodName = "getLineListINSERTCOM_MSC_GRADE";
                    ccp.ServerParams = new object[] { parm };
                    ccp = this._ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                    if (ccp.ReturnCode == -1)
                    {
                        MessageBox.Show("新增失败!");
                        return;
                    }
                }
            }
            MessageBox.Show("操作完成");
            this.DialogResult = DialogResult.OK;
            #endregion
        }


    }


}