/// <summary>
/// 获取车型列表
/// </summary>
/// <param name="query">查询条件</param>
/// <returns></returns>
public BasePageList<BaseCarModelListViewModel> GetCarModelList(BaseCarModelQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"base_carmodel as a left join base_carseries as b on a.seriesid=b.innerid left join base_carbrand c on b.brandid=c.innerid";
const string fields = " a.innerid,modelname,modelprice,modelyear,minregyear,maxregyear,liter,geartype,dischargestandard,seriesid,a.isenabled,ifnull(a.remark,'') remark,b.seriesname,c.brandname";
var orderField = string.IsNullOrWhiteSpace(query.Order) ? " innerid asc" : query.Order;
//查詢條件
var sqlWhere = new StringBuilder(" 1=1 ");
if (!string.IsNullOrWhiteSpace(query.Modelname))
{
sqlWhere.Append($" and modelname like '%{query.Modelname}%'");
}
if (!string.IsNullOrWhiteSpace(query.BrandId))
{
sqlWhere.Append($" and c.innerid = '{query.BrandId}'");
}
if (!string.IsNullOrWhiteSpace(query.SeriesId))
{
sqlWhere.Append($" and b.innerid = '{query.SeriesId}'");
}
var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
var list = Helper.ExecutePaging<BaseCarModelListViewModel>(model, query.Echo);
return list;
}
