/// <summary>
/// 分页获得数据信息
/// </summary>
/// <param name="limit">页码大小</param>
/// <param name="offset">从第几条数据开始</param>
/// <param name="UserName">用户名</param>
/// <param name="Role">角色ID</param>
/// <returns></returns>
public JsonResult GetUserList(int limit, int offset, string UserName, string SelectItem, string UsersSelectItems)
{
Business.Sys_UserAdmin Sys_UserAdmin = new Business.Sys_UserAdmin();
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(UserName))
{
sb.Append(" and UserName='******'");
}
if (!string.IsNullOrEmpty(SelectItem))
{
sb.Append(" and RoleCode='" + SelectItem + "'");
}
if (!string.IsNullOrEmpty(UsersSelectItems))
{
sb.Append(" and charindex('," + UsersSelectItems + ",',','+cast(WorkUsersId as varchar)+',' )>0 ");
}
return(Json(new { total = Sys_UserAdmin.GetUserAdminListCount(sb.ToString()), rows = Sys_UserAdmin.UserAdminList(limit, offset, sb.ToString()) }, JsonRequestBehavior.AllowGet));
}