?? index.asp
字號:
<% Set hdobj = Server.CreateObject("HD.comOpen")'請確保此行在最前
Connkaa = hdobj.WeekaaConn()
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="pragma" content="no-cache">
<title>紅笛軟件</title>
<style type="text/css">
<!--
.style3 {font-size: 12px}
.style4 {
font-size: 14px;
}
body,td,th {
font-size: 12px;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-image: url(../Image/bg.gif);
}
.STYLE9 {
font-size: 36px;
font-family: "黑體";
font-weight: bold;
color: #FFFF00;
}
.STYLE10 {color: #FF0000}
a:link {
text-decoration: none;
color: #003366;
}
a:visited {
text-decoration: none;
color: #003366;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.STYLE12 {font-family: "黑體"; font-size: 16px;}
.style13 {
font-size: 12px;
}
.tables {
background-image: url(../Image/bigbg.jpg);
background-repeat: no-repeat;
}
-->
</style><script language="JavaScript" type="text/JavaScript">
function delpay()
{
if(confirm("確定要刪除此嗎？"))
return true;
else
return false;
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body onmouseover="self.status='紅笛軟件:服務網址[http://weekaa.com/red]';return true">
<%
dim stv,sqstv,La,Lb
tab="stuCard"
La=Request("La")
Lb=Request("Lb")
Set stv = Server.CreateObject("ADODB.RecordSet")
sqstv = "Select * From [sets] where TB='"&tab&"'"
stv.Open Sqstv,Connkaa,1,3
ListLong=stv("lis")
if session("StudentListLm")<>"" then
ListLong=session("StudentListLm")
end if
Na=mid(ListLong,1,1)
Nb=mid(ListLong,2,1)
Nc=mid(ListLong,3,1)
Nd=mid(ListLong,4,1)
Ne=mid(ListLong,5,1)
Nf=mid(ListLong,6,1)
Ng=mid(ListLong,7,1)
Nh=mid(ListLong,8,1)
%>
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#3399fd">
<tr>
<td height="150" align="center" valign="bottom"><img src="../Image/bigbga.jpg" width="1003" height="150"></td>
</tr>
<tr>
<td height="28" align="center" valign="middle" background="../Image/bg01a.jpg"> </td>
</tr>
<tr>
<td height="28" align="center" valign="middle"> </td>
</tr>
<tr>
<td height="600" align="center" valign="top">
<table width="94%" height="25" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#0066CC">
<tr valign="bottom" bordercolor="#6A8FDA" bgcolor="#FFFFFF">
<td height="60" align="center" valign="bottom" bgcolor="#FFFFFF">
<form action="?action=search" method="post" name="form1" id="form1">
<%call hdobj.Solist("student", "La")%>
輸入查詢內容 <input name="Lb" type="text" id="Lb" size="14">
<input name="Submit2" type="submit" id="Submit" value="提交">
<a href="#" onClick="MM_openBrWindow('Lm.asp?Taba=stuCard','紅笛軟件','scrollbars=no,width=800,height=120,top=200,left=300')">[證卡名稱設置]</a>
</form></td></tr></table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0"><tr><td height="10"> </td></tr></table>
<table width="94%" border="1" align="center" cellspacing="0" bordercolor="#0033CC">
<tr><td height="30" align="center" class="STYLE12" background='../Image/bg01.jpg'>學生證卡管理</td></tr>
<tr> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#E8EBEE">
<tr align="center" bgcolor="#F1F3F5">
<td width="8%" height="25" class="style3">學 號</td>
<td width="8%" class="style3">姓名</td>
<td width="8%" class="style3">性別</td>
<td width="8%" class="style3"><%=stv(Na)%></td>
<td width="8%" class="style3"><%=stv(Nb)%></td>
<td width="8%" class="style3"><%=stv(Nc)%></td>
<td width="8%" class="style3"><%=stv(Nd)%></td>
<td width="8%" class="style3"><%=stv(Ne)%></td>
<td width="8%" class="style3"><%=stv(Nf)%></td>
<td width="14%" class="style3"><%=stv(Ng)%></td>
<td width="14%" class="style3"><%=stv(Nh)%></td></tr>
<%
Set rs = Server.CreateObject("ADODB.RecordSet")
if Lb="" or La="" then
sqls = "Select * From [student] order by c asc"
else
sqls = "Select * From [student] where "&La&" like '%"&Lb&"%' order by c asc"
end if
rs.Open Sqls,Connkaa,1,3
'=========================================================
Dim i, text, checkpage, page, MaxPerPage, CurrentPage
MaxPerPage = Request.Form("pages")
If MaxPerPage = "" Then
MaxPerPage = 12
End If
If MaxPerPage < 1 Or MaxPerPage > 1000 Then
MaxPerPage = 12
End If
MaxPerPage = MaxPerPage * 1
text = "0123456789"
rs.PageSize = MaxPerPage
GoPage = Request.Form("pagee")
For i = 1 To Len(GoPage)
checkpage = InStr(1, text, Mid(GoPage, i, 1))
If checkpage = 0 Then
Exit For
End If
Next
If checkpage <> 0 Then
If Not IsEmpty(GoPage) Then
CurrentPage = CInt(GoPage)
If CurrentPage < 1 Then CurrentPage = 1
If CurrentPage > rs.PageCount Then CurrentPage = rs.PageCount
Else
CurrentPage = 1
End If
If Not rs.EOF Then
rs.AbsolutePage = CurrentPage
End If
Else
CurrentPage = 1
End If
RsSum = CStr(rs.RecordCount) '記錄總條數
pageOn = CStr(CurrentPage) '當前第幾頁
pageSum = CStr(rs.PageCount) '總共幾頁
NextPage = pageOn + 1
If NextPage*1>pageSum*1 Then
NextPage = 1
End If
'==============================================================
i=0
do while not rs.eof
rsNb=rs("c")
nameLen = Len(rsNb)
If nameLen = 2 Then
rsNbs = Mid(rsNb, 1, 1) & " " & Mid(rsNb, 2, 1)
rsNb = rsNbs
End If
rsID=rs("ID")
set rc=Server.CreateObject("ADODB.RecordSet")
sqlc = "Select * From [stuCard] where l='"&rsID&"'"
rc.Open Sqlc,Connkaa,1,3
if rc.eof then
rc.addnew
rc("a")="未發證"
rc("b")="未發證"
rc("c")="未發證"
rc("d")="未發證"
rc("e")="未發證"
rc("f")="未發證"
rc("g")="未發證"
rc("h")="未發證"
rc("l")= rsID
rcA="未發證"
rcB="未發證"
rcC="未發證"
rcD="未發證"
rcE="未發證"
rcF="未發證"
rcG="未發證"
rcH="未發證"
rc.update
else
rcA=rc("a")
rcB=rc("b")
rcC=rc("c")
rcD=rc("d")
rcE=rc("e")
rcF=rc("f")
rcG=rc("g")
rcH=rc("h")
rcID=rc("ID")
end if
Longa="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=a&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longb="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=b&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longc="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=c&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longd="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=d&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longe="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=e&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longf="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=f&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longg="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=g&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
Longh="<a href='#' onClick=" & Chr(34) & "MM_openBrWindow('StudentCardadd.asp?n=h&ID=" & rcID &"','紅笛軟件','scrollbars=no,width=250,height=30,top=200,left=300')" & Chr(34) & ">"
response.write "<tr align='center' valign='bottom' bgcolor='#FFFFFF'>"
response.write "<td height='25'><a href='../H/StudentPer.asp?ID=" & rs("ID") & "' target='_blank'>"& rs("a") & "</a></td>"
response.write "<td>" & rsNb & "</td>"
response.write "<td>" & rs("d") & "</td>"
if rcA="未發證" then
response.write "<td>" &longa & rcA & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longa & rcA & "</a></td>"
end if
if rcB="未發證" then
response.write "<td>" &longb & rcB & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longb & rcB & "</a></td>"
end if
if rcC="未發證" then
response.write "<td>" &longc & rcC & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longc & rcC & "</a></td>"
end if
if rcD="未發證" then
response.write "<td>" &longd & rcD & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longd & rcD & "</a></td>"
end if
if rcE="未發證" then
response.write "<td>" &longe & rcE & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longe & rcE & "</a></td>"
end if
if rcF="未發證" then
response.write "<td>" &longf & rcF & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longf & rcF & "</a></td>"
end if
if rcG="未發證" then
response.write "<td>" &longg & rcG & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longg & rcG & "</a></td>"
end if
if rcH="未發證" then
response.write "<td>" &longh & rcH & "</a></td>"
else
response.write "<td bgcolor='#00CC66'>" &longh & rcH & "</a></td></tr>"
end if
rc.close
set rc=nothing
i=i+1
if i >= MaxPerpage then exit do
rs.movenext
loop
Response.Write "</table></td></tr><tr><form name='form2' method='post' action=''><td height='30' align='center' background='../Image/bg01.jpg'>"
Response.Write "<span class='STYLE13'><input type='hidden' name='La' value='" & La & "'><input type='hidden' name='Ld' value='" & Ld & "'>"
Response.Write "<span class='STYLE13'><input type='hidden' name='Lb' value='" & Lb & "'><input type='hidden' name='Lc' value='" & Lc & "'>"
Response.Write "第" & pageOn & "/" & pageSum & "頁 共" & RsSum & "條記錄 每頁"
Response.Write "<input name='pages' type='text' id='pages' value='" & MaxPerPage & "'"
Response.Write " size='2' style='background-color: #FFFFFF; border-color: #FFFFFF; border-style: solid; border-width: 0px 0px 1px 0px, font-family:Verdana,Arial; font-size: 10pt; color: #FF0000'>"
Response.Write "條記錄 轉到</span>"
Response.Write "<input name='pagee' type='text' id='pagee' value='" & NextPage & "' size='2' style='background-color: #FFFFFF; border-color: #FFFFFF;"
Response.Write " border-style: solid; border-width: 0px 0px 1px 0px, font-family:Verdana,Arial; font-size: 10pt; color: #FF0000'>"
Response.Write "<input name='Submit' type='submit' class='STYLE10' value='Go'></td></form></tr></table></td></tr><tr><td height='30' bordercolor='#3399FD' background='../Image/bg01a.jpg'> </td></tr></table>"
If Request.QueryString("deln") = "del" Then
call hdobj.Deler("student","ll")
end if
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -