/// <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>
/// 审核并通过订单，即订单状态置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>
//更新员工密码
/// </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>
/// 添加员工
/// </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="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>
/// <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>
/// <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>
/// <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"></param>
/// <param name="oldPassword"></param>
/// <param name="newPassword"></param>
/// <returns></returns>已测试
public bool NewPassword(string id, string oldPassword, string newPassword)
{
#region
using (var dbcontext = new asimsContext())
{
var user = dbcontext.User
.FirstOrDefault(u => u.Uphone == id && u.Upassword == oldPassword);
if (user != null)
{
user.Upassword = newPassword;
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
#endregion
}
/// <summary>
/// 修改地址信息
/// </summary>
/// <param name="no">地址号</param>
/// <param name="address">新地址</param>
/// <returns></returns>未测试
public bool ModifyAddress(int no, Address address)
{
#region
try
{
using (var dbcontext = new asimsContext())
{
var query = dbcontext.Address
.FirstOrDefault(a => a.Ano == no);
query = address;
dbcontext.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
#endregion
}
/// <summary>
/// 用户退单
/// </summary>
/// <param name="id">用户id</param>
/// <param name="mno">单号</param>
/// <returns></returns>未测试
public bool UserChargeBack(string id, int mno)
{
#region
try
{
using (var dbcontext = new asimsContext())
{
var query = dbcontext.Market
.FirstOrDefault(m => m.Sphone == id && m.Mno == mno);
dbcontext.Remove(query);
dbcontext.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
#endregion
}
/// <summary>
/// 提升员工权限
/// </summary>
/// <param name="id">员工id</param>
/// <returns></returns>未测试
public bool UpdateStaffLevel(string id)
{
#region
try
{
using (var dbcontext = new asimsContext())
{
var query = dbcontext.Staff
.FirstOrDefault(s => s.Sphone == id);
query.Stype = "管理员";
dbcontext.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
#endregion
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="id">用户id</param>
/// <param name="user">用户对象</param>
/// <param name="address">地址编号</param>
/// <returns></returns>未测试
public bool ModifyInformation(string id, User user, int address)
{
#region
try
{
using (var dbcontext = new asimsContext())
{
var query = dbcontext.User
.FirstOrDefault(u => u.Uphone == id);
query = user;
query.Uaddress = address;
dbcontext.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
#endregion
}
/// <summary>
//更改员工信息
/// </summary>
/// <param name="id">员工id</param>
/// <param name="staff">新员工信息</param>
/// <param name="address">员工地址号</param>
/// <returns></returns>
public bool ModifyInformation(string id, Staff staff, int address)
{
#region
using (var dbcontext = new asimsContext())
{
var staffs = dbcontext.Staff
.Single(staf => staf.Sphone == id);
if (staffs != null)
{
staffs = staff;
staff.Saddress = address;
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
#endregion
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="id">用户id</param>
/// <param name="user">用户对象</param>
/// <param name="address">地址编号</param>
/// <returns></returns>
public bool ModifyInformation(string id, User user, int address)
{
#region
using (var dbcontext = new asimsContext())
{
var users = dbcontext.User
.Single(use => use.Uphone == id);
if (users != null)
{
users = user;
user.Uaddress = address;
dbcontext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
#endregion
}
