qx_submit.jsp

一个较好的公务员管理系统软件源代码

<%@page contentType="text/html;charset=GBK"%>
<%@ page import = "com.vstsoft.std.*" %>
<%@ page import = "java.sql.*" %>
<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 Userid = "";
   Userid = jcypurview.getUserid();     //取当前公务员编号

   if (jcypurview.purviewVerdict("B0500006") == false)
  {
%>   
	<Script Language=javascript>
		alert("您没有操作此页权限!")
		window.open("../index.jsp","_top")
	</Script>
<%  return;  }  %>


<%
	vststd tra = new vststd("jc");
	String szt = tra.getValue(request,"zt");
	String jcid = "";
	String spd = "";
		
	int isi = 0;
	String errtext = "";
	
	if (szt.equals("ry")){
		String suserid = tra.getValue(request,"user");
		String value = tra.getValue(request,"count");
		
		if(value == null){
			isi = tra.getResultByUpdate("delete from qx_user_group where userid = '"+ suserid +"'");
			if (isi != 0)
			{
			   errtext = "保存成功!";
			}else
			{
			   errtext = "保存失败!";
			}	
		}else
		{

			int count = Integer.parseInt(value);

			tra.getResultByUpdate("delete from qx_user_group where userid = '"+ suserid +"'");

			for(int i = 0;i < count;i++)
			{
				value = tra.getValue(request,"s" + i);

				isi = tra.getResultByUpdate("insert into qx_user_group (gid,userid) values ('"+ value +"','"+ suserid +"')");				
			}
		
			if (isi != 0)
			{
			   errtext = "保存成功!";
			}else
			{
			   errtext = "保存失败!";
			}	
		}	
	}else if (szt.equals("jcqx"))
	{	
		String sjcid = tra.getValue(request,"jcid");
		String value = tra.getValue(request,"count");
		if (sjcid.equals("")){
			errtext = "请先保存角色基本信息!";
			spd = "notinsert";
		}else
		{
			if(value.equals("0")){
				isi = tra.getResultByUpdate("delete from qx_group_list where gid = '"+ sjcid +"'");

				if (isi != 0)
				{
				   errtext = "保存成功!";
				   spd = "jcins";
				}else
				{
				   errtext = "保存失败!";
				}				
			}else
			{

				int count = Integer.parseInt(value);
				
				isi = tra.getResultByUpdate("delete from qx_group_list where gid = '"+ sjcid +"'");
											   
				for(int i = 0;i < count;i++)
				{
					value = tra.getValue(request,"s" + i);

					isi = tra.getResultByUpdate("insert into qx_group_list (gid,iid) values ('"+ sjcid +"','"+ value +"')");				
				}
				
				if (isi != 0)
				{
				   errtext = "保存成功!";
  				   spd = "jcins";
				}else
				{
				   errtext = "保存失败!";
				}	
			}
		}
	}else if (szt.equals("jcmodify"))
	{
	    	String suser = tra.getValue(request,"user").trim();
	    	String sms = tra.getValue(request,"ms");
	    	String smjcid = tra.getValue(request,"jcid");

	    	if (suser.equals("")){
				errtext= "角色名称不能为空!";
			}else{
				if (smjcid.equals("")){

					sun.jdbc.rowset.CachedRowSet jc = tra.getResultBySelect("SELECT LPAD(SEQ_jcyID.NEXTVAL,5,'0') FROM DUAL");
					jc.next();
					smjcid = jc.getString(1);
					
					isi = tra.getResultByUpdate("insert into qx_group (id) values ('"+smjcid+"')");
					if (isi == 1){
						isi = tra.getResultByUpdate("update qx_group set name='"+suser+"',describe='"+sms+"' where id = '"+smjcid+"'");
						jcid = smjcid;
					}else{
						errtext = "保存失败!";
					}

				}else{
					isi = tra.getResultByUpdate("update qx_group set name='"+suser+"',describe='"+sms+"' where id = '"+smjcid+"'");

				}
				
				if (isi != 0)
				{
				   errtext = "保存成功!";
//				   spd = "jcins";
				}else
				{
				   errtext = "保存失败!";
				}			
			}
	}else if (szt.equals("jsdelete"))
	{
		String check = tra.getValue(request, "checkbox_userid");
		if (check.equals("")){
			errtext = "请选择需要删除的角色!";
		}
		else{
			String jcuserid[] = request.getParameterValues("checkbox_userid");
			for (int i = 0; i < jcuserid.length; i++){
				isi = tra.getResultByUpdate("delete from qx_group_list where gid = '"+jcuserid[i]+"'");
				isi = tra.getResultByUpdate("delete from QX_USER_GROUP where gid = '"+jcuserid[i]+"'");
				isi = tra.getResultByUpdate("delete from qx_group where id = '"+jcuserid[i]+"'");
			}
			errtext = "成功删除!";

			spd = "okdel";
		}
	}else if (szt.equals("rycount"))
	{
/*		String suserid = tra.getValue(request,"user");
		String value = tra.getValue(request,"count");
			int count = Integer.parseInt(value);
			tra.getResultByUpdate("delete from qx_user_group where userid = '"+ suserid +"'");
			for(int i = 0;i < count;i++)
			{
				value = tra.getValue(request,"s" + i);

				isi = tra.getResultByUpdate("insert into qx_user_group (gid,userid) values ('"+ value +"','"+ suserid +"')");				
			}
			if (isi != 0)
			{
			   errtext = "保存成功!";
			}else
			{
			   errtext = "保存失败!";
			}	
		}	
	f.action="qx_submit.jsp?zt=rycount&countb=" + countb + stextb + "&countd=" + countd + stextd;
*/
		String suserid = "";
		String valueb = tra.getValue(request,"countb");
		String valued = tra.getValue(request,"countd");
		if (valued.equals("0")){
			errtext = "请选择公务员!";
		}if (valueb.equals("0")){
			errtext = "请选择公务员角色!";
		}else{
			int countb = Integer.parseInt(valueb);
			int countd = Integer.parseInt(valued);
			for (int i = 0; i < countd;i++){
				suserid = tra.getValue(request,"sd" + i);
				tra.getResultByUpdate("delete from qx_user_group where userid = '"+suserid+"'");

				for(int ii = 0;ii < countb;ii++)
				{
					valueb = tra.getValue(request,"sb" + ii);

					isi = tra.getResultByUpdate("insert into qx_user_group (gid,userid) values ('"+ valueb +"','"+ suserid +"')");				
				}
			}
			if (isi != 0)
			{
			   errtext = "保存成功!";
			}else
			{
			   errtext = "保存失败!";
			}	
		}
	}
%>
<html>
<head>
<title>

</title>
</head>
<body onLoad="parent.f_err('<%=errtext%>','<%=jcid%>','<%=spd%>')">
</body>
</html>