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

        public BasePageList<CrowdPlayerListModel> GetPlayerPageList(CrowdPlayerQueryModel query)
        {
            const string spName = "sp_common_pager";
            const string tableName = @"activity_crow_player as a ";
            const string fields = @"innerid, wechatnick, wechatheadportrait, mobile, openid, flagcode, isenabled, iswinning,
                                    (select      count(1) from activity_crow_payrecord where flagcode=a.flagcode and openid=a.openid and ispay=1) as paynum,
                                    (select sum(totalfee) from activity_crow_payrecord where flagcode=a.flagcode and openid=a.openid and ispay=1) as totalfee";
            var oldField = string.IsNullOrWhiteSpace(query.Order) ? " a.createdtime desc " : query.Order;

            var sqlWhere = new StringBuilder($" a.flagcode='{query.Flagcode}' ");

            if (!string.IsNullOrWhiteSpace(query.Wechatnick))
            {
                sqlWhere.Append($" and a.wechatnick like '%{query.Wechatnick}%'");
            }
            if (query.Iswinning == 1)
            {
                sqlWhere.Append(" and a.iswinning=1");
            }
            var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
            var list = Helper.ExecutePaging<CrowdPlayerListModel>(model, query.Echo);
            return list;
        }