CCN.Modules.Activity.DataAccess.ActivityDataAccess.GetCrowdActivityPageList C# (CSharp) Метод

        public BasePageList<CrowdInfoListModel> GetCrowdActivityPageList(CrowdInfoQueryModel query)
        {
            const string spName = "sp_common_pager";
            const string tableName = @"activity_crow_info as a ";
            const string fields = @"innerid,flagcode, title, enrollstarttime, enrollendtime, secrettime, status, type, qrcode, createrid, createdtime,
                (select count(1) from activity_crow_player where flagcode=a.flagcode and isenabled=1) as playernum,
                (select sum(totalfee) from activity_crow_payrecord where flagcode=a.flagcode and ispay=1) as upperedtotal";
            var oldField = string.IsNullOrWhiteSpace(query.Order) ? " a.createdtime asc " : query.Order;

            var sqlWhere = new StringBuilder("");

            var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
            var list = Helper.ExecutePaging<CrowdInfoListModel>(model, query.Echo);
            return list;
        }