<%
/ ************************************************** ******** /
/ * Admin class jscript * /
/ * * /
/ ************************************************** ******** /
// Member Method Define
/ / Detect the user name existing (universal)
Function _iseXitsuser (username)
{
Try
{
// var conn = this.conn;
Var flag;
Var SQL = "SELECT MEMBASINFID from M_MEMBASINF WHERE MEMUSERNAME = '" Username ""
Var = Server.createObject ("AdoDb.Recordset");
RS.Open (SQL, this.conn, 1, 1);
Flag = (rs.eof == True? false: true);
Return flag;
}
Finally
{
CloseObj (RS);
}
}
// Get user ID
Function _GetUseridByuserName (username)
{
Try
{
UserName = String (username) .trim ();
// var conn = this.conn;
VAR userid = 0;
Var SQL = "SELECT MEMBASINFID from M_MEMBASINF WHERE MEMUSERNAME = '" Username ""
// var SQL = "SELECT MEMBASINFID from M_MEMBASINF WHERE MEMUSERNAME = 'Abao'";
Var = Server.createObject ("AdoDb.Recordset");
RS.Open (SQL, this.conn, 1, 1);
IF (! rs.eof)
{
UserId = rs ("MEMBASINFID");
}
Return UserId;
}
Finally
{
// CloseObj (RS);
}
}
//Member Login
Function _Login (username, userpas)
{
Try
{
UserName = SQLSTR (String (username) .trim ());
UserPas = SQLSTR (String (userpas) .trim ());
Var flag;
VAR SQL = "SELECT AdminID from T_S_Admin";
SQL = "Where adminName = '" username "' and adminPasewd = '" userpas "";
Var = Server.createObject ("AdoDb.Recordset");
RS.Open (SQL, this.conn, 1, 1);
Flag = (rs.eof == True? false: true); if (flag)
{
Session ("adminName" = username;
Session ("adminPasewd") = UserPas;
}
Return flag;
}
Finally
{
CloseObj (RS);
}
}
/ / Member logout
Function _loginout ()
{
}
// update password
Function _altpassword (OldPas, NewPas)
{
Try
{
Var adminName = string (session ("adminName");
Var flag;
Flag = false;
Var = Server.createObject ("AdoDb.Recordset");
VAR SQL = "SELECT AdminID from T_S_Admin";
SQL = "Where adminPaswd = '" OldPas "' and adminName = '" adminName "'"
Rs.Open (SQL, this.conn, 1, 1)
IF (! rs.eof)
{
SQL = "Update T_S_Admin Set Admin Paswd = '" NewPas "' where adminName = '" adminName ""
THIS.CONN.EXECUTE (SQL);
Session ("adminPaswd") = newpas; // update password
Flag = true;
}
Return flag;
}
Finally
{
CloseObj (RS);
}
}
//Constructor
Function CLSADMIN (CONN)
{
// Property
THIS.CONN = conn;
//Method
THIS.LOGIN = _Login;
THIS.ALTPASWD = _ALTPASSWORD;
}
