泛型分布式应用_数据访问类

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Collections;
using System.Collections.Generic;
using System.Data.SqlClient;
namespace CSShop.DAL
{
    public class Dz_ZoneDAL
    {
        public IList<CSShop.Model.Dz_Zone> GetZoneList()
        {
            List<CSShop.Model.Dz_Zone> Md = new List<CSShop.Model.Dz_Zone>();
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand("select [id],[ParentID],[ZoneName] from [Dz_Zone]", conn);
                SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (dr.Read())
                {
                    //实体类中没有初始化属性的构造函数
                    //CSShop.Model.Dz_Zone m = new CSShop.Model.Dz_Zone();
                    //m.id = dr["id"].ToString();
                    //m.ParentID = dr["ParentID"].ToString();
                    //m.ZoneName = dr["ZoneName"].ToString();

                    //实体类中有初始化属性的构造函数
                    CSShop.Model.Dz_Zone m = new CSShop.Model.Dz_Zone(int.Parse(dr["id"].ToString()), int.Parse(dr["ParentID"].ToString()), dr["ZoneName"].ToString());
                    Md.Add(m);
                }
                return Md;
            }
        }
    }
}