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 list = EntityHelper.GetData( "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(); //} ///// ///// 绑定X轴字段 ///// ///// //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); //} ///// ///// 加载Grid下啦列表 ///// //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; } } }