Esempio n. 1
0
        /// <summary>
        /// 根据roleType查出List<SecRoleEntity>, Add by Alex on 2010.3.20
        /// </summary>
        /// <param name="roleType"></param>
        /// <returns></returns>
        public static List <SecRoleEntity> GetRoleEntityByRoleType(string roleType)
        {
            List <SecRoleEntity> roleEntityList = new List <SecRoleEntity>();
            string       sql = "select * from " + SecRoleTable.C_TableName;
            WhereBuilder wb  = new WhereBuilder(sql);

            wb.FixFirstCondition = true;
            wb.AddAndCondition("1", "1");
            //根据RoleName来排序
            string sqlExtends = " order by " + SecRoleTable.C_TableName + "." + SecRoleTable.C_ROLE_NAME;

            wb.AddCondition(sqlExtends);
            roleEntityList = DataAccess.Select <SecRoleEntity>(wb);
            return(roleEntityList);
        }