/// <summary> /// 审核并通过订单,即订单状态置1,且库存减1 /// </summary> /// <param name="no">订单号</param> /// <param name="id">销售人员id</param> /// <returns></returns>未测试 public bool CheckMarket(int no, string id) { #region using (var dbcontext = new asimsContext()) { var market = dbcontext.Market .Single(m => m.Mno == no); try { market.Pflag = 1; market.Sphone = id; VehicleManagement vehicle = new VehicleManagement(); bool isSuccess = vehicle.InventoryReduction((int)market.Vno, (int)market.Number); if (isSuccess) { dbcontext.SaveChanges(); return(true); } else { return(false); } } catch (Exception) { return(false); } } #endregion }
/// <summary> /// 车辆库存减num /// </summary> /// <param name="vno">车辆号</param> /// <param name="num">数量</param> /// <returns></returns>已测试 public bool InventoryReduction(int vno, int num) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Cashlist .FirstOrDefault(c => c.Vno == vno); if (query.Vnumber > num) { query.Vnumber = query.Vnumber - num; dbcontext.SaveChanges(); return(true); } else { return(false); } } } catch { return(false); } #endregion }
/// <summary> /// 查看所有用户 /// </summary> /// <returns>所有用户</returns>已测试 public List <User> ListAllUser() { #region using (var dbcontext = new asimsContext()) { var query = dbcontext.User.FromSql("select * from asims.User").ToList(); return(query); } #endregion }
/// <summary> /// 查看账号为id用户的详细信息 /// </summary> /// <param name="id">用户id</param> /// <returns>账号为id的用户</returns> public User GetUserDetail(string id) { #region using (var dbcontext = new asimsContext()) { var user = dbcontext.User .Single(users => users.Uphone == id); return(user); } #endregion }
/// <summary> /// 通过id查询汽车 /// </summary> /// <param name="id">汽车id</param> /// <returns>汽车</returns> public Vehicle CheckVehicleThoughId(int id) { #region using (var dbcontext = new asimsContext()) { var vehicle = dbcontext.Vehicle .Single(vehicles => vehicles.Vno == id); return(vehicle); } #endregion }
/// <summary> /// 查询用户的订单 /// </summary> /// <param name="id">用户id</param> /// <returns>订单列表</returns> public List <Market> GetSomeUserMarket(string id) { #region using (var dbcontext = new asimsContext()) { var markets = dbcontext.Market .FromSql("select * from asims.Market") .Where(m => m.Uphone == id) .ToList(); return(markets); } #endregion }
/// <summary> /// 查看所有用户 /// </summary> /// <returns>所有用户</returns> public List <User> ListAllUser() { List <User> users = new List <User>(); #region using (var dbcontext = new asimsContext()) { foreach (var user in dbcontext.User) { users.Add(user); } } #endregion return(users); }
/// <summary> /// 处理员工的登录请求 /// </summary> /// <param name="id">员工id</param> /// <param name="password">员工密码</param> /// <returns>成功返回true</returns> public bool Login(string id, string password) { #region using (var dbcontext = new asimsContext()) { var staff = dbcontext.Staff .FirstOrDefault(s => s.Sphone == id && s.Spassword == password); if (staff != null) { return(true); } } #endregion return(false); }
/// <summary> /// 处理员工的登录请求 /// </summary> /// <param name="id">员工id</param> /// <param name="password">员工密码</param> /// <returns>成功返回true</returns> public bool Login(string id, string password) { #region using (var dbcontext = new asimsContext()) { foreach (var staff in dbcontext.Staff) { if (staff.Sphone == id && staff.Spassword == password) { return(true); } } } #endregion return(false); }
/// <summary> //根据地址号获取地址 /// </summary> /// <param name="no">地址号</param> /// <returns>地址</returns>未测试 public Address GetOneAddress(int no) { #region try { using (var db = new asimsContext()) { return(db.Find <Address>(no)); } } catch { return(null); } #endregion }
/// <summary> /// 根据地址号来删除地址 /// </summary> /// <param name="no">地址号</param> /// <returns>成功返回true</returns>未测试 public bool DeleteAddress(int no) { #region try { using (var dbcontext = new asimsContext()) { dbcontext.Remove <Address>(this.GetOneAddress(no)); return(true); } } catch { return(false); } #endregion }
/// <summary> /// 插入地址 /// </summary> /// <param name="address">地址</param> /// <returns>地址编号</returns>未测试 public int InsertAddress(Address address) { #region try { using (var dbcontext = new asimsContext()) { dbcontext.Add(address); return(address.Ano); } } catch { return(-1); } #endregion }
/// <summary> /// 通过id查询汽车 /// </summary> /// <param name="id">汽车id</param> /// <returns>汽车</returns>未测试 public Vehicle CheckVehicleThoughId(int id) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Vehicle .FirstOrDefault(v => v.Vno == id); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 获取员工经手的订单号为no的详细信息 /// </summary> /// <param name="id">员工id</param> /// <param name="no">订单号</param> /// <returns></returns> public Market GetOneStaffMarket(string id, int no) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Market .FirstOrDefault(m => m.Sphone == id && m.Mno == no); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 通过id获取员工 /// </summary> /// <param name="id">员工id</param> /// <returns></returns>未测试 public Staff GetStaffThoughID(string id) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Staff .FirstOrDefault(s => s.Sphone == id); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 添加员工 /// </summary> /// <param name="staff">员工</param> /// <returns></returns>未测试 public bool AddStaff(Staff staff) { #region try { using (var dbcontext = new asimsContext()) { dbcontext.Add(staff); dbcontext.SaveChanges(); return(true); } } catch { return(false); } #endregion }
/// <summary> //更新员工密码 /// </summary> /// <param name="id">员工id</param> /// <param name="oldPassword">旧密码</param> /// <param name="newPassword">新密码</param> /// <returns>成功返回true</returns> public bool NewPassword(string id, string oldPassword, string newPassword) { #region using (var dbcontext = new asimsContext()) { foreach (var staff in dbcontext.Staff) { if (staff.Sphone == id && staff.Spassword == oldPassword) { staff.Spassword = newPassword; dbcontext.SaveChanges(); break; } } } #endregion return(false); }
/// <summary> /// 获取用户的订单号为no的详细信息 /// </summary> /// <param name="id">用户id</param> /// <param name="no">订单号</param> /// <returns></returns> public Market GetOneUserMarket(string id, int no) { #region using (var dbcontext = new asimsContext()) { var market = dbcontext.Market .Single(m => m.Uphone == id && m.Mno == no); try { return(market); } catch (Exception) { return(null); } } #endregion }
/// <summary> /// 处理用户的登录请求 /// </summary> /// <param name="id">用户id</param> /// <param name="password">用户密码</param> /// <returns></returns>已测试 public bool Login(string id, string password) { #region using (var dbcontext = new asimsContext()) { var user = dbcontext.User .FirstOrDefault(u => u.Uphone == id && u.Upassword == password); if (user != null) { return(true); } else { return(false); } } #endregion }
/// <summary> /// 删除员工 /// </summary> /// <param name="id"></param> /// <returns></returns>未测试 public bool DeleteStaff(string id) { #region try { using (var dbcontext = new asimsContext()) { var query = GetStaffThoughID(id); dbcontext.Staff.Remove(query); dbcontext.SaveChanges(); return(true); } } catch { return(false); } #endregion }
/// <summary> /// 获取所有车辆 /// </summary> /// <returns>车辆列表</returns>未测试 public List <Vehicle> GetAllVehicle() { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Vehicle .FromSql("select * from asims.Vehicle") .ToList(); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 通过姓名获取员工(模糊查找) /// </summary> /// <param name="name">员工姓名</param> /// <returns></returns>已测试 public List <Staff> GetStaffThoughName(string name) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Staff .Where(s => s.Sname.Contains(name)) .ToList(); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 处理用户的注册 /// </summary> /// <param name="user">用户对象</param> /// <param name="address">地址号</param> /// <returns></returns>未测试 public bool Register(User user, int address) { #region try { using (var dbcontext = new asimsContext()) { user.Uaddress = address; dbcontext.User.Add(user); dbcontext.SaveChanges(); return(true); } } catch { return(false); } #endregion }
/// <summary> /// 获取所有员工 /// </summary> /// <returns></returns>未测试 public List <Staff> GetAllStaff() { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Staff .FromSql("select * from asims.Staff") .ToList(); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 提交订单 /// </summary> /// <param name="id">用户id</param> /// <param name="market">订单</param> /// <returns></returns>未测试 public bool SubmitOrder(string id, Market market) { #region try { using (var dbcontext = new asimsContext()) { market.Uphone = id; dbcontext.Add(market); dbcontext.SaveChanges(); return(true); } } catch { return(false); } #endregion }
/// <summary> /// 查询所有订单 /// </summary> /// <returns>订单列表</returns> public List <Market> GetAllMarket() { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Market .FromSql("select * from asims.Market") .ToList(); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 审核并通过订单,即订单状态置1 /// </summary> /// <param name="no">订单号</param> /// <returns>是否成功</returns> public bool CheckMarket(int no) { #region using (var dbcontext = new asimsContext()) { var market = dbcontext.Market .Single(m => m.Mno == no); try { market.Pflag = 1; return(true); } catch (Exception) { return(false); } } #endregion }
/// <summary> /// 进货 /// </summary> /// <param name="vno">车辆编号</param> /// <param name="num">车辆数目</param> /// <returns></returns>已测试 public bool StockVehicle(int vno, int num) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Cashlist .FirstOrDefault(c => c.Vno == vno); query.Vnumber = query.Vnumber + num; dbcontext.SaveChanges(); return(true); } } catch { return(false); } #endregion }
/// <summary> /// 查询员工经手的订单 /// </summary> /// <param name="id">员工id</param> /// <returns>订单列表</returns> public List <Market> GetSomeStaffMarket(string id) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Market .FromSql("select * from asims.Market") .Where(m => m.Sphone == id) .ToList(); return(query); } } catch { return(null); } #endregion }
/// <summary> /// 通过汽车类型查找汽车 /// </summary> /// <param name="type">汽车类型</param> /// <returns>type类型的所有汽车</returns>未测试 public List <Vehicle> CheckVehicleThoughType(string type) { #region try { using (var dbcontext = new asimsContext()) { var query = dbcontext.Vehicle .FromSql("select * from asims.Vehicle") .Where(v => v.Vtype == type) .ToList(); return(query); } } catch { return(null); } #endregion }