projclass.cs

在线考试系统 主要真对考试 开发的个人项目

        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_student_StatusUpdate", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@stuId", SqlDbType.VarChar, 15).Value = stuId;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myCommand.Parameters.Add("@stuStatus", SqlDbType.Int).Value = status;
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;//成功
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;//失败

        }
        finally
        {
            myConnection.Close();
        }

    }

    public int updateStuPwd(string stuId, string pwd)
    //在学生表里对学生的密码进行修改
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_student_pwdUpdate", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@stuId", SqlDbType.VarChar, 15).Value = stuId;
        myCommand.Parameters.Add("@stuPwd", SqlDbType.VarChar, 10).Value = pwd;
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;//成功
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;//失败

        }
        finally
        {
            myConnection.Close();
        }


    }

    //添加单选题
    public int insertTest(string testContent, string testAns1, string testAns2, string testAns3, string testAns4, int rightAns, int pub, int testScore, string testCourseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_insert", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        myCommand.Parameters.Add("@testAns1", SqlDbType.VarChar, 50).Value = testAns1;
        myCommand.Parameters.Add("@testAns2", SqlDbType.VarChar, 50).Value = testAns2;
        myCommand.Parameters.Add("@testAns3", SqlDbType.VarChar, 50).Value = testAns3;
        myCommand.Parameters.Add("@testAns4", SqlDbType.VarChar, 50).Value = testAns4;
        myCommand.Parameters.Add("@rightAns", SqlDbType.Int).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;
        myCommand.Parameters.Add("@testCourseId", SqlDbType.VarChar, 20).Value = testCourseId;

        try
        {
            myConnection.Open();
            int count = myCommand.ExecuteNonQuery();
            return count;
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;

        }
        finally
        {
            myConnection.Close();
        }

    }

    //添加多选题
    public int insertTestDuoXuan(string testContent, string testAns1, string testAns2, string testAns3, string testAns4, string rightAns, int pub, int testScore, string testCourseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testDuoXuan_insert", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        myCommand.Parameters.Add("@testAns1", SqlDbType.VarChar, 50).Value = testAns1;
        myCommand.Parameters.Add("@testAns2", SqlDbType.VarChar, 50).Value = testAns2;
        myCommand.Parameters.Add("@testAns3", SqlDbType.VarChar, 50).Value = testAns3;
        myCommand.Parameters.Add("@testAns4", SqlDbType.VarChar, 50).Value = testAns4;
        myCommand.Parameters.Add("@rightAns", SqlDbType.VarChar,20).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;
        myCommand.Parameters.Add("@testCourseId", SqlDbType.VarChar, 20).Value = testCourseId;

        try
        {
            myConnection.Open();
            int count = myCommand.ExecuteNonQuery();
            return count;
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;

        }
        finally
        {
            myConnection.Close();
        }

    }
    //添加判断题
    public int insertTestIf(string testContent, string  rightAns, int pub, int testScore, string testCourseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testIf_insert", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        
        myCommand.Parameters.Add("@rightAns", SqlDbType.VarChar, 20).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;
        myCommand.Parameters.Add("@testCourseId", SqlDbType.VarChar, 50).Value = testCourseId;

        try
        {
            myConnection.Open();
            int count = myCommand.ExecuteNonQuery();
            return count;
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;

        }
        finally
        {
            myConnection.Close();
        }

    }
    public string getCourseIdAsCourseName(string courseName)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_course_selectCourseIdAsCourseName", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseName", SqlDbType.VarChar, 20).Value = courseName;
        myConnection.Open();
        SqlDataReader thisReader = myCommand.ExecuteReader();
        if (thisReader.Read())
        {
            return thisReader.GetString(0);
        }
        else return "none";

    }
  public string getCourseNameAsCourseId(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_course_selectCourseNameAsCourseId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        SqlDataReader thisReader = myCommand.ExecuteReader();
        if (thisReader.Read())
        {
            return thisReader.GetString(0);
        }
        else return "none";

    }
    public bool getIsTestAsCourseId(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_course_isTest_select", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        SqlDataReader thisReader = myCommand.ExecuteReader();
        if (thisReader.Read())
        {
            bool isTest = thisReader.GetBoolean(0);
            return isTest;
        }
        else return false;

    }
    public DataSet getTestInfoAsId(string testId)
    //根据试题ID来获取单选试题详细信息
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_selectAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }
    public DataSet getTestDuoXuanInfoAsId(string testId)
    //根据试题ID来获取多选试题详细信息
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testDuoXuan_selectAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }
    public DataSet getTestIfInfoAsId(string testId)
    //根据试题ID来获取多选试题详细信息
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testIf_selectAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }
    public int updateTestInfo(string testId, string testContent, string testAns1, string testAns2, string testAns3, string testAns4, int rightAns, int pub, int testScore, string testCourseId)
    //更新试题信息,返回1表示更新成功,返回0则更新失败
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_update", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        myCommand.Parameters.Add("@testAns1", SqlDbType.VarChar, 50).Value = testAns1;
        myCommand.Parameters.Add("@testAns2", SqlDbType.VarChar, 50).Value = testAns2;
        myCommand.Parameters.Add("@testAns3", SqlDbType.VarChar, 50).Value = testAns3;
        myCommand.Parameters.Add("@testAns4", SqlDbType.VarChar, 50).Value = testAns4;
        myCommand.Parameters.Add("@rightAns", SqlDbType.Int).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;
        myCommand.Parameters.Add("@testCourseId", SqlDbType.VarChar, 20).Value = testCourseId;
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;

        }
        finally
        {
            myConnection.Close();
        }


    }


    //更新多选题信息
    public int updateTestDuoXuanInfo(string testId, string testContent, string testAns1, string testAns2, string testAns3, string testAns4, string rightAns, int pub, string testCourseId, int testScore)
    //更新试题信息,返回1表示更新成功,返回0则更新失败
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testDuoXuan_update", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        myCommand.Parameters.Add("@testAns1", SqlDbType.VarChar, 50).Value = testAns1;
        myCommand.Parameters.Add("@testAns2", SqlDbType.VarChar, 50).Value = testAns2;
        myCommand.Parameters.Add("@testAns3", SqlDbType.VarChar, 50).Value = testAns3;
        myCommand.Parameters.Add("@testAns4", SqlDbType.VarChar, 50).Value = testAns4;
        myCommand.Parameters.Add("@rightAns", SqlDbType.VarChar,20).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testCourse", SqlDbType.VarChar, 50).Value = testCourseId;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;       
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;

        }
        finally
        {
            myConnection.Close();
        }


    }

    //更新判断题
    public int updateTestIfInfo(string testId, string testContent,string rightAns, int pub, int testScore, string testCourseId)
    //更新试题信息,返回1表示更新成功,返回0则更新失败
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testIf_update", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myCommand.Parameters.Add("@testContent", SqlDbType.NVarChar, 100).Value = testContent;
        myCommand.Parameters.Add("@rightAns", SqlDbType.VarChar,20).Value = rightAns;
        myCommand.Parameters.Add("@pub", SqlDbType.Int).Value = pub;
        myCommand.Parameters.Add("@testScore", SqlDbType.Int).Value = testScore;
        myCommand.Parameters.Add("@testCourseId", SqlDbType.VarChar, 20).Value = testCourseId;