useraction.java

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

				} catch (Exception e) {
					e.printStackTrace();
					errors.add("nonum", new ActionMessage("office.person.telnotnum.error"));
				    mark=false;
				}
			}
			if (!mark) {
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			if (!password1.equals(password2)) {
				errors.add("nosame", new ActionMessage("office.person.password.nosame.error"));
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			String sql="select * from "+Content.TB_USER+" where "+Content.USERNAME+"='"+username+"'";
			DB db=new DB();
			ResultSet rs=db.getRs(sql);
			try{
			    if(rs.next()){
			    	userform.setUsertel(tel);
					userform.setUseremail(email);
			    	userform.setUsername(username);
					userform.setUsertruename(truename);
					userform.setUseraddress(address);
					userform.setUsersex(sex);
					userform.setUserable(able);
					userform.setUserbranch(branch);
					userform.setUsergood(usergood);
					userform.setUserjob(job);
			    	errors.add("exist",new ActionMessage("office.person.add.have.exist.error"));
			    	saveErrors(request,errors);
			    	return mapping.findForward("false");
			    }
			}
			catch(Exception e){e.printStackTrace();System.out.println("cun zai gai ji lu !");}
			
			String foundtime=Change.datetostr(new Date());
			sql = "insert into "+Content.TB_USER+" values('"+username+"','"+password1+"','"+truename+"',"+able+",'"+usergood+"','"+branch+"','"+job+"','"+sex+"','"+email+"','"+tel+"','"+address+"',"+0+",'"+foundtime+"')";
		    
		    int i=db.inseart(sql);
		    if(i==0){
		    	errors.add("addR",new ActionMessage("office.insert.false"));
		    	saveErrors(request,errors);
		    	return mapping.findForward("false");
		    }
		}
		errors.add("addR",new ActionMessage("office.insert.success"));
    	saveErrors(request,errors);
    	userform.clear();
		return mapping.findForward("success");
		
	}

	public ActionForward executePersonUpdate(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		UserForm userform = (UserForm) form;
				
		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");
		}
					
		String updatetype = request.getParameter("updatetype");
		if (updatetype == null || updatetype.equals(""))
			updatetype = "link";
		if (updatetype.equals("link")) {
			String lookid1=request.getParameter("id");
			 if(lookid1==null||lookid1.equals(""))lookid1="0";
			int lookid=Change.strtoint(lookid1);
			session.setAttribute("id", 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.meet.look.sigle.error"));
				saveErrors(request,errors);
				return mapping.findForward("false");
			}
			return mapping.findForward("update");
		}

		if (updatetype.equals("update")) {			
			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 (password1 == null || password1.equals("")) {
				mark = false;
				errors.add("nopswd1", new ActionMessage("office.person.nopassword1.error"));
			}
			if (password2 == null || password2.equals("")) {
				mark = false;
				errors.add("nopswd2", 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);
				} catch (Exception e) {
					e.printStackTrace();
					errors.add("nonum", new ActionMessage("office.person.telnotnum.error"));
				    mark=false;
				}
			}
			if (!mark) {
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			if (!password1.equals(password2)) {
				errors.add("nosame", new ActionMessage("office.person.password.nosame.error"));
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			String sql = "update " + Content.TB_USER + " set "
					+ Content.USERTRUENAME + "='" + truename + "',"
					+ Content.USERABLE + "=" + able + "," + Content.USERGOOD
					+ "='" + usergood + "'," + Content.USERBRANCH + "='"
					+ branch + "'," + Content.USERJOB + "='" + job + "',"
					+Content.USERPASSWORD+"='"+password1+"',"
					+ Content.USERSEX + "='" + sex + "'," + Content.USEREMAIL
					+ "='" + email + "'," + Content.USERTEL + "='" + tel + "',"
					+ Content.USERADDRESS + "='" + address + "' where "+Content.USERNAME+"='"+username+"'";
		    DB db=new DB();
		    int i=db.update(sql);
		    if(i==0){
		    	errors.add("updaeR",new ActionMessage("office.update.false"));
		    	saveErrors(request,errors);
		    	return mapping.findForward("false");
		    }
		}
		return mapping.findForward("success");
	}

	public ActionForward executeMyUpdate(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) {
		ActionMessages errors=new ActionMessages();
		HttpSession session=request.getSession();
		session.setAttribute("selectmenu2", "person_myself");
		LogonForm myform=(LogonForm)form;
		String updatetype = request.getParameter("updatetype");
		if (updatetype == null || updatetype.equals(""))
			updatetype = "link";
		if (updatetype.equals("link")) {
			LogonForm logonform=(LogonForm)session.getAttribute("logonuser");			
			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("update");
		}

		if (updatetype.equals("update")) {
						
			boolean mark = true;
			String username = myform.getUsername();
			String password1 = myform.getUserpassword();
			String password2 = myform.getUseraginpassword();
			String truename = myform.getUsertruename();
			String tel = myform.getUsertel();
			String address = myform.getUseraddress();
			String sex = myform.getUsersex();
			String job = myform.getUserjob();
			int able = myform.getUserable();
			String branch = myform.getUserbranch();
			String usergood = myform.getUsergood();
			String email = myform.getUseremail();

			if (password1 == null || password1.equals("")) {
				mark = false;
				errors.add("nopswd1", new ActionMessage("office.person.nopassword1.error"));
			}
			if (password2 == null || password2.equals("")) {
				mark = false;
				errors.add("nopswd2", 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);
				} catch (Exception e) {
					e.printStackTrace();
					errors.add("nonum", new ActionMessage("office.person.telnotnum.error"));
				    mark=false;
				}
			}
			if (!mark) {
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			if (!password1.equals(password2)) {
				errors.add("nosame", new ActionMessage("office.person.password.nosame.error"));
				saveErrors(request, errors);
				return mapping.findForward("false");
			}
			String sql = "update " + Content.TB_USER + " set "
					+ Content.USERTRUENAME + "='" + truename + "',"
					+ Content.USERABLE + "=" + able + "," + Content.USERGOOD
					+ "='" + usergood + "'," + Content.USERBRANCH + "='"
					+ branch + "'," + Content.USERJOB + "='" + job + "',"
					+Content.USERPASSWORD+"='"+password1+"',"
					+ Content.USERSEX + "='" + sex + "'," + Content.USEREMAIL
					+ "='" + email + "'," + Content.USERTEL + "='" + tel + "',"
					+ Content.USERADDRESS + "='" + address + "' where "+Content.USERNAME+"='"+username+"'";
		    DB db=new DB();
		    int i=db.update(sql);
		    if(i==0){
		    	errors.add("updateR",new ActionMessage("office.update.false"));
		    	saveErrors(request,errors);
		    	return mapping.findForward("false");
		    }
		}
		errors.add("updateR",new ActionMessage("office.update.success.logon.agin"));
		saveErrors(request,errors);
		return mapping.findForward("success");
	}

	public ActionForward executePersonDel(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");
		}
		
		String id1 = request.getParameter("id");
		if (id1 == null || id1.equals(""))
			id1 = "0";
		int id = Change.strtoint(id1);
		String sql = "delete from " + Content.TB_USER + " where "
				+ Content.USERID + "=" + id;
		DB db = new DB();
		int i = db.del(sql);
		if (i == 0) {
			errors = new ActionMessages();
			errors.add("deleteR", new ActionMessage("office.del.false"));
			saveErrors(request, errors);
			return mapping.findForward("false");
		}
		return mapping.findForward("success");
	}
}