DAL/ClassesDAO.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MODEL;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class ClassesDAO
    {
        private SQLHelper sqlhelper;
        public ClassesDAO()
        {
            sqlhelper = new SQLHelper();
        }
        #region 选择全部班级信息
        /// <summary>
        /// 选择全部班级信息
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAllClass()
        {
            return sqlhelper.ExecuteQuery("SELECT teachers.name, classes.classId, classes.name AS classname, classes.term, classes.teacherId FROM classes INNER JOIN teachers ON classes.teacherId = teachers.teacherId", CommandType.Text);
        }
        #endregion
        #region 按条件选择班级信息
        /// <summary>
        /// 按条件选择班级信息
        /// </summary>
        /// <returns></returns>
        public DataTable SelectClassByValue( string n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@value",n ),
            };
            return sqlhelper.ExecuteQuery("SELECT teachers.name, classes.classId, classes.name AS classname, classes.term, classes.teacherId FROM classes INNER JOIN teachers ON classes.teacherId = teachers.teacherId WHERE teachers.teacherId=@value   or classes.name like '%'+@value+'%' or teachers.name like '%'+@value+'%' order by term desc", paras, CommandType.Text);
        }
        #endregion
        #region 依班级ID查看班级信息
        /// <summary>
        /// 依班级ID查看班级信息
        /// </summary>
        /// <returns></returns>
        public DataTable SelectClassByClassId(int n)
        {
            SqlParameter[] paras = new SqlParameter[]
            {
                 new SqlParameter ("@value",n ),
            };
            return sqlhelper.ExecuteQuery("SELECT teachers.name, classes.classId, classes.name AS classname, classes.term, classes.teacherId FROM classes INNER JOIN teachers ON classes.teacherId = teachers.teacherId WHERE classes.classId=@value", paras, CommandType.Text);
        }
        #endregion
        #region 更新班级信息
        /// <summary>
        /// 更新班级信息
        /// </summary>
        /// <param name="n">班级信息实体类</param>