hoteluserbll.cs

酒店管理系统项目需求说明 第一部分 引言 1 1.1编写目的 1 1.2背景 1 第二部分 任务概述 2 3.1实现目标 2 3.1.1客房类型模块： 2 3.1.2客房信息

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Entity;
using DAL;

namespace BLL
{
    public class HotelUserBLL
    {
        /// <summary>
        /// 查询HotelUser表中的数据
        /// </summary>
        /// <returns>HotelUserEntity泛型集合</returns>
        public static List<HotelUserEntity> GetHotelUser()
        {
            return HotelUserDAL.GetHotelUser();
        }

        public static DataTable GetHotelUserByUserID(int UserID)
        {
            return HotelUserDAL.GetHotelUserByUserID(UserID);
        }

        public static DataTable GetHotelUserByUserName(string UserName)
        {
            return HotelUserDAL.GetHotelUserByUserName(UserName);
        }

        public static DataTable GetHotelUserByName(string Name)
        {
            return HotelUserDAL.GetHotelUserByName(Name);
        }
        public static int GetUserIDByUserName(string UserName)
        {
            return HotelUserDAL.GetUserIDByUserName(UserName);
        }


        /// <summary>
        /// 登录验证
        /// </summary>
        /// <param name="HUE"></param>
        /// <returns></returns>
        public static string ExistUser(HotelUserEntity HUE)
        {
            DataTable dt = HotelUserDAL.ExistUser(HUE);
            if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
            {
                return "成功";
            }
            else
            {
                return "失败";
            }
        }

        public static HotelUserEntity GetUserInfoByUserName(string UserName)
        {
            return HotelUserDAL.GetUserInfoByUserName(UserName);
        }

        public static int GetCountUserName(string UserName)
        {
            return HotelUserDAL.GetCountUserName(UserName);
        }


        /// <summary>
        /// 增加HotelUser表中的数据
        /// </summary>
        /// <param name="HUE">HotelUserEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int AddHotelUser(HotelUserEntity HUE)
        {
            return HotelUserDAL.AddHotelUser(HUE);
        }

        /// <summary>
        /// 修改HotelUser表中的数据
        /// </summary>
        /// <param name="HUE">HotelUserEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int UpdateHotelUser(HotelUserEntity HUE)
        {
            return HotelUserDAL.UpdateHotelUser(HUE);
        }

        public static int UpdateStatusByUserName(int Status, string UserName,string SessionName)
        {
            return HotelUserDAL.UpdateStatusByUserName(Status, UserName,SessionName);
        }

        public static int ChangePwd(HotelUserEntity HUE,string pwd)
        {
            return HotelUserDAL.ChangePwd(HUE,pwd);
        }

        /// <summary>
        /// 删除HotelUser表中的数据
        /// </summary>
        /// <param name="HUE">HotelUserEntity对象</param>
        /// <returns>返回结果：
        ///          1   执行SQL语句成功
        ///         -1   SQL语句执行错误
        ///         -2   数据库连接失败
        /// </returns>
        public static int DeleteHotelUser(HotelUserEntity HUE)
        {
            return HotelUserDAL.DeleteHotelUser(HUE);
        }

        public static int DeleteHotelUserByUserID(int UserID)
        {
            return HotelUserDAL.DeleteHotelUserByUserID(UserID);
        }
    }
}