private void LL()
{
string sql;
DataTable dt;
//PPT
sql = "select top 5 NewsSN,Title,PicS,PicB,UrlType,Url from news_Info where Item&2=2 order by EditDate desc";
dt = cac.GetDataTable("news_ppt", sql);
Bind.BGRepeater(dt, rpPPTImg);
Bind.BGRepeater(dt, rpPPTList);
//健康热点 NO.1
sql = "select top 1 NewsSN,PicS,Title,Title1,Detail,UrlType,Url from news_Info where Item&1=1 order by EditDate desc";
dt = cac.GetDataTable("news_item_1", sql);
Bind.BGRepeater(dt, rpHotNO1);
//健康热点 其他
sql = "select top 5 NewsSN,Title,Title1,UrlType,Url from news_Info where Item&4=4 order by EditDate desc";
dt = cac.GetDataTable("news_item_4", sql);
Bind.BGRepeater(dt, rpHotList);
//列表
sql = "select top 10 NewsSN,Source,Title,EditDate,Detail,UrlType,Url from news_Info where FK_News_Class=" + id + " order by EditDate desc";
dt = cac.GetDataTable("news_class_" + id, sql);
this.rpList.dt = dt;
this.rpList.listEvent = new CycleEventText(NewsList);
//独家
sql = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where Item&1024=1024 order by EditDate desc";
dt = cac.GetDataTable("news_Item_1024", sql);
this.rpDJ.dt = dt;
this.rpDJ.listEvent = new CycleEvent(ProLay.d_list4);
}
private void List()
{
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ge.ExSN,gi.PicS,gi.GiftName,ge.AddDate,ge.ExIntegral,ge.Num";
sqlFrom = " from Gift_ExchangeLog as ge left join Gift_Info as gi on ge.FK_Gift=gi.GiftSN";
sqlWhere = " where ge.FK_User="******" order by ge.AddDate desc";
pkName = "ExSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(12));//页记录 12
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "?p={0}";
countN.Text = pg.um.records_count.ToString();//总数
}
private void LL()
{
string sql = "select ProName from vgTaoCan_Info where ProSN=" + id;
d = new SqlDataSelect(sql);
if (d.Count < 1)
{
return;
}
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ev.Fraction,ev.FK_User,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName";
sqlFrom = " from TaoCan_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN";
sqlWhere = " where Purview=1 and FK_Pro=" + id;
sqlOrder = " order by ev.AddDate desc";
pkName = "EvalSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30));
pg.load();
DataTable dt = pg.GetDataTable();
cou = dt.Rows.Count.ToString();
Bind.BGRepeater(dt, this.rpList);
this.ucPS1.f = pg;
}
private void GetClass()
{
string sql = "select ClassSN,ClassName from vgPro_Class where PClassSN=0 order by Taxis asc";
DataTable dt = cac.GetDataTable("publist_PClassSN=0", sql);
Bind.BGRepeater(dt, this.rpClass);
}
private void GetPro()
{
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select ProSN,ProName,PicS,Price2,Unit,UnitNum";
sqlFrom = " from vgPro_Info";
if (classID > 0)
{
sqlFrom = " from vgPro_Info a inner join T_Pro_Class_GetChildAndSelf(" + classID + ") b on a.FK_Pro_Class=b.id";
}
sqlWhere = " where Item&2048=2048";
sqlOrder = " order by EditDate desc";
pkName = "ProSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(16));
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpPro);
this.ucPS1.f = pg;
}
private void LL()
{
string sql;
DataTable dt;
sql = "select Title,Detail,Source,EditDate,Vote from News_Info where NewsSN=" + id;
d = new SqlDataSelect(sql);
//导航栏
curPath.Text += d.Eval("Title");
//投票
sql = "select ClassName,Str,PicS from Vote_Class where PClassSN=(select ClassSN from Vote_Class where Str='news') order by Taxis asc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpVoteList, false);
//hit +1
sql = "update News_Info set Hit=Hit+1 where NewsSN=" + id;
DbHelp.Update(sql);
//健康食品推荐
sql = "select top 10 ProSN,ProName,PicS,Price from vgPro_Info where JoinType=0 and Item&128=128 and Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
this.rpList.dt = dt;
this.rpList.listEvent = new CycleEvent(ProLay.d_list3);
List();
}
private void GetHtml()
{
string sSql = "select top 5 ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName from TaoCan_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN where Purview=1 and FK_Pro=" + id + " order by ev.AddDate desc";
DataTable dt = DbHelp.GetDataTable(sSql);
Bind.BGRepeater(dt, this.rpMsg);
}
private void caipuPicList()
{
string sSql = "select PicS,PicB from CaiPu_Pic where FK_Pro=" + id;
DataTable dtPic = DbHelp.GetDataTable(sSql);
Bind.BGRepeater(dtPic, this.rpPic);
}
private void LL()
{
string sql;
DataTable dt;
//分类下 文章
sql = "select HelpSN,FK_Help_Class,Taxis,Title from Help_Info";
dtL = DbHelp.GetDataTable(sql);
//内容
if (id == 0)
{
sql = "select top 1 HelpSN,Title,Detail from Help_Info order by Taxis asc";
}
else
{
sql = "select HelpSN,Title,Detail from Help_Info where HelpSN=" + id;
}
d = new SqlDataSelect(sql);
//分类
dt = PubData.GetDataTable("help_class");
Bind.BGRepeater(dt, rpClass, false);
}
private void LL()
{
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select ev.Detail,ev.ReDetail,ev.AddDate,ev.Purview,ui.UserName,pi.ProSN,pi.ProName,pi.PicS";
sqlFrom = " from Pro_Msg ev left join User_Info ui on ev.FK_User=ui.UserSN left join vgPro_Info pi on ev.FK_Pro=pi.ProSN";
sqlWhere = " where ev.FK_User="******" order by ev.purview asc,ev.AddDate desc";
pkName = "MsgSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(10));
pg.load();
DataTable dt = pg.GetDataTable();
Bind.BGRepeater(dt, this.rpList);
this.ucPS1.f = pg;
}
private void LL()
{
string sSQL = "select * from Links where LinksType=" + LinksType + " and ShowLocal=" + ShowLocal + " and ShowType=" + ShowType + " order by Taxis desc,LinksSN desc";
//string sSQL = string.Format("select * from Links where LinksType={0} and Item={1}{2} order by Taxis asc", LinksType, Item, "{0}");
//if (IsPic)
//{
// sSQL = string.Format(sSQL, " and len(LinksImg)>0");
//}
//else
//{
// sSQL = string.Format(sSQL, " and len(LinksImg)=0");
//}
DataTable dt = dbCac.GetDataTable(LinksType.ToString() + ShowLocal.ToString() + ShowType.ToString(), sSQL);
if (ShowType == 1)
{
Bind.BGRepeater(dt, this.rpPic, false);
this.rpText.Visible = false;
}
else
{
Bind.BGRepeater(dt, this.rpText, false);
this.rpPic.Visible = false;
}
}
private void BGList()
{
string sql = "select ConSN,Name,Address,Tel,FixTel,FK_Area from User_Contact where FK_User=" + UserID;
DataTable dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, this.rpList);
}
private void LL()
{
string sql;
DataTable dt;
//一级分类
dtC = PubData.GetDataTable("TaoCan_Class");
DataRow[] dr = dtC.Select("ClassLevel=1", "Taxis asc");
dt = dtC.Clone();
Fn.DrwToDt(dr, dt);
Bind.BGRepeater(dt, rpClass1);
//推荐1
sql = "select top 2 ProSN,ProName,PicS from vgTaoCan_Info where Item&2=2 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ1);
//推荐2
sql = "select top 4 ProSN,ProName,PicS from vgTaoCan_Info where Item&4=4 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpTJ2);
//精品
sql = "select top 12 ProSN,ProName,PicS from vgTaoCan_Info where Item&1=1 order by EditDate desc";
dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, rpJP);
}
private void LL()
{
Paging pg = Coupons_Info.List(GetSess.UserID, type);
Bind.BGRepeater(pg.GetRead(), this.rpList);
this.ucPS1.f = pg;
}
private void MsgList()
{
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select Detail,N.AddDate as AddDate,UserName";
sqlFrom = " from Questionnaire_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
sqlWhere = " where Purview=1 and FK_Questionnaire=" + QuSN;
sqlOrder = " order by N.AddDate desc";
pkName = "MsgSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30, cur_pageIndex));//页记录 30
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";
lNum = pg.um.records_count.ToString();
}
private void EvaluateList()
{
string sSql = "select top 10 ev.Fraction,ev.Detail,ev.ReDetail,ev.AddDate,ui.UserName from Pro_Evaluate ev left join User_Info ui on ev.FK_User=ui.UserSN where Purview=1 and FK_Pro=" + id + " order by ev.AddDate desc";
DataTable dt = DbHelp.GetDataTable(sSql);
Bind.BGRepeater(dt, this.rpEvaluate);
}
//订单商品列表
private void BGOrdPro()
{
DataTable dtPro = Ord_Pro.List(id);
pageTotalPrice1 = PriceHandler.GetTotalPrice(dtPro, "op_UserTotalPrice");
Bind.BGRepeater(dtPro, this.rpListProUp);
}
private void ListTaoCan(string cacheName, int topN, PubEnum.TaoCanItem type, Repeater rep)
{
int iItem = (int)type;
string sSQL = string.Format("select top " + topN + " ProSN,ProName,PicS,Detail3,Item from vgTaoCan_Info where Item&{0}={0} order by EditDate desc", iItem);
DataTable dt = cac.GetDataTable(cacheName, sSQL);
Bind.BGRepeater(dt, rep, false);
}
//本类推荐
private void ListTJ()
{
int iItem = (int)PubEnum.TaoCanItem.推荐;
string sSQL = string.Format("select top 6 ProSN,ProName,PicS,Item from vgTaoCan_Info a,T_TaoCan_Class_GetChildAndSelf({0}) b where a.FK_Pro_Class=b.id and Item&{1}={1} order by EditDate desc", id, iItem);
DataTable dt = cac.GetDataTable("taoCan_classTJ" + id, sSQL);
Bind.BGRepeater(dt, this.rpTJ, false);
}
private void PicList()
{
string sSql = "select PicS,PicB from CaiPu_Pic where FK_Pro=" + id;
DataTable dtPic = DbHelp.GetDataTable(sSql);
if (dtPic.Rows.Count > 1)
{
Bind.BGRepeater(dtPic, this.rpPic);
}
}
private void LL()
{
HistoryData hd = new HistoryData("taoCanHistory", Max);
string sID = hd.Add(ProID);
if (sID.Length > 0)
{
DataTable dtHistory = DbHelp.GetDataTable("select ProSN,ProName,PicS from vgTaoCan_Info where ProSN in(" + sID + ") order by EditDate desc");
Bind.BGRepeater(dtHistory, this.rpHistory);
}
}
//分类列表
private void List()
{
if (keyword.Length > 0)
{
this.curPath.Text += " <span class=\"search-color\">" + keyword + "</span>";
}
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select NewsSN,Source,Title,EditDate,Detail,UrlType,Url";
sqlFrom = " from News_Info";
if (id > 0)
{
sqlWhere = " where FK_News_Class" + id;
}
if (item > 0)
{
string aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + "Item&" + item + "=" + item;
}
if (keyword.Length > 0)
{
string aw = sqlWhere.Length > 0 ? " and " : " where ";
sqlWhere += aw + " Title like '%'+@Title+'%'";
}
sqlOrder = " order by EditDate desc";
pkName = "NewsSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Title", keyword)
};
pv.DataParm = dp;
Paging pg = new Paging(pv, new PagingUrlVar(8, pageIndex));//页记录
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpNewsList);
this.ucPS1.f = pg;
this.ucPS1.cs = Request.Url.AbsolutePath + "?s=" + id + "-{0}----" + keywordEncode;
}
//产品列表
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()
{
//评论数
string sql = "select count(0) from News_Msg where Purview=1 and FK_News=" + id;
lNum = DbHelp.Scalar(sql).ToString();
//最新评论
sql = "select top 5 N.FK_User,Detail,N.AddDate as AddDate,UserName from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN where Purview=1 and FK_News=" + id + " order by N.AddDate desc";
DataTable dt = DbHelp.GetDataTable(sql);
Bind.BGRepeater(dt, this.rpMsgList);
}
protected DataTable dtHotSell2; //本月热卖
private void LL()
{
string sSQL;
//推荐
sSQL = string.Format("select top 4 ProSN,ProName,PicS,Price,Item from vgPro_Info where Item&{0}={0} order by EditDate desc", (int)PubEnum.ProItem.新品);
this.rpRecommend.dt = dbCac.GetDataTable("Pro_rpRecommend", ref sSQL);
//热门
sSQL = string.Format("select top 5 ProSN,ProName,PicS,Price,Item from vgPro_Info where Item&{0}={0} order by EditDate desc", (int)PubEnum.ProItem.热销);
this.rpHot.dt = dbCac.GetDataTable("Pro_rpHot", ref sSQL);
//网站公告
sSQL = "select top 5 BulletinSN,Title from Bulletin where BulletinType=0 order by EditDate desc";
Bind.BGRepeater(dbCac.GetDataTable("Bulletin_rpWebNotice", ref sSQL), this.rpWebNotice, false);
//活运通知
sSQL = "select top 5 BulletinSN,Title from Bulletin where BulletinType=1 order by EditDate desc";
Bind.BGRepeater(dbCac.GetDataTable("Bulletin_rpWebActive", ref sSQL), this.rpWebActive, false);
//幻灯片
sSQL = "select AdvName,AdvImg,AdvURL from Adv_Info where Keyword='default_ppt' order by Taxis asc";
Bind.BGRepeater(dbCac.GetDataTable("Adv_rpPPT", ref sSQL), this.rpPPT, false);
#region 热卖
//本周热卖
Pro_Info_HotSell pihHotSell1 = new Pro_Info_HotSell("Pro_pihHotSell1", DateTime.Now.Add(new TimeSpan(-7, 0, 0, 0)));
dtHotSell1 = dbCac.GetDataTable(pihHotSell1);
//本月热卖
Pro_Info_HotSell pihHotSell2 = new Pro_Info_HotSell("Pro_pihHotSell2", Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")));
dtHotSell2 = dbCac.GetDataTable(pihHotSell2);
#endregion
//分类商品
this.rpClassPro1.dt = dbCac.GetDataTable("Pro_Class_rpClassPro1", GetClassSQL(2));
this.rpClassPro2.dt = dbCac.GetDataTable("Pro_Class_rpClassPro2", GetClassSQL(1));
this.rpClassPro3.dt = dbCac.GetDataTable("Pro_Class_rpClassPro3", GetClassSQL(19));
//子级分类列表
DataTable classPro1 = dtProClass.Clone();
DataTable classPro2 = dtProClass.Clone();
DataTable classPro3 = dtProClass.Clone();
Fn.DrwToDt(dtProClass.Select("PClassSN=" + 2, "Taxis asc"), classPro1);
Fn.DrwToDt(dtProClass.Select("PClassSN=" + 1, "Taxis asc"), classPro2);
Fn.DrwToDt(dtProClass.Select("PClassSN=" + 19, "Taxis asc"), classPro3);
Bind.BGRepeater(classPro1, this.rpClass1, false);
Bind.BGRepeater(classPro2, this.rpClass2, false);
Bind.BGRepeater(classPro3, this.rpClass3, false);
}
//产品列表
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 ProList(string pIds)
{
int userLevel = LoginInfo.UserLevel;
string sql = "select ProSN," + num + " as Num,ProName,Number,Price,Price1,Price2,MS_StartTime,MS_EndTime,PicS,LevelPrice,Item,ProIsHas,StockN,pi.Unit,pi.UnitNum from "
+ "vgPro_Info pi left join (select LevelPrice,Fk_Pro from Pro_LevelPrice where FK_User_Level=" + userLevel + ") lp on lp.Fk_Pro=pi.ProSN "
+ "where ProSN in(" + pIds + ")";
DataTable dt = DbHelp.GetDataTable(sql);
PriceHandler ph = new PriceHandler(dt, userLevel, userIdentifier);
Dictionary <int, DataTable> dirc = ph.Change();
Bind.BGRepeater(dirc[10], this.rpList);
}
private void GetChild()
{
//string sSql="select pi.ProSN,pi.ProName,pi.Price,pi.PicS from "
// + "vgPro_Info pi left join CaiPu_Pro caip on pi.ProSN=caip.FK_Pro "
// + "left join TaoCan_Pro taoc on caip.FK_CaiPu=taoc.FK_CaiPu"
// + " where taoc.FK_TaoCan=" + id;
string sql;
sql = "select ci.ProSN,ci.ProName,ci.PicS from TaoCan_CaiPu tc left join vgCaiPu_Info ci on tc.FK_CaiPu=ci.ProSN where tc.FK_TaoCan=" + id;
Bind.BGRepeater(sql, this.rpChild);
sql = "select pi.ProSN,pi.ProName,pi.Price,pi.PicS from TaoCan_Pro tc left join vgPro_Info pi on tc.FK_CaiPu=pi.ProSN where tc.FK_TaoCan=" + id;
Bind.BGRepeater(sql, this.rpChild1);
}
//评论列表
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";
}
//分类列表
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}");
}