public List <BookCartEntity> list(int id) { List <BookCartEntity> list = new List <BookCartEntity>(); string sql = "select BookCart.*,BookInfo.PicPath,BookInfo.BookName,BookInfo.BookPrice,BookInfo.BookDisCount from BookCart left join BookInfo on BookCart.BookId=BookInfo.BookId where MemberId=" + id; db.PrepareSql(sql); DataTable dt = db.ExecQuery(); foreach (DataRow item in dt.Rows) { BookCartEntity entity = new BookCartEntity(); entity.CartId = int.Parse(item["CartId"].ToString()); entity.MemberId = int.Parse(item["MemberId"].ToString()); entity.BookId = int.Parse(item["BookId"].ToString()); entity.BookCount = int.Parse(item["BookCount"].ToString()); entity.IsSelect = int.Parse(item["IsSelect"].ToString()); entity.BookInfo = new BookInfoEntity(); entity.BookInfo.BookName = item["BookName"].ToString(); entity.BookInfo.PicPath = item["PicPath"].ToString(); entity.BookInfo.BookPrice = decimal.Parse(item["BookPrice"].ToString()); entity.BookInfo.BookDisCount = decimal.Parse(item["BookDisCount"].ToString()); list.Add(entity); } return(list); }
private void BookCart_Updatss() { BookCartBLL cartBLL = new BookCartBLL(); MemberEntity member = (MemberEntity)Session["usr"]; List <BookCartEntity> cartEntity = cartBLL.list(member.MemberId); var icv = from ic in cartEntity where ic.IsSelect == 0 select ic; if (Request["qxz"].ToLower().Equals("true")) { foreach (var item in icv) { BookCartEntity entity = cartBLL.lists(item.CartId); entity.IsSelect = entity.IsSelect == 0 ? 1 : 0; cartBLL.Update(entity); } } else { if (icv.Count() == 0) { foreach (BookCartEntity item in cartEntity) { BookCartEntity entity = cartBLL.lists(item.CartId); entity.IsSelect = entity.IsSelect == 0 ? 1 : 0; cartBLL.Update(entity); } } } BookCart_list(); }
private void BookCart_Updatexz() { BookCartBLL bLL = new BookCartBLL(); BookCartEntity entity = bLL.lists(int.Parse(Request["CartId"])); entity.IsSelect = entity.IsSelect == 0 ? 1 : 0; bLL.Update(entity); BookCart_list(); }
private void BookCart_Updatesz() { BookCartBLL bLL = new BookCartBLL(); BookCartEntity entity = bLL.lists(int.Parse(Request["CartId"])); entity.BookCount = int.Parse(Request["BookCount"]); bLL.Update(entity); BookCart_list(); }
public int Update(BookCartEntity entity) { string sql = "Update BookCart set BookId=@BookId,BookCount=@BookCount,IsSelect=@IsSelect where CartId=@CartId"; db.PrepareSql(sql); db.SetParameter("BookId", entity.BookId); db.SetParameter("BookCount", entity.BookCount); db.SetParameter("IsSelect", entity.IsSelect); db.SetParameter("CartId", entity.CartId); return(db.ExecNonQuery()); }
public int Add(BookCartEntity entity) { string sql = @"insert into BookCart(MemberId,BookId,BookCount,IsSelect) values(@MemberId, @BookId,@BookCount,1)"; db.PrepareSql(sql); db.SetParameter("MemberId", entity.MemberId); db.SetParameter("BookId", entity.BookId); db.SetParameter("BookCount", entity.BookCount); return(db.ExecNonQuery()); }
//绑定数据 private void bindata() { int count = 1; if (string.IsNullOrWhiteSpace(Request.QueryString["Count"])) { count = 1; } else if (int.TryParse(Request.QueryString["Count"], out count) == false || count <= 0) { count = 1; } if (string.IsNullOrWhiteSpace(Request.QueryString["BookId"])) { return; } if (int.TryParse(Request.QueryString["BookId"], out int i)) { BookInfoBLL infoBLL = new BookInfoBLL(); BookInfoEntity infoEntity = new BookInfoEntity(); MemberEntity member = (MemberEntity)Session["usr"]; BookCartBLL cartBLL = new BookCartBLL(); infoEntity = infoBLL.list(i); if (infoEntity == null) { return; } ContentPlaceHolder1_imgBook.ImageUrl = "~/uploadfile/" + infoEntity.PicPath; lblTitle.Text = "书名:" + infoEntity.BookName; lblInfo.Text = "作者:" + infoEntity.BookAuthor + " 出版社:" + infoEntity.BookPress + ""; lblPrice.InnerHtml = "<span style='text-decoration:line-through;'>原价:" + (infoEntity.BookPrice * count).ToString().Split('.')[0] + "元</span> 现价:" + ((infoEntity.BookPrice * infoEntity.BookDisCount) * count).ToString("n") + " 数量:" + count; //加入购物车 BookCartEntity cartEntity = cartBLL.list(member.MemberId, infoEntity.BookId); if (cartEntity != null) { cartEntity.BookCount += count; cartBLL.Update(cartEntity); } else { BookCartEntity bookCart = new BookCartEntity(); bookCart.MemberId = member.MemberId; bookCart.BookId = infoEntity.BookId; bookCart.BookCount = count; cartBLL.Add(bookCart); } } }
public BookCartEntity lists(int id) { string sql = "select BookCart.*,BookInfo.PicPath,BookInfo.BookName,BookInfo.BookPrice,BookInfo.BookDisCount from BookCart left join BookInfo on BookCart.BookId=BookInfo.BookId where CartId=" + id; db.PrepareSql(sql); DataTable dt = db.ExecQuery(); BookCartEntity entity = new BookCartEntity(); entity.CartId = int.Parse(dt.Rows[0]["CartId"].ToString()); entity.MemberId = int.Parse(dt.Rows[0]["MemberId"].ToString()); entity.BookId = int.Parse(dt.Rows[0]["BookId"].ToString()); entity.BookCount = int.Parse(dt.Rows[0]["BookCount"].ToString()); entity.IsSelect = int.Parse(dt.Rows[0]["IsSelect"].ToString()); entity.BookInfo = new BookInfoEntity(); entity.BookInfo.BookName = dt.Rows[0]["BookName"].ToString(); entity.BookInfo.PicPath = dt.Rows[0]["PicPath"].ToString(); entity.BookInfo.BookPrice = decimal.Parse(dt.Rows[0]["BookPrice"].ToString()); entity.BookInfo.BookDisCount = decimal.Parse(dt.Rows[0]["BookDisCount"].ToString()); return(entity); }
public BookCartEntity list(int usrid, int bookid) { BookCartEntity cartEntity = new BookCartEntity(); string sql = " select * from BookCart where MemberId=@MemberId and BookId=@BookId"; db.PrepareSql(sql); db.SetParameter("MemberId", usrid); db.SetParameter("BookId", bookid); DataTable dt = db.ExecQuery(); if (dt.Rows.Count == 0) { return(null); } cartEntity.CartId = int.Parse(dt.Rows[0]["CartId"].ToString()); cartEntity.MemberId = int.Parse(dt.Rows[0]["MemberId"].ToString()); cartEntity.BookId = int.Parse(dt.Rows[0]["BookId"].ToString()); cartEntity.BookCount = int.Parse(dt.Rows[0]["BookCount"].ToString()); cartEntity.IsSelect = int.Parse(dt.Rows[0]["IsSelect"].ToString()); return(cartEntity); }
public int Update(BookCartEntity entity) { return(dal.Update(entity)); }
public int Add(BookCartEntity entity) { return(dal.Add(entity)); }