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;
}