我的代码

我的代码

using System;
using System.Collections.Generic;
using System.Text;
using Com.Csddt.BBS.IDAL;
using Com.Csddt.BBS.Model;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data.Oracle;
using System.Data;
using System.Data.OracleClient;
using System.Data.Common;
namespace Com.Csddt.BBS.OracleDAL
{
  public class BBSAnnouncementFactory:IBBSAnnouncement
    {
        private Database db = DatabaseFactory.CreateDatabase("Com.Csddt.bbs.ConnectionString");
        public IList<BBSAnnouncementEntity> Announcement()
        {
            string sql = "select * from bbs_announcement t where rownum<=6 order by t.create_date desc";
            DbCommand cmd = db.GetSqlStringCommand(sql);
            DataSet ds = db.ExecuteDataSet(cmd);
            IList<BBSAnnouncementEntity> list = new List<BBSAnnouncementEntity>();
            using (IDataReader reader = db.ExecuteReader(cmd))
            {
                list = BindData(reader);
            }
            return list;
                        
        }
        public IList<BBSAnnouncementEntity> BindData(IDataReader reader)
        {
            IList<BBSAnnouncementEntity> list = new List<BBSAnnouncementEntity>();
                while ( null != reader&&reader.Read())
                {
                    BBSAnnouncementEntity ent = new BBSAnnouncementEntity();
                    ent.Am_id = Common.Common.ToInt32(reader["Am_id"].ToString(), 0);
                    ent.Am_title = reader["Am_title"].ToString();
                    ent.Am_url =reader["Am_url"].ToString();
                    ent.Create_date = Common.Common.ToDateTime(reader["Create_date"].ToString(), DateTime.Now);
                    ent.Create_userid = Common.Common.ToInt32(reader["Create_userid"].ToString(), 0);
                    list.Add(ent);
                }
      
               return list;
        }
     
    }
}