text/microsoft-resx
2.0
System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
using System;
using System.Web;
using System.Linq;
using System.Collections.Generic;
using System.Xml.Serialization;
using System.IO;
using System.Xml;
using DevExpress.Data.Filtering;
List<GroupField> _sortinParams = new List<GroupField>();
const string SortedColumnSuffix_Ascending = " ▼";
const string SortedColumnSuffix_Descending = " ▲";
private void ReportBase_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {
if (this.Parameters.Any<DevExpress.Data.IParameter>(t=>t.Name == "__RPT_BASE_PARAM_SORT_FIELD") &&
this.Parameters.Any<DevExpress.Data.IParameter>(t=>t.Name == "__RPT_BASE_PARAM_SORT_DIR"))
{
var keysXml = (string)this.Parameters["__RPT_BASE_PARAM_SORT_FIELD"].Value;
var valuesXml = (string)this.Parameters["__RPT_BASE_PARAM_SORT_DIR"].Value;
if (!string.IsNullOrWhiteSpace(keysXml) && !string.IsNullOrWhiteSpace(valuesXml))
{
var keys = Deserialize<List<string>>(keysXml);
var values = Deserialize<List<bool>>(valuesXml);
if (keys != null && values != null && keys.Count > 0 && keys.Count == values.Count)
for (var i=0; i<keys.Count; i++)
{
_sortinParams.Add(new GroupField(keys[i], values[i] ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending));
}
}
Detail.SortFields.Clear();
Detail.SortFields.AddRange(_sortinParams.ToArray());
}
}
private void ReportBase_DataSourceDemanded(object sender, System.EventArgs e) {
// List<CriteriaOperator> operators = new List<CriteriaOperator>();
// setup param default values here
// Example Code: Guid[] teams = new Guid[0];
// get param values if not empty
// Example Code: if (this.Parameters["Team"] != null)
// Example Code: {
// Example Code: teams = (Guid[])this.Parameters["Team"].Value;
// Example Code: }
// build filter operators using for not default values
// Example Code: if (teams.Length > 0)
// Example Code: {
// Example Code: operators.Add(new InOperator("TeamId", teams));
// Example Code: }
// convert filter operators to filterstring
// Example Code: GroupOperator collection = new GroupOperator(GroupOperatorType.And, operators);
// add cost saving type filter
// Example Code: this.FilterString = collection.ToString();
}
public void HeaderCell_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
XRLabel headerCell = sender as XRLabel;
string fieldName = (string)headerCell.Tag;
GroupField sort = _sortinParams.Find(sortField => sortField.FieldName == fieldName);
// рисуем иконку направления сортировки, если это поле перечислено в _sortinParams сво-ве
headerCell.Text = headerCell.Text.Replace(SortedColumnSuffix_Ascending, "");
headerCell.Text = headerCell.Text.Replace(SortedColumnSuffix_Descending, "");
if (sort != null)
{
headerCell.Text += (sort.SortOrder == XRColumnSortOrder.Ascending)
? SortedColumnSuffix_Ascending
: SortedColumnSuffix_Descending;
}
headerCell.NavigateUrl = String.Format("javascript:void('{0}')", headerCell.Tag);
}
public T Deserialize<T>(string input) where T : class
{
System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(typeof(T));
using (StringReader sr = new StringReader(input))
return (T)ser.Deserialize(sr);
}