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