resultaccess.cs

考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统考试管理系统

using System;
using System.Data;
using System.Data.SqlClient;
using ExamSystem.Common.Objects;
using ExamSystem.Common.DB;
using ExamSystem.Common;
using System.Collections;

namespace ExamSystem.DataAccess.ExamAccess
{
	/// <summary>
	/// ResultAccess 的摘要说明。
	/// </summary>
	public class ResultAccess
	{
		DataBaseOperate oper;
		/// <summary>
		/// 实例化班级数据访问对象
		/// </summary>
		/// <param name="dataBaseOperate">数据连接对象</param>
		public ResultAccess(DataBaseOperate dataBaseOperate)
		{
			oper=dataBaseOperate;
		}

		public DataSet getResultDetile(ExamResult result)
		{
			string sql="select paper from ExamResult where isDel=0";
			ParamList list=new ParamList();
			if(result.ResultID>0)
			{
				sql+=" and ResultID=@ResultID";
				list.AddNew("@ResultID",SqlDbType.Int,result.ResultID);
			}
			if(result.StuID>0)
			{
				sql+=" and StuID=@StuID";
				list.AddNew("@StuID",SqlDbType.Int,result.StuID);
			}
			if(result.ExamID>0)
			{
				sql+=" and ExamID=@ExamID";
				list.AddNew("@ExamID",SqlDbType.Int,result.ExamID);
			}
			if(result.Result>0)
			{
				sql+=" and Result=@Result";
				list.AddNew("@Result",SqlDbType.Int,result.Result);
			}
			return oper.Query(sql,"ResultDetile",list);
		}

		/// <summary>
		/// 获取考试结果
		/// </summary>
		/// <param name="result">结果对象</param>
		/// <returns></returns>
		public DataSet getResult(ExamResult result)
		{
			string sql="select ResultID,StuName,ExamName,ExamResult.StuID,ExamResult.ExamID,Result from ExamResult,StuLogin,ExamList where ExamResult.isDel=0 and ExamResult.StuID=StuLogin.StuID and ExamResult.ExamID=ExamList.ExamID";
			ParamList list=new ParamList();
			if(result.ResultID>0)
			{
				sql+=" and ExamResult.ResultID=@ResultID";
				list.AddNew("@ResultID",SqlDbType.Int,result.ResultID);
			}
			if(result.StuID>0)
			{
				sql+=" and ExamResult.StuID=@StuID";
				list.AddNew("@StuID",SqlDbType.Int,result.StuID);
			}
			if(result.ExamID>0)
			{
				sql+=" and ExamResult.ExamID=@ExamID";
				list.AddNew("@ExamID",SqlDbType.Int,result.ExamID);
			}
			if(result.Result>0)
			{
				sql+=" and ExamResult.Result=@Result";
				list.AddNew("@Result",SqlDbType.Int,result.Result);
			}
			return oper.Query(sql,"Result",list);
		}

		/// <summary>
		/// 插入考试结果
		/// </summary>
		/// <param name="result">结果对象</param>
		public void insertResult(ExamResult result)
		{
			string sql="insert into ExamResult(StuID,ExamID";
			ParamList list=new ParamList();
			ArrayList pamList=new ArrayList();
			pamList.Add("@StuID");
			list.AddNew("@StuID",SqlDbType.Int,result.StuID);

			pamList.Add("@ExamID");
			list.AddNew("@ExamID",SqlDbType.Int,result.ExamID);
			if(result.Result>0)
			{
				sql+=",Result";
				pamList.Add("@Result");
				list.AddNew("@Result",SqlDbType.Decimal,result.Result);
			}

			if(result.Paper!="")
			{
				sql+=",paper";
				pamList.Add("@paper");
				list.AddNew("@paper",SqlDbType.Text,result.Paper);
			}
			sql+=") values(";
			for(int i=0;i<pamList.Count;i++)
			{
				sql+=pamList[i].ToString();
				if(i<pamList.Count-1)
				{
					sql+=",";
				}
			}
			sql+=")";
			oper.Execute(sql,list);
		}

		public void updateResult(ExamResult result)
		{
			string sql="update ExamResult set isDel=0";
			ParamList list=new ParamList();
			
			if(result.StuID>=0)
			{
				sql+=",StuID=@StuID";
				list.AddNew("@StuID",SqlDbType.Int,result.StuID);
			}
			if(result.ExamID>=0)
			{
				sql+=",ExamID=@ExamID";
				list.AddNew("@ExamID",SqlDbType.Int,result.ExamID);
			}
			if(result.Result>=0)
			{
				sql+=",Result=@Result";
				list.AddNew("@Result",SqlDbType.Decimal,result.Result);
			}
			if(result.Paper!="")
			{
				sql+=",paper=@paper";
				list.AddNew("@paper",SqlDbType.NText,result.Paper);
			}
			if(result.ResultID>=0)
			{
				sql+=" where ResultID=@ResultID";
				list.AddNew("@ResultID",SqlDbType.Int,result.ResultID);
			}
			oper.Execute(sql,list);
		}

		public void deleteResult(ExamResult result)
		{
			string sql="update ExamResult set isDel=1 where isDel=0";
			ParamList list=new ParamList();
			if(result.StuID>=0)
			{
				sql+=" and StuID=@StuID";
				list.AddNew("@StuID",SqlDbType.Int,result.StuID);
			}
			if(result.ExamID>=0)
			{
				sql+=" and ExamID=@ExamID";
				list.AddNew("@ExamID",SqlDbType.Int,result.ExamID);
			}
			if(result.Result>=0)
			{
				sql+=" and Result=@Result";
				list.AddNew("@Result",SqlDbType.Decimal,result.Result);
			}
//			if(result.Paper>=0)
//			{
//				sql+=" and paper=@paper";
//				list.AddNew("@paper",SqlDbType.Int,result.Paper);
//			}
			oper.Execute(sql,list);
		}
	}
}