Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        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);
        }