log_check.asp

企业员工年度综合评测系统 Access(V1.060118)版

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp" -->
<%
var isvgm=Request("isvgm");
var rs__name1 = "0";
if (String(Request("name")) != "undefined" && 
    String(Request("name")) != "") { 
  rs__name1 = String(Request("name"));
}
%>
<%
var rs__pwd1 = "0";
if (String(Request("pwd")) != "undefined" && 
    String(Request("pwd")) != "") { 
  rs__pwd1 = String(Request("pwd"));
}
%>
<%
var sql="";
if(isvgm==1)
    {sql="SELECT *  FROM department  WHERE admin2='"+ rs__name1.replace(/'/g, "''") + "'And pw2='"+ rs__pwd1.replace(/'/g, "''") + "'";}
else 
    {sql="SELECT *  FROM department  WHERE admin1='"+ rs__name1.replace(/'/g, "''") + "'And pw1='"+ rs__pwd1.replace(/'/g, "''") + "'";	}
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM_conn_STRING;
rs.Source = sql;
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
%>
<%
if(rs.EOF)
      {Response.Write("<script language='javascript'>window.alert('您输入的用户名或密码有误');history.go(-1);</script>");}
if(!rs.EOF&&!rs.BOF)
    {    
	    Session("passed")=7666342;
		Session("departmentid")=rs.Fields.Item("departmentid").Value;
		Session("departmentname")=rs.Fields.Item("departmentname").Value;
		Session("k1")=rs.Fields.Item("k").Value;
			 
		Session("ok")=rs.Fields.Item("k").Value;
		if(isvgm==1)
	       {Session("admin")=rs.Fields.Item("admin2").Value;
		    Session("isvgm")=1;	
			}	
	    else
		  {Session("admin")=rs.Fields.Item("admin1").Value;
		  Session("isvgm")=0;}  
		Response.Redirect("main.asp");
		}
%>
<%
rs.Close();
%>