/// <summary>
/// 通过学号查找学生
/// </summary>
/// <param name="StudentId"></param>
/// <returns>学生信息</returns>
public StudentsExt queryStudentByStudentId(int StudentId)
{
string sql = "Select Students.StudentId,StudentName,Gender,Birthday,StudentIdNo,CardNo,PhoneNumber,StudentAddress,Students.ClassId,ClassName,SQLServerDB,CSharp"
+ " from Students join StudentClass on Students.ClassId=StudentClass.ClassId "
+ "join ScoreList on ScoreList.StudentId=Students.StudentId "
+ " where Students.StudentId=@StudentId";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@StudentId", StudentId)
};
StudentsExt stu = null;
SqlDataReader result = new Helper.SQLHelper().QueryAll(sql, param, false);
while (result.Read())
{
stu = new StudentsExt()
{
StudentId = Convert.ToInt32(result["StudentId"]),
StudentName = result["StudentName"].ToString(),
Gender = result["Gender"].ToString(),
Birthday = Convert.ToDateTime(result["Birthday"]),
StudentIdNo = result["StudentIdNo"].ToString(),
CardNo = result["CardNo"].ToString(),
PhoneNumber = result["PhoneNumber"].ToString(),
StudentAddress = result["StudentAddress"].ToString(),
ClassId = Convert.ToInt32(result["ClassId"]),
ClassName = result["ClassName"].ToString(),
SQLServerDB = Convert.ToInt32(result["SQLServerDB"]),
CSharp = Convert.ToInt32(result["CSharp"])
};
}
result.Close();
return(stu);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="user"></param>
/// <returns>返回Admins</returns>
public Admins Login(Admins user)
{
string sql = "Select AdminName from Admins where LoginId=@LoginId and LoginPwd=@LoginPwd";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd)
};
try
{
SqlDataReader result = new Helper.SQLHelper().QueryAll(sql, param, false);
while (result.Read())
{
user.LoginName = result["AdminName"].ToString();
if (user.LoginName == null)
{
user = null;
}
}
result.Close();
}
catch (Exception ex)
{
throw new Exception("系统异常！" + ex.Message);
}
return(user);
}
/// <summary>
/// 通过班级名查询学生
/// </summary>
/// <param name="ClassName"></param>
/// <returns>学生列表</returns>
public List <StudentsExt> queryStudentsbyClassName(string ClassName)
{
string sql = "Select Students.StudentId,StudentName,Gender,Birthday,StudentIdNo,CardNo,PhoneNumber,StudentAddress,Students.ClassId,ClassName,SQLServerDB,CSharp"
+ " from Students join StudentClass on Students.ClassId=StudentClass.ClassId "
+ "join ScoreList on ScoreList.StudentId=Students.StudentId "
+ " where ClassName like '%' + @ClassName + '%' ";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ClassName", ClassName)
};
List <StudentsExt> stus = new List <StudentsExt>();
try
{
SqlDataReader result = new Helper.SQLHelper().QueryAll(sql, param, false);
while (result.Read())
{
stus.Add(new StudentsExt {
StudentId = Convert.ToInt32(result["StudentId"]),
StudentName = result["StudentName"].ToString(),
Gender = result["Gender"].ToString(),
Birthday = Convert.ToDateTime(result["Birthday"]),
StudentIdNo = result["StudentIdNo"].ToString(),
CardNo = result["CardNo"].ToString(),
PhoneNumber = result["PhoneNumber"].ToString(),
StudentAddress = result["StudentAddress"].ToString(),
ClassId = Convert.ToInt32(result["ClassId"]),
ClassName = result["ClassName"].ToString(),
SQLServerDB = Convert.ToInt32(result["SQLServerDB"]),
CSharp = Convert.ToInt32(result["CSharp"])
});
}
result.Close();
return(stus);
}catch (Exception ex)
{
throw ex;
}
}
