Example #1
0
        /// <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;
        }
Example #3
0
 /// <summary>
 /// 初始化查询列表
 /// </summary>
 public void List()
 {
     try
     {
         ZhuJi.Modules.RssModule.IDAL.IRssChannel  rssChannel       = ZhuJi.AOP.Operator.WrapInterface(typeof(ZhuJi.Modules.RssModule.SQLServerDAL.RssChannel)) as ZhuJi.Modules.RssModule.IDAL.IRssChannel;
         ZhuJi.Modules.RssModule.Domain.RssChannel domainRssChannel = rssChannel.GetObject(_identity);
         if (domainRssChannel != null)
         {
             UIMapping.BindObjectToControls(domainRssChannel, this);
             rptList.DataSource = domainRssChannel.RssItems;
             rptList.DataBind();
         }
     }
     catch (Exception ex)
     {
         ShowMessage(ex);
     }
 }