Web/Model/ExaminationItemExtend.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;
using System.Web.UI.WebControls;
using System.Collections.Generic;//Please add references

namespace StudentExamination.Model
{
    //扩展EvaluateRecord类，增加自定义的方法

    public partial class ExaminationItem
    {
        /// <summary>
        /// 获得考题数据列表
        /// </summary>
        public DataSet GetJudgeList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [ExaminationItemJudgeView] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

       
        /// <summary>
        /// 获得单选考题数据列表
        /// </summary>
        public DataSet GetSingleList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [ExaminationItemSingleView] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获得多选考题数据列表
        /// </summary>
        public DataSet GetMultiList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [ExaminationItemMultiView] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>