Web/Model/AnswerExtend.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 Answer
    {


        public DataSet GetProcessList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [StudentCourseView] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 从视图获取数据列表
        /// </summary>
        public DataSet GetListFromView(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [AnswerView] ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }
        /// <summary>
        /// 从视图获取数据列表
        /// </summary>
        public DataSet GetChartList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select a.examinationID,b.papername, sum(AutoScore)/count(AutoScore) as AutoScore,sum(MarkScore)/count(MarkScore) as MarkScore,sum(TotalScore)/count(TotalScore) as TotalScore from answer a left join ExaminationPaper b ");
            strSql.Append("on a.examinationID = b.PaperID group by a.examinationID, b.papername ");            
            return DbHelperSQL.Query(strSql.ToString());
        }
        


        public bool HasAnswer(string PaperID, string StudentID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Answer where ");
            strSql.AppendFormat(" ExaminationID ={0} and StudentID = {1} ", PaperID, StudentID);
            DataSet ds = DbHelperSQL.Query(strSql.ToString());