?? propertylist.asp
字號:
<!--#INCLUDE FILE="../HXINCLUDE/HXINCLUDEHEAD.ASP"-->
<%if WS_S.MemberPriv("WS_PublicAffairsPropertyView")<>1 then HX_GoBack "對不起,您的權限不夠!",""
ColumnName="":Tablename="HX_Property":Orderby=" where 1=1":action=request("action"):keywords=request("keywords")
if action="search" then
if WS_S.MemberPriv("WS_PublicAffairsPropertySearch")<>1 then HX_GoBack "對不起,您的權限不夠!",""
if keywords<>"" then
select case request("selectname")
case "PropertyName"
Orderby=Orderby&" and WS_PropertyName like '%"&keywords&"%'"
case "PropertyNUM"
Orderby=Orderby&" and WS_PropertyNUM like '%"&keywords&"%'"
case "PropertyTableDate"
if isdate(keywords) then
Orderby=Orderby&" and WS_PropertyTableDate=#"&keywords&"#"
end if
case "PropertyBuyDate"
if isdate(keywords) then
Orderby=Orderby&" and WS_PropertyBuyDate=#"&keywords&"#"
end if
case "PropertyKind"
Orderby=Orderby&" and WS_PropertyKind like '%"&keywords&"%'"
end select
end if
end if
Orderby=Orderby&" order by WS_PPID desc"
set rs=WS_S.HX_SetRSD(ColumnName,Tablename,Orderby)
response.Write "<head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>資產清單</title><link rel=stylesheet type=text/css href='../HXinclude/HX_Style.css'><script src='../HXinclude/HX_Function.js'></script></head><body topmargin='20' leftmargin='0' bottommargin='0'><table width='98%' border='0' cellspacing='1' cellpadding='0' align=center bgcolor='#115F8F'><tr><td colspan='2' bgcolor=ffffff background='../hximages/titlelinebg.gif'><table width='550' border='0' cellspacing='0' cellpadding='0'><tr><td height='25' background='../hximages/titleline.gif'><font class='fontmenu'>資產清單</font></td></tr></table><table width='100%' border='0' cellspacing='1' cellpadding='3' bgcolor=f1f1f1><tr bgcolor='#A1BBE0' class='td4'><td width='4%'><div align='center'>序號</div></td><td width='8%'><div align='center'>資產編號</div></td><td width='8%'><div align='center'>資產名稱</div></td><td width='9%'><div align='center'>規格型號</div></td><td width='7%'><div align='center'>原始價值</div></td><td width='10%'><div align='center'>購入時間</div></td><td width='7%'><div align='center'>折舊年限</div></td><td width='10%'><div align='center'>制表日期</div></td><td width='9%'><div align='center'>經辦人</div></td><td width='7%'><div align='center'>管理人</div></td><td width='6%'><div align='center'>財務人</div></td><td width='15%'><div align='center'>備注</div></td></tr>"
if rs.recordcount<=0 then
response.Write "<tr><td colspan=12 bgcolor=ffffff height=25 align=center>暫無記錄!</td></tr>"
else
rs.PageSize =15 '每頁記錄條數
iCount=rs.RecordCount '記錄總數
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
ii=0
do while not rs.EOF
response.Write "<tr bgcolor='#FFFFFF' onmouseover=javascript:this.bgColor='#F9F8F2' onmouseout=javascript:this.bgColor='#ffffff'><td width='4%'><div align='center'>"&rs("WS_PPID")&"</div></td><td width='8%'><div align='center'>"&rs("WS_PropertyNUM")&"</div></td><td width='8%'><div align='center'>"&rs("WS_PropertyName")&"</div></td><td width='9%'><div align='center'>"&rs("WS_PropertyKind")&"</div></td><td width='7%'><div align='center'>¥"&rs("WS_PropertyPrice")&"萬元</div></td><td width='10%'><div align='center'>"&WS_S.Format_Time(rs("WS_PropertyBuyDate"),5)&"</div></td><td width='7%'><div align='center'>"&rs("WS_PropertyOldYear")&"年</div></td><td width='10%'><div align='center'>"&WS_S.Format_Time(rs("WS_PropertyTableDate"),5)&"</div></td><td width='9%'><div align='center'>"
Call WS_S.HX_OutUserInfo(rs("WS_PropertyJBManID")):response.Write OutName&"</div></td><td width='7%'><div align='center'>"
Call WS_S.HX_OutUserInfo(rs("WS_PropertyGLManID")):response.Write OutName&"</div></td><td width='6%'><div align='center'>"
Call WS_S.HX_OutUserInfo(rs("WS_PropertyCWManID")):response.Write OutName&"</div></td><td align='center'><div align='left'>"&rs("WS_PropertyRemark")&"</div></td></tr>"
ii=ii+1
if ii>=rs.PageSize then Exit Do
rs.movenext
loop
call WS_S.PageControl(iCount,maxpage,page,"border=0 align=right","<p align=right>",12)
end if
call WS_S.HX_RSClose(rs)
response.Write "<tr bgcolor='#A1BBE0'><td colspan='12' bgcolor='#FFFFFF' align='right'><input name='print' type='button' value=' 打 印 ' onClick='window.print();'> </td></tr></table></td></tr></table>"
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -