t_user.cs

这是一个很好的图书管理系统 数据库SQL2005

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using PublicClass;

namespace BLL
{
    public class T_User
    {
        DAL.DB_User user = new DAL.DB_User();

        private UserModel _User;

        public UserModel User
        {
            get { return _User; }
            set { _User = value; }
        }

        /// <summary>
        /// OK表示用户名和密码正确,Nonentity表示帐户不存在,PassWordError表示密码错误!
        /// </summary>
        public enum UserLoginKey
        {
            OK=0,
            Nonentity=-1,
            PassWordError=100
        }

        /// <summary>
        /// 登录验证
        /// </summary>
        /// <returns>返回0表示用户名和密码正确,-1表示帐户不存在,100表示密码错误!</returns>
        public int UserLogin()
        {
            user.User=_User;
            DataTable dt = user.LoginSelect();
            if (dt.Rows.Count == 0)
            {
                return -1;
            }
            string userpwd = _User.PassWord;
            if (userpwd != dt.Rows[0]["PassWord"].ToString())
            {
                return 100;
            }
            _User.UserID = int.Parse(dt.Rows[0]["UserID"].ToString());
            _User.Level = dt.Rows[0]["Level"].ToString();
            return 0;
        }

        /// <summary>
        /// 增加用户
        /// </summary>
        /// <returns>返回0表示用户信息有误,1表示增加成功,-1表示用户已存在!</returns>
        public int UserInsert()
        {
            user.User = _User;
            //判断用户名是否存在
            DataTable dt = user.LoginSelect();
            if (dt.Rows.Count > 0)
            {
                return -1;
            }
            int re = 0;
            try
            {
                //增加用户
                int row = user.InsertUser();
                if (row > 0)
                {
                    re = 1;
                }
                else
                    re = 0;
            }
            catch (Exception ex)
            {
                throw new Exception("用户信息有误", ex);
            }

            return re;
        }

        /// <summary>
        /// 查询所有用户
        /// </summary>
        /// <returns>返回所有用户信息</returns>
        public DataTable UserSelect(string id)
        {
            return user.SelectUser(id);
        }

        public DataTable UserSelect()
        {
            return user.SelectUser();
        }

        /// <summary>
        /// 删除用户
        /// </summary>
        /// <returns>返回1表示成功，0表示失败</returns>
        public int UserDelete()
        {
            int temp = 0;
            int row = 0;
            user.User = _User;
            row = user.DeleteUser();
            if (row > 0)
            {
                temp = 1;
            }
            else
                temp = 0;
            return temp;
        }

        /// <summary>
        /// 更新用户
        /// </summary>
        /// <returns>返回0表示失败，1表示成功</returns>
        public int UserUpdate()
        {
            int row = 0;
            user.User = _User;
            //权限为-1返回0
            if (_User.Level == "-1")
            {
                return 0;
            }
            row = user.UpdateUser();
            if (row > 0)
            {
                return 1;
            }
            else
                return 0;
        }


        /// <summary>
        /// 搜索用户
        /// </summary>
        /// <returns>返回搜索结果(DataTable)</returns>
        public void SelectUserID()
        {
            user.User = _User;
            DataTable dt = user.SearchUserID();
            _User.UserName = dt.Rows[0].ItemArray[1].ToString();
            _User.PassWord = dt.Rows[0].ItemArray[2].ToString();
            _User.Level = dt.Rows[0].ItemArray[3].ToString();
        }
    }
}