ExaminationDAL/TbSpecialityService.cs

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

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

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

namespace ExaminationDAL
{
    public class TbSpecialityService
    {
        /// <summary>
        /// 获取所有专业列表
        /// </summary>
        /// <returns></returns>
        public List<TbSpeciality> GetAllSpecialityList()
        {
            List<TbSpeciality> subjectList = new List<TbSpeciality>();
            TbSpeciality sbt = null;
            string sql = "select * from tbSpeciality";
            SqlDataReader reader = DBHelper.GetReader(sql);
            while (reader.Read())
            {
                sbt = new TbSpeciality();
                sbt.ZyName = reader["ZyName"].ToString();
                sbt.ZyID = (int)reader["ZyID"];
                sbt.Remark = reader["Remark"].ToString();
                subjectList.Add(sbt);
            }
            reader.Close();
            return subjectList;
        }
        /// <summary>
        /// 根据当前已有成绩获取对应所有专业列表
        /// </summary>
        /// <returns></returns>
        public List<TbSpeciality> GetAllSpecialityListByScore()
        {
            List<TbSpeciality> subjectList = new List<TbSpeciality>();
            TbSpeciality sbt = null;
            StringBuilder sbsql = new StringBuilder();
            sbsql.Append("select * from tbSpeciality where ZyID in (select ZyID from tbSubject where KmID in (select KmID from tbTestPaper ");
            sbsql.Append(" where SjID in (select SjID from tbObjTopic where KgtID in(select KgtID from tbScore))))");
            SqlDataReader reader = DBHelper.GetReader(sbsql.ToString());
            while (reader.Read())
            {
                sbt = new TbSpeciality();
                sbt.ZyName = reader["ZyName"].ToString();
                sbt.ZyID = (int)reader["ZyID"];
                sbt.Remark = reader["Remark"].ToString();
                subjectList.Add(sbt);
            }
            reader.Close();
            return subjectList;
        }
        /// <summary>
        /// 新增专业信息
        /// </summary>