public Student GetStudent(string id)
{
string sql = "select * from Student where id='{0}'".FormatWith(id);
SqlDataReader dr = SqlHelper.ExecuteReader(ConStr, CommandType.Text, sql);
if (dr.HasRows == false) return null;
dr.Read();
var stu = new Student(
dr["Name"].ToString(),
dr["Id"].ToString(),
dr["Major"].ToString(),
dr["Degree"].ToString());
dr.Close();
dr.Dispose();
//访问数据库，获取选课信息
var attends = new List<Section>();
string sql1 = @"select * from AttendSection where StudentNumber ='{0}'".FormatWith(id);
DataTable attendSec = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql1).Tables[0];
var secDAO = new SectionDAO();
foreach (DataRow r in attendSec.Rows)
{
attends.Add(secDAO.GetSection(r["SectionNumber"].ConvertToIntBaseZero()));
}
stu.Attends = attends;
return stu;
}
public Student GetStudent(string id)
{
string sql = "select * from Student where id='{0}'".FormatWith(id);
SqlDataReader dr = SqlHelper.ExecuteReader(ConStr, CommandType.Text, sql);
if (dr.HasRows == false)
{
return(null);
}
dr.Read();
var stu = new Student(
dr["Name"].ToString(),
dr["Id"].ToString(),
dr["Major"].ToString(),
dr["Degree"].ToString());
dr.Close();
dr.Dispose();
//访问数据库，获取选课信息
var attends = new List <Section>();
string sql1 = @"select * from AttendSection where StudentNumber ='{0}'".FormatWith(id);
DataTable attendSec = SqlHelper.ExecuteDataset(ConStr, CommandType.Text, sql1).Tables[0];
var secDAO = new SectionDAO();
foreach (DataRow r in attendSec.Rows)
{
attends.Add(secDAO.GetSection(r["SectionNumber"].ConvertToIntBaseZero()));
}
stu.Attends = attends;
return(stu);
}
