/// <summary>
/// 根据登录账号和密码登录
/// </summary>
/// <param name="objAdmin">封装了登录账号和密码的管理员对象</param>
/// <returns>返回包含管理员信息的对象</returns>
public SysAdmin AdminLogin(SysAdmin objAdmin)
{
//组合SQL语句
string sql = "select AdminName from Admins where LoginId={0} and LoginPwd='{1}'";
sql = string.Format(sql, objAdmin.LoginId, objAdmin.LoginPwd);
//从数据库中查询
SqlDataReader objReader = SQLHelper.GetReader(sql);
if (objReader.Read())
{
objAdmin.AdminName = objReader["AdminName"].ToString();
}
else
{
objAdmin = null;//如果登录不成功，则将当前对象清空
}
objReader.Close();
return(objAdmin);
}
public List <StudentExt> GetStudentByClass(string className)
{
string sql = "select StudentName,StudentId,Gender,Birthday,ClassName from Students ";
sql += " inner join StudentClass on Students.ClassId=StudentClass.ClassId ";
sql += " where ClassName='{0}'";
sql = string.Format(sql, className);
SqlDataReader objReader = SQLHelper.GetReader(sql);
List <StudentExt> list = new List <StudentExt>();
while (objReader.Read())
{
list.Add(new StudentExt()
{
StudentId = Convert.ToInt32(objReader["StudentId"]),
StudentName = objReader["StudentName"].ToString(),
Gender = objReader["Gender"].ToString(),
BirthDay = Convert.ToDateTime(objReader["Birthday"]),
ClassName = objReader["ClassName"].ToString()
});
}
objReader.Close();
return(list);
}