accesshoteluserservice.cs

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

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

using System.Collections;
using System.Data.OleDb;
using System.Data;
using IDAL;
using Model;
using DBUtility;

namespace AccessDAL
{
    public class AccessHotelUserService:IHotelUser
    {
        #region IHotelUser 成员

        private AccessRoomTypeOperatorService roomTypeOp = new AccessRoomTypeOperatorService();//操作房间类型的数据访问层类
        private const string PARM_ACCOUNT_ID = "@accountID"; //声明一个参数
        private const string PARM_PAW = "@paw";

        /// <summary>
        /// 按用户名得到用户密码(验证登录用户的合法性)
        /// </summary>
        /// <param name="userName"></param>
        /// <returns></returns>
        public string GetUserPasswordByUserName(string userName)
        {
            StringBuilder sql = new StringBuilder();
            string str = string.Empty;
            sql.Append("select Paw from HotelUser where AccountID='" + userName + "'");
            try
            {
                string temp = AccessHelper.ExecuteScalar(AccessHelper.AccessConnString, CommandType.Text, sql.ToString(), null);
                if (!string.IsNullOrEmpty(temp))
                    str = temp;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return str;
        }

        /// <summary>
        /// 添加新用户
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        public bool AddUser(HotelUser user)
        {
            StringBuilder add = new StringBuilder();
            add.Append("insert into HotelUser(AccountID,Paw) values(");
            add.Append(PARM_ACCOUNT_ID + ",");
            add.Append(PARM_PAW + ")");
            int line = 0;
            try
            {
                OleDbParameter[] parms = new OleDbParameter[2];
                parms[0] = new OleDbParameter(PARM_ACCOUNT_ID, OleDbType.VarChar);
                parms[1] = new OleDbParameter(PARM_PAW, OleDbType.VarChar);
                parms[0].Value = user.UserName;
                parms[1].Value = user.PassWord;

                line = AccessHelper.ExecuteNonQuery(AccessHelper.AccessConnString, add.ToString(), CommandType.Text, parms);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            if (line > 0)
                return true;
            else
                return false;
        }

        /// <summary>
        /// 获得所有的用户信息
        /// </summary>
        /// <returns></returns>
        public IList<HotelUser> GetAllUsers()
        {
            StringBuilder sel = new StringBuilder();
            sel.Append("select AccountID,Paw from HotelUser");
            IList<HotelUser> lists = new List<HotelUser>();
            try
            {
                OleDbDataReader rdr = AccessHelper.ExecuteReader(AccessHelper.AccessConnString, CommandType.Text, sel.ToString(), null);
                while (rdr.Read())
                {
                    HotelUser user = new HotelUser();
                    user.UserName = rdr.GetString(0);
                    user.PassWord = rdr.GetString(1);
                    lists.Add(user);
                }
                rdr.Close();
            }
            catch (OleDbException ex)
            {
                lists = null;
                throw new Exception(ex.Message + ex.StackTrace);
            }
            return lists;
        }

        #endregion
    }
}