📄 worked.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.zh.conpool.Condata"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.bwm.string.Str"%>
<%
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,"row114");
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 CheckDatess(INDate)
{ if (INDate=="")
{return true;}
subYY=INDate.substr(0,4)
if(isNaN(subYY)){
return true;
}
//转换月份
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(isNaN(subMM)){
return true;
}
if(subMM.length<2){subMM="0"+subMM}
//转换日
area=INDate.lastIndexOf(separate)
subDD=INDate.substr(area+1,INDate.length-area-1)
if(isNaN(subDD)){
return true;
}
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 chg2(company){
var company=document.form1.company.value;
var branch=document.form1.branch.value;
var url='worked.jsp?company='+company+'&branch='+branch;
location.href=url;
}
</script>
<script language="javascript">
function check(){
if(form1.workconent.value==""){
window.alert("请填写主要内容");
return false;
}
if(form1.name.value==''){
alert("请选择用户名称");
return false;
}
if(form1.worktime.value==""){
window.alert("请填写时间安排");
return false;
}
if(form1.begtime.value==""){
window.alert("请填写起止时间")
return false;
}else{
if(CheckDatess(form1.begtime.value)){
alert("您输入的起止时间有误，请重新输入！");
return false;
}
}
if(form1.endtime.value==""){
window.alert("请填写截止时间")
return false;
}else{
if(CheckDatess(form1.endtime.value)){
alert("您输入的截止时间有误，请重新输入！");
return false;
}
}
if(form1.endtime.value < form1.begtime.value){
alert("您输入的时间区域有误！");
return false;
}
return true;
}
</script>
<body>
<br>
<form action="../new/Addworded.jsp" method="get" name="form1" target="bottomFrame" >
新工作进度
<hr size=1>
<%
Str str1=new Str();
String company=str1.toChinese(request.getParameter("company"));
String branch=str1.toChinese(request.getParameter("branch"));
%>
<table bgcolor="#ffffff" border=0 cellpadding=1 cellspacing=1>
<tr>
<td bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">公司名称</div></td>
<td bgcolor="#FFFFFF"><select name="company" size="1" onChange="return chg2(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 bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">部门名称</div></td>
<td bgcolor="#FFFFFF"><SELECT name="branch" size="1" onChange="return chg2(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 width="32" bgcolor="#EFEFEF"> </td>
<td width="78" bgcolor="#EFEFEF"><div align="center">员工名称</div></td>
<td width="433" bgcolor="#FFFFFF">
<select name="name">
<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 bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">工作内容</div></td>
<td bgcolor="#FFFFFF"><input name="workconent" type="text" size="32"></td>
</tr>
<tr>
<td bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">起止时间</div></td>
<td bgcolor="#FFFFFF"><input name="begtime" type="text" size="9" value="<%=(((new java.util.Date()).toLocaleString()).substring(0,9))%>"></td>
</tr>
<tr>
<td bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">截止时间</div></td>
<td bgcolor="#FFFFFF"><input name="endtime" type="text" size="9" value="<%=(((new java.util.Date()).toLocaleString()).substring(0,9))%>">
</td>
</tr>
<tr>
<td bgcolor="#EFEFEF"> </td>
<td bgcolor="#EFEFEF"><div align="center">时间安排</div></td>
<td bgcolor="#FFFFFF" colspan=4><textarea name="worktime" cols="60" rows="10" >详细计划安排</textarea></td>
</tr>
</table>
<input type="submit" name="Submit" value=" 提 交 " onClick="return check()">
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -