MyBookShopDAL/UsersService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MyBookShop.Model;
using System.Data.SqlClient;

namespace MyBookShop.DAL
{
    public class UsersService
    {
        /// <summary>
        /// 添加一个用户
        /// </summary>
        /// <param name="user">要添加的用户对象</param>
        /// <returns>受影响的行数</returns>
        public int AddUser(Users user)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into Users values (");
            builder.Append("@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserRoleId,@UserStateId)");
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@LoginId",user.LoginId),
                new SqlParameter("@LoginPwd",user.LoginPwd),
                new SqlParameter("@Name",user.Name),
                new SqlParameter("@Address",user.Address),
                new SqlParameter("@Phone",user.Phone),
                new SqlParameter("@Mail",user.Mail),
                new SqlParameter("@UserRoleId",user.UserRoleId),
                new SqlParameter("@UserStateId",user.UserStateId)
            };
            int count = DBHelper.ExecuteNonQuery(System.Data.CommandType.Text, builder.ToString(), paras);
            return count;
        }

        /// <summary>
        /// 判断用户名是否存在
        /// </summary>
        /// <param name="loginId">要验证的用户名</param>
        /// <returns>存在的记录数</returns>
        public int ExistLoginId(string loginId)
        {
            string sqlStr = "select count(1) from Users where LoginId = @loginId";
            SqlParameter[] paras = new SqlParameter[]
            {
              new SqlParameter("@loginId",loginId)  
            };
            object obj = DBHelper.ExecuteScalar(System.Data.CommandType.Text, sqlStr, paras);
            return Convert.ToInt32(obj);
        }

        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="user">要登录的用户对象</param>
        /// <returns>该用户是否存在数据库中</returns>
        public Users UserLogin(string loginId, string loginPwd)
        {
            Users user = null;