public CarMaddenViewModel GetMaddenCarViewById(string innerid)
{
const string sql = @"select
a.innerid, a.supplierid, a.carno, a.pictures, a.provid, a.cityid, a.brand_id, a.series_id, a.model_id, a.colorid, a.programme, a.programmedesc, a.guideprice,
a.price, a.dealprice, a.dealtime, a.dealdesc, a.deletedtime, a.deletedesc, a.estimateprice, a.status, a.isdeleted, a.createdtime, a.modifiedtime, a.refreshtime, a.remark, a.operatedid,
pr.provname,
ct.cityname,
cb.brandname as brand_name,
cs.seriesname as series_name,
cm.modelname as model_name,
cm.liter,
cm.geartype,
cm.dischargestandard as dischargeName,
bc1.codename as color
from car_madden_info as a
left join base_province as pr on a.provid=pr.innerid
left join base_city as ct on a.cityid=ct.innerid
left join base_carbrand as cb on a.brand_id=cb.innerid
left join base_carseries as cs on a.series_id=cs.innerid
left join base_carmodel as cm on a.model_id=cm.innerid
left join base_code as bc1 on a.colorid=bc1.codevalue and bc1.typekey='car_color'
where a.innerid=@innerid;";
try
{
var list = Helper.Query<CarMaddenViewModel>(sql, new { innerid }).FirstOrDefault();
return list;
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("根据id获取劲爆车源的信息异常:", TraceEventType.Information, ex);
return null;
}
}