📄 ksquery.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="StudentConn.asp" -->
<%
Dim Recordset1__MMColParam, strStudentNum, strName, strClass
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_StudentConn_STRING
strStudentNum= Request("StudentNum")
strName=Request("Name")
strGrade=Request("GradeID")
strClass=Request("ClassID")
if Request.QueryString<>"" then Session("strQureyString")=Request.QueryString
if Request.Form<>"" then Session("strQureyString")=Request.Form
if strStudentNum <> "" then
Recordset1__MMColParam =strStudentNum
Recordset1.Source = "SELECT * FROM StudentInfo WHERE StudentNum like '%" & Recordset1__MMColParam & "%' ORDER BY StudentNum"
else
if strName<>"" then
Recordset1__MMColParam =strName
Recordset1.Source = "SELECT * FROM StudentInfo WHERE Name like '%" & Recordset1__MMColParam & "%' ORDER BY StudentNum"
else
if strClass<>"" and strGrade<>"" then
if strClass="All" then strClass=""
Recordset1__MMColParam =strClass
Recordset1__Grade=strGrade
Recordset1.Source = "SELECT * FROM StudentInfo WHERE ClassID like '%" & Recordset1__MMColParam & "%' and GradeID like '%" & Recordset1__Grade &"%' ORDER BY StudentNum"
end if
end if
end if
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<%
Dim Recordset2
Set Recordset2=Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection=MM_StudentConn_STRING
if not Recordset1.eof Then
Recordset2.Source="Select * from Class Where ClassID='" & Recordset1("ClassID") & "' and GradeID='" & Recordset1("GradeID") & "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 3
Recordset2.LockType = 3
Recordset2.Open()
End If
%>
<%
Dim rsGrade1__MMColParam
rsGrade1__MMColParam = "01"
If (Request("MM_EmptyValue") <> "") Then
rsGrade1__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsGrade1
Dim rsGrade1_numRows
Set rsGrade1 = Server.CreateObject("ADODB.Recordset")
rsGrade1.ActiveConnection = MM_StudentConn_STRING
rsGrade1.Source = "SELECT * FROM Class WHERE GradeID = '" & rsGrade1__MMColParam & "' ORDER BY ClassID ASC"
rsGrade1.CursorType = 0
rsGrade1.CursorLocation = 2
rsGrade1.LockType = 1
rsGrade1.Open()
rsGrade1_numRows = 0
%>
<%
Dim rsGrade2__MMColParam
rsGrade2__MMColParam = "02"
If (Request("MM_EmptyValue") <> "") Then
rsGrade2__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsGrade2
Dim rsGrade2_numRows
Set rsGrade2 = Server.CreateObject("ADODB.Recordset")
rsGrade2.ActiveConnection = MM_StudentConn_STRING
rsGrade2.Source = "SELECT * FROM Class WHERE GradeID = '" & rsGrade2__MMColParam & "' ORDER BY ClassID ASC"
rsGrade2.CursorType = 0
rsGrade2.CursorLocation = 2
rsGrade2.LockType = 1
rsGrade2.Open()
rsGrade2_numRows = 0
%>
<%
Dim rsGrade3__MMColParam
rsGrade3__MMColParam = "03"
If (Request("MM_EmptyValue") <> "") Then
rsGrade3__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsGrade3
Dim rsGrade3_numRows
Set rsGrade3 = Server.CreateObject("ADODB.Recordset")
rsGrade3.ActiveConnection = MM_StudentConn_STRING
rsGrade3.Source = "SELECT * FROM Class WHERE GradeID = '" & rsGrade3__MMColParam & "' ORDER BY ClassID ASC"
rsGrade3.CursorType = 0
rsGrade3.CursorLocation = 2
rsGrade3.LockType = 1
rsGrade3.Open()
rsGrade3_numRows = 0
%>
<%
Dim rsGrade4__MMColParam
rsGrade4__MMColParam = "04"
If (Request("MM_EmptyValue") <> "") Then
rsGrade4__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsGrade4
Dim rsGrade4_numRows
Set rsGrade4 = Server.CreateObject("ADODB.Recordset")
rsGrade4.ActiveConnection = MM_StudentConn_STRING
rsGrade4.Source = "SELECT * FROM Class WHERE GradeID = '" &rsGrade4__MMColParam & "' ORDER BY ClassID ASC"
rsGrade4.CursorType = 0
rsGrade4.CursorLocation = 2
rsGrade4.LockType = 1
rsGrade4.Open()
rsGrade4_numRows = 0
%>
<%
Dim rsGrade5__MMColParam
rsGrade5__MMColParam = "05"
If (Request("MM_EmptyValue") <> "") Then
rsGrade5__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsGrade5
Dim rsGrade5_numRows
Set rsGrade5 = Server.CreateObject("ADODB.Recordset")
rsGrade5.ActiveConnection = MM_StudentConn_STRING
rsGrade5.Source = "SELECT * FROM Class WHERE GradeID = '" & rsGrade5__MMColParam & "' ORDER BY ClassID ASC"
rsGrade5.CursorType = 0
rsGrade5.CursorLocation = 2
rsGrade5.LockType = 1
rsGrade5.Open()
rsGrade5_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>人员调科</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2600.0" Name=GENERATOR>
<link rel="stylesheet" href="home.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
function ChangeClass()
{
var i;
for(i=document.form1.ClassID.options.length-1;i>=0;i--)
{
document.form1.ClassID.options[i]=null;
}
switch(document.form1.GradeID.selectedIndex)
{
case 0:
for(i=0;i<document.Classes.Grade1.options.length;i++)
{
document.form1.ClassID.options[i]=new Option(document.Classes.Grade1.options[i].text,document.Classes.Grade1.options[i].value);
}
break;
case 1:
for(i=0;i<document.Classes.Grade2.options.length;i++)
{
document.form1.ClassID.options[i]=new Option(document.Classes.Grade2.options[i].text,document.Classes.Grade2.options[i].value);
}
break;
case 2:
for(i=0;i<document.Classes.Grade3.options.length;i++)
{
document.form1.ClassID.options[i]=new Option(document.Classes.Grade3.options[i].text,document.Classes.Grade3.options[i].value);
}
break;
case 3:
for(i=0;i<document.Classes.Grade4.options.length;i++)
{
document.form1.ClassID.options[i]=new Option(document.Classes.Grade4.options[i].text,document.Classes.Grade4.options[i].value);
}
break;
case 4:
for(i=0;i<document.Classes.Grade5.options.length;i++)
{
document.form1.ClassID.options[i]=new Option(document.Classes.Grade5.options[i].text,document.Classes.Grade5.options[i].value);
}
break;
}
}
</script>
</HEAD>
<BODY text=#000000 bgColor=#f7f7ff leftMargin=0 topMargin=0>
<div id="Layer1" style="position:absolute; left:445px; top:220px; width:188px; height:64px; z-index:1; visibility: hidden;">
<form name="Classes" method="post" action="">
<select name="Grade1" id="select">
<option value="All">全部</option>
<%
While (NOT rsGrade1.EOF)
%>
<option value="<%=(rsGrade1.Fields.Item("ClassID").Value)%>"><%=(rsGrade1.Fields.Item("ClassName").Value)%></option>
<%
rsGrade1.MoveNext()
Wend
If (rsGrade1.CursorType > 0) Then
rsGrade1.MoveFirst
Else
rsGrade1.Requery
End If
%>
</select>
<select name="Grade2" id="select2">
<option value="All">全部</option>
<%
While (NOT rsGrade2.EOF)
%>
<option value="<%=(rsGrade2.Fields.Item("ClassID").Value)%>"><%=(rsGrade2.Fields.Item("ClassName").Value)%></option>
<%
rsGrade2.MoveNext()
Wend
If (rsGrade2.CursorType > 0) Then
rsGrade2.MoveFirst
Else
rsGrade2.Requery
End If
%>
</select>
<select name="Grade3" id="Grade3">
<option value="All">全部</option>
<%
While (NOT rsGrade3.EOF)
%>
<option value="<%=(rsGrade3.Fields.Item("ClassID").Value)%>"><%=(rsGrade3.Fields.Item("ClassName").Value)%></option>
<%
rsGrade3.MoveNext()
Wend
If (rsGrade3.CursorType > 0) Then
rsGrade3.MoveFirst
Else
rsGrade3.Requery
End If
%>
</select>
<select name="Grade4" id="Grade4">
<option value="All">全部</option>
<%
While (NOT rsGrade4.EOF)
%>
<option value="<%=(rsGrade4.Fields.Item("ClassID").Value)%>"><%=(rsGrade4.Fields.Item("ClassName").Value)%></option>
<%
rsGrade4.MoveNext()
Wend
If (rsGrade4.CursorType > 0) Then
rsGrade4.MoveFirst
Else
rsGrade4.Requery
End If
%>
</select>
<select name="Grade5" id="Grade5">
<option value="All">全部</option>
<%
While (NOT rsGrade5.EOF)
%>
<option value="<%=(rsGrade5.Fields.Item("ClassID").Value)%>"><%=(rsGrade5.Fields.Item("ClassName").Value)%></option>
<%
rsGrade5.MoveNext()
Wend
If (rsGrade5.CursorType > 0) Then
rsGrade5.MoveFirst
Else
rsGrade5.Requery
End If
%>
</select>
</form>
</div>
<!--#include file="InfoManage_Top.asp"-->
<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
<TR>
<TD align="center" valign="top" bgcolor="#F7f7ff">
<% If Not Recordset1.EOF Or Not Recordset1.BOF Then %>
<form Name="form1" method="post" action="Modify_ks.asp"><br><br>
<span class="title">人员科室调整</span><font color="#FF0000"><br><br><br></font>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<%
txtStudentNum=Recordset1.Fields.Item("StudentNum").Value & ""
txtName=replace(Recordset1.Fields.Item("Name").Value & ""," "," ")
if txtName="" then txtName=" "
txtClassName=replace(Recordset2("ClassName") & ""," "," ")
if txtClassName="" then txtClassName=" "
txtGradeName=replace(Recordset2("Grade") & ""," "," ")
if txtGradeName="" then txtGradeName=" "
%>
<table cellspacing=1 width="300" border=1 cellpadding="1" bordercolor="#CCCCFF" align="center" style="border-collapse:collapse">
<tr align="center">
<td width="60" nowrap><font color="#000000">编号</font></td><td height="20" align="center" nowrap><%=txtStudentNum%></td>
<td height="20" align="center" nowrap> </td>
</tr>
<tr align="center">
<td nowrap><font color="#000000">姓名</font></td><td height="20" align="center" nowrap><%=txtName%></td>
<td height="20" align="center" nowrap>调整人员类别和科室</td>
</tr>
<tr align="center">
<td nowrap><font color="#000000">人员类别</font></td><td height="20" align="center" nowrap><%=txtGradeName%></td>
<td align="center" nowrap><select name="GradeID" onChange="ChangeClass()">
<option value="01" selected>医疗</option>
<option value="02">药品</option>
<option value="03">行政</option>
<option value="04">合同</option>
<option value="05">自负</option>
</select></td>
</tr>
<tr align="center">
<td nowrap><font color="#000000">科室</font></td><td height="20" align="center" nowrap><%=txtClassName%></td>
<td height="20" align="center" nowrap> <select name="ClassID">
<option value="All" selected>全部</option>
<%
While (NOT rsGrade1.EOF)
%>
<option value="<%=(rsGrade1.Fields.Item("ClassID").Value)%>"><%=(rsGrade1.Fields.Item("ClassName").Value)%></option>
<%
rsGrade1.MoveNext()
Wend
If (rsGrade1.CursorType > 0) Then
rsGrade1.MoveFirst
Else
rsGrade1.Requery
End If
%></select></td>
</tr>
</table>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%><br><br>
<input type="hidden" name="txtName" value="<%=txtName%>">
<input type="hidden" name="StudentNum" value="<%=strStudentNum%>">
<input type="submit" name="kstz" value="确认调整"><br><br><input type="button" name="fanhui" value="返回" onClick="javascript:history.go(-1)" style="cursor:hand"></form>
<%
else
Response.Write("<br><br><br><br><font color=#ff0000>没有您要查询的人员！</font><br><br><br><a href='javascript:history.go(-1)'>重新查询</a><br><br><br>")
End If
%>
</TD>
</TR>
</TBODY>
</TABLE>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<Iframe src="CopyRight.asp" width="760" height="100" marginheight="0" marginwidth="0" scrolling="NO" frameborder="0" name="CopyRight"></iframe>
</td>
</tr>
</table></BODY>
</HTML>
<%
Recordset1.Close()
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -