CCN.Modules.Car.DataAccess.CarDataAccess.GetBoutiquePageList C# (CSharp) Method

        public BasePageList<CarBoutiqueListModel> GetBoutiquePageList(CarBoutiqueQueryModel query)
        {
            const string spName = "sp_common_pager";
            const string tableName = @"boutique_info as a
                                    inner join cust_info as b on b.innerid=a.custid ";
            const string fields =
                "a.innerid,a.enterprisename,a.logo,a.telephone,a.mobile,a.address,a.tempid, a.createdtime, a.createrid, a.modifiedtime, a.modifierid";
            var orderField = string.IsNullOrWhiteSpace(query.Order) ? "a.sort desc, a.createdtime desc" : query.Order;
            var sqlWhere = new StringBuilder(" b.type=3 ");

            //省份
            if (query.Provid != null)
            {
                sqlWhere.Append($" and b.provid={query.Provid}");
            }

            //城市
            if (query.Cityid != null)
            {
                sqlWhere.Append($" and b.cityid={query.Cityid}");
            }

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