payplanaction.jsp

管理公司合同

<!--ACTION 动作控制JSP-->

<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="cn.com.juneng.system.common.BaseForm"%>
<%@ page import="cn.com.juneng.system.common.COMMON"%>
<%@ page import="cn.com.juneng.system.common.util.ValueObjectHelper"%>
<%@ page import="cn.com.juneng.payplan.service.PayplanService"%>
<%@ page import="cn.com.juneng.contract.service.ContractService"%>
<%@ page import="cn.com.juneng.payplan.vo.PayplanVOImpl"%>
<%@ page import="cn.com.juneng.contract.vo.ContractVOImpl"%>
<%@ page import="cn.com.juneng.system.common.SpringBeanFactory"%>
<%@ page import="cn.com.juneng.system.common.CommonService"%>
<%@ page import="cn.com.juneng.tixing.service.TixingService"%>
<%@ page import="cn.com.juneng.tixing.vo.TixingVOImpl"%>
<%@ page import="cn.com.juneng.contract.vo.ContractVOImpl" %>
<%@ page import="java.util.List"%>
<%@ page import="java.util.ArrayList"%>
<%@ include file="/common/inc/CommonAction.jsp"%>

<%!
	private ContractService contractService = (ContractService) SpringBeanFactory
			.getBean("contractService");

	private PayplanService payplanService = (PayplanService) SpringBeanFactory
			.getBean("payplanService");

	private String jspPath = "/payplan/";

	private String actionJsp = jspPath + "PayplanAction.jsp";

	private String listJsp = jspPath + "contractList.jsp";

	private String editJsp = jspPath + "ShowAll.jsp";

	private String innereditJsp = jspPath + "Edit.jsp";
	
	private String setplanJsp = jspPath + "setPlan.jsp";

	//列表
	public void list(HttpServletRequest request, HttpServletResponse response,
			BaseForm bForm) throws Exception {
		//根据传入参数构造查询条件语句
		String querySql = COMMON.getQuerySql(request);
		String orderSql = null;
		//排序
		if (!COMMON.isEmpty(bForm.getOrderCol())) {
			orderSql = "order by " + bForm.getOrderCol() + " "
					+ bForm.getOrder();
		}
		if (!COMMON.isEmpty(querySql)) {
			querySql += " and type=1 ";
		} else
			querySql += "  type=1 ";
		List list = contractService.getList(querySql, orderSql, bForm
				.getStartPos(), bForm.getRowCount());

		bForm.setTotalCount(contractService.getRowCount(querySql));
		request.setAttribute("List", list);
		request.setAttribute("BaseForm", bForm);
		pageForward(listJsp, request, response);
	}

	//初始化编辑页面
	public void init(HttpServletRequest request, HttpServletResponse response,
			BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		vo.setActionType("create");
		request.setAttribute("VO", vo);
		pageForward(editJsp, request, response);
	}

	//创建
	public void create(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		try {
			payplanService.create(vo);
			request.setAttribute("Message", "成功创建！");
			pageForward(actionJsp, request, response);
		} catch (Exception e) {
			request.setAttribute("Error", "创建失败：" + e.getMessage());
			request.setAttribute("VO", vo);
			pageForward(editJsp, request, response);
		}
	}

	//查看
	public void view(HttpServletRequest request, HttpServletResponse response,
			BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		ContractVOImpl contracVO = contractService
				.findByPrimaryKey(vo.getRid());
		List list = payplanService.getList(" contractid='" + vo.getRid() + "'",
				" order by plandate", 0, Integer.MAX_VALUE);
		if (!COMMON.isEmpty(list))
			vo = (PayplanVOImpl) list.get(0);
		else
			vo = new PayplanVOImpl();
		vo.setCurrentPage(bForm.getCurrentPage());
		vo.setActionType("save");
		request.setAttribute("List", list);
		request.setAttribute("VO", vo);
		request.setAttribute("contractVO", contracVO);
		pageForward(editJsp, request, response);
	}

	//保存
	public void save(HttpServletRequest request, HttpServletResponse response,
			BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		try {
			payplanService.update(vo);
			request.setAttribute("Message", "成功保存！");
			pageForward(actionJsp + "?currentPage=" + vo.getCurrentPage(),
					request, response);
		} catch (Exception e) {
			request.setAttribute("Error", "保存失败：" + e.getMessage());
			request.setAttribute("VO", vo);
			pageForward(editJsp, request, response);
		}
	}

	//编辑
	public void edit(HttpServletRequest request, HttpServletResponse response,
			BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		String hql = " contractid='" + vo.getContractid() + "'  ";
		List list = this.payplanService.getList(hql, "", 0, Integer.MAX_VALUE);
		if (COMMON.isEmpty(list)) {
			vo.setActionType("createBinfo");
		} else {
			vo = (PayplanVOImpl) list.get(0);
			vo.setActionType("saveBinfo");
		}
		request.setAttribute("VO", vo);
		pageForward(innereditJsp, request, response);
	}

	//编辑
	public void complexedit(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		String hql = " rid='" + vo.getRid() + "'  ";
		List list = this.payplanService.getList(hql, "", 0, Integer.MAX_VALUE);
		if (COMMON.isEmpty(list)) {
			vo.setActionType("createBinfo");
		} else {
			vo = (PayplanVOImpl) list.get(0);
			vo.setActionType("saveBinfo");
		}
		request.setAttribute("VO", vo);
		pageForward(innereditJsp, request, response);
	}

	//从合同信息创建
	public void createBinfo(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		ContractVOImpl contractVO = new ContractVOImpl();
		contractVO.setRid(vo.getContractid());
		contractVO.setCode(vo.getContractno());
		contractVO.setName(vo.getContractname());
		List list = null;
		try {
			payplanService.create(vo);
			request.setAttribute("info", "成功保存！");
			vo.setActionType("saveBinfo");
			request.setAttribute("VO", vo);
			list = payplanService.getList(" contractid='" + vo.getContractid()
					+ "'", " order by rid", 0, Integer.MAX_VALUE);
			request.setAttribute("contractVO", contractVO);
			request.setAttribute("List", list);
			pageForward(innereditJsp, request, response);
		} catch (Exception e) {
			request.setAttribute("Error", "创建失败：" + e.getMessage());
			request.setAttribute("VO", vo);
			list = payplanService.getList(" contractid='" + vo.getContractid()
					+ "'", " order by rid", 0, Integer.MAX_VALUE);
			request.setAttribute("contractVO", contractVO);
			request.setAttribute("List", list);
			pageForward(innereditJsp, request, response);
		}
	}

	//从合同信息保存
	public void saveBinfo(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		ContractVOImpl contractVO = new ContractVOImpl();
		contractVO.setRid(vo.getContractid());
		contractVO.setCode(vo.getContractno());
		contractVO.setName(vo.getContractname());
		List list = null;
		try {
			payplanService.update(vo);
			request.setAttribute("info", "成功保存！");
			vo.setActionType("saveBinfo");
			request.setAttribute("VO", vo);
			list = payplanService.getList(" contractid='" + vo.getContractid()
					+ "'", " order by rid", 0, Integer.MAX_VALUE);
			request.setAttribute("contractVO", contractVO);
			request.setAttribute("List", list);
			pageForward(innereditJsp, request, response);
		} catch (Exception e) {
			request.setAttribute("Error", "保存失败：" + e.getMessage());
			request.setAttribute("VO", vo);
			list = payplanService.getList(" contractid='" + vo.getContractid()
					+ "'", " order by rid", 0, Integer.MAX_VALUE);
			request.setAttribute("contractVO", contractVO);
			request.setAttribute("List", list);
			pageForward(innereditJsp, request, response);
		}
	}

	//保存
	public void moreSave(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		String[] batchnos = request.getParameterValues("batchno");
		String[] tmp3s = request.getParameterValues("tmp3");
		String[] percenges = request.getParameterValues("percenge");
		String[] paysums = request.getParameterValues("paysum");
		String[] paytypes = request.getParameterValues("paytype");
		String[] receivers = request.getParameterValues("receiver");
		String[] plandates = request.getParameterValues("plandate");
		String[] tmp4s = request.getParameterValues("tmp4");
		List payPlan = new ArrayList();
		for (int i = 0; i < batchnos.length; i++) {
			PayplanVOImpl planvo = new PayplanVOImpl();
			planvo.setContractid(vo.getContractid());
			planvo.setContractno(vo.getContractno());
			planvo.setContractname(vo.getContractname());
			planvo.setTmp1("1");
			planvo.setFlag("0");//计划未完成
			if (!COMMON.isEmpty(batchnos[i]))
				planvo.setBatchno(batchnos[i]);

			if (!COMMON.isEmpty(tmp3s[i]))
				planvo.setTmp3(tmp3s[i]);

			if (!COMMON.isEmpty(percenges[i]))
				planvo.setPercenge(percenges[i]);

			if (!COMMON.isEmpty(paysums[i]))
				planvo.setPaysum(new Double(paysums[i]));

			if (!COMMON.isEmpty(paytypes[i]))
				planvo.setPaytype(paytypes[i]);

			if (!COMMON.isEmpty(receivers[i]))
				planvo.setReceiver(receivers[i]);

			if (!COMMON.isEmpty(plandates[i]))
				planvo.setPlandate(COMMON.strToTimestamp(plandates[i]));

			if (!COMMON.isEmpty(tmp4s[i]))
				planvo.setTmp4(tmp4s[i]);
			payPlan.add(planvo);
		}
		//删除原有的计划
		List list = payplanService.getList(" contractid='" + vo.getContractid()
				+ "'  ", "", 0, Integer.MAX_VALUE);
		String[] payids = null;
		if (!COMMON.isEmpty(list) && list.size() > 0) {
			payids = new String[list.size()];
			PayplanVOImpl planvo = null;
			for (int i = 0; i < list.size(); i++) {
				planvo = (PayplanVOImpl) list.get(i);
				payids[i] = planvo.getRid();
			}
		}
		//删除计划对应的提醒记录 
		String[] tixiIds = null;
		TixingService tixingService = (TixingService) SpringBeanFactory
					.getBean("tixingService");
		if (!COMMON.isEmpty(payids) && payids.length > 0) {
			String paystr = "";
			for (int i = 0; i < payids.length; i++)
				paystr += "'" + payids[i] + "',";
			if (!COMMON.isEmpty(paystr) && paystr.length() > 1)
				paystr = paystr.substring(0, paystr.length()-1);
			
			List tixinlist = tixingService.getList(" ryid in (" + paystr+ ") ", "", 0, Integer.MAX_VALUE);
			if (!COMMON.isEmpty(tixinlist) && tixinlist.size() > 0) {
				tixiIds = new String[tixinlist.size()];
				for (int j = 0; j < tixinlist.size(); j++)
					tixiIds[j] = ((TixingVOImpl) tixinlist.get(j)).getRid();
			  	
		  }	
		}  
		
		//先删除后保存      
		try {
			//删除计划对应的提醒记录 
			if (!COMMON.isEmpty(tixiIds) && tixiIds.length > 0)
				tixingService.remove(tixiIds);
			
			//删除计划
			if (!COMMON.isEmpty(payids) && payids.length > 0)
				payplanService.remove(payids);
			CommonService commonsrv = (CommonService) SpringBeanFactory	.getBean("commonService");
			commonsrv.batchSave(payPlan);
			//更新合同相关的计划数据
			ContractVOImpl contractvo=contractService.findByPrimaryKey(vo.getContractid());
			contractvo.setTmp4(""+batchnos.length);
			request.setAttribute("info", "成功保存！");
			contractService.update(contractvo);
			pageForward(setplanJsp + "?rid="+vo.getContractid()+"&count="+batchnos.length,
					request, response);
		} catch (Exception e) {
			request.setAttribute("Error", "保存失败：" + e.getMessage());
			request.setAttribute("VO", vo);
			pageForward(editJsp, request, response);
		}
	}

	//复合页面初始化编辑页面
	public void complexInit(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		vo.setActionType("createBinfo");
		request.setAttribute("VO", vo);
		pageForward(innereditJsp, request, response);
	}

	//复合页面删除
	public void complexdelete(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		PayplanVOImpl vo = (PayplanVOImpl) bForm;
		String[] Ids = request.getParameterValues("Ids");
		//删除计划对应的提醒记录 
		String[] tixiIds = null;
		TixingService tixingService = (TixingService) SpringBeanFactory
					.getBean("tixingService");
		if (!COMMON.isEmpty(Ids) && Ids.length > 0) {
			String paystr = "";
			for (int i = 0; i < Ids.length; i++)
				paystr += "'" + Ids[i] + "',";
			if (!COMMON.isEmpty(paystr) && paystr.length() > 1)
				paystr = paystr.substring(0, paystr.length()-1);
			
			List tixinlist = tixingService.getList(" ryid in (" + paystr+ ") ", "", 0, Integer.MAX_VALUE);
			if (!COMMON.isEmpty(tixinlist) && tixinlist.size() > 0) {
				tixiIds = new String[tixinlist.size()];
				for (int j = 0; j < tixinlist.size(); j++)
					tixiIds[j] = ((TixingVOImpl) tixinlist.get(j)).getRid();
			  	
		  }	
		}  
		//删除计划对应的提醒记录 
		if (!COMMON.isEmpty(tixiIds) && tixiIds.length > 0)
				tixingService.remove(tixiIds);
		payplanService.remove(Ids);
		request.setAttribute("info", "成功删除！");
		String contractid = request.getParameter("contractid");
		ContractVOImpl contracVO = contractService.findByPrimaryKey(contractid);
		List list = this.payplanService.getList(" contractid='" + contractid
				+ "'", "order by rid desc ", 0, Integer.MAX_VALUE);
		if (COMMON.isEmpty(list)) {
			vo = new PayplanVOImpl();
		} else
			vo = (PayplanVOImpl) list.get(0);
		request.setAttribute("VO", vo);
		request.setAttribute("contractVO", contracVO);
		request.setAttribute("List", list);
		pageForward(editJsp, request, response);
	}

	//删除
	public void delete(HttpServletRequest request,
			HttpServletResponse response, BaseForm bForm) throws Exception {
		String[] ids = request.getParameterValues("Ids");
		payplanService.remove(ids);
		request.setAttribute("Message", "成功删除！");
		pageForward(actionJsp + "?currentPage=" + bForm.getCurrentPage(),
				request, response);
	}
%>
<%
request.setAttribute("ActionUrl", request.getContextPath()
					+ actionJsp);

			PayplanVOImpl vo = new PayplanVOImpl();
			ValueObjectHelper.fillObjectBean(vo, request);
			this.processRequest(request, response, vo);

		%>