App_Code/StudentPaperMgr.cs

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

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

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


	/// <summary>
	/// 学生答题管理类
	/// </summary>
	public class StudentPaperMgr
	{
		/// <summary>
		/// 初始化构造函数
		/// </summary>
		public StudentPaperMgr()
		{

		}

		#region 函数UpdateStudentPaper | 更新学生答题信息
		/// <summary>
		/// 更新一个学生答题信息
		/// </summary>
		/// <param name="studentPaper">学生答题</param>
		/// <returns>更新成功返回true 否则返回false</returns>
		public bool UpdateStudentPaper(StudentPaper studentPaper)
		{
			string strSQL = "";
			SqlDataAdapter sa = null;
			SqlCommandBuilder builder = null;
			DataRow row = null;
			DataTable dt = null;
			bool returnValue = false;

			if (studentPaper != null)
			{
				if (studentPaper.StudentPaperID == 0)
				{
					strSQL = "SELECT Top 0 * FROM Exam_StudentPaper";
				}
				else
				{
                    strSQL = "SELECT * FROM Exam_StudentPaper WHERE StudentPaperID = " + studentPaper.StudentPaperID.ToString();
				}

				dt = CMMgr.GetDataTable(strSQL);

				if (dt.Rows.Count > 0)
				{
					row = dt.Rows[0];
				}
				else
				{
					row = dt.NewRow();
				}
                row["StudentID"] = studentPaper.StudentID;
                row["PaperName"] = studentPaper.PaperName;
                row["RubricClassName"] = studentPaper.RubricClassName;
                row["Subject"] = studentPaper.Subject;
                row["Answer"] = studentPaper.Answer;
                row["Number"] = studentPaper.Number;