动态配置下拉框内容
画面的load事件中加入
this.order_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ORDER_CODE", "代码")); this.order_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ORDER_NAME", "描述"));
自定义方法处理下拉框值
#region 订单类型下拉 private void order_type_QueryPopUp(object sender, CancelEventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("ORDER_CODE", Type.GetType("System.String")); dt.Columns.Add("ORDER_NAME", Type.GetType("System.String")); dt.Rows.Add(new object[] { "", "" }); dt.Rows.Add(new object[] { "A", "热轧" }); dt.Rows.Add(new object[] { "B", "冷轧" }); dt.Rows.Add(new object[] { "C", "硅钢" }); this.order_type.Properties.DataSource = dt; this.order_type.Properties.DisplayMember = "ORDER_NAME"; this.order_type.Properties.ValueMember = "ORDER_CODE"; } #endregion
筛选小代码显示
// 获取按周标志数据 delivy_weekdata = EF.Utility.GetPartitionCodeClassValue("MA1RM", "S117");
自定义方法
#region 按周交货标志多选下拉 private void delivy_week_QueryPopUp(object sender, CancelEventArgs e) { DataTable dt = new DataTable(); dt = delivy_weekdata.Tables[0].Clone(); DataRow[] dr = delivy_weekdata.Tables[0].Select(" CODE IN('A','C','Y')"); dt = dr.CopyToDataTable(); this.delivy_week.Properties.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { string backlogName = dt.Rows[i]["CODE_DESC_1_CONTENT"].ToString().Trim(); string unitCode = dt.Rows[i]["CODE"].ToString().Trim(); string description = unitCode + ":" + backlogName; this.delivy_week.Properties.Items.Add(unitCode, description); } } #endregion
private void FormPMOMMACS01_Load(object sender, EventArgs e) { this.contract_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CONTRACT_CODE", "代码")); this.contract_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("CONTRACT_NAME", "描述")); this.order_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ORDER_CODE", "代码")); this.order_type.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ORDER_NAME", "描述")); this.product_shape.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("PRODUCT_CODE", "代码")); this.product_shape.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("PRODUCT_NAME", "描述")); this.design_status.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("STATUS_CODE", "代码")); this.design_status.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("STATUS_NAME", "描述")); // 获取按周标志数据 delivy_weekdata = EF.Utility.GetPartitionCodeClassValue("MA1RM", "S117"); if (isok == true) { EF.Utility.SetGridColumn(new EF.EFDevGrid[] { efDevGrid1 }, new string[] { "PMOMMACS01_INQ" }, "MA1RM"); } Grid_Style.efDevGrid_sTyle(efDevGrid1, gridView1); gridView1.OptionsView.ShowFooter = true;//显示下方汇总行 this.gridView1.Appearance.FooterPanel.ForeColor = System.Drawing.Color.Red;//汇总字体为红色 this.gridView1.Appearance.FooterPanel.Options.UseForeColor = true; this.gridView1.Columns["ORDER_WT"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和 this.gridView1.Columns["LACK_WT"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;//求和 } #endregion