hoteluserservice.cs

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

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

using IDAL;
using Model;
using DBUtility;
using System.Data;
using System.Data.SqlClient;

namespace SQLServerDAL
{
    public class HotelUserService:IHotelUser
    {
        #region IHotelUser 成员
        private const string PARM_USER_NAME = "@userName";
        private const string PARM_PASSWORD = "@passWord";

        /// <summary>
        /// 按用户名查询用户密码
        /// </summary>
        /// <param name="userName"></param>
        /// <returns></returns>
        public string GetUserPasswordByUserName(string userName)
        {
            StringBuilder sql = new StringBuilder();
            string str = string.Empty;
            sql.Append("select Password from HotelUser where UserName='" + userName + "'");
            try
            {
                string temp = SQLHelper.ExecuteScalar(SQLHelper.SQLConnString, 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(UserName,Password) values(");
            add.Append(PARM_USER_NAME + ",");
            add.Append(PARM_PASSWORD);
            int line = 0;
            try
            {
                SqlParameter[] parms = new SqlParameter[2];
                parms[0] = new SqlParameter(PARM_USER_NAME,SqlDbType.NVarChar);
                parms[1] = new SqlParameter(PARM_PASSWORD,SqlDbType.NVarChar);
                parms[0].Value = user.UserName;
                parms[1].Value = user.PassWord;
                add.Append(")");
                line = SQLHelper.ExecuteNonQuery(SQLHelper.SQLConnString, 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 UserName,Password from HotelUser");
            IList<HotelUser> lists = new List<HotelUser>();
            try
            {
                SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.SQLConnString, 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 (Exception ex)
            {
                lists = null;
                throw new Exception(ex.Message + ex.StackTrace);
            }
            return lists;
        }

        #endregion
    }
}