projclass.cs

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

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

        }
        finally
        {
            myConnection.Close();
        }


    }


   
    public int deleteTestInfo(string testId)
    //在test表中删除记录,成功返回1,失败返回0
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_delete", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);

        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;//删除成功
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;//删除失败

        }
        finally
        {
            myConnection.Close();
        }

    }
    public int deleteTestDuoXuanInfo(string testId)
    //在testDuoXuan表中删除记录,成功返回1,失败返回0
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testDuoXuan_delete", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);

        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;//删除成功
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;//删除失败

        }
        finally
        {
            myConnection.Close();
        }

    }
    public int deleteTestIfInfo(string testId)
    //在testDuoXuan表中删除记录,成功返回1,失败返回0
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testIf_delete", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);

        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            return 1;//删除成功
        }
        catch (SqlException SQLexc)
        {
            Console.WriteLine("SqlException:{0}", SQLexc);
            return 0;//删除失败

        }
        finally
        {
            myConnection.Close();
        }

    }


    //查询单选题
    public SqlDataReader createTest(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_create", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        //try
        //{	
        SqlDataReader reader = myCommand.ExecuteReader();
        //}
        //catch(SqlException SQLexc)
        //{
        //	Console.WriteLine("SqlException:{0}",SQLexc);


        //}
        return reader;
    }

    //查询多选题
    public SqlDataReader createTestDuoXuan(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testDuoXuan_create", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        //try
        //{	
        SqlDataReader reader = myCommand.ExecuteReader();
        //}
        //catch(SqlException SQLexc)
        //{
        //	Console.WriteLine("SqlException:{0}",SQLexc);


        //}
        return reader;
    }
    //查询判断题
    public SqlDataReader createTestIf(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testIf_create", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        //try
        //{	
        SqlDataReader reader = myCommand.ExecuteReader();
        //}
        //catch(SqlException SQLexc)
        //{
        //	Console.WriteLine("SqlException:{0}",SQLexc);
        //}
        return reader;
    }

    //查询填空题
    public SqlDataReader createTestTianKong(string courseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_testTianKong_create", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar, 20).Value = courseId;
        myConnection.Open();
        //try
        //{	
        SqlDataReader reader = myCommand.ExecuteReader();
        //}
        //catch(SqlException SQLexc)
        //{
        //	Console.WriteLine("SqlException:{0}",SQLexc);
        //}
        return reader;
    }



    public int ifCourseHasTest(string stuId, string courseId)
    //判断指定的用户指定的科目是否已经考试过
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_score_courseStatus_select", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@stuId", SqlDbType.VarChar, 15).Value = stuId;
        myCommand.Parameters.Add("@courseId", SqlDbType.VarChar,20).Value = courseId;
        myConnection.Open();
        SqlDataReader thisReader = myCommand.ExecuteReader();


        if (thisReader.Read())
        {
            return 1;//说明找到了记录,即用户已经考试过了.

        }
        thisReader.Close();
        myConnection.Close();
        return 0;

    }

    //获得单选题答案
    public int getRightAnsAsTestId(string testId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_rightAnsselectAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataReader reader = myCommand.ExecuteReader();
        int rightAns = 1;
        if (reader.Read())
        {
            rightAns = reader.GetInt32(0);
        }
        reader.Close();
        return rightAns;
    }


   //获得多选题答案
    public string getRightAnsAsTestDuoXuanId(string testId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_rightAnsselectDuoXuanAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataReader reader = myCommand.ExecuteReader();
        string rightAns = "";
        if (reader.Read())
        {
            rightAns = reader.GetString(0);
        }
        reader.Close();
        return rightAns;
    }
    //获得判断题答案
    public string getRightAnsAsTestIfId(string testId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_rightAnsselectIfAsId", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testId", SqlDbType.Int).Value = Int32.Parse(testId);
        myConnection.Open();
        SqlDataReader reader = myCommand.ExecuteReader();
        string rightAns = "";
        if (reader.Read())
        {
            rightAns = reader.GetString(0);
        }
        reader.Close();
        return rightAns;
    }
    public DataSet getStuScore(string stuId)
    //取得学生考试结果的信息
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_score_select", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@stuId", SqlDbType.VarChar, 15).Value = stuId;
        myConnection.Open();

        SqlDataAdapter da = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        da.Fill(ds, "stuInfo");
        myConnection.Close();
        return ds;
    }

    public DataSet getTianKong(string course)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_TianKong_selectAsCourse", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testCourse", SqlDbType.VarChar, 20).Value = course;
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }

    //取得问答题信息
    public DataSet getWenDa(string course)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_WenDa_selectAsCourse", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testCourse", SqlDbType.VarChar, 20).Value = course;
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }

    public DataSet imitationGetWenDa(string course)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_imitationWenDa_selectAsCourse", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;
        myCommand.Parameters.Add("@testCourse", SqlDbType.VarChar, 20).Value = course;
        myConnection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(myCommand);
        DataSet ds = new DataSet();
        adapter.Fill(ds, "testInfo");
        myConnection.Close();
        return ds;
    }


    public int insertTianKong(string testContent,string testContent2, string rightAns, int pub, int testScore, string testCourseId)
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
        SqlCommand myCommand = new SqlCommand("sp_test_insertTianKong", myConnection);
        myCommand.CommandType = CommandType.StoredProcedure;

        myCommand.Parameters.Add("@formerContent", SqlDbType.NVarChar, 800).Value = testContent;
        myCommand.Parameters.Add("@backContent", SqlDbType.NVarChar, 800).Value = testContent2;
        myCommand.Parameters.Add("@rightAns", SqlDbType.VarChar, 50).Value = rightAns;


        myCommand.Parameters.Add("@