ExaminationBLL/TbClassManager.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ExaminationDAL;
using System.Data;
using System.Data.SqlClient;
using ExaminationModels;

namespace ExaminationBLL
{
    public class TbClassManager
    {
        static TbClassService tbclass = new TbClassService();

        /// <summary>
        /// 添加班级信息
        /// </summary>
        /// <param name="BjName">班级名称</param>
        /// <param name="Nj">年级</param>
        /// <param name="ZyID">专业名</param>
        /// <param name="Xz">学制</param>
        /// <param name="Bz">备注</param>
        /// <returns>Sql语句执行后返回受影响的行数</returns>
        public static int AddClass(string BjName, string Nj, int ZyID)
        {
            return tbclass.AddClass(BjName, Nj, ZyID);
        }

        /// <summary>
        /// //查找专业表对应的专业ID
        /// </summary>
        /// <param name="Zy">专业名称</param>
        /// <returns>专业ID</returns>
        public static int Sel_ZyID(string Zy)
        {
            return tbclass.Sel_ZyID(Zy);
        }

        /// <summary>
        /// 根据班级名和年级查找对应的信息
        /// </summary>
        /// <param name="BjName">班级名</param>
        /// <param name="Nj">年级</param>
        /// <returns>返回对应的班级列表</returns>
        public static DataTable Sel_Bj(string BjName, string Nj)
        {
            return tbclass.Sel_Bj(BjName, Nj);
        }

        public static SqlDataReader Sel_Zy()
        {
            return tbclass.Sel_Zy();
        }
        /// <summary>
        /// 返回当前页的班级列表信息
        /// </summary>
        /// <param name="len">每页显示条数</param>
        /// <param name="page">当前页数</param>