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