/// <summary> /// 获取列表 /// </summary> private void GetList() { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Order.ShoppingCard data = new ShowShop.BLL.Order.ShoppingCard(); ChangeHope.DataBase.DataByPage dataPage = data.GetProfilesList(""); //第一步先添加表头 table.AddHeadCol("10%", "序号"); table.AddHeadCol("50%", "购者名称"); table.AddHeadCol("25%", "购物时间"); table.AddHeadCol("15%", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); if (curpage < 0) { curpage = 1; } int count = 0; while (dataPage.DataReader.Read()) { count++; string No = (15 * (curpage - 1) + count).ToString(); table.AddCol(No); table.AddCol(string.Format("<a href='order_shop_view.aspx?q_uniqueid={1}&UserName={0}'>{0}</a>", dataPage.DataReader["username"].ToString(), dataPage.DataReader["uniqueid"].ToString())); table.AddCol(dataPage.DataReader["lastupdateddate"].ToString()); table.AddCol(string.Format("<a href='#' onclick=\"Del('{0}')\">删除</a>", dataPage.DataReader["username"].ToString())); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.ltlList.Text = view; }
/// <summary> /// 获取列表 /// </summary> private void GetList() { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Order.ShoppingCard data = new ShowShop.BLL.Order.ShoppingCard(); ChangeHope.DataBase.DataByPage dataPage = data.GetCartProduct(ChangeHope.WebPage.PageRequest.GetString("q_uniqueid")); //第一步先添加表头 table.AddHeadCol("5%", "序号"); table.AddHeadCol("35%", "商品名称"); table.AddHeadCol("10%", "购买数量"); table.AddHeadCol("10%", "单价"); table.AddHeadCol("25%", "购买时间"); table.AddHeadCol("10%", "小计"); //table.AddHeadCol("5%", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { string userName = ChangeHope.WebPage.PageRequest.GetString("UserName"); string userId = string.Empty; ShowShop.BLL.Member.MemberAccount mabll = new ShowShop.BLL.Member.MemberAccount(); ShowShop.Model.Member.MemberAccount mamodel = mabll.GetModel(userName); if (mamodel != null) { userId = mamodel.UID.ToString(); } int curpage = ChangeHope.WebPage.PageRequest.GetInt("pageindex"); if (curpage < 0) { curpage = 1; } int count = 0; // YXShop.TemplateAction.Common dp = new YXShop.TemplateAction.Common(); double totalPrice=0; while (dataPage.DataReader.Read()) { double price = 0.0; price = double.Parse(dataPage.DataReader["pro_ShopPrice"].ToString()); if (userId != string.Empty) { price =ShowShop.Common.ProductInfo.DiscountedPrice(Convert.ToInt32(userId), price, dataPage.DataReader["pro_RatingDiscount"].ToString()); } /* *修改人:ym *修改时间:2009.10.09 */ int procount = int.Parse(dataPage.DataReader["quantity"].ToString()); double total = price * procount; totalPrice+=total; count++; string No = (15 * (curpage - 1) + count).ToString(); table.AddCol(No); table.AddCol(string.Format("<a href='" + sp.DummyPaht + "product/productcontent.aspx?q_productid={1}' target=\"_blank\">{0}</a>", dataPage.DataReader["pro_Name"].ToString(), dataPage.DataReader["pro_Id"].ToString())); table.AddCol(dataPage.DataReader["quantity"].ToString()); table.AddCol(dataPage.DataReader["pro_ShopPrice"].ToString()); table.AddCol(dataPage.DataReader["addtime"].ToString()); table.AddCol(total.ToString()); table.AddRow(); } this.lbTotal.Text = "本页合计:" + totalPrice; } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.ltlList.Text = view; }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> private void Delete(string id) { ShowShop.BLL.Order.ShoppingCard bll = new ShowShop.BLL.Order.ShoppingCard(); bll.Delete(id); bll = null; }