private void InitializeManualCode() { string CheckedMember = "CHECKED"; string DisplayMember = PPublicationTable.GetPublicationDescriptionDBName(); string ValueMember = PPublicationTable.GetPublicationCodeDBName(); DataTable Table = TDataCache.TMPartner.GetCacheableSubscriptionsTable(TCacheableSubscriptionsTablesEnum.PublicationList); DataView view = new DataView(Table); // TODO view.RowFilter = only active publications? view.Sort = ValueMember; DataTable NewTable = view.ToTable(true, new string[] { ValueMember, DisplayMember }); NewTable.Columns.Add(new DataColumn(CheckedMember, typeof(bool))); clbIncludePublication.SpecialKeys = ((SourceGrid.GridSpecialKeys)((((((SourceGrid.GridSpecialKeys.Arrows | SourceGrid.GridSpecialKeys.PageDownUp) | SourceGrid.GridSpecialKeys.Enter) | SourceGrid.GridSpecialKeys.Escape) | SourceGrid.GridSpecialKeys.Control) | SourceGrid.GridSpecialKeys.Shift))); //clbIncludePublication.SelectionMode = SourceGrid.GridSelectionMode.Row; clbIncludePublication.Columns.Clear(); clbIncludePublication.AddCheckBoxColumn("", NewTable.Columns[CheckedMember], 17, false); clbIncludePublication.AddTextColumn(Catalog.GetString("Publication Code"), NewTable.Columns[ValueMember]); clbIncludePublication.AddTextColumn(Catalog.GetString("Publication Description"), NewTable.Columns[DisplayMember]); clbIncludePublication.DataBindGrid(NewTable, ValueMember, CheckedMember, ValueMember, false, true, false); dtpDateOfSendingCopy.Date = DateTime.Now; ActiveSubscriptionsBoxChanged(null, null); }
private void InitializePublicationCodeList() { string CheckedMember = "CHECKED"; string ValueMember = PPublicationTable.GetPublicationCodeDBName(); string DisplayMember = PPublicationTable.GetPublicationDescriptionDBName(); DataTable Publications = TDataCache.TMPartner.GetCacheableSubscriptionsTable(TCacheableSubscriptionsTablesEnum.PublicationList); DataView PublicationsView = new DataView(Publications); PublicationsView.Sort = ValueMember; DataTable PublicationsTable = PublicationsView.ToTable(true, new string[] { ValueMember, DisplayMember }); PublicationsTable.Columns.Add(new DataColumn(CheckedMember, typeof(bool))); clbPublicationCode.SpecialKeys = ((SourceGrid.GridSpecialKeys)((((((SourceGrid.GridSpecialKeys.Arrows | SourceGrid.GridSpecialKeys.PageDownUp) | SourceGrid.GridSpecialKeys.Enter) | SourceGrid.GridSpecialKeys.Escape) | SourceGrid.GridSpecialKeys.Control) | SourceGrid.GridSpecialKeys.Shift))); clbPublicationCode.Columns.Clear(); clbPublicationCode.AddCheckBoxColumn("", PublicationsTable.Columns[CheckedMember], 17, false); clbPublicationCode.AddTextColumn(Catalog.GetString("Group Code"), PublicationsTable.Columns[ValueMember]); clbPublicationCode.AddTextColumn(Catalog.GetString("Description"), PublicationsTable.Columns[DisplayMember]); clbPublicationCode.DataBindGrid(PublicationsTable, ValueMember, CheckedMember, ValueMember, false, true, false); clbPublicationCode.AutoResizeGrid(); clbPublicationCode.AutoStretchColumnsToFitWidth = true; clbPublicationCode.SetCheckedStringList(""); }