protected void Page_Load(object sender, EventArgs e) { webconfig = Loneu.BLL.Config.WebSiteConfig.Info(); using (SiteBLL bll = new SiteBLL()) { //友情链接 this.rpt_list_link.DataSource = bll.GetList<EmptyTable>("select * from Com_FrendLink where YN_State=0 order by YN_FlSortNumber desc,YN_id desc"); this.rpt_list_link.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { webconfig = Loneu.BLL.Config.WebSiteConfig.Info(); string sql = string.Empty; string ids = string.Empty; List<EmptyTable> ls = null; using (SiteBLL bll = new SiteBLL()) { #region 今日发布 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and Islock<>1 and title<>'' order by Addtime desc,Sortid desc,ArticleID desc "; ls = bll.GetList<EmptyTable>(sql); if (ls != null && ls.Count > 0) { topNews = ls[0]; ls.Remove(topNews); } this.rpt_New_9NewsList.DataSource = ls; #endregion #region 热点排行 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and Islock<>1 and title<>'' and Imgurl<>'' and Isred=1 order by Sortid desc,ArticleID desc "; ls = new List<EmptyTable>(); ls = bll.GetList<EmptyTable>(sql); if (ls != null && ls.Count > 0) { hotNews = ls[0]; ls.Remove(hotNews); } this.rpt_Hits_NewsList.DataSource = ls; #endregion #region 图文精华 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and Islock<>1 and title<>'' and Imgurl<>'' and Zhaiyao<>'' order by Addtime desc,ArticleID desc "; this.rpt_List_PhotoNews.DataSource = bll.GetList<EmptyTable>(sql); #endregion //夷木百科及纵览 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=45 and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc"; this.rpt_list_yimu.DataSource = bll.GetList<EmptyTable>(sql); //数据发布纵横 sql = @" select top 8 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=39 and Imgurl<>'' and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc"; rpt_list_PostData.DataSource = bll.GetList<EmptyTable>(sql); //空气净化器纵览 sql = @" select top 2 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=51 and Imgurl<>'' and Islock<>1 order by ArticleID desc "; ls = bll.GetList<EmptyTable>(sql); ids = string.Empty; if (ls != null && ls.Count > 0) { foreach (EmptyTable et in ls) { ids += et.Get<string>("ArticleID") + ","; } } this.rpt_List_Photo_kongqi.DataSource = ls; sql = @" select top 5 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=51 {0} and Islock<>1 order by ArticleID desc "; if (!string.IsNullOrEmpty(ids)) { ids = ids.TrimEnd(','); ids = " and ArticleID not in(" + ids + ")"; } sql = string.Format(sql, ids); this.rpt_List_News_kongqi.DataSource = bll.GetList<EmptyTable>(sql); //甲醛清除纵览 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=56 and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc"; this.rpt_List_jiaquan.DataSource = bll.GetList<EmptyTable>(sql); #region 社区生活纵览 sql = @" select top 2 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=2 and Imgurl<>'' and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc"; ls = bll.GetList<EmptyTable>(sql); this.rpt_list_shenghuo_Photo.DataSource = ls; ids = string.Empty; if (ls != null && ls.Count > 0) { foreach (EmptyTable et in ls) { ids += et.Get<string>("ArticleID") + ","; } } sql = @" select top 5 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=2 {0} and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc "; if (!string.IsNullOrEmpty(ids)) { ids = ids.TrimEnd(','); ids = " and ArticleID not in(" + ids + ")"; } sql = string.Format(sql, ids); this.rpt_List_shenghuo_news.DataSource = bll.GetList<EmptyTable>(sql); #endregion //热点纵览 sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID and sys_article.ChannelID=63 and Islock<>1 order by Istop desc,Sortid desc,ArticleID desc"; rpt_list_Hot.DataSource = bll.GetList<EmptyTable>(sql); } this.Page.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { webconfig = Loneu.BLL.Config.WebSiteConfig.Info(); bll = new SiteBLL(); }
protected void Page_Load(object sender, EventArgs e) { webconfig = Loneu.BLL.Config.WebSiteConfig.Info(); bll = new SiteBLL(); if (!Loneu.BLL.User.UserDal.CheckUserIsLogin()) Web9long.Web.Clew.Alert("您还没有登录,请登录", "Userlogin.aspx"); }
protected void Page_Load(object sender, EventArgs e) { webconfig = Loneu.BLL.Config.WebSiteConfig.Info(); username = Web9long.Web.Util.Query("username"); }