📄 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(); //取当前用户所在区县
String nowuserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
%>
<html>
<head>
<%vststd std = new vststd();%>
<title>公务员管理</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 = ""; //公务员姓名
String pxqk = ""; //备注
String useid = ""; //公务员编号
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); //公务员姓名
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("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
String qaxa = "select qx from jcy_ry where userid = '"+userid+"'"; ///判断当前用户有无权限新增此人陪训班信息
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("您没有新增其它区县人员培训的权限！")
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("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
String qaxa = "select qx from jcy_ry where userid = '"+userid+"'"; ///判断当前用户有无权限新增此人陪训班信息
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("您没有新增其它区县人员培训的权限！")
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("开始日期不得大于结束日期!");
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("开始日期不得大于结束日期!");
return false;
}
else{
return true;
}
}
else{
ret="加入日期 止："+ret;
alert(ret);
return false;
}
}
//日期结束
</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);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -