📄 psserach.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.zh.conpool.Condata"%>
<%@ page import="com.bwm.string.Str"%>
<% request.setCharacterEncoding("gb2312"); %>
<%
String sess=(String)session.getAttribute("username");
if(sess==null||sess.equals("")){
response.sendRedirect("../main.jsp");
}else{
swing.Rous rou=new swing.Rous();
boolean maybe=rou.toInt(sess,"row111");
if(!maybe){
response.sendRedirect("../../notrous.jsp");
}
}
%><html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/style1.css" rel="stylesheet">
</head>
<script language="JavaScript">
function CheckDate(INDate)
{ if (INDate=="")
{return true;}
subYY=INDate.substr(0,4)
//转换月份
if(INDate.indexOf('-',0)!=-1){ separate="-"}
else{
if(INDate.indexOf('/',0)!=-1){separate="/"}
else {return true;}}
area=INDate.indexOf(separate,0)
subMM=INDate.substr(area+1,INDate.indexOf(separate,area+1)-(area+1))
if(subMM.length<2){subMM="0"+subMM}
//转换日
area=INDate.lastIndexOf(separate)
subDD=INDate.substr(area+1,INDate.length-area-1)
if(eval(subDD)<10){subDD="0"+eval(subDD)}
NewDate=subYY+"-"+subMM+"-"+subDD
if(NewDate.length!=10){return true;}
if(NewDate.substr(4,1)!="-"){return true;}
if(NewDate.substr(7,1)!="-"){return true;}
if(NewDate.substr(5,2)>"12"){return true;}
if(NewDate.substr(8,2)>"31"){return true;}
return false;}
</script>
<script language="javascript">
<!--
function check(){
if(form1.time.value!=''){
if(CheckDate(form1.time.value)){
alert("您输入时间有误，请重新输入！");
return false;
}
}
if(form1.name.value==''){
alert("请选择用户名称");
return false;
}
return true;
}
-->
</script>
<script language="javascript">
function chg1(company){
var company=document.form1.company.value;
var branch=document.form1.branch.value;
var url='psserach.jsp?company='+company+'&branch='+branch;
location.href=url;
}
</script>
<body>
<%
Str str1=new Str();
String company=str1.toChinese(request.getParameter("company"));
String branch=str1.toChinese(request.getParameter("branch"));
%>
<br>
<img src="../../images/Manual41.gif" width="16" height="16">工作记录查询
<hr size=1>
<table width="100%" border=1 cellpadding=0 cellspacing=0 bgcolor="#ffffff" bordercolordark="#ECECF2" bordercolorlight="#FFFFFF">
<form action="psserres.jsp" method="post" name="form1" target="bottomFrame" onsubmit="return check();">
<tr>
<td height="24" align="center">公司名称</td>
<td height="24" bgcolor="#FFFFFF"><select name="company" size="1" class="wenbenkuang" onChange="return chg1(this.value);">
<option selected>—请选择—</option>
<%
Condata con=new Condata();
Connection conn=con.getConnection();
String sql="select * from tb_company";
ResultSet rs=con.executeQuery(sql);
int temp=0;
while(rs.next()){
int companyid=rs.getInt(1);
String str=rs.getString(2);
if(company.equals(str)){
out.println("<option value="+str+" selected>"+str+"</option>");
temp=companyid;
}else{
out.println("<option value="+str+">"+str+"</option>");
}
}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
</select></td>
</tr>
<tr>
<td height="24" align="center">部门名称</td>
<td height="24" bgcolor="#FFFFFF">
<SELECT name="branch" size="1" class="wenbenkuang" onChange="return chg1(this.value);">
<option selected>—请选择—</option>
<%
Condata con1=new Condata();
Connection conn1=con1.getConnection();
String sq="select * from tb_branch where BranchId='"+temp+"'";
ResultSet rss=con1.executeQuery(sq);
int branchid=0;
while(rss.next()){
int id=rss.getInt(1);
String tem=rss.getString(3);
if(branch.equals(tem)){
out.println("<option value="+tem+" selected>"+tem+"</option>");
branchid=id;
}else{
out.println("<option value="+tem+">"+tem+"</option>");
}
}
try{
conn1.close();
conn1=null;
}catch(Exception e){
}
try{
con1.close();
con1=null;
}catch(Exception e){
}
%>
</SELECT>
</td>
</tr>
<tr>
<td height="24" align="center"><div align="center">员工名称</div></td>
<td height="24" bgcolor="#FFFFFF">
<select name="name" class="wenbenkuang">
<option selected>—请选择—</option>
<%
Condata con12=new Condata();
Connection conn12=con12.getConnection();
String sql1="select * from tb_person where BranchId='"+branchid+"'and Popdeom='"+1+"'";
ResultSet rst=con12.executeQuery(sql1);
while(rst.next()){
String tt=rst.getString(3);
out.println("<option value="+tt+">"+tt+"</option>");
}
try{
conn12.close();
conn12=null;
}catch(Exception e){
}
try{
con12.close();
con12=null;
}catch(Exception e){
}
%>
</select>
</td>
</tr>
<tr>
<td height="24" align="center"><div align="center">日志类型</div></td>
<td height="24" bgcolor="#FFFFFF">
<SELECT name="state" size="1" class="wenbenkuang">
<option value="0" selected>日工作总结</option>
<option value="1">周工作总结</option>
<option value="2">月工作总结</option>
</SELECT>
</td>
</tr>
<tr>
<td height="24" align="center"><div align="center">时间</div></td>
<td height="24" bgcolor="#FFFFFF"><input name="time" type="text" class="txt_grey" size="9" ></td>
</tr>
<tr>
<td height="24" align="center"><div align="center">完成情况</div></td><td height="24" bgcolor="#FFFFFF">
<input name="over" type="radio" value="0" >
按计划完成
<input name="over" type="radio" value="1">
提前完成
<input name="over" type="radio" value="2">
落后完成
<input name="over" type="radio" value="">
无</td>
</tr>
<tr align="center" bgcolor="#ECECF2">
<td height="28" colspan="2"><input name="Submit" type="submit" class="btn_grey" onClick="return check()" value="开始查询"></td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -