RubricMgr.cs

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

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

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


	/// <summary>
	/// 试题类管理类
	/// </summary>
	public class RubricMgr
	{
		/// <summary>
		/// 初始化构造函数
		/// </summary>
		public RubricMgr()
		{

		}

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

			if (rubric != null)
			{
				if (rubric.RubricID == 0)
				{
					strSQL = "SELECT Top 0 * FROM Exam_Rubric";
				}
				else
				{
					strSQL = "SELECT * FROM Exam_Rubric WHERE RubricID = " + rubric.RubricID.ToString();
				}

				dt = CMMgr.GetDataTable(strSQL);

				if (dt.Rows.Count > 0)
				{
					row = dt.Rows[0];
				}
				else
				{
					row = dt.NewRow();
                    row["RubricID"] = rubric.RubricID;
				}

                row["KenID"] = rubric.C_Ken.KenID;
                row["ChapterID"] = rubric.C_Chapter.ChapterID;
                row["RubricClassName"] = rubric.RubricClassName;