serverinfo.java

java阿里巴巴代码

	public ArrayList getServerByCode6(String param_Attr) throws SaasApplicationException {

		ArrayList servlist = new ArrayList();
		
		CommparaExt comExt = new CommparaExt();
		comExt.setParam(":VPARAM_ATTR", param_Attr);
		ArrayList list = comExt.selByList("SEL_BY_ATTR");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap map = (HashMap) list.get(i);
				String para_code6 = "";
				String serverName = "";
				String serverId = "";
				if (map.get("para_code6") != null) {
					para_code6 = map.get("para_code6").toString();
					if (para_code6 == "1" || para_code6.equals("1")) {
						serverId = map.get("para_code1").toString();
						serverName = map.get("para_code2").toString();
						HashMap svcmap = new HashMap();
						svcmap.put("serverId", serverId);
						svcmap.put("serverName", serverName);
						servlist.add(svcmap);
					}
				}
			}
		}
		return servlist;
	}
	
	
	
	// 取得服务代码
	
	// 删除服务
	public void delServerInfo(Buffers inbuffer) {

		log.LOG_INFO("进入delServerInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		ServerDAO serverDao = new ServerDAO();
		try {
			String cust_id = inbuffer.getString("CUST_ID");
			String rsrv_str1 = inbuffer.getString("B2B");
			String rsrv_str2 = inbuffer.getString("COM");
			String rsrv_str3 = inbuffer.getString("OA");
			String rsrv_str4 = inbuffer.getString("BSS");
			String rsrv_str5 = inbuffer.getString("HRM");
			String rsrv_str6 = inbuffer.getString("CRM");
			String rsrv_str7 = inbuffer.getString("SERVER_NAME");// 订购服务名称
			String staff_id = inbuffer.getString("SESSION_USER_ID");
			String remark = inbuffer.getString("V_AMOUNT");// 存放总金额
			serverDao.setCust_id(cust_id);
			serverDao.setRsrv_str1(rsrv_str1);
			serverDao.setRsrv_str2(rsrv_str2);
			serverDao.setRsrv_str3(rsrv_str3);
			serverDao.setRsrv_str4(rsrv_str4);
			serverDao.setRsrv_str5(rsrv_str5);
			serverDao.setRsrv_str6(rsrv_str6);
			serverDao.setRsrv_str7(rsrv_str7);
			serverDao.setStaff_id(staff_id);
			serverDao.setRemark(remark);
			iResult = delServerInfo(serverDao);
		}
		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("退出delServerInfo方法...");
	}
	
	
	public int delServerInfo(ServerDAO serverDao) throws SaasApplicationException {

		ServerExt servExt = new ServerExt();
		servExt.setParam(":VSERVER_ID", serverDao.getServer_id());
		servExt.setParam(":VSTART_DATE", serverDao.getStart_date());
		servExt.setParam(":VEND_DATE", serverDao.getEnd_date());
		servExt.setParam(":VSTAFF_ID", serverDao.getStaff_id());
		servExt.setParam(":VSTATE_CODE", serverDao.getState_code());
		servExt.setParam(":VREMARK", serverDao.getRemark());
		tradeQuery.executeBy(servExt.insBy("DEL_BY_IDX"));
		return 0;
	}
	
	
	
	// 取出服务
	public ArrayList getServersByIdx(String idx) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ServerExt servExt = new ServerExt();
		servExt.setParam(":VSERVER_ID", idx);
		list = servExt.selByList("SEL_BY_ID");
		return list;
	}
	
	
	
	// 取出服务
	public ArrayList getServersByCustId(String cust_id, String state) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ServerExt servExt = new ServerExt();
		servExt.setParam(":VCUST_ID", cust_id);
		servExt.setParam(":VSTATE_CODE", state);
		list = servExt.selByList("SEL_BY_CUST");
		return list;
	}
	
	
	
	// 取出服务
	public ArrayList getServerByID(String cust_id, String server_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ServerExt servExt = new ServerExt();
		servExt.setParam(":VCUST_ID", cust_id);
		servExt.setParam(":VSERVER_ID", server_id);
		list = servExt.selByList("SEL_BY_PK");
		return list;
	}
	
	
	
	/**
	 * 检测服用户的服务是否到期 0：正常；1：欠费封锁；2：注销；3：试用
	 * 
	 * @param cust_id
	 * @return
	 * @throws Exception
	 * @throws SaasApplicationException
	 */
	
	public void checkUserServer(String cust_id) throws Exception {

		ArrayList list = new ArrayList();
		ServerExt servExt = new ServerExt();
		servExt.setParam(":VCUST_ID", cust_id);
		list = servExt.selByList("SEL_CHECK_SERVER");
		String msg = "";
		try {
			if (list != null && list.size() > 0) {
				HashMap map = (HashMap) list.get(0);
				String state_code = map.get("state_code").toString();
				if (state_code.equals("3") || state_code.equals("3")) {
					log.LOG_INFO("正常");
				}
				else if (state_code == "1" || state_code.equals("1")) {
					msg = "服务欠费，帐号被封锁！请续交费用！";
					throw new RuntimeException(msg);
				}
				else if (state_code == "2" || state_code == "2") {
					msg = "对不起，该帐号已被注销！请与管理员联系！";
					throw new RuntimeException(msg);
				}
			}
			else {
				msg = "不可预知的错误，请刷新页面后，重试！";
				throw new RuntimeException(msg);
			}
		}
		catch (Exception e) {
			throw new RuntimeException(msg);
		}
	}
	
	
	
	// 网银业务办理成功时修改其状态
	public void updateOrDelete(Buffers inbuffer) {

		log.LOG_INFO("进入delServerInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		try {
			String contract_no = inbuffer.getString("CONTRACT_NO");
			int result_code = inbuffer.getInt("RESULT_CODE");
			String v_amount = inbuffer.getString("ACCOUNT_MONEY");
			String account_name = inbuffer.getString("ACCOUNT_NAME");
			String cust_id = inbuffer.getString("SESSION_CUST_ID");
			String userId = inbuffer.getString("SESSION_USER_ID");
			iResult = updateOrDelete(cust_id, result_code, v_amount, contract_no, account_name, userId);
		}
		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("退出delServerInfo方法...");
	}
	
	
	public int updateOrDelete(String cust_id, int result_code, String v_amount, String contract_no, String account_name, String userId) throws SaasApplicationException {

		log.LOG_INFO(cust_id + "}{" + result_code + "}{" + contract_no + "}");
		if (result_code == 20) {// 办理成功
			ArrayList webList = getServerByID(cust_id, contract_no);
			ArrayList list = getCustSerevicByCustId(cust_id);// 取出客户所有服务
			if (list != null && list.size() > 0) {
				for (int i = 0; i < list.size(); i++) {
					HashMap map = (HashMap) list.get(i);
					String server_code = "", end_date = "";
					if (map.get("server_id") != null) {
						server_code = map.get("server_id").toString();
					}
					if (map.get("end_date") != null) {
						end_date = map.get("end_date").toString();
						if (end_date.length() > 10) {
							end_date = end_date.substring(0, 10);
						}
					}
					if (webList != null && webList.size() > 0) {
						for (int j = 0; j < webList.size(); j++) {
							HashMap w_map = (HashMap) webList.get(j);
							String w_code = "", w_date = "";
							if (w_map.get("rsrv_str10") != null) {
								w_code = w_map.get("rsrv_str10").toString();
							}
							if (w_map.get("end_date") != null) {
								w_date = w_map.get("end_date").toString();
								if (w_date.length() > 10) {
									w_date = w_date.substring(0, 10);
								}
							}
							if (w_code == server_code || w_code.equalsIgnoreCase(server_code)) {
								ServerExt servExt = new ServerExt();
								servExt.setParam(":VCUST_ID", cust_id);
								servExt.setParam(":VSERVER_ID", server_code);
								String w_end_date = getDayMinusSResutlt(end_date, format.format(new Date()));
								w_end_date = getDateFormateAddDAY(w_date, Integer.parseInt(w_end_date));
								tradeQuery.executeBy(servExt.insBy("DEL_BY_CUST_ID"));
								ServerExt w_servExt = new ServerExt();
								w_servExt.setParam(":VCUST_ID", cust_id);
								w_servExt.setParam(":VSTATE_CODE", "4");
								w_servExt.setParam(":VSERVER_ID", contract_no);// 网上支付
								w_servExt.setParam(":VEND_DATE", w_end_date);
								tradeQuery.executeBy(w_servExt.insBy("UPDATE_BY_WEB"));
							}
						}
					}
				}
			}
			// 会员没有服务
			ServerExt servExt = new ServerExt();
			servExt.setParam(":VSERVER_ID", contract_no);
			servExt.setParam(":VCUST_ID", cust_id);
			servExt.setParam(":VSTATE_CODE", "4");
			servExt.setParam(":VRSRV_STR5", "w");// 网上支付
			tradeQuery.executeBy(servExt.insBy("EDIT_BY_WEB"));
		}
		return 0;
	}
	
	
	
	// 取得用户姓名
	public HashMap getCustIdByUserName(String name) throws SaasApplicationException {

		HashMap map = new HashMap();
		ArrayList list = new ArrayList();
		UserExt userExt = new UserExt();
		userExt.setParam(":VUSER_NAME", name);
		list = userExt.selByList("SEL_BY_NAME");
		if (list != null && list.size() > 0) {
			map = (HashMap) list.get(0);
		}
		return map;
	}
	
	
	
	// 取得客户订购的服务
	public ArrayList getCustSerevicByCustId(String cust_id) throws SaasApplicationException {

		ArrayList list = new ArrayList();
		ServerExt servExt = new ServerExt();
		servExt.setParam(":VCUST_ID", cust_id);
		list = servExt.selByList("SEL_BY_STR5");
		return list;
	}
	
	
	
	/**
	 * 人工缴费
	 * 
	 * @检测服用户的服务是否到期 0：正常；1：欠费封锁；2：注销；3：试用
	 * @param cust_id
	 * @return
	 * @throws Exception
	 * @throws SaasApplicationException
	 */
	
	public void addManualServerInfo(Buffers inbuffer) {

		log.LOG_INFO("进入addManualServerInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		ServerDAO serverDao = new ServerDAO();
		String value_id = inbuffer.getString("VALUE_ID");// 服务及其限
		String value_num = inbuffer.getString("VALUE_NUM");// 总费用
		String cust_id = inbuffer.getString("OBJ_CUST_ID");
		String staff_id = inbuffer.getString("SESSION_USER_ID");
		String account_id = inbuffer.getString("ACCOUNT_ID");
		try {
			serverDao.setCust_id(cust_id);
			serverDao.setState_code("0");// 服务状态
			serverDao.setStaff_id(staff_id);
			serverDao.setRsrv_str1(value_id);
			serverDao.setRsrv_str2(value_num);