public override UserEmoticonInfoCollection AdminGetUserEmoticonInfos(EmoticonFilter filter, int pageIndex, IEnumerable <Guid> excludeRoleIDs)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_UserEmoticonInfo";
query.Pager.PageSize = filter.Pagesize;
query.Pager.PageNumber = pageIndex;
query.Pager.SortField = "[UserID]";
if (filter.UserName == null)
{
filter.UserName = string.Empty;
}
if (filter.Order != null)
{
switch (filter.Order.Value)
{
case EmoticonFilter.OrderBy.SpaceSize:
query.Pager.SortField = "[TotalSizes]";
break;
case EmoticonFilter.OrderBy.EmoticonCount:
query.Pager.SortField = "[TotalEmoticons]";
break;
}
}
query.Pager.Condition = " Username LIKE '%'+@Username+'%'";
string excludeRoleUserIds = DaoUtil.GetExcludeRoleSQL("UserID", excludeRoleIDs, query);
if (!string.IsNullOrEmpty(excludeRoleUserIds))
{
query.Pager.Condition += " AND " + excludeRoleUserIds;
}
query.CreateParameter <string>("@Username", filter.UserName, SqlDbType.NVarChar, 50);
query.Pager.SelectCount = true;
query.Pager.PrimaryKey = "[UserID]";
query.Pager.IsDesc = filter.IsDesc;
using (XSqlDataReader reader = query.ExecuteReader())
{
UserEmoticonInfoCollection groups = new UserEmoticonInfoCollection(reader);
if (reader.NextResult())
{
if (reader.Read())
{
groups.TotalRecords = reader.Get <int>(0);
}
}
return(groups);
}
}
}
public override UserEmoticonInfoCollection AdminGetUserEmoticonInfos(EmoticonFilter filter, int pageIndex, IEnumerable<Guid> excludeRoleIDs)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_UserEmoticonInfo";
query.Pager.PageSize = filter.Pagesize;
query.Pager.PageNumber = pageIndex;
query.Pager.SortField = "[UserID]";
if (filter.UserName == null)
filter.UserName = string.Empty;
if (filter.Order != null)
{
switch (filter.Order.Value)
{
case EmoticonFilter.OrderBy.SpaceSize:
query.Pager.SortField = "[TotalSizes]";
break;
case EmoticonFilter.OrderBy.EmoticonCount:
query.Pager.SortField = "[TotalEmoticons]";
break;
}
}
query.Pager.Condition = " Username LIKE '%'+@Username+'%'";
string excludeRoleUserIds = DaoUtil.GetExcludeRoleSQL("UserID", excludeRoleIDs, query);
if (!string.IsNullOrEmpty(excludeRoleUserIds))
{
query.Pager.Condition += " AND " + excludeRoleUserIds;
}
query.CreateParameter<string>("@Username", filter.UserName, SqlDbType.NVarChar, 50);
query.Pager.SelectCount = true;
query.Pager.PrimaryKey = "[UserID]";
query.Pager.IsDesc = filter.IsDesc;
using (XSqlDataReader reader = query.ExecuteReader())
{
UserEmoticonInfoCollection groups = new UserEmoticonInfoCollection(reader);
if (reader.NextResult())
if (reader.Read())
groups.TotalRecords = reader.Get<int>(0);
return groups;
}
}
}
