App_Code/PaperMgr.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Data.SqlClient;



	/// <summary>
	/// 试卷管理类
	/// </summary>
	public class PaperMgr
	{
		public PaperMgr()
		{

		}

		#region 函数UpdatePaper | 更新试卷信息
		/// <summary>
		/// 更新试卷类
		/// </summary>
		/// <param name="paper">试卷参数</param>
		public void UpdatePaper(Paper paper)
		{
			string strSQL = "";
			if (paper.PaperID == 0)
			{
				strSQL = "INSERT INTO Exam_Paper (PaperName) VALUES ('" + paper.PaperName + "')";
			}
			else
			{
				strSQL = "UPDATE Exam_Paper SET PaperName = '" + paper.PaperName + "' WHERE PaperID = " + paper.PaperID;
			}
			CMMgr.ExecuteNonQuery(strSQL);
		}
		#endregion

		#region 函数DelPaper | 删除试卷类型 | 重载3次
		/// <summary>
		/// 删除试卷类型
		/// </summary>
		/// <param name="PaperID">试卷编号</param>
		public void DelPaper(string PaperID)
		{
			string strSQL = "DELETE FROM Exam_Paper WHERE PaperID = " + PaperID;
			CMMgr.ExecuteNonQuery(strSQL);
		}

		/// <summary>
		/// 删除试卷类型
		/// </summary>
		/// <param name="PaperID">试卷编号</param>
		public void DelPaper(int PaperID)
		{
			this.DelPaper(PaperID.ToString());
		}
		
		/// <summary>
		/// 删除试卷类型
		/// </summary>
		/// <param name="paper">试卷类</param>