Exemplo n.º 1
0
 /// <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();
     }
 }
Exemplo n.º 2
0
        /// <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();
            }
        }
Exemplo n.º 3
0
        /// <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();
            }
        }
Exemplo n.º 4
0
        /// <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();
            }
        }