nationalityaccess.cs

来自「酒店管理系统,您酒店物业管理的好帮手」· CS 代码 · 共 34 行

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

namespace Hotel.Operation
{
    public class NationalityAccess
    {
        GetDatabase objGetDatabase = null;
        DataSet ds = null;

        public NationalityAccess()
        {
            objGetDatabase = new GetDatabase();
        }
        //获取国家列表
        public ArrayList GetNationalityName()
        {
            string sql = "select nationalityName from nationality";
            ArrayList arr = new ArrayList();
            ds = new DataSet();
            ds = objGetDatabase.GetDataSet(sql, "nationality");
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                arr.Add(ds.Tables[0].Rows[i][0].ToString());
            }
            objGetDatabase.DataClose();
            return arr;
        }
    }
}