Web/Model/StudentCourseExtend.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 StudentCourse
    {
        public DataSet GetProcessList(string strWhere,string StudentID)
        {
            StringBuilder strSql = new StringBuilder();
             strSql.Append("  SELECT  a.CourseID, a.SubjectID, a.StudentID, a.SchoolID, dbo.Subject.SubjectTitle FROM dbo.StudentCourse AS a INNER JOIN dbo.Subject ON a.SubjectID = dbo.Subject.SubjectID ");
             strSql.AppendFormat("  WHERE a.StudentID = {0} ", StudentID);
             //strSql.AppendFormat(" AND a.SubjectID NOT IN  (SELECT  a.SubjectID  FROM dbo.Answer     WHERE  StudentID = {0}) ", StudentID);
           
            if (strWhere.Trim() != "")
            {
                strSql.Append(" and " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetViewList(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());
        }
        public bool hasSelect(int SubjectID, int StudentID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM [StudentCourse] ");
            strSql.AppendFormat(" where SubjectID = {0} and studentID = {1} ", SubjectID, StudentID);
         
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
                return true;
            else
                return false;
 
        }
        //DeleteList

        /// <summary>
        ///批量删除数据
        /// </summary>