?? jcy_ry_submit.jsp
字號(hào):
<%@ 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(); //取當(dāng)前用戶usercode
String curruserid = jcypurview.getUserid(); //取當(dāng)前用戶編號(hào)
String currusername = jcypurview.getUserName(); //取當(dāng)前用戶名稱
String curruserszqx = jcypurview.getUserSzqx(); //取當(dāng)前用戶所在區(qū)縣
String curruserszdw = jcypurview.getUserSzdw(); //取當(dāng)前用戶所在單位
//檢測(cè)用戶是否登錄
if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用戶已斷線或未正常登錄，請(qǐng)重新登錄！")
window.open("../index.htm","_top")
</Script>
<%
return;}
%>
<%
//檢測(cè)用戶是否有操作權(quán)限
if (!(jcypurview.purviewVerdict("B0500001") || jcypurview.purviewVerdict("B0500002") || jcypurview.purviewVerdict("B0500003") || jcypurview.purviewVerdict("B0500004") || jcypurview.purviewVerdict("B0500010")))
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權(quán)限！")
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");//添加密碼
/**
*公務(wù)員新增，分為兩種情況，即錄入人分為市處和非市處（區(qū)縣）公務(wù)員
*人員狀態(tài)(ryzt)為04－未上報(bào)
*/
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(); //身份證號(hào)
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"); //職務(wù)(代碼)
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"); //所學(xué)專業(yè)(代碼)
String zjlb = std.getValue(request,"zjlb"); //證件類別(代碼)
String zjhm = std.getValue(request,"zjhm").trim(); //公務(wù)證件號(hào)碼
String xphm = std.getValue(request,"xphm").trim(); //胸牌號(hào)碼
String sfjd = std.getValue(request,"sfjx"); //是否街鄉(xiāng)公務(wù)員
String gzqr = std.getValue(request,"ry_startdate"); //從事執(zhí)法檢查起時(shí)間
String gzzr = std.getValue(request,"ry_enddate"); //從事執(zhí)法檢查止時(shí)間
String ryzt = std.getValue(request,""); //人員狀態(tài)(注銷，減少，正常，未上報(bào)，待審核，未通過)
String zxrq = std.getValue(request,"zxrq"); //證件注銷時(shí)間
String zxyy = std.getValue(request,"zxyy"); //證件注銷原因
String fzjg = std.getValue(request,"fzjg").trim(); //發(fā)證機(jī)關(guān)
String lrr = curruserid; //錄入人
String lrrq = std.getDateStr("YYYY.MM.DD"); //錄入時(shí)間
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 = ""; //縣區(qū)代碼
String gzbm = std.getValue(request,"gzbm").trim(); //工作部門
String today = std.getDateStr("YYYY.MM.DD"); //當(dāng)天日期
/************************判斷***************************/
//判斷usercode是否有漢字
boolean flag = false;
for(int i = 0; i<usercode.length(); i++)
{
if((int)(usercode.charAt(i))>255)
flag = true;
}
//判斷公務(wù)起止日期
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 = "請(qǐng)?zhí)顚懶彰?quot;;
else if (sfzh.equals(""))
errtext = "請(qǐng)?zhí)顚懮矸葑C號(hào)碼！";
else if (!std.checkNumber(sfzh))
errtext = "身份證號(hào)碼必須為數(shù)字！";
else if (sfzh.length() != 15 & sfzh.length() != 18)
errtext = "請(qǐng)正確填寫身份證號(hào)碼！身份證號(hào)碼長(zhǎng)度必須為15或者18位數(shù)字！";
else if (usercode.equals(""))
errtext = "請(qǐng)?zhí)顚懝珓?wù)員編號(hào)！";
else if(flag)
errtext = "公務(wù)員編號(hào)不能使用中文！";
else if (sxzy.equals(""))
errtext = "請(qǐng)?zhí)顚懰鶎W(xué)專業(yè)！";
else if (qx.equals(""))
errtext = "請(qǐng)選擇區(qū)縣！";
else if (dwdm.equals(""))
errtext = "請(qǐng)選擇工作單位！";
else if (fzjg.equals(""))
errtext = "請(qǐng)?zhí)顚懓l(fā)證機(jī)關(guān)！";
else if (gzbm.equals(""))
errtext = "請(qǐng)?zhí)顚懝ぷ鞑块T！";
else if (xphm.length() != 0 && xphm.length() != 9)
errtext = "胸牌號(hào)碼長(zhǎng)度為9位，請(qǐng)正確填寫！";
else if (zjhm.length() != 0 && zjhm.length() != 9)
errtext = "證件號(hào)碼長(zhǎng)度為9位，請(qǐng)正確填寫！";
else if (num_rq == 1)
errtext = "請(qǐng)正確填寫工作起止日期！";
else{
//檢測(cè)sfzh與usercode是否已經(jīng)存在
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 = "此公務(wù)員已經(jīng)存在！";
else if (!num_usercode.equals("0"))
errtext = "您所填寫的用戶名已存在，請(qǐng)您重新選擇一個(gè)用戶名！";
//如果當(dāng)前錄入人為市處公務(wù)員，則新錄入的人員的 ryzt='03', 同時(shí)還要添加與審核成功時(shí)相同的信息
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'的數(shù)據(jù)
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";
}
}
//當(dāng)前錄入人為非市處（區(qū)縣）公務(wù)員
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'的數(shù)據(jù)
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";
}
}
}
}
/**
*修改公務(wù)員信息
*不涉及人員狀態(tài)(ryzt)、錄入人(lrr)、錄入日期(lrrq)、上報(bào)時(shí)間(sbsj)、減少狀態(tài)(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(); //身份證號(hào)
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"); //職務(wù)(代碼)
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"); //所學(xué)專業(yè)(代碼)
String zjlb = std.getValue(request,"zjlb"); //證件類別(代碼)
String zjhm = std.getValue(request,"zjhm").trim(); //公務(wù)證件號(hào)碼
String xphm = std.getValue(request,"xphm").trim(); //胸牌號(hào)碼
String sfjd = std.getValue(request,"sfjx"); //是否街鄉(xiāng)公務(wù)員
String gzqr = std.getValue(request,"ry_startdate"); //從事執(zhí)法檢查起時(shí)間
String gzzr = std.getValue(request,"ry_enddate"); //從事執(zhí)法檢查止時(shí)間
String zxrq = std.getValue(request,"zxrq"); //證件注銷時(shí)間
String zxyy = std.getValue(request,"zxyy"); //證件注銷原因
String fzjg = std.getValue(request,"fzjg").trim(); //發(fā)證機(jī)關(guān)
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);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -