public static List <SysMenuPoint> GetByMenuCode(string menuCode) { var sql = @" Select * From SysMenuPoint Where MenuCode = @MenuCode "; return(DbHelper.GetModels <SysMenuPoint>(sql, new DbField("MenuCode", menuCode))); }
public static List <SysMenu> GetMenus() { var sql = @" Select menu.* From SysMenu menu Where menu.IsDeleted = 0; "; return(DbHelper.GetModels <SysMenu>(sql)); }
public static List <VideoMark> GetByMainId(string mainId) { var sql = @" Select mark.*,owner.Name as _OwnerName From VideoMark mark Join BasOwner owner on owner.Id = mark.OwnerId Where mark.MainId = @mainId "; return(DbHelper.GetModels <VideoMark>(sql, new DbField("mainId", mainId))); }
public static List <VideoCommentUpdown> GetByCommentId(string commentId) { var sql = @" Select updown.*,owner.Name as _OwnerName From VideoCommentUpdown updown Join BasOwner owner on owner.Id = updown.OwnerId Where updown.CommentId = @commentId "; return(DbHelper.GetModels <VideoCommentUpdown>(sql, new DbField("commentId", commentId))); }
public static List <VideoComment> GetByMainId(string mainId) { var sql = @" Select comment.*,owner.Name as _OwnerName From VideoComment comment Join BasOwner owner on owner.Id = comment.OwnerId Where comment.MainId = @mainId "; return(DbHelper.GetModels <VideoComment>(sql, new DbField("mainId", mainId))); }
public static List <SysUser> GetUnSelectedUser(string roleId) { var sql = @" select user.* from SysUser user left Join SysUserRole userRole on userRole.UserId = user.Id and userRole.RoleId = @roleId where userRole.UserId is null "; return(DbHelper.GetModels <SysUser>(sql, new DbField("roleId", roleId))); }
public static List <SysMenuPoint> GetByUserId(long userId) { var sql = @" Select point.* From SysMenuPoint point Join SysRoleMenuPoint rolePoint On rolePoint.MenuCode = point.MenuCode And rolePoint.PointCode = point.Code Join SysUserRole userRole On userRole.RoleId = rolePoint.RoleId Where userRole.UserId = @userId; "; return(DbHelper.GetModels <SysMenuPoint>(sql, new DbField("userId", userId))); }
public static dynamic GetRoleRightMenu(string roleid) { List <dynamic> RightMenu = new List <dynamic>(); var sql1 = @" select A.*, Case When ifnull(B.MenuCode,1) then 0 else 1 end as checked from SysMenu A left join SysRoleMenu B on A.Code=B.MenuCode and B.roleid=@roleid order by A.Seq asc "; var sql2 = @" select A.*, Case When ifnull(B.MenuCode,1) then 0 else 1 end as checked from SysMenuPoint A left join SysRoleMenuPoint B on A.MenuCode=B.MenuCode and A.Code=B.PointCode and B.RoleId=@roleid order by A.Seq asc "; RightMenu.Add(DbHelper.GetModels <dynamic>(sql1, new DbField("roleid", roleid))); RightMenu.Add(DbHelper.GetModels <dynamic>(sql2, new DbField("roleid", roleid))); return(RightMenu); }
public static List <SysMenuPoint> GetByUserId(long userId) { var user = new SysUserService().GetModel("Id", userId + ""); var sql = @" Select point.* From SysMenuPoint point Join SysRoleMenuPoint rolePoint On rolePoint.MenuCode = point.MenuCode And rolePoint.PointCode = point.Code Join SysUserRole userRole On userRole.RoleId = rolePoint.RoleId Where userRole.UserId = @userId; "; if (user != null && user.Account == "admin") { sql = @" Select * From SysMenuPoint "; } return(DbHelper.GetModels <SysMenuPoint>(sql, new DbField("userId", userId))); }