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