Model

  1. using System; 
  2. using System.Collections.Generic; 
  3. using System.Linq; 
  4. using System.Text; 
  5.  
  6. namespace NeoModel 
  7. { 
  8.     public class RssReader 
  9.     { 
  10.         public RssReader() 
  11.         { 
  12.         } 
  13.         private int _id; 
  14.         public int ID 
  15.         { 
  16.             get { return _id; } 
  17.             set { _id = value; } 
  18.         } 
  19.  
  20.         private string _title; 
  21.         public string Title 
  22.         { 
  23.             get { return _title; } 
  24.             set { _title = value; } 
  25.         } 
  26.  
  27.         private DateTime? _pubdate; 
  28.         public DateTime? PubDate 
  29.         { 
  30.             get { return _pubdate; } 
  31.             set { _pubdate = value; } 
  32.         } 
  33.  
  34.         private string _guid; 
  35.         public string Guid 
  36.         { 
  37.             get { return _guid; } 
  38.             set { _guid = value; } 
  39.         } 
  40.  
  41.         private string _description; 
  42.         public string Description 
  43.         { 
  44.             get { return _description; } 
  45.             set { _description = value; } 
  46.         } 
  47.     } 
  48. } 

DAL

 

  1. using System; 
  2. using System.Collections.Generic; 
  3. using System.Linq; 
  4. using System.Text; 
  5. using System.Data; 
  6. using System.Data.SqlClient; 
  7. using NeoCommon; 
  8. namespace NeoDAL 
  9. { 
  10.     public class RssReaderDal 
  11.     { 
  12.         public RssReaderDal() 
  13.         { 
  14.         } 
  15.         /// <summary> 
  16.         /// 添加rss 
  17.         /// </summary> 
  18.         /// <param name="rss"></param> 
  19.         /// <returns></returns> 
  20.         public bool AddRssReader(NeoModel.RssReader rss) 
  21.         { 
  22.             string strSql = "Insert into RssReader(title,pubdate,[guid],[description]) values(@title,@pubdate,@guid,@description)"; 
  23.             SqlParameter[] sp = {  
  24.                                new SqlParameter("@title",rss.Title), 
  25.                                new SqlParameter("@pubdate",rss.PubDate), 
  26.                                new SqlParameter("@guid",rss.Guid), 
  27.                                new SqlParameter("@description",rss.Description) 
  28.                                }; 
  29.             return DbHelperSQL.ExecuteSql(strSql, sp) > 0; 
  30.  
  31.         } 
  32.         /// <summary> 
  33.         /// 判断rss是否存在 
  34.         /// </summary> 
  35.         /// <param name="guid"></param> 
  36.         /// <returns></returns> 
  37.         public bool IsExistRssByGuid(string guid) 
  38.         { 
  39.             string strSql = "SELECT COUNT(0) FROM RssReader WHERE [guid]=@guid"; 
  40.             SqlParameter[] sp = {  
  41.                                 new SqlParameter("@guid",guid) 
  42.                                 }; 
  43.             return Convert.ToInt32(DbHelperSQL.GetSingle(strSql, sp)) > 0; 
  44.         } 
  45.         /// <summary> 
  46.         ///  
  47.         /// </summary> 
  48.         /// <returns></returns> 
  49.         public DataTable GetRss() 
  50.         { 
  51.             string strSql = "Select * from RssReader order by pubdate desc"; 
  52.             DataSet ds = DbHelperSQL.Query(strSql); 
  53.             if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) 
  54.             { 
  55.                 return new DataTable(); 
  56.             } 
  57.             return ds.Tables[0]; 
  58.         } 
  59.  
  60.     } 
  61. } 

BLL

 

  1. using System; 
  2. using System.Collections.Generic; 
  3. using System.Linq; 
  4. using System.Text; 
  5. using System.Data; 
  6.  
  7. namespace NeoBLL 
  8. { 
  9.     public class RssReader 
  10.     { 
  11.         NeoDAL.RssReaderDal dal = new NeoDAL.RssReaderDal(); 
  12.         public RssReader() { } 
  13.  
  14.         /// <summary> 
  15.         ///  
  16.         /// </summary> 
  17.         /// <param name="rss"></param> 
  18.         /// <returns></returns> 
  19.         public bool AddRssReader(NeoModel.RssReader rss) 
  20.         { 
  21.             return dal.AddRssReader(rss); 
  22.         } 
  23.         /// <summary> 
  24.         ///  
  25.         /// </summary> 
  26.         /// <param name="guid"></param> 
  27.         /// <returns></returns> 
  28.         public bool IsExistRssByGuid(string guid) 
  29.         { 
  30.             return dal.IsExistRssByGuid(guid); 
  31.         } 
  32.         public DataTable GetRss() 
  33.         { 
  34.             return dal.GetRss(); 
  35.         } 
  36.     } 
  37. } 

页面源

 

  1. <%@ Page Title="" Language="C#" MasterPageFile="~/master/Oa.Master" AutoEventWireup="true" 
  2.     CodeBehind="RssReader.aspx.cs" Inherits="NeoBackground.Baidu.RssReader" %> 
  3.  
  4. <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server"> 
  5.     <style type="text/css"> 
  6.         .title 
  7.         { 
  8.             font-size: 11pt; 
  9.             margin: 5px 0; 
  10.             background: transparent url(../p_w_picpaths/icon.rss.current.png) no-repeat 4px 50%; 
  11.             padding-left: 28px; 
  12.             word-break: break-word; 
  13.             -webkit-user-select: text; 
  14.         } 
  15.         h3, h4 
  16.         { 
  17.             padding: 0; 
  18.         } 
  19.         a 
  20.         { 
  21.             color: #036; 
  22.         } 
  23.         h3 
  24.         { 
  25.             display: block; 
  26.             -webkit-margin-before: 1em; 
  27.             -webkit-margin-after: 1em; 
  28.             -webkit-margin-start: 0px; 
  29.             -webkit-margin-end: 0px; 
  30.             font-weight: bold; 
  31.         } 
  32.         h4 
  33.         { 
  34.             display: block; 
  35.             -webkit-margin-before: 1.33em; 
  36.             -webkit-margin-after: 1.33em; 
  37.             -webkit-margin-start: 0px; 
  38.             -webkit-margin-end: 0px; 
  39.         } 
  40.         .updated 
  41.         { 
  42.             color: #666; 
  43.             font-weight: normal; 
  44.              padding-left:8px; 
  45.             margin: 5px 0; 
  46.         } 
  47.         .description 
  48.         { 
  49.             margin: 14px 20px 20px 0; 
  50.             padding-left:8px; 
  51.             max-width: 850px; 
  52.             line-height: 1.8; 
  53.             font-size: 10pt; 
  54.             word-break: break-word; 
  55.         } 
  56.         .actions 
  57.         { 
  58.             padding: 5px 8px; 
  59.             background-color: #f4f5f5; 
  60.             border-radius: 3px; 
  61.              width:99%; 
  62.         } 
  63.         div 
  64.         { 
  65.             display: block; 
  66.             width: 100%; 
  67.         } 
  68.         body 
  69.         { 
  70.             color: Black; 
  71.             cursor: default; 
  72.             font-size: 9pt; 
  73.             font-family: Segoe UI, 微软雅黑 , Tahoma; 
  74.         } 
  75.     </style> 
  76. </asp:Content> 
  77. <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> 
  78.     <asp:Repeater ID="reprss" runat="server"> 
  79.         <ItemTemplate> 
  80.             <div style=" margin:10px; padding:5px; background-color:White; border:1px #ccc solid; border-radius:4px;"> 
  81.                 <div> 
  82.                     <h3 class="title"> 
  83.                         <a href="<%#Eval("guid") %>" target="_blank"> 
  84.                             <%#Eval("title") %></a></h3> 
  85.                     <h4 class="updated"> 
  86.                         <%#Eval("pubdate")%> 
  87.                     </h4> 
  88.                 </div> 
  89.                 <div class="description"> 
  90.                     <%#Eval("description")%><br /> 
  91.                    
  92.                 </div> 
  93.                 <div class="actions"> 
  94.                     <a href="<%#Eval("guid") %>"  target="_blank">打开页面</a> 
  95.                 </div> 
  96.             </div> 
  97.         </ItemTemplate> 
  98.     </asp:Repeater> 
  99. </asp:Content> 

后台

 

  1. using System; 
  2. using System.Collections.Generic; 
  3. using System.Linq; 
  4. using System.Web; 
  5. using System.Web.UI; 
  6. using System.Web.UI.WebControls; 
  7. using System.Xml; 
  8. using System.Data; 
  9. namespace NeoBackground.Baidu 
  10. { 
  11.     public partial class RssReader : System.Web.UI.Page 
  12.     { 
  13.         NeoBLL.RssReader bll = new NeoBLL.RssReader(); 
  14.         protected void Page_Load(object sender, EventArgs e) 
  15.         { 
  16.             if (!IsPostBack) 
  17.             { 
  18.                 // WriterRss(); 
  19.                 DataTable dt = bll.GetRss(); 
  20.                 this.reprss.DataSource = dt; 
  21.                 this.reprss.DataBind(); 
  22.             } 
  23.         } 
  24.  
  25.  
  26.  
  27.         public void WriterRss() 
  28.         { 
  29.             string url = "http://feed.cnblogs.com/news/rss"; 
  30.             XmlDocument document = new XmlDocument(); 
  31.             document.Load(url);// 
  32.             XmlNodeList list = document.GetElementsByTagName("item"); 
  33.             if (document.HasChildNodes) 
  34.             { 
  35.                 foreach (XmlNode xn in list) 
  36.                 { 
  37.                     if (xn.HasChildNodes) 
  38.                     { 
  39.  
  40.                         NeoModel.RssReader rss = new NeoModel.RssReader(); 
  41.                         XmlNodeList xlcd = xn.ChildNodes; 
  42.                         foreach (XmlNode xmlchild in xlcd) 
  43.                         { 
  44.                             switch (xmlchild.Name)//节点的限定名字 
  45.                             { 
  46.                                 case "title": 
  47.                                     rss.Title = xmlchild.InnerText; 
  48.                                     break; 
  49.                                 case "pubDate": 
  50.                                     rss.PubDate = Convert.ToDateTime(xmlchild.InnerText); 
  51.                                     break; 
  52.                                 case "guid": 
  53.                                     rss.Guid = xmlchild.InnerText; 
  54.                                     break; 
  55.                                 case "description": 
  56.                                     rss.Description = xmlchild.InnerText; 
  57.                                     break; 
  58.                                 default: 
  59.                                     break; 
  60.                             } 
  61.                         } 
  62.                         if (!bll.IsExistRssByGuid(rss.Guid)) 
  63.                         { 
  64.                             bll.AddRssReader(rss); 
  65.                         } 
  66.                     } 
  67.                 } 
  68.             } 
  69.         } 
  70.     } 
  71. } 

显示如下图：

 

读取博客园rss_Xml