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;
}
