/// <summary> /// 根据班级Id查询学生列表 /// </summary> /// <param name="classId"></param> /// <returns>返回学生列表</returns> public List <StudentExt> GetStudentByClassId(int classId) { string sql = "select StudentId,StudentName, Gender, Birthday, StudentIdNo, PhoneNumber, ClassName"; sql += " from Students inner join StudentClass on Students.ClassId=StudentClass.ClassId"; sql += " where StudentClass.ClassId=" + classId; List <StudentExt> studentList = new List <StudentExt>(); SqlDataReader reader = SQLHelper.GetReader(sql); //try //{ // while (reader.Read()) // { // studentList.Add(new StudentExt // { // StudentId = Convert.ToInt32(reader["StudentId"]), // StudentName = reader["StudentName"].ToString(), // Gender = reader["Gender"].ToString(), // Birthday = Convert.ToDateTime(reader["Birthday"]), // StudentIdNo = reader["StudentIdNo"].ToString(), // PhoneNumber = reader["PhoneNumber"].ToString(), // ClassName = reader["ClassName"].ToString(), // }); ; // } // reader.Close(); // return studentList; //} //catch (Exception ex) //{ // throw new Exception("查询学生列表时数据库访问异常" + ex.Message); //} return(db.GetAllModeList <StudentExt>(reader)); }