/* Admin Class JScript */
/* */
/*********************************************************/
//Member Method Define
//检测用户名是否存在(通用)
function _isExitsUser(userName)
{
try
{
//var conn = this.conn;
var flag ;
var sql = " select memBasInfId from M_MemBasInf where memUserName = '" + userName + "' ";
var rs = Server.CreateObject("ADODB.Recordset");
rs.open(sql,this.conn,1,1);
flag = ( rs.Eof == true ? false : true );
return flag;
}
finally
{
closeObj(rs);
}
}
//获取用户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 rs = Server.CreateObject("ADODB.Recordset");
rs.open(sql,this.conn,1,1);
if(!rs.eof)
{
userId = rs("memBasInfId");
}
return userId;
}
finally
{
//closeObj(rs);
}
}
//会员登录
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 AdminPaswd = '"+userPas+"' ";
var rs = Server.CreateObject("ADODB.Recordset");
rs.open(sql,this.conn,1,1);
flag = ( rs.Eof == true ? false : true );
if(flag)
{
Session("adminName") = userName;
Session("adminPaswd") = userPas;
}
return flag;
}
finally
{
closeObj(rs);
}
}
//会员注销
function _loginOut()
{
}
//更新密码
function _altPassword(oldPas,newPas)
{
try
{
var AdminName = String(Session("AdminName"));
var flag;
flag = false;
var rs = 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 AdminPaswd = '"+newPas+"' where AdminName = '"+AdminName+"' ";
this.conn.Execute(sql);
Session("AdminPaswd") = newPas;//更新密码
flag = true;
}
return flag;
}
finally
{
closeObj(rs);
}
}
//构造函数
function clsAdmin(conn)
{
//property
this.conn = conn;
//method
this.login = _login;
this.altPaswd = _altPassword;
}