//单一查询--详细信息
public student GetStudentById(string studentId)
{
string sql = "select * from students where studentId=" + studentId;
MySqlDataReader objReader = MysqlHelper.GetReader(sql);
student objStudent = null;
if (objReader.Read())
{
objStudent = new student()
{
StudentId = Convert.ToInt32(objReader["StudentId"]),
StudentName = objReader["StudentName"].ToString(),
Gender = objReader["Gender"].ToString(),
Birthday = Convert.ToDateTime(objReader["Birthday"]),
CardNo = objReader["CardNo"].ToString(),
StudentIdNo = objReader["StudentIdNo"].ToString(),
PhoneNumber = objReader["PhoneNumber"].ToString(),
StudentAddress = objReader["StudentAddress"].ToString(),
Age = Convert.ToInt16(objReader["Age"]),
ClassId = Convert.ToInt32(objReader["ClassId"])
};
}
objReader.Close();
return(objStudent);
}
public List <student> GetStudentByClass(string className)
{
string sql = "select a.* from students a,studentclass b where a.ClassId=b.ClassId and b.ClassName like '%{0}%'";
sql = string.Format(sql, className);
MySqlDataReader objReader = MysqlHelper.GetReader(sql);
List <student> list = new List <student>();
while (objReader.Read())
{
list.Add(new student
{
StudentId = Convert.ToInt32(objReader["StudentId"]),
StudentName = objReader["StudentName"].ToString(),
Gender = objReader["Gender"].ToString(),
//Birthday = Convert.ToDateTime(objReader["Birthday"]),
//CardNo = objReader["CardNo"].ToString(),
//StudentIdNo=objReader["StudentIdNo"].ToString(),
//PhoneNumber=objReader["PhoneNumber"].ToString(),
//StudentAddress=objReader["StudentAddress"].ToString()
});
}
objReader.Close();
return(list);
}
public SysAdmin AdminLogin(SysAdmin objAdmin)
{
string sql = "select AdminName from Admins where LoginId='{0}' and LoginPwd='{1}'";
sql = string.Format(sql, objAdmin.LoginId, objAdmin.LoginPwd);
try
{
MySqlDataReader objReader = MysqlHelper.GetReader(sql);
if (objReader.Read())
{
objAdmin.AdminName = objReader["AdminName"].ToString();
objReader.Close();
}
else
{
objAdmin = null;
}
}
catch (Exception ex) {
throw new Exception("应用程序和数据库出现问题" + ex.Message);
}
return(objAdmin);
}
