/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarBrandEntity> QueryList(CarBrandEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,rid,url,brand AS BrandName,logo AS BrandLogo,tagname,add_time AS AddTime FROM hengtu_carbrand WHERE rid=@Rid AND url=@Url AND tagname=@TagName",
new { car.Rid, car.Url, car.TagName }, null));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarModelEntity> QueryList(CarModelEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,brandid AS BrandId,model AS ModelName, linkurl AS LinkUrl,factory,image AS ImagePath,add_time AS AddTime,national_reference_price AS NationalReferencePrice,msrp,second_hand AS SecondHand,displacement AS Displacement,fuel_consumption AS FuelConsumption,gearbox AS Gearbox,warranty AS Warranty,color_link AS ColorLink FROM hengtu_carmodel WHERE brandid=@BrandId AND linkurl=@LinkUrl",
new { car.BrandId, car.LinkUrl }, null));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarSeriesEntity> QueryList(CarSeriesEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,modelid AS ModelId,model AS SeriesName,linkurl AS LinkUrl,reference_price AS ReferencePrice,full_payment_reference AS FullPaymentReference,msrp AS Msrp,fuel_consumption AS FullPaymentReference,displacement AS Displacement,engine AS Engine,gearbox AS Gearbox,add_time AS AddTime FROM hengtu_carmodeldetail WHERE modelid=@ModelId AND linkurl=@LinkUrl",
new { car.ModelId, car.LinkUrl }, null));
}