roomtypeoperatorbll.cs

酒店管理 主要实现了基础设施管理（客房管理、客房类型管理）、业务管理（入住、退房、数据库切换） 本系统简单明了,适合初学者学习,采用三层加抽象工厂实现

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

using IDAL;
using Model;
using Factory;
using System.Data;

namespace BLL
{
    public class RoomTypeOperatorBLL
    {
        //得到工厂操作房间类型的接口对象
        private static IRoomType op = null;


        public RoomTypeOperatorBLL()
        {
            op = AbstractFactory.GetFactory().CreateRoomTypeOperator();
        }

        /// <summary>
        /// 查询房间类型的所有信息
        /// 将泛型集合转换成DataTable
        /// </summary>
        /// <returns></returns>
        public DataTable SelectRoomTypeDataByAll()
        {
            List<RoomType> temp = null;
            DataTable table = null;
            try
            {
                temp = op.SelectAllDataByRoomType() as List<RoomType>;

                table = GetDataTable(temp);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return table;
        }

        /// <summary>
        /// 按房间类型编号查询房间类型信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public RoomType GetRoomTypeByID(int id)
        {
            return op.SelectRoomTypeByID(id);
        }

        /// <summary>
        /// 按类型名称查询类型信息
        /// </summary>
        /// <param name="typeName"></param>
        /// <returns></returns>
        public DataTable GetRoomTypeByTypeName(string typeName)
        {
            List<RoomType> temp = null;
            DataTable table = null;
            try
            {
                temp = op.GetRoomTypeByTypeName(typeName) as List<RoomType>;
                if (temp != null)
                    table = GetDataTable(temp);
                else
                    table = null;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return table;
        }

        /// <summary>
        /// 按房间类型名称查询房间类型信息
        /// </summary>
        /// <param name="typeName"></param>
        /// <returns></returns>
        public RoomType SelectDataForRoomTypeByRoomTypeName(string typeName)
        {
            return op.SelectRoomTypeByTypeName(typeName);
        }

        /// <summary>
        /// 添加房间类型信息
        /// </summary>
        /// <param name="roomType"></param>
        /// <returns></returns>
        public bool AddRoomType(RoomType roomType)
        {
            return op.InsertRoomTypeValues(roomType);
        }

        /// <summary>
        /// 修改房间类型信息
        /// </summary>
        /// <param name="roomType"></param>
        /// <returns></returns>
        public bool ModifyRoomType(RoomType roomType)
        {
            return op.ModifyRoomTypeValues(roomType);
        }

        /// <summary>
        /// 删除房间类型信息
        /// </summary>
        /// <param name="roomType"></param>
        /// <returns></returns>
        public bool DeleteRoomType(RoomType roomType)
        {
            return op.DeleteRoomTypeValues(roomType);
        }

        /// <summary>
        /// 根据泛型集合返回DataTable对象
        /// </summary>
        /// <param name="temp"></param>
        /// <returns></returns>
        private DataTable GetDataTable(List<RoomType> temp)
        {
            DataTable table = null;
            if (temp != null)
            {
                //Enumerator类型是struct类型
                List<RoomType>.Enumerator en = temp.GetEnumerator();
                table = new DataTable("RoomType");
                table.Columns.Add("TypeId");
                table.Columns.Add("TypeName");
                table.Columns.Add("TypePrice");
                table.Columns.Add("IsAddBed");
                table.Columns.Add("AddBedPrice");
                table.Columns.Add("Remark");
                while (en.MoveNext())
                {
                    object[] items = new object[6];
                    DataRow row = table.NewRow();
                    items[0] = (object)en.Current.Typeid;
                    items[1] = (object)en.Current.Typename;
                    items[2] = (object)en.Current.Typeprice;
                    items[3] = (object)en.Current.Isaddbed;
                    items[4] = (object)en.Current.Addbedprice;
                    items[5] = (object)en.Current.Remark;
                    row.ItemArray = items;
                    table.Rows.Add(row);
                }
            }
            return table;
        }
    }
}