public List <ActionStatisticItem> QueryActionStatistic(QueryActionStatisticCriteria criteria)
{
if (criteria == null)
{
return(new List <ActionStatisticItem>());
}
var customCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryActionStatistic");
using (var sqlBuilder = new DynamicQuerySqlBuilder(customCommand.CommandText, customCommand, new Framework.Entity.PagingInfoEntity(), "InDate DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Url", DbType.AnsiString,
"@Url", QueryConditionOperatorType.Equal,
criteria.Url);
if (criteria.DateFrom.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "InDate", DbType.DateTime,
"@InDateFrom", QueryConditionOperatorType.MoreThanOrEqual,
criteria.DateFrom.Value);
}
if (criteria.DateTo.HasValue)
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "InDate", DbType.DateTime,
"@InDateTo", QueryConditionOperatorType.LessThan,
criteria.DateTo.Value.AddDays(1));
}
customCommand.CommandText = sqlBuilder.BuildQuerySql();
return(customCommand.ExecuteEntityList <ActionStatisticItem>());
}
}
public List <ActionStatisticItem> QueryActionStatistic(QueryActionStatisticCriteria criteria)
{
var da = new StatisticDA();
return(da.QueryActionStatistic(criteria));
}
