//添加
public static bool add(YF.Model.Shopping shopping)
{
bool result = false;
string strsql = "insert into t_shopping(goodsid,userid,num,state,addate,orderid) values(" + shopping.Goods.Id + "," + shopping.User.Id + "," + shopping.Num + "," + shopping.State + ",'" + shopping.Addate + "','')";
int i = 0;
i = YF.MsSqlHelper.YFMsSqlHelper.ExecuteSql(strsql);
if (i > 0)
{
result = true;
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
//向后台数据库加入记录，点击购买，购物车加
YF.Model.User myuser = new YF.Model.User();
myuser = (YF.Model.User)YF.SessionHelper.GetSesstion("user");//读取当前用户信息 //强制转
if (myuser != null)
{
YF.Model.Shopping shopping = new YF.Model.Shopping(); //1，声明空的购物车对象
int id = int.Parse(Request.QueryString["id"].ToString()); //通过id查询，传过来的，转化数字
YF.Model.Goods goods = YF.BLL.Goods.GetGoods(id); ////4，声明一个商品对象，通过id查询
//5，空对象赋值
shopping.Goods = goods;
shopping.User = myuser;//等于当前用户
shopping.Num = 1;
shopping.State = 0;
shopping.Addate = DateTime.Now;
if (YF.BLL.Shopping.list(goods.Id, myuser.Id, 0).Count > 0) //查询商品是否是第一次，，不是第一次，已经存在之前有添加，则修改数量
{
YF.BLL.Shopping.updatenum(goods.Id, myuser.Id, 0); //修改数量
YF.JsHelper.AlertAndRedirect("添加成功", "/user/shopping.aspx"); //3，添加成功返回购物车页面
}
else
{
if (YF.BLL.Shopping.add(shopping)) //2，调用业务类，判断逻辑。真，操作成功//第一次
{
YF.JsHelper.AlertAndRedirect("操作成功", "/user/shopping.aspx"); //3，返回购物车页面
}
else
{
YF.JsHelper.AlertAndRedirect("操作失败", "/user/shopping.aspx");//不成功购物，失败
}
}
}
else
{
YF.JsHelper.AlertAndRedirect("尚未登录", "/login.aspx");
}
}
public static bool add(YF.Model.Shopping shopping)
{
return(YF.DAL.Shopping.add(shopping));
}
