user.cs

一个基于.NETFramework架构的图书管理系统

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

namespace DataAccess
{
    public class User
    {
        private SqlCommand cmd;
        public User()
        {
            cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
        }

        public DataSet GetUserInfo(string userno)
        {
            if (userno == null)
                throw new ArgumentException("userno");

            cmd.Parameters.Clear();
            cmd.CommandText = "GetUserInfoByNo";
            cmd.Parameters.Add("@UserNo", SqlDbType.Char, 11).Value = userno;
            DataSet ds = DataAccess.DBAccess.QueryData(cmd);
            return ds;
        }
        public bool Login(string userno, string password)
        {
            if (userno == null)
            {
                throw new ArgumentNullException("userno");
            }
            if (password == null)
            {
                throw new ArgumentNullException("password");
            }
            cmd.Parameters.Clear();
            cmd.CommandText = "UserLogin";
            cmd.Parameters.Add("@UserNo", SqlDbType.Char, 11).Value = userno;
            cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 10).Value = password;
            object objResult = DBAccess.GetScalar(cmd);
            if (objResult == null)
            {
                return false;
            }
            else
            {
                if ((int)objResult > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }

        }

        public bool InsertUser(string userno, string username, string password, int sex, string email, string classname)
        {
            if (userno == null)
            {
                throw new ArgumentNullException("userno");
            }
            if (username == null)
            {
                throw new ArgumentNullException("username");
            }
            cmd.Parameters.Clear();
            cmd.CommandText = "InsertNewUser";
            cmd.Parameters.Add("@UserNo", SqlDbType.Char, 11).Value = userno;
            cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 20).Value = username;
            cmd.Parameters.Add("@Sex", SqlDbType.Bit).Value = sex;
            cmd.Parameters.Add("@PassWord ", SqlDbType.NVarChar, 10).Value = password;
            cmd.Parameters.Add("@Email ", SqlDbType.NVarChar, 30).Value = email;
            cmd.Parameters.Add("@Class", SqlDbType.NVarChar, 40).Value = classname;
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }
        }
    }
}