userlist.asp
来自「OFFICE办公自动化」· ASP 代码 · 共 130 行
ASP
130 行
<%
'功能:批量选择下属员工
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'变量申明区
dim Rsdepart
dim Sqldepart
%>
<%
'显示部门
set Rsdepart=server.createobject("adodb.recordset")
Sqldepart="select * from tbioadepartment"
Rsdepart.open Sqldepart,oconn,1,3
%>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>选择接受者</title>
<SCRIPT language=javascript>
<!--
function unselectall()
{
if (document.frm.checuser.checked){
document.frm.checuser.checked = document.frm.checuser.checked&0;
}
}
function selectall()
{
var length=document.frm.checuser.length ;
document.frm.checuser.checked = document.frm.all.checked|0;
if (length == 0 ){
return;
}
if (length ==1 )
{
document.frm.checuser.checked=document.frm.all.checked ;
}
if (length>1)
{
for (var i = 0; i < length; i++)
{
document.frm.checuser[i].checked=document.frm.all.checked;
}
}
}
function chec()
{
var checstr=",";
var name="";
var tempstr
var length=document.frm.checuser.length ;
for(var i=0;i<length;i++)
{
tempstr="";
if(document.frm.checuser[i].checked)
{
tempstr=(document.frm.checuser[i].value).split("/");
checstr=checstr+tempstr[0]+",";
name=name+tempstr[1]+" ";
}
}
self.opener.document.eventfrm.userlist.value=name;
self.opener.document.eventfrm.userid.value=checstr;
window.close();
}
//-->
</SCRIPT>
</HEAD>
<body topmargin="0" leftmargin="0">
<center>
<form name="frm" method="POST" action="">
<table width="75%" border="0" cellspacing="10" cellpadding="0">
<tr>
<td colspan="5" class="tdTop"><div align="center">用户列表</div></td>
</tr>
<%
set Rsuser=server.CreateObject("adodb.recordset")
kk=0
do while not Rsdepart.eof
Rsuser.open "select * from tbioaUser where department='" &Rsdepart("id")& "'",oconn,1,3
%>
<tr>
<td colspan="5" align="left"><%=Rsdepart("name")%> </td>
</tr>
<%
i=0
do while not Rsuser.eof
kk=kk+1
if (i mod 5= 0) then response.write ("</tr><tr>")
i=i+1
%>
<td ><input type="checkbox" name="checuser" value="<%=Rsuser("loginname")%>/<%=Rsuser("name")%>" >
<%=Rsuser("name")%> </td>
<%
Rsuser.movenext
loop
Rsuser.close
Rsdepart.movenext
loop
%>
<tr>
<td>
<input type="checkbox" name="all" id="Sall" value=1 onClick=selectall()>
<label for="Sall" style="CURSOR: hand">全 选</label
</td>
</tr>
<tr>
<td ><div align="center">
<input type="button" name="Submit" value="确定" class="button0" onClick="chec()">
</div></td>
</tr>
</table>
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?