📄 newworksheet.asp
字号:
<%
'************************************************************************************************
' 文件名: newworksheet.asp
' Copyright(c) 2001-2002 上海阿尔卡特网络支援系统有限公司
'
' 创建人 : 魏霖
' 日 期 : 2002-11-18
' 修改历史 :
' ****年**月**日 ****** 修改内容:**************************************************
' 功能描述 :
' 版 本 :
'*******************************************************************************
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="newworksheet.inc" -->
<%
call CheckSecurity()
dim iRight:iRight=HasRight(ID_WORKSHEET)
if iRight=2 then
else
Response.Clear
Response.Redirect "../include/error.asp?error=只有具有工作单管理更新权限的人员才能访问该网页&"
Response.End
end if
dim conn:set conn=DBConnection
dim iRow
if UCase(Request.ServerVariables("REQUEST_METHOD") = "POST") then
AddWorksheet()
end if
'*******************************************************************************
' 服务器端代码
dim pObjecttype:pObjecttype=GetParam("objecttype")
dim pEquisysid:pEquisysid=GetParam("equisysid")
dim pComplaintid:pComplaintid=GetParam("complaintid")
iRow=0
if IsEmpty(pObjecttype) then
pObjecttype=""
pEquisysid=""
else
if IsEmpty(pEquisysid) then
pEquisisid=""
else
if pObjecttype=0 then
iRow=DLookUp(conn,"select count(*) from t_sys where sys_id="&ToSQL(pEquisysid,"number"))
elseif pObjecttype=1 then
iRow=DLookUp(conn,"select count(*) from t_equipment where equi_id="&ToSQL(pEquisysid,"number"))
else
iRow=0
end if
if iRow=0 then
response.write "<script language=javascript >alert('对不起，系统或设备不存在！')</script>"
response.write "<script language=javascript >history.back();</script>"
Disconnect(conn)
response.end
end if
end if
end if
if IsEmpty(pComplaintid) then
pComplaintid=""
else
iRow=0
iRow=DLookUp(conn,"select count(*) from t_customer_complaints where complaint_id="&ToSQL(pComplaintid,"number"))
if iRow=0 then
response.write "<script language=javascript >alert('对不起，客户意见不存在！')</script>"
response.write "<script language=javascript >history.back();</script>"
Disconnect(conn)
response.end
end if
end if
%>
<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>
input {color:blue}
</style>
<script language="javascript">
function len(str)
{
var y = 0; // 用于保存字符串的长度
var s; // 用于暂存临时字符
y = 0;
for (j=0; j<str.length; j++)
{
s = str.substring(j, j+1)
if ( s.charCodeAt(0) < 0 || s.charCodeAt(0) > 255 )
{
y = y + 2;
}
else
{
y = y + 1;
}
}
return y;
}
function CheckInput()
{
//
var re = new RegExp("^[0-9]*$","ig");
var re1= new RegExp("^2[0-9][0-9][0-9]\-[0-1]?[0-9]\-[0-3]?[0-9]$","ig");
var re2= new RegExp("^2[0-9][0-9][0-9]\-[0-1]?[0-9]\-[0-3]?[0-9] [0-2]?[0-9]:[0-5]?[0-9]:[0-5]?[0-9]$","ig");
var sEquisysid = frmAddWorksheet.equisysid.value;
if (sEquisysid == "")
{
alert("对不起，请输入系统/设备号！");
frmAddWorksheet.equisysid.focus();
return false;
}
else
{
var str = sEquisysid;
if (str.match(re) == null)
{
alert("对不起，系统/对象号只能是数字！");
frmAddWorksheet.equisysid.focus();
return false;
}
}
var sComplaintid = frmAddWorksheet.complaintid.value;
if(sComplaintid!="")
{
var str = sComplaintid;
if (str.match(re) == null)
{
alert("对不起，客户意见号只能是数字！");
frmAddWorksheet.complaintid.focus();
return false;
}
}
var sPlanhours = frmAddWorksheet.planhours.value;
if(sPlanhours=="")
{
alert("对不起，请输入计划工时（整数）！");
frmAddWorksheet.planhours.focus();
return false;
}
else
{
var str = sPlanhours;
if (str.match(re) == null)
{
alert("对不起，计划工时只能是（整数）！");
frmAddWorksheet.planhours.focus();
return false;
}
}
var sLimitdays = frmAddWorksheet.limitdays.value;
if(sLimitdays=="")
{
alert("对不起，请输入完成期限（整数）！");
frmAddWorksheet.limitdays.focus();
return false;
}
else
{
var str = sLimitdays;
if (str.match(re) == null)
{
alert("对不起，完成期限只能是整数！");
frmAddWorksheet.limitdays.focus();
return false;
}
}
var sStarttime = frmAddWorksheet.starttime.value;
if(sStarttime!="")
{
var str = sStarttime;
if ((str.match(re1) == null) &&(str.match(re2) == null))
{
alert("对不起，开始时间格式有误！");
frmAddWorksheet.starttime.focus();
return false;
}
}
var sFailuretime = frmAddWorksheet.failuretime.value;
if(sFailuretime!="")
{
var str = sFailuretime;
if ((str.match(re1) == null) && (str.match(re2) == null))
{
alert("对不起，故障时间格式有误！");
frmAddWorksheet.failuretime.focus();
return false;
}
}
var sContent=frmAddWorksheet.content.value
if(len(sContent)==0)
{
alert("请输入工单内容，不能超过256个字符！");
frmAddWorksheet.content.focus();
return false;
}
if(len(sContent)>256)
{
alert("对不起，输入的工单内容超过256个字符！");
frmAddWorksheet.content.focus();
return false;
}
frmAddWorksheet.submit();
return true;
}
</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 AddWorksheetForm
Response.Write TableLink
'-------------------------------------------------------------------------------
' 主体到这里结束
'*******************************************************************************
Response.Write InnerTableTailer
Response.Write Footer
Response.Write OuterTableTailer
Disconnect(conn)
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -