/// <summary> /// 车系查询数据 /// </summary> /// <param name="cxname"></param> /// <returns></returns> public List <CardInfo> CardInfoCxList(string cxname = "") { string str = $"select * from CardInfo a join CarSeries b on a.CarserId=b.CarserId where 1=1"; if (!string.IsNullOrEmpty(cxname)) { str += $" and a.CarserName like '%{cxname}%'"; } return(JcyDBHelper.GetList <CardInfo>(str)); }
/// <summary> /// 品牌查询数据 /// </summary> /// <param name="ppname"></param> /// <returns></returns> public List <CardInfo> CardInfoPPList(string ppname = "") { string str = $"select * from CardInfo a join Brand b on a.BrandId=b.BrandId where 1=1"; if (!string.IsNullOrEmpty(ppname)) { str += $" and a.BrandName like '%{ppname}%'"; } return(JcyDBHelper.GetList <CardInfo>(str)); }
/// <summary> /// 返填车辆信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public CardInfo ShowCardId(int id) { try { string str = $"select * from CardInfo a join CarAge b on a.AgeId = b.AgeId join Gearbox c on a.GearboxId = c.GearboxId join CarsVison d on a.CarsVisonId = d.CarsVisonId join Mileage e on a.MileageId = e.MileageId join Displacement f on a.DisplacementId = f.DisplacementId join Dischargenorm g on a.DisId = g.DisId join Seatnum h on a.SeatnumId = h.SeatnumId join FuelType i on a.FuelTypeId = i.FuelTypeId JOIN Colors j on a.ColorId = j.ColorId join Carnumlocation k on a.CarnumId = k.CarnumId join DriveType l on a.DriveTypeId = l.DriveTypeId join CountryDistinct m on a.CountryDisId = m.CountryDisId join BrightConfig n on a.ConfigId = n.ConfigId join Brand o on a.BrandId=o.BrandId join CarSeries p on a.CarserId=p.CarserId join CardPhoto z on a.CardId=z.PhotoId where a.CardId={id}"; var list = JcyDBHelper.GetList <CardInfo>(str).ToList(); if (list.Count > 0) { return(list.First()); } else { return(null); } } catch (Exception) { throw; } }
/// <summary> /// 热门筛选 /// </summary> /// <returns></returns> public Task <List <HotSizer> > HotSizerList() { string str = $"select * from HotSizer"; return(Task.FromResult(JcyDBHelper.GetList <HotSizer>(str))); }
/// <summary> /// 车龄 /// </summary> /// <returns></returns> public Task <List <CarAge> > GetCarAge() { string str = $"select * from CarAge"; return(Task.FromResult(JcyDBHelper.GetList <CarAge>(str))); }
/// <summary> /// 获取国别 /// </summary> /// <returns></returns> public Task <List <CountryDistinct> > CountryDistinctList() { string str = $"select * from CountryDistinct"; return(Task.FromResult(JcyDBHelper.GetList <CountryDistinct>(str))); }
/// <summary> /// 亮点配置 /// </summary> /// <returns></returns> public Task <List <BrightConfig> > BrightConfigList() { string str = $"select * from CountryDistinct"; return(Task.FromResult(JcyDBHelper.GetList <BrightConfig>(str))); }
/// <summary> /// 随机获取车系数据 /// </summary> /// <returns></returns> public List <CarSeries> GetCarSeries() { string str = $"SELECT * FROM CarSeries WHERE CarserId >= (SELECT floor(RAND() * (SELECT MAX(CarserId) FROM CarSeries))) ORDER BY CarserId LIMIT 0,8"; return(JcyDBHelper.GetList <CarSeries>(str)); }
/// <summary> /// 获取驱动类型 /// </summary> /// <returns></returns> public Task <List <DriveType> > DriveTypeList() { string str = $"select * from DriveType"; return(Task.FromResult(JcyDBHelper.GetList <DriveType>(str))); }
/// <summary> /// 查询下拉框获取车辆数据 /// </summary> /// <param name="agecard"></param> /// <param name="bsx"></param> /// <param name="cx"></param> /// <param name="kms"></param> /// <param name="pl"></param> /// <param name="pfbz"></param> /// <param name="zws"></param> /// <param name="rylx"></param> /// <param name="color"></param> /// <param name="cardszd"></param> /// <param name="qdlx"></param> /// <param name="countryb"></param> /// <param name="lightCoig"></param> /// <returns></returns> public List <CardInfo> CardInfoCofigList(string name = "", int brandId = 0, int CardId = 0, int priceId = 0, decimal startprice = 0, decimal endprice = 0, int agecard = 0, int bsx = 0, int cx = 0, int kms = 0, int pl = 0, int pfbz = 0, int zws = 0, int rylx = 0, int color = 0, int cardszd = 0, int qdlx = 0, int countryb = 0, int lightCoig = 0, int jg = 0) { var t = ""; if (jg == 1) { t = "a.Price"; } else if (jg == 2) { t = "a.AgeId"; } else if (jg == 3) { t = "a.MileageId"; } string str = $"select * from CardInfo a join CarAge b on a.AgeId = b.AgeId join Gearbox c on a.GearboxId = c.GearboxId join CarsVison d on a.CarsVisonId = d.CarsVisonId join Mileage e on a.MileageId = e.MileageId join Displacement f on a.DisplacementId = f.DisplacementId join Dischargenorm g on a.DisId = g.DisId join Seatnum h on a.SeatnumId = h.SeatnumId join FuelType i on a.FuelTypeId = i.FuelTypeId JOIN Colors j on a.ColorId = j.ColorId join Carnumlocation k on a.CarnumId = k.CarnumId join DriveType l on a.DriveTypeId = l.DriveTypeId join CountryDistinct m on a.CountryDisId = m.CountryDisId join BrightConfig n on a.ConfigId = n.ConfigId join Brand o on a.BrandId=o.BrandId join CarSeries p on a.CarserId=p.CarserId where 1 = 1"; if (!string.IsNullOrEmpty(name)) { str += $" and a.CardName like '%{name}%'"; } if (brandId > 0) { str += $" and o.BrandId={brandId}"; } if (CardId > 0) { str += $" and p.CarserId={CardId}"; } if (priceId == 1) { str += $" and a.Price<=3"; } if (priceId == 2) { str += $" and a.Price >= 3 and a.Price<=5"; } if (priceId == 3) { str += $" and a.Price>= 5 and a.Price<=7"; } if (priceId == 4) { str += $" and a.Price>=7 and a.Price<=9"; } if (priceId == 5) { str += $" and a.Price>=9 and a.Price<=12"; } if (priceId == 6) { str += $" and a.Price>=12 and a.Price<=16"; } if (priceId == 7) { str += $" and a.Price>=16 and a.Price<=20"; } if (priceId == 8) { str += $" and a.Price>20"; } if (startprice > 0 && endprice > 0) { str += $" and a.Price between {startprice} and {endprice}"; } if (agecard > 0) { str += $" and b.AgeId={agecard}"; } if (bsx > 0) { str += $" and c.GearboxId={bsx}"; } if (cx > 0) { str += $" and d.CarsVisonId={cx}"; } if (kms > 0) { str += $" and e.MileageId={kms}"; } if (pl > 0) { str += $" and f.DisplacementId={pl}"; } if (pfbz > 0) { str += $" and g.DisId={pfbz}"; } if (zws > 0) { str += $" and h.SeatnumId={zws}"; } if (rylx > 0) { str += $" and i.FuelTypeId={rylx}"; } if (color > 0) { str += $" and j.ColorId={color}"; } if (cardszd > 0) { str += $" and k.CarnumId={cardszd}"; } if (qdlx > 0) { str += $" and l.DriveTypeId={qdlx}"; } if (countryb > 0) { str += $" and m.CountryDisId={countryb}"; } if (lightCoig > 0) { str += $" and n.ConfigId={lightCoig}"; } if (jg != 0) { str += $" order by {t} desc"; } return(JcyDBHelper.GetList <CardInfo>(str)); }
/// <summary> /// 车系数据 /// </summary> /// <returns></returns> public List <CarSeries> GetCards() { string str = $"select * from CarSeries LIMIT 10"; return(JcyDBHelper.GetList <CarSeries>(str)); }
/// <summary> /// 获取排放标准 /// </summary> /// <returns></returns> public Task <List <Dischargenorm> > DischargenormList() { string str = $"select * from Dischargenorm"; return(Task.FromResult(JcyDBHelper.GetList <Dischargenorm>(str))); }
/// <summary> /// 获取座位数 /// </summary> /// <returns></returns> public Task <List <Seatnum> > SeatnumList() { string str = $"select * from Seatnum"; return(Task.FromResult(JcyDBHelper.GetList <Seatnum>(str))); }
/// <summary> /// 获取排量下拉 /// </summary> /// <returns></returns> public Task <List <Displacement> > DisplacementList() { string str = $"select * from Displacement"; return(Task.FromResult(JcyDBHelper.GetList <Displacement>(str))); }
/// <summary> /// 获取里程下拉 /// </summary> /// <returns></returns> public Task <List <Mileage> > MileageList() { string str = $"select * from Mileage"; return(Task.FromResult(JcyDBHelper.GetList <Mileage>(str))); }
/// <summary> /// 获取变速箱下拉 /// </summary> /// <param name="id"></param> /// <returns></returns> public List <Gearbox> GearboxList() { string str = $"select * from Gearbox"; return(JcyDBHelper.GetList <Gearbox>(str)); }
/// <summary> /// 根据id查询品牌对应的车系 /// </summary> /// <param name="id"></param> /// <returns></returns> public List <CarSeries> CarSeriesList(int id = 0) { string str = $"select b.CarserName from Brand a JOIN CarSeries b on a.BrandId=b.BrandId where 1=1 and a.BrandId={id}"; return(JcyDBHelper.GetList <CarSeries>(str)); }
/// <summary> /// 排序 /// </summary> /// <returns></returns> public List <CardInfo> GetdescInfo() { string str = $"select * from CardInfo a join CarAge b on a.AgeId = b.AgeId join Gearbox c on a.GearboxId = c.GearboxId join CarsVison d on a.CarsVisonId = d.CarsVisonId join Mileage e on a.MileageId = e.MileageId join Displacement f on a.DisplacementId = f.DisplacementId join Dischargenorm g on a.DisId = g.DisId join Seatnum h on a.SeatnumId = h.SeatnumId join FuelType i on a.FuelTypeId = i.FuelTypeId JOIN Colors j on a.ColorId = j.ColorId join Carnumlocation k on a.CarnumId = k.CarnumId join DriveType l on a.DriveTypeId = l.DriveTypeId join CountryDistinct m on a.CountryDisId = m.CountryDisId join BrightConfig n on a.ConfigId = n.ConfigId join Brand o on a.BrandId=o.BrandId join CarSeries p on a.CarserId=p.CarserId join CardPhoto z on a.CardId=z.PhotoId join CarsPrice y on a.CardId=y.CardId"; return(JcyDBHelper.GetList <CardInfo>(str)); }
/// <summary> /// 获取颜色 /// </summary> /// <returns></returns> public Task <List <Colors> > ColorsList() { string str = $"select * from Colors"; return(Task.FromResult(JcyDBHelper.GetList <Colors>(str))); }
/// <summary> /// 查询品牌 /// </summary> /// <returns></returns> public List <Brand> BrandsList() { string str = $"select * from Brand ORDER BY BrandId DESC LIMIT 10"; return(JcyDBHelper.GetList <Brand>(str)); }
/// <summary> /// 获取价格区间 /// </summary> /// <returns></returns> public List <CarsPrice> GetPrices() { string str = $"select * from CarsPrice"; return(JcyDBHelper.GetList <CarsPrice>(str)); }
/// <summary> /// 获取车牌所在地 /// </summary> /// <returns></returns> public Task <List <Carnumlocation> > CarnumlocationList() { string str = $"select * from Carnumlocation"; return(Task.FromResult(JcyDBHelper.GetList <Carnumlocation>(str))); }