关于集合类的做法!

类工程：
using System;
using System.Data;

namespace MyProduct.Employee
{
 /// <summary>
 /// Employee的实体类
 /// </summary>
 public class EmployeeEntity
 {
        private int mEmployeeID;
        private string mLastName;
        private string mFirstName;

        public int EmployeeID
        {
            get { return mEmployeeID; }
            set { mEmployeeID = value; }
        }
        public string LastName
        {
            get { return mLastName; }
            set { mLastName = value; }
        }
        public string FirstName
        {
            get { return mFirstName; }
            set { mFirstName = value; }
        }

  public EmployeeEntity()
  {
  
  }

        /// <summary>
        /// 构造函数，给实体类赋值
        /// </summary>
        /// <param name="pDR">DataRow</param>
        public EmployeeEntity(DataRow pDR)
        {
            Fill(pDR);
        }

        /// <summary>
        /// 给实体类赋值
        /// </summary>
        /// <param name="pDR">DataRow</param>
        public void Fill(DataRow pDR)
        {           
            foreach( System.Reflection.PropertyInfo pi in this.GetType().GetProperties())
            {
                if (pi.CanWrite)
                {
                    try
                    {
                        if (pDR[ pi.Name ] != null && !pDR.IsNull( pi.Name ) )
                        {     
                            pi.Setvalue(this, pDR[ pi.Name ], null);
                        }
                        else
                        {
                            pi.Setvalue(this, null, null);
                        }
                    }
                    catch
                    {
                        pi.Setvalue(this, null, null);
                    }
                }
            }
  
        }
 }

    /// <summary>
    /// Employee的集合类
    /// </summary>
    public class EmployeeList : System.Collections.CollectionBase
    {

        public EmployeeList()
        {
  
        }

        /// <summary>
        /// 构造函数，给集合类赋值
        /// </summary>
        /// <param name="pDT">DataTable</param>
        public EmployeeList(DataTable pDT)
        {
            Fill(pDT);
        }

        /// <summary>
        /// 给集合类赋值
        /// </summary>
        /// <param name="pDT">DataTable</param>
        public void Fill(DataTable pDT)
        {
            foreach(DataRow pDR in pDT.Rows)
            {
                this.InnerList.Add( new EmployeeEntity( pDR ) );
            }
        }

        /// <summary>
        /// 索引
        /// </summary>
        public virtual EmployeeEntity this[int Index]
        {
            get
            {
                return (EmployeeEntity)this.List[Index];
            }
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="pEmp">实体类</param>
        public virtual void Add(EmployeeEntity pEmp)
        {
            this.List.Add(pEmp);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="Index">index</param>
        public virtual void Remove(int Index)
        {
            this.List.RemoveAt(Index);
        }
    }

    /// <summary>
    /// Employee业务类
    /// </summary>
    public class EmployeeRule
    {
        /// <summary>
        /// 获取所有
        /// </summary>
        /// <returns></returns>
        public EmployeeList GetAllEmployees()
        {
            string sql;
            sql="select * from employees";
            DataTable pDT=ExeForDtl(sql);

            EmployeeList emplist=new EmployeeList();           
            emplist.Fill(pDT);
            return emplist;
        }

        /// <summary>
        /// 获取一个
        /// </summary>
        /// <param name="pEmployeeID"></param>
        /// <returns></returns>
        public EmployeeEntity GetOneEmployee(int pEmployeeID)
        {
            string sql;
            sql="select * from employees where employeeid="+pEmployeeID;
          
            DataTable pDT=new DataTable();
            pDT=ExeForDtl(sql);
            if(pDT.Rows.Count>0)
            {
                return new EmployeeEntity(pDT.Rows[0]);
            }
            else
            {
                return null;
            }
        }
    }
}

Web工程：
这里的Web工程说明了怎样去调用我们写的集合类。

1。在DataGrid中使用集合类
直接绑定：
EmployeeRule empRule=new EmployeeRule();
DataGrid1.DataSource=empRule.GetAllEmployees();
DataGrid1.DataBind();

手工添加绑定：
EmployeeEntity emp=new EmployeeEntity();
emp.EmployeeID=10;
emp.FirstName="mike";
emp.LastName="daoson";
EmployeeList empList=new EmployeeList();
empList.Add(emp);
DataGrid1.DataSource=empList;
DataGrid1.DataBind();

2。给文本框赋值
EmployeeEntity emp=new EmployeeEntity();
emp=empRule.GetOneEmployee(1);
txtEmployeeID.Text=emp.EmployeeID.ToString();
txtFirstName.Text=emp.FirstName;
txtLastName.Text=emp.LastName;

下面讲一下此种方法的优缺点：
优点：
1。通过反射，循环给属性赋值，省去了给属性赋值的大量工作量
2。集合类可以直接绑定到DataGrid中
3。自己如果想构造一个虚拟的DataTable，可以通过集合类来做
4。这种方法可以用foreach做循环来检索出他的实体类
5。这里可以直接把datarow赋给实体类，也可以给实体类手工赋值

缺点：
1。数据库中的字段名必须要和实体类中的属性相一致
2。如果是多个表关联，那么集合类就不能绑定到DataGrid