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

        public BasePageList<CarInfoListViewModel> GetInterestList(CarInterestQueryModel query)
        {
            const string spName = "sp_common_pager";
            const string tableName = @"car_info as a
                                        left join base_carbrand as c1 on a.brand_id = c1.innerid
                                        left join base_carseries as c2 on a.series_id = c2.innerid
                                        left join base_carmodel as c3 on a.model_id = c3.innerid
                                        left join base_city as ct on a.cityid = ct.innerid
                                        inner join car_share as b on a.innerid = b.carid";
            const string fields =
                "a.innerid,a.custid,a.pic_url,a.price,a.buyprice,a.dealprice,a.buytime,a.status,a.mileage,a.register_date,c1.brandname as brand_name,c2.seriesname as series_name,c3.modelname as model_name,ct.cityname";
            var orderField = string.IsNullOrWhiteSpace(query.Order) ? "b.seecount" : query.Order;

            #region 查询条件

            var sqlWhere = new StringBuilder("a.seller_type<>3 and (a.status=1 or a.status=2)");

            sqlWhere.Append(
                $" and a.innerid <> '{query.carid}' and(a.series_id = {query.series_id} or(a.price > {query.price - 3 ?? 0} and a.price < {query.price + 5 ?? 0}) or(register_date > '{query.regdate?.AddMonths(-6) ?? DateTime.Now}' and register_date < '{query.regdate?.AddMonths(6) ?? DateTime.Now}'))");

            #endregion

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