internal static void GridLookupEdit_门店信息(RepositoryItemGridLookUpEdit properties, string[] fields = null) { var list = 门店Logic.GetList(); properties.DataSource = list; properties.ValueMember = "编码"; properties.DisplayMember = "门店名称"; properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; properties.ShowFooter = false; properties.View.AutoConfig(); properties.View.BestFitColumns(); if (null == fields) fields = new string[] { "门店名称" }; for (int i = 0; i < fields.Length; i++) { properties.View.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn { FieldName = fields[i], Caption = fields[i], VisibleIndex = i }); } }
/// <summary> /// An di cac cot, dung sau ShowField /// </summary> /// <param name="grid"></param> /// <param name="fieldName"></param> public static void HideField(RepositoryItemGridLookUpEdit grid, string[] fieldName) { for (int i = 0; i < fieldName.Length; i++) { grid.View.Columns[fieldName[i]].Visible = false; } }
//filter control public override void applyCustomEditShownFilterControl(IDataBindingSource src, ShowValueEditorEventArgs e) { RepositoryItemGridLookUpEdit rle = new RepositoryItemGridLookUpEdit(); e.CustomRepositoryItem = rle; setupRle(src, rle, e.CurrentNode.FirstOperand.PropertyName); }
/// <summary> /// /// </summary> /// <param name="grid"></param> /// <param name="fieldName"></param> /// <param name="visible"></param> public static void ShowAssignField(RepositoryItemGridLookUpEdit grid, string[] fieldName, bool visible) { for (int i = 0; i < fieldName.Length; i++) { grid.View.Columns[fieldName[i]].Visible = visible; } }
private void InitializeComponent() { this.fProperties = new DevExpress.XtraEditors.Repository.RepositoryItemGridLookUpEdit(); this.fPropertiesView = new DevExpress.XtraGrid.Views.Grid.GridView(); ((System.ComponentModel.ISupportInitialize)(this.fProperties)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.fPropertiesView)).BeginInit(); this.SuspendLayout(); // // fProperties // this.fProperties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] { new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo) }); this.fProperties.Name = "fProperties"; this.fProperties.PopupView = this.fPropertiesView; // // fPropertiesView // this.fPropertiesView.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus; this.fPropertiesView.Name = "fPropertiesView"; this.fPropertiesView.OptionsSelection.EnableAppearanceFocusedCell = false; this.fPropertiesView.OptionsView.ShowGroupPanel = false; ((System.ComponentModel.ISupportInitialize)(this.fProperties)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.fPropertiesView)).EndInit(); this.ResumeLayout(false); }
public FrmS11AH() { InitializeComponent(); _dbOptionHelper = new GlobalVariable(); _accountsPresenter = new AccountsPresenter(this); dateTimeRangeV1.InitData(DateTime.Parse(new GlobalVariable().PostedDate)); dateTimeRangeV1.SetComboIndex(7); #region BudgetItem _rpsAccountNumberView = new GridView(); _rpsAccountNumberView.OptionsView.ColumnAutoWidth = false; _rpsAccountNumber = new RepositoryItemGridLookUpEdit { NullText = "", View = _rpsAccountNumberView, TextEditStyle = TextEditStyles.Standard, PopupResizeMode = ResizeMode.FrameResize, PopupFormSize = new Size(500, 200), ShowFooter = false }; _rpsAccountNumber.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; _rpsAccountNumber.View.BestFitColumns(); _rpsAccountNumber.View.OptionsView.ShowIndicator = false; #endregion }
private void SetUpEditor(RepositoryItemGridLookUpEdit edit) { edit.DataSource = list;//new BindingSource(list, ""); edit.ValueMember = "ID"; edit.DisplayMember = "Text"; helper = new TypeConverterHelper(edit, "Unbound", "Point"); }
private void zoneNameGridLookUpEdit_QueryPopUp(object sender, CancelEventArgs e) { GridLookUpEdit editor = (GridLookUpEdit)sender; RepositoryItemGridLookUpEdit properties = editor.Properties; properties.PopupFormSize = new Size(editor.Width - 4, properties.PopupFormSize.Height); }
public UserControlAccountingObjectList() { InitializeComponent(); rpsAccountingObjectCategory = new RepositoryItemGridLookUpEdit(); _accountingObjectsPresenter = new AccountingObjectsPresenter(this); }
/// <summary> /// Initializes a new instance of the <see cref="FrmS12H"/> class. /// </summary> public FrmS12H() { InitializeComponent(); _dbOptionHelper = new GlobalVariable(); _accountsPresenter = new AccountsPresenter(this); _banksPresenter = new BanksPresenter(this); dateTimeRangeV1.DateRangePeriodMode = DateRangeMode.Reduce; dateTimeRangeV1.InitSelectedIndex = GlobalVariable.DateRangeSelectedIndex; #region BudgetItem var rpsAccountNumberView = new GridView(); rpsAccountNumberView.OptionsView.ColumnAutoWidth = false; var rpsAccountNumber = new RepositoryItemGridLookUpEdit { NullText = "", View = rpsAccountNumberView, TextEditStyle = TextEditStyles.Standard, PopupResizeMode = ResizeMode.FrameResize, PopupFormSize = new Size(500, 200), ShowFooter = false }; rpsAccountNumber.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; rpsAccountNumber.View.OptionsView.ShowIndicator = false; #endregion }
private void TypeLookUp_SizeChanged(object sender, EventArgs e) { GridLookUpEdit editor = (GridLookUpEdit)sender; RepositoryItemGridLookUpEdit properties = editor.Properties; properties.PopupFormSize = new Size(editor.Width, properties.PopupFormSize.Height); }
public void AddEvent() { gcMain = data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl; gvMain = gcMain.MainView as GridView; riCode = gcMain.RepositoryItems["Code"] as RepositoryItemGridLookUpEdit; riCode.CloseUp += new DevExpress.XtraEditors.Controls.CloseUpEventHandler(riCode_CloseUp); }
public void AddEvent() { //bổ sung chọn địa chỉ giao hàng, người liên hệ và số điện thoại cbeDCGH = data.FrmMain.Controls.Find("NguoiLH", true)[0] as ComboBoxEdit; cbeNLH = data.FrmMain.Controls.Find("NLH", true)[0] as ComboBoxEdit; cbeDT = data.FrmMain.Controls.Find("SDTNL", true)[0] as ComboBoxEdit; cbeDCGH.QueryPopUp += new System.ComponentModel.CancelEventHandler(cbeDCGH_QueryPopUp); cbeNLH.QueryPopUp += new System.ComponentModel.CancelEventHandler(cbeNLH_QueryPopUp); cbeNLH.EditValueChanged += new EventHandler(cbeNLH_EditValueChanged); gluKH = data.FrmMain.Controls.Find("MaKH", true)[0] as GridLookUpEdit; //gluKH.CloseUp += new DevExpress.XtraEditors.Controls.CloseUpEventHandler(gluKH_CloseUp); gcMain = data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl; gvMain = gcMain.MainView as GridView; RepositoryItemGridLookUpEdit gluDVT = gcMain.RepositoryItems["MaDVT"] as RepositoryItemGridLookUpEdit; gluDVT.QueryCloseUp += new System.ComponentModel.CancelEventHandler(gluDVT_QueryCloseUp); gvMain.FocusedColumnChanged += new DevExpress.XtraGrid.Views.Base.FocusedColumnChangedEventHandler(gvMain_FocusedColumnChanged); data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged); BsMain_DataSourceChanged(data.BsMain, new EventArgs()); //them chuc nang Lam tron tien LayoutControl lcMain = data.FrmMain.Controls.Find("lcMain", true)[0] as LayoutControl; SimpleButton btnLamTron = new SimpleButton(); btnLamTron.Name = "btnLamTron"; //phai co name cua control btnLamTron.Text = "Làm tròn"; LayoutControlItem lci = lcMain.AddItem("", btnLamTron); lci.Name = "cusLamTron"; //phai co name cua item, bat buoc phai co "cus" phai truoc btnLamTron.Click += new EventHandler(btnLamTron_Click); }
public static void InitCachingPresentControls( ) { CachingGridViews.Clear(); ReposityGridLookupEdits.Clear(); ReposityLookupEdits.Clear(); foreach (String strTableName in DataConfigProvider.TableConfigList.Keys) { DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName]; if (config.IsCaching && DataStructureProvider.IsSystemTable(strTableName) == false) { //RepositoryLookUpEdit GetDefaultRepositoryLookUpEdit(strTableName, false); } } foreach (String strTableName in DataConfigProvider.TableConfigList.Keys) { DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName]; if (config.IsCaching) { //GridView GridView view = GetDefaultGridView(strTableName); //RepositoryGridLookupEdit RepositoryItemGridLookUpEdit repoLookupEdit = GetDefaultRepositoryGridLookupEdit(strTableName, false); repoLookupEdit.View = view; } } }
private void GetLookUpData() { string table = _data.DrTableMaster["TableName"].ToString(); if ((table == "MT24" || table == "MT32") && gvVat.Columns["MaVT"] != null && gvVat.Columns["MaVT"].ColumnEdit != null) { RepositoryItemGridLookUpEdit riGlu = gvVat.Columns["MaVT"].ColumnEdit as RepositoryItemGridLookUpEdit; CDTData data = (riGlu.Tag as GrdSingle).Data; //CDTData data = riGlu.Tag as CDTData; if (data.FullData) { return; } data.GetData(); data.FullData = true; BindingSource bs = riGlu.DataSource as BindingSource; bs.DataSource = data.DsData.Tables[0]; } if ((table.Contains("MT1") || table == "MT51") && gvVat.Columns["MaKH"] != null && gvVat.Columns["MaKH"].ColumnEdit != null) { RepositoryItemGridLookUpEdit riGlu = gvVat.Columns["MaKH"].ColumnEdit as RepositoryItemGridLookUpEdit; CDTData data = (riGlu.Tag as GrdSingle).Data; //CDTData data = riGlu.Tag as CDTData; if (data.FullData) { return; } data.GetData(); data.FullData = true; BindingSource bs = riGlu.DataSource as BindingSource; bs.DataSource = data.DsData.Tables[0]; } }
public void AddEvent() { isVay = _data.DrTable.Table.Columns.Contains("ExtraSql") && _data.DrTable["ExtraSql"].ToString().ToLower().Contains("isvay = 1"); gvMain = (_data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl).MainView as GridView; RepositoryItemGridLookUpEdit gluLT = gvMain.GridControl.RepositoryItems["LoaiThu"] as RepositoryItemGridLookUpEdit; gluLT.Popup += new EventHandler(gluLC_Popup); cbePX = (_data.FrmMain.Controls.Find("PhanXuong", true)[0] as ComboBoxEdit); gluLT.View.ColumnFilterChanged += new EventHandler(View_ColumnFilterChanged); cbePX.EditValueChanging += new DevExpress.XtraEditors.Controls.ChangingEventHandler(cbe_EditValueChanging); //thêm nút chọn DH lcMain = _data.FrmMain.Controls.Find("lcMain", true)[0] as LayoutControl; if (!isVay) { SimpleButton btnChon = new SimpleButton(); btnChon.Name = "btnChon"; btnChon.Text = "Chọn khách hàng"; LayoutControlItem lci = lcMain.AddItem("", btnChon); lci.Name = "cusChon"; btnChon.Click += new EventHandler(btnChon_Click); } _data.FrmMain.Shown += new EventHandler(FrmMain_Shown); _data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged); BsMain_DataSourceChanged(_data.BsMain, new EventArgs()); }
private void FilterDMCN(GridLookUpEdit gluDMCN) { if (!_data.DrTable.Table.Columns.Contains("ExtraSQL")) { return; } string filter = _data.DrTable["ExtraSQL"].ToString(); RepositoryItemGridLookUpEdit ri = gluDMCN.Properties; if ((ri.Tag as GrdSingle) != null) { CDTData data = (ri.Tag as GrdSingle).Data; if (data.FullData) { return; } if (data.Condition != string.Empty) { data.Condition = data.Condition + " and " + filter; } else { data.Condition = filter; } data.GetData(); data.FullData = true; BindingSource bs = ri.DataSource as BindingSource; bs.DataSource = data.DsData.Tables[0]; ri.View.BestFitColumns(); } }
protected override void InitControls() { grdDetail.ForceInitialize(); RepositorySalaryRatio = new RepositoryItemCalcEdit(); RepositoryAmount = new RepositoryItemCalcEdit(); RepositoryPayItemId = new RepositoryItemGridLookUpEdit(); RepositorySalaryRatio.Mask.MaskType = MaskType.Numeric; RepositorySalaryRatio.Mask.EditMask = @"f" + _dbOptionHelper.ExchangeRateDecimalDigits; RepositorySalaryRatio.Mask.UseMaskAsDisplayFormat = true; RepositoryAmount.Mask.MaskType = MaskType.Numeric; RepositoryAmount.Mask.EditMask = @"c" + int.Parse(_dbOptionHelper.CurrencyDecimalDigits); RepositoryAmount.Mask.Culture = new CultureInfo("vi-VN") { NumberFormat = { CurrencySymbol = _dbOptionHelper.CurrencySymbol, CurrencyDecimalSeparator = _dbOptionHelper.CurrencyDecimalSeparator, CurrencyGroupSeparator = _dbOptionHelper.CurrencyGroupSeparator, CurrencyDecimalDigits = int.Parse(_dbOptionHelper.CurrencyDecimalDigits) } }; RepositoryAmount.Mask.UseMaskAsDisplayFormat = true; RepositoryPayItemId.NullText = ResourceHelper.GetResourceValueByName("ResRepositoryControlPayItemID"); }
/// <summary> /// 新的下拉菜单 /// </summary> /// <param name="ykgridLookUp"></param> /// <param name="displayName"></param> /// <param name="valueName"></param> public virtual void SetGridLookUpEdit(RepositoryItemGridLookUpEdit ykgridLookUp, List <InputItem> listData, int inputitemCount = 1) { ykgridLookUp.View.Columns.Clear(); ykgridLookUp.DataSource = listData.OrderBy(a => a.Value).ToList(); //初始化一些状态 GridColumn col1 = ykgridLookUp.View.Columns.AddField("DisPlayName"); col1.VisibleIndex = 0; col1.Caption = "描述"; for (int i = 1; i <= inputitemCount; i++) { GridColumn col = ykgridLookUp.View.Columns.AddField("InputCode" + i); col.VisibleIndex = i; col.Caption = "代号" + i; } ykgridLookUp.NullText = ""; ykgridLookUp.View.OptionsBehavior.AutoPopulateColumns = false; ykgridLookUp.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; ykgridLookUp.View.BestFitColumns(); ykgridLookUp.ShowFooter = true; ykgridLookUp.View.OptionsView.ShowAutoFilterRow = false; ykgridLookUp.AutoComplete = false; ykgridLookUp.ImmediatePopup = true; ykgridLookUp.PopupFilterMode = PopupFilterMode.Contains; ykgridLookUp.TextEditStyle = TextEditStyles.Standard; ykgridLookUp.DisplayMember = "DisPlayName"; ykgridLookUp.ValueMember = "Value"; ykgridLookUp.View.BestFitColumns(); ykgridLookUp.BestFitMode = BestFitMode.BestFitResizePopup; ykgridLookUp.EditValueChanging += ykgridLookUp_EditValueChanging; }
protected virtual void Attach(RepositoryItemGridLookUpEdit rep) { if (rep == null) { return; } selection.Clear(); _currentRepository = rep; edit = _currentRepository.View.GridControl.RepositoryItems.Add("CheckEdit") as RepositoryItemCheckEdit; GridColumn column = _currentRepository.View.Columns.Add(); column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False; column.Visible = true; column.VisibleIndex = 0; column.FieldName = checkColumnFieldName; column.Caption = "Mark"; column.OptionsColumn.ShowCaption = false; column.OptionsColumn.AllowEdit = false; column.OptionsColumn.AllowSize = false; column.UnboundType = DevExpress.Data.UnboundColumnType.Boolean; column.Width = GetCheckBoxWidth(); column.ColumnEdit = edit; _currentRepository.View.Click += new EventHandler(View_Click); _currentRepository.View.CustomDrawColumnHeader += new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader); _currentRepository.View.CustomDrawGroupRow += new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow); _currentRepository.View.CustomUnboundColumnData += new CustomColumnDataEventHandler(view_CustomUnboundColumnData); _currentRepository.View.KeyDown += new KeyEventHandler(view_KeyDown); }
/// <summary> /// Loads the data into grid. /// </summary> protected void LoadDataIntoGrid() { IList <ActionForm> dataSource = new List <ActionForm>(); dataSource.Add(new ActionForm(1, "Thêm mới")); dataSource.Add(new ActionForm(2, "Sửa")); dataSource.Add(new ActionForm(3, "Xóa")); dataSource.Add(new ActionForm(4, "Xem")); dataSource.Add(new ActionForm(5, "Nhân bản")); dataSource.Add(new ActionForm(6, "In")); dataSource.Add(new ActionForm(7, "Đăng nhập")); dataSource.Add(new ActionForm(8, "Đăng xuất")); _rsActionView = new GridView(); _rsActionView.OptionsView.ColumnAutoWidth = false; _rsAction = new RepositoryItemGridLookUpEdit { NullText = "", View = _rsActionView, TextEditStyle = TextEditStyles.Standard, }; _rsAction.View.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; _rsAction.View.OptionsView.ShowIndicator = false; _rsAction.PopupFormSize = new Size(10, 150); _rsAction.View.BestFitColumns(); _rsAction.DataSource = dataSource; _rsActionView.PopulateColumns(dataSource); var gridColumnsCollection = new List <XtraColumn>(); gridColumnsCollection.Add(new XtraColumn { ColumnName = "Id", ColumnCaption = "Mã nguồn vốn", ColumnVisible = false, ColumnPosition = 1 }); gridColumnsCollection.Add(new XtraColumn { ColumnName = "Name", ColumnCaption = "Thao tác", ColumnVisible = true, ColumnWith = 180, ColumnPosition = 2 }); XtraColumnCollectionHelper <ActionForm> .ShowXtraColumnInGridView(gridColumnsCollection, _rsActionView); _rsAction.DataSource = dataSource; _rsAction.DisplayMember = "Name"; _rsAction.ValueMember = "Id"; _audittingLogsPresenter.Display(); _refTypesPresenter.Display(); _userProfilesPresenter.Display(); }
public void AddRepositoryGridLookupEdit(RepositoryItemGridLookUpEdit gridlookup) { DataTable dataTable = new DataTable(); gridlookup.DataSource = this.GetList(); gridlookup.DisplayMember = "MachineName"; gridlookup.ValueMember = "MachineCode"; }
public void AddRepositoryGridLookupEdit(RepositoryItemGridLookUpEdit gridlookup) { DataTable dataTable = new DataTable(); gridlookup.DataSource = this.GetList(); gridlookup.DisplayMember = "TimeKeeperTableListName"; gridlookup.ValueMember = "TimeKeeperTableListID"; }
/// <summary> /// Initializes a new instance of the <see cref="UserControlOutputInventoryList"/> class. /// </summary> public UserControlOutputInventoryList() { InitializeComponent(); _rpsInventoryItem = new RepositoryItemGridLookUpEdit(); _inventoryItemsPresenter = new InventoryItemsPresenter(this); _outputInventoriesPresenter = new OutputInventoriesPresenter(this); _voucherTypesPresenter = new VoucherTypesPresenter(this); }
public void AddRepositoryGridLookup(RepositoryItemGridLookUpEdit grlookup) { DataTable dataTable = new DataTable(); grlookup.DataSource = this.GetList(); grlookup.DisplayMember = "RelativeName"; grlookup.ValueMember = "RelativeName"; }
public void AddRepositoryGridLookupEdit(Guid SalaryTableListID, RepositoryItemGridLookUpEdit gridlookup) { DataTable dataTable = new DataTable(); gridlookup.DataSource = this.GetList(SalaryTableListID); gridlookup.DisplayMember = "DeductionName"; gridlookup.ValueMember = "DeductionCode"; }
public TypeConverterHelper(RepositoryItemGridLookUpEdit edit, string unboundColumnFieldName, string convertedProperty) { this.edit = edit; this.unboundColumnFieldName = unboundColumnFieldName; this.convertedProperty = convertedProperty; CreateUnboundColumn(edit.View, unboundColumnFieldName); }
public override void applyRetrievedAttribute(IDataBindingSource src, FieldRetrievedEventArgs e) { RepositoryItemGridLookUpEdit rle = e.RepositoryItem as RepositoryItemGridLookUpEdit; src.EditorsHost.onSetupLookUpGridEventData(this, new SetupLookUpGridEventData { FieldName = e.FieldName, DataBindingSource = src, Rle = rle }); setupRle(src, rle, e.FieldName); }
public override void applyCustomRowCellEdit(IDataBindingSource src, CustomRowCellEditEventArgs e) { RepositoryItemGridLookUpEdit rle = e.RepositoryItem as RepositoryItemGridLookUpEdit; rle.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; src.EditorsHost.onSetupLookUpGridEventData(this, new SetupLookUpGridEventData { FieldName = e.Column.FieldName, DataBindingSource = src, Rle = rle }); }
public void SetReposGridLookUpEdit(RepositoryItemGridLookUpEdit ykgridLookUp, string displayName, string valueName) { ykgridLookUp.DisplayMember = displayName; ykgridLookUp.ValueMember = valueName; ykgridLookUp.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; ykgridLookUp.ImmediatePopup = true; ykgridLookUp.View.OptionsView.ShowColumnHeaders = false; ykgridLookUp.NullText = ""; }
public void AddEvent() { _isBanSP = _data.DrTable.Table.Columns.Contains("ExtraSql") && _data.DrTable["ExtraSql"].ToString().Contains("IsBanSP = 1"); _data.BsMain.DataSourceChanged += new EventHandler(BsMain_DataSourceChanged); BsMain_DataSourceChanged(_data.BsMain, new EventArgs()); GridControl gcMain = (_data.FrmMain.Controls.Find("gcMain", true)[0] as GridControl); RepositoryItemGridLookUpEdit glu = gcMain.RepositoryItems["MaSP"] as RepositoryItemGridLookUpEdit; glu.Popup += new EventHandler(glu_Popup); }
public BookFilterEditor(TCommonFireBirdDB db) { if (db == null) { throw new ArgumentNullException("db"); } InitializeComponent(); firstActivate = true; database = db; FilterColumnCollection columnCollection = new FilterColumnCollection(); genreEditor = new RepositoryItemGridLookUpEdit(); genreEditor.ValueMember = "Name"; genreEditor.DisplayMember = "Name"; genreEditor.ViewType = GridLookUpViewType.Default; GridColumn genreNameColumn = new GridColumn(); genreNameColumn.Caption = "Name"; genreNameColumn.FieldName = "Name"; genreNameColumn.VisibleIndex = 0; GridColumn genreDescColumn = new GridColumn(); genreDescColumn.Caption = "Description"; genreDescColumn.FieldName = "RuDescription"; genreDescColumn.VisibleIndex = 1; genreEditor.View.Columns.Add(genreNameColumn); genreEditor.View.Columns.Add(genreDescColumn); columnCollection.Add(new UnboundFilterColumn("Genre", "Genres", typeof(string), this.genreEditor, FilterColumnClauseClass.String)); columnCollection.Add(new UnboundFilterColumn("Language", "Lang", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String)); columnCollection.Add(new UnboundFilterColumn("Source Language", "SrcLang", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String)); columnCollection.Add(new UnboundFilterColumn("Book Author", "BookAuthors", typeof(string), new RepositoryItemComboBox(), FilterColumnClauseClass.String)); this.filterControl.SetFilterColumnsCollection(columnCollection); }
protected virtual void Attach(RepositoryItemGridLookUpEdit rep) { if (rep == null) return; selection.Clear(); _currentRepository = rep; edit = _currentRepository.View.GridControl.RepositoryItems.Add("CheckEdit") as RepositoryItemCheckEdit; GridColumn column = _currentRepository.View.Columns.Add(); column.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False; column.Visible = true; column.VisibleIndex = 0; column.FieldName = checkColumnFieldName; column.Caption = "Mark"; column.OptionsColumn.ShowCaption = false; column.OptionsColumn.AllowEdit = false; column.OptionsColumn.AllowSize = false; column.UnboundType = DevExpress.Data.UnboundColumnType.Boolean; column.Width = GetCheckBoxWidth(); column.ColumnEdit = edit; _currentRepository.View.Click += new EventHandler(View_Click); _currentRepository.View.CustomDrawColumnHeader += new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader); _currentRepository.View.CustomDrawGroupRow += new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow); _currentRepository.View.CustomUnboundColumnData += new CustomColumnDataEventHandler(view_CustomUnboundColumnData); _currentRepository.View.KeyDown += new KeyEventHandler(view_KeyDown); }
/// <summary> /// 绑定表格数据 /// </summary> /// <param name="dbgrid">显示数据的表格</param> /// <param name="tab">数据表</param> public void BindGrid(GridControl dbgrid, DataTable tab) { if (null == dbgrid || null == tab) return; GridView gridview = (GridView)dbgrid.MainView; dbgrid.DataSource = tab; gridview.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(gridview_CellValueChanged); DataColumnCollection dbcols = tab.Columns; if (null != gridview.Columns["ID"]) gridview.Columns["ID"].Visible = false; foreach (DataColumn dbcol in dbcols) { //设置表格字典 GridColumn gdcol = gridview.Columns.ColumnByFieldName(dbcol.ColumnName); if (null == gdcol) gdcol = gridview.Columns.ColumnByName(dbcol.ColumnName); if (null == gdcol) continue; string src = Convert.ToString(dbcol.ExtendedProperties[BindManager.srcpro]); string txt = Convert.ToString(dbcol.ExtendedProperties[BindManager.txtpro]); string val = Convert.ToString(dbcol.ExtendedProperties[BindManager.valpro]); txt = string.IsNullOrEmpty(txt) ? val : txt; val = string.IsNullOrEmpty(val) ? txt : val; if (BindManager.regexSQL.IsMatch(src)) src = dbcol.ColumnName; if (null != tab.DataSet && !string.IsNullOrEmpty(src) && !string.IsNullOrEmpty(txt) && !string.IsNullOrEmpty(val) && tab.DataSet.Tables.Contains(src)) { DataTable tabdict = tab.DataSet.Tables[src]; if (tabdict.Columns.Contains(txt) && tabdict.Columns.Contains(val)) { RepositoryItemGridLookUpEdit ri = new RepositoryItemGridLookUpEdit(); ri.DataSource = tabdict; //控制下拉的选项哪些可以显示,哪些不可以显示 if (ri.View.Columns.Contains(ri.View.Columns["ID"])) { ri.View.Columns["ID"].Visible = false; } ri.NullText = "请选择"; ri.DisplayMember = txt; ri.ValueMember = val; gdcol.ColumnEdit = ri ; } } //设置列是否可见 if (null != dbcol.ExtendedProperties[BindManager.visipro]) { bool visible = Convert.ToBoolean(dbcol.ExtendedProperties[BindManager.visipro]); if (!visible) gdcol.Visible = visible; } //设置列是否只读 if (null != dbcol.ExtendedProperties[BindManager.readpro]) { bool readble = Convert.ToBoolean(dbcol.ExtendedProperties[BindManager.readpro]); if (readble) gdcol.Visible = readble; } } }
/// <summary> /// 绑定表格数据并且只根据部门来绑定过滤后的数据 /// </summary> /// <param name="dbgrid">显示数据的表格</param> /// <param name="tab">数据表</param> /// <param name="tag">部门id</param> private void GetDeptEmployee(GridControl dbgrid, DataTable tab, string tag) { if (null == dbgrid || null == tab) return; GridView gridview = (GridView)dbgrid.MainView; DataTable dt = tab.Clone(); if (!dt.Columns.Contains("部门id")) return; dt = FunShare.GetTable(dt, tab.Select("部门id='" + tag + "'")); dbgrid.DataSource = dt; DataColumnCollection dbcols = tab.Columns; if (null != gridview.Columns["ID"]) gridview.Columns["ID"].Visible = false; foreach (DataColumn dbcol in dbcols) { //设置表格字典 GridColumn gdcol = gridview.Columns.ColumnByFieldName(dbcol.ColumnName); if (null == gdcol) gdcol = gridview.Columns.ColumnByName(dbcol.ColumnName); if (null == gdcol) continue; string src = Convert.ToString(dbcol.ExtendedProperties[srcpro]); string txt = Convert.ToString(dbcol.ExtendedProperties[txtpro]); string val = Convert.ToString(dbcol.ExtendedProperties[valpro]); txt = string.IsNullOrEmpty(txt) ? val : txt; val = string.IsNullOrEmpty(val) ? txt : val; src = dbcol.ColumnName; if (null != tab.DataSet && !string.IsNullOrEmpty(src) && !string.IsNullOrEmpty(txt) && !string.IsNullOrEmpty(val) && tab.DataSet.Tables.Contains(src)) { DataTable tabdict = tab.DataSet.Tables[src]; if (tabdict.Columns.Contains(txt) && tabdict.Columns.Contains(val)) { RepositoryItemGridLookUpEdit ri = new RepositoryItemGridLookUpEdit(); DataTable dtDict = tabdict.Clone(); if (dtDict.Columns.Contains("id")) { dtDict = FunShare.GetTable(dtDict, tabdict.Select("id='" + tag + "'")); ri.DataSource = dtDict; } else { ri.DataSource = tabdict; } //控制下拉的选项哪些可以显示,哪些不可以显示 if (ri.View.Columns.Contains(ri.View.Columns["ID"])) { ri.View.Columns["ID"].Visible = false; } ri.NullText = "请选择"; ri.DisplayMember = txt; ri.ValueMember = val; gdcol.ColumnEdit = ri; } } } }
protected virtual void Detach() { if (_currentRepository == null) return; if (edit != null) { _currentRepository.View.GridControl.RepositoryItems.Remove(edit); edit.Dispose(); } _currentRepository.View.Click -= new EventHandler(View_Click); _currentRepository.View.CustomDrawColumnHeader -= new ColumnHeaderCustomDrawEventHandler(View_CustomDrawColumnHeader); _currentRepository.View.CustomDrawGroupRow -= new RowObjectCustomDrawEventHandler(View_CustomDrawGroupRow); _currentRepository.View.CustomUnboundColumnData -= new CustomColumnDataEventHandler(view_CustomUnboundColumnData); _currentRepository.View.KeyDown -= new KeyEventHandler(view_KeyDown); _currentRepository = null; }
public GridCheckMarksSelection(RepositoryItemGridLookUpEdit repository) : this() { CurrentRepository = repository; }