rolemodule.asp

蓝芒3.0A最新所有功能完整破解版

<% ModuleCode="M0120" %>
<!--#include file="../../Include/Reference.asp"-->
<%
Call PrintPageHead
%>
<!--#include file="../../Include/connect.asp"-->
<%
strSQL="select * from T_DNS_RoleInfo order by RoleCode"
Set Rs= Server.CreateObject("ADODB.Recordset")
Rs.open strSQL,Cn,1,1
If Rs.Eof Then
	Response.Write "目前还没有角色信息记录，请先添加角色！"
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">共 <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>
  </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("RoleCode")%></font></td>
        <td><%=Rs("RoleName")%></td>
        <td>
		<%  '显示模块
		ModuleStr=""
		StrSQL="Select b.ModuleName  from T_DNS_RoleModule a, T_DNS_ModuleInfo b where a.RoleCode='"& rs("RoleCode")&"' and a.ModuleCode=b.ModuleCode order by b.ModuleCode"
		Set Rs2= Server.CreateObject("ADODB.Recordset")
		Rs2.open StrSQL,Cn
		while not Rs2.EOF
			ModuleStr =ModuleStr & rs2("ModuleName")& ","
			Rs2.MoveNext
		wend
		Rs2.Close
		ModuleStr=Replace(ModuleStr," ","")
		if Len(ModuleStr) > 60 then
			ModuleStr = Left(ModuleStr,30) & " ..."
		end if
		Response.Write ModuleStr
		%>
        </td>
        <td>
        <a href="RoleModuleEdt.asp?RoleCode=<%=Rs("RoleCode")%>&RoleName=<%=Rs("RoleName")%>" class="a2">修改</a>&nbsp;
        </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")%>?TicketType=<%=TicketType%>&px=<%=px%>">
  <tr height="26">
      <td>     
          <%if currentpage>1 then%>
              <a href="<%=Request("SCRIPT_NAME")%>?currentpage=1&TicketType=<%=TicketType%>&px=<%=px%>" class="a2">首页</a> <a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=currentpage-1%>&TicketType=<%=TicketType%>&px=<%=px%>" class="a2">上一页</a>
          <%end if%>
          <%if currentpage<pages then%>
              <a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=currentpage+1%>&TicketType=<%=TicketType%>&px=<%=px%>" class="a2">下一页</a> <a href="<%=Request("SCRIPT_NAME")%>?currentpage=<%=pages%>&TicketType=<%=TicketType%>&px=<%=px%>" class="a2">末页</a>
          <%end if%>
      </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
%>