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> /// 根据传来的id删除用户的权限 /// </summary> /// <returns></returns> public int RemoveRoleUserInfo(int id) { using (CarSaleEntities context=new CarSaleEntities()) { var item = context.RoleUserInfo.FirstOrDefault(r => r.ID == id); context.DeleteObject(item); context.SaveChanges(); return 1; } }
/// <summary> /// 根据Order的ID获取一个Order /// </summary> /// <returns></returns> public OrderModel GetOrderById(int id) { CarSaleEntities context=new CarSaleEntities(); var order = context.Order.FirstOrDefault(o=>o.ID==id); OrderModel model=new OrderModel(); model.ID = order.ID; model.BuyManID = order.BuyManID; model.CarID = order.CarID; model.Date = order.Date; model.Price = order.Price; model.SaleManID = order.SaleManID; return model; }
public int CheckUser(string userName, string password) { CarSaleEntities context=new CarSaleEntities(); var user=context.UserInfo.FirstOrDefault(u => u.UserName == userName&&u.Pwd==password); if (user==null) { return 0; } else { return 1; } }
/// <summary> /// 向该角色添加一个已有的用户 /// </summary> /// <param name="roleName"></param> /// <param name="userID"></param> /// <returns></returns> public int AddExitUser(string roleName,int userID) { using (CarSaleEntities context = new CarSaleEntities()) { var role = context.Role.FirstOrDefault(r => r.RoleName == roleName); RoleUserInfo newitem = new RoleUserInfo(); newitem.RoleID = role.ID; newitem.UserID = userID; context.AddToRoleUserInfo(newitem); context.SaveChanges(); return 1; } }
/// <summary> /// 在角色分配页面向该角色添加一个用户,RoleUserInfo表,UserInfo表都要新增一条记录 /// </summary> /// <returns></returns> public int AddUser(string roleName,string userName,string realName) { CarSaleEntities context=new CarSaleEntities(); UserInfoBll bll=new UserInfoBll(); bll.AddUserInfo(userName, realName, "123456", " ", " ", " ", " ", " ", 1, " "); var user = context.UserInfo.FirstOrDefault(u => u.UserName == userName); var role = context.Role.FirstOrDefault(r => r.RoleName == roleName); RoleUserInfo newitem=new RoleUserInfo(); newitem.RoleID = role.ID; newitem.UserID = user.ID; context.AddToRoleUserInfo(newitem); context.SaveChanges(); return 1; }
/// <summary> /// 已出售的车辆状态修改为“已售” /// </summary> /// <param name="id"></param> /// <returns></returns> public int ChageCarStatusToSold(int id) { try { CarSaleEntities context = new CarSaleEntities(); var car = context.Car.FirstOrDefault(c => c.ID == id); car.Statu = "已售"; context.SaveChanges(); return 1; } catch (Exception) { return 0; } }
/// <summary> /// 根据角色名查询出具有该角色权限的用户列表 /// </summary> /// <param name="roleName"></param> /// <returns></returns> public ActionResult GetUserByRoleName(string roleName) { CarSaleEntities context=new CarSaleEntities(); int roleID = context.Role.FirstOrDefault(r => r.RoleName == roleName).ID; var roleUserInfo=context.RoleUserInfo.Where(p => p.RoleID == roleID); List<UserInfoModel> list=new List<UserInfoModel>(); foreach (var item in roleUserInfo) { UserInfoModel model=new UserInfoModel(); var user = context.UserInfo.FirstOrDefault(u => u.ID == item.UserID); model.ID = item.ID; model.UserName = user.UserName; model.RealName = user.RealName; list.Add(model); } return Json(list); }
/// <summary> /// 获取该用户的成交记录(卖家) /// </summary> /// <param name="userid"></param> /// <returns></returns> public List<DealModel> GetDealsByUserId(int userid) { CarSaleEntities context=new CarSaleEntities(); List<DealModel> list=new List<DealModel>(); var deals=context.Deal.Where(d => d.SaleManID == userid); foreach (var deal in deals) { DealModel model=new DealModel(); model.ID = deal.ID; model.BuyManID = deal.BuyManID; model.CarID = deal.CarID; model.Price = deal.Price; model.SaleManID = deal.SaleManID; model.Time = deal.Time; list.Add(model); } return list; }
public UserInfoModel GetUserById(int id) { CarSaleEntities context=new CarSaleEntities(); var user=context.UserInfo.FirstOrDefault(u => u.ID == id); UserInfoModel model=new UserInfoModel(); model.ID = id; model.UserName = user.UserName; model.RealName = user.RealName; model.Password = user.Pwd; model.Phone = user.Phone; model.IdCard = user.IdCard; model.Sex = user.Sex; model.Email = user.Email; model.QQ = user.QQ; model.Level = user.Level; model.Address = user.Address; return model; }
public List<OrderModel> GetOrdersByUserId(int userid) { CarSaleEntities context=new CarSaleEntities(); var orders=context.Order.Where(o => o.BuyManID == userid); List<OrderModel> list=new List<OrderModel>(); foreach (var order in orders) { OrderModel model = new OrderModel(); model.ID = order.ID; model.BuyManID = order.BuyManID; model.CarID = order.CarID; model.Date = order.Date; model.Price = order.Price; model.SaleManID = order.SaleManID; list.Add(model); } return list; }
/// <summary> /// 新添加一条车辆出售记录 /// </summary> /// <param name="brand"></param> /// <param name="carType"></param> /// <param name="price"></param> /// <param name="color"></param> /// <param name="year"></param> /// <returns></returns> public ActionResult AddCar(string brand,string carType,decimal price,string color,int year) { var session = Session["logID"]; if (session==null) { return RedirectToAction("Login", "Home"); } else { //================================================================= int userid = Int32.Parse(session.ToString()); CarBll bll=new CarBll(); int result = bll.AddCar(userid, brand, carType, price, color, year, "在售"); if (result==1) { CarSaleEntities context=new CarSaleEntities(); var car = context.Car.OrderByDescending(c => c.ID).First(); int carid = car.ID;//获取车辆ID HttpPostedFileBase file = Request.Files["file1"];//获取提交上来的图片文件 //存入文件 if (file.ContentLength > 0) { file.SaveAs(Server.MapPath("~/CarImgs/") + System.IO.Path.GetFileName(file.FileName)); string url = System.IO.Path.GetFileName(file.FileName); CarImgBll imgBll = new CarImgBll(); imgBll.AddCarImg(carid, url); return RedirectToAction("MyCars"); } else { return RedirectToAction("Failed", "PageHelper"); } } else { return RedirectToAction("Failed", "PageHelper"); } } }
/// <summary> /// 验证会员登陆 /// </summary> /// <param name="userName"></param> /// <param name="password"></param> /// <returns></returns> public ActionResult CheckLogin(string userName, string password) { UserInfoBll bll=new UserInfoBll(); int result=bll.CheckUser(userName, password); if (result==1) { CarSaleEntities context=new CarSaleEntities(); var firstOrDefault = context.UserInfo.FirstOrDefault(u => u.UserName == userName); if (firstOrDefault != null) { int userid = firstOrDefault.ID; Session.Add("logID",userid); } return RedirectToAction("Index"); } else { return RedirectToAction("LoginFaile");//跳转到登陆失败页面 } }
/// <summary> /// 出售者的待处理订单 /// </summary> /// <returns></returns> public ActionResult MyOrders() { var session = Session["logID"]; if (session == null) { return RedirectToAction("Login", "Home"); } else { int userid = Int32.Parse(session.ToString()); CarSaleEntities context = new CarSaleEntities(); List<OrderModel> list=new List<OrderModel>(); var orders=context.Order.Where(o => o.SaleManID == userid); if (orders.Count()==0) { return RedirectToAction("NoOrder"); } else { foreach (var order in orders) { OrderModel model = new OrderModel(); model.ID = order.ID; model.BuyManID = order.BuyManID; model.CarID = order.CarID; model.Date = order.Date; model.Price = order.Price; model.SaleManID = order.SaleManID; list.Add(model); } return View(list); } } }
/// <summary> /// 查看详情页面 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Details(int id) { CarSaleEntities context=new CarSaleEntities(); CarBll bll=new CarBll(); var car=bll.GetCarById(id); int userid = car.UserInfo_ID; var user = context.UserInfo.FirstOrDefault(u => u.ID == userid); DetailViewModel model=new DetailViewModel(); model.CarID = id; model.BrandName = car.BrandName; model.CarType = car.CarType; model.Phone = user.Phone; model.Price = car.Price; model.Status = car.Status; model.Year = car.Year; model.UserName = user.RealName; var img=context.CarImg.FirstOrDefault(c => c.CarID == id); model.imgUrl = img.Imgurl; return View(model); }
/// <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); }
/// <summary> /// 根据出售者的ID获取该用户出售的所有车辆 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List<CarModel> GetCarsByUserId(int userid) { CarSaleEntities context=new CarSaleEntities(); var cars=context.Car.Where(c => c.UserInfo_ID == userid); List<CarModel> list=new List<CarModel>(); foreach (var car in cars) { CarModel model=new CarModel(); 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; list.Add(model); } return list; }