//产品列表 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"; }