/// <summary> /// Cai dat luoi /// </summary> /// <param name="grid"></param> /// <param name="autoFilter"></param> public static void InitGridLookUp(GridLookUpEdit grid, bool autoFilter, TextEditStyles textEditStyle) { //Show filter grid.Properties.View.OptionsView.ShowAutoFilterRow = autoFilter; grid.Properties.TextEditStyle = textEditStyle; grid.Properties.PopupFilterMode = PopupFilterMode.Contains; //grid.Properties.BestFitMode = BestFitMode.BestFit; for (int i = 0; i < grid.Properties.View.Columns.Count; i++) { grid.Properties.View.Columns[i].Visible = false; } }
/// <summary> /// Thiet lap cau hinh luoi /// </summary> /// <param name="repo"></param> /// <param name="autoFilter"></param> /// <param name="autoPopup"></param> /// <param name="textEditStyle"></param> public static void Init(RepositoryItemGridLookUpEdit repo, bool autoPopup, TextEditStyles textEditStyle) { //Show filter repo.View.OptionsView.ShowAutoFilterRow = true; repo.TextEditStyle = textEditStyle; repo.ImmediatePopup = autoPopup; repo.PopupFilterMode = PopupFilterMode.Contains; //grid.BestFitMode = BestFitMode.BestFit; for (int i = 0; i < repo.View.Columns.Count; i++) { repo.View.Columns[i].Visible = false; } }
public W20231(string programID, string programName) : base(programID, programName) { InitializeComponent(); this.Text = _ProgramID + "─" + _ProgramName; GridHelper.SetCommonGrid(gvMain); PrintableComponent = gcMain; dao20231 = new D20231(); //統一設定下拉選單TextEditStyles TextEditStyles textEditStyles = TextEditStyles.DisableTextEditor; //期貨 //List<LookupItem> futList = new List<LookupItem>(){ // new LookupItem() { ValueMember = " ", DisplayMember = " "}, // new LookupItem() { ValueMember = "F", DisplayMember = "○" }}; DataTable dtFut = new CODW().ListLookUpEdit("20231", "PLS4_FUT"); Pls4FutLookUpEdit.SetColumnLookUp(dtFut, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_FUT.ColumnEdit = Pls4FutLookUpEdit; //選擇權 //List<LookupItem> optList = new List<LookupItem>(){ // new LookupItem() { ValueMember = " ", DisplayMember = " "}, // new LookupItem() { ValueMember = "O", DisplayMember = "○" }}; DataTable dtOpt = new CODW().ListLookUpEdit("20231", "PLS4_OPT"); Pls4OptLookUpEdit.SetColumnLookUp(dtOpt, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_OPT.ColumnEdit = Pls4OptLookUpEdit; //商品類別 //List<LookupItem> codeList = new List<LookupItem>(){ // new LookupItem() { ValueMember = "I", DisplayMember = "新增"}, // new LookupItem() { ValueMember = "M", DisplayMember = "小型"}, // new LookupItem() { ValueMember = "N", DisplayMember = " " }}; DataTable dtCode = new CODW().ListLookUpEdit("20231", "PLS4_STATUS_CODE"); Pls4StatusCodeLookUpEdit.SetColumnLookUp(dtCode, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_STATUS_CODE.ColumnEdit = Pls4StatusCodeLookUpEdit; //上市/上櫃 //Pls4PidLookUpEdit.SetColumnLookUp(new COD().ListByCol("TFXM", "TFXM_PID"), "COD_ID", "COD_DESC", textEditStyles, null); DataTable dtTFXM = new CODW().ListLookUpEdit("APDK", "UNDERLYING_MARKET"); Pls4PidLookUpEdit.SetColumnLookUp(dtTFXM, "CODW_ID", "CODW_DESC", textEditStyles, null); PLS4_PID.ColumnEdit = Pls4PidLookUpEdit; //預設隱藏DataGridView gcMain.Visible = false; }
/// <summary> /// 直接設定DataTable給lookupEdit /// </summary> /// <param name="cbx"></param> /// <param name="dataSource">dataTable or Dictionary(k,v)</param> /// <param name="valueMember">valueMember</param> /// <param name="displayMember">displayMember</param> /// <param name="textEditStyles">Standard=可輸入 DisableTextEditor=不可輸入,單純的下拉選單</param> /// <param name="nullText">nullText</param> public static void SetDataTable(this DevExpress.XtraEditors.LookUpEdit cbx, object dataSource, string valueMember, string displayMember = "CP_DISPLAY", TextEditStyles textEditStyles = TextEditStyles.Standard, string nullText = "--請選擇--") { //一些基本參數設定 cbx.EnterMoveNextControl = true; cbx.Properties.NullText = nullText; cbx.Properties.DropDownRows = 10; //一次顯示的下拉選單項目數量(太多或太少都不好) cbx.Properties.BestFitMode = BestFitMode.BestFitResizePopup; cbx.Properties.SearchMode = SearchMode.AutoFilter; //SearchMode.AutoFilter=輸入框每次輸入,都直接過濾下拉選項 cbx.Properties.AutoSearchColumnIndex = 1; cbx.Properties.TextEditStyle = textEditStyles; //Standard=可輸入 DisableTextEditor=不可輸入,單純的下拉選單 cbx.Properties.ShowHeader = false; cbx.Properties.ShowFooter = false; cbx.Properties.DataSource = dataSource; cbx.Properties.ForceInitialize(); cbx.Properties.PopulateColumns(); cbx.Properties.DisplayMember = displayMember; cbx.Properties.ValueMember = valueMember; //把不需要顯示的欄位隱藏 //ken,如果是Dictionary<Key,Value>,則Key在PopulateColumns時其Visible就直接為false foreach (LookUpColumnInfo col in cbx.Properties.Columns) { if (!string.IsNullOrEmpty(displayMember)) { if (col.FieldName.ToUpper() != displayMember.ToUpper()) { col.Visible = false; } } } }
internal static void SetCheckedComboEdit(CheckedComboBoxEdit control, ICollection <string> list, bool includeALL = false, TextEditStyles style = TextEditStyles.Standard) { if (control == null) { return; } control.Properties.Items.Clear(); if (includeALL) { control.Properties.Items.Add(ALL); } foreach (string item in list) { control.Properties.Items.Add(item); } if (control.Properties.Items.Count > 0) { foreach (CheckedListBoxItem item in control.Properties.Items) { item.CheckState = CheckState.Checked; } } }
internal static void SetComboEdit(ComboBoxEdit control, ICollection <string> list, bool includeALL = false, TextEditStyles style = TextEditStyles.Standard) { if (control == null) { return; } control.Properties.Items.Clear(); if (includeALL) { control.Properties.Items.Add(ALL); } foreach (string item in list) { control.Properties.Items.Add(item); } if (control.Properties.Items.Count > 0) { control.SelectedIndex = 0; } control.Properties.TextEditStyle = style; }