ordersbusiness.cs

本系统是基于三层架构和Ajax控件结合的酒店预订系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Reflection;
using DBaoBookingManagement.DataAccess;
using DBaoBookingManagement.Entity;

namespace DBaoBookingManagement.BusinessLogic
{
    /// <summary>
    /// 对Orders进行业务逻辑操作
    /// </summary>
    public class OrdersBusiness : Business
    {
        private OrdersAccessor oa = new OrdersAccessor();

        private static OrdersBusiness instance = null;
        private OrdersBusiness() { }//私有构造函数

        /// <summary>
        /// 获取OrdersBusiness对象
        /// </summary>
        /// <returns></returns>
        public static OrdersBusiness GetInstance()
        {
            if (instance == null)
            {
                instance = new OrdersBusiness();
            }
            return instance;
        }

        /// <summary>
        /// 根据订单ID查询订单
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public Orders QueryById(int id)
        {
            Orders entity = null;
            try
            {
                DataTable dt = oa.QueryById(id);
                if (dt.Rows.Count > 0)
                {
                    entity = new Orders();
                    PropertyInfo[] props = typeof(Orders).GetProperties();
                    for (int j = 0; j < props.Length; j++)
                    {
                        string columnName = props[j].Name;
                        object value = dt.Rows[0][columnName];
                        props[j].SetValue(entity, value, null);
                    }
                }
                return entity;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据订单名称查询订单
        /// </summary>
        /// <param name="orderName"></param>
        /// <returns></returns>
        public Orders[] QueryByNum(string orderName)
        {
            Orders[] entityList = null;
            try
            {
                DataTable dt = oa.QueryByNum(orderName);
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据下订时间查询订单
        /// </summary>
        /// <param name="begin"></param>
        /// <param name="end"></param>
        /// <returns></returns>
        public Orders[] QueryByOrderTime(DateTime begin, DateTime end)
        {
            Orders[] entityList = null;
            try
            {
                DataTable dt = oa.QueryByOrderTime(begin, end);
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 查询所有订单
        /// </summary>
        /// <returns></returns>
        public Orders[] QueryAll()
        {
            Orders[] entityList = null;
            try
            {
                DataTable dt = oa.QueryAll();
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 增加订单
        /// </summary>
        /// <param name="orderName"></param>
        /// <param name="startTime"></param>
        /// <param name="endTime"></param>
        /// <param name="orderTime"></param>
        /// <param name="price"></param>
        /// <param name="roomId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool Insert(string orderName,DateTime startTime,DateTime endTime,DateTime orderTime,
            double price,int roomId,int userId,string realName,string phoneNum)
        {
            Orders entity = new Orders();
            entity.OrderName = orderName;
            entity.StartTime = startTime;
            entity.EndTime = endTime;
            entity.OrderTime = orderTime;
            entity.Price = price;
            entity.RoomId = roomId;
            entity.UserId = userId;
            entity.RealName = realName;
            entity.PhoneNum = phoneNum;
            try
            {
                return oa.Insert(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 修改订单
        /// </summary>
        /// <param name="id"></param>
        /// <param name="orderName"></param>
        /// <param name="startTime"></param>
        /// <param name="endTime"></param>
        /// <param name="orderTime"></param>
        /// <param name="price"></param>
        /// <param name="roomId"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool Update(int id,string orderName, DateTime startTime, DateTime endTime, DateTime orderTime,
            double price, int roomId, int userId,string realName,string phoneNum)
        {
            Orders entity = new Orders();
            entity.OrderId = id;
            entity.OrderName = orderName;
            entity.StartTime = startTime;
            entity.EndTime = endTime;
            entity.OrderTime = orderTime;
            entity.Price = price;
            entity.RoomId = roomId;
            entity.UserId=userId;
            entity.RealName = realName;
            entity.PhoneNum = phoneNum;
            try
            {
                return oa.Update(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据订单ID删除订单
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteById(int id)
        {
            try
            {
                return oa.DeleteById(id);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        //根据会员ID查询订单
        public Orders[] QueryByUserId(int userId)
        {
            Orders[] entityList = null;
            try
            {
                DataTable dt = oa.QueryByUserId(userId);
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        //填充实体类列表
        private Orders[] FillEntityList(Orders[] entityList, DataTable dt)
        {
            if (dt.Rows.Count > 0)
            {
                entityList = new Orders[dt.Rows.Count];

                //用反射给实体类赋值
                for (int i = 0; i < entityList.Length; i++)
                {
                    Orders entity = new Orders();
                    PropertyInfo[] props = typeof(Orders).GetProperties();
                    for (int j = 0; j < props.Length; j++)
                    {
                        string columnName = props[j].Name;
                        object value = dt.Rows[i][columnName];
                        props[j].SetValue(entity, value, null);
                    }
                    entityList[i] = entity;
                }
            }
            return entityList;
        }
    }
}