/// <summary> /// 获取频道 /// </summary> /// <param name="channelId">频道ID</param> /// <returns>频道</returns> public ZhuJi.Modules.RssModule.Domain.RssChannel GetObject(int channelId) { ZhuJi.Modules.RssModule.Domain.RssChannel domainRssChannel = null; SqlParameter parm = new SqlParameter(PARM_CHANNELID, SqlDbType.Int); parm.Value = channelId; using (SqlDataReader rdr = SqlHelper.ExecuteReader(DBFactory.DBConnectionString, CommandType.Text, SQL_SELECT_RSSCHANNEL, parm)) { if (rdr.Read()) { domainRssChannel = new ZhuJi.Modules.RssModule.Domain.RssChannel(); DbManager.BindIDataReaderToObject(rdr, domainRssChannel); using (SqlDataReader rdrItem = SqlHelper.ExecuteReader(DBFactory.DBConnectionString, CommandType.Text, SQL_SELECT_RSSITEM, parm)) { while (rdrItem.Read()) { ZhuJi.Modules.RssModule.Domain.RssItem domainRssItem = new ZhuJi.Modules.RssModule.Domain.RssItem(); DbManager.BindIDataReaderToObject(rdrItem, domainRssItem); domainRssChannel.RssItems.Add(domainRssItem); } } } } return(domainRssChannel); }
/// <summary> /// 获取频道 /// </summary> /// <param name="channelId">频道ID</param> /// <returns>频道</returns> public ZhuJi.Modules.RssModule.Domain.RssChannel GetObject(int channelId) { ZhuJi.Modules.RssModule.Domain.RssChannel domainRssChannel = null; SqlParameter parm = new SqlParameter(PARM_CHANNELID, SqlDbType.Int); parm.Value = channelId; using (SqlDataReader rdr = SqlHelper.ExecuteReader(DBFactory.DBConnectionString, CommandType.Text, SQL_SELECT_RSSCHANNEL, parm)) { if (rdr.Read()) { domainRssChannel = new ZhuJi.Modules.RssModule.Domain.RssChannel(); DbManager.BindIDataReaderToObject(rdr, domainRssChannel); using (SqlDataReader rdrItem = SqlHelper.ExecuteReader(DBFactory.DBConnectionString, CommandType.Text, SQL_SELECT_RSSITEM, parm)) { while (rdrItem.Read()) { ZhuJi.Modules.RssModule.Domain.RssItem domainRssItem = new ZhuJi.Modules.RssModule.Domain.RssItem(); DbManager.BindIDataReaderToObject(rdrItem, domainRssItem); domainRssChannel.RssItems.Add(domainRssItem); } } } } return domainRssChannel; }