admin.cs

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

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

namespace DataAccess
{
    public class Admin
    {
        private Comm.Encrypt encrypt;
        private SqlCommand cmd;
        public Admin()
        {
            encrypt = new Comm.Encrypt();
            cmd = new SqlCommand();
            cmd.CommandType = CommandType.StoredProcedure;
        }
        public bool InsertAdmin(string adminno,string adminname,string password,string email  )
        {
            if (adminno == null)
                throw new ArgumentNullException("adminno");

            if (adminname== null)
                throw new ArgumentNullException("adminname");

            if (password == null)
                throw new ArgumentNullException("password");

            if (email == null)
                throw new ArgumentNullException("email");
            cmd.Parameters.Clear();
            cmd.CommandText = "InsertAdmin";
            cmd.Parameters .Add ("@AdminNO",SqlDbType .Char ,10).Value =adminno ;
            cmd.Parameters .Add ("@AdminName",SqlDbType .NVarChar ,30).Value =adminname ;
            cmd.Parameters.Add("@PassWord", SqlDbType.Binary ,20).Value = encrypt.EncryptPassword(password);
            cmd.Parameters .Add ("@Email",SqlDbType .NVarChar ,40).Value =email ;
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }

        }
        public bool Login(string adminno, string password)
        {
            if (adminno == null)
                throw new ArgumentNullException("adminno");
            if (password == null)
                throw new ArgumentNullException("password");
            cmd.Parameters.Clear();
            cmd.CommandText = "AdminLogin";
            cmd.Parameters .Add ("@AdminNO",SqlDbType .Char ,10).Value =adminno;
            cmd.Parameters.Add("@Password", SqlDbType.Binary, 20).Value = encrypt.EncryptPassword (password);
            Object o = DBAccess.GetScalar(cmd);
            if (o == null)
            {
                return false;
            }
            else
            {
                if ((int)o > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }

        }
        public bool ChangePassword(string adminno, string newpassword)
        {
            if (adminno == null)
                throw new ArgumentNullException("adminno");
            if (newpassword == null)
                throw new ArgumentNullException("newpassword");
            cmd.Parameters.Clear();
            cmd.CommandText = "ChangeAdminPassword";
            cmd.Parameters.Add("@AdminNO", SqlDbType.Char, 10).Value = adminno;
            cmd.Parameters.Add("@Password", SqlDbType.Binary, 20).Value = encrypt.EncryptPassword(newpassword); 
            try
            {
                DBAccess.ExecuteSQL(cmd);
                return true;
            }
            catch
            {
                return false;
            }

        }
    }
}