public void SortContracts() { if (beiSortField.EditValue != null && beiSortMethod.EditValue != null) { Forms.ContractSelectForm childForm = new Forms.ContractSelectForm(); foreach (var item in this.MdiChildren) { if (item is Forms.ContractSelectForm) { childForm = item as Forms.ContractSelectForm; break; } } string sortField = string.Empty; DevExpress.Data.ColumnSortOrder method = new DevExpress.Data.ColumnSortOrder(); if (beiSortMethod.EditValue.ToString() == "По возрастанию") { method = DevExpress.Data.ColumnSortOrder.Ascending; } else { method = DevExpress.Data.ColumnSortOrder.Descending; } switch (beiSortField.EditValue.ToString()) { case "Номер договора": sortField = "Number"; break; } childForm.gvList.SortInfo.ClearAndAddRange(new[] { new GridColumnSortInfo(childForm.gvList.Columns[sortField], method) }); } }
private DevExpress.Data.ColumnSortOrder TransliateSortOrderEnum(string sortOrder) { DevExpress.Data.ColumnSortOrder v = DevExpress.Data.ColumnSortOrder.None; switch (sortOrder) { case "Ascending": v = DevExpress.Data.ColumnSortOrder.Ascending; break; case "Descending": v = DevExpress.Data.ColumnSortOrder.Descending; break; case "None": v = DevExpress.Data.ColumnSortOrder.None; break; default: break; } return(v); }
//根据devexpress 的列sort order 获取up.data.model下的SortOrderType. private MB.Util.DataOrderType getOrderTypeBy(DevExpress.Data.ColumnSortOrder order) { switch (order) { case DevExpress.Data.ColumnSortOrder.Ascending: return MB.Util.DataOrderType.Ascending; case DevExpress.Data.ColumnSortOrder.Descending: return MB.Util.DataOrderType.Descending; case DevExpress.Data.ColumnSortOrder.None: return MB.Util.DataOrderType.None; default: return MB.Util.DataOrderType.None; } }
public ListViewSort(DevExpress.Data.ColumnSortOrder SortingDirection) { this.sortingDirection = SortingDirection; }
public static SortOptionsDialog ShowSortOptions(Form owner, string sortOption, List <string> sortOptions, DevExpress.Data.ColumnSortOrder sortOrder) { using SortOptionsDialog sortOptionsDialog = new() { SortOption = sortOption, SortOptions = sortOptions, SortOrder = sortOrder }; return(sortOptionsDialog.ShowDialog(owner) == DialogResult.OK ? sortOptionsDialog : null); }
protected void Bind() { if ((!this.IsCallback) && (!this.IsPostBack)) { //Restore filter from cookies this.LoadFilterFromCookies(); this.InitialFilterBind(); SessionManager.CurrentCategories = this.GetListOfCategories(); } //Get main results try { List <int> channelIds = (SessionManager.CurrentChannels.Count == 0)?this.GetListOfChannels() :SessionManager.CurrentChannels; List <int> categoryIds = (SessionManager.CurrentCategories.Count == 0)?this.GetListOfCategories() :SessionManager.CurrentCategories; SessionManager.CurrentChannels = channelIds; SessionManager.CurrentCategories = categoryIds; CanonMainMonitor monitor = new CanonMainMonitor(Cdb.ConnectionString); monitor.Date = deDate.Date; monitor.ChannelIds = channelIds; monitor.PriceCondition = this.GetPriceCondition(); if (categoryIds != null) { monitor.CategoryIds = categoryIds; } if (!string.IsNullOrEmpty(txtProduct.Text.Trim())) { monitor.ProductName = Memos.Framework.Utilities.TruncateString(txtProduct.Text.Trim(), 300); } mappingRules = monitor.GetMappingRules(); DataSet ds = monitor.GetMainMonitorValues(); //get sorting settings before columns clearing DevExpress.Data.ColumnSortOrder sortOrder = DevExpress.Data.ColumnSortOrder.None; string sortColumn = string.Empty; foreach (GridViewColumn gvc in gridMainMonitor.Columns) { GridViewDataColumn gvdc = gvc as GridViewDataColumn; if (gvdc != null) { if (gvdc.SortOrder != DevExpress.Data.ColumnSortOrder.None) { sortColumn = gvdc.FieldName; sortOrder = gvdc.SortOrder; } } } gridMainMonitor.Columns.Clear(); GridViewCommandColumn col0 = new GridViewCommandColumn(); col0.ShowSelectCheckbox = true; col0.VisibleIndex = 0; col0.HeaderTemplate = new CommandColumnHeaderTemplate(gridMainMonitor, "selCheckbox", "gridMainMonitorSelectionBox"); col0.HeaderStyle.HorizontalAlign = HorizontalAlign.Center; col0.HeaderStyle.VerticalAlign = VerticalAlign.Middle; gridMainMonitor.Columns.Add(col0); int visIndex = 1; foreach (DataColumn dc in ds.Tables[0].Columns) { GridViewDataTextColumn col1 = new GridViewDataTextColumn(); col1.Caption = this.LocalizeColumnName(dc.ColumnName); col1.FieldName = dc.ColumnName; col1.VisibleIndex = visIndex++; if (dc.ColumnName == "ProductId") { col1.Visible = false; } if ((!string.IsNullOrEmpty(sortColumn)) && (col1.FieldName == sortColumn)) { col1.SortOrder = sortOrder; } col1.Settings.SortMode = DevExpress.XtraGrid.ColumnSortMode.Custom; gridMainMonitor.Columns.Add(col1); } gridMainMonitor.SettingsPager.PageSize = int.Parse(cbPageSize.SelectedItem.Value.ToString()); gridMainMonitor.DataSource = ds.Tables[0]; gridMainMonitor.DataBind(); gridMainMonitor.JSProperties["cpRowsCount"] = gridMainMonitor.VisibleRowCount; } catch (Exception ex) { Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error); gridMainMonitor.Columns.Clear(); gridMainMonitor.DataSource = null; gridMainMonitor.DataBind(); } }