ExaminationDAL/TbClassService.cs

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

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

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

namespace ExaminationDAL
{
    public class 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 int AddClass(string BjName, string Nj, int ZyID)
        {

            string Sql_Insert = "insert into TbClass(BjName,Nj,ZyID) values(@BjName,@Nj,@ZyID)";
            SqlParameter[] paras2 = new SqlParameter[]{
                new SqlParameter("@BjName",BjName),
                new SqlParameter("@Nj",Nj),
                new SqlParameter("@ZyID",ZyID)
            };
            return DBHelper.ExecuteCommand(Sql_Insert, paras2);
        }
        /// <summary>
        /// //查找专业表对应的专业ID
        /// </summary>
        /// <param name="Zy">专业名称</param>
        /// <returns>专业ID</returns>
        public int Sel_ZyID(string Zy)
        {
            string Sql_Select = "select ZyID from tbSpeciality where ZyName=@Zy ";
            SqlParameter[] paras1 = new SqlParameter[]{
                new SqlParameter("@Zy",Zy)
              };
            return DBHelper.GetScalar(Sql_Select, paras1);
        }

        /// <summary>
        /// 根据班级名和年级查找对应的信息
        /// </summary>
        /// <param name="BjName">班级名</param>
        /// <param name="Nj">年级</param>
        /// <returns>返回对应的班级列表</returns>
        public DataTable Sel_Bj(string BjName, string Nj)
        {
            string Sql_Select = "select * from TbClass where BjName=@BjName and Nj=@Nj";
            SqlParameter[] paras = new SqlParameter[]{
                new SqlParameter("@BjName",BjName),
                new SqlParameter("@Nj",Nj)