//public static readonly string sqlconnectionString = PubConstant.GetConnectionString("ConnectionStringForGameData"); //public static PagedList<UserClub> GetListByPage(GameRecordView msv) //{ // PagerQuery pq = new PagerQuery(); // pq.CurrentPage = msv.Page; // pq.PageSize = 10; // pq.RecordCount = DAL.PagedListDAL<UserClub>.GetRecordCount(string.Format(@"select count(0) from Role where ID = {0}", msv.UserID), sqlconnectionString); // pq.Sql = string.Format(@"select r.* from (select ID, NickName, ClubID, Agent from Role where ID = {2} order by ID desc limit {0}, {1}) as r", pq.StartRowNumber, pq.PageSize, msv.UserID); // PagedList<UserClub> obj = new PagedList<UserClub>(DAL.PagedListDAL<UserClub>.GetListByPage(pq, sqlconnectionString), pq.CurrentPage, pq.PageSize, pq.RecordCount); // return obj; //} public static IEnumerable <UserClub> GetRebate(GameRecordView model) { return(ClubDAL.GetRebate(model)); }