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();
}
}
