testpaper.cs

在线考试系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Test.GlobalLibrary;

namespace Test.GlobalLibrary
{
    public class Testpaper
    {
        public string TableName;
        
        public void SelQue(string course,string difficult,int number1,string middle,int number2,string easy,int number3,string TestID)
        {  
            sql sel=new sql();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            DataTable dtreturn=new DataTable();
            DataTable dt1 = new DataTable();
            DataTable dt2 = new DataTable();
            DataTable dt3 = new DataTable();

            this.TableName = "tblQuestion";
            string str = "select * from "+this.TableName+" where CourseID='" + course + "'";
            ds=sel.Select(str, TableName);            
            dt = ds.Tables[0];

            DataRow[] drs_1 = dt.Select( "Comon Like "+"'" + difficult + "'");
            DataRow[] drs_2 = dt.Select("Comon Like " + "'" + middle + "'");
            DataRow[] drs_3 = dt.Select("Comon Like " + "'" + easy + "'");

            int count_1 = drs_1.GetLength(0);
            int count_2 = drs_2.GetLength(0);
            int count_3 = drs_3.GetLength(0);

            dt1 = Paper(dt, drs_1,count_1,number1);
            dt2 = Paper(dt, drs_2,count_2,number2);
            dt3 = Paper(dt, drs_3,count_3,number3);

            dt1.Merge(dt2);
            dt1.Merge(dt3);
            dtreturn = dt1;

            Input(dtreturn,TestID);
        }

        public DataTable Paper(DataTable dt,DataRow[] dr,int count,int num)
        {
            int temp = 1;
            int i = 0;
            int paperamout = count / num;

            DataTable dt2 = new DataTable();
            dt2 = dt.Clone();
            for (temp = 1; temp <= num; temp++)
            {
                Random rd = new Random();
                i = rd.Next(0, paperamout - 1) + paperamout * (temp - 1);
                dt2.ImportRow(dr[i]);
            }
            return dt2;
        }

        public void Input(DataTable dt,string TestID)
        {
            sql InQues=new sql();
            this.TableName = "tblPaper";
            string QuesNum=null;
            string SqlStr=null;
            
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                QuesNum = dt.Rows[i][0].ToString();
                SqlStr = "insert into " + this.TableName + " values('" + QuesNum + "','" + TestID + "','')";
                InQues.InDeMo(SqlStr);
            }
        }

    }
}