public static IList <LoginUserLimit> getAllNodeById(int id) { string sql = "SELECT a.* FROM LoginUserLimit a,Menu b WHERE a.NodeId = b.NodeId and a.loginId = " + id + ""; return(LoginUserLimitService.getLoginUserLimitsBySql(sql));//LoginLimitService.getLoginLimitsBySql(sql); }
public static IList <LoginUserLimit> GetUserLimitByIdAndParentNodeId(int id, int parentNodeId) { string sql = "SELECT a.* FROM LoginUserLimit a,Menu b WHERE a.NodeId = b.NodeId and b.ParentNodeId=" + parentNodeId + " and a.loginId = " + id + ""; return(LoginUserLimitService.getLoginUserLimitsBySql(sql)); }