//产品列表
private void List()
{
PagingList pl = new PagingList("vgPro_Info", "ProSN", new PagingUrlVar(16, pageIndex));
if (t == 1)
{
pl.SqlSelect = "select ProSN,ProName,PicS,Price1,PriceMarket,Item,Number,UnitNum,StockN,Unit";
}
else
{
pl.SqlSelect = "select ProSN,ProName,PicS,Price1,PriceMarket,Item";
}
//pl.SqlFrom = "from vgPro_Info a , T_Pro_Class_GetChildAndSelf(" + id + ") b";
//pl.SqlWhere = "where a.FK_Pro_Class=b.id";
pl.SqlFrom = "from vgPro_Info";
pl.SqlWhere = "where Item&16=16 and MS_StartTime<=getdate() and MS_EndTime>=getdate()";
switch (ord)
{
case 1:
pl.SqlOrder = "order by Price1 asc";
break;
case 2:
pl.SqlOrder = "order by Price1 desc";
break;
default:
pl.SqlOrder = "order by EditDate desc";
break;
}
Paging pg = pl.List(true);
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
}
else
{
this.showList.Visible = false;
rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = new CycleEvent(ProLay.listCuXiao2);
}
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}-" + t;
}
//产品列表
private void List()
{
PagingList pl = new PagingList("vgTaoCan_Info", "ProSN", new PagingUrlVar(16, pageIndex));
if (t == 1)
{
pl.SqlSelect = "select ProSN,ProName,PicS,Item,Number,UnitNum,StockN,Unit";
}
else
{
pl.SqlSelect = "select ProSN,ProName,PicS,Item";
}
pl.SqlFrom = "from vgTaoCan_Info a , T_TaoCan_Class_GetChildAndSelf(" + id + ") b";
pl.SqlWhere = "where a.FK_Pro_Class=b.id";
switch (ord)
{
case 1:
pl.SqlOrder = "order by Hit asc";
break;
case 2:
pl.SqlOrder = "order by Hit desc";
break;
default:
pl.SqlOrder = "order by EditDate desc";
break;
}
Paging pg = pl.List(true);
if (t == 1)
{
stypeModel = "2";
this.showPic.Visible = false;
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
}
else
{
this.showList.Visible = false;
this.rpPic.dt = pg.GetDataTable();
this.rpPic.listEvent = new CycleEvent(TaoCanLay.list1);
}
this.ucPS1.f = pg;
this.ucPS1.cs = GetURL.TaoCan.Class(id + "-{0}-" + t);
}
//分类列表
private void List()
{
PagingList pl = new PagingList("News_Info", "NewsSN", new PagingUrlVar(8, pageIndex));
pl.SqlSelect = "select NewsSN,Source,Title,EditDate,Detail,UrlType,Url";
pl.SqlFrom = "from news_Info";
pl.SqlWhere = "where FK_News_Class=" + id;
pl.SqlOrder = "order by EditDate desc";
Paging pg = pl.List(true);
Bind.BGRepeater(pg.GetDataTable(), this.rpNewsList);
this.ucPS1.f = pg;
this.ucPS1.cs = GetURL.News.Class(id.ToString() + "-{0}");
}
//评论列表
private void List()
{
PagingList pl = new PagingList("Gift_Info", "GiftSN", new PagingUrlVar(12, pageIndex));
pl.SqlSelect = "select GiftSN,GiftName,Integral,PicS";
pl.SqlFrom = "from Gift_Info";
pl.SqlWhere = id == 0 ? "" : "where FK_Gift_Class=" + id;
pl.SqlOrder = "order by ExchangeN desc";
Paging pg = pl.List(true);
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "?s=" + id + "-{0}#locate";
}
