?? 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 + -