/// <summary> /// 列表 /// </summary> /// <returns></returns> protected void GetList(string PutoutType) { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo(); ChangeHope.DataBase.DataByPage dataPage = data.GetList("[order by] ProductID desc", 20, ""); //第一步先添加表头 table.AddHeadCol("5%", "<input type=\"checkbox\" id=\"chkAll\" onclick=\"CheckAll(this.form)\" alt=\"全选/取消\" />选择"); table.AddHeadCol("10%", "商品编号"); table.AddHeadCol("18%", "商品名称"); table.AddHeadCol("15%", "所属分类"); table.AddHeadCol("10%", "品牌"); table.AddHeadCol("14%", "创建时间"); table.AddHeadCol("8%", "上架状态"); table.AddHeadCol("20%", "操作"); table.AddRow(); //添加表的内容 if (dataPage.DataReader != null) { while (dataPage.DataReader.Read()) { string pic_url = sp.DummyPaht + dataPage.DataReader["Thumbnail"].ToString(); table.AddCol("<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["ProductID"].ToString() + "\" />"); table.AddCol(dataPage.DataReader["ProductNo"].ToString()); table.AddCol("<span style='cursor:hand' onMouseOut=\"hiddenPic();\" onMouseMove=\"showPic('" + pic_url + "');\">" + dataPage.DataReader["ProductName"].ToString() + "(" + dataPage.DataReader["ProductAttachName"].ToString() + ")</span>"); table.AddCol(ProductClassName(dataPage.DataReader["cid"].ToString())); table.AddCol(dataPage.DataReader["BrandID"].ToString()); table.AddCol(dataPage.DataReader["CreateTime"].ToString()); table.AddCol(dataPage.DataReader["IsShelves"].ToString() == "1" ? "上架" : "未上架"); table.AddCol(string.Format("<a href=product_info_edit.aspx?productNo={0}>编辑</a> <a href='#' onclick='Del({0})'>删除</a> <a href=product_info_edit.aspx?productNo={0}>属性添加</a> <a href='../../product/productcontent.aspx?q_productid={0}' target='_blank'>SKU添加</a>", dataPage.DataReader["ProductID"].ToString(), dataPage.DataReader["cid"].ToString(), PutoutType)); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.Literal1.Text = view; }
/// <summary> /// 列表 /// </summary> /// <returns></returns> protected void GetList() { ShowShop.Common.SysParameter sp = new ShowShop.Common.SysParameter(); ChangeHope.WebPage.Table table = new ChangeHope.WebPage.Table(); ShowShop.BLL.Product.ProductInfo data = new ShowShop.BLL.Product.ProductInfo(); ChangeHope.DataBase.DataByPage dataPage = data.GetList(); //第一步先添加表头 table.AddHeadCol("10%","序号"); table.AddHeadCol("20%","货号"); table.AddHeadCol("65%", "商品名称"); table.AddHeadCol("10%", "库存"); 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 + "<input ID=\"cBox\" type=\"checkbox\" value=\"" + dataPage.DataReader["pro_ID"].ToString() + "\" />"); table.AddCol(dataPage.DataReader["pro_NO"].ToString()); table.AddCol("" + dataPage.DataReader["pro_Name"].ToString() + ""); table.AddCol(string.Format("{0}{1}", dataPage.DataReader["pro_Stock"].ToString(), dataPage.DataReader["pro_Unit"].ToString())); table.AddRow(); } } string view = table.GetTable() + dataPage.PageToolBar; dataPage.Dispose(); dataPage = null; this.Literal1.Text = view; }