Example #1
0
        public SysRoleEntity GetById(int id)
        {
            string sql = "select * from  sys_role where id=@Id";

            return(SqlHelper.Query <SysRoleEntity>(sql, new { Id = id }).FirstOrDefault());
        }
Example #2
0
 public List <SysMenuEntity> GetUserPartMenu(string userCode, int mlevel)
 {
     return(SqlHelper.Query <SysMenuEntity>("p_getUserMenu", new { UserCode = userCode }, commandType: CommandType.StoredProcedure).ToList());
 }