DBhelpaer类
public static SqlDataReader GetReader(string sql)
{
SqlCommand cmd = new SqlCommand(sql, Conn);
return cmd.ExecuteReader();
}
DAO
public IList<Class> GetClasslist()
{
List<Class> Class = new List<Class>();
StringBuilder strsql = new StringBuilder();
strsql.Append("select top 10 * from gg_sys_class");
SqlDataReader dr=DBhelpaer.GetReader(strsql.ToString());
if (dr.HasRows)
{
while (dr.Read())
{
Class.Add(SetClass(dr));
}
}
return Class;
}