/// <summary> /// 添加购物车 /// </summary> /// <param name="FlowerId"></param> /// <param name="Num"></param> /// <returns></returns> public ActionResult AddToCart(string FlowerId, int Num) { Business.Sys_FlowerShopCart bus = new Business.Sys_FlowerShopCart(); Model.FlowerShopCart Cart = bus.GetFlowerShopCart(FlowerId.ToString(), userid); if (Cart != null) { Cart.Num += Num; Cart.UpdateTime = DateTime.Now; bus.UpdateFlowerShopCart(Cart);//原来有这个商品,更新下数量 } else { Model.FlowerShopCart model = new Model.FlowerShopCart(); model.Num = Num; model.UsersId = userid; model.FlowerId = FlowerId; model.Status = 1; model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; bus.InsertFlowerShopCart(model); } int num = bus.GetFlowerList().Where(m => m.UsersId == userid).ToList().Sum(m => m.Num); return(Json(new { code = 1, cnum = num }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 从购物车移除 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult RemoveFromCart(string id) { Business.Sys_FlowerShopCart bus = new Business.Sys_FlowerShopCart(); Model.FlowerShopCart Cart = bus.GetFlowerShopCartById(id); if (Cart != null) { bus.DeleteFlowerShopCart(Cart.Id.ToString());// } return(Json(new { code = 1 }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 写入一条记录 /// </summary> /// <param name="Flower"></param> /// <returns></returns> public bool InsertFlowerShopCart(Model.FlowerShopCart Flower) { const string sql = @"INSERT INTO FlowerShopCart(FlowerId,Num,UsersId,Status,CreateTime,UpdateTime) VALUES(@FlowerId,@Num,@UsersId,@Status,@CreateTime,@UpdateTime)"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { Flower.FlowerId, Flower.Num, Flower.UsersId, Flower.Status, Flower.CreateTime, Flower.UpdateTime, }))); }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="Flower"></param> /// <returns></returns> public bool UpdateFlowerShopCart(Model.FlowerShopCart Flower) { const string sql = @"UPDATE FlowerShopCart SET FlowerId=@FlowerId,Num=@Num,UsersId=@UsersId,Status=@Status, CreateTime=@CreateTime,UpdateTime=@UpdateTime WHERE Id=@Id"; return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new { Flower.FlowerId, Flower.Num, Flower.UsersId, Flower.Status, Flower.CreateTime, Flower.UpdateTime, Flower.Id, }))); }
public ActionResult IncreaseOrDecreaseOne(string id, int quantity) { Business.Sys_FlowerShopCart bus = new Business.Sys_FlowerShopCart(); Model.FlowerShopCart Cart = bus.GetFlowerShopCartById(id); if (Cart != null) { Cart.Num = quantity; Cart.UpdateTime = DateTime.Now; bus.UpdateFlowerShopCart(Cart);//原来有这个商品,更新下数量 } return(Json(new { msg = true })); }