SQLServerDAL/DepartmentDAL.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.WebConfig;
using CheckOnWork.DBHelper;
using CheckOnWork.IDAL;

namespace CheckOnWork.SQLServerDAL
{
    public class DepartmentDAL:DBAccess,IDepartment
    {
        /// <summary>
        /// 根据系别编号得到名称
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns></returns>
        public string GetDepartmentNameById(int id)
        {
            string name="";
            SqlParameter param=new SqlParameter("@departmentId",id);
            

            using(SqlDataReader read = ExecuteReader(StoredProcedureName.departmentSelectNameById,param))
            {
                if (read.Read())
                {
                    name = read.GetString(read.GetOrdinal("departmentName"));
                    return name;
                }

                
                else
                return name; 
            }
        }

     
        public int GetDepartmentIdByName(string departmentName)
        {
            SqlParameter param = new SqlParameter("@departmentName", departmentName);
            //CheckOnWork.Model.Department department=new Department();
            int id=0;

            using (SqlDataReader read = ExecuteReader(StoredProcedureName.GetDepartmentIdByName,param))
            {
                if (read.Read())
                {
                    id = read.GetInt32(0);
                }
                return id;
            }
        }