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;
}
}
}
public abstract UserEmoticonInfoCollection AdminGetUserEmoticonInfos(EmoticonFilter filter, int pageIndex, IEnumerable <Guid> excludeRoleIDs);
protected void Search()
{
EmoticonFilter filter = EmoticonFilter.GetFromForm();
filter.Apply("filter", "page");
}
/// <summary>
/// 获取分组
/// </summary>
/// <param name="operatorUserID"></param>
/// <param name="filter"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public UserEmoticonInfoCollection AdminGetUserEmoticonInfos(int operatorUserID, EmoticonFilter filter, int pageIndex)
{
if (!AllSettings.Current.BackendPermissions.HasPermissionForSomeone(operatorUserID, BackendPermissions.ActionWithTarget.Manage_Emoticon))
{
ThrowError(new NoPermissionManageEmoticonError());
return(null);
}
if (filter.Pagesize < 1)
{
filter.Pagesize = 20;
}
if (pageIndex < 1)
{
pageIndex = 1;
}
IEnumerable <Guid> excludeRoleIDs = AllSettings.Current.BackendPermissions.GetNoPermissionTargetRoleIds(operatorUserID, BackendPermissions.ActionWithTarget.Manage_Emoticon);
return(EmoticonDao.Instance.AdminGetUserEmoticonInfos(filter, pageIndex, excludeRoleIDs));
}
