📄 worker_seach.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../login/check_power.asp"-->
<%
if check_power("员工管理")=0 then
response.redirect("/login/check_false.asp")
else%>
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = "dsn=hotel;"
Recordset1.Source = "SELECT * FROM view_worker_basic_gb"
Recordset1.CursorType = 3
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open
Recordset1_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
<!--
function goworker_show(){
location.assign("worker_show.asp")
}
function checkform(theform){
if (theform.fields_name.value==""){
alert("请选择查询项目");
return false;
}
if (theform.op.value==""){
alert("请选择查询条件");
return false;
}
if (theform.seach_text.value==""){
alert("请填写查询内容");
return false;
}
return true;
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="worker_list.asp" onsubmit="return checkform(this)">
<p>查询项目:
<select name="fields_name"><%
set rsfields=Recordset1.fields
for i=0 to rsfields.count-1
%><option value=<%=rsfields(i).name%>><%=rsfields(i).name%></option><%
next
%> </select>
</p>
<p>查询条件:
<select name="op">
<option value="=" selected>等于</option>
<option value=">">大于</option>
<option value="<">小于</option>
<option value="<>">不等于</option>
<option value="like">包含</option>
</select>
</p>
<p>查询内容:
<input type="text" name="seach_text">
(日期格式:9999-99-99)</p>
<p>
<input type="submit" name="Submit" value="提 交">
<input type="button" name="Submit2" value="返 回" onclick="goworker_show()">
</p>
</form>
</body>
</html>
<%end if%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -