useraction.java

通过企业办公自动化系统对企业日常办公进行管理

package com.office.action;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.office.actionform.LogonForm;
import com.office.actionform.SearchForm;
import com.office.actionform.UserForm;
import com.office.dao.Content;
import com.office.dao.DB;
import com.office.officemenu.Searchtypelist;
import com.office.tools.Change;
import com.office.tools.CheckUserAble;

public class UserAction extends Action {
	public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {
		HttpSession session=request.getSession();
		LogonForm logonuser=(LogonForm)session.getAttribute("logonuser");
		if(logonuser==null){
			ActionMessages errors=new ActionMessages();
			errors.add("notAllow",new ActionMessage("office.logon.notallow"));
		    saveErrors(request,errors);
		    return mapping.findForward("notallowlogon");
		}
		
		String mark = mapping.getParameter();
		ActionForward forward = new ActionForward();
		if (mark.equals("person_look"))
			forward = executePersonLook(mapping, form, request, response);
		if (mark.equals("person_sigle_look"))
			forward = executePersonSigleLook(mapping, form, request, response);
		if (mark.equals("person_myself_look"))
			forward = executePersonMyselfLook(mapping, form, request, response);
		if (mark.equals("person_add"))
			forward = executePersonAdd(mapping, form, request, response);
		if (mark.equals("person_update"))
			forward = executePersonUpdate(mapping, form, request, response);
		if (mark.equals("person_myself_update"))
			forward = executeMyUpdate(mapping, form, request, response);
		if (mark.equals("person_del"))
			forward = executePersonDel(mapping, form, request, response);
		if (mark.equals("person_good"))
			forward = executePersonGood(mapping, form, request, response);
		return forward;
	}

	public ActionForward executePersonLook(ActionMapping mapping,ActionForm form, HttpServletRequest request,HttpServletResponse response) {
		ActionMessages errors = new ActionMessages();
		HttpSession session = request.getSession();    		
		
		LogonForm logonuser=(LogonForm)session.getAttribute("logonuser");				
		if(!CheckUserAble.check(logonuser)){
			session.setAttribute("selectmenu2", "");
			errors.add("notAllow",new ActionMessage("office.user.noallow"));
			saveErrors(request,errors);
			return mapping.findForward("notallow");
		}
				
		session.setAttribute("selectmenu2", "person_look");
		SearchForm searchform = (SearchForm) form;

		String sql = "";
		String subsql = searchform.getSubsql();
		String subsqlvalue = searchform.getSubsqlvalue();
		if (subsql == null || subsql.equals(""))
			subsql = "all";
		if (subsql.equals("all")){
			subsqlvalue="";
			sql = "select * from " + Content.TB_USER;
		}
	    else if (subsql.equals("user_good")) {
			session.setAttribute("selectmenu2", "person_good");
			searchform.setSubsql(subsql);
	    	if (subsqlvalue == null || subsqlvalue.equals("")) {
				sql = "select * from " + Content.TB_USER + " where user_good='1'";
			} else {
				sql = "select * from " + Content.TB_USER + " where "+ Content.USERNAME + "='" + subsqlvalue + "' and user_good='1'";
			}
		} 
	    else if(subsql.equals("user_able")){
	    	if (subsqlvalue == null || subsqlvalue.equals("")) {
				errors.add("novalue", new ActionMessage("office.search.notiaojian.error"));
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			int subsqlvalue1=-1;
			if(subsqlvalue.equals("游客"))subsqlvalue1=0;
			else if(subsqlvalue.equals("普通管理员"))subsqlvalue1=1;
			else if(subsqlvalue.equals("系统管理员"))subsqlvalue1=2;
			sql = "select * from " + Content.TB_USER + " where user_able=" + subsqlvalue1;
	    }	    
	    else {	    	
	    	if (subsqlvalue == null || subsqlvalue.equals("")) {
	    		errors.add("novalue", new ActionMessage("office.search.notiaojian.error"));
				saveErrors(request, errors);
				return mapping.findForward("false");
			}			
			sql = "select * from " + Content.TB_USER + " where " + subsql+ "='" + subsqlvalue + "'";
		}
		String str_currentpage=request.getParameter("page");
        if(str_currentpage==null||str_currentpage.equals(""))
        	str_currentpage="0";
		int currentpage=Change.strtoint(str_currentpage);
		if(currentpage<=0)
			currentpage=1;

		DB db = new DB();
		ArrayList personlist = db.getallpersonlist(sql,currentpage);
	    
	    session.setAttribute("numrs",Integer.toString(db.getNumrs()));
	    session.setAttribute("numper", Integer.toString(db.getNumper()));
	    session.setAttribute("currentpage",Integer.toString(db.getCurrentPage()));
	    session.setAttribute("numpages", Integer.toString(db.getNumPages()));
		session.setAttribute("personlist", personlist);
		searchform.setSubsqlvalue(subsqlvalue);
		
		return mapping.findForward("success");
	}

	public ActionForward executePersonGood(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		
		ActionMessages errors=new ActionMessages();
		HttpSession session=request.getSession();
		
		LogonForm logonuser=(LogonForm)session.getAttribute("logonuser");
						
		if(!CheckUserAble.check(logonuser)){
			session.setAttribute("selectmenu2", "");
			errors.add("notAllow",new ActionMessage("office.user.noallow"));
			saveErrors(request,errors);
			return mapping.findForward("notallow");
		}

		SearchForm searchform=(SearchForm)form;
		searchform.setSubsql(Content.USERGOOD);
		executePersonLook(mapping, form, request, response);
		return mapping.findForward("success");
	}

	public ActionForward executePersonSigleLook(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		
		ActionMessages errors=new ActionMessages();
		HttpSession session=request.getSession();
		
		LogonForm logonuser=(LogonForm)session.getAttribute("logonuser");
				
		if(!CheckUserAble.check(logonuser)){
			session.setAttribute("selectmenu2", "");
			errors.add("notAllow",new ActionMessage("office.user.noallow"));
			saveErrors(request,errors);
			return mapping.findForward("notallow");
		}
		
		UserForm userform=(UserForm)form; 
		String lookid1=request.getParameter("id");
		 if(lookid1==null||lookid1.equals(""))lookid1="0";
		int lookid=Change.strtoint(lookid1);
		
		ArrayList personlist=(ArrayList)session.getAttribute("personlist");
		boolean flag=false;		
		for(int i=0;i<personlist.size();i++){
			UserForm personsigleform=(UserForm)personlist.get(i);
			if(lookid==personsigleform.getUserid()){
				flag=true;
				userform.setUsername(personsigleform.getUsername());
				userform.setUsertruename(personsigleform.getUsertruename());
				userform.setUserable(personsigleform.getUserable());
				userform.setUsergood(personsigleform.getUsergood());
				userform.setUserbranch(personsigleform.getUserbranch());
				userform.setUserjob(personsigleform.getUserjob());
				userform.setUsersex(personsigleform.getUsersex());
				userform.setUseremail(personsigleform.getUseremail());
				userform.setUsertel(personsigleform.getUsertel());
				userform.setUseraddress(personsigleform.getUseraddress());
			    userform.setUseraccesstimes(personsigleform.getUseraccesstimes());
			    userform.setUserfoundtime(personsigleform.getUserfoundtime());
	    		break;
			}
		}
		if(!flag){
			errors.add("lookR",new ActionMessage("office.person.look.sigle.error"));
			saveErrors(request,errors);
			return mapping.findForward("looksiglewrong");
		}
		return mapping.findForward("success");
	}
	
	public ActionForward executePersonMyselfLook(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		HttpSession session = request.getSession();
		
		session.setAttribute("selectmenu1", "person");
		session.setAttribute("selectmenu2", "person_myself");
		
		ArrayList personsextypelist=Searchtypelist.getpersonsextypelist();
		ArrayList personabletypelist=Searchtypelist.getpersonabletypelist();
		ArrayList personjobtypelist=Searchtypelist.getpersonjobtypelist();
		ArrayList personbranchtypelist=Searchtypelist.getpersonbranchtypelist();
		ArrayList persongoodtypelist=Searchtypelist.getpersongoodtypelist();
		session.setAttribute("personabletypelist", personabletypelist);
		session.setAttribute("personjobtypelist", personjobtypelist);
		session.setAttribute("personbranchtypelist", personbranchtypelist);
		session.setAttribute("persongoodtypelist", persongoodtypelist);
		session.setAttribute("personsextypelist", personsextypelist);
		
		LogonForm logonform=(LogonForm)session.getAttribute("logonuser");
		LogonForm myform=(LogonForm)form;
		myform.setUsername(logonform.getUsername());
		myform.setUsertruename(logonform.getUsertruename());
		myform.setUserable(logonform.getUserable());
		myform.setUsergood(logonform.getUsergood());
		myform.setUserbranch(logonform.getUserbranch());
		myform.setUserjob(logonform.getUserjob());
		myform.setUsersex(logonform.getUsersex());
		myform.setUseremail(logonform.getUseremail());
		myform.setUsertel(logonform.getUsertel());
		myform.setUseraddress(logonform.getUseraddress());
	    myform.setUseraccesstimes(logonform.getUseraccesstimes());
	    myform.setUserfoundtime(logonform.getUserfoundtime());
		return mapping.findForward("success");
		
	}
	
	public ActionForward executePersonAdd(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		ActionMessages errors=new ActionMessages();
		HttpSession session = request.getSession();
				
		LogonForm logonuser=(LogonForm)session.getAttribute("logonuser");
				
		if(!CheckUserAble.check(logonuser)){
			session.setAttribute("selectmenu2", "");
			errors.add("notAllow",new ActionMessage("office.user.noallow"));
			saveErrors(request,errors);
			return mapping.findForward("notallow");
		}
		
		session.setAttribute("selectmenu2", "person_add");
		
		UserForm userform = (UserForm) form;
		errors = new ActionMessages();
					
		String addtype = request.getParameter("addtype");
		if (addtype == null || addtype.equals(""))
			addtype = "link";
		if (addtype.equals("link")) {
			return mapping.findForward("add");
		}

		if (addtype.equals("add")) {
			
			boolean mark = true;
			String username = userform.getUsername();
			String password1 = userform.getUserpassword();
			String password2 = userform.getUseraginpassword();
			String truename = userform.getUsertruename();
			String tel = userform.getUsertel();
			String address = userform.getUseraddress();
			String sex = userform.getUsersex();
			String job = userform.getUserjob();
			int able = userform.getUserable();
			String branch = userform.getUserbranch();
			String usergood = userform.getUsergood();
			String email = userform.getUseremail();
			
			if (username == null || username.equals("")) {
				mark = false;
				errors.add("noname", new ActionMessage("office.person.nousername.error"));
			}
			if (password1 == null || password1.equals("")) {
				mark = false;
				errors.add("nopswd", new ActionMessage("office.person.nopassword1.error"));
			}
			if (password2 == null || password2.equals("")) {
				mark = false;
				errors.add("nopswd1", new ActionMessage("office.person.nopassword2.error"));
			}
			if (truename == null || truename.equals("")) {
				mark = false;
				errors.add("notruename", new ActionMessage("office.person.notruename.error"));
			}
			if (tel != null && !(tel.equals(""))) {
				try {
					Long.parseLong(tel);