/// <summary> /// 获取条件 /// </summary> /// <param name="query"></param> /// <returns></returns> public string GetMaddenWhere(CarMaddenQueryModel query) { #region 查询条件 var sqlWhere = new StringBuilder("1=1"); //在售和已售车辆 //是否删除 if (query.isdeleted != null) { sqlWhere.Append($" and a.isdeleted={query.isdeleted}"); } //状态 if (query.status != null) { sqlWhere.Append($" and a.status={query.status}"); } //省份 if (query.provid != null) { sqlWhere.Append($" and a.provid={query.provid}"); } //城市 if (query.cityid != null) { sqlWhere.Append($" and a.cityid={query.cityid}"); } //品牌 if (query.brand_id != null && query.brand_id != 0) { sqlWhere.Append($" and a.brand_id={query.brand_id}"); } //车系 if (query.series_id != null && query.series_id != 0) { sqlWhere.Append($" and a.series_id={query.series_id}"); } //车型 if (query.model_id != null && query.model_id != 0) { sqlWhere.Append($" and a.model_id={query.model_id}"); } sqlWhere.Append(""); return sqlWhere.ToString(); #endregion }
/// <summary> /// 查询劲爆车源列表 /// </summary> /// <param name="query">查询条件</param> /// <returns></returns> public BasePageList<CarMaddenListModel> GetMaddenCarPageList(CarMaddenQueryModel query) { const string spName = "sp_common_pager"; const string tableName = @"car_madden_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_province as pt on a.provid=pt.innerid left join base_city as ct on a.cityid=ct.innerid"; const string fields = "a.innerid,a.supplierid,a.carno,a.pictures,a.programme,a.guideprice,a.price,a.status,a.isdeleted,a.createdtime,a.brand_id,a.series_id,a.model_id,c1.brandname as brand_name,c2.seriesname as series_name,c3.modelname as model_name,pt.provname,ct.cityname"; var orderField = string.IsNullOrWhiteSpace(query.Order) ? "a.refreshtime desc" : query.Order; query.isdeleted = 0; var model = new PagingModel(spName, tableName, fields, orderField, GetMaddenWhere(query), query.PageSize, query.PageIndex); var list = Helper.ExecutePaging<CarMaddenListModel>(model, query.Echo); return list; }