MES_Client/TGMES/Core.StlMes.Client.SalePrice/BaseForm/FrmPriceCatolog.cs

using com.steering.pss.sale.price.entity;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.SalePrice.BaseForm
{
    public partial class FrmPriceCatolog : FrmBase
    {
        int MaxIniX = 50;///合并表头时初始化的最大起始坐标X轴
        int MaxSpyX = 20;///合并表头时初始化的最大跨越段数
        int XZhouCount;
        int YZhouCount;
        int Y1Count;
        int Y2Count;
        int BaseFieldCount = 3;
        DataTable dt = new DataTable();
       
        DataTable dt_Cat = new DataTable();
        public FrmPriceCatolog()
        {
            InitializeComponent();
        }

        private void FrmPriceCatolog_Load(object sender, EventArgs e)
        {
            InitForm();
            InitComBoBox1();
            InitComBoBox_DropDownList();

            ucFrame.Rows[0].Selected = true;
        }

        private void InitComBoBox_DropDownList()
        {
            LoadFactorInfo("品种", this.ultraComboEditor1);
            LoadFactorInfo("钢级", this.ultraComboEditor2);
            LoadFactorInfo("标准", this.ultraComboEditor3);
            LoadFactorInfo("标准类别", this.ultraComboEditor4);
                           
            LoadFactorInfo("扣型", this.ultraComboEditor5);



        }

        private void LoadFactorInfo(string p, UltraComboEditor ultraComboEditor)
        {
            string FactorName = p;

            DataTable FactorInfo = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.GetFactorInfo", new object[] { FactorName }, this.ob);

            if (FactorInfo != null && FactorInfo.Rows.Count > 0 && FactorInfo.Rows[0]["Table_Name"].ToString() != "")
            {
                UltraComboEditor uce1 = new UltraComboEditor();
                string sql_getFactorBind = "";
                string TableName = FactorInfo.Rows[0]["TABLE_NAME"].ToString();
                string DataValue = FactorInfo.Rows[0]["COLUMN_KEY"].ToString();
                string DataDesc = FactorInfo.Rows[0]["COLUMN_NAME"].ToString();
                string sql_getSQL = FactorInfo.Rows[0]["VAL_SQL"].ToString();

                DataTable dtFactor = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.FactorBind", new object[] { TableName, DataValue, DataDesc, sql_getSQL }, this.ob);
                if (dtFactor != null && dtFactor.Rows.Count > 0)
                {

                    Object[] obj = new Object[] { "", "" };
                    DataRow dr = dtFactor.NewRow();
                    dr.ItemArray = obj;
                    dtFactor.Rows.InsertAt(dr, 0);
                    ultraComboEditor.DataSource = dtFactor;
                    ultraComboEditor.DataMember = "";
                    ultraComboEditor.ValueMember = DataValue;
                    ultraComboEditor.DisplayMember = DataDesc;
                    ClsBaseInfo.SetComboItemHeight(ultraComboEditor);
                }

               
            }
        }
        private void InitForm()
        {
            string isValid = "1";
            List<SlmPriceBaseframeSetEntity> list = EntityHelper.GetData<SlmPriceBaseframeSetEntity>(
           "com.steering.pss.sale.price.server.CorePriceBaseFrame.query", new object[] { isValid }, this.ob);
            slmPriceBaseframeSetEntityBindingSource.DataSource = list;

            

        }
        private void InitComBoBox1()
        {
            UltraComboEditor uce1 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce1, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X1FACTORID"].EditorComponent = uce1;
            ucFrame.DisplayLayout.Bands[0].Columns["X1FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce1);
            uce1.Visible = false;

            UltraComboEditor uce2 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce2, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X2FACTORID"].EditorComponent = uce2;
            ucFrame.DisplayLayout.Bands[0].Columns["X2FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce2);
            uce2.Visible = false;

            UltraComboEditor uce3 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce3, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X3FACTORID"].EditorComponent = uce3;
            ucFrame.DisplayLayout.Bands[0].Columns["X3FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce3);
            uce3.Visible = false;

            UltraComboEditor uce4 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce4, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X4FACTORID"].EditorComponent = uce4;
            ucFrame.DisplayLayout.Bands[0].Columns["X4FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce4);
            uce4.Visible = false;

            UltraComboEditor uce5 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce5, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X5FACTORID"].EditorComponent = uce5;
            ucFrame.DisplayLayout.Bands[0].Columns["X5FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce5);
            uce5.Visible = false;

            UltraComboEditor uce6 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce6, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X6FACTORID"].EditorComponent = uce6;
            ucFrame.DisplayLayout.Bands[0].Columns["X6FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce6);
            uce6.Visible = false;

            UltraComboEditor uce7 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce7, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X7FACTORID"].EditorComponent = uce7;
            ucFrame.DisplayLayout.Bands[0].Columns["X7FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce7);
            uce7.Visible = false;

            UltraComboEditor uce8 = new UltraComboEditor();
            SalePriceClass.InitComboEditorWithParm(uce8, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryFacName", "FACTOR_ID", "FACTOR_NAME", this.ob, true, null);
            ucFrame.DisplayLayout.Bands[0].Columns["X8FACTORID"].EditorComponent = uce8;
            ucFrame.DisplayLayout.Bands[0].Columns["X8FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce8);
            uce8.Visible = false;

            //UltraComboEditor uce9 = new UltraComboEditor();
            //SalePriceClass.InitComboEditorWithParm(uce9, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryRangeName", "CLASS_D_ID", "CLASS_D_NAME", this.ob, true, null);
            //ultraCombo1.DisplayLayout.Bands[0].Columns["Y1FACTORID"].EditorComponent = uce9;
            //ultraCombo1.DisplayLayout.Bands[0].Columns["Y1FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //this.Controls.Add(uce9);
            //uce9.Visible = false;

            //UltraComboEditor uce10 = new UltraComboEditor();
            //SalePriceClass.InitComboEditorWithParm(uce10, "com.steering.pss.sale.price.server.CorePriceBaseFrame.queryRangeName", "CLASS_D_ID", "CLASS_D_NAME", this.ob, true, null);
            //ultraCombo1.DisplayLayout.Bands[0].Columns["Y2FACTORID"].EditorComponent = uce10;
            //ultraCombo1.DisplayLayout.Bands[0].Columns["Y2FACTORID"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            //this.Controls.Add(uce10);
            //uce10.Visible = false;
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                     string isValid = "1";
                     string price_ver_id = "";
                QueryDataCat(price_ver_id, isValid);
                    break;

                case "Save":
                    //SaveFormData();
                    break;

                case "Delete":
                    //DeleteOrResume(true);
                    break;

                case "Resume":
                    //DeleteOrResume(false);
                    break;

                case "Close":
                    this.Close();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ugFramePrice_Cat, "价格导出");
                    break;
            }
        }
        //private void QueryData()
        //{
          

        //    DataTable dt_query = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.query", null, this.ob);
        //    dt.Rows.Clear();
        //    ugFramePrice.DataSource = dt;
        //    ugFramePrice.DataBind();

        //    for (int i = 0; i < dt_query.Rows.Count; i++)
        //    {
        //        DataRow dr = dt.NewRow();

        //        dt.Rows.Add(dr);

        //        dt.Rows[i]["validflag"] = dt_query.Rows[i]["validflag"].ToString();
        //        dt.Rows[i]["create_name"] = dt_query.Rows[i]["create_name"].ToString();
        //        dt.Rows[i]["create_time"] = dt_query.Rows[i]["create_time"].ToString();



        //        if (dt.Columns.Contains("因素一") == true)
        //        {
        //            dt.Rows[i]["因素一"] = dt_query.Rows[i]["X_1_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素二") == true)
        //        {
        //            dt.Rows[i]["因素二"] = dt_query.Rows[i]["X_2_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素三") == true)
        //        {
        //            dt.Rows[i]["因素三"] = dt_query.Rows[i]["X_3_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素四") == true)
        //        {
        //            dt.Rows[i]["因素四"] = dt_query.Rows[i]["X_4_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素五") == true)
        //        {
        //            dt.Rows[i]["因素五"] = dt_query.Rows[i]["X_5_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素六") == true)
        //        {
        //            dt.Rows[i]["因素六"] = dt_query.Rows[i]["X_6_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素七") == true)
        //        {
        //            dt.Rows[i]["因素七"] = dt_query.Rows[i]["X_7_ID_VALUE"].ToString();
        //        }
        //        if (dt.Columns.Contains("因素八") == true)
        //        {
        //            dt.Rows[i]["因素八"] = dt_query.Rows[i]["X_8_ID_VALUE"].ToString();
        //        }
        //        for (int n = 0; n < dt_query.Columns.Count; n++)
        //        {
        //            if (dt.Columns.Contains(dt_query.Columns[n].ColumnName.Replace("'", "")))
        //            {
        //                string ColName = dt_query.Columns[n].ColumnName;
        //                dt.Rows[i][ColName.Replace("'", "")] = dt_query.Rows[i][ColName].ToString();
        //            }
        //        }







        //    }


        //    ugFramePrice.DataSource = dt;
        //}
        //private void bindBaseField(DataTable dt)
        //{
        //    this.ugFramePrice.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;



        //    //    dt.Columns.Add("CHK", typeof(Boolean));
        //    dt.Columns.Add("PRICE_VER_ID", typeof(string));
        //    dt.Columns.Add("PRICE_VER_M", typeof(string));
        //    dt.Columns.Add("PRICE_VER_SQE", typeof(string));
        //    dt.Columns.Add("FRAME_ID", typeof(string));





        //    ugFramePrice.DataSource = dt;
        //    ugFramePrice.DataBind();



        //    SalePriceClass.ModifyColumnName("PRICE_VER_ID", "基价版本ID", this.ugFramePrice, true);
        //    SalePriceClass.ModifyColumnName("PRICE_VER_M", "基价版本描述", this.ugFramePrice, true);
        //    //      ModifyColumnName("PRICE_VER_SQE", "基价序号");
        //    SalePriceClass.ModifyColumnName("FRAME_ID", "基价框架", this.ugFramePrice, false);

        //    // dt.Columns.Add("PRICE_VER_ID", typeof(string));

        //    //ugFramePrice.DataSource = dt;
        //    //ugFramePrice.DataBind();
        //}
        ///// <summary>
        ///// 绑定X轴字段
        ///// </summary>
        ///// <param name="dt"></param>
        //private void LoadXField(DataTable dt)
        //{
        //    string facId = "";
        //    string facName = "";
        //    string isValid = "1";
        //    int m = 0;

        //    for (int i = 1; i < ucFrame.ActiveRow.Cells.Count - 7; i++)
        //    {
        //        if (ucFrame.ActiveRow.Cells[i].Value.ToString() != null && ucFrame.ActiveRow.Cells[i].Value.ToString() != "")
        //        {
        //            // dt.Columns.Add(ultraCombo1.ActiveRow.Cells[i].Text.ToString(), typeof(string));
        //            dt.Columns.Add(ucFrame.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString(), typeof(string));
        //            m += 1;
        //        }

        //    }
        //    ugFramePrice.DataSource = dt;
        //    ugFramePrice.DataBind();

        //    for (int i = 1; i < ucFrame.ActiveRow.Cells.Count - 7; i++)
        //    {
        //        if (ucFrame.ActiveRow.Cells[i].Value.ToString() != null && ucFrame.ActiveRow.Cells[i].Value.ToString() != "")
        //        {
        //            SalePriceClass.ModifyColumnName(ucFrame.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString(), ucFrame.ActiveRow.Cells[i].Text.ToString(), this.ugFramePrice, true);
        //        }

        //    }
        //    XZhouCount = m;
        //}
        //private void bindBaseField1(DataTable dt)
        //{
        //    dt.Columns.Add("validflag", typeof(string));
        //    dt.Columns.Add("create_name", typeof(string));
        //    dt.Columns.Add("create_time", typeof(string));
        //    dt.Columns.Add("update_name", typeof(string));
        //    dt.Columns.Add("update_time", typeof(string));

        //    ugFramePrice.DataSource = dt;
        //    ugFramePrice.DataBind();



        //    SalePriceClass.ModifyColumnName("validflag", "有效标志", this.ugFramePrice, true);
        //    SalePriceClass.ModifyColumnName("create_name", "创建人", this.ugFramePrice, true);
        //    SalePriceClass.ModifyColumnName("create_time", "创建时间", this.ugFramePrice, true);
        //    SalePriceClass.ModifyColumnName("update_name", "修改人", this.ugFramePrice, true);
        //    SalePriceClass.ModifyColumnName("update_time", "修改时间", this.ugFramePrice, true);
        //}
        ///// <summary>
        ///// 加载Grid下啦列表 
        ///// </summary>
        //private void LoadFactorInfo()
        //{
        //    for (int i = 0; i < ugFramePrice.DisplayLayout.Bands[0].Columns.Count; i++)
        //    {
        //        string FactorName = ugFramePrice.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString();

        //        DataTable FactorInfo = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.GetFactorInfo", new object[] { FactorName }, this.ob);

        //        if (FactorInfo != null && FactorInfo.Rows.Count > 0 && FactorInfo.Rows[0]["Table_Name"].ToString() != "")
        //        {
        //            UltraComboEditor uce1 = new UltraComboEditor();
        //            string sql_getFactorBind = "";
        //            string TableName = FactorInfo.Rows[0]["TABLE_NAME"].ToString();
        //            string DataValue = FactorInfo.Rows[0]["COLUMN_KEY"].ToString();
        //            string DataDesc = FactorInfo.Rows[0]["COLUMN_NAME"].ToString();
        //            string sql_getSQL = FactorInfo.Rows[0]["VAL_SQL"].ToString();

        //            DataTable dtFactor = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.FactorBind", new object[] { TableName, DataValue, DataDesc, sql_getSQL }, this.ob);
        //            if (dtFactor != null && dtFactor.Rows.Count > 0)
        //            {

        //                Object[] obj = new Object[] { "", "" };
        //                DataRow dr = dtFactor.NewRow();
        //                dr.ItemArray = obj;
        //                dtFactor.Rows.InsertAt(dr, 0);
        //                uce1.DataSource = dtFactor;
        //                uce1.DataMember = "";
        //                uce1.ValueMember = DataValue;
        //                uce1.DisplayMember = DataDesc;
        //                ClsBaseInfo.SetComboItemHeight(uce1);
        //            }

        //            ugFramePrice.DisplayLayout.Bands[0].Columns[i].EditorComponent = uce1;
        //            ugFramePrice.DisplayLayout.Bands[0].Columns[i].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        //            this.Controls.Add(uce1);
        //            uce1.Visible = false;
        //        }


        //    }
        //}
        private void LoadFactorInfo_Cat()
        {
            for (int i = 0; i < ugFramePrice_Cat.DisplayLayout.Bands[0].Columns.Count; i++)
            {
                string FactorName = ugFramePrice_Cat.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString();

                DataTable FactorInfo = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.GetFactorInfo", new object[] { FactorName }, this.ob);

                if (FactorInfo != null && FactorInfo.Rows.Count > 0 && FactorInfo.Rows[0]["Table_Name"].ToString() != "")
                {
                    UltraComboEditor uce1 = new UltraComboEditor();
                    string sql_getFactorBind = "";
                    string TableName = FactorInfo.Rows[0]["TABLE_NAME"].ToString();
                    string DataValue = FactorInfo.Rows[0]["COLUMN_KEY"].ToString();
                    string DataDesc = FactorInfo.Rows[0]["COLUMN_NAME"].ToString();
                    string sql_getSQL = FactorInfo.Rows[0]["VAL_SQL"].ToString();

                    DataTable dtFactor = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceFramePrice.FactorBind", new object[] { TableName, DataValue, DataDesc, sql_getSQL }, this.ob);
                    if (dtFactor != null && dtFactor.Rows.Count > 0)
                    {

                        Object[] obj = new Object[] { "", "" };
                        DataRow dr = dtFactor.NewRow();
                        dr.ItemArray = obj;
                        dtFactor.Rows.InsertAt(dr, 0);
                        uce1.DataSource = dtFactor;
                        uce1.DataMember = "";
                        uce1.ValueMember = DataValue;
                        uce1.DisplayMember = DataDesc;
                        ClsBaseInfo.SetComboItemHeight(uce1);
                    }

                    ugFramePrice_Cat.DisplayLayout.Bands[0].Columns[i].EditorComponent = uce1;
                    ugFramePrice_Cat.DisplayLayout.Bands[0].Columns[i].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
                    this.Controls.Add(uce1);
                    uce1.Visible = false;
                }


            }
        }


        private void ucFrame_ValueChanged(object sender, EventArgs e)
        {
            dt.Columns.Clear();
            dt.Rows.Clear();

            //bindBaseField(dt); ///绑定基础字段
            //LoadXField(dt);     ///加载 X轴因素的字段
            ////  LoadYfield(dt);      ///加载 Y轴因素的字段
            //bindBaseField1(dt);
            //LoadFactorInfo();     ///获取X轴下拉列表
                           ///
            ///
            bindBaseField_Cat(dt_Cat); ///绑定基础字段
            LoadXField_Cat(dt_Cat);     ///加载 X轴因素的字段
            //  LoadYfield(dt);      ///加载 Y轴因素的字段
            bindBaseField1_Cat(dt_Cat);
            LoadFactorInfo_Cat();   


        }

        private void bindBaseField1_Cat(DataTable dt_Cat)
        {
            dt_Cat.Columns.Add("waijing_begin", typeof(string));
            dt_Cat.Columns.Add("waijing_end", typeof(string));
            dt_Cat.Columns.Add("bihou_begin", typeof(string));
            dt_Cat.Columns.Add("bihou_end", typeof(string));
            dt_Cat.Columns.Add("specificion", typeof(string));

            dt_Cat.Columns.Add("price_unit", typeof(string));
            dt_Cat.Columns.Add("price_num", typeof(string));

            dt_Cat.Columns.Add("validflag", typeof(string));
            dt_Cat.Columns.Add("create_name", typeof(string));
            dt_Cat.Columns.Add("create_time", typeof(string));
            dt_Cat.Columns.Add("update_name", typeof(string));
            dt_Cat.Columns.Add("update_time", typeof(string));

            ugFramePrice_Cat.DataSource = dt_Cat;
            ugFramePrice_Cat.DataBind();

            SalePriceClass.ModifyColumnName("waijing_begin", "外径起", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("waijing_end", "外径止", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("bihou_begin", "壁厚起", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("bihou_end", "壁厚止", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("specificion", "规格", this.ugFramePrice_Cat, true);

            SalePriceClass.ModifyColumnName("price_unit", "单位", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("price_num", "价格", this.ugFramePrice_Cat, true);

            SalePriceClass.ModifyColumnName("validflag", "有效标志", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("create_name", "创建人", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("create_time", "创建时间", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("update_name", "修改人", this.ugFramePrice_Cat, true);
            SalePriceClass.ModifyColumnName("update_time", "修改时间", this.ugFramePrice_Cat, true);
        }

        private void LoadXField_Cat(DataTable dt_Cat)
        {
            string facId = "";
            string facName = "";
            string isValid = "1";
            int m = 0;

            for (int i = 1; i < ucFrame.ActiveRow.Cells.Count - 7; i++)
            {
                if (ucFrame.ActiveRow.Cells[i].Value.ToString() != null && ucFrame.ActiveRow.Cells[i].Value.ToString() != "")
                {
                    // dt.Columns.Add(ultraCombo1.ActiveRow.Cells[i].Text.ToString(), typeof(string));
                    dt_Cat.Columns.Add(ucFrame.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString(), typeof(string));
                    m += 1;
                }

            }
            ugFramePrice_Cat.DataSource = dt_Cat;
            ugFramePrice_Cat.DataBind();

            for (int i = 1; i < ucFrame.ActiveRow.Cells.Count - 7; i++)
            {
                if (ucFrame.ActiveRow.Cells[i].Value.ToString() != null && ucFrame.ActiveRow.Cells[i].Value.ToString() != "")
                {
                    SalePriceClass.ModifyColumnName(ucFrame.DisplayLayout.Bands[0].Columns[i].Header.Caption.ToString(), ucFrame.ActiveRow.Cells[i].Text.ToString(), this.ugFramePrice_Cat, true);

                }

            }
            XZhouCount = m;
        }

        private void bindBaseField_Cat(DataTable dt_Cat)
        {
           // this.ugFramePrice.DisplayLayout.Bands[0].RowLayoutStyle = RowLayoutStyle.GroupLayout;

            // dt_Cat.Columns.Add("PRICE_VER_ID", typeof(string));
            //dt_Cat.Columns.Add("PRICE_VER_M", typeof(string));
            //dt_Cat.Columns.Add("PRICE_VER_SQE", typeof(string));
            //dt_Cat.Columns.Add("FRAME_ID", typeof(string));





            ugFramePrice_Cat.DataSource = dt_Cat;
            ugFramePrice_Cat.DataBind();



            //SalePriceClass.ModifyColumnName("PRICE_VER_ID", "基价版本ID", this.ugFramePrice, true);
            //SalePriceClass.ModifyColumnName("PRICE_VER_M", "基价版本描述", this.ugFramePrice, true);
            ////      ModifyColumnName("PRICE_VER_SQE", "基价序号");
            //SalePriceClass.ModifyColumnName("FRAME_ID", "基价框架", this.ugFramePrice, false);
        }

        //private void ugFramePrice_AfterRowActivate(object sender, EventArgs e)
        //{
        //    if (ugFramePrice.ActiveRow.Cells["price_ver_id"].Value.ToString() != "")
        //    {
        //        string price_ver_id = ugFramePrice.ActiveRow.Cells["price_ver_id"].Value.ToString();
        //        string isValid = "1";
        //        QueryDataCat(price_ver_id, isValid);
        //    }
        //}

        private void QueryDataCat(string price_ver_id_aa, string isValid)
        {
            string X_1_ID_VALUE ="";
            string X_2_ID_VALUE ="";
            string X_3_ID_VALUE ="";
            string X_4_ID_VALUE ="";
            string X_5_ID_VALUE = "";

            X_1_ID_VALUE = ultraComboEditor1.Value.ToString2();
            X_2_ID_VALUE = ultraComboEditor2.Value.ToString2();
            X_3_ID_VALUE = ultraComboEditor3.Value.ToString2();
            X_4_ID_VALUE = ultraComboEditor4.Value.ToString2();
            X_5_ID_VALUE = ultraComboEditor5.Value.ToString2();
           


            DataTable dt_query = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceCatolog.queryBaseCatolog", new object[] { price_ver_id_aa, isValid }, this.ob);
           dt_Cat.Rows.Clear();
            ugFramePrice_Cat.DataSource = dt_Cat;
            ugFramePrice_Cat.DataBind();
            
            for (int i = 0; i < dt_query.Rows.Count; i++)
            {
                DataRow dr = dt_Cat.NewRow();

                dt_Cat.Rows.Add(dr);

                //dt_Cat.Rows[i]["validflag"] = dt_query.Rows[i]["validflag"].ToString();
                //dt_Cat.Rows[i]["create_name"] = dt_query.Rows[i]["create_name"].ToString();
                //dt_Cat.Rows[i]["create_time"] = dt_query.Rows[i]["create_time"].ToString();

                dt_Cat.Rows[i]["因素一"] = dt_query.Rows[i]["x_1_id_value"].ToString();
                dt_Cat.Rows[i]["因素二"] = dt_query.Rows[i]["x_2_id_value"].ToString();
                dt_Cat.Rows[i]["因素三"] = dt_query.Rows[i]["x_3_id_value"].ToString();
                dt_Cat.Rows[i]["因素四"] = dt_query.Rows[i]["x_4_id_value"].ToString();
                dt_Cat.Rows[i]["因素五"] = dt_query.Rows[i]["x_5_id_value"].ToString();

                dt_Cat.Rows[i]["waijing_begin"] = dt_query.Rows[i]["waijing_begin"].ToString();
                dt_Cat.Rows[i]["waijing_end"] = dt_query.Rows[i]["waijing_end"].ToString();
                dt_Cat.Rows[i]["bihou_begin"] = dt_query.Rows[i]["bihou_begin"].ToString();
                dt_Cat.Rows[i]["bihou_end"] = dt_query.Rows[i]["bihou_end"].ToString();
                dt_Cat.Rows[i]["specificion"] = dt_query.Rows[i]["specificion"].ToString();
                dt_Cat.Rows[i]["price_unit"] = dt_query.Rows[i]["price_unit"].ToString();
                dt_Cat.Rows[i]["price_num"] = dt_query.Rows[i]["price_num"].ToString();
                
              
            }
            ugFramePrice_Cat.DataSource = dt_Cat;

            int n = dt_Cat.Rows.Count;
            for (int i = 0; i < dt_query.Rows.Count; i++)
            {
                string price_head_id = dt_query.Rows[i]["price_head_id"].ToString();
                DataTable dt_Exp = ServerHelper.GetData("com.steering.pss.sale.price.server.CorePriceCatolog.queryBaseCatologExp", new object[] { price_head_id, isValid }, this.ob);




                for (int m = 0; m < dt_Exp.Rows.Count; m++)
                {
                DataRow dr = dt_Cat.NewRow();

                dt_Cat.Rows.Add(dr);

                //dt_Cat.Rows[i]["validflag"] = dt_query.Rows[i]["validflag"].ToString();
                //dt_Cat.Rows[i]["create_name"] = dt_query.Rows[i]["create_name"].ToString();
                //dt_Cat.Rows[i]["create_time"] = dt_query.Rows[i]["create_time"].ToString();

                dr["因素一"] = dt_query.Rows[i]["x_1_id_value"].ToString();

               
                dr["因素二"] = dt_query.Rows[i]["x_2_id_value"].ToString();
                dr["因素三"] = dt_query.Rows[i]["x_3_id_value"].ToString();
                dr["因素四"] = dt_query.Rows[i]["x_4_id_value"].ToString();
                dr["因素五"] = dt_query.Rows[i]["x_5_id_value"].ToString();

               dr["waijing_begin"] = dt_query.Rows[i]["waijing_begin"].ToString();
                dr["waijing_end"] = dt_query.Rows[i]["waijing_end"].ToString();
               dr["bihou_begin"] = dt_query.Rows[i]["bihou_begin"].ToString();
               dr["bihou_end"] = dt_query.Rows[i]["bihou_end"].ToString();
               dr["specificion"] = dt_query.Rows[i]["specificion"].ToString();
               dr["price_unit"] = dt_query.Rows[i]["price_unit"].ToString();
               dr["price_num"] = dt_query.Rows[i]["price_num"].ToString();

               //dr["因素一"] = dt_query.Rows[i]["x_1_id_value"].ToString();
               // dr["因素二"] = dt_query.Rows[i]["x_2_id_value"].ToString();
               // dr["因素三"] = dt_query.Rows[i]["x_3_id_value"].ToString();
               // dr["因素四"] = dt_query.Rows[i]["x_4_id_value"].ToString();
               // dr["因素五"] = dt_query.Rows[i]["x_5_id_value"].ToString();

               // dr["waijing_begin"] = dt_query.Rows[i]["waijing_begin"].ToString();
               // dr["waijing_end"] = dt_query.Rows[i]["waijing_end"].ToString();
               // dr["bihou_begin"] = dt_query.Rows[i]["bihou_begin"].ToString();
               // dr["bihou_end"] = dt_query.Rows[i]["bihou_end"].ToString();
               // dr["specificion"] = dt_query.Rows[i]["specificion"].ToString();
               // dr["price_unit"] = dt_query.Rows[i]["price_unit"].ToString();
               // dr["price_num"] = dt_query.Rows[i]["price_num"].ToString();


                if (dt_Exp.Rows[m]["FACTOR1_ID"] != null && dt_Exp.Rows[m]["FACTOR1_ID"].ToString() != "")
                {
                    dr["因素一"] = dt_Exp.Rows[m]["FACTOR1_ID"].ToString();
                    dr["price_num"] = Convert.ToDecimal(dr["price_num"]) + Convert.ToDecimal(dt_Exp.Rows[m]["FACTOR1_PRICE"]);
                }
                if (dt_Exp.Rows[m]["FACTOR2_ID"] != null && dt_Exp.Rows[m]["FACTOR2_ID"].ToString() != "")
                {
                    dr["因素二"] = dt_Exp.Rows[m]["FACTOR2_ID"].ToString();
                    dr["price_num"] = Convert.ToDecimal(dr["price_num"]) + Convert.ToDecimal(dt_Exp.Rows[m]["FACTOR2_PRICE"]);
                }
                if (dt_Exp.Rows[m]["FACTOR3_ID"] != null && dt_Exp.Rows[m]["FACTOR3_ID"].ToString() != "")
                {
                    dr["因素三"] = dt_Exp.Rows[m]["FACTOR3_ID"].ToString();
                    dr["price_num"] = Convert.ToDecimal(dr["price_num"]) + Convert.ToDecimal(dt_Exp.Rows[m]["FACTOR3_PRICE"]);
                }
                if (dt_Exp.Rows[m]["FACTOR4_ID"] != null && dt_Exp.Rows[m]["FACTOR4_ID"].ToString() != "")
                {
                    dr["因素四"] = dt_Exp.Rows[m]["FACTOR4_ID"].ToString();
                    dr["price_num"] = Convert.ToDecimal(dr["price_num"]) + Convert.ToDecimal(dt_Exp.Rows[m]["FACTOR4_PRICE"]);
                }
                if (dt_Exp.Rows[m]["FACTOR5_ID"] != null && dt_Exp.Rows[m]["FACTOR5_ID"].ToString() != "")
                {
                    dr["因素五"] = dt_Exp.Rows[m]["FACTOR5_ID"].ToString();
                    dr["price_num"] = Convert.ToDecimal(dr["price_num"]) + Convert.ToDecimal(dt_Exp.Rows[m]["FACTOR5_PRICE"]);
                }
                }

               
            }
            DataTable dt_CatNew = dt_Cat.Clone();
            DataRow[] drArr = dt_Cat.Select(" 因素一 LIKE '%'+'" + this.ultraComboEditor1.Value.ToString2() + "'+ '%' and  因素二 LIKE '%'+'" + this.ultraComboEditor2.Value.ToString2() + "'+ '%'  and   因素三 LIKE '%'+'" + this.ultraComboEditor3.Value.ToString2() + "'+ '%' and  因素四 LIKE '%'+'" + this.ultraComboEditor4.Value.ToString2() + "'+ '%'  and  因素五 LIKE '%'+'" + this.ultraComboEditor5.Value.ToString2() + "'+ '%' ");

           
            for (int i = 0; i < drArr.Length; i++)
            {
                dt_CatNew.ImportRow(drArr[i]);

            }
            ugFramePrice_Cat.DataSource = dt_CatNew;

        
        }

        private void ucFrame_ValueChanged_1(object sender, EventArgs e)
        {
            dt.Columns.Clear();
            dt.Rows.Clear();

            //bindBaseField(dt); ///绑定基础字段
            //LoadXField(dt);     ///加载 X轴因素的字段
            ////  LoadYfield(dt);      ///加载 Y轴因素的字段
            //bindBaseField1(dt);
            //LoadFactorInfo();     ///获取X轴下拉列表
            ///
            ///
            bindBaseField_Cat(dt_Cat); ///绑定基础字段
            LoadXField_Cat(dt_Cat);     ///加载 X轴因素的字段
            //  LoadYfield(dt);      ///加载 Y轴因素的字段
            bindBaseField1_Cat(dt_Cat);
            LoadFactorInfo_Cat(); 
        }

        private void ultraComboEditor3_ValueChanged(object sender, EventArgs e)
        {

        }

        private void ugFramePrice_Cat_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            UltraComboEditor uce1 = new UltraComboEditor();

            SalePriceClass.InitComboEditorWithParm(uce1, "com.steering.pss.sale.price.server.CorePriceFactor.queryBaseInfo", "BASECODE", "BASENAME", this.ob, true, new object[] { "1215" });
            ugFramePrice_Cat.DisplayLayout.Bands[0].Columns["price_unit"].EditorComponent = uce1;
            ugFramePrice_Cat.DisplayLayout.Bands[0].Columns["price_unit"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            this.Controls.Add(uce1);
            uce1.Visible = false;
        }
    }
}