//���뿼�Գɼ�
        public static bool InsertScore(Scores score, string PaperName, string userId, int paperId)
        {
            if (SeclctCheck(userId, paperId))
            {
                using (SqlConnection con = DBHelp.GetConnection())
                {
                    string sql = @"insert into Score
            (UserID,PaperID,Score,ExamTime,JudgeTime)
            select
            @UserID,
            PaperID,
            @Score,
            @ExamTime,
            @JudgeTime
            from
            Paper
            where
            PaperName = '" + PaperName + "'";

                    SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@UserId",score.UserID),
                    new SqlParameter("@PaperID",score.PaperID),
                    new SqlParameter("@Score",score.Score),
                    new SqlParameter("@ExamTime",score.ExamTime),
                    new SqlParameter("@JudgeTime",score.JudgeTime)
                };

                    int i = DBHelp.ExecuteCommand(sql, para);
                    if (i > 0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }

            }
            return false;
        }
 public static bool InsertScores(Scores scores, string PaperName,string userId, int paperId)
 {
     if (UserService.InsertScore(scores, PaperName, userId, paperId))
     {
         return true;
     }
     else
     {
         return false;
     }
 }
        public List<Scores> SelectAll()
        {
            using (SqlConnection conn = DBHelp.GetConnection())
            {
                string sql = @"select ID,Score.UserID,PaperID,Score,ExamTime,JudgeTime,Users.UserName from Score,Users
            where Score.UserID=Users.UserID";
                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = sql;

                conn.Open();

                SqlDataReader dr = cmd.ExecuteReader();

                List<Scores> list = new List<Scores>();

                while (dr.Read())
                {
                    Users user = new Users();
                    Scores scores = new Scores();

                    scores.ID = Convert.ToInt32(dr["ID"]);
                    scores.UserID = dr["UserID"].ToString();
                    user.UserName = dr["UserName"].ToString();
                    scores.UserName = user.UserName;
                    scores.PaperID = Convert.ToInt32(dr["PaperID"]);
                    scores.Score = Convert.ToInt32(dr["Score"]);
                    scores.ExamTime = Convert.ToDateTime(dr["ExamTime"]);
                    scores.JudgeTime = Convert.ToDateTime(dr["JudgeTime"]);

                    list.Add(scores);
                }

                dr.Close();

                conn.Close();

                return list;
            }
        }
 public List<Scores> SelectUserScores(string userID)
 {
     using (SqlConnection conn = DBHelp.GetConnection())
     {
         string sql = @"select * from Score where Score.userID  = '" + userID + "'";
         SqlCommand cmd = conn.CreateCommand();
         cmd.CommandText = sql;
         conn.Open();
         SqlDataReader sdr = cmd.ExecuteReader();
         List<Scores> list = new List<Scores>();
         while (sdr.Read())
         {
             Scores score = new Scores();
             score.ID=  Convert.ToInt32(sdr["ID"]);
             score.PaperID = Convert.ToInt32(sdr["PaperID"]);
             score.Score = Convert.ToInt32(sdr["Score"]);
             score.ExamTime = Convert.ToDateTime(sdr["ExamTime"]);
             score.JudgeTime = Convert.ToDateTime(sdr["JudgeTime"]);
             score.UserID = sdr["UserID"].ToString();
             score.UserName = SelectUserName(score.UserID);
             list.Add(score);
         }
         sdr.Close();
         conn.Close();
         return list;
     }
 }