Example #1
0
        //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));
        }