st_question.cs

很完善的在线考试系统。.net（C#）源代码

using System;
using System.Collections;
using System.Data;
using System.Text;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_ExamBiz
{
    public class ST_Question
    {
        string st_SqlString = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
        public ST_Question()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 插入题目基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_InsertQuestionInfo(string ST_QuestionDes,string ST_Answer1,string ST_Answer2,string ST_Answer3,string ST_Answer4,string ST_RightAnswer,int ST_CourseID)
		{
			string sqlString = "insert ST_QuestionInfo(ST_QuestionDes,ST_Answer1,ST_Answer2,ST_Answer3,ST_Answer4,ST_RightAnswer,ST_CourseID) values('"+ST_QuestionDes+"','"+ST_Answer1+"','"+ST_Answer2+"','"+ST_Answer3+"','"+ST_Answer4+"','"+ST_RightAnswer+"','"+ST_CourseID+"')";
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 修改题目基本信息
		/// </summary>
		/// <param name="st_StuInfo"></param>
		public void ST_UpdateQuestionInfo(string ST_QuestionDes,string ST_Answer1,string ST_Answer2,string ST_Answer3,string ST_Answer4,string ST_RightAnswer,int ST_CourseID, int ST_QuestionID)
		{
			string sqlString = "update ST_QuestionInfo set ST_QuestionDes='"+ST_QuestionDes+"',ST_Answer1='"+ST_Answer1+"',ST_Answer2='"+ST_Answer2+"',ST_Answer3='"+ST_Answer3+"',ST_Answer4='"+ST_Answer4+"',ST_RightAnswer='"+ST_RightAnswer+"',ST_CourseID="+ST_CourseID+" where ST_QuestionID="+ST_QuestionID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 删除题目的记录
		/// </summary>
		/// <param name="st_TeacherID"></param>
		public void ST_DeleteQuestionInfo(int ST_QuestionID)
		{
			string sqlString = "update ST_QuestionInfo set ST_IsDeleted=1 where  ST_QuestionID="+ST_QuestionID;
			SqlHelper.ExecuteNonQuery(st_SqlString, CommandType.Text, sqlString);
		}

		/// <summary>
		/// 取得一个科目中的试题信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
        public DataSet ST_GetAllQuestionInfo(int ST_CourseID)
		{
			string sqlString = "select * from ST_QuestionInfo where ST_IsDeleted=0 and ST_CourseID="+ST_CourseID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 随机从一个科目中取得10道试题
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetTenQuestionInfo(int ST_CourseID)
		{
			string sqlString = "select top 10 * from ST_QuestionInfo where ST_IsDeleted=0 and ST_CourseID="+ST_CourseID + " order by newid()";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得一个试题信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetQuestionInfo(int ST_QuestionID)
		{
			string sqlString = "select * from ST_QuestionInfo where ST_IsDeleted=0 and ST_QuestionID="+ST_QuestionID;
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
		/// <summary>
		/// 取得所有题目的信息
		/// </summary>
		/// <param name="ST_DeptID"></param>
		/// <returns></returns>
		public DataSet ST_GetAllQuestionInfo()
		{
			string sqlString = "select * from ST_QuestionInfo where ST_IsDeleted=0";
			return SqlHelper.ExecuteDataset(st_SqlString, CommandType.Text, sqlString);
		}
	}
}