/// <summary>
/// 角色分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>结果</returns>
public IEnumerable <MRole> QueryRolesByPaging(TRoleCondition condition)
{
this.ClearParameters();
StringBuilder sqlCondition = new StringBuilder();
if (!string.IsNullOrWhiteSpace(condition.RoleName))
{
sqlCondition.Append(" AND RoleName = @RoleName ");
this.AddParameter("@RoleName", condition.RoleName);
}
if (!string.IsNullOrWhiteSpace(condition.RoleDescription))
{
sqlCondition.Append(" AND RoleDescription = @RoleDescription ");
this.AddParameter("@RoleDescription", condition.RoleDescription);
}
if (condition.GetRowsCount)
{
string sqlCount = "SELECT COUNT(0) FROM Role WHERE 1 = 1 " + sqlCondition + ";";
object obj = this.ExecuteScalar(sqlCount);
condition.RowsCount = obj == null ? 0 : Convert.ToInt32(obj);
}
string sqlData = string.Format("SELECT TOP {0} * FROM Role WHERE Id NOT IN( SELECT TOP {1} Id FROM Role);", condition.PageSize, condition.StratRows);
this.AddParameter("@StratRows", condition.StratRows);
this.AddParameter("@PageSize", condition.PageSize);
return(this.BuildEntitiesFromSql(sqlData));
}
/// <summary>
/// 角色分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>结果</returns>
public static IEnumerable <TRole> QueryRolesByPagings(TRoleCondition condition)
{
using (var roleRepository = DbContext.CreateIRoleRepository())
{
var data = roleRepository.QueryRolesByPaging(condition).ToTRole();
return(data);
}
}
/// <summary>
/// 角色分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>结果</returns>
public static EsayUIQueryResult <TRole> QueryRolesByPaging(TRoleCondition condition)
{
using (var roleRepository = DbContext.CreateIRoleRepository())
{
var data = roleRepository.QueryRolesByPaging(condition).ToTRole();
EsayUIQueryResult <TRole> roles = new EsayUIQueryResult <TRole>
{
rows = data,
total = condition.RowsCount
};
return(roles);
}
}
/// <summary>
/// 角色分页查询
/// </summary>
/// <param name="condition">查询条件</param>
/// <returns>结果</returns>
public static QueryResult <TRole> QueryRolesByPaging(TRoleCondition condition)
{
using (var roleRepository = DbContext.CreateIRoleRepository())
{
var data = roleRepository.QueryRolesByPaging(condition).ToTRole();
QueryResult <TRole> roles = new QueryResult <TRole>
{
Data = data,
Paging = condition.Paging
};
return(roles);
}
}
public ActionResult RoleList(TRoleCondition condition)
{
if (condition != null)
{
IEnumerable <TRole> data = RoleService.QueryRolesByPagings(condition);
PagedList <TRole> pageList = new PagedList <TRole>(data, condition.PageIndex, condition.PageSize, condition.RowsCount);
ViewModel <TRoleCondition, PagedList <TRole> > result = new ViewModel <TRoleCondition, PagedList <TRole> >
{
Condition = condition,
Data = pageList
};
return(this.View(result));
}
else
{
return(this.View());
}
}
public IActionResult RoleListVal([FromBody] TRoleCondition condition)
{
var data = RoleService.QueryRolesByPaging(condition);
return(MyJson(data));
}
public JsonResult RoleListVal(TRoleCondition condition)
{
var data = RoleService.QueryRolesByPaging(condition);
return(Json(data));
}
