本文整理汇总了C#中Rock.Model.FinancialTransactionService.OrderBy方法的典型用法代码示例。如果您正苦于以下问题：C# FinancialTransactionService.OrderBy方法的具体用法？C# FinancialTransactionService.OrderBy怎么用？C# FinancialTransactionService.OrderBy使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Rock.Model.FinancialTransactionService的用法示例。
在下文中一共展示了FinancialTransactionService.OrderBy方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BindGrid
//.........这里部分代码省略.........
// Credit Card Type
int creditCardTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Credit Card Type" ), out creditCardTypeId ) )
{
qry = qry.Where( t => t.FinancialPaymentDetail != null && t.FinancialPaymentDetail.CreditCardTypeValueId == creditCardTypeId );
}
// Source Type
int sourceTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Source Type" ), out sourceTypeId ) )
{
qry = qry.Where( t => t.SourceTypeValueId == sourceTypeId );
}
// Campus
if ( this.ContextEntity() == null )
{
var campus = CampusCache.Read( gfTransactions.GetUserPreference( "Campus" ).AsInteger() );
if ( campus != null )
{
qry = qry.Where( b => b.Batch != null && b.Batch.CampusId == campus.Id );
}
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if ( sortProperty != null )
{
if ( sortProperty.Property == "TotalAmount" )
{
if ( sortProperty.Direction == SortDirection.Ascending )
{
qry = qry.OrderBy( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.00M );
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.0M );
}
}
else
{
qry = qry.Sort( sortProperty );
}
}
else
{
// Default sort by Id if the transations are seen via the batch,
// otherwise sort by descending date time.
if ( ContextTypesRequired.Any( e => e.Id == batchEntityTypeId ) )
{
qry = qry.OrderBy( t => t.Id );
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDateTime ).ThenByDescending( t => t.Id );
}
}
var lTransactionImageField = gTransactions.ColumnsOfType<RockLiteralField>().FirstOrDefault( a => a.ID == "lTransactionImage" );
var summaryField = gTransactions.ColumnsOfType<RockBoundField>().FirstOrDefault( a => a.DataField == "Summary" );
var showImages = bddlOptions.SelectedValue.AsIntegerOrNull() == 1;
if ( lTransactionImageField != null)
{
lTransactionImageField.Visible = showImages;
}示例2: BindPaymentsGrid
/// <summary>
/// Binds the payments grid.
/// </summary>
private void BindPaymentsGrid()
{
int? instanceId = hfRegistrationInstanceId.Value.AsIntegerOrNull();
if ( instanceId.HasValue )
{
using ( var rockContext = new RockContext() )
{
var currencyTypes = new Dictionary<int, string>();
var creditCardTypes = new Dictionary<int, string>();
// If configured for a registration and registration is null, return
int registrationEntityTypeId = EntityTypeCache.Read( typeof( Rock.Model.Registration ) ).Id;
// Get all the registrations for this instance
PaymentRegistrations = new RegistrationService( rockContext )
.Queryable( "PersonAlias.Person,Registrants.PersonAlias.Person" ).AsNoTracking()
.Where( r =>
r.RegistrationInstanceId == instanceId.Value &&
!r.IsTemporary )
.ToList();
// Get the Registration Ids
var registrationIds = PaymentRegistrations
.Select( r => r.Id )
.ToList();
// Get all the transactions relate to these registrations
var qry = new FinancialTransactionService( rockContext )
.Queryable().AsNoTracking()
.Where( t => t.TransactionDetails
.Any( d =>
d.EntityTypeId.HasValue &&
d.EntityTypeId.Value == registrationEntityTypeId &&
d.EntityId.HasValue &&
registrationIds.Contains( d.EntityId.Value ) ) );
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = fPayments.GetUserPreference( "Date Range" );
if ( drp.LowerValue.HasValue )
{
qry = qry.Where( t => t.TransactionDateTime >= drp.LowerValue.Value );
}
if ( drp.UpperValue.HasValue )
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays( 1 );
qry = qry.Where( t => t.TransactionDateTime < upperDate );
}
SortProperty sortProperty = gPayments.SortProperty;
if ( sortProperty != null )
{
if ( sortProperty.Property == "TotalAmount" )
{
if ( sortProperty.Direction == SortDirection.Ascending )
{
qry = qry.OrderBy( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.00M );
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.0M );
}
}
else
{
qry = qry.Sort( sortProperty );
}
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDateTime ).ThenByDescending( t => t.Id );
}
gPayments.SetLinqDataSource( qry.AsNoTracking() );
gPayments.DataBind();
}
}
}示例3: BindGrid
//.........这里部分代码省略.........
{
qry = qry.Where( t => t.TransactionDateTime >= drp.LowerValue.Value );
}
if ( drp.UpperValue.HasValue )
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays( 1 );
qry = qry.Where( t => t.TransactionDateTime < upperDate );
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = gfTransactions.GetUserPreference( "Amount Range" );
if ( nre.LowerValue.HasValue )
{
qry = qry.Where( t => t.TransactionDetails.Sum( d => d.Amount ) >= nre.LowerValue.Value );
}
if ( nre.UpperValue.HasValue )
{
qry = qry.Where( t => t.TransactionDetails.Sum( d => d.Amount ) <= nre.UpperValue.Value );
}
// Transaction Code
string transactionCode = gfTransactions.GetUserPreference( "Transaction Code" );
if ( !string.IsNullOrWhiteSpace( transactionCode ) )
{
qry = qry.Where( t => t.TransactionCode == transactionCode.Trim() );
}
// Account Id
int accountId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Account" ), out accountId ) )
{
qry = qry.Where( t => t.TransactionDetails.Any( d => d.AccountId == accountId ) );
}
// Transaction Type
int transactionTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Transaction Type" ), out transactionTypeId ) )
{
qry = qry.Where( t => t.TransactionTypeValueId == transactionTypeId );
}
// Currency Type
int currencyTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Currency Type" ), out currencyTypeId ) )
{
qry = qry.Where( t => t.CurrencyTypeValueId == currencyTypeId );
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Credit Card Type" ), out creditCardTypeId ) )
{
qry = qry.Where( t => t.CreditCardTypeValueId == creditCardTypeId );
}
// Source Type
int sourceTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Source Type" ), out sourceTypeId ) )
{
qry = qry.Where( t => t.SourceTypeValueId == sourceTypeId );
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if ( sortProperty != null )
{
if ( sortProperty.Property == "TotalAmount" )
{
if ( sortProperty.Direction == SortDirection.Ascending )
{
qry = qry.OrderBy( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.00M );
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.0M );
}
}
else
{
qry = qry.Sort( sortProperty );
}
}
else
{
qry = qry.OrderBy( t => t.Id );
}
// Row Limit
int? rowLimit = gfTransactions.GetUserPreference( "Row Limit" ).AsIntegerOrNull();
if ( rowLimit.HasValue )
{
qry = qry.Take( rowLimit.Value );
}
gTransactions.DataSource = qry.AsNoTracking().ToList();
gTransactions.DataBind();
}示例4: BindGrid
//.........这里部分代码省略.........
queryable = queryable.Where( t => t.AuthorizedPersonId == _person.Id );
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = gfTransactions.GetUserPreference( "Date Range" );
if ( drp.LowerValue.HasValue )
{
queryable = queryable.Where( t => t.TransactionDateTime >= drp.LowerValue.Value );
}
if ( drp.UpperValue.HasValue )
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays( 1 );
queryable = queryable.Where( t => t.TransactionDateTime < upperDate );
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = gfTransactions.GetUserPreference( "Amount Range" );
if ( nre.LowerValue.HasValue )
{
queryable = queryable.Where( t => t.TransactionDetails.Sum( d => d.Amount ) >= nre.LowerValue.Value );
}
if ( nre.UpperValue.HasValue )
{
queryable = queryable.Where( t => t.TransactionDetails.Sum( d => d.Amount ) <= nre.UpperValue.Value );
}
// Transaction Code
string transactionCode = gfTransactions.GetUserPreference( "Transaction Code" );
if ( !string.IsNullOrWhiteSpace( transactionCode ) )
{
queryable = queryable.Where( t => t.TransactionCode == transactionCode.Trim() );
}
// Account Id
int accountId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Account" ), out accountId ) )
{
queryable = queryable.Where( t => t.TransactionDetails.Any( d => d.AccountId == accountId ) );
}
// Transaction Type
int transactionTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Transaction Type" ), out transactionTypeId ) )
{
queryable = queryable.Where( t => t.TransactionTypeValueId == transactionTypeId );
}
// Currency Type
int currencyTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Currency Type" ), out currencyTypeId ) )
{
queryable = queryable.Where( t => t.CurrencyTypeValueId == currencyTypeId );
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Credit Card Type" ), out creditCardTypeId ) )
{
queryable = queryable.Where( t => t.CreditCardTypeValueId == creditCardTypeId );
}
// Source Type
int sourceTypeId = int.MinValue;
if ( int.TryParse( gfTransactions.GetUserPreference( "Source Type" ), out sourceTypeId ) )
{
queryable = queryable.Where( t => t.SourceTypeValueId == sourceTypeId );
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if ( sortProperty != null )
{
if ( sortProperty.Property == "TotalAmount" )
{
if ( sortProperty.Direction == SortDirection.Ascending )
{
queryable = queryable.OrderBy( t => t.TransactionDetails.Sum( d => d.Amount ) );
}
else
{
queryable = queryable.OrderByDescending( t => t.TransactionDetails.Sum( d => d.Amount ) );
}
}
else
{
queryable = queryable.Sort( sortProperty );
}
}
else
{
queryable = queryable.OrderBy( t => t.TransactionDateTime );
}
gTransactions.DataSource = queryable.AsNoTracking().ToList();
gTransactions.DataBind();
}示例5: BindPaymentsGrid
/// <summary>
/// Binds the payments grid.
/// </summary>
private void BindPaymentsGrid()
{
if ( Registration != null )
{
using ( var rockContext = new RockContext() )
{
var currencyTypes = new Dictionary<int, string>();
var creditCardTypes = new Dictionary<int, string>();
int registrationEntityTypeId = EntityTypeCache.Read( typeof( Rock.Model.Registration ) ).Id;
// Get all the transactions related to this registration
var qry = new FinancialTransactionService( rockContext )
.Queryable().AsNoTracking()
.Where( t =>
t.TransactionDateTime.HasValue &&
t.TransactionDetails
.Any( d =>
d.EntityTypeId.HasValue &&
d.EntityTypeId.Value == registrationEntityTypeId &&
d.EntityId.HasValue &&
d.EntityId.Value == Registration.Id ) );
SortProperty sortProperty = gPayments.SortProperty;
if ( sortProperty != null )
{
if ( sortProperty.Property == "TotalAmount" )
{
if ( sortProperty.Direction == SortDirection.Ascending )
{
qry = qry.OrderBy( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.00M );
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDetails.Sum( d => (decimal?)d.Amount ) ?? 0.0M );
}
}
else
{
qry = qry.Sort( sortProperty );
}
}
else
{
qry = qry.OrderByDescending( t => t.TransactionDateTime ).ThenByDescending( t => t.Id );
}
gPayments.DataSource = qry.ToList().Select( p => new {
p.Id,
TransactionDateTime = p.TransactionDateTime.Value.ToShortDateString() + "<br/>" +
p.TransactionDateTime.Value.ToShortTimeString(),
Details = FormatDetails( p ),
p.TotalAmount });
gPayments.DataBind();
}
}
}示例6: BindGrid
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var queryable = new FinancialTransactionService().Queryable();
// Set up the selection filter
if ( _batch != null )
{
// If transactions are for a batch, the filter is hidden so only check the batch id
queryable = queryable.Where( t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id );
}
else
{
// otherwise set the selection based on filter settings
if ( _person != null )
{
queryable = queryable.Where( t => t.AuthorizedPersonId == _person.Id );
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = rFilter.GetUserPreference( "Date Range" );
if ( drp.LowerValue.HasValue )
{
queryable = queryable.Where( t => t.TransactionDateTime >= drp.LowerValue.Value );
}
if ( drp.UpperValue.HasValue )
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays( 1 );
queryable = queryable.Where( t => t.TransactionDateTime < upperDate );
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = rFilter.GetUserPreference( "Amount Range" );
if ( nre.LowerValue.HasValue )
{
queryable = queryable.Where( t => t.Amount >= nre.LowerValue.Value );
}
if ( nre.UpperValue.HasValue )
{
queryable = queryable.Where( t => t.Amount <= nre.UpperValue.Value );
}
// Transaction Code
string transactionCode = rFilter.GetUserPreference( "Transaction Code" );
if ( !string.IsNullOrWhiteSpace( transactionCode ) )
{
queryable = queryable.Where( t => t.TransactionCode == transactionCode.Trim() );
}
// Account Id
int accountId = int.MinValue;
if ( int.TryParse( rFilter.GetUserPreference( "Account" ), out accountId ) )
{
queryable = queryable.Where( t => t.TransactionDetails.Any( d => d.AccountId == accountId ) );
}
// Transaction Type
int transactionTypeId = int.MinValue;
if ( int.TryParse( rFilter.GetUserPreference( "Transaction Type" ), out transactionTypeId ) )
{
queryable = queryable.Where( t => t.TransactionTypeValueId == transactionTypeId );
}
// Currency Type
int currencyTypeId = int.MinValue;
if ( int.TryParse( rFilter.GetUserPreference( "Currency Type" ), out currencyTypeId ) )
{
queryable = queryable.Where( t => t.CurrencyTypeValueId == currencyTypeId );
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if ( int.TryParse( rFilter.GetUserPreference( "Credit Card Type" ), out creditCardTypeId ) )
{
queryable = queryable.Where( t => t.CreditCardTypeValueId == creditCardTypeId );
}
// Source Type
int sourceTypeId = int.MinValue;
if ( int.TryParse( rFilter.GetUserPreference( "Source Type" ), out sourceTypeId ) )
{
queryable = queryable.Where( t => t.SourceTypeValueId == sourceTypeId );
}
}
SortProperty sortProperty = rGridTransactions.SortProperty;
if ( sortProperty != null )
{
queryable = queryable.Sort( sortProperty );
}
else
{
queryable = queryable.OrderBy( t => t.TransactionDateTime );
}
rGridTransactions.DataSource = queryable.AsNoTracking().ToList();
//.........这里部分代码省略.........