📄 moduleinfo.asp
字号:
<% ModuleCode="M0117" %>
<!--#include file="../../Include/Reference.asp"-->
<%
Call PrintPageHead
%>
<!--#include file="../../Include/connect.asp"-->
<%
TypeCode=Request("TypeCode")
if TypeCode<>"" then
strSQL="Select a.ModuleCode,a.ModuleName,a.ModulePath,b.TypeName from T_DNS_ModuleInfo a,T_DNS_ModuleType b where a.TypeCode=b.TypeCode and a.TypeCode='" & TypeCode & "' order by a.TypeCode,a.ModuleCode"
else
strSQL="Select a.ModuleCode,a.ModuleName,a.ModulePath,b.TypeName from T_DNS_ModuleInfo a,T_DNS_ModuleType b where a.TypeCode=b.TypeCode order by a.TypeCode,a.ModuleCode"
end if
Set Rs= Server.CreateObject("ADODB.Recordset")
Rs.open strSQL,Cn,1,1
If Rs.Eof Then
Response.Write "<br><br><p align=center>目前还没有模块信息记录!"
else
Rs.PageSize=Opt_PageSize
pages=Rs.pagecount
records=Rs.recordcount
currentpage=request("currentpage")
if currentpage="" or currentpage<1 then currentpage=1
currentpage=cint(currentpage)
if currentpage>pages then currentpage=pages
Rs.absolutepage=currentpage
%>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td height="22" class="titletext"><font color="<%=Opt_Font_TitleColor%>"><strong>模块信息管理</strong></font></td>
<td align="right"><a href="ModuleInfoEdt.asp" class="a2"><b>添加模块信息</b></a></td>
<td align="right">共 <font color="red"><b><%=Records%></b></font> 个项目 页次:
<font color="red"><b><%=currentpage%></b></font> / <font color="red"><b><%=Pages%></b></font>
页
</td>
</tr>
</tbody>
</table>
<!------------------------------------------------------------------------------------->
<table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="<%=Opt_Table_BGColor%>">
<tr bgcolor="<%=Opt_TR_BGColor%>" height="24">
<td>模块代码</td>
<td>模块名称</td>
<td>相对路径</td>
<td>模块类别</td>
<td width="70">操作</td>
</tr>
<%
linenumber=Rs.pagesize
do while (not Rs.eof) and (line<linenumber)
if line mod 2 =0 Then %>
<tr bgcolor="<%=Opt_TD_BGColor1%>" height="20">
<% else %>
<tr bgcolor="<%=Opt_TD_BGColor2%>" height="20">
<% end if %>
<td><font color="<%=Opt_Font_IndexColor%>"><%=Rs("ModuleCode")%></font></td>
<td><%=Rs("ModuleName")%></td>
<td><%=Rs("ModulePath")%></td>
<td><%=Rs("TypeName")%></td>
<td>
<a href="ModuleInfoEdt.asp?ModuleCode=<%=Rs("ModuleCode")%>" class="a2">修改</a>
<a href="ModuleInfoSQL.asp?act=删除&ModuleCode=<%=Rs("ModuleCode")%>" class="a2">删除</a>
</td>
</tr>
<%
Rs.MoveNext
line=line+1
Loop
%>
</table>
<!-------------------------------------分页导航--------------------------------------->
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tbody>
<form name="pageform" method="Post" action="<%=Request("SCRIPT_NAME")%>?px=<%=px%>">
<tr height="26">
<td>
<%if currentpage>1 then%>
<a href="<%=Request("SCRIPT_NAME")%>?currentpage=1&TypeCode=<%=TypeCode%>&px=<%=px%>" class="a2">首页</a> <a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=currentpage-1%>&TypeCode=<%=TypeCode%>&px=<%=px%>" class="a2">上一页</a>
<%end if%>
<%if currentpage<pages then%>
<a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=currentpage+1%>&TypeCode=<%=TypeCode%>&px=<%=px%>" class="a2">下一页</a> <a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=pages%>&TypeCode=<%=TypeCode%>&px=<%=px%>" class="a2">末页</a>
<%end if%>
</td>
<td>
<select name="TypeCode" class="input" onchange="document.pageform.submit();">
<option value="">全部</option>
<%
strSQL1="Select * from T_DNS_ModuleType order by DispSeq"
Set Rs1= Server.CreateObject("ADODB.Recordset")
Rs1.open strSQL1,Cn,1,1
While not Rs1.eof
%>
<option value="<%=Rs1("TypeCode")%>" <% if TypeCode=Rs1("TypeCode") then Response.Write "selected" %>><%=Rs1("TypeName")%></option>
<%
Rs1.movenext
Wend
Rs1.close
Set Rs1=nothing
%>
</select>
</td>
<td align="right">
转到: <input type="text" name="currentpage" size="2" maxlength="6" class="input" value="<%=currentpage%>"> 页
</td></tr>
</form>
</tbody>
</table>
<%
end if
Rs.Close
Cn.Close
Set Rs=Nothing
Set Cn=Nothing
%>
<br><br>
<%
Call PrintPageBottom
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -