📄 designcolumnlist.asp
字号:
<% Option Explicit %>
<!--#include file="../../../Inc/Cls_DB.asp" -->
<!--#include file="../../../Inc/Const.asp"-->
<%
'==============================================================================
'软件名称：风讯网站信息管理系统
'当前版本：Foosun Content Manager System(FoosunCMS V3.1.0930)
'最新更新：2005.10
'==============================================================================
'Copyright (C) 2002-2004 Foosun.Net All rights reserved.
'商业注册联系：028-85098980-601,项目开发：028-85098980-606、609,客户支持：608
'产品咨询QQ：394226379,159410,125114015
'技术支持QQ：315485710,66252421
'项目开发QQ：415637671，655071
'程序开发：四川风讯科技发展有限公司(Foosun Inc.)
'Email:service@Foosun.cn
'MSN：skoolls@hotmail.com
'论坛支持：风讯在线论坛(http://bbs.foosun.net)
'官方网站：www.Foosun.cn 演示站点：test.cooin.com
'网站通系列(智能快速建站系列)：www.ewebs.cn
'==============================================================================
'免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接
'风讯公司保留此程序的法律追究权利
'==============================================================================
Dim DBC,Conn
Set DBC = New DataBaseClass
Set Conn = DBC.OpenConnection()
Set DBC = Nothing
%>
<!--#include file="../../../Inc/Session.asp" -->
<!--#include file="../../../Inc/CheckPopedom.asp" -->
<%
'============================
'权限判断
'if Not JudgePopedomTF(Session("Name"),"P040400") then Call ReturnError1()
Dim ColumnSql,RsColumnObj
ColumnSql = "Select ID,TableName,ColumnEName,ColumnCName,ColumnDefault,ColumnNoNull from FS_ColumnInfo order by id desc"
Set RsColumnObj = Server.CreateObject(G_FS_RS)
RsColumnObj.open ColumnSql,Conn,1,1
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>自定义字段列表</title>
</head>
<link href="../../../CSS/FS_css.css" rel="stylesheet">
<script src="../../SysJS/PublicJS.js" language="JavaScript"></script>
<script language="JavaScript" src="../../SysJS/ContentMenu.js"></script>
<body topmargin="2" leftmargin="2" onClick="SelectColumn();" onselectstart="return false;" oncontextmenu="return false;">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#999999">
<tr bgcolor="#EEEEEE">
<td height="26" colspan="5" valign="middle">
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width=35 align="center" alt="添加新字段" onClick="AddColumn();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">新建</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="修改字段" onClick="EditColumn();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">修改</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="删除字段" onClick="DelColumn();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">删除</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="后退" onClick="top.GetEkMainObject().history.back();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">后退</td>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" height="95%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" height="2"></td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="26" class="ButtonListLeft">
<div align="center">字段英文名称</div>
</td>
<td height="26" class="ButtonList">
<div align="center">字段中文名称</div>
</td>
<td height="26" class="ButtonList">
<div align="center">所属表</div>
</td>
<td height="26" class="ButtonList">
<div align="center">默认值</div>
</td>
<td height="26" class="ButtonList">
<div align="center">是否必填</div>
</td>
</tr>
<%
Dim page_size,page_no,page_total,record_all,PageNums
page_size=Request.QueryString("page_size")
if page_size<=0 or page_size="" then page_size=20
If isnumeric(Request.Form("PageNums")) then
if Request.Form("PageNums")<>0 then
page_size = Cint(Request.Form("PageNums"))
end if
End if
page_no=request.querystring("page_no")
if page_no<=1 or page_no="" then page_no=1
If Request.QueryString("page_no")="" then
page_no=1
end if
If Not RsColumnObj.Eof Then
RsColumnObj.PageSize=page_size
page_total=RsColumnObj.PageCount
if (cint(page_no)>page_total) then page_no=page_total
RsColumnObj.AbsolutePage=page_no
record_all=RsColumnObj.RecordCount
End If
Dim i
for i=1 to page_size
if RsColumnObj.eof then exit for
%>
<tr>
<td height="22">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../../Images/ColumnPic.gif" width="18" height="18"></td>
<td><span class="TempletItem" ColumnID="<% = RsColumnObj(0) %>">
<% = RsColumnObj(1)&"."&RsColumnObj(2) %>
</span></td>
</tr>
</table>
</td>
<td>
<div align="center"> <%= RsColumnObj(3)%> </div>
</td>
<td>
<div align="center">
<%
If RsColumnObj(1) = "FS_News" then
Response.Write("新闻表")
ElseIf RsColumnObj(1)="FS_NewsClass" Then
Response.Write("栏目表")
ElseIf RsColumuObj(1)="FS_Shop_Products" Then
Response.Write("商城表")
end if
%>
</div>
</td>
<td>
<div align="center">
<% = RsColumnObj(4) %>
</div>
</td>
<td>
<div align="center">
<%
If RsColumnObj(5)="1" Then
Response.write("是")
Else
Response.write("否")
End If %>
</div>
</td>
</tr>
<%
RsColumnObj.MoveNext
Next
%>
</table>
</td>
</tr>
<%if page_total>1 then%>
<tr>
<td height="18">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td width="42%" height="18">
<table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr> </tr>
</table>
</td>
<td width="51%" height="25" valign="middle">
<div align="right">
<% = "NO.<b>"& page_no &"</b>, " %>
<% = "Totel:<b>"& page_total &"</b>, RecordCounts:<b>" & record_all &"</b> "%>
<%
if Page_Total=1 then
response.Write " <img src=../images/FirstPage.gif border=0 alt=首页></img> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img> "
response.Write " <img src=../images/endPage.gif border=0 alt=尾页></img> "
else
if cint(Page_No)<>1 and cint(Page_No)<>Page_Total then
response.Write " <a href=?page_no=1&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/FirstPage.gif border=0 alt=首页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1)&"&page_size="&page_size&"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1)&"&page_size="&page_size&"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/endPage.gif border=0 alt=尾页></img></a> "
elseif cint(Page_No)=1 then
response.Write " <img src=../images/FirstPage.gif border=0 alt=首页></img></a> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1)&"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/endpage.gif border=0 alt=尾页></img></a> "
else
response.Write " <a href=?page_no=1&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/FirstPage.gif border=0 alt=首页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1)&"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <img src=../images/endpage.gif border=0 alt=尾页></img> "
end if
end if
%>
</div>
</td>
<td width="7%" valign="middle">
<select onChange="ChangePage(this.value);" style="width:50;" name="select">
<% for i=1 to Page_Total %>
<option <% if cint(Page_No) = i then Response.Write("selected")%> value="<% = i %>">
<% = i %>
</option>
<% next %>
</select>
</td>
</tr>
</table>
</td>
</tr>
<%end if%>
</table>
</body>
</html>
<%
Set Conn = Nothing
%>
<script>
var DocumentReadyTF=false;
var ListObjArray = new Array();
var ContentMenuArray=new Array();
function document.onreadystatechange()
{
if (DocumentReadyTF) return;
InitialContentListContentMenu();
DocumentReadyTF=true;
}
function ShowMouseRightMenu(event)
{
ContentMenuShowEvent();
var width=100;
var height=0;
var lefter=event.clientX;
var topper=event.clientY;
var ObjPopDocument=ObjPopupMenu.document;
var ObjPopBody=ObjPopupMenu.document.body;
var MenuStr='';
var sRootDir;
if('<%=SysRootDir%>'=='') sRootDir='';else sRootDir='/<%=SysRootDir%>';
for (var i=0;i<ContentMenuArray.length;i++)
{
if (ContentMenuArray[i].ExeFunction=='seperator')
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -