moneyaction.java

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

				return mapping.findForward("false");
			}
		}
		
		errors.add("updateR",new ActionMessage("office.update.success"));
		saveErrors(request,errors);
		return mapping.findForward("success");
	}
	public ActionForward executeMoneyThingDel(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		ActionMessages errors=new ActionMessages();
		String thingid1=request.getParameter("id");
		 if(thingid1==null||thingid1.equals(""))thingid1="";
        int thingid=Change.strtoint(thingid1);
		String sql="delete from "+Content.TB_THING+" where "+Content.THINGID+"="+thingid;
	    DB db=new DB();
	    int i=db.del(sql);
	    if(i==0){
	    	errors.add("deleteR",new ActionMessage("office.del.false"));
	    	saveErrors(request,errors);
	    	return mapping.findForward("false");
	    }
		return mapping.findForward("success");
	}
	
	public ActionForward executeMoneyCarLook(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		HttpSession session=request.getSession();
		ActionMessages errors=new ActionMessages();
		session.setAttribute("selectmenu2", "money_cars");
		session.setAttribute("selectmenu3", "money_cars_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_CAR;
		}
	    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_CAR+" where "+subsql+"='"+subsqlvalue+"'";
	    }
		searchform.setSubsqlvalue(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 carlist=db.getallcarlist(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("carlist", carlist);
		
		return mapping.findForward("success");
	}
	public ActionForward executeMoneyCarSigleLook(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		HttpSession session=request.getSession();
		MoneyCarForm moneycarform=(MoneyCarForm)form; 
		String lookid1=request.getParameter("id");
		 if(lookid1==null||lookid1.equals(""))lookid1="0";
		int lookid=Change.strtoint(lookid1);
		
		ArrayList carlist=(ArrayList)session.getAttribute("carlist");
		boolean flag=false;		
		for(int i=0;i<carlist.size();i++){
			MoneyCarForm carsigleform=(MoneyCarForm)carlist.get(i);
			if(lookid==carsigleform.getCarid()){
				flag=true;
				moneycarform.setNumber(carsigleform.getNumber());
	    		moneycarform.setModel(carsigleform.getModel());
	    		moneycarform.setFdj(carsigleform.getFdj());
	    		moneycarform.setDriver(carsigleform.getDriver());
	    		moneycarform.setMaker(carsigleform.getMaker());
	    		moneycarform.setBuytime(carsigleform.getBuytime());
	    		moneycarform.setStatus(carsigleform.getStatus());
	    		moneycarform.setNjinfo(carsigleform.getNjinfo());
	    		moneycarform.setInfo(carsigleform.getInfo());
			    break;
			}
		}
		if(!flag){
			ActionMessages errors=new ActionMessages();
			errors.add("lookR",new ActionMessage("office.money.car.look.sigle.error"));
			saveErrors(request,errors);
			return mapping.findForward("looksiglewrong");
		}
		return mapping.findForward("success");
	}
	public ActionForward executeMoneyCarAdd(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		ActionMessages errors=new ActionMessages();
		HttpSession session=request.getSession();
		session.setAttribute("selectmenu3", "money_cars_add");
		MoneyCarForm moneycarform=(MoneyCarForm)form;
		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 number=moneycarform.getNumber();
			String model=moneycarform.getModel();
			String fdj=moneycarform.getFdj();
			String driver=moneycarform.getDriver();
			String maker=moneycarform.getMaker();
			String buytime=moneycarform.getBuytime();
			String status=moneycarform.getStatus();
			String njinfo=moneycarform.getNjinfo();
			String info=moneycarform.getInfo();
		
			if(number==null||number.equals("")){
				mark=false;
				errors.add("nonum",new ActionMessage("office.money.car.nonumber.error"));
			}
			if(model==null||model.equals("")){
				mark=false;
				errors.add("nomodel",new ActionMessage("office.money.car.nomodel.error"));
			}
			if(fdj==null||fdj.equals("")){
				mark=false;
				errors.add("nofdj",new ActionMessage("office.money.car.nofdj.error"));
			}
			if(driver==null||driver.equals("")){
				mark=false;
				errors.add("nodriver",new ActionMessage("office.money.car.nodriver.error"));
			}
			if(maker==null||maker.equals("")){
				mark=false;
				errors.add("nomaker",new ActionMessage("office.money.car.nomaker.error"));
			}
			if(buytime==null||buytime.equals("")){
				mark=false;
				errors.add("nobuytime",new ActionMessage("office.money.car.nobuytime.error"));
			}
			if(njinfo==null||njinfo.equals("")){
                mark=false;			
				errors.add("nonjinfo",new ActionMessage("office.money.car.nonjinfo.error"));
			}
			if(info==null||info.equals("")){
			    mark=false;
			    errors.add("noinfo",new ActionMessage("office.money.car.noinfo.error"));
			}
			if(!mark){
				saveErrors(request,errors);
				return mapping.findForward("false");
			}
			
			String timeerrors=Change.checkdate(buytime);
		    if(!timeerrors.equals("success")){
				errors.add("timeE",new ActionMessage(timeerrors));
			    saveErrors(request,errors);
			    return mapping.findForward("false");
			}			
			String sql="insert into "+Content.TB_CAR+" values('"+number+"','"+model+"','"+fdj+"','"+driver+"','"+maker+"','"+buytime+"','"+status+"','"+njinfo+"','"+info+"')";
			System.out.println(sql);
			DB db=new DB();
			int i=db.inseart(sql);
			if(i==0){
				errors.add("addR",new ActionMessage("office.insert.false"));
				saveErrors(request,errors);
				return mapping.findForward("false");
			}
		}
		moneycarform.clear();
		errors.add("addR",new ActionMessage("office.insert.success"));
		saveErrors(request,errors);
		return mapping.findForward("success");
	}

	public ActionForward executeMoneyCarUpdate(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		ActionMessages errors=new ActionMessages();
		HttpSession session=request.getSession();
		session.setAttribute("selectmenu3", "");
		MoneyCarForm moneycarform=(MoneyCarForm)form;
		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 carlist=(ArrayList)session.getAttribute("carlist");
			boolean flag=false;		
			for(int i=0;i<carlist.size();i++){
				MoneyCarForm carsigleform=(MoneyCarForm)carlist.get(i);
				if(lookid==carsigleform.getCarid()){
					flag=true;
					moneycarform.setNumber(carsigleform.getNumber());
		    		moneycarform.setModel(carsigleform.getModel());
		    		moneycarform.setFdj(carsigleform.getFdj());
		    		moneycarform.setDriver(carsigleform.getDriver());
		    		moneycarform.setMaker(carsigleform.getMaker());
		    		moneycarform.setBuytime(carsigleform.getBuytime());
		    		moneycarform.setStatus(carsigleform.getStatus());
		    		moneycarform.setNjinfo(carsigleform.getNjinfo());
		    		moneycarform.setInfo(carsigleform.getInfo());
				    break;
				}
			}
			if(!flag){
				errors.add("lookR",new ActionMessage("office.money.car.look.sigle.error"));
				saveErrors(request,errors);
				return mapping.findForward("false");
			}
			return mapping.findForward("update");
		}
		
		if(updatetype.equals("update")){
			boolean mark=true;
			String number=moneycarform.getNumber();
			String model=moneycarform.getModel();
			String fdj=moneycarform.getFdj();
			String driver=moneycarform.getDriver();
			String maker=moneycarform.getMaker();
			String buytime=moneycarform.getBuytime();
			String status=moneycarform.getStatus();
			String njinfo=moneycarform.getNjinfo();
			String info=moneycarform.getInfo();

			if(driver==null||driver.equals("")){
				mark=false;
				errors.add("nodriver",new ActionMessage("office.money.car.nodriver.error"));
			}
			if(maker==null||maker.equals("")){
				mark=false;
				errors.add("nomaker",new ActionMessage("office.money.car.nomaker.error"));
			}
			if(buytime==null||buytime.equals("")){
				mark=false;
				errors.add("nobuytime",new ActionMessage("office.money.car.nobuytime.error"));
			}
			if(njinfo==null||njinfo.equals("")){
                mark=false;			
				errors.add("nonjinfo",new ActionMessage("office.money.car.nonjinfo.error"));
			}
			if(info==null||info.equals("")){
			    mark=false;
			    errors.add("noinfo",new ActionMessage("office.money.car.noinfo.error"));
			}
			if(!mark){
				saveErrors(request,errors);
				return mapping.findForward("false");
			}
			

			String timeerrors=Change.checkdate(buytime);
		    if(!timeerrors.equals("success")){
				errors.add("timeE",new ActionMessage(timeerrors));
			    saveErrors(request,errors);
			    return mapping.findForward("false");
			}
		    String id=(String)session.getAttribute("id");
			String sql="update "+Content.TB_CAR+" set "+Content.CARDRIVER+"='"+driver+"',"+Content.CARMAKER+"='"+maker+"',"+Content.CARBUYTIME+"='"+buytime+"',"+Content.CARSTATUS+"='"+status+"',"+Content.CARNJ+"='"+njinfo+"',"+Content.CARINFO+"='"+info+"' where "+Content.CARID+"="+id;
			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"));
		saveErrors(request,errors);
		return mapping.findForward("success");
	}

	public ActionForward executeMoneyCarDel(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){
		String carid1=request.getParameter("id");
		 if(carid1==null||carid1.equals(""))carid1="0";
		int carid=Change.strtoint(carid1);
		String sql="delete from "+Content.TB_CAR+" where "+Content.CARID+"="+carid;
	    DB db=new DB();
	    int i=db.del(sql);
	    if(i==0){
	    	ActionMessages errors=new ActionMessages();
	    	errors.add("deleteR",new ActionMessage("office.del.false"));
	    	saveErrors(request,errors);
	    	return mapping.findForward("false");
	    }
		return mapping.findForward("success");
	}	
}