?? default.asp
字號:
<!-- #include virtual="/eB3KTransaction.asp" -->
<!-- #include virtual="/Server/ebo.asp" -->
<!-- #include virtual="/Server/cblib.asp" -->
<!-- #include file="../Common.asp" -->
<HTML><HEAD><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><LINK REL=stylesheet HREF="/Client/All.css" TYPE="text/css"><script src="/Client/ebComm.js"></script></HEAD>
<script src="/client/ebo.js"></script>
<script src="/client/Request.js"></script>
<script src="/client/IClient.js"></script>
<script src="/client/grid.js"></script>
<BODY>
<div id=SelectArea></div>
<div id=PageCtrlArea></div>
</BODY>
<%
dim eBP,y
Set eBP = Server.CreateObject("ZZ.Privilege")
y=eBP.PrivilegeTest(0,Clng(bdType),8,me)
if CStr(y)<>"0" then err.raise 10000,"PrivilegeGroup.Open", eBP.GetLastError()
dim szSQL,szFind,iListWidth
dim SQLSelect,SQLFrom,SQLWhere,SQLOrderSQLSelect=""SQLFrom=""SQLWhere=""SQLOrder=""
iListWidth = 5 'ListWidth
szFind = Request("Find")
SQLFrom = SQLFrom& " FROM [BillDocument]"
SQLWhere=SQLWhere&" WHERE AccountID=" & AccountID & " AND IsDeleted=0 AND BillType=" & bdType & ""
if len(szFind)<>0 then
SQLWhere = SQLWhere & " AND ID="& SQLInputParam(szFind)
end if
SQLOrder=SQLOrder &" ORDER BY ID DESC"
'eboReg
eboReg 1, "List_0_", "ID", "", "cbRSDirect"
eboReg 1, "List_1_", "BillDate", "", "cbRSDateToText"
eboReg 1, "List_2_", "Stock", "", "cbRSStockToText"
eboReg 1, "List_3_", "Amount", "", "cbRSDirect"
eboReg 1, "List_4_", "AuditID", "", "cbRSDirect"
eboReg 2, "List_rows", "i", "", "cbLocalVariable"
eboReg 2, "List_cols", "iListWidth", "", "cbLocalVariable"
eboReg 2, "MaxPage", "iMaxPage", "", "cbLocalVariable"
'End
dim iPage,iRows,iMaxPage
iMaxPage = 0
iPage = GetLong(Request("Page"),1) 'default page pos
iRows = GetLong(Request("Rows"),10) 'default rows
dim eBD,rs
dim i,x,szTableName
Set eBD = Server.CreateObject("eB3KCommon.BillDocument")
x = eBD.bdGetDetailByType(Conn, CLng(bdType), rs)
set eBD = Nothing
if x=0 then
szSQl = ""
else
szTableName = CStr(rs("TableName"))
end if
set rs = nothing
i = 0dim iRecordCount ,tRcSQLSelect="SELECT COUNT(*) AS rc "
szSQL=SQLSelect & SQLFrom & SQLWhere
szSQL=replace(szSQL,"[BillDocument]","["&szTableName&"]")
tRc=Conn.Execute(szSQL)
iRecordCount=tRc("rc")
SQLSelect=" SELECT TOP "& iPage*iRows & " [ID],[BillDate],[Stock],[Amount],[AuditID] "
szSQL=SQLSelect & SQLFrom & SQLWhere & SQLOrder
Response.Write "<script>" & VBCrLf
if szSQL <> "" then
szSQL=replace(szSQL,"[BillDocument]","["&szTableName&"]")
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open szSQL,Conn,1,1
iMaxPage = Int((iRecordCount+iRows-1)/iRows)
if iRecordCount > 0 then rs.move iPage*iRows-iRows
IData2d 1,1
Do While Not rs.EOF And i < iRows
eboGet 1, rs, nothing
i = i + 1
rs.MoveNext
Loop
Set rs = Nothing
end if
IData2d 0,2
eboGet 2, nothing, nothing
Response.Write "</script>" & VBCrLf
%>
<script>
requestSet('Page','<%=iPage%>');
requestSet('Rows','<%=iRows%>');
</script>
<script src="default.js"></script>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -