public static List <YF.Model.Shopping> Dotolist(DataTable dt) { List <YF.Model.Shopping> list = new List <Model.Shopping>();//空的泛型对象 转换 for (int i = 0; i < dt.Rows.Count; i++) { YF.Model.Shopping shopping = new Model.Shopping();//空对象 shopping.Id = int.Parse(dt.Rows[i]["id"].ToString()); //当前商品 YF.Model.Goods goods = YF.DAL.Goods.GetGoods(int.Parse(dt.Rows[i]["goodsid"].ToString())); //通过id 得到商品实列对象 shopping.Goods = goods; //商品赋值=上面的goods //当前用户 YF.Model.User user = YF.DAL.User.GetUser(int.Parse(dt.Rows[i]["userid"].ToString())); //通过id 得到用户实列对象 shopping.User = user; //商品赋值=上面的user shopping.Num = int.Parse(dt.Rows[i]["num"].ToString()); shopping.State = int.Parse(dt.Rows[i]["state"].ToString()); shopping.Addate = DateTime.Parse(dt.Rows[i]["addate"].ToString()); list.Add(shopping); //空的泛型对象+数据 } return(list); }
public static bool add(YF.Model.Goods goods) { bool result = false; string strsql = "insert into t_goods(title,price,num,img,detail,state,addate) values('" + goods.Title + "'," + goods.Price + "," + goods.Num + ",'" + goods.Img + "','" + goods.Detail + "'," + goods.State + ",'" + goods.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) { //获取id string id = Request["id"]; YF.Model.Goods goods = YF.BLL.Goods.GetGoods(int.Parse(id)); this.title.Text = goods.Title; this.price.Text = goods.Price.ToString(); this.num.Text = goods.Num.ToString(); this.detail.Text = goods.Detail.ToString(); this.img.ImageUrl = " .. / admin / +goods.Img.ToString()"; this.img.Width = 180; }
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"); } }