📄 categoryedit.asp

📁 物业管理和办公自动化系统
💻 ASP
字号:
<%
'###########################################################
'#   文件名:  CategoryEdit.asp
'#   创建人:  yaoxiaohui
'#   日期:    2002-07-20
'#   修改历史: ****-**-**
'#   修改内容: *************
'#   功能描述: 类别管理
'#   版 本:
'#   Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'###########################################################
option explicit
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
%>

<!-- #include file="../include/config.inc" -->
<!-- #include file="../include/common.inc" -->
<!-- #include file="../include/debug.inc" -->
<!-- #include file="../include/db.inc" -->
<!-- #include file="../include/emp.inc" -->
<!-- #include file="../include/date.inc" -->
<!-- #include file="../include/datahandle.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/security.inc" -->
<!-- #include file="../common/commonpage.inc" -->

<!-- #include file="categoryedit.inc" -->
<%
'call CheckSecurity()
'----------------------------------------------------------
' 服务器端代码
Dim pTitleId : pTitleId = GetParam("id")
Dim sTitleDesp
if Not IsEmpty(pTitleId) then
	sTitleDesp = DLookUp(dbLocal, "t_library_books_category", "title", "category_id = " & ToSQL(pTitleId, "Number"))
	if sTitleDesp = "" then
		Response.Redirect "../common/error.asp"
		Response.end
	end if
end if
'----------------------------------------------------------
' 如果是提交，则调用函数InsertTitle或UpdateTitle或DeleteTitle更新数据库
Dim sFormAction
if UCase(Request.ServerVariables("REQUEST_METHOD") = "POST") then
	sFormAction = GetParam("FormAction")
	select case sFormAction
	case "insert":
		call AddTitle()
	case "update":
		call UpdateTitle()
	case "delete":
		call DeleteTitle()
	end select
end if
'----------------------------------------------------------
' 分页相关的变量定义
Dim sSQL, sWhere, sOrderby
Dim sFileName			: sFileName = "categoryedit.asp"
Dim iTotalRecords		: iTotalRecords = 0			' 分页
Dim iRecordsPerPage	: iRecordsPerPage = 12
Dim iTotalPages			: iTotalPages = 0
Dim iCols					: iCols = 1
Dim iCurrentPage		: iCurrentPage = GetParam("Page")
Dim iSort					: iSort = GetParam("Sorting")
Dim iSorted				: iSorted = GetParam("Sorted")
Dim sSortParams		: sSortParams = ""
Dim sFormParams		: sFormParams = ""
Dim sDirection			: sDirection = ""
'----------------------------------------------------------
' 构造分页的SQL语句
sSQL = "select category_id as id, title as description from t_library_books_category order by title"
'----------------------------------------------------------
' 分页SQL语句构造完毕，调用PrepareListData进行分页前的准备
dim arrayFields(1), sDelimiter
sDelimiter = "*"
arrayFields(0) = "description"
call PrepareListData(sSQL, Join(arrayFields, sDelimiter), sDelimiter)
'----------------------------------------------------------
%>

<HTML>
<HEAD>
<title>上海信息大楼 Shanghai Information Tower</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<link rel="stylesheet" href="../common/common.css" type="text/css">
<style type="text/css">
input		{color:blue;border-width:1}
</style>
<!--------------------------------------------------------->
<script language="javascript" src="categoryedit.js"></script>
<!--------------------------------------------------------->
</HEAD>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="../images/bg/bg0.jpg">
<br>

<%
Response.Write OuterTableHeader
Response.Write HeaderWithMenu
Response.Write InnerTableHeader
'----------------------------------------------------------
' 主体从这里开始
'----------------------------------------------------------
Response.Write _
	"<table cellspacing=1 cellpadding=0 border=0 bgcolor=navy>" & _
	"<tr>" & _
	"<td width=300 valign=top>" & _
			ListTableHeader & _
			ListTableRecords(sSQL, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams ) & _
			ListTableTailer() & _
	"</td>" & _
	"<td width=300 valign=top>" & _
			FormTable & _
	"</td></tr></table>"

Response.Write TableLink
'----------------------------------------------------------
' 主体到这里结束
'----------------------------------------------------------
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
%>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -