课程考试辅助系统软件程序

一、 考试、评分模块
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace CES
{
    public partial class frmEP : Form
    {
        public frmEP()
        {
            InitializeComponent();
        }
        public   int number = 1;//存放题目号
        public static  int id=1;//存放试题ID
        
        public static string answer = null;//存放相应试题的答案
        public static bool IsAnswered=false ;
        public static int answeredID = 0;
        //向lbxEP中添加试题的方法
        private void AppendString()
        {
          string sqlQ = "select Question from Course where ID='" + list[list_Index]  + "'";

          string sqlA = "select A from Course where ID=" + list[list_Index] + "";
          string sqlB = "select B from Course where ID=" + list[list_Index] + "";
          string sqlC = "select C from Course where ID=" + list[list_Index] + "";
          string sqlD = "select D from Course where ID=" + list[list_Index] + "";
          string sqlR = "select RightAnswer from Course where ID=" + list[list_Index] + "";
          string[] EP_Info = { number +"、"+DBhelper.ExecuteScalar(sqlQ).ToString(),"", "A："
                                 +DBhelper.ExecuteScalar(sqlA).ToString(), "","B："+DBhelper.ExecuteScalar(sqlB).ToString(), "","C："
                                 +DBhelper.ExecuteScalar(sqlC).ToString(), "","D："+DBhelper.ExecuteScalar(sqlD).ToString() };
          lbxEP.Items.Clear();
          lbxEP.Items.AddRange(EP_Info );
        }
        /// <summary>
        /// 生成试卷的方法
        /// </summary>
        /// 
        int list_Index = 0;
        //集合List,用来随机生成试卷
        List<int> list = new List<int>();
        private void EP()
        {
            Random rd = new Random();
            int n1 = rd.Next(1, 103);
            list.Add(n1);
            //for (int i = 0; i <=50; i++)
            //{
            //    int n2 = rd.Next(1,50);
            //    if (!list.Contains(n2))
            //    {
            //        list.Add(n2 );
            //    }