动态配置下拉框内容

画面的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

 

posted @ 2021-03-01 16:46  gitee1412  阅读(130)  评论(0编辑  收藏  举报