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

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Data;
using System.Windows.Forms;

namespace Core.StlMes.Client.Qcm
{
    /// <summary>
    /// 初始化基础数据
    /// </summary>
    public class QcmBaseQuery
    {

        /// <summary>
        /// 列绑定下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="column">列名</param>
        /// <param name="column">行</param>
        public static void BindColumn(UltraComboEditor uce, string column, UltraGridBand ugb)
        {
            ugb.Columns[column].EditorComponent = uce;
            ugb.Columns[column].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        }

        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodID">方法名</param>
        /// <param name="showValue">显示值</param>
        /// <param name="hiddenValue">隐藏值</param>
        /// <param name="isNull">是否增加空行</param>
        /// <param name="ob">OB对象</param>
        public static void NitializeDropDownBox(UltraComboEditor uce, string methodID, string showValue, string hiddenValue, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData(methodID, new Object[] { }, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr[i] = "";
                }
                dt.Rows.InsertAt(dr, 0);
            }
            uce.DataSource = dt;
            uce.DisplayMember = showValue;
            uce.ValueMember = hiddenValue;
            ClsBaseInfo.SetComboItemHeight(uce);
        }

        /// <summary>
        /// 初始化下拉框(仅针对初始化产品规范管理界面的最终用户)
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodID">方法名</param>
        /// <param name="showValue">显示值</param>
        /// <param name="hiddenValue">隐藏值</param>
        /// <param name="isNull">是否增加空行</param>
        /// <param name="ob">OB对象</param>
        public static void NitializeDropDownBoxUser(UltraComboEditor uce, string methodID, string showValue, string hiddenValue, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData(methodID, new Object[] { }, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr1 = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr1[i] = " ";
                }
                dt.Rows.InsertAt(dr1, 0);
            }
            uce.DataSource = dt;
            uce.DisplayMember = showValue;
            uce.ValueMember = hiddenValue;
            ClsBaseInfo.SetComboItemHeight(uce);
        }


        /// <summary>
        /// 初始化下拉框
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="methodID">方法名</param>
        /// <param name="showValue">显示值</param>
        /// <param name="hiddenValue">隐藏值</param>
        /// <param name="isNull">是否增加空行</param>
        /// <param name="ob">OB对象</param>
        public static void NitializeDropDownBox(LabelComboBox cmb, string methodID, string showValue, string hiddenValue, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData(methodID, new Object[] { }, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr[i] = "";
                }
                dt.Rows.InsertAt(dr, 0);
            }
            cmb.ComboBox.DataSource = dt;
            cmb.ComboBox.DisplayMember = showValue;
            cmb.ComboBox.ValueMember = hiddenValue;
        }

        /// <summary>
        /// 初始化上限符号
        /// </summary>
        /// <param name="uce">下拉框</param>
        public static void NitializeSignMax(UltraComboEditor uce)
        {
            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);
            uce.DataSource = dt;
            uce.DisplayMember = "STDMAX_SIGN";
        }

        /// <summary>
        /// 初始化下限符号
        /// </summary>
        /// <param name="uce">下拉框</param>
        public static void NitializeSignMin(UltraComboEditor uce)
        {
            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);
            uce.DataSource = dt;
            uce.DisplayMember = "STDMIN_SIGN";
        }

        /// <summary>
        /// 标准类型
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardType(UltraComboEditor uce, bool isNull, OpeBase ob)
        {
            DataTable dt = new DataTable();
            DataColumn[] dc = new DataColumn[] { new DataColumn("NAME"), new DataColumn("CODE") };
            dt.Columns.AddRange(dc);
            dt.Rows.Add(new object[] { "订货标准", "G" });
            dt.Rows.Add(new object[] { "协议标准", "X" });
            dt.Rows.Add(new object[] { "Alpha", "K" });
            dt.Rows.Add(new object[] { "内控", "N" });
            dt.Rows.Add(new object[] { "试验标准", "S" });
            dt.Rows.Add(new object[] { "成分偏差标准", "P" });

            if (isNull && dt != null && dt.Rows.Count > 0)
            {
                DataRow dr = dt.NewRow();
                dr[0] = "";
                dr[1] = "";
                dt.Rows.InsertAt(dr, 0);
            }

            uce.DataSource = dt;
            uce.DisplayMember = "NAME";
            uce.ValueMember = "CODE";
            ClsBaseInfo.SetComboItemHeight(uce);
        }

        /// <summary>
        /// 标准协会
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeSociety(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.bandCmbMaxStdXh", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        /// 管理部门
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeDepartment(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.comm.data.ComBaseInfo.getDepartment", "DEPARTNAME", "DEPARTID", isNull, ob);
        }

        /// <summary>
        /// 管理科室
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeSection(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.comm.data.ComBaseInfo.getSection", "DEPARTNAME", "DEPARTID", isNull, ob);
        }

        /// <summary>
        /// 品名
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeProducName(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getProducName", "PRODUCNAME", "PRODUCCODE", isNull, ob);
        }

        /// <summary>
        /// 标准类别
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStdStyle(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getStdStyle", "STD_STYLE_DESC", "STD_STYLE", isNull, ob);
        }

        /// <summary>
        /// 钢级牌号
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeSteel(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getSteel", "STEELNAME", "STEELCODE", isNull, ob);
        }

        /// <summary>
        /// 客户
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeCustomer(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBoxUser(uce, "com.steering.pss.qcm.ComBaseQuery.getCustomer", "CUSTOMER_NM", "CUSTOMER_NO", isNull, ob);
        }

        /// <summary>
        /// 冶金规范码
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeMSC(UltraComboEditor uce, Boolean isNull, OpeBase ob, string msc)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getMsc", new Object[] { msc }, ob);
            if (dt != null && dt.Rows.Count > 0 && isNull)
            {
                DataRow dr = dt.NewRow();
                Object[] obj = new Object[] { "0000", "/" };
                dr.ItemArray = obj;
                dt.Rows.InsertAt(dr, 0);

                DataRow dr1 = dt.NewRow();
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dr1[i] = " ";
                }
                dt.Rows.InsertAt(dr1, 0);
            }
            uce.DataSource = dt;
            uce.DisplayMember = "MSC";
            uce.ValueMember = "MSC";
            ClsBaseInfo.SetComboItemHeight(uce);
        }

        /// <summary>
        /// 国家标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardG(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdG", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        /// 国家标准和协议
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardGX(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdGX", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        /// 国家标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardG(LabelComboBox cmb, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(cmb, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdG", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        /// 内控标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeInnerStandard(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdN", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        /// 内控标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeInnerStandard(LabelComboBox cmb, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(cmb, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdN", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///Alpha标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeAlphaStandard(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdK", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///Alpha标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeAlphaStandard(LabelComboBox cmb, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(cmb, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdK", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///试验标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardSS(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdSS", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///试验标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeStandardSS(LabelComboBox cmb, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(cmb, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdSS", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///其它标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeOtherStandard(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseStdS", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///工序
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeProcess(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseProcessAll", "PROCESS_DESC", "PROCESS_CODE", isNull, ob);
        }

        /// <summary>
        ///钢种
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeGrade(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseGrade", "GRADENAME", "GRADECODE", isNull, ob);
        }

        /// <summary>
        ///成分偏差
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeChemBias(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getComBaseChemBias", "STD_NAME", "STD_CODE", isNull, ob);
        }

        /// <summary>
        ///限制规格
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeLimitSpecifications(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4003", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///化学元素
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeChemicalElement(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getCombaseChem", "CHEM_NAME", "CHEM_CODE", isNull, ob);
        }

        /// <summary>
        ///公差项
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeTolerance(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4040", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///精度等级
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializePrecision(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4041", "BASENAME", "BASECODE", isNull, ob);
        }


        /// <summary>
        ///公差约束项
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeToleranceRestrain(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4003", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///探伤位置
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeDetectionPosition(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4020", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///探伤标准
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeDetectionStandard(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4021", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///探伤级别
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeDetectionLV(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4022", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///探伤检验项
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeDetectionPhy(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getComBasePhyD", "PHY_NAME", "PHY_CODE", isNull, ob);
        }

        /// <summary>
        ///刻槽位置
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeGroovePosition(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4023", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///刻槽方向
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeGrooveDirection(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4024", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///结箍
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeJG(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getComMSCJG", "SPEC_JG_DESC", "SPEC_JG", isNull, ob);
        }

        /// <summary>
        ///标准附加项
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeBaseAdd(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getBaseStdAdd", "BASENAME", "BASECODE", isNull, ob);
        }

        /// <summary>
        ///材质大类
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeBasePhyB(LabelComboBox cmb, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(cmb, "com.steering.pss.qcm.ComBaseQuery.geComBasePhyRStd", "PHY_TYPE", "PHY_CODE", isNull, ob);
        }

        /// <summary>
        /// 附加要求项目
        /// </summary>
        /// <param name="uce">下拉框</param>
        /// <param name="isNull">空行</param>
        /// <param name="ob"></param>
        public static void NitializeAskIime(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            NitializeDropDownBox(uce, "com.steering.pss.qcm.ComBaseQuery.getAskItem", "ASK_ITEM_DESC", "ASK_ITEM_NO", isNull, ob);
        }

        /// <summary>
        /// 加载接箍标准类别
        /// </summary>
        /// <param name="uce"></param>
        public static void NitializeJgStdStyle(UltraComboEditor uce, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ClsBaseInfo.GetComBaseInfo("4054", ob);
            if (isNull)
            {
                dt.Rows.Add(dt.NewRow());
            }
            uce.DataSource = dt;
            uce.ValueMember = "BASECODE";
            uce.DisplayMember = "BASENAME";
            ClsBaseInfo.SetComboItemHeight(uce);
        }

        /// <summary>
        /// 加载产品大类
        /// </summary>
        public static void NitializeProductBigType(ComboBox cmb, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ClsBaseInfo.GetComBaseInfo("4049", ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.ValueMember = "BASECODE";
            cmb.DisplayMember = "BASENAME";
        }

        /// <summary>
        /// 加载产品大类
        /// </summary>
        public static void NitializeProductBigType(UltraComboEditor cmb, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ClsBaseInfo.GetComBaseInfo("4049", ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.ValueMember = "BASECODE";
            cmb.DisplayMember = "BASENAME";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 获取产能井
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="processCode">工序代码</param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializeComBaseWell(UltraComboEditor cmb, string processCode, Boolean isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getComBaseWell",
                new object[] { processCode }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "WELL_NAME";
            cmb.ValueMember = "WELL_CODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 加载规格
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="specType">规格类型</param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializeSpec(UltraComboEditor cmb, string specType, bool isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getSpecByType",
                new object[] { specType }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "SPEC_NAME";
            cmb.ValueMember = "SPEC_CODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 初始化产线
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="msc"></param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializMscPline(UltraComboEditor cmb, string msc, bool isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getMscPlineByMsc",
                new object[] { msc }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "MSC_PLINE";
            cmb.ValueMember = "MSC_PLINE";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 初始化用途码
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="stdCode"></param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializStdAlpha(UltraComboEditor cmb, string stdCode, bool isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.BLCodeManage.GetBLStd_Alpha",
                new object[] { stdCode }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "STD_NAME";
            cmb.ValueMember = "STD_CODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 初始化产品
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializePsc(UltraComboEditor cmb, bool isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getPsc2",
                new object[] { }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "PSC_DESC";
            cmb.ValueMember = "PSC";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }

        /// <summary>
        /// 初始化产品
        /// </summary>
        /// <param name="cmb"></param>
        /// <param name="isNull"></param>
        /// <param name="ob"></param>
        public static void NitializePlineByProcess(string process, UltraComboEditor cmb, bool isNull, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.getPlineByProcess",
                new object[] { process }, ob);
            if (isNull)
            {
                dt.Rows.InsertAt(dt.NewRow(), 0);
            }
            cmb.DataSource = dt;
            cmb.DisplayMember = "PLINE_NAME";
            cmb.ValueMember = "PLINE_CODE";
            ClsBaseInfo.SetComboItemHeight(cmb);
        }
    }
}