public ActionResult Query(string condition)
{
CarSaleEntities context = new CarSaleEntities();
List<TempCar> list = new List<TempCar>();
IndexViewModel viewModel = new IndexViewModel();
var cars =
context.Car.Where(
c => c.BrandName.Contains(condition) || c.CarType.Contains(condition) || c.Color.Contains(condition));//根据输入的条件进行近似查找
foreach (var car in cars)
{
TempCar model = new TempCar();
int userid = car.UserInfo_ID;
var user = context.UserInfo.FirstOrDefault(u => u.ID == userid);
var img = context.CarImg.FirstOrDefault(i => i.CarID == car.ID);
model.ID = car.ID;
model.BrandName = car.BrandName;
model.CarType = car.CarType;
model.Color = car.Color;
model.Price = car.Price;
model.Status = car.Statu;
model.Year = car.Year;
if (user != null) model.UserName = user.RealName;
if (img != null) model.imgUrl = img.Imgurl;
list.Add(model);
}
viewModel.cars = list;
viewModel.queryStr = " ";
return View(viewModel);
}
/// <summary>
/// 主页展示出售车辆列表
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
CarSaleEntities context = new CarSaleEntities();
List<TempCar> list=new List<TempCar>();
CarBll carBll=new CarBll();
IndexViewModel viewModel=new IndexViewModel();
var cars=carBll.GetAllCars("在售", 1, 10);
foreach (var car in cars)
{
TempCar model=new TempCar();
int userid = car.UserInfo_ID;
var user=context.UserInfo.FirstOrDefault(u => u.ID == userid);
var img = context.CarImg.FirstOrDefault(i => i.CarID == car.ID);
model.ID = car.ID;
model.BrandName = car.BrandName;
model.CarType = car.CarType;
model.Color = car.Color;
model.Price = car.Price;
model.Status = car.Status;
model.Year = car.Year;
if (user != null) model.UserName = user.RealName;
if (img != null) model.imgUrl = img.Imgurl;
list.Add(model);
}
viewModel.cars = list;
viewModel.queryStr = " ";
return View(viewModel);
}