App_Code/DAO/DepartmentDAO.cs

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using Salary.Model;
using Salary.DB;
using System.Collections;


namespace Salary.DAO
{
    /// <summary>
    /// DepartmentDAO 的摘要说明
    /// </summary>
    public class DepartmentDAO
    {
        /*查询所有的部门信息*/
        public ArrayList QueryAllDepartment()
        {
            ArrayList departmentList = new ArrayList();
            String sql = "select * from [department]";
            DataBase db = new DataBase();
            DataSet ds = db.GetDataSet(sql);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                DataRow dr = ds.Tables[0].Rows[i];
                Department department = new Department();
                department.setDepartmentId(Convert.ToInt32(dr["departmentId"]));
                department.setDepartmentName(dr["departmentName"].ToString());
                departmentList.Add(department);
            }
            return departmentList;
        }

        /*根据部门id得到部门名称*/
        public string GetDepartmentNameById(int departmentId)
        {
            String departmentName = "";
            String sql = "select departmentName from [department] where departmentId=" + departmentId;
            DataBase db = new DataBase();
            DataSet ds = db.GetDataSet(sql);
            departmentName = ds.Tables[0].Rows[0]["departmentName"].ToString();
            return departmentName;
        }
    }
}