protected void Page_PreRender(object sender, EventArgs e) { url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/"; string ChannelAlias = null; try { ChannelAlias = Request.QueryString["SubAlias"].ToString(); } catch (Exception AliasNull) { Response.Redirect("HomeLite.aspx"); } string ChannelGuid = DataQuery.CategoryAliasToID(ChannelAlias); string CategoryName = DataQuery.GetNameByCategoryAlias(ChannelAlias); string OtherAlias = DataQuery.GetChannelAliasByName(ConfigurationManager.AppSettings["NewsCategoriesAlias"], CategoryName); string OtherGuid = DataQuery.CategoryAliasToID(OtherAlias); DataTable TopInfo = DataQuery.ArticleQuerySummary("", "1", ChannelAlias).Tables[0]; DataTable OtherInfo = DataQuery.ArticleQuery("", "", OtherAlias).Tables[0]; TopPicLargeLink.NavigateUrl = "ShowVideo.aspx?ID=" + TopInfo.Rows[0]["ArticleGUID"].ToString(); PlayLink.NavigateUrl = "ShowVideo.aspx?ID=" + TopInfo.Rows[0]["ArticleGUID"].ToString(); TopPicLarge.ImageUrl = DataQuery.GetCoursePicPath(TopInfo.Rows[0]["ArticleGUID"].ToString(), url, "360x240.png"); TopPicSmall.ImageUrl = DataQuery.GetCoursePicPath(TopInfo.Rows[0]["ArticleGUID"].ToString(), url, "001.jpg"); TopTitle.Text = DataProcessing.SubstringText(TopInfo.Rows[0]["Title"].ToString(), 17); TopSpeaker.Text = DataProcessing.SubstringText(TopInfo.Rows[0]["Author"].ToString(), 17); TopSpeakerInfo.Text = DataProcessing.SubstringText(TopInfo.Rows[0]["SpeakerInfo"].ToString(), 25); TopSpeakerInfo.ToolTip = TopInfo.Rows[0]["SpeakerInfo"].ToString(); TopSummary.Text = DataProcessing.SubstringText(DataProcessing.NoHTML(TopInfo.Rows[0]["Summary"].ToString()), 155); TopSummary.ToolTip = DataProcessing.NoHTML(TopInfo.Rows[0]["Summary"].ToString()); // SpecialAttentionLevel2CourseList.DataSource = OtherInfo; SpecialAttentionLevel2CourseList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string CourseKeyWord; string CourseSperker; url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/"; string CourseId = Request.QueryString["ID"].ToString(); if (CourseId == null) { Response.Redirect("HomeLite.aspx"); } string CoursrQueryStr = "SELECT Top 1 ArticleGUID,State,Title,Area,Author,PlainText,Filename,CreateTime,KeyWord FROM ArticleCurrent Where ArticleGUID='" + CourseId + "'"; string SpeakerQueryStr = "Select Top 1 PropertyValue From ArticleCurrentPropertyExt Where PropertyAlias = 'speakerresume' And ArticleGUID='" + CourseId + "'"; string connectingString = ConfigurationManager.ConnectionStrings["zjspccmConnectionString"].ToString(); String SpeakerFile; using (SqlConnection connection = new SqlConnection(connectingString)) { SqlCommand command = new SqlCommand(CoursrQueryStr, connection); connection.Open(); SqlDataReader CourseReder = command.ExecuteReader(); CourseReder.Read(); TopPicLargeLink.NavigateUrl = "ShowVideo.aspx?ID=" + CourseReder[0].ToString(); TopPlayLink.NavigateUrl = "ShowVideo.aspx?ID=" + CourseReder[0].ToString(); TopPicLarge.ImageUrl = DataQuery.GetCoursePicPath(CourseReder[0].ToString(), url, "360x240.png"); TopPicSmall.ImageUrl = DataQuery.GetCoursePicPath(CourseReder[0].ToString(), url, "001.jpg"); SpeakerInfoUrl = DataQuery.GetCoursePicPath(CourseReder[0].ToString(), url, "data/jsData.js"); TopTitle.Text = DataProcessing.SubstringText(CourseReder[2].ToString(), 17); TopSpeaker.Text = DataProcessing.SubstringText(CourseReder[4].ToString(), 17); TopSpeakerInfo.Text = DataProcessing.SubstringText(CourseReder[3].ToString(), 40); TopSpeakerInfo.ToolTip = CourseReder[3].ToString(); TopSummary.Text = DataProcessing.SubstringText(DataProcessing.NoHTML(CourseReder[5].ToString()), 210); TopSummary.ToolTip = DataProcessing.NoHTML(CourseReder[5].ToString()); CourseSperker = CourseReder[4].ToString(); CourseKeyWord = CourseReder[8].ToString(); } //主讲人简介 //using (SqlConnection connection = new SqlConnection(connectingString)) //{ // connection.Open(); // SqlCommand SpeakerCommand = new SqlCommand(SpeakerQueryStr, connection); // SqlDataReader SpeakerReder = SpeakerCommand.ExecuteReader(); // if (SpeakerReder.Read()) // { // SpeakerFile = SpeakerReder[0].ToString(); // string SpeakerFilePath = DataQuery.GetCoursePicPath(CourseId, url, SpeakerFile); // XmlDocument xmlDoc = new XmlDocument(); // try // { // xmlDoc.Load(SpeakerFilePath); // XmlNode root = xmlDoc.SelectSingleNode("Speaker"); // //string SperkerSummary = DataProcessing.NoHTML((root.SelectSingleNode("Information1")).InnerXml); // string SperkerSummary = (root.SelectSingleNode("Information1")).InnerXml; // SperkerSummary = SperkerSummary.Replace("<", "<"); // SperkerSummary = SperkerSummary.Replace(">", ">"); // SperkerSummary = DataProcessing.NoHTML(SperkerSummary); // SperkerSummary = SperkerSummary.Replace("![CDATA[", ""); // SperkerSummary = SperkerSummary.Replace("]]", ""); // SperkerSummary = SperkerSummary.Replace("<", ""); // SperkerSummary = SperkerSummary.Replace(">", ""); // TopSpeakerSummary.Text = DataProcessing.SubstringText(SperkerSummary,45); // } // catch (Exception eXML) // { // } // } //} // 相关列表 string SearchContent = "Author like '%" + CourseSperker + "%'"; string RelatedQueryStr = "SELECT Top 10 ArticleGUID,Title,Author,Area as SpeakerInfo,Filename,CreateTime FROM ArticleCurrent Where " + SearchContent; using (SqlConnection connection = new SqlConnection(connectingString)) { SqlCommand command = new SqlCommand(RelatedQueryStr, connection); connection.Open(); SqlDataReader CourseReder = command.ExecuteReader(); DataTable CourseTable = new DataTable(); CourseTable.Load(CourseReder); CoursesWithSperker.DataSource = CourseTable; CoursesWithSperker.DataBind(); } if (CourseKeyWord != null) { CourseKeyWord = CourseKeyWord.Replace(" ", ","); SearchContent = new DAL.CategoryDAL().GetArticleSearchContent(CourseKeyWord); RelatedQueryStr = "SELECT Top 10 ArticleGUID,Title,Author,Area as SpeakerInfo,Filename,CreateTime FROM ArticleCurrent Where " + SearchContent; using (SqlConnection connection = new SqlConnection(connectingString)) { SqlCommand command = new SqlCommand(RelatedQueryStr, connection); connection.Open(); SqlDataReader CourseReder = command.ExecuteReader(); DataTable CourseTable = new DataTable(); CourseTable.Load(CourseReder); CoursesWithTitle.DataSource = CourseTable; CoursesWithTitle.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/"; DataTable NewsList1Video = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 0, 4); DataTable NewsList1Other = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 4, 8); if (NewsList1Video.Rows.Count > 0) { Level2NewsList1Video.DataSource = NewsList1Video; Level2NewsList1Video.DataBind(); Level2NewsList1Other.DataSource = NewsList1Other; Level2NewsList1Other.DataBind(); } // DataTable NewsList2Video = DataQuery.GetArticleListFromAlias("gxchannel9_topics_6_1", false, "desc", 0, 4); DataTable NewsList2Other = DataQuery.GetArticleListFromAlias("gxchannel9_topics_6_1", false, "desc", 4, 8); if (NewsList2Video.Rows.Count > 0) { Level2NewsList2Video.DataSource = NewsList1Video; Level2NewsList2Video.DataBind(); Level2NewsList2Other.DataSource = NewsList1Other; Level2NewsList2Other.DataBind(); } // string FameListAlias = DataQuery.GetChannelAliasByName("gxchannel10", "名家谈时事"); DataTable Lv2NewsListLeftCourses = DataQuery.GetArticleListFromAlias(FameListAlias, false, "desc", 0, 5); Lv2NewsListLeft.DataSource = Lv2NewsListLeftCourses; Lv2NewsListLeft.DataBind(); //改别名 DataTable Lv2NewsList3BottomInfo = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 0, 3); Level2NewsList3Bottom.DataSource = Lv2NewsList3BottomInfo; Level2NewsList3Bottom.DataBind(); DataTable Lv2NewsList4BottomInfo = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 0, 3); Level2NewsList4Bottom.DataSource = Lv2NewsList4BottomInfo; Level2NewsList4Bottom.DataBind(); // DataTable Lv2NewsList5Info = DataQuery.GetArticleListFromAlias("gxchannel9_topics_3_1", false, "desc", 0, 5); Level2NewsList5.DataSource = Lv2NewsList5Info; Level2NewsList5.DataBind(); Level2NewsList5Image.ImageUrl = DataQuery.GetCoursePicPath(Lv2NewsList5Info.Rows[0][0].ToString(), url, "001.jpg"); DataTable Lv2NewsList6Info = DataQuery.GetArticleListFromAlias("gxchannel9_topics_5_1", false, "desc", 0, 5); Level2NewsList6.DataSource = Lv2NewsList6Info; Level2NewsList6.DataBind(); Level2NewsList6Image.ImageUrl = DataQuery.GetCoursePicPath(Lv2NewsList6Info.Rows[0][0].ToString(), url, "001.jpg"); DataTable Lv2NewsList7Info = DataQuery.GetArticleListFromAlias("gxchannel9_topics_4_1", false, "desc", 0, 5); Level2NewsList7.DataSource = Lv2NewsList7Info; Level2NewsList7.DataBind(); Level2NewsList7Image.ImageUrl = DataQuery.GetCoursePicPath(Lv2NewsList7Info.Rows[0][0].ToString(), url, "001.jpg"); //改别名 DataTable Level2NewsList8Info = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 0, 3); Level2NewsList8.DataSource = Level2NewsList8Info; Level2NewsList8.DataBind(); //改别名 DataTable Level2NewsList9Info = DataQuery.GetArticleListFromAlias("gxchannel9_topics_1_1", false, "desc", 0, 5); Level2NewsList9.DataSource = Level2NewsList9Info; Level2NewsList9.DataBind(); }