public List<UserAnswer> selectUserPaperList()
{
using (SqlConnection con = DBHelp.GetConnection())
{
string sql = @"select
u.UserName,p.PaperName,ua.ExamTime,ua.UserID,ua.PaperID
from
Users as u,Paper as p,UserAnswer as ua
where
ua.UserID = u.UserID and ua.PaperID = p.PaperID and ua.ExamTime = ua.ExamTime and ua.UserID= ua.UserID and ua.PaperID=ua.PaperID
Group by
u.UserName,p.PaperName,ua.ExamTime,ua.UserID,ua.PaperID";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
List<UserAnswer> list = new List<UserAnswer>();
while (dr.Read())
{
UserAnswer user = new UserAnswer();
user.UserID = dr["UserID"].ToString();
user.PaperID = Convert.ToInt32(dr["PaperID"]);
user.ExamTime = Convert.ToDateTime(dr["ExamTime"]);
user.UserName = dr["UserName"].ToString();
user.PaperName = dr["PaperName"].ToString();
list.Add(user);
}
return list;
}
}
//��ѯ�û�������Ϣ
public List<UserAnswer> selectExamInfo(string name)
{
using (SqlConnection con = DBHelp.GetConnection())
{
string sql = @"select
UserName,PaperName,Score,ExamTime,JudgeTime
from
Score,Paper,Users
where
paper.PaperID = Score.PaperID and Users.UserID = Score.UserID and Score.UserID='" + name + "'";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
List<UserAnswer> list = new List<UserAnswer>();
while (dr.Read())
{
UserAnswer user = new UserAnswer();
// user.UserID = dr["UserID"].ToString();
user.UserName = dr["UserName"].ToString();
user.ExamTime = Convert.ToDateTime(dr["ExamTime"]);
// user.UserName = dr["UserName"].ToString();
user.PaperName = dr["PaperName"].ToString();
user.Score = Convert.ToInt32(dr["Score"]);
user.JudgeTime = Convert.ToDateTime(dr["JudgeTime"]);
list.Add(user);
}
return list;
}
}