userm.cs

精通网络应用系统开发 光盘 该书是人民邮电出版社出版的

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Collections.Generic;
using System.Data.Linq;
using System.Web;
using System.Web.Security;
using System.Xml.Linq;
using System.Security;
using System.Security.Cryptography;
using System.Text;

/// <summary>
/// Summary description for UserM
/// </summary>
public class UserM
{
    public static readonly int USERTYPESUPERADMIN = 0;
    public static readonly int USERTYPEADMIN = 1;
    public static readonly int USERTYPENORMAL = 2;
	public UserM()
	{
	}
    /// <summary>
    /// 用户加密函数
    /// </summary>
    public static String Encrypt(string password)
    {
        Byte[] clearBytes = new UnicodeEncoding().GetBytes(password);
        Byte[] hashedBytes = ((HashAlgorithm)CryptoConfig.CreateFromName("MD5")).ComputeHash(clearBytes);

        return BitConverter.ToString(hashedBytes);
    }
    /// <summary>
    /// 判断登录用户
    /// </summary>
    /// <param name="sUserName">用户名</param>
    /// <param name="sPassword">密码</param>
    /// <returns>用户ID</returns>
    public string GetUserLogin(string sUserName, string sPassword)
    {
         DataClassesDataContext db = new DataClassesDataContext();
         string dr = "";
        try
        {
            //获取符合条件的用户
            User myuser = db.Users.Where(u => u.UserName == sUserName && u.Password == sPassword).First();
            dr = myuser.UserID.ToString();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (dr);
    }
    /// <summary>
    /// 添加用户
    /// </summary>
    /// <param name="sUserName">用户名</param>
    /// <param name="sPassword">密码</param>
    /// <param name="sAliasName">别名</param>
    /// <param name="sEmail">邮箱</param>
    /// <param name="nRoleID">角色ID</param>
    public void AddUser(string sUserName, string sPassword, string sAliasName, string sEmail, int nRoleID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //创建一个新用户对象
            User myuser = new User { UserName = sUserName, Password = sPassword,  Email = sEmail, RoleID = nRoleID };
            //添加到数据库
            db.Users.InsertOnSubmit(myuser);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 获取唯一的用户
    /// </summary>
    /// <param name="nUserID">指定用户ID</param>
    /// <returns>返回一个用户</returns>
    public User GetSingleUser(int nUserID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        User myuser;
        try
        {
            myuser = db.Users.Where(u => u.UserID == nUserID).First();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (myuser);
    }
    /// <summary>
    /// 更新用户的密码
    /// </summary>
    /// <param name="nUserID">指定用户的ID</param>
    /// <param name="sPassword">用户的密码</param>
    public void UpdateUserPwd(int nUserID, string sPassword)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //获取指定的用户
            User myuser = db.Users.Where(u => u.UserID == nUserID).First();
            //更改密码
            myuser.Password = sPassword;
            //提交数据更改
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 删除指定的用户
    /// </summary>
    /// <param name="nUserID">制定用户的ID</param>
    public void DeleteUser(int nUserID)
    {
        DataClassesDataContext db = new DataClassesDataContext();
        try
        {
            //获取指定的用户,并从集合中删除
            User myuser = db.Users.Where(u => u.UserID == nUserID).First();
            db.Users.DeleteOnSubmit(myuser);
            db.SubmitChanges();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }
    }
    /// <summary>
    /// 获取所有用户
    /// </summary>
    /// <returns></returns>
    public IList<User> GetUsers()
    {
        DataClassesDataContext db = new DataClassesDataContext();
        IList<User> users;
        try
        {
            users = db.Users.ToList();
        }
        catch (Exception ex)
        {
            ///抛出执行数据库异常
            throw new Exception(ex.Message, ex);
        }

        ///返回从数据库获取的结果
        return (users);
    }
}