purchase_input_detail.asp

物业管理和办公自动化系统

<%
'##############################################################################
'#
'#		文 件 名	 : purchase_input_detail.asp
'#
'#
'#		创 建 人	 : yaoxiaohui
'# 　	日　  期	 : 2002-11-7
'#
'#		修改历史  : ****年**月**日 ******
'#      修改内容  : **************************************************
'#
'#		功能描述	 : 采购入库物品
'# 　	版  　本	 : v1.0
'#	
'#	    Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'#
'##############################################################################
'------------------------------------------------------------------------------
'----   服务器端设置
'------------------------------------------------------------------------------
option explicit
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
%>
<!-- include files begin -->

<!-- #include file="../include/common.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/commonpage.inc" -->

<!-- #include file="purchase_input_detail.inc" -->

<!-- include files end -->
<%
call CheckSecurity()
'------------------------------------------------------------------------------
'----   用户权限检查
'------------------------------------------------------------------------------
if hasright(ID_STOCK) < RIGHT_WRITE  then
	Response.Clear
	Response.Redirect "../include/error.asp?error=只有仓库管理员才能进行入库操作！"
	Response.end
end if
'##############################################################################
'----   服务器端代码
'##############################################################################
dim conn
set conn = DBConnection

dim pSheetID   :  pSheetID = GetParam("id")

'response.write pSheetID & "<br>"
'response.end

if UCase(Request.ServerVariables("REQUEST_METHOD") = "POST") then
	dim choose1, choose2, sFormAction
	choose1 = GetParam("choose1")
	choose2 = GetParam("choose2")
	sFormAction = GetParam("FormAction")
	select case sFormAction
	case "input"
		call Input(choose1)
	case "output"
		call Output(choose2)
	case "cancel"
		call Cancel()
	end select
end if

'******************************************************************************
'----   分页相关的变量定义
'------------------------------------------------------------------------------
Dim sSQL, sWhere, sOrderby ,sWhere1
Dim sFileName			: sFileName			= "purchase_input_detail.asp"
Dim iTotalRecords		: iTotalRecords		= 0			                ' 分页
Dim iRecordsPerPage		: iRecordsPerPage	= 10                         ' 一页8行
Dim iTotalPages			: iTotalPages		= 0
Dim iCols				: iCols				= 9                         ' 9列
Dim iCurrentPage		: iCurrentPage		= GetParam("Page")
Dim sSorting			: sSorting			= GetParam("Sorting")
Dim sSorted				: sSorted			= GetParam("Sorted")
Dim sSortParams			: sSortParams		= ""
Dim sFormParams			: sFormParams		= ""
Dim sDirection			: sDirection		= ""
'******************************************************************************
'----   构造分页的SQL语句
'------------------------------------------------------------------------------
sSQL = "select cargo_id,cargo_name,sheet_id,model,quantity,unit_price,unit,remark" & _
" from t_purchase_detail"
sWhere = " where sheet_id in(" & pSheetID & ") and is_input = '0'"
sWhere1 = " where sheet_id in(" & pSheetID & ") and is_input = '1'"
sOrderby = " order by cargo_id"
'------------------------------------------------------------------------------
sFormParams = "id=" & pSheetID & "&"
'******************************************************************************
'----   分页SQL语句构造完毕，调用PrepareListData进行分页前的准备
'------------------------------------------------------------------------------
dim arrayFields(7), sDelimiter
sDelimiter = "*"
arrayFields(0)	=	"cargo_id"
arrayFields(1)	=	"cargo_name"
arrayFields(2)	=	"sheet_id"
arrayFields(3)	=	"model"
arrayFields(4)	=	"quantity"
arrayFields(5)	=	"unit_price"
arrayFields(6)	=	"unit"
arrayFields(7)	=	"remark"

'response.write pSheetID  &"<BR>"
'response.write sSQL & sWhere & sOrderby  &"<BR>"
'response.end

call PrepareListData(conn,sSQL & sWhere & sOrderby, 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="../include/common.css" type="text/css">

<script language="javascript" src="purchase_input_detail.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 TableHeader
Response.Write TableRecords(sSQL & sWhere & sOrderby, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams )

Response.Write TableRecords2(sSQL & sWhere1 & sOrderby, iCols, iRecordsPerPage, iTotalRecords, iCurrentPage, iTotalPages, sFileName, sFormParams, sSortParams )

Response.Write TableAction
'------------------------------------------------------------------------------
'----   主体到这里结束
'******************************************************************************
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
Disconnect(conn)
%>

</body>
</html>