public List <PVStatisticItem> QueryPVStatistic(QueryPVStatisticCriteria criteria)
{
if (criteria == null)
{
return(new List <PVStatisticItem>());
}
var customCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryPVStatistic");
using (var sqlBuilder = new DynamicQuerySqlBuilder(customCommand.CommandText, customCommand, new Framework.Entity.PagingInfoEntity(), "InDate DESC"))
{
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();
customCommand.ReplaceParameterValue("#LanguageCode#", string.Format("'{0}'", Thread.CurrentThread.CurrentCulture.Name));
return(customCommand.ExecuteEntityList <PVStatisticItem>());
}
}
public List <PVStatisticItem> QueryPVStatistic(QueryPVStatisticCriteria criteria)
{
var da = new StatisticDA();
return(da.QueryPVStatistic(criteria));
}
