📄 jcy_dwjc_submit_jl.jsp
字号:
<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*,com.vstsoft.std.*" errorPage="" %>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<jsp:useBean id="jcypurview" class="com.vstsoft.jcypurview" scope = "session" />
<html>
<%vststd std = new vststd();%>
<%
String dwjcxh_id = std.getValue(request,"ID"); // 单位奖惩代码
String szt = std.getValue(request,"zt"); //按钮类别
String imager = "";
String dwdm = std.getValue(request,"dwdm"); //单位编号
int ixy = 0;
String sfjl =""; //是否奖励
String lry =""; //录入人
%>
<%
if (jcypurview.checkLogin() == false)
{
%>
<Script Language=javascript>
alert("用户已断线或未正常登录，请重新登录！")
window.open("../index.htm","_top")
</Script>
<% return;
}
if (szt.equals("del"))
{
if (jcypurview.purviewVerdict("B0500022") == false) //判断是否有删除权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}
if (szt.equals("modify"))
{
if (jcypurview.purviewVerdict("B0500021") == false) //判断是否有修改权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}
if (szt.equals("new"))
{
if (jcypurview.purviewVerdict("B0500020") == false) //判断是否有新增权限
{
%>
<Script Language=javascript>
alert("您没有操作此页权限！")
window.open("../index.jsp","_top")
</Script>
<% return;
}
}%>
<%
String nowuserid = jcypurview.getUserid(); //取当前用户编号
String nowusername = jcypurview.getUserName(); //取当前用户名称
String nowuserszqx = jcypurview.getUserSzqx(); //取当前用户所在区县
String nowuserszdw = jcypurview.getUserSzdw(); //取当前用户所在单位
%>
<%
//新增单位
if ( szt.equals("new"))
{
String jcyy = std.getValue(request,"jcyy").trim(); //单位奖惩原因
if (jcyy.equals(""))
{
ixy = 1;
imager = "奖励名称不能为空!";
}
if (ixy != 1)
{
if (jcyy.length() > 500)
{
ixy = 1;
imager = "奖励名称长度不能大于500位!";
}
}
String jcrq =std.getValue(request,"rq"); //奖惩日期
String jljb =std.getValue(request,"jljb"); //奖励级别
if (ixy == 0)
{
String lrrq = std.getDateStr("YYYY.MM.DD"); //取数据库时间
String dwjcxh ="SELECT LPAD(SEQ_jcyID.NEXTVAL,10,'0') FROM DUAL"; //奖惩编号
sun.jdbc.rowset.CachedRowSet crs = std.getResultBySelect("SELECT LPAD(SEQ_jcyID.NEXTVAL,10,'0') FROM DUAL");
crs.next();
String suserid = crs.getString(1);
//新增单位信息
String sql_insert = "insert into jcy_dwjc (dwjcxh) values ('"+suserid+"')";
int isi = std.getResultByUpdate(sql_insert);
if (isi == 1 )
{
String sql_update = "update jcy_dwjc set dwdm='"+dwdm+"',sfjl='01',jljb='"+jljb+"',jcrq=to_date('"+jcrq+"','YYYY.MM.DD'),jcyy='"+jcyy+"',lrrq=to_date('"+lrrq+"','YYYY.MM.DD'),lry='"+nowuserid+"' where dwjcxh = '"+suserid+"'";
int isu = std.getResultByUpdate(sql_update);
if (isu == 1)
{
imager = "保存成功!";
//return;
}else
{
ixy = 1;
imager = "新增失败!";
}
}
}
}
//修改单位
if (szt.equals("modify"))
{
//修改单位
String jcyy = std.getValue(request,"jcyy").trim(); //单位原因
if (jcyy.equals(""))
{
ixy = 1;
imager = "惩罚名称不能为空!";
}
if (ixy != 1)
{
if (jcyy.length() > 500)
{
ixy = 1;
imager = "惩罚名称长度不能大于500位!";
}
}
String jcrq =std.getValue(request,"rq"); //奖惩日期
String jljb =std.getValue(request,"jljb"); //奖励级别
String lrrq = std.getDateStr("YYYY.MM.DD"); //取数据库时间
if(ixy == 0)
{
String sql_modify_update = "update jcy_dwjc set dwdm='"+dwdm+"',sfjl='01',jljb='"+jljb+"',jcrq=to_date('"+jcrq+"','YYYY.MM.DD'),jcyy='"+jcyy+"',lrrq=to_date('"+lrrq+"','YYYY.MM.DD'),lry='"+nowuserid+"' where dwjcxh = '"+dwjcxh_id+"'";
int imodify = std.getResultByUpdate(sql_modify_update);
if (imodify == 1 )
{
imager = "修改成功!";
}else
{
ixy = 1;
imager = "修改失败!";
}
}
}
//单位惩罚信息删除
if(szt.equals("del"))
{
String sql_del = "delete from jcy_dwjc where dwjcxh = '"+dwjcxh_id+"'";
int idel = std.getResultByUpdate(sql_del);
if (idel == 1)
{
//imager = "减少成功!";
imager = "删除成功！";
}else
{
ixy = 1;
imager = "删除失败！";
}
}
%>
<head>
<title>
</title>
</head>
<body onLoad="parent.f_imager('<%=imager%>','<%=ixy%>')">
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -