public List <UserPVStatisticItem> QueryUserPVStatistic(QueryUserPVStatisticCriteria criteria)
{
if (criteria == null)
{
return(new List <UserPVStatisticItem>());
}
var customCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryUserPVStatistic");
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 <UserPVStatisticItem>());
}
}
public List <UserPVStatisticItem> QueryUserPVStatistic(QueryUserPVStatisticCriteria criteria)
{
var da = new StatisticDA();
List <UserPVStatisticItem> list = da.QueryUserPVStatistic(criteria);
if (list != null)
{
foreach (UserPVStatisticItem item in list)
{
UserInfo u = CPContext.GetUserInfoFromAD(item.UserId, CPContext.GetADDomain());
if (u != null && !string.IsNullOrWhiteSpace(u.FullName))
{
item.UserId = string.Format("{0} - {1} ({2})", u.UserID, u.FullName, u.Department);
}
}
}
return(list);
}
