📄 jcy_ry_submit.jsp
字号:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" %>
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="com.jspsmart.upload.*,java.sql.*,java.util.* "%>
<%@page import = "collapsar.Cipher" %>
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires", 0);
%>
<%vststd std = new vststd();%>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<%
String currusercode = jcypurview.getUsercode(); //取当前用户usercode
String curruserid = jcypurview.getUserid(); //取当前用户编号
String currusername = jcypurview.getUserName(); //取当前用户名称
String curruserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县
String curruserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
//检测用户是否登录
if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用户已断线或未正常登录，请重新登录！")
window.open("../index.htm","_top")
</Script>
<%
return;}
%>
<%
//检测用户是否有操作权限
if (!(jcypurview.purviewVerdict("B0500001") || jcypurview.purviewVerdict("B0500002") || jcypurview.purviewVerdict("B0500003") || jcypurview.purviewVerdict("B0500004") || jcypurview.purviewVerdict("B0500010")))
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
history.go(-1);
</Script>
<% return;
}
%>
<%
String errtext = "";
String uid = std.getValue(request, "uid"); //uid
String dz = std.getValue(request, "dz"); //dz
String password = Cipher.Encrypt("888888");//添加密码
/**
*公务员新增，分为两种情况，即录入人分为市处和非市处（区县）公务员
*人员状态(ryzt)为04－未上报
*/
if (dz.equals("new")){
String usercode = std.getValue(request,"usercode").trim();//usercode
String username = std.getValue(request,"username").trim();//姓名
String sfzh = std.getValue(request,"sfzh").trim(); //身份证号
String xb = std.getValue(request,"xb"); //性别(1 男 2 女)
String mz = std.getValue(request,"mz"); //民族(代码)
String year = std.getValue(request,"year").trim();
String month= std.getValue(request,"month").trim();
String day = std.getValue(request,"day").trim();
String csrq = year+"."+month+"."+day; //出生年月
String zw = std.getValue(request,"zw"); //职务(代码)
String zbdm = std.getValue(request,"zbdm"); //组别代码
String ssbz = std.getValue(request,"ssbz"); //所属编制(代码)
String zzmm = std.getValue(request,"zzmm"); //政治面目(代码)
String whcd = std.getValue(request,"whcd"); //文化程度(代码)
String sxzy = std.getValue(request,"sxzy"); //所学专业(代码)
String zjlb = std.getValue(request,"zjlb"); //证件类别(代码)
String zjhm = std.getValue(request,"zjhm").trim(); //公务证件号码
String xphm = std.getValue(request,"xphm").trim(); //胸牌号码
String sfjd = std.getValue(request,"sfjx"); //是否街乡公务员
String gzqr = std.getValue(request,"ry_startdate"); //从事执法检查起时间
String gzzr = std.getValue(request,"ry_enddate"); //从事执法检查止时间
String ryzt = std.getValue(request,""); //人员状态(注销，减少，正常，未上报，待审核，未通过)
String zxrq = std.getValue(request,"zxrq"); //证件注销时间
String zxyy = std.getValue(request,"zxyy"); //证件注销原因
String fzjg = std.getValue(request,"fzjg").trim(); //发证机关
String lrr = curruserid; //录入人
String lrrq = std.getDateStr("YYYY.MM.DD"); //录入时间
String jddm = std.getValue(request,"jd"); //街道代码
String dwdm = std.getValue(request,"dwdm"); //单位代码
String qx_temp = std.getValue(request,"qx");
String qx = "";
if (qx_temp.length() >= 3)
qx = qx_temp.substring(0,3);
else qx = ""; //县区代码
String gzbm = std.getValue(request,"gzbm").trim(); //工作部门
String today = std.getDateStr("YYYY.MM.DD"); //当天日期
/************************判断***************************/
//判断usercode是否有汉字
boolean flag = false;
for(int i = 0; i<usercode.length(); i++)
{
if((int)(usercode.charAt(i))>255)
flag = true;
}
//判断公务起止日期
String sql_rq = "select * from dual where to_date('"+gzqr+"','yyyy.mm.dd') > to_date('"+gzzr+"','yyyy.mm.dd')";
int num_rq = std.getResultByUpdate(sql_rq);
if (username.equals(""))
errtext = "请填写姓名！";
else if (sfzh.equals(""))
errtext = "请填写身份证号码！";
else if (!std.checkNumber(sfzh))
errtext = "身份证号码必须为数字！";
else if (sfzh.length() != 15 & sfzh.length() != 18)
errtext = "请正确填写身份证号码！身份证号码长度必须为15或者18位数字！";
else if (usercode.equals(""))
errtext = "请填写公务员编号！";
else if(flag)
errtext = "公务员编号不能使用中文！";
else if (sxzy.equals(""))
errtext = "请填写所学专业！";
else if (qx.equals(""))
errtext = "请选择区县！";
else if (dwdm.equals(""))
errtext = "请选择工作单位！";
else if (fzjg.equals(""))
errtext = "请填写发证机关！";
else if (gzbm.equals(""))
errtext = "请填写工作部门！";
else if (xphm.length() != 0 && xphm.length() != 9)
errtext = "胸牌号码长度为9位，请正确填写！";
else if (zjhm.length() != 0 && zjhm.length() != 9)
errtext = "证件号码长度为9位，请正确填写！";
else if (num_rq == 1)
errtext = "请正确填写工作起止日期！";
else{
//检测sfzh与usercode是否已经存在
String sql_select_sfzh = "select count(*) from dual where exists(select 1 from jcy_ry where sfzh = '"+sfzh+"')";
String sql_select_usercode = "select count(*) from dual where exists(select 1 from jcy_ry where usercode = lower('"+usercode+"'))";
sun.jdbc.rowset.CachedRowSet crssfzh = std.getResultBySelect(sql_select_sfzh);
sun.jdbc.rowset.CachedRowSet crsuc = std.getResultBySelect(sql_select_usercode);
crssfzh.next();
crsuc.next();
String num_sfzh = crssfzh.getString(1);
String num_usercode = crsuc.getString(1);
if (!num_sfzh.equals("0"))
errtext = "此公务员已经存在！";
else if (!num_usercode.equals("0"))
errtext = "您所填写的用户名已存在，请您重新选择一个用户名！";
//如果当前录入人为市处公务员，则新录入的人员的 ryzt='03', 同时还要添加与审核成功时相同的信息
else if (curruserszqx.equals("001")){
String sql_userid = "SELECT LPAD(SEQ_USERID.NEXTVAL,20,'0') FROM DUAL";
sun.jdbc.rowset.CachedRowSet crsuserid = std.getResultBySelect(sql_userid);
crsuserid.next();
//获得userid
String userid = crsuserid.getString(1);
//添加userid
String sql_insert_ry = "insert into jcy_ry (userid) values ('"+userid+"')";
//添加人员信息
String sql_update_ry = "update jcy_ry set username='"+username+"', sfzh='"+sfzh+"', xb='"+xb+"', usercode = lower('"+usercode+"'), mz='"+mz+"', csrq=to_date('"+csrq+"','YYYY.MM.DD'), zw='"+zw+"', zbdm='"+zbdm+"', ssbz='"+ssbz+"', zzmm='"+zzmm+"', whcd='"+whcd+"', sxzy='"+sxzy+"', zjlb='"+zjlb+"', zjhm='"+zjhm+"', xphm='"+xphm+"', sfjd='"+sfjd+"', gzqr=to_date('"+gzqr+"','YYYY.MM.DD'), gzzr=to_date('"+gzzr+"','YYYY.MM.DD'), ryzt='03', zxrq=to_date('','YYYY.MM.DD'), zxyy='00', fzjg='"+fzjg+"', lrr ='"+lrr+"', lrrq=to_date('"+lrrq+"','YYYY.MM.DD'), jddm='" + jddm + "', dwdm='"+dwdm+"' , qx='"+qx+"', gzbm = '"+gzbm+"' where userid = '"+userid+"'";
//向jcy_ryzp表添加zp
String sql_insert_ryzp = "insert into jcy_ryzp (userid, zp) select '"+userid+"', zp from t_zp where id = 1";
//删除t_zp表中的id='1'的数据
String sql_delete_ryzp = "delete from t_zp zp where id = '1'";
//向qx_user表添加userid, password, usercode, username, flag
String sql_insert_qx_user = "insert into qx_user (userid, password, usercode, username, flag) values ('"+userid+"', '"+password+"', lower('"+usercode+"'), '"+username+"', '01')";
//向jcy_sh表中添加userid,shr,shrq,shjg
String sql_insert_sh = "insert into jcy_sh (userid, shr, shrq, shjg) values ('"+userid+"', '"+lrr+"', to_date('"+today+"','YYYY.MM.DD'), '03')";
int n1 = std.getResultByUpdate(sql_insert_ry);
int n2 = std.getResultByUpdate(sql_update_ry);
int n3 = std.getResultByUpdate(sql_insert_qx_user);
int n4 = std.getResultByUpdate(sql_insert_sh);
std.getResultByUpdate(sql_insert_ryzp);
std.getResultByUpdate(sql_delete_ryzp);
if (n1 == 0 || n2 == 0 || n3 == 0 || n4 == 0){
errtext = "保存失败！";
}else{
errtext = "ok";
}
}
//当前录入人为非市处（区县）公务员
else {
String sql_userid = "SELECT LPAD(SEQ_USERID.NEXTVAL,20,'0') FROM DUAL";
sun.jdbc.rowset.CachedRowSet crsuserid = std.getResultBySelect(sql_userid);
crsuserid.next();
//获得userid
String userid = crsuserid.getString(1);
//添加userid
String sql_insert_ry = "insert into jcy_ry (userid) values ('"+userid+"')";
//添加人员信息
String sql_update_ry = "update jcy_ry set username='"+username+"', sfzh='"+sfzh+"', xb='"+xb+"', usercode = lower('"+usercode+"'), mz='"+mz+"', csrq=to_date('"+csrq+"','YYYY.MM.DD'), zw='"+zw+"', zbdm='"+zbdm+"', ssbz='"+ssbz+"', zzmm='"+zzmm+"', whcd='"+whcd+"', sxzy='"+sxzy+"', zjlb='"+zjlb+"', zjhm='"+zjhm+"', xphm='"+xphm+"', sfjd='"+sfjd+"', gzqr=to_date('"+gzqr+"','YYYY.MM.DD'), gzzr=to_date('"+gzzr+"','YYYY.MM.DD'), ryzt='04', zxrq=to_date('','YYYY.MM.DD'), zxyy='00', fzjg='"+fzjg+"', lrr ='"+lrr+"', lrrq=to_date('"+lrrq+"','YYYY.MM.DD'), jddm='" + jddm + "', dwdm='"+dwdm+"' , qx='"+qx+"', gzbm = '"+gzbm+"' where userid = '"+userid+"'";
//向jcy_ryzp表添加zp
String sql_insert_ryzp = "insert into jcy_ryzp (userid, zp) select '"+userid+"', zp from t_zp where id = 1";
//删除t_zp表中的id='1'的数据
String sql_delete_ryzp = "delete from t_zp zp where id = '1'";
int n1 = std.getResultByUpdate(sql_insert_ry);
int n2 = std.getResultByUpdate(sql_update_ry);
std.getResultByUpdate(sql_insert_ryzp);
std.getResultByUpdate(sql_delete_ryzp);
if (n1 == 0 || n2 == 0){
errtext = "保存失败！";
}else{
errtext = "ok";
}
}
}
}
/**
*修改公务员信息
*不涉及人员状态(ryzt)、录入人(lrr)、录入日期(lrrq)、上报时间(sbsj)、减少状态(jszt)的修改
*/
else if (dz.equals("modify")){
String usercode = std.getValue(request,"usercode").trim(); //usercode
String username = std.getValue(request,"username").trim(); //姓名
String sfzh = std.getValue(request,"sfzh").trim(); //身份证号
String xb = std.getValue(request,"xb"); //性别(1 男 2 女)
String mz = std.getValue(request,"mz"); //民族(代码)
String year = std.getValue(request,"year").trim();
String month= std.getValue(request,"month").trim();
String day = std.getValue(request,"day").trim();
String csrq = year+"."+month+"."+day; //出生年月
String zw = std.getValue(request,"zw"); //职务(代码)
String zbdm = std.getValue(request,"zbdm"); //组别代码
String ssbz = std.getValue(request,"ssbz"); //所属编制(代码)
String zzmm = std.getValue(request,"zzmm"); //政治面目(代码)
String whcd = std.getValue(request,"whcd"); //文化程度(代码)
String sxzy = std.getValue(request,"sxzy"); //所学专业(代码)
String zjlb = std.getValue(request,"zjlb"); //证件类别(代码)
String zjhm = std.getValue(request,"zjhm").trim(); //公务证件号码
String xphm = std.getValue(request,"xphm").trim(); //胸牌号码
String sfjd = std.getValue(request,"sfjx"); //是否街乡公务员
String gzqr = std.getValue(request,"ry_startdate"); //从事执法检查起时间
String gzzr = std.getValue(request,"ry_enddate"); //从事执法检查止时间
String zxrq = std.getValue(request,"zxrq"); //证件注销时间
String zxyy = std.getValue(request,"zxyy"); //证件注销原因
String fzjg = std.getValue(request,"fzjg").trim(); //发证机关
String jddm = std.getValue(request,"jd"); //街道代码
String dwdm = std.getValue(request,"dwdm"); //单位代码
String qx_temp = std.getValue(request,"qx");
String qx = "";
if (qx_temp.length() >= 3)
qx = qx_temp.substring(0,3);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -