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);
}
public static DataTable GetTree(DataTable pDt, int pClassID, int pMaxLevel, string pOrderBy)
{
//DataTable dtClassAll = List();
GetClassTree gct = new GetClassTree();
ClassTree ct = new ClassTree(pDt, gct, pOrderBy);
ct.Exe(pClassID);
DataTable dt = pDt.Clone();
if (pMaxLevel > 0)
{
IList <DataRow> rowList = new List <DataRow>();
foreach (DataRow drw in gct.DataRowList)
{
if (Convert.ToInt32(drw["ClassLevel"]) < pMaxLevel)
{
rowList.Add(drw);
}
}
Fn.DrwToDt(rowList, dt);
}
else
{
Fn.DrwToDt(gct.DataRowList, dt);
}
return(dt);
}
protected void rpClass_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
int ID = Convert.ToInt32(((Label)e.Item.FindControl("ClassID")).Text);
Repeater r = (Repeater)e.Item.FindControl("rpList");
DataTable dt1 = dtL.Clone();
DataRow[] dr = dtL.Select("FK_Help_Class=" + ID, "Taxis asc");
Fn.DrwToDt(dr, dt1);
r.DataSource = dt1;
r.DataBind();
}
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);
}
