usermanager.cs

C#2.0宝典源码,C#经典书籍,很多例子

using System;
using System.Data.OleDb;
using StudentsMIS.DataAccess;

namespace StudentsMIS.Security
{
	/// <summary>
	/// UserManager 的摘要说明。
	/// </summary>
	public class UserManager
	{
		public UserManager()
		{
			
		}

    public UserEntity Select(string id)
    {
      UserEntity entity = new UserEntity();
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From admin Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminID",id);
      OleDbDataReader objReader = objCommand.ExecuteReader();
      if(objReader.Read())
      {
        entity.AdminName = objReader["admin_name"].ToString().Trim();
        entity.AdminLevel = objReader["admin_level"].ToString().Trim();
        entity.AdminPassword = objReader["admin_password"].ToString().Trim();
      }
      return entity;
    }

    public int Insert(UserEntity obj)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From admin Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminID",obj.AdminID);
      if(objCommand.ExecuteReader().HasRows)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Insert Into admin(admin_ID,admin_name,admin_level,admin_password) Values(@AdminID,@AdminName,@AdminLevel,@AdminPassword)");
      objCommand.Parameters.Add("@AdminID",obj.AdminID);
      objCommand.Parameters.Add("@AdminName",obj.AdminName);
      objCommand.Parameters.Add("@AdminLevel",obj.AdminLevel);
      objCommand.Parameters.Add("@AdminPassword",obj.AdminPassword);
      objCommand.ExecuteNonQuery();
      return 1;
    }

    public void Delete(string id)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Delete From admin Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public void Update(UserEntity obj)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Update admin Set admin_name=@AdminName,admin_level=@AdminLevel Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminName",obj.AdminName);
      objCommand.Parameters.Add("@AdminLevel",obj.AdminLevel);
      objCommand.Parameters.Add("@AdminID",obj.AdminID);      
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
    }

    public int UpdatePwd(string id,string oldPwd,string newPwd)
    {
      OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select admin_password From admin Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminID",id);
      if(objCommand.ExecuteScalar().ToString().Trim()!=oldPwd)
      {
        CommandCloser.CloseOleDbCommand(objCommand);
        return 0;
      }
      objCommand = CommandBuilder.BuildOleDbCommand("Update admin Set admin_password=@AdminPassword Where admin_ID=@AdminID");
      objCommand.Parameters.Add("@AdminPassword",newPwd);
      objCommand.Parameters.Add("@AdminID",id);
      objCommand.ExecuteNonQuery();
      CommandCloser.CloseOleDbCommand(objCommand);
      return 1;
    }
	}
}