Пример #1
0
 /// <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));
 }
Пример #2
0
 /// <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));
 }
Пример #3
0
 /// <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));
 }