/// <summary>
/// 根据学号查询学生。
/// </summary>
/// <param name="number">要查询的学生学号</param>
/// <returns>除密码、IP、注册时间外的所有学生信息</returns>
public static Student queryStudent(string number)
{
try
{
string sql = "select username,sex,grade,age,major from users where username=?1;";
MySqlParameter[] para = new MySqlParameter[1];
para[0] = new MySqlParameter("?1", number);
DataTable dataTable = DAL_MysqlHelper.ExecuteDataTable(sql, para).Tables[0];
Student student = new Student("", "", "", "", "", "", "", "");
if (dataTable != null)
{
student.username = dataTable.Rows[0]["username"].ToString();
student.sex = dataTable.Rows[0]["sex"].ToString();
student.age = dataTable.Rows[0]["age"].ToString();
student.grade = dataTable.Rows[0]["grade"].ToString();
student.major = dataTable.Rows[0]["major"].ToString();
}
return(student);
}
catch (Exception e)
{
LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "queryStudent:" + e.Message);
return(null);
}
}
public static DataSet queryAllTeam()
{
DataSet ds = null;
try
{
string sql = "select team.*,teacher.TeaName from teacher inner join team on teacher.username=team.TeaID";
ds = DAL_MysqlHelper.ExecuteDataTable(sql);
}
catch
{
}
return(ds);
}
public static DataSet queryMember(string TeamID)
{
string sql = "select b.username,b.major,a.AuditStatus from team_member a, users b where a.StuID=b.username and a.TeamID=?0";
MySqlParameter para = new MySqlParameter("?0", TeamID);
try
{
return(DAL_MysqlHelper.ExecuteDataTable(sql, para));
}
catch (Exception e)
{
return(null);
}
}
/// <summary>
/// 查询所有学生信息。
/// </summary>
/// <returns>DataSet</returns>
public static DataSet queryAllStudent()
{
DataSet ds = null;
try
{
string sql = "select username,sex,grade,age,major,IP,regtime,id from users;";
ds = DAL_MysqlHelper.ExecuteDataTable(sql);
}
catch
{
}
return(ds);
}
public static string queryJoinStatus(string teamID, string stuID)
{
try
{
string sql = "select AuditStatus from team_member where TeamID=?0 and StuID=?1";
MySqlParameter[] para = { new MySqlParameter("?0", teamID), new MySqlParameter("?1", stuID) };
DataSet ds = DAL_MysqlHelper.ExecuteDataTable(sql, para);
if (ds.Tables[0].Rows.Count == 0)
{
return("未加入*");
}
else
{
return(ds.Tables[0].Rows[0].ItemArray[0].ToString());
}
}
catch
{
return("ERROR");
}
}
public static string queryTeamAuditMode(string teamID)
{
string sql = "select AuditMode from team where teamID=?0";
MySqlParameter para = new MySqlParameter("?0", teamID);
try
{
DataSet ds = DAL_MysqlHelper.ExecuteDataTable(sql, para);
if (ds.Tables[0].Rows.Count == 0)
{
return("");
}
else
{
return(ds.Tables[0].Rows[0].ItemArray[0].ToString());
}
}
catch
{
return("ERROR");
}
}
/// <summary>
/// 根据用户名查询教师。
/// </summary>
/// <param name="number">用户名</param>
/// <returns></returns>
public static Teacher queryTeacher(string number)
{
try
{
string sql = "select username,sex,age from teacher where username=?1;";
MySqlParameter[] para = new MySqlParameter[1];
para[0] = new MySqlParameter("?1", number);
DataTable dataTable = DAL_MysqlHelper.ExecuteDataTable(sql, para).Tables[0];
Teacher teacher = new Teacher("", "", "", "");
if (dataTable != null)
{
teacher.username = dataTable.Rows[0]["username"].ToString();
teacher.sex = dataTable.Rows[0]["sex"].ToString();
teacher.age = dataTable.Rows[0]["age"].ToString();
}
return(teacher);
}
catch (Exception e)
{
LogWriter.writeLine(@"C:\WEB_ASP\logs\DAL.log", "queryTeacher:" + e.Message);
return(null);
}
}
