/// <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;
}
