用户登录验证-优快云博客

本文介绍了一个简单的用户登录验证机制实现方式，包括验证用户身份和获取用户的权限级别。通过SQL查询数据库来判断用户输入的用户名和密码是否正确，并进一步获取该用户的权限。

using System;
using RFID.PublicClass.DataBase;
using System.Data;
using System.Data.SqlClient;
using System.Web;

namespace RFID.PublicClass.LogIn
{

public class UserRole
{
  private static string TABLE="TM_SYS_USER";
  private static string UID=null;
  private static string PSW=null;
        private static string SQL=null;
  private static string POWER=null;
  private static string GETROLE=null;
  //--------------------------------------------------------------------------------------------------------
  public UserRole(string logname,string logword)
  { UID=logname;
     PSW=logword;
     SQL="select count(*) from "+TABLE+" where LOGNAME='"+UID+"' and LOGPWORD='"+PSW+"'";
     GETROLE="select POWER from "+TABLE+" where LOGNAME='"+UID+"' and LOGPWORD='"+PSW+"'";
  }

  //判断是否允许登陆
  public static bool GetPass()
  {
   try
   {
    SqlDB db = new SqlDB ();
    DataSet ds=null;
    ds=db.GetDataSet(SQL,TABLE);
    int count=Convert.ToInt16(ds.Tables[TABLE].Rows[0][0]);
    db.CloseConn();
    ds.Clear();
    if(count==0)
    {
     return (false);
    }
    else
    {
     return (true);
    }
   }
   catch
   {
    return (false);
   }


  }

  //判断权限,获得权限。
  public static string Power()
  {
   try
   {
    SqlDB db=new SqlDB ();
    DataSet dsRoleDist = db.GetDataSet(GETROLE,"tbl");
    POWER= dsRoleDist.Tables["tbl"].Rows[0][0].ToString();
    dsRoleDist.Clear();
    db.CloseConn();
    return (POWER);
   }
   catch
   {return (null);
   }


  }

}
}

登录使用类