/// <summary>
/// 绑定相关资讯
/// </summary>
private void BindRelated()
{
string sql = string.Empty;
sql = "select top 5 ID,NodeCode,Title,type,ShopNo,Stereogram,LocationImg,TelPhone,SalesPro,SiteURL,IntroDetail,Shopshow,LikeImg,Orders FROM K_U_FoodGuide where isdel=0 and len(LikeImg)>0 and ID not in (" + id + ") and flowstate=99 order by orders desc";
DataTable dt = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dt))
{
RptRelated.DataSource = dt;
RptRelated.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003001' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003001' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
dtdata0 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dtdata0))
{
rptdata0lclist.DataSource = dtdata0;
rptdata0lclist.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003002' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003002' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
dtdata1 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dtdata1))
{
rptdatalc1list.DataSource = dtdata1;
rptdatalc1list.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003003' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003003' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc2 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc2))
{
rptdatalc2list.DataSource = datalc2;
rptdatalc2list.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003004' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003004' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc3 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc3))
{
rptdatalc3list.DataSource = datalc3;
rptdatalc3list.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003005' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003005' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc4 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc4))
{
rptdatalc4list.DataSource = datalc4;
rptdatalc4list.DataBind();
}
// sql = "select ID,Title,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003006' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003006' and f.isdel=0 and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc5 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc5))
{
rptdatalc5list.DataSource = datalc5;
rptdatalc5list.DataBind();
}
}
/// <summary>
/// 绑定购物指南分类
/// </summary>
private void BindRelated()
{
string sql = string.Empty;
sql = "select ID,NodeCode,Title,Orders FROM K_U_Category where isdel=0 and flowstate=99 and NodeCode='101002001' order by orders desc";
DataTable dt = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dt))
{
RptRelated.DataSource = dt;
RptRelated.DataBind();
}
}
/// <summary>
/// 绑定相关资讯
/// </summary>
private void BindRelated()
{
string sql = string.Empty;
sql = "select top 5 ID,NodeCode,Title,type,ShopNo,Stereogram,LocationImg,TelPhone,SalesPro,SiteURL,IntroDetail,Shopshow,LikeImg,Orders,MetaKeyword,MetaDescript FROM K_U_CategoryGuide where isdel=0 and len(LikeImg)>0 and ID not in (" + id + ") and NodeCode='104002002' and flowstate=99 order by orders desc";
DataTable dt = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dt))
{
RptRelated.DataSource = dt;
RptRelated.DataBind();
}
sql = "select f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003001' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable dtdata0 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dtdata0))
{
rptdata0lclist.DataSource = dtdata0;
rptdata0lclist.DataBind();
}
sql = "sselect f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003002' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable datalc = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc))
{
rptdatalc1list.DataSource = datalc;
rptdatalc1list.DataBind();
}
sql = "select f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003003' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable datalc2 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc2))
{
rptdatalc2list.DataSource = datalc2;
rptdatalc2list.DataBind();
}
sql = "select f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003004' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable datalc3 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc3))
{
rptdatalc3list.DataSource = datalc3;
rptdatalc3list.DataBind();
}
sql = "select f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003005' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable datalc4 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc4))
{
rptdatalc4list.DataSource = datalc4;
rptdatalc4list.DataBind();
}
sql = "select f.Title,ShopNo,c.ID as cID,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords from K_U_Floorguide as f left join K_U_CategoryGuide as c on f.lcnum =c.ShopNo where f.NodeCode='104002003006' and f.IsDel='0' and f.flowstate='99' order by f.Orders desc";
DataTable datalc5 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc5))
{
rptdatalc5list.DataSource = datalc5;
rptdatalc5list.DataBind();
}
}
/// <summary>
/// 绑定购物指南分类
/// </summary>
private void BindRelated()
{
string sql = string.Empty;
sql = "select ID,NodeCode,Title,Orders FROM K_U_Category where NodeCode='101002001' and isdel=0 and flowstate=99 order by orders desc";
DataTable dt = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dt))
{
RptRelated.DataSource = dt;
RptRelated.DataBind();
}
// sql = "select ID,Title,NodeCode,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003001' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003001' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
dtdata0 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dtdata0))
{
rptdata0lclist.DataSource = dtdata0;
rptdata0lclist.DataBind();
}
// sql = "select ID,Title,NodeCode,lcnum,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003002' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003002' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
dtdata1 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(dtdata1))
{
rptdatalc1list.DataSource = dtdata1;
rptdatalc1list.DataBind();
}
// sql = "select ID,Title,lcnum,NodeCode,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003003' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003003' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc2 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc2))
{
rptdatalc2list.DataSource = datalc2;
rptdatalc2list.DataBind();
}
// sql = "select ID,Title,lcnum,NodeCode,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003004' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003004' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc3 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc3))
{
rptdatalc3list.DataSource = datalc3;
rptdatalc3list.DataBind();
}
// sql = "select ID,Title,lcnum,NodeCode,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003005' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003005' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc4 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc4))
{
rptdatalc4list.DataSource = datalc4;
rptdatalc4list.DataBind();
}
// sql = "select ID,Title,lcnum,NodeCode,lcoverimgurl,lcx,lcy,lclink,lccoords FROM K_U_Floorguide where NodeCode ='101002003006' and isdel=0 and flowstate=99 order by orders desc";
sql = " select f.NodeCode,fg.NodeCode, cg.ID as cgID,cg.Title as cgTitle,fg.ID as fgID,fg.Title as fgTitle ,f.Title,f.ID,f.lcnum,f.NodeCode,f.lcoverimgurl,f.lcx,f.lcy,f.lclink,f.lccoords,cg.type as cgType from K_U_Floorguide as f left join K_U_CategoryGuide as cg on f.lcnum=cg.ShopNo left join K_U_FoodGuide as fg on f.lcnum=fg.ShopNo where f.NodeCode='101002003006' and f.isdel=0 and (cg.isdel=0 or cg.isdel is NULL) and f.flowstate=99 and (cg.NodeCode='101002002' or fg.NodeCode='101003002') order by f.orders desc ";
datalc5 = SQLHelper.GetDataSet(sql);
if (Utils.CheckDataTable(datalc5))
{
rptdatalc5list.DataSource = datalc5;
rptdatalc5list.DataBind();
}
}