📄 gz_edit.jsp
字号:
if(xm.equals("0")){out.print("请您选择员工姓名");}
else
{ //int jcny=0,gl=0;
// float gll=0;
condition="select * from BZGZ where XM='"+xm+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{all++;}
if(all>0)
{ out.print("共找到");out.print(all);out.print("条记录");
if(all<=pagecount){pageall=1;}
else
{ int lastcount=0;
lastcount=all%pagecount;
if(lastcount==0){pageall=all/pagecount;}
else{pageall=all/pagecount+1;}
}
%>
<%if(pageall>1){%>
</p>
<table width="254" border="0">
<tr class="f1">
<td width="248" align="center">
<form action="gz_edit.jsp" method="post">
<div align="center">
跳转到
<select name="pageNO">
<%for(i=1;i<=pageall;i++){%>
<option value="<%=i%>">第<%=i%>页</option>
<%}%>
</select>
<input name="确定" type="submit" value="确定">
<input name="xm" type="hidden" id="xm" value="<%=xm%>">
</div>
</form>
</td>
</tr></table>
<%}%>
<div align="center" class="f1">
第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="gz_edit.jsp?pageNO=<%=page_send%>&xm=<%=xm%>">第一页</a>
<%}%>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<a href="gz_edit.jsp?pageNO=<%=page_send%>&xm=<%=xm%>">上一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<a href="gz_edit.jsp?pageNO=<%=page_send%>&xm=<%=xm%>">下一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<a href="gz_edit.jsp?pageNO=<%=page_send%>&xm=<%=xm%>">最末页</a>
<%}%>
共<%=pageall%>页</div>
<%
//condition="select BZGZ.BH,BZGZ.XM,BZGZ.BM,BZGZ.GZ,BZGZ.JCNY,BZGZ.GT,BZGZ.SYY,BZGZ.SL,BZGZ.LQ,BZGZ.CS,BZGZ.JT,BZGZ.LFDG,BZGZ.LT,BZGZ.FT,BZGZ.DWT,BZGZ.ZYB,BZGZ.GWX,BZGZ.BJ,BZGZ.BX,BZGZ.YB,BZGZ.WS,BZGZ.SB,BZGZ.JIAOTONG,BZGZ.FANGTIE,BZGZ.MT,BZGZ.ZFT,BZGZ.GZBT,BZGZ.YW,BZGZ.FZ,BZGZ.ST,BZGZ.BT,BZGZ.KFZ,BZGZ.KHF,BZGZ.KGJJ,BZGZ.WJ,BZGZ.QT from ZGXX,BZGZ where BZGZ.XM='"+xm+"'and ZGXX.BH=BZGZ.BH";
condition="select * from BZGZ where XM='"+xm+"'";
rs=conn.executeQuery(condition);
for(i=0;i<(pageNO_c-1)*pagecount;i++){rs.next();}
for(i=0;i<pagecount;i++)
{ if(!rs.next()){break;}
/*jcny=Integer.parseInt(rs.getString("jnyr"));
gll=(dayy-jcny)/10000;
gl=(int)gll;
float CS=Float.parseFloat(rs.getString("CS"));
float JT=Float.parseFloat(rs.getString("JT"));
float LFDG=Float.parseFloat(rs.getString("LFDG"));
float LT=Float.parseFloat(rs.getString("LT"));
float FT=Float.parseFloat(rs.getString("FT"));
float DWT=Float.parseFloat(rs.getString("DWT"));
float ZYB=Float.parseFloat(rs.getString("ZYB"));
float GWX=Float.parseFloat(rs.getString("GWX"));
float BJ=Float.parseFloat(rs.getString("BJ"));
float BX=Float.parseFloat(rs.getString("BX"));
float YB=Float.parseFloat(rs.getString("YB"));
float WS=Float.parseFloat(rs.getString("WS"));
float SB=Float.parseFloat(rs.getString("SB"));
float JIAOTONG=Float.parseFloat(rs.getString("JIAOTONG"));
float FANGTIE=Float.parseFloat(rs.getString("FANGTIE"));
float MT=Float.parseFloat(rs.getString("MT"));
float ZFT=Float.parseFloat(rs.getString("ZFT"));
float YW=Float.parseFloat(rs.getString("YW"));
float FZ=Float.parseFloat(rs.getString("FZ"));
float ST=Float.parseFloat(rs.getString("ST"));
float BT=Float.parseFloat(rs.getString("BT"));
float KFZ=Float.parseFloat(rs.getString("KFZ"));
float KHF=Float.parseFloat(rs.getString("KHF"));
float KGJJ=Float.parseFloat(rs.getString("KGJJ"));
float WJ=Float.parseFloat(rs.getString("WJ"));
float QT=Float.parseFloat(rs.getString("QT"));
float GZ=Float.parseFloat(rs.getString("GZ"));
float SYY=Float.parseFloat(rs.getString("SYY"));
float GT=Float.parseFloat(rs.getString("GT"));
float GZBT=Float.parseFloat(rs.getString("GZBT"));
float SL=Float.parseFloat(rs.getString("SL"));
int INRGZ=(int)Math.round(GZ*100/GT);
float RGZ=(float)INRGZ/100;
int ICJ=(int)Math.round(GZ*100/(GT*8));
float CJ=(float)ICJ/100;
float CZ=CS*CJ;
float JZ=JT*RGZ;
float KQQ=ST*RGZ;
int KBJJ=0;
if(gl>8){}
else{
KBJJ=(int)Math.round(BT*RGZ*60);}
float KBJ=(float)KBJJ/100;
float ZBT=LFDG+LT+FT+ZFT+DWT+ZYB+GWX+BJ+YW+FANGTIE+JIAOTONG+SB+MT+WS+YB;
float ZGZ=GZ+GZBT;
if(ZGZ<1000){}
else{ZGZ=ZGZ*99/100;}
float YL=SYY+GZ+CJ+JZ+FZ+GZBT+ZBT-KQQ-KBJ-KFZ-KHF-KGJJ-WJ-BX-QT;
float YE=YL-SL;*/
%>
<form name="form2" action="gz_edit_sav.jsp?id=<%=rs.getString("BH")%>" method="post" onsubmit="return validate_BZGZbt()">
<!--<table width="800" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<th colspan="8"></th>
</tr>
<tr>
<td width="100" bgcolor="#CC99FF"><div align="center">职工编号</div></td>
<td width="100"><div align="center"></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">职工姓名</div></td>
<td width="100"><div align="center"></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">所在部门</div></td>
<td width="100"><div align="center"></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">基本工资</div></td>
<td width="100" align="center"><input name="GZ" type="text" value="" size="8" maxlength="5" onchange="onGz(this.form)">
</td>
</tr>
<tr>
<td bgcolor='#CC99FF' align="center">工龄</td>
<td align="center"></td>
<td><div align="center">进厂年月</div></td>
<td><div align="center"></div></td>
<td>工天</td>
<td><input name="GT" type="text" value="" size="8" maxlength="3" onchange="onGt(this.form)"></td>
<td>上月余</td>
<td><input name="SYY" type="text" value="" size="8" maxlength="5" onchange="onSyy(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF" align="center">应领</td>
<td align="center"></td>
<td bgcolor="#CC99FF"><div align="center">实领</div></td>
<td><div align="center">
<input name="SL" type="text" class="noborInput" size="8" maxlength="5" onchange="onSl(this.form)">
</div>
<div align="center"></div></td>
<td bgcolor="#CC99FF"><div align="center">余额</div></td>
<td><div align="center"></div></td>
<td bgcolor="#CC99FF"><div align="center">领签</div></td>
<td><div align="center"><input name="LQ" type="text" class="noborInput" value="" size="8" maxlength="5"></div></td>
</tr>
</table>-->
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<th colspan="8" scope="col">第<%=rs.getString("BH")%>号职工工资信息表</th>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">职工编号</div></td>
<td width="75"><%=rs.getString("BH")%></td>
<td bgcolor="#CC99FF"><div align="center">职工姓名</div></td>
<td width="75"><%=rs.getString("XM")%></td>
<td bgcolor="#CC99FF"><div align="center">所在部门</div></td>
<td width="75"><%=rs.getString("BM")%></td>
<td bgcolor="#CC99FF"><div align="center">基本工资</div></td>
<td><input name="GZ" type="text" class="noborInput" value=<%=rs.getString("GZ")%> size="8" maxlength="3" onchange="onGz(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">工龄</div></td>
<td><%=rs.getString("GL")%></td>
<td bgcolor="#CC99FF"><div align="center">进厂年月</div></td>
<td><%=rs.getDate("JCNY")%></td>
<td bgcolor="#CC99FF"><div align="center">工天</div></td>
<td><input name="GT" type="text" class="noborInput" value=<%=rs.getString("GT")%> size="8" maxlength="3" onchange="onGt(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">上月余</div></td>
<td width="75"><input name="SYY" type="text" class="noborInput" value=<%=rs.getString("SYY")%> size="8" maxlength="3" onchange="onSyy(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">应领</div></td>
<td><%=rs.getString("YL")%></td>
<td bgcolor="#CC99FF"><div align="center">实领</div></td>
<td><input name="SL" type="text" class="noborInput" value=<%=rs.getString("SL")%> size="8" maxlength="3" onchange="onSl(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">余额</div></td>
<td><%=rs.getString("YE")%></td>
<td bgcolor="#CC99FF"><div align="center">领签</div></td>
<td><input name="LQ" type="text" class="noborInput" value=<%=rs.getString("LQ")%> size="8" maxlength="3" onchange="onLq(this.form)"></td>
</tr>
</table>
<p> </p>
</div>
<table width="800" height="150" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CC66FF" class="f1">
<tr>
<th colspan="12" bgcolor="#CC99FF" scope="col"><%=rs.getString("XM")%> 工资明细表</th>
</tr>
<tr>
<td width="76" bgcolor="#CC99FF"><div align="center">超时</div></td>
<td width="59"><input name="CS" type="text" class="noborInput" value=<%=rs.getString("CS")%> size="8" maxlength="3" onchange="onCs(this.form)">
</td>
<td width="56" bgcolor="#CC99FF"><div align="center">超价</div></td>
<td width="65" bgcolor="#CCCCCC"><%=rs.getString("CJ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">超资</div></td>
<td width="65" bgcolor="#CCCCCC"><%=rs.getString("CZ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">加天</div></td>
<td width="65">
<input name="JT" type="text" class="noborInput" value=<%=rs.getString("JT")%> size="8" maxlength="3" onchange="onJt(this.form)"></td>
<td width="63" bgcolor="#CC99FF"><div align="center">日工资</div></td>
<td width="65" bgcolor="#CCCCCC"><%=rs.getString("RGZ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">加资</div></td>
<td width="69" bgcolor="#CCCCCC"><%=rs.getString("JZ")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">粮副地工</div></td>
<td><input name="LFDG" type="text" class="noborInput" value=<%=rs.getString("LFDG")%> size="8" maxlength="6" onchange="onLfdg(this.form)">
</td>
<td bgcolor="#CC99FF"><div align="center">粮贴</div></td>
<td><input name="LT" type="text" class="noborInput" value=<%=rs.getString("LT")%> size="8" maxlength="5" onchange="onLt(this.form)">
</td>
<td bgcolor="#CC99FF"><div align="center">副贴</div></td>
<td><input name="FT" type="text" class="noborInput" value=<%=rs.getString("FT")%> size="8" maxlength="5" onchange="onFt(this.form)">
</td>
<td bgcolor="#CC99FF"><div align="center">单位贴</div></td>
<td><input name="DWT" type="text" class="noborInput" value=<%=rs.getString("DWT")%> size="8" maxlength="5" onchange="onDwt(this.form)">
</td>
<td bgcolor="#CC99FF"><div align="center">中夜班</div></td>
<td><input name="ZYB" type="text" class="noborInput" value=<%=rs.getString("ZYB")%> size="8" maxlength="3" onchange="onZyb(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">岗位薪</div></td>
<td><input name="GWX" type="text" class="noborInput" value=<%=rs.getString("GWX")%> size="8" maxlength="5" onchange="onGwx(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">保健</div></td>
<td><input name="BJ" type="text" class="noborInput" value=<%=rs.getString("BJ")%> size="8" maxlength="5" onchange="onBj(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">保险</div></td>
<td><input name="BX" type="text" class="noborInput" value=<%=rs.getString("BX")%> size="8" maxlength="4" onchange="onBx(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">药补</div></td>
<td><input name="YB" type="text" class="noborInput" value=<%=rs.getString("YB")%> size="8" maxlength="5" onchange="onYb(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">卫生</div></td>
<td><input name="WS" type="text" class="noborInput" value=<%=rs.getString("WS")%> size="8" maxlength="5" onchange="onWs(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">书报</div></td>
<td><input name="SB" type="text" class="noborInput" value=<%=rs.getString("SB")%> size="8" maxlength="5" onchange="onSb(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">交通</div></td>
<td><input name="JIAOTONG" type="text" class="noborInput" value=<%=rs.getString("JIAOTONG")%> size="8" maxlength="5" onchange="onJiaotong(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">房贴</div></td>
<td><input name="FANGTIE" type="text" class="noborInput" value=<%=rs.getString("FANGTIE")%> size="8" maxlength="5" onchange="onFangtie(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">煤贴</div></td>
<td><input name="MT" type="text" class="noborInput" value=<%=rs.getString("MT")%> size="8" maxlength="5" onchange="onMt(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">政府贴</div></td>
<td><input name="ZFT" type="text" class="noborInput" value=<%=rs.getString("ZFT")%> size="8" maxlength="5" onchange="onZft(this.form)">
</td>
<td bgcolor="#CC99FF"><div align="center">工资贴</div></td>
<td><input name="GZBT" type="text" class="noborInput" value=<%=rs.getString("GZBT")%> size="8" maxlength="7" onchange="onGzbt(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">业务</div></td>
<td><input name="YW" type="text" class="noborInput" value=<%=rs.getString("YW")%> size="8" maxlength="5" onchange="onYw(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">浮资</div></td>
<td><input name="FZ" type="text" class="noborInput" value=<%=rs.getString("FZ")%> size="8" maxlength="3" onchange="onFz(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">事天</div></td>
<td><input name="ST" type="text" class="noborInput" value=<%=rs.getString("ST")%> size="8" maxlength="3" onchange="onSt(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">病天</div></td>
<td><input name="BT" type="text" class="noborInput" value=<%=rs.getString("BT")%> size="8" maxlength="3" onchange="onBt(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">扣缺勤</div></td>
<td><%=rs.getString("KQQ")%></td>
<td bgcolor="#CC99FF"><div align="center">扣病假</div></td>
<td><%=rs.getString("KBJ")%></td>
<td bgcolor="#CC99FF"><div align="center">房租</div></td>
<td><input name="KFZ" type="text" class="noborInput" value=<%=rs.getString("KFZ")%> size="8" maxlength="5" onchange="onKfz(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">会费</div></td>
<td><input name="KHF" type="text" class="noborInput" value=<%=rs.getString("KHF")%> size="8" maxlength="5" onchange="onKhf(this.form)"></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">扣公积金</div></td>
<td><input name="KGJJ" type="text" class="noborInput" value=<%=rs.getString("KGJJ")%> size="8" maxlength="6" onchange="onKgjj(this.form)"></td>
<td bgcolor="#CC99FF"><div align="center">违纪</div></td>
<td><input name="WJ" type="text" class="noborInput" value=<%=rs.getString("WJ")%> size="8" maxlength="5" onchange="onWj(this.form)"></td>
<td bgcolor="#CC99FF"> 其他</td>
<td><input name="QT" type="text" class="noborInput" value=<%=rs.getString("QT")%> size="8" maxlength="5" onchange="onQt(this.form)"></td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
</tr>
</table>
<p>
<div align="center"> <input name="Submit2" type="submit" class="buttonface" value="提交">
<input name="Submit3" type="button" class="buttonface" onclick="location.href='gz_edit.jsp?xm=<%=rs.getString("XM")%>';" value="刷新">
</p>
<p class="f1"> 注：如误填而又忘了原值请按刷新放弃你所作的修改</p>
</div>
</form>
<div align="center">
<%
}
}
else
{ if(all==0 && !xm.equals("")){out.print("数据库中没有这个员工的信息");}
if(all<0){out.print("系统错误！请关闭网页重新登入！如有疑问请与软件开发商联系！");}
}
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -