?? jcy_pxxx_new_modify.jsp
字號:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" errorPage=""%>
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<% if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用戶已斷線或未正常登錄，請重新登錄！")
window.open("../index.htm","_top")
</Script>
<% return; }%>
<%
String nowuserid = jcypurview.getUserid(); //取當前用戶編號
String nowusername = jcypurview.getUserName(); //取當前用戶名稱
String nowuserszqx = jcypurview.getUserSzqx(); //取當前用戶所在區(qū)縣
String nowuserszdw = jcypurview.getUserSzdw(); //取當前用戶所在單位
%>
<html>
<head>
<%vststd std = new vststd();%>
<title>公務(wù)員管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" href="../style.css" type="text/css">
<%
response.setHeader("Pragma","No-cache");
response.setHeader("Cache-Control","no-cache");
response.setDateHeader("Expires",0);
String szt = std.getValue(request,"zt");
String userid = std.getValue(request,"userid"); //用戶編號
String sdwdm = std.getValue(request,"sdwdm");
String szbdm = std.getValue(request,"szbdm");
String pxxxid = std.getValue(request,"ID"); //培訓序號
String pxbm = ""; //培訓組織部門
String pxqr = ""; //培訓時間起
String pxzr = ""; //培訓時間止
String pxqc = ""; //培訓班期次
String pxnd = ""; //培訓年度
String sfzh = ""; //身份證號
String username = ""; //公務(wù)員姓名
String pxqk = ""; //備注
String useid = ""; //公務(wù)員編號
String rqtime = "";
String rqtime1 = "";
String rtime="";
if ( szt.equals("modify"))
{
String sql_select = "select b.username,b.sfzh,a.pxnd,a.PXQC,to_char(a.PXQR,'yyyy.mm.dd'),to_char(a.pxzr,'yyyy.mm.dd'),a.PXBM,a.PXQK from jcy_pxxx a,jcy_ry b where a.pxxxid = '"+pxxxid+"' and a.userid = b.userid and a.userid = '"+userid+"'";
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_select);
crs.next();
username = crs.getString(1); //公務(wù)員姓名
sfzh = crs.getString(2); //身份證號
pxnd = crs.getString(3); //培訓年度
pxqc = crs.getString(4); //培訓班期次
pxqr = crs.getString(5); //培訓時間起
pxzr = crs.getString(6); //培訓時間止
pxbm = crs.getString(7); //培訓組織部門
pxqk = crs.getString(8); //備注
if (username == null) username = "無";
if (sfzh == null) sfzh = "000000000000000";
if (pxnd == null) pxnd = "0";
if (pxqc == null) pxqc = "0";
if (pxqr == null) pxqr = "0000-00-00";
if (pxzr == null) pxzr = "0000-00-00";
if (pxbm == null) pxbm = "無";
if (pxqk == null) pxqk = "無";
}
if (szt.equals("new"))
{
String sql_new =" select username,sfzh from jcy_ry where userid = '"+userid+"'";
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect(sql_new);
crs.next();
username = crs.getString(1);
sfzh = crs.getString(2);
if (username == null ) username = "次人無姓名，請修改個人信息";
if (sfzh == null ) sfzh = "次人無身份證號，修改個人信息";
}
//計算當前時間，格式：yyyy.mm.dd
sun.jdbc.rowset.CachedRowSet aa=std.getResultBySelect("select to_char(sysdate,'yyyy.mm.dd') t from dual");
aa.next();
String ti=aa.getString("t");
%>
<%
if (szt.equals("new"))
{
if (jcypurview.purviewVerdict("B0500036") == false)
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權(quán)限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
String qaxa = "select qx from jcy_ry where userid = '"+userid+"'"; ///判斷當前用戶有無權(quán)限新增此人陪訓班信息
sun.jdbc.rowset.CachedRowSet v_qaxa = std.getResultBySelect(qaxa);
v_qaxa.next();
String pi_qaxa = v_qaxa.getString(1);
if(!nowuserszqx.equals("001"))
{
if(!pi_qaxa.equals(nowuserszqx))
{
%>
<Script Language=javascript>
alert("您沒有新增其它區(qū)縣人員培訓的權(quán)限！")
window.open("jcy_pxxx_select.jsp?zt=back&userid="+'<%=userid%>'+"&sdwdm="+'<%=sdwdm%>'+"&szbdm="+'<%=szbdm%>',"_self");
</Script>
<%
return;
}
}
}
%>
<%
if (szt.equals("modify"))
{
if (jcypurview.purviewVerdict("B0500037") == false)
{
%>
<Script Language=javascript>
alert("您沒有操作此頁權(quán)限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
String qaxa = "select qx from jcy_ry where userid = '"+userid+"'"; ///判斷當前用戶有無權(quán)限新增此人陪訓班信息
sun.jdbc.rowset.CachedRowSet v_qaxa = std.getResultBySelect(qaxa);
v_qaxa.next();
String pi_qaxa = v_qaxa.getString(1);
if(!pi_qaxa.equals("001"))
{
if(!pi_qaxa.equals(nowuserszqx))
{
%>
<Script Language=javascript>
alert("您沒有新增其它區(qū)縣人員培訓的權(quán)限！")
window.open("jcy_pxxx_select.jsp?zt=back&userid="+'<%=userid%>'+"&sdwdm="+'<%=sdwdm%>'+"&szbdm="+'<%=szbdm%>',"_self");
</Script>
<%
return;
}
}
}
%>
<script language="JavaScript" src = "new.js">
</script>
<!--modify: yhy-->
<link rel="stylesheet" href="../lib/main.css" type="text/css">
<script language="javascript" src="../lib/check.js"></script>
<script language="JavaScript" src="../lib/date/GetDate.js"></script>
<script language="JavaScript" src="../lib/util.js"></script>
<!-- modify end -->
<!--modify: yhy-->
<SCRIPT LANGUAGE="JavaScript">
function checkJsrqs(inval){
if(inval==""){
return true;
}
var ret = check_date(inval,"D");
if(ret==""){
ret = checkStartEndDate(inval,document.getElementById("rqr").value);
if(ret == -1||ret == -2){
alert("日期格式不對！");
return false;
}
if(ret == -3){
document.getElementById("rq").value="";
document.getElementById("rqr").value="";
alert("開始日期不得大于結(jié)束日期!");
return false;
}
else{
return true;
}
}
else{
ret="加入日期 起："+ret;
alert(ret);
return false;
}
}
function checkJsrqz(inval){
if(inval==""){
return true;
}
var ret = check_date(inval,"D");
if(ret==""){
ret = checkStartEndDate(document.getElementById("rq").value,inval);
if(ret == -1||ret == -2){
alert("日期格式不對！");
return false;
}
if(ret == -3){
document.getElementById("rq").value="";
document.getElementById("rqr").value="";
alert("開始日期不得大于結(jié)束日期!");
return false;
}
else{
return true;
}
}
else{
ret="加入日期 止："+ret;
alert(ret);
return false;
}
}
//日期結(jié)束
</SCRIPT>
<!--modify end-->
<script language=javascript>
function f_number()
{
//var v_sfzh = document.form.sfzh.value;
//var v_username = document.form .username.value;
if (document.form.pxnd.value.length > 4)
{
alert('年份長度不能超過4位！');
document.form.pxnd.focus();
return(false);
}
if (document.form.pxnd.value.length == 0)
{
alert('年份長度不能為空！');
document.form.pxnd.focus();
return(false);
}
if (document.form.pxqc.value.length >20)
{
alert('培訓班期次長度不能超過20位！');
document.form.pxqc.focus();
return(false);
}
if (document.form.pxqc.value.length == 0)
{
alert('培訓班期次不能為空!');
document.form.pxqc.focus();
return(false);
}
if(document.form.rq.value.length==0)
{
alert('請輸入培訓起始日期！');
document.form.rq.focus();
return(false);
}
if(document.form.rqr.value.length==0)
{
alert("請輸入培訓終止日期！");
document.form.rqr.focus();
return(false);
}
if (document.form.pxqk.value.length >1000)
{
alert('培訓班培訓情況長度不能超過1000位!');
document.form.pxqk.focus();
return(false);
}
if (document.form.pxqk.value.length == 0)
{
alert('培訓班培訓情況不能為空!');
document.form.pxqk.focus();
return(false);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -