/// <summary>获取角色列表 /// </summary> /// <param name="skip">跳过的记录数</param> /// <param name="count">获取的数量</param> /// <returns></returns> public List <RoleEntity> GetRoles(int skip, int pagesize, string RoleName, out int count) { StringBuilder sql = new StringBuilder(); sql.Append("select Id,Name,RightIds,IsSuper from t_roles "); if (!string.IsNullOrEmpty(RoleName)) { sql.Append(" where Name=@Name "); } if (pagesize != 0) { sql.Append(" Limit @count Offset @skip "); } SqlLiteHelper sqliteHelper = new SqlLiteHelper(); SQLiteParameter[] para = new SQLiteParameter[] { new SQLiteParameter("@count", pagesize), new SQLiteParameter("@skip", skip), new SQLiteParameter("@Name", RoleName) }; DataTable dataTable = sqliteHelper.GetDataTable(sql.ToString(), para); List <RoleEntity> roleEntities = new List <RoleEntity>(); foreach (DataRow dataRow in dataTable.Rows) { roleEntities.Add(Conver2Entity(dataRow)); } count = sqliteHelper.GetCount("t_roles"); return(roleEntities); }
public List <UserEntity> GetUsers(int skip, int pagesize, string userName, out int count) { StringBuilder sql = new StringBuilder(); sql.Append(" select Uid,Name,Photo,RolesIds,Status from t_users "); if (!string.IsNullOrEmpty(userName)) { sql.Append(" where Uid like @Uid "); } if (pagesize != 0) { sql.Append(" Limit @count Offset @skip "); } SQLiteParameter[] para = new SQLiteParameter[] { new SQLiteParameter("@count", pagesize), new SQLiteParameter("@skip", skip), new SQLiteParameter("@Uid", "%" + userName + "%") }; SqlLiteHelper sqliteHelper = new SqlLiteHelper(); DataTable dataTable = sqliteHelper.GetDataTable(sql.ToString(), para); List <UserEntity> userEntities = new List <UserEntity>(); foreach (DataRow dataRow in dataTable.Rows) { userEntities.Add(Conver2Entity(dataRow)); } count = sqliteHelper.GetCount("t_users"); return(userEntities); }