/// <summary>
/// 检查用户名是否存在，返回大于0则存在
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public int CheckUserName(string name)
{
using (ECContext ctx = new ECContext())
{
return(ctx.UserInfo.Where(m => m.LoginId == name).Count());
}
}
/// <summary>
/// 买家登录
/// </summary>
/// <param name="name"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public UserInfo UserLogin(string name, string pwd)
{
using (ECContext ctx = new ECContext())
{
return(ctx.UserInfo.Where(m => m.LoginId == name && m.Pwd == pwd).FirstOrDefault());
}
}
/// <summary>
/// 根据id查询商品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Product GetProductById(int id)
{
using (ECContext ctx = new ECContext())
{
return(ctx.Product.First(m => m.PId == id));
}
}
/// <summary>
/// 查询所有商品类型
/// </summary>
/// <returns></returns>
public List <ProType> GetProType()
{
using (ECContext ctx = new ECContext())
{
return(ctx.ProType.ToList());
}
}
/// <summary>
/// 查询所有商品
/// </summary>
/// <returns></returns>
public List <Product> GetProducts()
{
using (ECContext ctx = new ECContext())
{
return(ctx.Product.Include("ProType").Include(m => m.AdminInfo).ToList());
}
}
/// <summary>
/// 注册用户
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int RegisterUser(UserInfo user)
{
using (ECContext ctx = new ECContext())
{
ctx.UserInfo.Add(user);
return(ctx.SaveChanges());
}
}
/// <summary>
/// 新增商品
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int AddProduct(Product pro)
{
using (ECContext ctx = new ECContext())
{
ctx.Product.Add(pro);
return(ctx.SaveChanges());
}
}
/// <summary>
/// 删除商品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteProduct(int id)
{
using (ECContext ctx = new ECContext())
{
Product pro = ctx.Product.First(m => m.PId == id);
ctx.Product.Remove(pro);
return(ctx.SaveChanges());
}
}
/// <summary>
/// 修改商品
/// </summary>
/// <param name="pro"></param>
/// <returns></returns>
public int UpdateProduct(Product pro)
{
using (ECContext ctx = new ECContext())
{
ctx.Product.Attach(pro);
ctx.Entry(pro).State = EntityState.Modified;
return(ctx.SaveChanges());
}
}
public void CreateOrder()
{
try
{
using (ECContext context = new ECContext())
{
Console.WriteLine("开始生成订单");
RedisProduct caceh = new RedisProduct();
var product = context.Product.FirstOrDefault(p => p.Id == ProductId);
Thread.Sleep(5000);
//var cacheProduct = caceh.Get(product.Id.ToString());
Order model = new Order()
{
Id = Guid.NewGuid().ToString(),
CreateTime = DateTime.Now,
OrderNo = OrderNo,
OrderItem = new List <OrderItem>(),
};
model.OrderItem.Add(new OrderItem()
{
Count = Count, Id = Guid.NewGuid().ToString(), Product = product, Order = model
});
//if (cacheProduct.Count <= Count)
//{
// throw new Exception("库存不足");
//}
caceh.LockStore(product.Id.ToString(), Count);
context.Order.Add(model);
context.SaveChanges();
//cacheProduct.Count -= Count;
//caceh.UpdateCache(product.Id.ToString(), cacheProduct);
Console.WriteLine("下单完成");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
public ProductServices(ECContext context)
{
_context = context;
}
