📄 gz_bmxg.jsp
字号:
{
status++;
}
if (status>1)
{
//alert("无效数字！.");
test=false;
return test;
}
if (str.charAt(j)<'0' || str.charAt(j)>'9' )
{
if (str.charAt(j)!='.')
{
//alert("无效数字！.");
test=false;
return test;
}
}
}
return test;
}
</script>
</head>
<body>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<div align="center">当月部门员工修改页面
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!(page_type.equals("super")) && !page_type.equals("sgz"))
{response.sendRedirect("../index.jsp");}
}
%>
<%String meb=response.encodeURL("gz_bmxg.jsp");%>
</div>
<form name="form1" method="post" action="<%=meb%>" onsubmit="return validate_zc()">
<div align="center">
<p>请选择企业员工的部门：
<select name="bm" id="select" onChange="MM_jumpMenu('parent',this,0)">
<option value="0" selected>请选择企业员工的部门查询</option>
<%
ResultSet rs=null;
String condition="select * from BM";
rs=conn.executeQuery(condition);
while(rs.next())
{
%>
<option value="<%=rs.getString("BM")%>"><%=rs.getString("BM")%></option>
<%
}
%>
</select><BR>
<% String bm=request.getParameter("bm");
if(bm==null){bm="";}
byte b[]=bm.getBytes("ISO-8859-1");
bm=new String(b);
condition="select distinct ZGXX.ZC from ZGXX WHERE ZGXX.BM='"+bm+"'";
rs=conn.executeQuery(condition);
%>
请选择企业员工的职称：
<select name="zc" id="select">
<option value="0">请选择<%=bm%>员工的职称查询</option>
<%
while(rs.next())
{
%>
<option value="<%=rs.getString("ZC")%>"><%=rs.getString("ZC")%></option>
<%
}
%>
</select>
</p>
<p>
<input type="hidden" name="bmm" value=<%=bm%> >
<BR>
<input type="submit" name="Submit" value="提交">
<input type="button" name="back" onClick="location.href='../index/gz_index.jsp';" value="退出">
</p>
</div>
</form>
<div align="center">
<%
if (request.getParameter("flag")==null) {}
else
{//String bm2=conn.toChinese(request.getParameter("bm"));
// String zc2=conn.toChinese(request.getParameter("zc"));
String bm2=request.getParameter("bmm");
if(bm2==null){bm2="";}
byte c[]=bm2.getBytes("ISO-8859-1");
bm2=new String(c);
String zc2=request.getParameter("zc");
if(zc2==null){zc2="";}
byte d[]=zc2.getBytes("ISO-8859-1");
zc2=new String(d);
//String lfdg2=conn.toChinese(request.getParameter("lfdg"));
// Float lfdg=Float.valueOf(lfdg2);
float lfdg=Float.parseFloat(request.getParameter("lfdg"));
float lt=Float.parseFloat(request.getParameter("lt"));
float ft=Float.parseFloat(request.getParameter("ft"));
float zft=Float.parseFloat(request.getParameter("zft"));
float dwt=Float.parseFloat(request.getParameter("dwt"));
float zyb=Float.parseFloat(request.getParameter("zyb"));
float gwx=Float.parseFloat(request.getParameter("gwx"));
float bj=Float.parseFloat(request.getParameter("bj"));
float yw=Float.parseFloat(request.getParameter("yw"));
float fangtie=Float.parseFloat(request.getParameter("fangtie"));
float jiaotong=Float.parseFloat(request.getParameter("jiaotong"));
float sb=Float.parseFloat(request.getParameter("sb"));
float mt=Float.parseFloat(request.getParameter("mt"));
float ws=Float.parseFloat(request.getParameter("ws"));
float yb=Float.parseFloat(request.getParameter("yb"));
int i=0,j=0,k=0;
condition="select bh from zgxx where zc='"+zc2+"' and BM='"+bm2+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{i++;}
String tmp_bh[]=new String[i];
condition="select bh from zgxx where zc='"+zc2+"' and BM='"+bm2+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{
tmp_bh[j]=rs.getString("bh");
j++;
}
for(k=0;k<i;k++)
{
conn.executeUpdate("update BZGZ set LFDG='"+lfdg+"',LT='"+lt+"',FT='"+ft+"',ZFT='"+zft+"',DWT='"+dwt+"',ZYB='"+zyb+"',GWX='"+gwx+"',BJ='"+bj+"',YW='"+yw+"',FANGTIE='"+fangtie+"',JIAOTONG='"+jiaotong+"',SB='"+sb+"',MT='"+mt+"',WS='"+ws+"',YB='"+yb+"' where bh='"+tmp_bh[k]+"'");
}
}
//rs.refreshRow();
//}catch(Exception e) {out.print("更新错误！");}
%>
<%
String bm3=request.getParameter("bmm");
if(bm3==null){bm3="";}
byte a[]=bm3.getBytes("ISO-8859-1");
bm3=new String(a);
String zc=request.getParameter("zc");
if(zc==null){zc="";}
byte s[]=zc.getBytes("ISO-8859-1");
zc=new String(s);
int flag=0;
if(bm3.equals("")){}
else{
if(zc.equals("")){}
else
{
condition="select distinct BZGZ.LFDG,BZGZ.LT,BZGZ.FT,BZGZ.ZFT,BZGZ.DWT,BZGZ.ZYB,BZGZ.GWX,BZGZ.BJ,BZGZ.YW,BZGZ.FANGTIE,BZGZ.JIAOTONG,BZGZ.SB,BZGZ.MT,BZGZ.WS,BZGZ.YB from ZGXX,BZGZ where ZGXX.ZC='"+zc+"' and ZGXX.BM='"+bm3+"' and ZGXX.BH=BZGZ.BH";
rs=conn.executeQuery(condition);
while(rs.next())
{
%>
</div>
<hr align="center" width="1000">
<div align="center">
<form name="form2" method="post" action="<%=meb%>?bmm=<%=bm3%>&zc=<%=zc%>&flag=1" onsubmit="return validate_BZGZbt()">
<table width="570" border="1" align="center" cellspacing="1" bordercolor="#D2A3FF">
<tr bgcolor="#D2A3FF">
<td height="30" colspan="6"><div align="center" class="style2"><%=bm3%>职称为<%=zc%>的各种补贴信息</div></td>
</tr>
<tr>
<td width="94" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"></div>
<div align="left" class="style4"></div>
<div align="left" class="style4">
<div align="left" class="style5"></div>
<div align="left" class="style4"><span class="style1"> 粮副地工：</span></div>
</div></td>
<td width="110" height="20"><input name="lfdg" type="text" id="lfdg" value="<%=rs.getFloat("LFDG")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6" onchange="onLfdg(this.form)"></td>
<td width="59" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">业务： </span></div></td>
<td width="113" height="20"><input name="yw" type="text" id="yw" value="<%=rs.getFloat("YW")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onYw(this.form)"></td>
<td width="65" bgcolor="#D2A3FF" class="style5"><div align="left">药补：</div></td>
<td width="96"><input name="yb" type="text" id="yb" value="<%=rs.getFloat("YB")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onYb(this.form)"></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style4"></div>
<div align="left" class="style5">
<div align="left" class="style4"></div>
<div align="left" class="style4"><span class="style1"> 粮贴：</span></div>
</div></td>
<td width="110" height="20"><input name="lt" type="text" id="lt" value="<%=rs.getFloat("LT")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6" onchange="onLt(this.form)"></td>
<td width="59" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">房贴： </span></div></td>
<td width="113" height="20"><input name="fangtie" type="text" id="fangtie" value="<%=rs.getFloat("FANGTIE")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onFangtie(this.form)"></td>
<td width="65" height="20" bgcolor="#D2A3FF" class="style5"><div align="left"><span class="style4"><span class="style1">保健：</span></span></div></td>
<td width="96" height="20"><input name="bj" type="text" id="bj" value="<%=rs.getFloat("BJ")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onBj(this.form)"></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style4"></div>
<div align="left" class="style4">
<div align="left" class="style4"></div>
<div align="left" class="style4"><span class="style1"> 副贴：</span></div>
</div></td>
<td width="110" height="20"><input name="ft" type="text" id="ft" value="<%=rs.getFloat("FT")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onFt(this.form)"></td>
<td width="59" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">交通： </span></div></td>
<td width="113" height="20"><input name="jiaotong" type="text" id="jiaotong" value="<%=rs.getFloat("JIAOTONG")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onJiaotong(this.form)"></td>
<td width="65" height="20" bgcolor="#D2A3FF" class="style5"><div align="left">单位贴：</div></td>
<td width="96" height="20"><input name="dwt" type="text" id="dwt" value="<%=rs.getFloat("DWT")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onDwt(this.form)"></td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style4"></div>
<div align="left" class="style4">
<div align="left" class="style4"></div>
<div align="left" class="style4"><span class="style1"> 政府贴：</span></div>
</div></td>
<td width="110" height="20"><input name="zft" type="text" id="zft" value="<%=rs.getFloat("ZFT")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onZft(this.form)"></td>
<td width="59" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">书报： </span></div></td>
<td width="113" height="20"><input name="sb" type="text" id="sb" value="<%=rs.getFloat("SB")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onSb(this.form)"></td>
<td width="65" height="20" bgcolor="#D2A3FF" class="style5"><div align="left"></div></td>
<td width="96" height="20"> </td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left" class="style4"></div>
<div align="left" class="style4"><span class="style5">中夜班：</span></div></td>
<td width="110" height="20"><input name="zyb" type="text" id="zyb" value="<%=rs.getFloat("ZYB")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6" onchange="onZyb(this.form)"></td>
<td width="59" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1">煤贴： </span></div></td>
<td width="113" height="20"><input name="mt" type="text" id="mt" value="<%=rs.getFloat("MT")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onMt(this.form)"></td>
<td width="65" height="20" bgcolor="#D2A3FF" class="style5"><div align="left"></div></td>
<td width="96" height="20"> </td>
</tr>
<tr>
<td height="20" bgcolor="#D2A3FF"><div align="left"></div>
<div align="left" class="style5">
<div align="left"></div>
<div align="left" class="style5">岗位：</div>
</div></td>
<td height="20"><input name="gwx" type="text" id="gwx" value="<%=rs.getFloat("GWX")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6" onchange="onGwx(this.form)"></td>
<td height="20" bgcolor="#D2A3FF" class="style5"><div align="left">卫生：</div></td>
<td height="20"><input name="ws" type="text" id="ws" value="<%=rs.getFloat("WS")%>" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="10" maxlength="6"onchange="onWs(this.form)"></td>
<td height="20" bgcolor="#D2A3FF" class="style5"><div align="left"></div></td>
<td height="20"><input name="xg" type="submit" id="xg" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" value="提交修改" size="100" width="388"></td>
</tr>
</table>
</form>
</div>
<div align="center"></div>
<div align="center">
<hr align="center" width="1000">
<% }
}
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -