MES_Client/TGMES/Core.StlMes.Client.Qcm/FrmProPSCMSC.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.UltraWinGrid;
using System;
using System.Collections;
using System.Data;
using System.Drawing;
using System.Text.RegularExpressions;
using System.Windows.Forms;
namespace Core.StlMes.Client.Qcm
{
    public partial class FrmProPSCMSC : FrmBase
    {
        string pscName = ""; //MSC名称
        string pscmscName = "";//PSC
        string mscNmae = "";//MSC
        string strShift = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserOrder();
        string strTerm = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserGroup();
        string strOperator = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
        string STD_CODE, STD_NAME, PRODUCCODE, PRODUCNAME, STEELCODE, STEELNAME, STD_STYLE, STD_STYLE_DESC, NEW_PROC_CODE, NEW_PROC_DESC = " ";
        string pscNameDesc = "";
        string proMsc = "";//全程工序MSC
        string pline = "";//产线号
        int iSelectRow = -1; //判定全程途径是否单选
        string whole_backlog = "";//工序
        string whole_backlog_desc = "";//工序名称 
        //用于展开操作项
        ArrayList listExpanl = new ArrayList();
        string falsTra = "false";

        TreeNode tNode = new TreeNode();
        TreeNode tNodes = new TreeNode();
        public FrmProPSCMSC()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            falsTra = "false";
            switch (ToolbarKey)
            {
                case "Query":
                    this.doQuery();
                    break;
                case "Add":
                    this.DoAdd();
                    if (falsTra.Equals("true"))
                    {
                        MessageUtil.ShowTips("操作成功！");
                    }
                    else if (falsTra.Equals("triwFalse"))
                    {
                        MessageUtil.ShowWarning("请单击选择树菜单品名-->冶金规范码!");
                        return;
                    }
                    else if (falsTra.Equals("com_msc"))
                    {
                        MessageUtil.ShowError(" 插入com_msc失败,可能数据错误,请联系计算机中心维护人员处理.");
                        return;
                    }
                    else if (falsTra.Equals("pscrmsc"))
                    {
                        MessageUtil.ShowError("插入品名和冶金规范码关系表失败(com_psc_r_msc)失败,可能数据错误,请联系计算机中心维护人员处理.");
                        return;
                    }
                    else if (falsTra.Equals("cicpic"))
                    {
                        MessageUtil.ShowError("冶金规范码项目已存在！");
                        return;
                    }
                    else if (falsTra.Equals("backLog"))
                    {
                        MessageUtil.ShowWarning("该产线号已存在!,不能重复添加。");
                        return;
                    }
                    else
                    {
                        MessageUtil.ShowWarning("未选中任何数据,操作失败!");
                        return;
                    }
                    doQuery();
                    uldtsMscGetData();
                    DataTable dtx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOG", new Object[] { pscName }, this.ob);
                    uldtsMscGetDataBACLOG(dtx);
                    break;
                case "Update"://作废

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认无效?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdate("申请作废");
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }
                    break;
                case "UpdateCs"://审核

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认审核通过?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdate("审核");
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }

                    break;
                case "UpdateBs"://提交审核

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认提交审核?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdate("提交审核");
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }
                    break;
                case "UpdateEs"://申请修改

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认申请修改?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdate("申请修改");
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }
                    break;
                case "UpdateMsc"://更新MSC

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认更新?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdateMsc();
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }

                    break;
                case "Resume": //恢复

                    if (boolMsc())
                    {
                        if (MessageBox.Show("是否确认恢复?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
                        {
                            this.DoUpdate("申请恢复");
                        }
                    }
                    else
                    {
                        MessageUtil.ShowWarning("请选择一条冶金规范码数据！");
                    }

                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /**
        *验证是否选择冶金规范码
        **/
        public bool boolMsc()
        {
            foreach (UltraGridRow ugrs in this.ultraGridMSC.Rows)
            {
                if (ugrs.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true")
                {
                    return true;
                }
            }
            return false;
        }
        /**
         *除了更新，查询按钮都调用该方法。
         **/
        public void DoUpdate(string flagName)
        {
            string flagbug = "";
            int selectid = 0;
            foreach (UltraGridRow ugr in this.ultraGridMSC.Rows)
            {
                if (ugr.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true" || ugr.Cells["UCCHOOSE"].Text.ToString().ToLower() == "true")
                {
                    string msc = ugr.Cells["MSC"].Value.ToString().Trim();
                    string valflag = flagName;
                    string flag = "";
                    DataTable dataFlg = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYCOM_MSC_PSCRMSC", new Object[] { msc }, this.ob);
                    if (dataFlg.Rows.Count <= 0)
                    {
                        MessageUtil.ShowWarning(pscName + " 冶金规范码不存在.");
                        continue;
                    }
                    string valName = dataFlg.Rows[0][0].ToString();
                    if (string.IsNullOrEmpty(valName))
                    {
                        flagbug += "冶金规范码:" + msc + " 有效标记不能为空； ";
                        continue;
                    }
                    if (flagName.Equals("申请修改") && valName.Equals("申请修改"))
                    {
                        MessageUtil.ShowWarning("不能重复申请修改。");
                        continue;
                    }
                    if (flagName.Equals("提交审核") && valName.Equals("提交审核"))
                    {
                        MessageUtil.ShowWarning("不能重复提交审核。");
                        continue;
                    }
                    if (flagName.Equals("审核") && valName.Equals("审核"))
                    {
                        MessageUtil.ShowWarning("不能重复审核。");
                        continue;
                    }
                    if (flagName.Equals("申请作废") && valName.Equals("申请作废"))
                    {
                        MessageUtil.ShowWarning("不能重复申请作废。");
                        continue;
                    }
                    if (flagName.Equals("申请恢复") && valName.Equals("申请恢复"))
                    {
                        MessageUtil.ShowWarning("不能重复申请恢复。");
                        continue;
                    }
                    if (flagName.Equals("申请恢复") && valName.Equals("录入状态"))
                    {
                        MessageUtil.ShowWarning("申请恢复失败，已经是录入状态，请提交审核。");
                        continue;
                    }

                    if (flagName.Equals("申请修改") && !valName.Equals("作废"))
                    {
                        valflag = "申请修改";
                    }
                    else if (flagName.Equals("申请修改") && valName.Equals("作废"))
                    {
                        MessageUtil.ShowWarning("作废状态不能申请修改，请先恢复在修改。");
                        continue;
                    }
                    if (flagName.Equals("申请修改") && !valName.Equals("提交审核"))
                    {
                        valflag = "申请修改";
                    }
                    else if (flagName.Equals("申请修改") && valName.Equals("提交审核"))
                    {
                        MessageUtil.ShowWarning("提交审核状态不能申请修改，请先审核完成在修改。");
                        continue;
                    }
                    if (flagName.Equals("申请作废") && !valName.Equals("作废"))
                    {
                        valflag = "申请作废";
                    }
                    else if (flagName.Equals("申请作废") && valName.Equals("作废"))
                    {
                        MessageUtil.ShowWarning("已经作废,不可重复！");
                        continue;
                    }
                    if (flagName.Equals("审核") && valName.Equals("无效"))
                    {
                        MessageUtil.ShowWarning("已经作废,请恢复数据，进行下一步操作。");
                        continue;
                    }
                    if (flagName.Equals("申请修改") && valName.Equals("无效"))
                    {
                        MessageUtil.ShowWarning("已经作废,请恢复数据，进行下一步操作。");
                        continue;
                    }
                    if (flagName.Equals("申请恢复") && valName.Equals("已生效"))
                    {
                        MessageUtil.ShowWarning("已经生效的冶金规范码,操作无效！");
                        continue;
                    }
                    if (flagName.Equals("审核") && valName.Equals("已生效"))
                    {
                        MessageUtil.ShowWarning("已经审核的冶金规范码,操作无效！");
                        continue;
                    }
                    if (flagName.Equals("提交审核") && valName.Equals("已生效"))
                    {
                        MessageUtil.ShowWarning("已经审核的冶金规范码,提交审核操作无效！");
                        continue;
                    }

                    if (flagName.Equals("审核") && valName.Equals("申请修改"))
                    {
                        valflag = "录入状态";
                    }
                    if (flagName.Equals("审核") && valName.Equals("申请作废"))
                    {
                        valflag = "无效";
                    }
                    if (flagName.Equals("审核") && valName.Equals("申请恢复"))
                    {
                        valflag = "录入状态";
                    }
                    if (flagName.Equals("审核") && valName.Equals("提交审核"))
                    {
                        valflag = "已生效";
                    }
                    if (flagName.Equals("审核") && valName.Equals("提交审核"))
                    {
                        valflag = "已生效";
                    }
                    if (flagName.Equals("提交审核") && valName.Equals("录入状态"))
                    {
                        valflag = "提交审核";
                    }
                    if (flagName.Equals("提交审核") && !valName.Equals("录入状态"))
                    {
                        MessageUtil.ShowWarning("MSC码：" + msc + "，必须是录入状态!");
                        continue;
                    }
                    if (flagName.Equals("录入状态") && !valName.Equals("作废"))
                    {
                        MessageUtil.ShowWarning("该条数据有效, 恢复失败.");
                        continue;
                    }
                    if (flagName.Equals("审核") && valName.Equals("录入状态"))
                    {
                        MessageUtil.ShowWarning("请按照流程操作, 目前状态是录入需要提交审核->审核!");
                        continue;
                    }
                    selectid = ugr.Index;
                    if (valflag.Trim().Equals("录入状态")) valflag = "A";
                    else if (valflag.Trim().Equals("提交审核")) valflag = "B";
                    else if (valflag.Trim().Equals("已生效")) valflag = "C";
                    else if (valflag.Trim().Equals("无效")) valflag = "D";
                    else if (valflag.Trim().Equals("申请修改")) valflag = "E";
                    else if (valflag.Trim().Equals("申请作废")) valflag = "F";
                    else if (valflag.Trim().Equals("申请恢复")) valflag = "G";
                    else if (valflag.Trim().Equals("申请审核")) valflag = "H";

                    if (valflag.Equals("D")) flag = "0";
                    else flag = "1";
                    ArrayList parm = new ArrayList();
                    parm.Add(valflag);//valflag代码标示
                    parm.Add(msc);//MSC主建代码

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

                    if (ccp.ReturnCode == -1)
                    {
                        return;
                    }
                    else
                    {
                        parm = new ArrayList();
                        parm.Add(flag);//valflag代码标示
                        parm.Add(msc);//MSC主建代码

                        ccp = new CoreClientParam();
                        ccp.ServerName = "com.steering.pss.qcm.CoreFrmProPSCMSC";
                        ccp.MethodName = "getLineListUPDATEPSCRMSCIS";
                        ccp.ServerParams = new object[] { parm };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                    }
                }
            }
            if (!string.IsNullOrEmpty(flagbug))
            {
                MessageUtil.ShowWarning(flagbug);
            }
            this.ultraGridMSC.Rows[selectid].Selected = true;
            doQuery();
            uldtsMscGetData();
        }
        /**
        *只更新冶金规范码数据
        **/
        public void DoUpdateMsc()
        {
            string flagbug = "";
            int selectid = 0;
            foreach (UltraGridRow ugr in this.ultraGridMSC.Rows)
            {
                if (ugr.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true" || ugr.Cells["UCCHOOSE"].Text.ToString().ToLower() == "true")
                {
                    string msc = ugr.Cells["MSC"].Value.ToString().Trim();
                    string valflag = ugr.Cells["VALIDFLAG"].Value.ToString();
                    if (string.IsNullOrEmpty(valflag))
                    {
                        flagbug += "冶金规范码:" + msc + " 有效标记不能为空； ";
                        continue;
                    }
                    if (!valflag.Equals("录入状态"))
                    {
                        flagbug += "冶金规范码:" + msc + " 录入状态才能修改。";
                        continue;
                    }
                    string department_code = ugr.Cells["DEPARTMENT_DESC"].Text.ToString();
                    string department_desc = ugr.Cells["DEPARTMENT_CODE"].Text.ToString();
                    string unit_code = ugr.Cells["UNIT_DESC"].Text.ToString();
                    string unit_desc = ugr.Cells["UNIT_CODE"].Text.ToString();
                    string use_code = ugr.Cells["USE_CODE"].Text.ToString();
                    string use_desc = ugr.Cells["USE_DESC"].Text.ToString();
                    string user_count = ugr.Cells["USER_COUNT"].Text.ToString();
                    string msc_seq = ugr.Cells["MSC_SEQ"].Text.ToString();
                    string msc_desc_seq = ugr.Cells["MSC_DESC_SEQ"].Text.ToString();
                    string update_name = strOperator;
                    string memo = ugr.Cells["MEMO"].Text.ToString().Trim();
                    string msc_style = ugr.Cells["MSC_STYLE"].Text.ToString().Trim();
                    if (msc_style.Trim().Equals("钢管")) msc_style = "A";
                    else if (msc_style.Trim().Equals("其他")) msc_style = "B";

                    string allownk = ugr.Cells["ALLOW_NK"].Text.ToString().Trim();
                    if (allownk.Trim().Equals("需要")) allownk = "1";
                    else if (allownk.Trim().Equals("不需要")) allownk = "0";

                    selectid = ugr.Index;
                    //if (valflag.Trim().Equals("录入状态")) valflag = "A";
                    //else if (valflag.Trim().Equals("提交审核")) valflag = "B";
                    //else if (valflag.Trim().Equals("已生效")) valflag = "C";
                    //else if (valflag.Trim().Equals("无效")) valflag = "D";
                    //else if (valflag.Trim().Equals("申请审核")) valflag = "E";

                    ArrayList parm = new ArrayList();
                    parm.Add(department_code);
                    parm.Add(department_desc);
                    parm.Add(unit_code);
                    parm.Add(unit_desc);
                    parm.Add(msc_style);
                    parm.Add(user_count);
                    parm.Add(allownk);
                    parm.Add(msc_seq);
                    parm.Add(msc_desc_seq);
                    //parm.Add(valflag);//valflag代码标示
                    parm.Add(update_name);
                    parm.Add(memo);
                    parm.Add(use_code);
                    parm.Add(use_desc);
                    parm.Add(msc);//MSC主建代码
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.pss.qcm.CoreFrmProPSCMSC";
                    ccp.MethodName = "getLineListSETUPDATECOMMSC";
                    ccp.ServerParams = new object[] { parm };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                    if (ccp.ReturnCode == -1)
                    {
                        return;
                    }
                }
            }
            if (!string.IsNullOrEmpty(flagbug))
            {
                MessageUtil.ShowWarning(flagbug);
            }
            else
            {
                MessageUtil.ShowTips("修改完成");
            }

            this.ultraGridMSC.Rows[selectid].Selected = true;
            doQuery();
            uldtsMscGetData();
        }
        /**
          * 已知需要维护3种标准，涉及三张表COM_MSC_ITEM（与树形菜单有关），COM_MSC_STD_CIC，COM_MSC_STD_PIC。
          * 1.适用客观无法维护.
          * 2.成分标准：新增成分项目 G国标或者K客服标准 生成索引号 新增COM_MSC_STD_CIC成分表，成分表界面维护其他属性。
          * 3.材质标准：新增材质项目 G国标或者K客服标准 生成索引号 新增COM_MSC_STD_PIC成分表，材质表界面维护其他属性。
          **/
        #region 冶金规范码二级。
        private void gridMscrj(int Index)
        {
            foreach (UltraGridRow ugrs in this.ultraGridMSC.Rows[Index].ChildBands[0].Rows)
            {
                if (ugrs.Cells["BANDUCCHOOSE"].Value.ToString().ToLower() == "true" || ugrs.Cells["BANDUCCHOOSE"].Text.ToString().ToLower() == "true")
                {
                    string msc = " where msc = '" + ugrs.Cells["MSC"].Value.ToString() + "' and ITEM ='" + ugrs.Cells["ITEM"].Value.ToString() + "' AND (item_c ='" + ugrs.Cells["ITEM_C"].Value.ToString() + "' or item_c is null)  ";
                    DataTable dts = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_COM_ITEM", new Object[] { msc }, this.ob);
                    if (dts.Rows.Count <= 0)
                    {
                        /*
                         msc, index_seq, item, item_c, create_name, create_time,
                         validflag, memo
                         */

                        ArrayList parm = new ArrayList();

                        parm.Add(ugrs.Cells["MSC"].Value.ToString());
                        parm.Add(ugrs.Cells["MSC"].Value.ToString());
                        parm.Add(ugrs.Cells["ITEM"].Value.ToString());
                        parm.Add(ugrs.Cells["ITEM_C"].Value.ToString());
                        parm.Add(strOperator);
                        parm.Add("1");
                        parm.Add(" ");



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

                        if (ccp.ReturnCode == -1) { return; }
                        else
                        {
                            string name_item = "";
                            DataTable dtitem = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_INFO_SORT_BASE", new Object[] { ugrs.Cells["ITEM"].Value.ToString() }, this.ob);
                            if (dtitem.Rows[0]["basename"].Equals("成分标准"))
                            {
                                dtitem = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_INFO_SORT_BASE", new Object[] { ugrs.Cells["ITEM_C"].Value.ToString() }, this.ob);
                                if (dtitem.Rows.Count > 0)
                                {
                                    if (dtitem.Rows[0]["basename"].Equals("国家标准"))
                                    {
                                        name_item = "G";
                                    }
                                    else if (dtitem.Rows[0]["basename"].Equals("客户标准"))
                                    {
                                        name_item = "K";
                                    }
                                    else
                                    {
                                        MessageUtil.ShowWarning("国家标准和客户标准不存在");
                                        continue;
                                    }

                                    parm = new ArrayList();

                                    parm.Add("CIC" + name_item);
                                    parm.Add(pscmscName);
                                    parm.Add(name_item);
                                    parm.Add(strOperator);

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

                                    if (ccp.ReturnCode == -1) return;
                                }
                            }
                            else if (dtitem.Rows[0]["basename"].Equals("材质标准"))
                            {
                                dtitem = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_INFO_SORT_BASE", new Object[] { ugrs.Cells["ITEM_C"].Value.ToString() }, this.ob);
                                if (dtitem.Rows.Count > 0)
                                {
                                    if (dtitem.Rows[0]["basename"].Equals("国家标准"))
                                    {
                                        name_item = "G";
                                    }
                                    else if (dtitem.Rows[0]["basename"].Equals("客户标准"))
                                    {
                                        name_item = "K";
                                    }
                                    else
                                    {
                                        MessageUtil.ShowWarning("国家标准和客户标准不存在");
                                        continue;
                                    }
                                    parm = new ArrayList();

                                    parm.Add("PIC" + name_item);
                                    parm.Add(pscmscName);
                                    parm.Add(name_item);
                                    parm.Add(strOperator);

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

                                    if (ccp.ReturnCode == -1) return;
                                }
                            }
                        }
                    }
                    else
                    {
                        falsTra = "cicpic";
                    }
                }
            }
        }
        #endregion
        /**
        *新增按钮涉及面有：冶金规范码、冶金规范码二级、全程工序产线。
         *1.新增冶金规范码涉及两张表：COM_MSC,COM_PSC_R_MSC;
         *2  * 已知需要维护3种标准，涉及三张表COM_MSC_ITEM（与树形菜单有关），COM_MSC_STD_CIC，COM_MSC_STD_PIC。
          * 1.适用客观无法维护.
          * 2.成分标准：新增成分项目 G国标或者K客服标准 生成索引号 新增COM_MSC_STD_CIC成分表，成分表界面维护其他属性。
          * 3.材质标准：新增材质项目 G国标或者K客服标准 生成索引号 新增COM_MSC_STD_PIC成分表，材质表界面维护其他属性。
         *3.全程工序产线（COM_MSC_BACKLOG与树菜单有关）简单新增。
        **/
        private void DoAdd()
        {
            //IList<string> stName = new List<string>();
            //IList<string> stPline = new List<string>();
            string strmscCode = "";//冶金规范码
            string strPscName = ""; //冶金规范码描述
            string errString = "";// 冶金规范码bug
            string errItemBug = "";//项目表bug
            string errBug = "";//验证
            string flagInt = "";
            string msc_pline = "";//产线号
            #region 冶金规范码
            /*msc, msc_desc, use_code, use_desc, department_code,
             department_desc, unit_code, unit_desc, msc_style, user_count,
             produccode, producname, std_code, std_name, steelcode,
             steelname, std_style, std_style_desc, new_proc_code,
             new_proc_desc, allow_nk, msc_seq, msc_desc_seq, create_name,
             create_time, validflag, memo*/
            ultraGridMSC.UpdateData();
            foreach (UltraGridRow ugr in this.ultraGridMSC.Rows)
            {
                if (ugr.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true" || ugr.Cells["UCCHOOSE"].Text.ToString().ToLower() == "true")
                {

                    //用于修改增加后展开
                    listExpanl.Add(ugr.Index);
                    string usecode = ugr.Cells["USE_CODE"].Value.ToString().Trim();
                    string msctos = ugr.Cells["MSC"].Value.ToString().Trim();
                    this.tNodes.Name = msctos;
                    int count = Convert.ToInt32(ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYPSCORMSCCOUNT", new Object[] { pscmscName, msctos }, this.ob).Rows[0][0].ToString());
                    if (count > 0)
                    {
                        falsTra = "true";
                        gridMscrj(ugr.Index);
                        continue;
                    }
                    if (!string.IsNullOrEmpty(pscmscName) && !pscmscName.Substring(0, 3).Equals("PSC"))
                    {
                        errBug += "PSC错误，请点击MSC。"; break;
                    }
                    if (string.IsNullOrEmpty(ugr.Cells["USER_COUNT"].Value.ToString().Trim())) { errBug += "使用次数不能为空，请填写！"; break; }
                    if (string.IsNullOrEmpty(ugr.Cells["ALLOW_NK"].Value.ToString().Trim())) { errBug += "是否维护内控标准不能为空，请填写！"; break; }
                    if (string.IsNullOrEmpty(errBug))
                    {
                        strmscCode = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYStaMsc", new Object[] { }, this.ob).Rows[0][0].ToString();
                        string usedesc = ugr.Cells["USE_CODE"].Text.ToString().Trim();
                        if (string.IsNullOrEmpty(usecode))
                        {
                            strPscName = pscNameDesc;
                        }
                        else
                        {
                            strPscName = pscNameDesc + "-" + usecode;
                        }
                        string departmentcode = ugr.Cells["DEPARTMENT_CODE"].Value.ToString().Trim();
                        string departmentdesc = ugr.Cells["DEPARTMENT_CODE"].Text.ToString().Trim();
                        string unitcode = ugr.Cells["UNIT_CODE"].Value.ToString().Trim();
                        string unitdesc = ugr.Cells["UNIT_CODE"].Text.ToString().Trim();
                        string mscstyle = ugr.Cells["MSC_STYLE"].Text.ToString().Trim();
                        if (mscstyle.Trim().Equals("钢管")) mscstyle = "A";
                        else if (mscstyle.Trim().Equals("其他")) mscstyle = "B";
                        string usercount = ugr.Cells["USER_COUNT"].Value.ToString().Trim();
                        string use_code = ugr.Cells["USE_CODE"].Value.ToString().Trim();
                        string use_desc = ugr.Cells["USE_CODE"].Text.ToString().Trim();
                        string produccode = this.PRODUCCODE;//品名
                        string producname = this.PRODUCNAME;
                        string stdcode = this.STD_CODE;
                        string stdname = this.STD_NAME;
                        string steelcode = this.STEELCODE;
                        string steelname = this.STEELNAME;
                        string stdstyle = this.STD_STYLE;
                        string stdstyledesc = this.STD_STYLE_DESC;
                        string newproccode = this.NEW_PROC_CODE;
                        string newprocdesc = this.NEW_PROC_DESC;
                        string allownk = ugr.Cells["ALLOW_NK"].Text.ToString().Trim();
                        string mscseq = " ";
                        string mscdescseq = " ";
                        if (allownk.Trim().Equals("需要")) allownk = "1";
                        else if (allownk.Trim().Equals("不需要")) allownk = "0";
                        if (!string.IsNullOrEmpty(ugr.Cells["MSC_SEQ"].Text.Trim()))
                        {
                            mscseq = ugr.Cells["MSC_SEQ"].Text.ToString().Trim().Substring(0, 20);
                            mscdescseq = ugr.Cells["MSC_SEQ"].Text.ToString().Trim();
                        }
                        string createname = strOperator;
                        string validflag = "A";
                        //if (validflag.Trim().Equals("录入状态")) validflag = "A";
                        //else if (validflag.Trim().Equals("提交审核")) validflag = "B";
                        //else if (validflag.Trim().Equals("已生效")) validflag = "C";
                        //else if (validflag.Trim().Equals("无效")) validflag = "D";
                        string memo = ugr.Cells["MEMO"].Value.ToString().Trim();

                        if (flagInt.Trim().Equals("无效")) flagInt = "0";
                        else flagInt = "1";
                        ArrayList parm = new ArrayList();

                        parm.Add(strmscCode);
                        parm.Add(strPscName);
                        parm.Add(usecode);
                        parm.Add(usedesc);
                        parm.Add(departmentcode);
                        parm.Add(departmentdesc);
                        parm.Add(unitcode);
                        parm.Add(unitdesc);
                        parm.Add(mscstyle);
                        parm.Add(usercount);
                        parm.Add(produccode);
                        parm.Add(producname);
                        parm.Add(stdcode);
                        parm.Add(stdname);
                        parm.Add(steelcode);
                        parm.Add(steelname);
                        parm.Add(stdstyle);
                        parm.Add(stdstyledesc);
                        parm.Add(newproccode);
                        parm.Add(newprocdesc);
                        parm.Add(allownk);
                        parm.Add(mscseq);
                        parm.Add(mscdescseq);
                        parm.Add(createname);
                        parm.Add(validflag);
                        parm.Add(memo);

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

                        if (ccp.ReturnCode == -1)
                        {
                            falsTra = "com_msc";
                            return;
                        }
                        else
                        {
                            parm = new ArrayList();
                            parm.Add(pscmscName);//PSC代码
                            parm.Add(pscmscName);//PSC描述
                            parm.Add(usecode);
                            parm.Add(usedesc);
                            parm.Add(strmscCode);
                            parm.Add(strPscName);
                            parm.Add(createname);
                            parm.Add(flagInt);
                            parm.Add(memo);

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

                            if (ccp.ReturnCode == -1) { falsTra = "pscrmsc"; return; }
                            else { falsTra = "true"; gridMscrj(ugr.Index); }
                        }
                    }
                }
                #endregion
            }
            #region 全程工序
            foreach (UltraGridRow ugrs in this.ultraGridBack.Rows)
            {
                if (ugrs.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true")
                {
                    if (!string.IsNullOrEmpty(pscName) && pscName.Substring(0, 3).Equals("MSC"))
                    {
                        DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOGS", new Object[] { pscName, ugrs.Cells["msc_pline"].Value.ToString() }, this.ob);
                        if (dt.Rows.Count > 0)
                        {
                            falsTra = "backLog";
                            //stName.Add(ugrs.Cells["msc"].Value.ToString());
                            //stPline.Add(ugrs.Cells["msc_pline"].Value.ToString());
                            continue;
                        }
                        if (pscName.Substring(0, 3).Equals("MSC"))
                        {
                            ArrayList parm = new ArrayList();
                            string memo = ugrs.Cells["MEMO"].Value.ToString();
                            parm.Add(pscName);
                            parm.Add(pscName);
                            parm.Add(strOperator);
                            parm.Add(memo);
                            CoreClientParam ccp = new CoreClientParam();
                            ccp.ServerName = "com.steering.pss.qcm.CoreFrmProPSCMSC";
                            ccp.MethodName = "getLineListINSERTCOM_MSC_BACKLOG";
                            ccp.ServerParams = new object[] { parm };
                            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                            if (ccp.ReturnCode == -1) { return; }
                            else
                            {
                                falsTra = "true";
                            }
                        }
                    }
                    else
                    {
                        falsTra = "triwFalse";
                        return;
                    }
                }

            }
            #endregion 
            if (!string.IsNullOrEmpty(errString))
            {
                MessageUtil.ShowWarning("其他冶金规范维护成功,以下冶金规范已存在:" + errString + "; /R 错误提示:" + errBug);
            }
            if (!string.IsNullOrEmpty(errItemBug))
            {
                MessageUtil.ShowWarning(errItemBug);
            }
            if (!string.IsNullOrEmpty(errBug))
            {
                MessageUtil.ShowWarning(errBug);
                return;
            }
        }
        /**加载全程工序点路径
         * 11.27提出需求未实现部分：勾选大工序循环次数（ICOUNT）>1 在工序点画面复制一份相同数据如：选中一条热处理大工序循环次数=2，工序点只有一条热处理1显示两遍，保存到工序点表(com_msc_station).同工序流水号。
         **/
        public void loadStation(string mscs, string msc_plines)
        {

            DataTable dtStiation = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERY_MSC_STATION_DESC", new Object[] { mscs, msc_plines }, this.ob);
            string staTionName = "全程工序点路径: ";
            for (int j = 0; j < dtStiation.Rows.Count; j++)
            {
                staTionName += dtStiation.Rows[j]["STATION_DESC"].ToString() + "-";
            }
            this.labelStation.Text = staTionName.Substring(0, staTionName.Length - 1);
        }
        private void FrmProPSCMSC_Load(object sender, EventArgs e)
        {
            doQuery();
            loadBox();
        }
        //初始化box
        private void loadBox()
        {
            DataTable isx = new DataTable();
            DataTable unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            //引用MSC代码
            this.MSCBOX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQueryMSC", new Object[] { }, this.ob);
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["代码"].ToString(), isx.Rows[i]["代码"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.MSCBOX.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                MSCBOX.DataSource = unLoad;
                MSCBOX.DisplayMember = "Name";
                MSCBOX.ValueMember = "Code";
            }
            //AlpHa代码
            isx = new DataTable();
            this.STDBOX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQuerySTD", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["代码描述"].ToString(), isx.Rows[i]["代码"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.STDBOX.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                STDBOX.DataSource = unLoad;
                STDBOX.DisplayMember = "Name";
                STDBOX.ValueMember = "Code";
            }
            //类型：钢管，其他。
            isx = new DataTable();
            this.MSCSTYLECOMBX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQueryType", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["代码描述"].ToString(), i.ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.MSCSTYLECOMBX.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.Add(dr);
                MSCSTYLECOMBX.DataSource = unLoad;
                MSCSTYLECOMBX.DisplayMember = "Name";
                MSCSTYLECOMBX.ValueMember = "Code";
            }
            //维护内控标准：需要，不需要。
            isx = new DataTable();
            this.ALLOWNKBOX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYLKAK", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["代码描述"].ToString(), i.ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.ALLOWNKBOX.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.Add(dr);
                ALLOWNKBOX.DataSource = unLoad;
                ALLOWNKBOX.DisplayMember = "Name";
                ALLOWNKBOX.ValueMember = "Code";
            }
            //状态 录入，已生效......
            isx = new DataTable();
            this.VALIDFLAGBOX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQueryVALIDFLAG", new Object[] { }, this.ob);
            if (isx.Rows.Count > 0)
            {
                this.VALIDFLAGBOX.DataSource = isx;
                DataRow dr = isx.NewRow();
                isx.Rows.InsertAt(dr, 0);
                VALIDFLAGBOX.DataSource = isx;
            }
            //查询项目规范项
            isx = new DataTable();
            this.ultraITEMBOX.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_INFO", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["basename"].ToString(), isx.Rows[i]["basecode"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.ultraITEMBOX.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                ultraITEMBOX.DataSource = unLoad;
                ultraITEMBOX.DisplayMember = "Name";
                ultraITEMBOX.ValueMember = "Code";
            }
            //获取内控标准
            isx = new DataTable();
            this.ultraComboSTDNK.DataSource = null;
            isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_STD_NK", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["std_name"].ToString(), isx.Rows[i]["std_code"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.ultraComboSTDNK.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                ultraComboSTDNK.DataSource = unLoad;
                ultraComboSTDNK.DisplayMember = "Name";
                ultraComboSTDNK.ValueMember = "Code";
            }
            //获取部门
            isx = new DataTable();
            this.ultraComboDepart.DataSource = null;
            isx = ServerHelper.GetData("com.steering.comm.data.ComBaseInfo.getDepartment", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["DEPARTNAME"].ToString(), isx.Rows[i]["DEPARTID"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.ultraComboDepart.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                ultraComboDepart.DataSource = unLoad;
                ultraComboDepart.DisplayMember = "Name";
                ultraComboDepart.ValueMember = "Code";
            }
            //获取科室
            isx = new DataTable();
            this.ultraComboSection.DataSource = null;
            isx = ServerHelper.GetData("com.steering.comm.data.ComBaseInfo.getSection", new Object[] { }, this.ob);
            unLoad = new DataTable();
            unLoad.Columns.Add("Name", typeof(System.String));
            unLoad.Columns.Add("Code", typeof(System.String));
            for (int i = 0; i < isx.Rows.Count; i++)
            {
                unLoad.Rows.Add(isx.Rows[i]["DEPARTNAME"].ToString(), isx.Rows[i]["DEPARTID"].ToString());
            }
            if (isx.Rows.Count > 0)
            {
                this.ultraComboSection.DataSource = unLoad;
                DataRow dr = unLoad.NewRow();
                unLoad.Rows.InsertAt(dr, 0);
                ultraComboSection.DataSource = unLoad;
                ultraComboSection.DisplayMember = "Name";
                ultraComboSection.ValueMember = "Code";
            }
        }
        //查询树形结构
        private void doQuery()
        {
            //产品规范 
            tNode = new TreeNode();
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQuery", new Object[] { }, this.ob);
            DataTable fnodedt = new DataTable(); //一级
            DataTable datblBack = new DataTable(); //工序
            DataTable datblGrad = new DataTable(); //钢种 

            DataTable fnodeLipn = new DataTable(); //二级
            this.treeViewName.Nodes.Clear();
            TreeNode fnode = new TreeNode();
            TreeNode fnodeLp = new TreeNode();//工序
            TreeNode fnodexs = new TreeNode(); //冶金
            TreeNode fnodexGx = new TreeNode(); //工序
            TreeNode fnodexGz = new TreeNode(); //钢种
            int j = 0;
            int x = 0;
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string mscName = dt.Rows[i]["msc"].ToString();
                //正在修改的树形结构、
                if (i > 0)
                {
                    if (dt.Rows[i - 1]["psc"].ToString().Equals(dt.Rows[i]["psc"].ToString()))
                    {
                        j = j + 1;
                        //二级
                        if (!string.IsNullOrEmpty(dt.Rows[i]["psc"].ToString()) && !string.IsNullOrEmpty(dt.Rows[i]["msc"].ToString()))
                        {
                            fnode = treeViewName.Nodes[i - j];
                            fnode.Nodes.Add(dt.Rows[i]["msc"].ToString(), dt.Rows[i]["mscdesc"].ToString());

                            fnodedt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_ITEMCODE", new Object[] { mscName }, this.ob);
                            fnodeLipn = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOG", new Object[] { mscName }, this.ob);

                            fnodeLp = fnode.LastNode;

                            fnodexs = fnode.LastNode;
                            fnodexGx = fnode.LastNode;
                            fnodexGz = fnode.LastNode;
                            x = 0;
                            //加载成分和标准
                            for (int r = 0; r < fnodedt.Rows.Count; r++)
                            {

                                if (r > 0 && fnodedt.Rows[r - 1]["item"].ToString().Equals(fnodedt.Rows[r]["item"].ToString()))
                                {
                                    fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename_c"].ToString());
                                    continue;
                                }

                                fnode = fnodexs;
                                fnodexs = fnode;

                                fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename"].ToString());
                                if (!string.IsNullOrEmpty(fnodedt.Rows[r]["basename_c"].ToString()))
                                {
                                    fnode = fnode.LastNode;
                                    fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename_c"].ToString());
                                }
                            }
                            //加载全程工序
                            for (int w = 0; w < fnodeLipn.Rows.Count; w++)
                            {
                                fnode = fnodeLp;
                                fnode.Nodes.Add(fnodeLipn.Rows[w]["msc_pline"].ToString(), "全程路径产线号-" + fnodeLipn.Rows[w]["msc_pline"].ToString());

                                datblBack = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_PROCESSDESC", new Object[] { mscName, fnodeLipn.Rows[w]["msc_pline"] }, this.ob);

                                for (int r = 0; r < datblBack.Rows.Count; r++)
                                {
                                    if (r > 0 && datblBack.Rows[r - 1]["process_code"].ToString().Equals(datblBack.Rows[r]["process_code"].ToString()))
                                    {
                                        fnode.Nodes.Add(datblBack.Rows[r]["station_code"].ToString(), datblBack.Rows[r]["station_desc"].ToString());
                                        continue;
                                    }
                                    if (!string.IsNullOrEmpty(datblBack.Rows[r]["process_desc"].ToString().Trim()) && !string.IsNullOrEmpty(datblBack.Rows[r]["process_code"].ToString().Trim()))
                                    {
                                        fnode = fnodeLp.LastNode;
                                        fnode.Nodes.Add(datblBack.Rows[r]["process_code"].ToString(), datblBack.Rows[r]["process_desc"].ToString());
                                        if (!string.IsNullOrEmpty(datblBack.Rows[r]["station_code"].ToString().Trim()))
                                        {
                                            fnode = fnode.LastNode;
                                            fnode.Nodes.Add(datblBack.Rows[r]["station_code"].ToString(), datblBack.Rows[r]["station_desc"].ToString());
                                        }
                                    }
                                }

                                //加载钢种
                                datblGrad = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_GRADECODE", new Object[] { mscName, fnodeLipn.Rows[w]["msc_pline"].ToString() }, this.ob);

                                for (int r = 0; r < datblGrad.Rows.Count; r++)
                                {

                                    if (r > 0 && datblGrad.Rows[r - 1]["gradecode"].ToString().Equals(datblGrad.Rows[r]["gradecode"].ToString()))
                                    {
                                        fnode.Nodes.Add(datblGrad.Rows[r]["gradecode"].ToString(), datblGrad.Rows[r]["gradename"].ToString() + "-" + datblGrad.Rows[r]["std_name"].ToString());
                                        continue;
                                    }

                                    fnode = fnodeLp.LastNode;

                                    fnode.Nodes.Add(datblGrad.Rows[r]["gradecode"].ToString(), datblGrad.Rows[r]["gradename"].ToString() + "-" + datblGrad.Rows[r]["std_name"].ToString());

                                }
                            }
                        }
                        continue;
                    }
                }
                //一级
                if (!string.IsNullOrEmpty(dt.Rows[i]["psc"].ToString()))
                {
                    treeViewName.Nodes.Add(dt.Rows[i]["psc"].ToString(), dt.Rows[i]["psc_desc"].ToString());
                }
                //二级
                if (!string.IsNullOrEmpty(dt.Rows[i]["psc"].ToString()) && !string.IsNullOrEmpty(dt.Rows[i]["msc"].ToString()))
                {
                    fnode = treeViewName.Nodes[i - j];
                    fnode.Nodes.Add(dt.Rows[i]["msc"].ToString(), dt.Rows[i]["mscdesc"].ToString());

                    fnodedt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_ITEMCODE", new Object[] { mscName }, this.ob);
                    fnodeLipn = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOG", new Object[] { mscName }, this.ob);

                    fnodeLp = fnode.LastNode;

                    fnodexs = fnode.LastNode;
                    fnodexGx = fnode.LastNode;
                    fnodexGz = fnode.LastNode;
                    x = 0;
                    for (int r = 0; r < fnodedt.Rows.Count; r++)
                    {

                        if (r > 0 && fnodedt.Rows[r - 1]["item"].ToString().Equals(fnodedt.Rows[r]["item"].ToString()))
                        {
                            fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename_c"].ToString());
                            continue;
                        }

                        fnode = fnodexs;
                        fnodexs = fnode;

                        fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename"].ToString());
                        if (!string.IsNullOrEmpty(fnodedt.Rows[r]["basename_c"].ToString()))
                        {
                            fnode = fnode.LastNode;
                            fnode.Nodes.Add(fnodedt.Rows[r]["item"].ToString(), fnodedt.Rows[r]["basename_c"].ToString());
                        }
                    }

                    for (int w = 0; w < fnodeLipn.Rows.Count; w++)
                    {
                        fnode = fnodeLp;
                        fnode.Nodes.Add(fnodeLipn.Rows[w]["msc_pline"].ToString(), "全程路径产线号-" + fnodeLipn.Rows[w]["msc_pline"].ToString());

                        datblBack = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_PROCESSDESC", new Object[] { mscName, fnodeLipn.Rows[w]["msc_pline"] }, this.ob);

                        for (int r = 0; r < datblBack.Rows.Count; r++)
                        {
                            if (r > 0 && datblBack.Rows[r - 1]["process_code"].ToString().Equals(datblBack.Rows[r]["process_code"].ToString()))
                            {
                                fnode.Nodes.Add(datblBack.Rows[r]["station_code"].ToString(), datblBack.Rows[r]["station_desc"].ToString());
                                continue;
                            }
                            if (!string.IsNullOrEmpty(datblBack.Rows[r]["process_desc"].ToString().Trim()) && !string.IsNullOrEmpty(datblBack.Rows[r]["process_code"].ToString().Trim()))
                            {
                                fnode = fnodeLp.LastNode;
                                fnode.Nodes.Add(datblBack.Rows[r]["process_code"].ToString(), datblBack.Rows[r]["process_desc"].ToString());
                                if (!string.IsNullOrEmpty(datblBack.Rows[r]["station_code"].ToString().Trim()))
                                {
                                    fnode = fnode.LastNode;
                                    fnode.Nodes.Add(datblBack.Rows[r]["station_code"].ToString(), datblBack.Rows[r]["station_desc"].ToString());
                                }
                            }
                        }


                        datblGrad = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListSELECT_MSC_STATION_GRADECODE", new Object[] { mscName, fnodeLipn.Rows[w]["msc_pline"].ToString() }, this.ob);

                        for (int r = 0; r < datblGrad.Rows.Count; r++)
                        {

                            if (r > 0 && datblGrad.Rows[r - 1]["gradecode"].ToString().Equals(datblGrad.Rows[r]["gradecode"].ToString()))
                            {
                                fnode.Nodes.Add(datblGrad.Rows[r]["gradecode"].ToString(), datblGrad.Rows[r]["gradename"].ToString() + "-" + datblGrad.Rows[r]["std_name"].ToString());
                                continue;
                            }

                            fnode = fnodeLp.LastNode;

                            fnode.Nodes.Add(datblGrad.Rows[r]["gradecode"].ToString(), datblGrad.Rows[r]["gradename"].ToString() + "-" + datblGrad.Rows[r]["std_name"].ToString());

                        }
                    }
                }
            }
            //自动展开功能只处理PSC,MSC,MSC子节点三级。tNodes在点击树节点事件保存起来的。
            if (!string.IsNullOrEmpty(tNodes.Name))
            {
                for (int e = 0; e < this.treeViewName.Nodes.Count; e++)
                {
                    //展开PSC节点

                    if (this.treeViewName.Nodes[e].Name.Equals(tNodes.Name))
                    {
                        this.treeViewName.Nodes[e].Expand();
                        return;
                    }

                    //展开MSC节点
                    for (int w = 0; w < this.treeViewName.Nodes[e].Nodes.Count; w++)
                    {
                        if (this.treeViewName.Nodes[e].Nodes[w].Name.Equals(tNodes.Name))
                        {
                            this.treeViewName.Nodes[e].Expand();
                            this.treeViewName.Nodes[e].Nodes[w].ExpandAll();
                            return;
                        }
                    }
                    //展开MSC子节点
                    for (int w = 0; w < this.treeViewName.Nodes[e].Nodes.Count; w++)
                    {
                        for (int r = 0; r < this.treeViewName.Nodes[e].Nodes[w].Nodes.Count; r++)
                        {
                            if (this.treeViewName.Nodes[e].Nodes[w].Nodes[r].Name.Equals(tNodes.Name))
                            {
                                this.treeViewName.Nodes[e].Expand();
                                this.treeViewName.Nodes[e].Nodes[w].Expand();
                                this.treeViewName.Nodes[e].Nodes[w].Nodes[r].ExpandAll();
                                return;
                            }
                        }
                    }
                }
            }
        }
        //查询冶金规范码
        private void uldtsMscGetData()
        {
            string columnName = "";
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQueryComMsc", new Object[] { pscmscName }, this.ob);
            int i = 0;
            uldtsMsc.Tables[0].Clear();
            foreach (DataRow dr in dt.Rows)
            {
                DataRow _dr = uldtsMsc.Tables[0].NewRow();
                foreach (DataColumn dc in uldtsMsc.Tables[0].Columns)
                {
                    _dr[dc.ColumnName] = dr[dc.ColumnName];
                }
                uldtsMsc.Tables[0].Rows.Add(_dr);
                columnName += "'" + uldtsMsc.Tables[0].Rows[i]["MSC"].ToString() + "',";
                i++;
            }
            if (dt.Rows.Count > 0)
            {
                int idex = Convert.ToInt32(columnName.LastIndexOf(","));
                string sql = "where msc in (" + columnName.Substring(0, idex) + ") ";

                DataTable dts = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_COM_ITEM", new Object[] { sql }, this.ob);
                uldtsMsc.Tables[1].Clear();
                foreach (DataRow dr in dts.Rows)
                {
                    DataRow _dr = uldtsMsc.Tables[1].NewRow();
                    foreach (DataColumn dc in uldtsMsc.Tables[1].Columns)
                    {
                        _dr[dc.ColumnName] = dr[dc.ColumnName];
                    }
                    uldtsMsc.Tables[1].Rows.Add(_dr);
                }
            }
            foreach (UltraGridRow ugr in this.ultraGridMSC.Rows)
            {
                if (ugr.Cells["VALIDFLAG"].Value.ToString().ToLower() == "无效")
                {
                    this.ultraGridMSC.Rows[ugr.Index].CellAppearance.BackColor = Color.Red;
                    this.ultraGridMSC.DisplayLayout.Override.AllowColMoving = AllowColMoving.WithinBand;
                    this.ultraGridMSC.DisplayLayout.Override.AllowColSwapping = AllowColSwapping.WithinBand;
                    this.ultraGridMSC.DisplayLayout.Override.TemplateAddRowCellAppearance.BackColor = Color.Yellow;
                    this.ultraGridMSC.DisplayLayout.Override.TemplateAddRowCellAppearance.ForeColor = Color.LightYellow;
                }
            }
            foreach (int ix in listExpanl)
            {
                this.ultraGridMSC.Rows[ix].ExpandAll();
            }
            listExpanl = new ArrayList();
            GridHelper.RefreshAndAutoSizeExceptRows(ultraGridMSC, new UltraGridColumn[] { });
        }
        //查询冶金规范产线表
        private void uldtsMscGetDataBACLOG(DataTable dttos)
        {
            DataTable dt = dttos;
            iSelectRow = -1;
            this.uldtsBaclog.Tables[0].Clear();
            foreach (DataRow dr in dt.Rows)
            {
                DataRow _dr = uldtsBaclog.Tables[0].NewRow();
                foreach (DataColumn dc in uldtsBaclog.Tables[0].Columns)
                {
                    _dr[dc.ColumnName] = dr[dc.ColumnName];
                }
                uldtsBaclog.Tables[0].Rows.Add(_dr);
            }
        }
        //刷新冶金规范产线表
        private void uldtsMscGetDataBAClogs(DataTable dttos)
        {
            DataTable dt = dttos;
            this.uldtsBaclog.Tables[0].Clear();
            foreach (DataRow dr in dt.Rows)
            {
                DataRow _dr = uldtsBaclog.Tables[0].NewRow();
                foreach (DataColumn dc in uldtsBaclog.Tables[0].Columns)
                {
                    _dr[dc.ColumnName] = dr[dc.ColumnName];
                }
                uldtsBaclog.Tables[0].Rows.Add(_dr);
            }
        }
        //查询钢种
        private void uldtsMscGetDatabBaseGrade(DataTable dttos)
        {
            DataTable dt = dttos;
            this.uldtsProce.Tables["TableGrade"].Clear();
            foreach (DataRow dr in dt.Rows)
            {
                DataRow _dr = this.uldtsProce.Tables["TableGrade"].NewRow();
                foreach (DataColumn dc in this.uldtsProce.Tables["TableGrade"].Columns)
                {
                    _dr[dc.ColumnName] = dr[dc.ColumnName];
                }
                this.uldtsProce.Tables["TableGrade"].Rows.Add(_dr);
            }
        }
        //树形结构点击事件
        private void treeViewName_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            if (tNode.Text.Trim() != "")
            {
                tNode.NodeFont = new Font("宋体", 9F, System.Drawing.FontStyle.Regular);
                tNode.BackColor = Color.Empty;
            }
            e.Node.NodeFont = new Font("宋体", 10F, System.Drawing.FontStyle.Underline);
            e.Node.BackColor = Color.Empty;
            e.Node.BackColor = Color.LightBlue;
            tNode = e.Node;
            tNodes = e.Node;
            this.uldtsProce.Tables[1].Clear(); //清空工序点数据。
            if (e.Node.Name.Length > 3 && e.Node.Name.ToString().Substring(0, 3).Equals("PSC"))
            {
                this.pscmscName = e.Node.Name.ToString();
            }

            pscName = e.Node.Name.ToString();
            pscNameDesc = e.Node.Text.ToString();
            if (e.Node.Name.Length > 3 && e.Node.Name.ToString().Substring(0, 3).Equals("MSC"))
            {
                this.mscNmae = e.Node.Name.ToString();
            }


            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYStaPsc", new Object[] { pscName }, this.ob);
            if (dt.Rows.Count > 0)
            {
                STD_CODE = dt.Rows[0]["STD_CODE"].ToString();
                STD_NAME = dt.Rows[0]["STD_NAME"].ToString();
                STEELCODE = dt.Rows[0]["STEELCODE"].ToString();
                STEELNAME = dt.Rows[0]["STEELNAME"].ToString();
                STD_STYLE = dt.Rows[0]["STD_STYLE"].ToString();
                STD_STYLE_DESC = dt.Rows[0]["STD_STYLE_DESC"].ToString();
                NEW_PROC_CODE = dt.Rows[0]["NEW_PROC_CODE"].ToString();
                NEW_PROC_DESC = dt.Rows[0]["NEW_PROC_DESC"].ToString();
                PRODUCNAME = dt.Rows[0]["PRODUCNAME"].ToString();
                PRODUCCODE = dt.Rows[0]["PRODUCCODE"].ToString();

                uldtsMscGetData();
            }
            else if (dt.Rows.Count <= 0)
            {
                dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOG", new Object[] { pscName }, this.ob);

                uldtsMscGetDataBACLOG(dt);
            }
        }
        /**
         * 两种逻辑：第一种选择冶金规范码项目；第二种：选择冶金规范码二级自动勾选一级。
         *选择冶金规范码项目触发该方法根据ITEM查询com_base_info where SORTCODE = ITEM.
         **/
        private void ultraGrid5_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {

            ultraGridMSC.UpdateData();
            if (e.Cell.Column.Key.Equals("ITEM") && !string.IsNullOrEmpty(e.Cell.Row.Cells["ITEM"].Value.ToString()))
            {
                DataTable isx = new DataTable();

                this.ultraITEMCBOX.DataSource = null;
                isx = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_BASE_INFO_SORT", new Object[] { e.Cell.Row.Cells["ITEM"].Value.ToString() }, this.ob);
                if (isx.Rows.Count > 0)
                {
                    DataTable unLoad = new DataTable();
                    unLoad.Columns.Add("Name", typeof(System.String));
                    unLoad.Columns.Add("Code", typeof(System.String));
                    for (int i = 0; i < isx.Rows.Count; i++)
                    {
                        unLoad.Rows.Add(isx.Rows[i]["basename"].ToString(), isx.Rows[i]["basecode"].ToString());
                    }
                    if (isx.Rows.Count > 0)
                    {
                        this.ultraITEMCBOX.DataSource = unLoad;
                        DataRow dr = unLoad.NewRow();
                        unLoad.Rows.InsertAt(dr, 0);
                        ultraITEMCBOX.DataSource = unLoad;
                        ultraITEMCBOX.DisplayMember = "Name";
                        ultraITEMCBOX.ValueMember = "Code";
                    }
                }
            }
            if (e.Cell.Column.Key.Equals("BANDUCCHOOSE"))
            {
                string toMsc = e.Cell.Row.Cells["MSC"].Value.ToString();
                Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
                for (int i = 0; i < ultraGridMSC.Rows.Count; i++)
                {
                    row = ultraGridMSC.Rows[i];
                    row.Cells["UCCHOOSE"].Value = false;
                    foreach (UltraGridRow ugrs in this.ultraGridMSC.Rows[i].ChildBands[0].Rows)
                    {
                        if (ugrs.Cells["BANDUCCHOOSE"].Value.ToString().ToLower().Equals("true"))
                        {
                            row = ultraGridMSC.Rows[i];
                            row.Cells["UCCHOOSE"].Value = true;
                            break;
                        }
                    }
                }
            }

            #region 勾选选择处理逻辑。  
            //Infragistics.Win.UltraWinGrid.UltraGridRow row = null;

            //for (int i = 0; i < ultraGridMSC.Rows.Count; i++)
            //{
            //    row = ultraGridMSC.Rows[i];
            //    if (row.Cells["UCCHOOSE"].Value.ToString().ToLower().Equals("true"))
            //    {  
            //        row.Activation = Activation.AllowEdit; 
            //    }
            //    else
            //    {
            //        //取消勾选变成不可编辑导致勾选栏也不可编辑，待完善。
            //        //row.Activation = Activation.ActivateOnly;
            //    }
            //} 
            //row.Band.Columns["UCCHOOSE"].CellActivation = Activation.AllowEdit;
            #endregion

            #region 使用次数验证
            if (e.Cell.Column.Key.Equals("USER_COUNT") && !e.Cell.Value.ToString().Equals("-") && !e.Cell.Value.ToString().Equals("-1") && !string.IsNullOrEmpty(e.Cell.Value.ToString()))
            {
                string pattern = "^([-+]?\\d+)(\\.\\d+)?$"; ;// 定义正则表达式 ,"  "里面的是表达式

                Match m = Regex.Match(e.Cell.Value.ToString(), pattern);// 匹配正则表达式

                if (m.Success)
                {

                }
                else
                {
                    e.Cell.Value = "";
                    MessageUtil.ShowWarning("有效使用次数只允许使用无限:-1和阿拉伯数字0-9.");
                }
            }
            #endregion

        }

        //冶金规范码只允许操作一行。
        public int QuerybriBack()
        {
            this.ultraGridBack.UpdateData();
            int QuerybriBackInt = 0;
            foreach (UltraGridRow ugrs in this.ultraGridBack.Rows)
            {
                if (ugrs.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true")
                {
                    QuerybriBackInt = QuerybriBackInt + 1;
                }
            }
            return QuerybriBackInt;
        }

        //加载大工序。
        public void comMsc_Process()
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_PROCESS", new Object[] { pscName, pline }, this.ob);

            this.uldtsProce.Tables[0].Clear();
            foreach (DataRow dr in dt.Rows)
            {
                int iCount = Convert.ToInt32(dr["ICOUNT"]);
                int iProcessSeq = 1;
                while (iCount > 0)
                {
                    DataRow _dr = uldtsProce.Tables[0].NewRow();
                    foreach (DataColumn dc in uldtsProce.Tables[0].Columns)
                    {
                        _dr[dc.ColumnName] = dr[dc.ColumnName];
                    }
                    _dr["PROCESS_SEQ"] = iProcessSeq;
                    uldtsProce.Tables[0].Rows.Add(_dr);
                    iCount = iCount - 1;
                    iProcessSeq++;
                }
            }

            Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
            for (int i = 0; i < ultraGridProCes.Rows.Count; i++)
            {
                row = ultraGridProCes.Rows[i];
                if (!string.IsNullOrEmpty(row.Cells["MSC"].Value.ToString()))
                {
                    row.Cells["UCCHOOSE"].Value = true;
                }
                if (row.Cells["VALIDFLAG"].Value.ToString().Equals("无效"))
                {
                    row.Cells["UCCHOOSE"].Row.Activation = Activation.ActivateOnly;
                    row.CellAppearance.BackColor = Color.Red;
                }
            }
        }

        //勾选冶金规范码触发的事件
        private void ultraGridBack_CellChange(object sender, CellEventArgs e)
        {
            this.ultraGridBack.UpdateData();

            if (e.Cell.Column.Key.Equals("UCCHOOSE") && Convert.ToBoolean(e.Cell.Value))
            {
                if (iSelectRow != -1)
                    ultraGridBack.Rows[iSelectRow].Cells["UCCHOOSE"].Value = false;
                iSelectRow = e.Cell.Row.Index;
                pline = e.Cell.Row.Cells["MSC_PLINE"].Value.ToString();
                //刷新钢种
                DataTable dtlipe = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSGRADE_ROWS", new Object[] { pscName, pline }, this.ob);
                this.uldtsMscGetDatabBaseGrade(dtlipe);
                comMsc_Process();
                //加载全程工序点路径
                loadStation(pscName, pline);
                this.doQueryCoupLing();
            }
            else
            {
                iSelectRow = -1;
                //加载全程工序点路径
                loadStation(" ", " ");
                this.uldtsProce.Tables[0].Clear(); //清空大工序点数据。 
                this.uldtsProce.Tables["TableGrade"].Clear();//清空接箍码
                this.uldtsCoupling.Tables["TableCoupling"].Clear(); //清空钢种。 
            }

        }

        private void ultraGridProCes_CellChange(object sender, CellEventArgs e)
        {
            string name = "0";
            //this.ultraGridProCes.UpdateData(); 
            //this.uldtsProce.Tables[1].Clear();
            //foreach (UltraGridRow ugrs in this.ultraGridProCes.Rows)
            //{
            //    if (ugrs.Cells["UCCHOOSE"].Value.ToString().ToLower() == "true") 
            //    {
            //        string proName = ugrs.Cells["PROCESS_CODE"].Value.ToString();
            //        DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_STATION", new Object[] { proName }, this.ob);

            //        foreach (DataRow dr in dt.Rows)
            //        {
            //            DataRow _dr = uldtsProce.Tables[1].NewRow();
            //            foreach (DataColumn dc in uldtsProce.Tables[1].Columns)
            //            {
            //                _dr[dc.ColumnName] = dr[dc.ColumnName];
            //            }
            //            uldtsProce.Tables[1].Rows.Add(_dr);
            //        }
            //    }
            //}

            //if (e.Cell.Column.Key.Equals("UCCHOOSE") && Convert.ToBoolean(e.Cell.Value))
            //{
            //    string proName = e.Cell.Row.Cells["PROCESS_CODE"].Value.ToString();
            //    DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_STATION", new Object[] { proName }, this.ob);

            //    foreach (DataRow dr in dt.Rows)
            //    {
            //        DataRow _dr = uldtsProce.Tables[1].NewRow();
            //        foreach (DataColumn dc in uldtsProce.Tables[1].Columns)
            //        {
            //            _dr[dc.ColumnName] = dr[dc.ColumnName];
            //        }
            //        uldtsProce.Tables[1].Rows.Add(_dr);
            //    }
            //} 
        }

        ///<<sunmary>
        ///接箍码查询
        ///</sunmary>
        public void doQueryCoupLing()
        {
            uldtsCoupling.Clear();
            string msc = this.pscName;
            if (string.IsNullOrEmpty(msc))
            {
                return;
            }
            bool flag = true;
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYJGAndMSC", new Object[] { msc, flag }, this.ob);

            foreach (DataRow dr in dt.Rows)
            {
                DataRow _dr = uldtsCoupling.Tables[0].NewRow();
                foreach (DataColumn dc in uldtsCoupling.Tables[0].Columns)
                {
                    _dr[dc.ColumnName] = dr[dc.ColumnName];
                }
                uldtsCoupling.Tables[0].Rows.Add(_dr);
            }

            Infragistics.Win.UltraWinGrid.UltraGridRow row = null;
            for (int i = 0; i < ultraGridCpling.Rows.Count; i++)
            {
                row = ultraGridCpling.Rows[i];
                if (!row.Cells["VALIDFLAG"].Value.ToString().Equals("有效"))
                {
                    row.Appearance.ForeColor = Color.Red;
                }
                else
                {
                    row.Appearance.ForeColor = Color.Black;
                }
            }
        }
        //接箍按钮
        private void butCoupLing_Click(object sender, EventArgs e)
        {
            int i = QuerybriBack();
            if (i == 0) { MessageUtil.ShowWarning("请选择选择一行冶金规范码数据。"); return; }
            JGCodeManage jgcm = new JGCodeManage(ob, pscName, pscNameDesc, "", "", "", "", "", "", "", "", "", "", "");
            jgcm.ShowDialog();
            doQueryCoupLing();
        }
        //备料按钮
        private void butBarNo_Click(object sender, EventArgs e)
        {
            int i = QuerybriBack();
            if (i == 0) { MessageUtil.ShowWarning("请选择选择一行冶金规范码数据。"); return; }
            BLCodeManageParms blCodeParms = new BLCodeManageParms();
            blCodeParms.Ob = ob;
            blCodeParms.Msc = pscName;
            blCodeParms.Msc_desc = pscNameDesc;
            BLCodeManage blcm = new BLCodeManage(blCodeParms);
            blcm.ShowDialog();
            doQueryCoupLing();
        }
        //工序点按钮
        private void buttonProRsta_Click(object sender, EventArgs e)
        {
            int i = QuerybriBack();
            if (i == 0) { MessageUtil.ShowWarning("请选择选择一行冶金规范码数据。"); return; }
            this.ultraGridProCes.UpdateData();
            frmStationSelect frmstr = new frmStationSelect(this.ultraGridProCes, this.ultraGridBack, this.ob, strOperator);
            frmstr.ShowDialog();
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSCOM_MSC_BACKLOG", new Object[] { pscName }, this.ob);
            uldtsMscGetDataBAClogs(dt);
            if (iSelectRow != -1)
            {
                ultraGridBack.Rows[iSelectRow].Cells["UCCHOOSE"].Value = true;
                //刷新钢种
                DataTable dtlipe = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSGRADE_ROWS", new Object[] { pscName, pline }, this.ob);
                this.uldtsMscGetDatabBaseGrade(dtlipe);
                comMsc_Process();
                //加载全程工序点路径
                loadStation(pscName, pline);
                this.doQueryCoupLing();
            }
            doQuery();
        }
        //钢种按钮
        private void buttonGRAD_Click(object sender, EventArgs e)
        {
            int i = QuerybriBack();
            if (i == 0) { MessageUtil.ShowWarning("请选择一条全程途径数据。"); return; }
            frmInnerMSCRGRD blcm = new frmInnerMSCRGRD();
            blcm.SetOb = this.ob;
            blcm.Msc = this.pscName;
            blcm.Msc_pline = this.pline;
            blcm.NameOrd = strOperator;
            blcm.ShowDialog();
            doQuery();
            //刷新钢种
            DataTable dtlipe = ServerHelper.GetData("com.steering.pss.qcm.CoreFrmProPSCMSC.getLineListQUERYSGRADE_ROWS", new Object[] { pscName, pline }, this.ob);
            this.uldtsMscGetDatabBaseGrade(dtlipe);
        }
    }
}