userinfodal.cs

酒店管理系统

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using HotelManagerModels;

namespace HotelManagerDAL
{
    public class UserInfoDAL
    {
        string strConn = ConfigurationManager.ConnectionStrings["HotelConn"].ToString();

        #region 添加用户信息
        /// <summary>
        /// 添加用户信息
        /// </summary>
        /// <param name="u">用户对象</param>
        public void InsertUserInfo(UserInfo u)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_InsertUserInfo", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter[] pars = new SqlParameter[] { 
                new SqlParameter("@Name",SqlDbType.VarChar,50),
                new SqlParameter("@Password",SqlDbType.VarChar,50),
                new SqlParameter("@Gender",SqlDbType.Int),
                new SqlParameter("@Email",SqlDbType.VarChar,50),
                new SqlParameter("@Department",SqlDbType.VarChar,50),
                new SqlParameter("@Type",SqlDbType.Int),
            };
                pars[0].Value = u.Name;
                pars[1].Value = u.Password;
                pars[2].Value = u.Gender;
                pars[3].Value = u.Email;
                pars[4].Value = u.Department;
                pars[5].Value = u.Type;
                foreach (SqlParameter par in pars)
                {
                    cmd.Parameters.Add(par);
                }
                try
                {
                    conn.Open();
                    cmd.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        #endregion

        #region 判断用户是否可用,并返回身份
        /// <summary>
        /// 判断用户是否可用,并返回身份
        /// </summary>
        /// <param name="name">用户名</param>
        /// <param name="password">密码</param>
        /// <returns>用户身份</returns>
        public int CheckUserInfo(string name, string password)
        {
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                SqlCommand cmd = new SqlCommand("usp_SelectUserTypeByNamePassword", conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = name;
                cmd.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = password;
                try
                {
                    conn.Open();
                    SqlDataReader dr = cmd.ExecuteReader();
                    while (dr.Read())
                    {
                        return Convert.ToInt32(dr[0]);
                    }
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
                return 0;
            }
        }
        #endregion
    }
}