SQLServerDAL/ProfessionalDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using System.Data.SqlClient;

using CheckOnWork.Model;
using CheckOnWork.IDAL;
using CheckOnWork.DBHelper;
using CheckOnWork.WebConfig;

namespace CheckOnWork.SQLServerDAL
{
    public class ProfessionalDAL:DBAccess,IProfessional
    {

        #region 根据专业名称，得到其编号
        //根据专业名称，得到其编号
        public int GetProfessionIdByName(string name)
        {
            SqlParameter param = new SqlParameter("@professionalName", name);
            int professionalID = 0;

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.professionalGetIDByName, param))
            {
                if (read.Read())
                {
                    professionalID = read.GetInt32(0);
                }

                return professionalID;
            }

        }
        #endregion

        #region 按系别得到该系专业
        //按系别得到该系专业
        public IList<professional> GetProfessionByDepartmentId(int departmentId)
        {
            SqlParameter param = new SqlParameter("@departmentID", departmentId);

            IList<professional> list=new List<professional>();

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.professionalSelectByDepartmentID, param))
            {
                while (read.Read())
                {
                    CheckOnWork.Model.professional professional = new professional(read.GetInt32(0),read.GetString(1),read.GetInt32(2));

                    list.Add(professional);
                }

                return list;
            }
        }
        #endregion