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