📄 newreportto.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
if request("id")<>"" then
dim connq
dim rsq
set connq=server.CreateObject("adodb.connection")
set rsq=server.CreateObject("adodb.recordset")
connq.Open connstring
rsq.Open "select * from userreportto where id="&request("id"),connq,2,3,1
struser=rsq("userid")
strusername=getfieldvalue("usertable","loginid",rsq("userid"),"username")
strowner=rsq("reportto")
strownername=getfieldvalue("usertable","loginid",rsq("reportto"),"username")
rsq.Close
set rsq=nothing
connq.Close
set connq=nothing
else
strdefinetype=request("deftype")
end if
if request("owner")<>"" then
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
set rsu=conn.Execute("select * from userreportto where (userid='"&Request.Form("user")&"' and reportto='"&Request.Form("owner")&"') or (userid='"&Request.Form("owner")&"' and reportto='"&Request.Form("user")&"')")
if not rsu.EOF then
%>
<script language=javascript>
alert('已经存在这个职位关系');
</script>
<%
else
if request("id")="" then
rs.Open "select * from userreportto",conn,2,3,1
rs.AddNew
else
rs.Open "select * from userreportto where id="&request("id"),conn,2,3,1
end if
rs("userid")=request("user")
rs("reportto")=request("owner")
rs.Update
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
<script language=javascript>
window.opener.location.reload();
window.close();
</script>
<%
end if
end if
%>
<HTML><HEAD><TITLE><%if request("id")="" then%>新建职位关系<%else%>编辑职位关系<%end if%></TITLE>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<script language="javascript">
function save(){
if (form1.owner.value==''){
alert('请选择上级!');
form1.owner.focus();
return;
}
if (form1.user.value==''){
alert('请选择用户!');
form1.user.focus();
return;
}
if (form1.owner.value==form1.user.value){
alert('不能指定自己为上级!');
form1.user.focus();
return;
}
form1.submit();
}
</script>
<form name=form1 method="post" id=form1>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font size="2" class=title><b><%if request("id")="" then%>新建职位关系<%else%>编辑职位关系<%end if%></b></font></strong></td>
<td> </td>
</tr>
<tr >
<td height="16" colspan="2" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4></td>
</tr>
<tr><td>
<div align="center" style="cursor:hand"><a onclick="save();"><img src="../images/button_save.gif"></a> <a onclick="window.close();"><img src="../images/button_cancel.gif"></a>
</div></td>
</tr>
</table>
<table width="100%" align="center" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="40%" bgcolor="DEDFDE" >
<div align="center"><font color="#FF0000" size="3">*</font>上级</div></td>
<td width="60%" bgcolor="EFEFEF">
<input name="owner" type="hidden" size="8" value="<%=strowner%>">
<input name="ownername" type="text" size="12" value="<%=strownername%>" readonly>
<input type="button" name="bnowner" onClick="JavaScript:opensubwin2('form1','owner')" value=... class=black></td>
</tr>
<tr>
<td width="40%" bgcolor="DEDFDE">
<div align="center"><font color="#FF0000" size="3">*</font>用户</div></td>
<td width="60%" bgcolor="EFEFEF">
<input name="user" type="hidden" size="8" value="<%=struser%>">
<input name="username" type="text" size="12" value="<%=strusername%>" readonly>
<input type="button" name="bnuser" onClick="JavaScript:opensubwin2('form1','user')" value=... class=black></td>
</tr>
</table>
</form>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -