📄 jcy_jcyjc_submit_cf.jsp

📁 公务员工资系统软件工程文档及源代码
💻 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 jcyjcxh_id = std.getValue(request,"ID");	                //公务员奖惩代码	
	String szt = std.getValue(request,"zt");                        //按钮类别	
	String imager = "";
	String userid = std.getValue(request,"userid");                 //公务员编号
	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("B0500026") == false)			//判断是否有删除权限
  {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限！")
		window.open("../index.jsp","_top")
	</Script>
<%  return;   
    }
  }
 if (szt.equals("modify"))
 { 
    if (jcypurview.purviewVerdict("B0500024") == false)			//判断是否有修改权限
  {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限！")
		window.open("../index.jsp","_top")
	</Script>
<%  return; 
    }
  }
if (szt.equals("new"))
 {    
    if (jcypurview.purviewVerdict("B0500025") == 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(""))
	    {
            imager = "惩罚名称不能为空!";
            ixy = 1;
         }
       if (ixy != 1)
       {	
       	if (jcyy.length() > 500)
	    { 
		imager = "惩罚名称长度不能大于500位!";
		ixy = 1;
	     }
	   }
	 String jcrq =std.getValue(request,"rq");												//奖惩日期
	 String cfzl =std.getValue(request,"cfzl");	
  if (ixy == 0)
  {	
    String lrrq = std.getDateStr("YYYY.MM.DD");              		    //取数据库时间     
	String jcyjcxh ="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_jcyjc (jcyjcxh) values ('"+suserid+"')";
	int isi = std.getResultByUpdate(sql_insert);
	if (isi == 1 )
	    {   
	         String sql_update = "update jcy_jcyjc set userid='"+userid+"',sfcf='01',cfzl='"+cfzl+"',jcrq=to_date('"+jcrq+"','YYYY.MM.DD'),jcyy='"+jcyy+"',lrrq=to_date('"+lrrq+"','YYYY.MM.DD'),lry='"+nowuserid+"' where jcyjcxh = '"+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(""))
	    {
            imager = "惩罚名称不能为空!";
            ixy = 1;
         }
       if (ixy != 1)
       {	
       	if (jcyy.length() > 500)
	    { 
		imager = "惩罚名称长度不能大于500位!";
		ixy = 1;
	     }
	   }
	 String jcrq =std.getValue(request,"rq");												//奖惩日期
	 String cfzl =std.getValue(request,"cfzl");	
	 String lrrq = std.getDateStr("YYYY.MM.DD");                     //取数据库时间
  if(ixy == 0)
  { 
	String sql_modify_update = "update jcy_jcyjc set userid='"+userid+"',sfcf='01',cfzl='"+cfzl+"',jcrq=to_date('"+jcrq+"','YYYY.MM.DD'),jcyy='"+jcyy+"',lrrq=to_date('"+lrrq+"','YYYY.MM.DD'),lry='"+nowuserid+"' where jcyjcxh = '"+jcyjcxh_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_jcyjc where jcyjcxh = '"+jcyjcxh_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 + -