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