登录使用类

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);
   }
   
  
  }
  
 }
 }