📄 rs_update_shgx.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>修改社会关系页面</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
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("srs"))
{response.sendRedirect("../index.jsp");}
}
%>
<script language="javascript">
function check_bh()
{ var true_false=true;
if(document.intobh.bh.value=="")
{ alert("请填写'所要添加家庭成员信息的职工编号！'");
true_false=false;
}
return true_false;
}
function check()
{ var true_false=true;
if(document.add.gxxm.value=="")
{ alert("请填写'关系人姓名'");
true_false=false;
}
if(document.add.ybrgx.value=="")
{ alert("请填写'与本人关系关系'");
true_false=false;
}
if(document.add.zzmm.value=="0")
{ alert("请选择'政治面目'");
true_false=false;
}
if(document.add.gzdw.value=="")
{ alert("请填写'工作单位'如果没有请填写'无'");
true_false=false;
}
if(document.add.zwgz.value=="")
{ alert("请填写'职务工种'如果没有请填写'无'");
true_false=false;
}
if(document.add.bz.value=="")
{ alert("请填写'备注'如果没有请填写'无'");
true_false=false;
}
return true_false;
}
</script>
<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 }
.style11 {
font-size: 12;
font-family: Verdana;
line-height: 15pt;
font-weight: bold;
}
.style12 {font-size: 14px}
.style14 {color: #FF66CC}
body {
background-image: url(../img/bg5.gif);
}
-->
</style>
</head>
<body>
</div>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<jsp:include page="../index/shgx_entry_menu.jsp"></jsp:include>
</jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<% String meb=response.encodeURL("rs_update_shgx.jsp");%>
<div align="center"><span class="style11">修改社会关系页面</span>
<% ResultSet rs=null;
String bh=request.getParameter("bh");
int all=0;
if(bh==null){bh="";}
else
{ String condition_bh="select * from zgxx where bh='"+bh+"'";
conn.setcondition(condition_bh);
ResultSet rs_zgxx=conn.getrs();
rs_zgxx.last();
int all_zgxx=rs_zgxx.getRow();
condition_bh="select * from txzgxx where bh='"+bh+"'";
conn.setcondition(condition_bh);
ResultSet rs_txzgxx=conn.getrs();
rs_txzgxx.last();
int all_txzgxx=rs_txzgxx.getRow();
all=all_zgxx+all_txzgxx;
if(all>1)
{out.print("<center>出现职工编号重复错误！请予管理员联系！</center>");}
else
{ if(all==0){if(bh.equals("")){out.print("<center>您还没有输入编号,请输入！</center>");}else{out.print("<center>没有编号为"+bh+"的职工,请重新填写</center>");}}
if(all==1)
{ if(all_zgxx==1){rs=rs_zgxx;}
if(all_txzgxx==1){rs=rs_txzgxx;}
}
}
}
if(bh.equals("")||all!=1)
{
%>
<form action="<%=meb%>" method="post" name="intobh" id="intobh" onSubmit="return check_bh()">
<div align="center">请填写所要修改'社会关系信息'的'职工'的编号
<input name="bh" type="text" id="bh" 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="15" maxlength="15">
<input type="submit" name="Submit3" value="确定">
</div></form>
<% }
else
{ rs.first();
String condition_shgx="select * from shgx where bh='"+bh+"'";
conn.setcondition(condition_shgx);
ResultSet rs_shgx=conn.getrs();
rs_shgx.last();
int all_shgx=rs_shgx.getRow();
if(all_shgx==0){out.print("<center>"+bh+"号"+rs.getString("XM")+"没有社会关系</center>");}
else
{ out.print("<center>找到"+bh+"号"+rs.getString("XM")+"社会关系记录共"+all_shgx+"个</center>");
String pageNO=request.getParameter("pageNO");
if(pageNO==null){pageNO="1";}
int pageNO_c=Integer.parseInt(pageNO);
int pagecount=1,pageall=0,i=0;
if(all_shgx<=pagecount){pageall=1;}
else
{ int lastcount=0;
lastcount=all_shgx%pagecount;
if(lastcount==0){pageall=all_shgx/pagecount;}
else{pageall=all_shgx/pagecount+1;}
}
rs_shgx.beforeFirst();
for(i=0;i<(pageNO_c-1)*pagecount;i++){rs_shgx.next();}
%>
<div align="center">
第<%=pageNO_c%>页
<%if(pageNO_c>1){String page_send=Integer.toString(1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">第一页</a>
<%}%>
<%if(pageNO_c>1){String page_send=Integer.toString(pageNO_c-1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">上一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageNO_c+1);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">下一页</a>
<%}%>
<%if(pageNO_c<pageall){String page_send=Integer.toString(pageall);%>
<a href="<%=meb%>?pageNO=<%=page_send%>&bh=<%=bh%>">最末页</a>
<%}%>
共<%=pageall%>页
</div>
<%for(i=0;i<pagecount;i++)
{ if(!rs_shgx.next()){break;}
%>
<form <%String meb_rs_update_shgx_sav=response.encodeURL("rs_update_shgx_sav.jsp");%>action="<%=meb_rs_update_shgx_sav%>?pageNO=<%=pageNO%>" method=post name="add" id="add" onSubmit="return check()">
<table width="331" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="63" nowrap class="style12"><div align="right"> 编号:</div></td>
<td colspan="3" nowrap><div align="left"><span class="style14"><%=rs.getString("BH")%>
<input name="bh" type="hidden" id="bh" value="<%=bh%>">
</span></div></td>
</tr>
<tr>
<td nowrap class="style12"><div align="right">姓名:</div></td>
<td colspan="3" nowrap><div align="left"><%=rs.getString("XM")%>
<input name="xm" type="hidden" id="xm" value="<%=rs.getString("XM")%>">
</div></td>
</tr>
<tr>
<td class="style12" nowrapclass="f1"><div align="right">关系姓名:</div></td>
<td colspan="3" nowrap> <div align="left">
<input name="gxxm" type="text" id="gxxm" 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="<%=rs_shgx.getString("GXXM")%>" maxlength="4">
<input name="ygxxm" type="hidden" value="<%=rs_shgx.getString("GXXM")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">本人关系:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="ybrgx" type="text" 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="<%=rs_shgx.getString("YBRGX")%>" maxlength="3">
<input name="yybrgx" type="hidden" value="<%=rs_shgx.getString("YBRGX")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">政治面貌:</div></td>
<td colspan="3" nowrap><div align="left">
<select name="zzmm" id="select22">
<option value="<%=rs_shgx.getString("ZZMM")%>" selected><%=rs_shgx.getString("ZZMM")%></option>
<option value="党员">党员</option>
<option value="团员">团员</option>
<option value="群众">群众</option>
<option value="少先队员">少先队员</option>
</select>
<input name="yzzmm" type="hidden" value="<%=rs_shgx.getString("ZZMM")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">工作单位:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="gzdw" type="text" 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="<%=rs_shgx.getString("GZDW")%>">
<input name="ygzdw" type="hidden" value="<%=rs_shgx.getString("GZDW")%>">
</div></td>
</tr>
<tr>
<td height="30" nowrap class="style12"><div align="right">职务工种:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="zwgz" type="text" 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="<%=rs_shgx.getString("ZWGZ")%>">
<input name="yzwgz" type="hidden" value="<%=rs_shgx.getString("ZWGZ")%>">
</div></td>
</tr>
<tr>
<td height="27" nowrap class="style12"><div align="right">备注:</div></td>
<td colspan="3" nowrap><div align="left">
<input name="bz" type="text" id="bz" 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="<%=rs_shgx.getString("BZ")%>">
<input name="ybz" type="hidden" id="ybz" value="<%=rs_shgx.getString("BZ")%>">
</div></td>
</tr>
<tr>
<td colspan="2" nowrap class="f1">
<div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td width="131" nowrap class="f1"><div align="center"></div></td>
<td width="98" nowrap class="f1"><div align="center">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
<br>
</center>
</form>
<% }
}
}
%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -