📄 gz_edit_sav.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>修改成功</title>
<style>
<!--
a {text-decoration: none}
.f1 { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2 { font-size: 8pt; font-family: Verdana; line-height: 12pt }
body {
background-image: url(../img/bg4.gif);
}
input.noborInput{background:#ffffff; border-bottom-width:0px;border-top-width:0px;border-left-width:0px;border-right-width:0px; solid #ff6633; COLOR: #3300FF; FONT-SIZE: 10pt}
input.smallInput{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}
input.buttonface{BACKGROUND: #CCCCFF; border:1 solid #CC33FF; COLOR: #CC00FF; FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal}
.style1 {
font-family: Verdana;
color: #3333FF;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%
ResultSet rs=null;
int dayy=0;
String condition="select to_char(sysdate,'yyyymmdd') nyr from dual";
rs=conn.executeQuery(condition);
while(rs.next())
{dayy=Integer.parseInt(rs.getString("nyr"));}
%>
<% String bh=request.getParameter("id");
if(bh==null)
{response.sendRedirect("gz_edit.jsp");}
else
{ byte a[]=bh.getBytes("ISO-8859-1");
bh=new String(a);
int jcny=0,gl=0;
float gll=0;
String lq=request.getParameter("LQ");
if(lq==null){lq="";}
else{
byte l[]=lq.getBytes("ISO-8859-1");
lq=new String(l);}
float CS=Float.parseFloat(request.getParameter("CS"));
float JT=Float.parseFloat(request.getParameter("JT"));
float LFDG=Float.parseFloat(request.getParameter("LFDG"));
float LT=Float.parseFloat(request.getParameter("LT"));
float FT=Float.parseFloat(request.getParameter("FT"));
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 BX=Float.parseFloat(request.getParameter("BX"));
float YB=Float.parseFloat(request.getParameter("YB"));
float WS=Float.parseFloat(request.getParameter("WS"));
float SB=Float.parseFloat(request.getParameter("SB"));
float JIAOTONG=Float.parseFloat(request.getParameter("JIAOTONG"));
float FANGTIE=Float.parseFloat(request.getParameter("FANGTIE"));
float MT=Float.parseFloat(request.getParameter("MT"));
float ZFT=Float.parseFloat(request.getParameter("ZFT"));
float YW=Float.parseFloat(request.getParameter("YW"));
float FZ=Float.parseFloat(request.getParameter("FZ"));
float ST=Float.parseFloat(request.getParameter("ST"));
float BT=Float.parseFloat(request.getParameter("BT"));
//float KQQ=Float.parseFloat(request.getParameter("KQQ"));
//float KBJ=Float.parseFloat(request.getParameter("KBJ"));
float KFZ=Float.parseFloat(request.getParameter("KFZ"));
float KHF=Float.parseFloat(request.getParameter("KHF"));
float KGJJ=Float.parseFloat(request.getParameter("KGJJ"));
float WJ=Float.parseFloat(request.getParameter("WJ"));
float QT=Float.parseFloat(request.getParameter("QT"));
float GZ=Float.parseFloat(request.getParameter("GZ"));
float SYY=Float.parseFloat(request.getParameter("SYY"));
float GT=Float.parseFloat(request.getParameter("GT"));
float GZBT=Float.parseFloat(request.getParameter("GZBT"));
float SL=Float.parseFloat(request.getParameter("SL"));
condition="select to_char(CJGZSJ,'yyyymmdd') jnyr from zgxx where BH='"+bh+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{jcny=Integer.parseInt(rs.getString("jnyr"));
}
gll=(dayy-jcny)/10000;
gl=(int)gll;
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;
condition="update BZGZ set GZBT="+GZBT+",GT="+GT+",CS="+CS+",CJ="+CJ+",CZ="+CZ+",JT="+JT+",JZ="+JZ+",FZ="+FZ+",ST="+ST+",BT="+BT+",KQQ="+KQQ+",KBJ="+KBJ+",LFDG="+LFDG+",LT="+LT+",FT="+FT+",ZFT="+ZFT+",DWT="+DWT+",ZYB="+ZYB+",GWX="+GWX+",BJ="+BJ+",BX="+BX+",YW="+YW+",FANGTIE="+FANGTIE+",JIAOTONG="+JIAOTONG+",SB="+SB+",MT="+MT+",WS="+WS+",YB="+YB+",KFZ="+KFZ+",KHF="+KHF+",KGJJ="+KGJJ+",WJ="+WJ+",YE="+YE+",YL="+YL+",SL="+SL+",LQ='"+lq+"',QT="+QT+" where BH='"+bh+"'";
//out.print(condition);
conn.executeUpdate(condition);
}
%>
<div align="center">
<p class="f1 style1">修改记录后的表</p>
<%String bh2=request.getParameter("id");
byte b[]=bh2.getBytes("ISO-8859-1");
bh2=new String(b);
condition="SELECT * FROM BZGZ where BH="+"'"+bh2+"'";
rs=conn.executeQuery(condition);
while(rs.next())
{ %>
<table width="800" height="100" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CC66FF" class="f1">
<tr bgcolor="#CC99FF">
<th colspan="8" scope="col">第<%=rs.getString("BH")%>号职工工资信息表</th>
</tr>
<tr>
<td width="100" bgcolor="#CC99FF"><div align="center">职工编号</div></td>
<td width="100"><div align="center"><%=rs.getString("BH")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">职工姓名</div></td>
<td width="100"><div align="center"><%=rs.getString("XM")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">所在部门</div></td>
<td width="100"><div align="center"><%=rs.getString("BM")%></div></td>
<td width="100" bgcolor="#CC99FF"><div align="center">基本工资</div></td>
<td width="100"><div align="center"><%=rs.getString("GZ")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">工龄</div></td>
<td><div align="center"><%=rs.getString("GL")%></div></td>
<td bgcolor="#CC99FF"><div align="center">进厂年月</div></td>
<td><div align="center"><%=rs.getDate("JCNY")%></div></td>
<td bgcolor="#CC99FF"><div align="center">工天</div></td>
<td><div align="center"><%=rs.getString("GT")%></div></td>
<td bgcolor="#CC99FF"><div align="center">上月余</div></td>
<td><div align="center"><%=rs.getString("SYY")%></div></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">应领</div></td>
<td><div align="center"><%=rs.getString("YL")%></div></td>
<td bgcolor="#CC99FF"><div align="center">实领</div></td>
<td><div align="center"><%=rs.getString("SL")%></div></td>
<td bgcolor="#CC99FF"><div align="center">余额</div></td>
<td><div align="center"><%=rs.getString("YE")%></div></td>
<td bgcolor="#CC99FF"><div align="center">领签</div></td>
<td><div align="center"><%=rs.getString("LQ")%></div></td>
</tr>
</table>
<br>
<table width="798" 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" align="center"><%=rs.getString("CS")%></td>
<td width="56" bgcolor="#CC99FF"><div align="center">超价</div></td>
<td width="65" align="center"><%=rs.getString("CJ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">超资</div></td>
<td width="65" align="center"><%=rs.getString("CZ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">加天</div></td>
<td width="65"align="center"><%=rs.getString("JT")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">日工资</div></td>
<td width="65" align="center"><%=rs.getString("RGZ")%></td>
<td width="63" bgcolor="#CC99FF"><div align="center">加资</div></td>
<td width="69" align="center"><%=rs.getString("JZ")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">粮副地工</div></td>
<td align="center"><%=rs.getString("LFDG")%></td>
<td bgcolor="#CC99FF"><div align="center">粮贴</div></td>
<td align="center"><%=rs.getString("LT")%></td>
<td bgcolor="#CC99FF"><div align="center">副贴</div></td>
<td align="center"><%=rs.getString("FT")%></td>
<td bgcolor="#CC99FF"><div align="center">单位贴</div></td>
<td align="center"><%=rs.getString("DWT")%></td>
<td bgcolor="#CC99FF"><div align="center">中夜班</div></td>
<td align="center"><%=rs.getString("ZYB")%></td>
<td bgcolor="#CC99FF"><div align="center">岗位薪</div></td>
<td align="center"><%=rs.getString("GWX")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">保健</div></td>
<td align="center"><%=rs.getString("BJ")%></td>
<td bgcolor="#CC99FF"><div align="center">保险</div></td>
<td align="center"><%=rs.getString("BX")%></td>
<td bgcolor="#CC99FF"><div align="center">药补</div></td>
<td align="center"><%=rs.getString("YB")%></td>
<td bgcolor="#CC99FF"><div align="center">卫生</div></td>
<td align="center"><%=rs.getString("WS")%></td>
<td bgcolor="#CC99FF"><div align="center">书报</div></td>
<td align="center"><%=rs.getString("SB")%></td>
<td bgcolor="#CC99FF"><div align="center">交通</div></td>
<td align="center"><%=rs.getString("JIAOTONG")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">房贴</div></td>
<td align="center"><%=rs.getString("FANGTIE")%></td>
<td bgcolor="#CC99FF"><div align="center">煤贴</div></td>
<td align="center"><%=rs.getString("MT")%></td>
<td bgcolor="#CC99FF"><div align="center">政府贴</div></td>
<td align="center"><%=rs.getString("ZFT")%></td>
<td bgcolor="#CC99FF"><div align="center">工资贴</div></td>
<td align="center"><%=rs.getString("GZBT")%></td>
<td bgcolor="#CC99FF"><div align="center">业务</div></td>
<td align="center"><%=rs.getString("YW")%></td>
<td bgcolor="#CC99FF"><div align="center">浮资</div></td>
<td align="center"><%=rs.getString("FZ")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">事天</div></td>
<td align="center"><%=rs.getString("ST")%></td>
<td bgcolor="#CC99FF"><div align="center">病天</div></td>
<td align="center"><%=rs.getString("BT")%></td>
<td bgcolor="#CC99FF"><div align="center">扣缺勤</div></td>
<td align="center"><%=rs.getString("KQQ")%></td>
<td bgcolor="#CC99FF"><div align="center">扣病假</div></td>
<td align="center"><%=rs.getString("KBJ")%></td>
<td bgcolor="#CC99FF"><div align="center">房租</div></td>
<td align="center"><%=rs.getString("KFZ")%></td>
<td bgcolor="#CC99FF"><div align="center">会费</div></td>
<td align="center"><%=rs.getString("KHF")%></td>
</tr>
<tr>
<td bgcolor="#CC99FF"><div align="center">扣公积金</div></td>
<td align="center"><%=rs.getString("KGJJ")%></td>
<td bgcolor="#CC99FF"><div align="center">违纪</div></td>
<td align="center"><%=rs.getString("WJ")%></td>
<td bgcolor="#CC99FF"> 其他</td>
<td align="center"><%=rs.getString("QT")%></td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
<td bgcolor="#CC99FF"> </td>
<td> </td>
</tr>
</table>
<%}%>
<p class="f1"><input name="back" type="button" class="buttonface" onClick="javascript:history.go(-1);" value="返回">
<input name="back" type="button" class="buttonface" onClick="location.href='../index/gz_index.jsp';" value="退出">
</p>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -