📄 prints.asp
字号:
<%
'************************************************************************************************
' 文件名: prints.asp
' Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'
' 创建人 : 魏霖
' 日 期 : 2002-12-6
' 修改历史 :
' ****年**月**日 ****** 修改内容:**************************************************
' 功能描述 :
' 版 本 :
'************************************************************************************************
option explicit
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"
Response.Expires = -1
%>
<!-- #include file="../include/common.inc" -->
<!-- #include file="../include/recordlist.inc" -->
<!-- #include file="../include/commonpage.inc" -->
<!-- #include file="prints.inc" -->
<%
call CheckSecurity()
dim iRight:iRight=HasRight(ID_WORKSHEET)
if iRight=1 or iRight=2 then
else
Response.Clear
Response.Redirect "../include/error.asp?error=只有工单管理员或具有工单信息查询权限的人员才能访问该页面&"
Response.End
end if
dim conn :set conn=DBConnection
'********************************************************************************************************
' 服务器端代码
Dim sSQL, sWhere, sOrderby
'-----------------------------------------------------------------------------------------------------'
' 查询参数
'-----------------------------------------------------------------------------------------------------
dim pDay1 : pDay1 = GetParam("pDay1")
dim pDay2 : pDay2 = GetParam("pDay2")
dim pObjecttype : pObjecttype = GetParam("pobjecttype")
dim pObjectname :pObjectname=GetParam("pObjectname")
dim pFinished :pFinished=GetParam("pfinished")
dim pFormtype :pFormtype=GetParam("pformtype")
dim pUrgency :pUrgency=GetParam("purgency")
dim pDepartment :pDepartment=GetParam("pdepartment")
if IsEmpty(pDay1) or IsEmpty(pDay2) then
pDay1=year(date)&"-"&month(date)&"-1"
pDay2=date
end if
if IsEmpty(pObjecttype) then
pObjecttype=-1
pObjectname=""
end if
if IsEmpty(pFinished) then pFinished=0
if IsEmpty(pFormtype) then pFormtype=-1
if IsEmpty(pUrgency) then pUrgency=-1
if IsEmpty(pDepartment) then pDepartment=-1
''response.write pDay1&","&pDay2&","&pObjecttype&","&pObjectname&","&pFinished&","&pFormtype&","&pUrgency&","&pDepartment
''response.end
''sFormParams = "name=" & pName & "person="&pPerson&"&"
''********************************************************************************************************
'' 查询条件限制
''********************************************************************************************************
sWhere=" where starttime>='"&pDay1&"' and starttime<'"&DateAdd("d", 1, pDay2)&"'"
if pFinished>=0 then sWhere=sWhere&" and finished="&ToSQL(pFinished,"number")
if pFormtype>=0 then sWhere=sWhere&" and form_type="&ToSQL(pFormtype,"number")
if pUrgency>=0 then sWhere=sWhere&" and urgency="&ToSQL(pUrgency,"number")
if pDepartment>=0 then sWhere=sWhere&" and department="&ToSQL(pDepartment,"number")
if pObjecttype=0 then
sWhere=sWhere&" and equi_sys_id in (select sys_id from t_sys where sys_desc like "& ToSQL("%" & pObjectname & "%","Text")&") and object_type=0"
end if
if pObjecttype=1 then
sWhere=sWhere&" and equi_sys_id in (select equi_id from t_equipment where name like "& ToSQL("%" & pObjectname & "%","Text")&") and object_type=1"
end if
sSQL = "select * from t_worksheet "&sWhere
%>
<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">
<style type="text/css" media=print>
.noprint {display:none; BORDER: 1PX SOLID #008800; FONT-SIZE: 9PT}
</style>
<style type="text/css" media=screen>
.noprint {display:block; BORDER: 1PX SOLID #008800; FONT-SIZE: 9PT}
</style>
<OBJECT id=closes classid="CLSID:ADB880A6-D8FF-11CF-9377-00AA003B7A11"><param name="Command" value="close"></OBJECT>
<OBJECT id=WB classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" height=0 width=0></OBJECT>
<script language="JavaScript">
function doPrintSetup() { WB.ExecWB(8,1) } // 打印设置
function doPrintPreview() { WB.ExecWB(7,1) } // 打印预览
function doPrint() { WB.ExecWB(6,1) } // 打印
function closethis() { closes.click(); return; } // 关闭窗口
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="../images/bg/bg0.jpg">
<%
'*******************************************************************************
' 主体从这里开始
'-------------------------------------------------------------------------------
Response.Write "<table class=noprint border=0 cellspacing=0 cellpadding=0 width=700 align=center style=""border:2px solid outset"">" & vbLF&_
"<tr height=50 ><td align=center valign=center>" & vbLF & _
"<img border=0 src=""../images/button/preview.gif"" style=""cursor:hand"" OnClick=""JavaScript:doPrintPreview();"">" & vbLF & _
" " & vbLF & _
"<img border=0 src=""../images/button/print.gif"" style=""cursor:hand"" OnClick=""JavaScript:doPrint();"">" & vbLF & _
" " & vbLF & _
"<img border=0 src=""../images/button/close.gif"" style=""cursor:hand"" OnClick=""JavaScript:closes.Click();"">" & vbLF & _
"</td></tr>" & vbLF &_
"</table>"
response.write printsForm
'-------------------------------------------------------------------------------
' 主体到这里结束
'*******************************************************************************
Disconnect(conn)
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -