employeeaccess.cs

酒店管理系统,您酒店物业管理的好帮手

using System;
using System.Collections;
using System.Text;
using Hotel.DAO;
using System.Data;
using System.Data.SqlClient;

namespace Hotel.Operation
{
    public class EmployeeAccess
    {
        GetDatabase objGetDatabase;
        public EmployeeAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获取所有员工编号和名称
        public ArrayList GetAllEmployee()
        {
            ArrayList arr=new ArrayList();
            string sql = "select EmployeeID,EmployeeName from Employee";
            
            DataSet ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql,"Employee");
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                arr.Add(ds.Tables[0].Rows[i][0].ToString()+"--" + ds.Tables[0].Rows[i][1].ToString());
            }
            
            objGetDatabase.DataClose();
            return arr;

            
        }
    }
}