/// <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(); } }