📄 gz_qtxg.jsp
字号:
function onDwt(form){
var strs=form.dwt.value;
if( !isAllNumber(strs)){
form.dwt.value="";
alert("请输入正确的数据--数字！");
form.dwt.focus();
}
}
function isAllNumber(str)
{
var test=true;
var i=str.length;
var staus;//staus用于记录.的个数
status=0;
//当最后一位为.时出错
if (str.charAt(i-1)=='.')
{
//alert("无效数字！.");
test=false;
return test;
}
for (j=0;j<i;j++)
{
if (str.charAt(j)=='.')
{
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"/>
<%--
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");}
}
--%>
<div align="center">当月全体员工修改页面
<%String meb=response.encodeURL("gz_qtxg.jsp");
String condition=null;
ResultSet rs=null;
%>
</div>
<form name="form1" method="post" action="<%=meb%>" onsubmit="return validate_zc()">
<div align="center">
<p>
请选择企业员工的职称：
<select name="zc" id="select">
<option value="0" selected>请选择企业员工的职称查询</option>
<%
rs=conn.executeQuery("select distinct ZGXX.ZC from ZGXX");
while(rs.next())
{
%>
<option value="<%=rs.getString("ZC")%>"><%=rs.getString("ZC")%></option>
<%
}
%>
</select><BR><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 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+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{i++;}
String tmp_bh[]=new String[i];
condition="select bh from zgxx where zc='"+zc2+"'";
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]+"'");
}
}
%>
<%
String zc=request.getParameter("zc");
if(zc==null){zc="";}
byte b[]=zc.getBytes("ISO-8859-1");
zc=new String(b);
int flag=0;
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.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%>?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">职称为<%=zc%>的各种补贴信息</div></td>
</tr>
<tr>
<td width="94" height="20" bgcolor="#D2A3FF"><div align="left" class="style4"><span class="style1"> 粮副地工：</span></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"><span class="style1"> 粮贴：</span></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"><span class="style1"> 副贴：</span></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"><span class="style1"> 政府贴：</span></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"><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"><span class="style5">岗位: </span></div></td>
<td height="20"><input name="gwx" type="text" id="gwx" onchange="onGwx(this.form)" value=<%=rs.getFloat("GWX")%> size="10" maxlength="6"></td>
<td height="20" bgcolor="#D2A3FF"><div align="left"><span class="style5">卫生：</span></div></td>
<td height="20"> <input name="ws" type="text" id="ws" onchange="onWs(this.form)" value="<%=rs.getFloat("WS")%>" size="10" maxlength="6"></td>
<td height="20" bgcolor="#D2A3FF" class="style5"> </td>
<td height="20"> <input name="xg" type="submit" id="xg" 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 + -