///<summary>Allows the controller to customize the column's sorting comparisons.</summary> protected internal virtual void CompareValues(CustomColumnSortEventArgs e) { }
private void TreeProjectFiles_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.NodeValue1 is string && e.NodeValue2 is string) { e.Result = StringLogicalComparer.Compare(Convert.ToString(e.NodeValue1), Convert.ToString(e.NodeValue2)); } }
private void grid_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { e.Result = Comparer <int> .Default.Compare(e.ListSourceRowIndex1, e.ListSourceRowIndex2); e.Handled = true; }
private void AssociatedObject_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName == "ImdbRating" || e.Column.FieldName == "Item.VoteAverage" || e.Column.FieldName == "PersonalRating") { int value1 = Convert.ToInt32(e.Value1); int value2 = Convert.ToInt32(e.Value2); e.Result = Comparer.Default.Compare(value1, value2); e.Handled = true; } else if (e.Column.FieldName == "Item.Budget" || e.Column.FieldName == "Item.Revenue") { decimal value1 = Convert.ToDecimal(e.Value1); decimal value2 = Convert.ToDecimal(e.Value2); decimal valueRate1 = Math.Floor(value1 / MoneyGroupInterval); decimal valueRate2 = Math.Floor(value2 / MoneyGroupInterval); int result = Comparer.Default.Compare(valueRate1, valueRate2); if (value1 > MoneyMaxValue && value2 > MoneyMaxValue) { result = 0; } e.Result = result; e.Handled = true; } else if (e.Column.FieldName == "Item.GenreIds" || e.Column.FieldName == "Starring") { string value1 = e.Value1.ToString().FirstOfJoinedByListSeparator(); string value2 = e.Value2.ToString().FirstOfJoinedByListSeparator(); e.Result = Comparer.Default.Compare(value1, value2); e.Handled = true; } }
private void AssociatedObject_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName == "Department") { string department = (e.Column.DataContext as PersonContainer)?.Person?.KnownForDepartment; string value1 = e.Value1.ToString(); string value2 = e.Value2.ToString(); if (value1 == value2) { e.Result = 0; e.Handled = true; } else if (value1 == department) { e.Result = -1; e.Handled = true; } else if (value2 == department) { e.Result = 1; e.Handled = true; } } }
protected internal override void CompareValues(CustomColumnSortEventArgs e) { var index1 = SortedOrder.IndexOf(e.Value1 as string); var index2 = SortedOrder.IndexOf(e.Value2 as string); e.Result = index1.CompareTo(index2); e.Handled = index1 != index2; }
private void gridViewData_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column != gridColumnQuiz) return; var record1 = e.RowObject1 as QuizPassGroupReportModel; var record2 = e.RowObject1 as QuizPassGroupReportModel; if (record1 == null || !record1.Date.HasValue || record2 == null || !record2.Date.HasValue) return; e.Handled = true; e.Result = record1.Date.Value.CompareTo(record2.Date.Value); }
///<summary>Raises the CustomColumnSort event.</summary> protected override void RaiseCustomColumnSort(CustomColumnSortEventArgs e) { base.RaiseCustomColumnSort(e); var column = e.Column as SmartGridColumn; if (column != null && column.Controller != null) { column.Controller.CompareValues(e); } }
private void gridViewReceipts_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { if (e.Column == colDateMonth) { var r1 = e.RowObject1 as Receipt; var r2 = e.RowObject2 as Receipt; e.Result = r1.Date.Month.CompareTo(r2.Date.Month); e.Handled = true; } }
protected void grid_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { if (e.Column != null && e.Column.FieldName == "ProductName") { int intervalValue1 = GetInterval(e.Value1.ToString()); int intervalValue2 = GetInterval(e.Value2.ToString()); e.Result = Comparer.Default.Compare(intervalValue1, intervalValue2); e.Handled = true; } }
void OnCustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName == "Day") { int dayIndex1 = GetDayIndex(e.Value1); int dayIndex2 = GetDayIndex(e.Value2); e.Result = dayIndex1.CompareTo(dayIndex2); e.Handled = true; } }
protected void gv_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { int order1 = GetOrderValue(e.Value1.ToString()); int order2 = GetOrderValue(e.Value2.ToString()); e.Handled = order1 != order2; if (e.Handled) { e.Result = order1 > order2 ? 1 : -1; } }
protected void grid_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (cb_CustomSort.Checked == false) { return; } if (e.Column.FieldName != "value") { return; } int Value1_NumberPart; string Value1_TextPart; string Value1_NumberString = Regex.Match(e.Value1.ToString(), @"\d+").Value; if (Value1_NumberString != "") { Value1_NumberPart = Convert.ToInt32(Value1_NumberString); Value1_TextPart = e.Value1.ToString().Replace(Value1_NumberString, "").ToLower(); } else { Value1_NumberPart = 0; Value1_TextPart = e.Value1.ToString().ToLower(); } int Value2_NumberPart; string Value2_TextPart; string Value2_NumberString = Regex.Match(e.Value2.ToString(), @"\d+").Value; if (Value2_NumberString != "") { Value2_NumberPart = Convert.ToInt32(Value2_NumberString); Value2_TextPart = e.Value2.ToString().Replace(Value2_NumberString, "").ToLower(); } else { Value2_NumberPart = 0; Value2_TextPart = e.Value2.ToString().ToLower(); } if (Value1_TextPart != Value2_TextPart) { e.Handled = false; } else { e.Handled = true; e.Result = Value1_NumberPart > Value2_NumberPart ? 1 : -1; } }
private void projectsGridView_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { int?res = DoCustomColumnSort(sender, e); if (res == null) { return; } e.Handled = true; e.Result = res.Value; }
void OnCustomColumnGroup(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName != "UnitPrice") { return; } double x = Math.Floor(Convert.ToDouble(e.Value1) / 10); double y = Math.Floor(Convert.ToDouble(e.Value2) / 10); e.Result = x > 9 && y > 9 ? 0 : x.CompareTo(y); e.Handled = true; }
void grid_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { double x = Math.Floor(Convert.ToDouble(e.Value1) / 10); double y = Math.Floor(Convert.ToDouble(e.Value2) / 10); int res = Comparer <double> .Default.Compare(x, y); if (x > 19 && y > 19) { res = 0; } e.Result = res; e.Handled = true; }
protected void gridMainMonitor_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { try { if (e.Column.VisibleIndex >= 4) { if ((e.Value1 == null) && (e.Value2 == null)) { e.Result = 0; e.Handled = true; return; } else if (e.Value1 == null) { e.Result = -1; e.Handled = true; return; } else if (e.Value2 == null) { e.Result = 1; e.Handled = true; return; } decimal res1 = 0; decimal perc1 = 0; decimal res2 = 0; decimal perc2 = 0; this.CalculateMonitorValues( (decimal)e.Value1, (decimal)e.GetRow1Value("RecommendedPrice"), out res1, out perc1); this.CalculateMonitorValues( (decimal)e.Value2, (decimal)e.GetRow2Value("RecommendedPrice"), out res2, out perc2); if (res1 > res2) { e.Result = 1; } else if (res1 < res2) { e.Result = -1; } else { e.Result = 0; } e.Handled = true; } } catch (Exception ex) { Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error); } }
private void gridView_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column == colName) { var name1 = (e.Value1 ?? "").ToString(); var name2 = (e.Value2 ?? "").ToString(); if (name1.Length < 3 || name2.Length < 3) return; e.Result = String.Compare(name1.Substring(2), name2.Substring(2), StringComparison.CurrentCultureIgnoreCase); if (e.SortOrder == ColumnSortOrder.Descending) e.Result = -e.Result; e.Handled = true; } }
private void customColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column != _colGrouping.XtraColumn) { return; } var parameterDTO1 = e.RowObject1 as ParameterDTO; var parameterDTO2 = e.RowObject2 as ParameterDTO; if (parameterDTO1 == null || parameterDTO2 == null) { return; } e.Handled = true; e.Result = parameterDTO1.Sequence.CompareTo(parameterDTO2.Sequence); }
private void bandedGridView2_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { try { if (e.Column == Codigo2) { XTRATABPAGE8xx dr1 = bandedGridView2.GetRow(e.ListSourceRowIndex1) as XTRATABPAGE8xx; XTRATABPAGE8xx dr2 = bandedGridView2.GetRow(e.ListSourceRowIndex2) as XTRATABPAGE8xx; e.Handled = true; e.Result = System.Collections.Comparer.Default.Compare( String.Concat(dr1.Codigo2.Split(';').Select(s => s.PadLeft(5, '0'))), String.Concat(dr2.Codigo2.Split(';').Select(s => s.PadLeft(5, '0'))) ); } } catch { } }
protected void gridCustomers_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column != null & e.Column.FieldName == "City") { object country1 = e.GetRow1Value("Country"); object country2 = e.GetRow2Value("Country"); int res = Comparer.Default.Compare(country1, country2); if (res == 0) { object city1 = e.Value1; object city2 = e.Value2; res = Comparer.Default.Compare(city1, city2); } e.Result = res; e.Handled = true; } }
private void customColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column != _colGrouping.XtraColumn) { return; } var container1 = e.RowObject1 as ExpressionContainerDTO; var container2 = e.RowObject2 as ExpressionContainerDTO; if (container1 == null || container2 == null) { return; } e.Handled = true; e.Result = container1.Sequence.CompareTo(container2.Sequence); }
protected void GridOrderDetail_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { int s1 = Convert.ToInt32(e.GetRow1Value("SortShipper")); int s2 = Convert.ToInt32(e.GetRow2Value("SortShipper")); int v1 = Convert.ToInt32(e.GetRow1Value("ShipperID")); int v2 = Convert.ToInt32(e.GetRow2Value("ShipperID")); if (e.Column.FieldName == "ShipperID") { e.Result = s1.CompareTo(s2); if (e.Result == 0) { e.Result = v1.CompareTo(v2); } e.Handled = true; } }
/// <summary> /// 自定义排序 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gvRecRej_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Value1 == e.Value2) { return; } e.Handled = true; switch (e.SortOrder) { case ColumnSortOrder.Ascending: e.Result = -1; break; case ColumnSortOrder.Descending: e.Result = 1; break; } }
private void AssociatedObject_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { FileModel value1 = AssociatedObject.GetRowByListIndex(e.ListSourceRowIndex1) as FileModel; FileModel value2 = AssociatedObject.GetRowByListIndex(e.ListSourceRowIndex2) as FileModel; if (value1 == null || value2 == null) { return; } if (e.Column.FieldName == "Name") { if (value1.IsDrive == true && value2.IsDrive == true) { e.Result = value1.FullPath.CompareTo(value2.FullPath); e.Handled = true; } else if (value1.IsDirectory == value2.IsDirectory) { e.Result = SafeNativeMethods.NaturalCompare(value1.FullName, value2.FullName); e.Handled = true; } } else if (e.Column.FieldName == "ParentName") { if (value1.IsDirectory == value2.IsDirectory) { e.Result = SafeNativeMethods.NaturalCompare(value1.ParentName, value2.ParentName); e.Handled = true; } } if (value1.IsDirectory == true && value2.IsDirectory == false) { e.Result = e.SortOrder == ColumnSortOrder.Ascending ? -1 : 1; e.Handled = true; } else if (value2.IsDirectory == true && value1.IsDirectory == false) { e.Result = e.SortOrder == ColumnSortOrder.Ascending ? 1 : -1; e.Handled = true; } }
private int?DoCustomColumnSort(object sender, CustomColumnSortEventArgs e) { DateTime?date1 = GetBuildDate(e.Column, e.ListSourceRowIndex1); DateTime?date2 = GetBuildDate(e.Column, e.ListSourceRowIndex2); if (date1 == null && date2 == null) { return(null); } if (date1 == null) { return(-1); } if (date2 == null) { return(1); } int res = date1.Value.CompareTo(date2.Value); return(res); }
private void gridView_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column == colName) { var name1 = (e.Value1 ?? "").ToString(); var name2 = (e.Value2 ?? "").ToString(); if (name1.Length < 3 || name2.Length < 3) { return; } e.Result = String.Compare(name1.Substring(2), name2.Substring(2), StringComparison.CurrentCultureIgnoreCase); if (e.SortOrder == ColumnSortOrder.Descending) { e.Result = -e.Result; } e.Handled = true; } }
protected void grid_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName != "Objects") { return; } Type type1 = e.Value1.GetType(); Type type2 = e.Value2.GetType(); if ((type1 == type2) && (type1 == typeof(int))) { e.Handled = false; return; } int parseResult1; int parseResult2; bool value1IsNumber = Int32.TryParse(e.Value1.ToString() as string, out parseResult1); bool value2IsNumber = Int32.TryParse(e.Value2.ToString() as string, out parseResult2); e.Handled = true; if (value1IsNumber && !value2IsNumber) { e.Result = -1; } else if (!value1IsNumber && value2IsNumber) { e.Result = 1; } else if (value1IsNumber && value2IsNumber) { e.Result = parseResult1 < parseResult2 ? -1 : 1; } else { e.Handled = false; } }
protected void GridOrderDetail_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { int s1 = Convert.ToInt32(e.GetRow1Value("SortShipper")); int s2 = Convert.ToInt32(e.GetRow2Value("SortShipper")); int v1 = Convert.ToInt32(e.GetRow1Value("ShipperID")); int v2 = Convert.ToInt32(e.GetRow2Value("ShipperID")); if (e.Column.FieldName == "ShipperID") { if (v1 == v2) { e.Result = (s1 != s2) ? 1 : 0; } else { e.Result = 1; } e.Handled = true; } }
private void OrderGridView_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { e.Handled = true; if (e.Column.FieldName != "ShowCustomerDetail" && (_sortColumn != e.Column.FieldName || _sortColumn == e.Column.FieldName && _sortDirection != e.SortOrder) ) { if (_sortColumn != e.Column.FieldName) { _sortDirection = ColumnSortOrder.Ascending; } else if (_sortColumn == e.Column.FieldName && _sortDirection != e.SortOrder) { _sortDirection = e.SortOrder; } _sortColumn = e.Column.FieldName; _loadingRecords = true; LoadGridRecords(); } }
private void customColumnSort(object sender, CustomColumnSortEventArgs e) { if (!CustomSortEnabled) { return; } var parameterDTO1 = e.RowObject1 as ParameterDTO; var parameterDTO2 = e.RowObject2 as ParameterDTO; if (parameterDTO1 == null || parameterDTO2 == null) { return; } if (UseAdvancedSortingMode && _groupingIndexList.Any(pathColumn => parameterDTO1.PathElements[pathColumn] != parameterDTO2.PathElements[pathColumn])) { return; } e.Handled = true; e.Result = parameterDTO1.Sequence.CompareTo(parameterDTO2.Sequence); }
private void gridView1_CustomColumnSort(object sender,CustomColumnSortEventArgs e) { //try //{ // if (e.Column.FieldName == "colTRANDATE") // { // DataRowView dr1 = (gridView1.DataSource as DataView)[e.ListSourceRowIndex1]; // DataRowView dr2 = (gridView1.DataSource as DataView)[e.ListSourceRowIndex2]; // e.Handled = true; // e.Result = System.Collections.Comparer.Default.Compare(dr1["TRANDATE"], dr2["TRANDATE"]); // } //} //catch(Exception ex) //{ //} }
protected void gridMainMonitor_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { try { if (e.Column.VisibleIndex >= 4) { if ((e.Value1 == null) && (e.Value2 == null)) { e.Result = 0; e.Handled = true; return; } else if (e.Value1 == null) { e.Result = -1; e.Handled = true; return; } else if (e.Value2 == null) { e.Result = 1; e.Handled = true; return; } decimal res1 = 0; decimal perc1 = 0; decimal res2 = 0; decimal perc2 = 0; this.CalculateMonitorValues( (decimal)e.Value1, (decimal)e.GetRow1Value("RecommendedPrice"), out res1, out perc1); this.CalculateMonitorValues( (decimal)e.Value2, (decimal)e.GetRow2Value("RecommendedPrice"), out res2, out perc2); if (res1 > res2) e.Result = 1; else if (res1 < res2) e.Result = -1; else e.Result = 0; e.Handled = true; } } catch (Exception ex) { Logger.Log(string.Format("exception {0}", ex.ToString()), LogLevel.Error); } }
///<summary>Allows the controller to customize the column's sorting comparisons.</summary> protected internal virtual void CompareValues(CustomColumnSortEventArgs e) { }
///<summary>Raises the CustomColumnSort event.</summary> protected override void RaiseCustomColumnSort(CustomColumnSortEventArgs e) { base.RaiseCustomColumnSort(e); var column = e.Column as SmartGridColumn; if (column != null && column.Controller != null) column.Controller.CompareValues(e); }
private void gvServers_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column == this.colPing) { object val1 = this.gvServers.GetListSourceRowCellValue(e.ListSourceRowIndex1, colPing); object val2 = this.gvServers.GetListSourceRowCellValue(e.ListSourceRowIndex1, colPing); if (val1 == null) e.Result = val2 == null ? 0 : 1; else if (val2 == null) e.Result = -1; else e.Result = Comparer<int>.Default.Compare((int) val1, (int) val2); e.Handled = true; } }
private void gvCallLog_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName == "call_length") { if (e.SortOrder == DevExpress.Data.ColumnSortOrder.Ascending) { TimeSpan val1 = TimeSpan.Parse(e.Value1.ToString()); TimeSpan val2 = TimeSpan.Parse(e.Value2.ToString()); if (val1 == val2) { e.Result = 0; } else if (val1 < val2) { e.Result = -1; } else { e.Result = 1; } } else if (e.SortOrder == DevExpress.Data.ColumnSortOrder.Descending) { TimeSpan val1 = TimeSpan.Parse(e.Value1.ToString()); TimeSpan val2 = TimeSpan.Parse(e.Value2.ToString()); if (val1 == val2) { e.Result = 0; } else if (val1 < val2) { e.Result = 1; } else { e.Result = -1; } } } }
private void projectsGridView_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { int? res = DoCustomColumnSort(sender, e); if (res == null) return; e.Handled = true; e.Result = res.Value; }
private int? DoCustomColumnSort(object sender, CustomColumnSortEventArgs e) { DateTime? date1 = GetBuildDate(e.Column, e.ListSourceRowIndex1); DateTime? date2 = GetBuildDate(e.Column, e.ListSourceRowIndex2); if (date1 == null && date2 == null) return null; if (date1 == null) return -1; if (date2 == null) return 1; int res = date1.Value.CompareTo(date2.Value); return res; }
protected void GRIDITENSCONTRATO_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { atualizaGridItensContrato(); }
private void AssociatedObject_CustomColumnGroup(object sender, CustomColumnSortEventArgs e) { if (e.Column.FieldName == "Size") { long value1 = Convert.ToInt64(e.Value1); long value2 = Convert.ToInt64(e.Value2); int result = Comparer.Default.Compare(value1, value2); while (value1 > 0 && value2 > 0) { value1 = value1 / 1024; value2 = value2 / 1024; if (value1 == value2) { result = 0; } } e.Result = result; e.Handled = true; } else if (e.Column.FieldName == "Name") { string value1 = e.Value1.ToString(); string value2 = e.Value2.ToString(); e.Result = String.Compare(value1.Substring(0, 1), value2.Substring(0, 1), StringComparison.OrdinalIgnoreCase); if (Char.IsDigit(value1[0]) && Char.IsDigit(value2[0])) { e.Result = 0; } e.Handled = true; } else if (e.Column.FieldType == typeof(DateTime)) { DateTime value1 = Convert.ToDateTime(e.Value1); DateTime value2 = Convert.ToDateTime(e.Value2); switch (e.Column.GroupInterval) { case ColumnGroupInterval.Date: case ColumnGroupInterval.DateRange: e.Result = Comparer.Default.Compare(value1.Date, value2.Date); e.Handled = true; break; case ColumnGroupInterval.DateMonth: e.Result = value1.Year != value2.Year ? Comparer.Default.Compare(value1.Year, value2.Year) : Comparer.Default.Compare(value1.Month, value2.Month); e.Handled = true; break; case ColumnGroupInterval.DateYear: e.Result = Comparer.Default.Compare(value1.Year, value2.Year); e.Handled = true; break; } } }
private void gridView3_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { e.Handled = true; }
private void gvReplays_CustomColumnSort(object sender, CustomColumnSortEventArgs e) { if (e.Column.Name == this.gcRating.Name) { ReplayInfo row = this.gvReplays.GetRow(this.gvReplays.GetRowHandle(e.ListSourceRowIndex1)) as ReplayInfo; ReplayInfo info2 = this.gvReplays.GetRow(this.gvReplays.GetRowHandle(e.ListSourceRowIndex2)) as ReplayInfo; if (row.Rating < info2.Rating) { e.Result = -1; } else { e.Result = 1; } e.Handled = true; } else { e.Handled = false; } }