contractinfo.java

java阿里巴巴代码

			condao.setStart_date(start_date);
			condao.setEnd_date(end_date);
			condao.setCon_desc(con_desc);
			condao.setPublish_date(publish_date);
			condao.setUser_id(user_id);
			condao.setRemark(remark);

			iResult = modifyConTractList(condao);
		} catch (Exception 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("退出modifyConTractList方法...");
	}

	public int modifyConTractList(ContractDAO condao)
			throws SaasApplicationException {

		ContractExt conExt = new ContractExt();
		conExt.setParam(":VCUST_ID", condao.getCust_id());
		conExt.setParam(":VCON_ID", condao.getCon_id());
		conExt.setParam(":VCON_NAME", condao.getCon_name());
		conExt.setParam(":VOBJ_CUST_NAME", condao.getObj_cust_name());
		conExt.setParam(":VPROJ_NAME", condao.getProj_name());
		conExt.setParam(":VSTATE_CODE", condao.getState_code());
		conExt.setParam(":VCON_CLASS", condao.getCon_class());
		conExt.setParam(":VSTATE_CODE_DATE", condao.getState_code_date());
		conExt.setParam(":VCON_TYPE", condao.getCon_type());
		conExt.setParam(":VCON_EXCUT_WAY", condao.getCon_excut_way());
		conExt.setParam(":VFARE_WAY", condao.getFare_way());
		conExt.setParam(":VPAY_TYPE", condao.getPay_type());
		conExt.setParam(":VCURRENCY", condao.getCurrency());
		conExt.setParam(":VCON_SIGN_FARE", condao.getCon_sign_fare());
		conExt.setParam(":VCON_FARE", condao.getCon_fare());
		conExt.setParam(":VSIGN_DATE", condao.getSign_date());
		conExt.setParam(":VCON_OBJECT", condao.getCon_object());
		conExt.setParam(":VSTART_DATE", condao.getStart_date());
		conExt.setParam(":VEND_DATE", condao.getEnd_date());
		conExt.setParam(":VCON_DESC", condao.getCon_desc());
		conExt.setParam(":VPUBLISH_DATE", condao.getPublish_date());
		conExt.setParam(":VUSER_ID", condao.getUser_id());
		conExt.setParam(":VREMARK", condao.getRemark());

		tradeQuery.executeBy(conExt.insBy("UP_CON_BY_TRACT"));
		return 0;
	}

	public void DelConList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入DelConList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String con_id = inbuffer.getString("CON_ID");
		try {
			ContractDAO contractdao = new ContractDAO();
			contractdao.setCust_id(cust_id);
			contractdao.setCon_id(con_id);

			iResult = DelConList(contractdao);
		} catch (Exception 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("退出DelConList方法...");
	}

	public int DelConList(ContractDAO condao) throws SaasApplicationException {

		ContractExt conExt = new ContractExt();
		conExt.setParam(":VCUST_ID", condao.getCust_id());
		conExt.setParam(":VCON_ID", condao.getCon_id());

		tradeQuery.executeBy(conExt.insBy("DEL_CON_BY_TRACT"));
		return 0;
	}

	public ArrayList getListByConId(String cust_id, String con_id)
			throws SaasApplicationException {

		ContractExt chriExt = new ContractExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VCON_ID", con_id);
		ArrayList list = chriExt.selByList("SEL_BY_CON_ID");
		return list;
	}
	
	
	public String getEndDateByConId(String cust_id, String con_id)
		throws SaasApplicationException {

		ContractExt chriExt = new ContractExt();
		chriExt.setParam(":VCUST_ID", cust_id);
		chriExt.setParam(":VCON_ID", con_id);
		ArrayList list = chriExt.selByList("SEL_BY_CON_ID");
		String end_date="";
		if(list!=null&&list.size()>0){
			HashMap map = (HashMap)list.get(0);
			if(map.get("end_date")!=null){
				end_date = map.get("end_date").toString();
			}
		}
		return end_date;
	}
	
	//取出所有合同
	public ArrayList getConStateList(int iStart, String cust_id)
			throws SaasApplicationException {

		iStart=iStart*20;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = coniExt.selByList("SEL_BY_CON_STATE", iStart, 20);
		return list;
	}
	

	public int getConStateList(String cust_id) throws SaasApplicationException {
		int count = 0;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		ArrayList list = coniExt.selByList("SEL_BY_CON_STATE");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}
	
	//取出已执行合同进行状态更改
	public ArrayList getConStateList1(int iStart, String cust_id,
			String state_code) throws SaasApplicationException {

		iStart=iStart*20;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		coniExt.setParam(":VSTATE_CODE", state_code);
		ArrayList list = coniExt.selByList("SEL_BY_CONSTATE", iStart, 20);
		return list;
	}

	public int getConStateList1(String cust_id, String state_code)
			throws SaasApplicationException {
		int count = 0;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		coniExt.setParam(":VSTATE_CODE", state_code);
		ArrayList list = coniExt.selByList("SEL_BY_CONSTATE");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}

	// 修改合同状态
	public void modifyConStateList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("进入modifyConStateList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String con_id = inbuffer.getString("CON_ID");
		String state_code = inbuffer.getString("STATE_CODE");
		String user_id = inbuffer.getString("SESSION_USER_ID");

		try {
			ContractDAO condao = new ContractDAO();
			condao.setCust_id(cust_id);
			condao.setCon_id(con_id);
			condao.setState_code(state_code);
			condao.setUser_id(user_id);

			iResult = modifyConStateList(condao);
		} catch (Exception 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("退出modifyConTractList方法...");
	}

	public int modifyConStateList(ContractDAO condao)
			throws SaasApplicationException {

		ContractExt conExt = new ContractExt();
		conExt.setParam(":VCUST_ID", condao.getCust_id());
		conExt.setParam(":VCON_ID", condao.getCon_id());
		conExt.setParam(":VSTATE_CODE", condao.getState_code());
		conExt.setParam(":VUSER_ID", condao.getUser_id());

		tradeQuery.executeBy(conExt.insBy("UP_CON_BY_STATE"));
		return 0;
	}
	
	public ArrayList getContractByView(String sign_date,String sign_date1,String cust_id,String con_name,
			String state_code,String con_type,String con_excut_way,
			String con_class,String con_object,int iStart) throws SaasApplicationException {
		
		iStart=iStart*20;
	
//		log.LOG_INFO("=========="+sign_date+"===========");
//		log.LOG_INFO("=========="+sign_date1+"===========");
		ArrayList list = new ArrayList();
		ContractExt conExt = new ContractExt();
		conExt.setParam(":VCUST_ID", cust_id);
		conExt.setParam(":VCON_NAME", "%"+con_name+"%");
		conExt.setParam(":VSTATE_CODE", "%"+state_code+"%");
		conExt.setParam(":VCON_TYPE", "%"+con_type+"%");
		conExt.setParam(":VCON_EXCUT_WAY", "%"+con_excut_way+"%");
		conExt.setParam(":VCON_CLASS", "%"+con_class+"%");
		conExt.setParam(":VSIGN_DATE", "%"+sign_date+"%");
		conExt.setParam(":VSIGN_DATE_T", "%"+sign_date1+"%");
		conExt.setParam(":VCON_OBJECT", "%"+con_object+"%");
		list = conExt.selByList("SEL_CONTRACT_BY_VIEW",iStart, 20);
//		log.LOG_INFO("开始执行SQL：=============="+conExt.selByList("SEL_CONTRACT_BY_VIEW",iStart, 20)+"==========");
		return list;
	} 
	
	public int getContractByView(String sign_date,String sign_date1,String cust_id,String con_name,
			String state_code,String con_type,String con_excut_way,
			String con_class,String con_object) throws SaasApplicationException {
		int count = 0;
		ArrayList list = new ArrayList();
		ContractExt conExt = new ContractExt();
		conExt.setParam(":VCUST_ID", cust_id);
		conExt.setParam(":VCON_NAME", "%"+con_name+"%");
		conExt.setParam(":VSTATE_CODE", "%"+state_code+"%");
		conExt.setParam(":VCON_TYPE", "%"+con_type+"%");
		conExt.setParam(":VCON_EXCUT_WAY", "%"+con_excut_way+"%");
		conExt.setParam(":VCON_CLASS", "%"+con_class+"%");
		conExt.setParam(":VSIGN_DATE", "%"+sign_date+"%");
		conExt.setParam(":VSIGN_DATE_T", "%"+sign_date1+"%");
		conExt.setParam(":VCON_OBJECT", "%"+con_object+"%");
		list = conExt.selByList("SEL_CONTRACT_BY_VIEW");
		if(list!=null && list.size()>0){
			count = list.size();
		}
		return count;
	} 
	
}