messagebusiness.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>
    /// 对Message表进行业务逻辑操作
    /// </summary>
    public class MessageBusiness:Business
    {
        private MessageAccessor ma = new MessageAccessor();

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

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

        /// <summary>
        /// 根据酒店ID查询留言
        /// </summary>
        /// <param name="hotelId"></param>
        /// <returns></returns>
        public Message[] QueryByHotelId(int hotelId)
        {
            Message[] entityList = null;
            try
            {
                DataTable dt = ma.QueryByHotelId(hotelId);
                entityList = FillEntityList(entityList, dt);
                return entityList;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

        /// <summary>
        /// 根据ID查询留言
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        public Message QueryById(int Id)
        {
            Message entity = null;
            try
            {
                DataTable dt = ma.QueryById(Id);
                if (dt.Rows.Count > 0)
                {
                    entity = new Message();
                    PropertyInfo[] props = typeof(Message).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="staff"></param>
        /// <param name="service"></param>
        /// <param name="clean"></param>
        /// <param name="comfortable"></param>
        /// <param name="worth"></param>
        /// <param name="goods"></param>
        /// <param name="bads"></param>
        /// <param name="touristTypeId"></param>
        /// <param name="messageTime"></param>
        /// <param name="hotelId"></param>
        /// <returns></returns>
        public bool Insert(double staff,double service,double clean,double comfortable,double worth,
            string goods,string bads,int touristTypeId,DateTime messageTime,int hotelId)
        {
            Message entity = new Message();
            entity.Staff = staff;
            entity.Service = service;
            entity.Clean = clean;
            entity.Comfortable = comfortable;
            entity.Worth = worth;
            entity.Goods = goods;
            entity.Bads = bads;
            entity.TouristTypeId = touristTypeId;
            entity.MessageTime = messageTime;
            entity.HotelId = hotelId;
            try
            {
                return ma.Insert(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

        /// <summary>
        /// 修改留言
        /// </summary>
        /// <param name="id"></param>
        /// <param name="staff"></param>
        /// <param name="service"></param>
        /// <param name="clean"></param>
        /// <param name="comfortable"></param>
        /// <param name="worth"></param>
        /// <param name="goods"></param>
        /// <param name="bads"></param>
        /// <param name="touristTypeId"></param>
        /// <param name="messageTime"></param>
        /// <param name="hotelId"></param>
        /// <returns></returns>
        public bool Update(int id,double staff,double service,double clean,double comfortable,double worth,
            string goods,string bads,int touristTypeId,DateTime messageTime,int hotelId)
        {
            Message entity = new Message();
            entity.MessageId = id;
            entity.Staff = staff;
            entity.Service = service;
            entity.Clean = clean;
            entity.Comfortable = comfortable;
            entity.Worth = worth;
            entity.Goods = goods;
            entity.Bads = bads;
            entity.TouristTypeId = touristTypeId;
            entity.MessageTime = messageTime;
            entity.HotelId = hotelId;
            try
            {
                return ma.Update(entity);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

                //用反射给实体类赋值
                for (int i = 0; i < entityList.Length; i++)
                {
                    Message entity = new Message();
                    PropertyInfo[] props = typeof(Message).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;
        }
    }
}