planinfo.java

java阿里巴巴代码

			planDao.setRsrv_str6(rsrv_str6);
			planDao.setRsrv_str7(rsrv_str7);
			planDao.setRsrv_str8(rsrv_str8);
			planDao.setRsrv_str9(rsrv_str9);
			planDao.setRsrv_str10(rsrv_str10);
			planDao.setPlan_state(plan_state);
			planDao.setRemark(remark);
			planDao.setOper_user_id(oper_user_id);

			iResult = eidPlanInfo(planDao);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出eidPlanInfo方法...");
	}

	public int eidPlanInfo(PlanDAO planDao) throws SaasApplicationException {

		PlanExt planExt = new PlanExt();
		planExt.setParam(":VPLAN_ID", planDao.getPlan_id());
		planExt.setParam(":VCUST_ID", planDao.getCust_id());
		planExt.setParam(":VDEPART_CODE", planDao.getDepart_code());
		planExt.setParam(":VPLANNER_ID", planDao.getPlanner_id());
		planExt.setParam(":VPLANNER_NAME", planDao.getPlanner_name());
		planExt.setParam(":VTITLE", planDao.getTitle());
		planExt.setParam(":VSTART_DATE", planDao.getStart_date());
		planExt.setParam(":VEND_DATE", planDao.getEnd_date());
		planExt.setParam(":VPRIORITYS", planDao.getPrioritys());
		planExt.setParam(":VSECURITY", planDao.getSecurity());
		planExt.setParam(":VCONTENT", planDao.getContent());
		planExt.setParam(":VPLAN_CLASS", planDao.getPlan_class());
		planExt.setParam(":VRSRV_STR1", planDao.getRsrv_str1());
		planExt.setParam(":VRSRV_STR2", planDao.getRsrv_str2());
		planExt.setParam(":VRSRV_STR3", planDao.getRsrv_str3());
		planExt.setParam(":VRSRV_STR4", planDao.getRsrv_str4());
		planExt.setParam(":VRSRV_STR5", planDao.getRsrv_str5());
		planExt.setParam(":VPLAN_TYPE", planDao.getPlan_type());
		planExt.setParam(":VRSRV_STR6", planDao.getRsrv_str6());
		planExt.setParam(":VRSRV_STR7", planDao.getRsrv_str7());
		planExt.setParam(":VRSRV_STR8", planDao.getRsrv_str8());
		planExt.setParam(":VRSRV_STR9", planDao.getRsrv_str9());
		planExt.setParam(":VRSRV_STR10", planDao.getRsrv_str10());
		planExt.setParam(":VREMARK", planDao.getRemark());
		planExt.setParam(":VPLAN_STATE", planDao.getPlan_state());
		planExt.setParam(":VOPER_USER_ID", planDao.getOper_user_id());
		tradeQuery.executeBy(planExt.insBy("EDIT_BY_ALL"));
		return 0;
	}

	// 删除计划
	public void deletePlanInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入deletePlanInfo方法...");

		int iResult = -1;
		String plan_id = inbuffer.getString("PLAN_ID");
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		try {
			PlanDAO planDao = new PlanDAO();
			planDao.setPlan_id(plan_id);
			planDao.setCust_id(cust_id);
			planDao.setOper_user_id(oper_user_id);
			iResult = deletePlanInfo(planDao);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出deletePlanInfo方法...");
	}

	public int deletePlanInfo(PlanDAO planDao) throws SaasApplicationException {

		PlanExt planExt = new PlanExt();
		planExt.setParam(":VPLAN_ID", planDao.getPlan_id());
		planExt.setParam(":VCUST_ID", planDao.getCust_id());
		planExt.setParam(":VOPER_USER_ID", planDao.getOper_user_id());
		tradeQuery.executeBy(planExt.insBy("DEL_BY_ALL"));
		return 0;
	}

	// 找出同新录入或被打回,拒绝计划
	public ArrayList getPlanListByState(int iStart, String user_id,
			String state1, String state2, String state3)
			throws SaasApplicationException {

		iStart = iStart * 20;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VOPER_USER_ID", user_id);
		planExt.setParam(":VSTATE1", state1);
		planExt.setParam(":VSTATE2", state2);
		planExt.setParam(":VSTATE3", state3);
		ArrayList list = planExt.selByList("SEL_REGECT_NEW", iStart, 20);
		return list;
	}

	// 找出同新录入或被打回,拒绝计划总数
	public int getPlanCountByState(String user_id, String state1,
			String state2, String state3) throws SaasApplicationException {

		int size = 0;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VOPER_USER_ID", user_id);
		planExt.setParam(":VSTATE1", state1);
		planExt.setParam(":VSTATE2", state2);
		planExt.setParam(":VSTATE3", state3);
		ArrayList list = planExt.selByList("SEL_REGECT_NEW_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}

	// 找出计划
	public ArrayList getPlanListByOwn(int iStart, String user_id)
			throws SaasApplicationException {

		iStart = iStart * 20;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VOPER_USER_ID", user_id);
		ArrayList list = planExt.selByList("SEL_PLNA_OWN", iStart, 20);
		return list;
	}

	// 找出计划总数
	public int getPlanCountByOwn(String user_id)
			throws SaasApplicationException {

		int size = 0;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VOPER_USER_ID", user_id);
		ArrayList list = planExt.selByList("SEL_PLAN_BY_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}

	// 修改计划的状态
	public void updatePlanState(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入updatePlanState方法...");

		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String plan_id = inbuffer.getString("PLAN_ID");
		String plan_state = inbuffer.getString("PLAN_STATE");
		try {
			iResult = updatePlanState(plan_id, plan_state, cust_id,
					oper_user_id);
		} catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "业务处理失败！");

		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "业务处理成功！");
		}
		log.LOG_INFO("退出updatePlanState方法...");
	}

	public int updatePlanState(String plan_id, String plan_state,
			String cust_id, String oper_user_id)
			throws SaasApplicationException {

		PlanExt planExt = new PlanExt();
		planExt.setParam(":VPLAN_ID", plan_id);
		planExt.setParam(":VPLAN_STATE", plan_state);
		planExt.setParam(":VCUST_ID", cust_id);
		planExt.setParam(":VOPER_USER_ID", oper_user_id);
		tradeQuery.executeBy(planExt.insBy("UPDATE_BY_STATE"));
		return 0;
	}

	// 取出计划
	public HashMap getPlanInfoById(String plan_id)
			throws SaasApplicationException {

		PlanExt planExt = new PlanExt();
		planExt.setParam(":VPLAN_ID", plan_id);
		ArrayList list = planExt.selByList("SEL_BY_ID");
		HashMap map = new HashMap();
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}

	// 审批计划
	public ArrayList getPlanByAudit(int iStart, String dapart_code, String state)
			throws SaasApplicationException {

		iStart = iStart * 20;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VDEPART", dapart_code);
		planExt.setParam(":VPLAN_STATE", state);
//		log.LOG_INFO("=========" + planExt.insBy("SEL_BY_DEPART"));
		ArrayList list = planExt.selByList("SEL_BY_DEPART", iStart, 20);
		return list;
	}

	// 统计审批计划
	public int getPlanByAuditCt(String depart_code, String state)
			throws SaasApplicationException {

//		log.LOG_INFO("===depart_code=" + depart_code + "  state==" + state);
		int size = 0;
		PlanExt planExt = new PlanExt();
		planExt.setParam(":VDEPART", depart_code);
		planExt.setParam(":VPLAN_STATE", state);
		ArrayList list = planExt.selByList("SEL_DEPART_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
}