universalgs.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * 金包银、至尊双利产品管理
 */
package com.NCL;

import java.util.*;
import com.sinosoft.common.*;

public class UniversalGS{

	/**
	 * @param args
	 * @author feizhigao	 * 
	 */
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	protected String fValuationDate = "";
	protected String tValuationDate = "";
	protected String fRateAssueStartDate = "";
	protected String tRateAssueStartDate = "";
	protected String fRateAssueEndDate = "";
	protected String tRateAssueEndDate = "";
	protected String fRangeStartDate = "";
	protected String tRangeStartDate = "";
	protected String fRangeEndDate = "";
	protected String tRangeEndDate = "";
	protected String fMakeDate = "";
	protected String tMakeDate = "";
	/**
	 * 构造函数
	 *
	 */
	public UniversalGS(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ID");	                       	//自增长ID
		Property.add("RiskCode");					//险种代码
		Property.add("RiskName");					//险种名称
		Property.add("RateMonth");					//月度结算利率
		Property.add("RateYear");					//终了结算利率
		Property.add("RateAssue");					//保证利率
		Property.add("IsDisplay");					//是否发布 0未发布 1已发布
		Property.add("ValuationUnit");				//计价日单位
		Property.add("ValuationDate");				//公布日期
		Property.add("RateAssueStartDate");			//保证利率起期
		Property.add("RateAssueEndDate");			//保证利率止期
		Property.add("RangeStartDate");				//结算期间起期
		Property.add("RangeEndDate");				//结算期间止期
		Property.add("MakeDate");					//创建日期
	}
	/**
	 * 初始化
	 * @param ID 自增长ID
	 */
	public void Init(String ID){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from UniversalGS where ID=?";
		this.propList = d.init(sql,ID,this.Property);	
	}
	/**
	 * 创建
	 * @return boolean
	 */
	public boolean create(){
		DBAccess d = new DBAccess();
		String RateMonth = this.get("RateMonth");
		String RateYear = this.get("RateYear");
		String RateAssue = this.get("RateAssue");
		try{
			java.text.DecimalFormat df=new java.text.DecimalFormat("##0.00");
			RateMonth = df.format(Double.parseDouble(RateMonth));
			RateYear = df.format(Double.parseDouble(RateYear));
			RateAssue = df.format(Double.parseDouble(RateAssue));
		}catch(Exception e){
			e.printStackTrace();
		}
		this.set("RateMonth", RateMonth);
		this.set("RateYear", RateYear);
		this.set("RateAssue", RateAssue);
		String sql = "INSERT into UniversalGS values(UniversalGS_ID_SQE.nextval,?,?,?,?,?,?,?,to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),sysdate)";
		return d.execute(sql, this.propList);
	}
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean update(){
		StringBuffer sql = new StringBuffer("UPDATE UniversalGS set ");
		List l = new ArrayList();
		for(int i=0;i<strList.size();i++){
			Object[] strArray =(Object[]) strList.get(i);
			sql.append(strArray[0]);
			sql.append("=?,");
			l.add(strArray[1]);
		}
		sql.deleteCharAt(sql.lastIndexOf(","));
		sql.append(" where ID=?");
		l.add(this.get("ID"));
		strList.clear();
		DBAccess q = new DBAccess();
		return q.executeUpdate(sql.toString(),l);
	}
	
	/**
	 * 删除
	 * @param ID 自增长ID
	 * @return boolean
	 */
	public boolean delete(String ID){
		DBAccess DBA= new DBAccess();
		String sql = "DELETE from UniversalGS WHERE ID=?";		
		return DBA.executeDelete(sql,ID);
	}
	/**
	 * 根据条件查询
	 * @param I			对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return String
	 */
	public String find(UniversalGS I,int pageSize,int pageIndex){
		String result="";
		String ID = I.get("ID");
		String RiskCode = I.get("RiskCode");
		String RiskName = I.get("RiskName");
		String RateMonth = I.get("RateMonth");
		String RateYear = I.get("RateYear");
		String RateAssue = I.get("RateAssue");
		String IsDisplay = I.get("IsDisplay");
		String ValuationUnit = I.get("ValuationUnit");
		String fValuationDate = I.getfValuationDate();
		String tValuationDate = I.gettValuationDate();
		String fRateAssueStartDate = I.getfRateAssueStartDate();
		String tRateAssueStartDate = I.gettRateAssueStartDate();
		String fRateAssueEndDate = I.getfRateAssueEndDate();
		String tRateAssueEndDate = I.gettRateAssueEndDate();
		String fRangeStartDate = I.getfRangeStartDate();
		String tRangeStartDate = I.gettRangeStartDate();
		String fRangeEndDate = I.getfRangeEndDate();
		String tRangeEndDate = I.gettRangeEndDate();
		String fMakeDate = I.getfMakeDate();
		String tMakeDate = I.gettMakeDate();
		StringBuffer sql = new StringBuffer("SELECT ID from UniversalGS where 1=1");
		if(Data.hasValue(ID))
			sql.append(" and ID = ?");
		if(Data.hasValue(RiskCode))
			sql.append(" and RiskCode = ?");
		if(Data.hasValue(RiskName))
			sql.append(" and RiskName like ?");
		if(Data.hasValue(RateMonth))
			sql.append(" and RateMonth = ?");
		if(Data.hasValue(RateYear))
			sql.append(" and RateYear = ?");
		if(Data.hasValue(RateAssue))
			sql.append(" and RateAssue = ?");
		if(Data.hasValue(IsDisplay))
			sql.append(" and IsDisplay = ?");
		if(Data.hasValue(ValuationUnit))
			sql.append(" and ValuationUnit = ?");
		if(Data.hasValue(fValuationDate))
			sql.append(" and ValuationDate>=to_date('" + fValuationDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tValuationDate))
			sql.append(" and ValuationDate<=to_date('" + tValuationDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fRateAssueStartDate))
			sql.append(" and RateAssueStartDate>=to_date('" + fRateAssueStartDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tRateAssueStartDate))
			sql.append(" and RateAssueStartDate<=to_date('" + tRateAssueStartDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fRateAssueEndDate))
			sql.append(" and RateAssueEndDate>=to_date('" + fRateAssueEndDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tRateAssueEndDate))
			sql.append(" and RateAssueEndDate<=to_date('" + tRateAssueEndDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fRangeStartDate))
			sql.append(" and RangeStartDate>=to_date('" + fRangeStartDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tRangeStartDate))
			sql.append(" and RangeStartDate<=to_date('" + tRangeStartDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fRangeEndDate))
			sql.append(" and RangeEndDate>=to_date('" + fRangeEndDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tRangeEndDate))
			sql.append(" and RangeEndDate<=to_date('" + tRangeEndDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(fMakeDate))
			sql.append(" and MakeDate>=to_date('" + fMakeDate + "','yyyy-MM-dd')");
		if(Data.hasValue(tMakeDate))
			sql.append(" and MakeDate<=to_date('" + tMakeDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		sql.append(" order by ValuationDate desc");
		DBAccess q = new DBAccess();
		result = q.executeQuery(sql.toString(), I.propList, pageSize, pageIndex);
		setCOUNT(q.COUNT);
		setEOF(q.EOF);
		return result;	
		
	}
	
	/**
	 * 查询保证利率历史信息
	 * @param RiskCode	险种代码
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return	String
	 */
	public String findHistoryRate(String RiskCode,int pageSize,int pageIndex){
		String result = "";
		DBAccess d = new DBAccess();
		String sql = "Select Max(Id) from UniversalGS Where isdisplay='1' and RiskCode = ? Group By rateassuestartdate,rateassueenddate,rateassue";
		IndexMap m = new IndexMap();
		m.put("RiskCode", RiskCode);
		result = d.executeQuery(sql.toString(), m, pageSize, pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;
	}
	
	/**
	 * 查找已经发布的险种代码
	 * @return List
	 */
	public List findRiskCode(){
		String sql = "SELECT distinct RiskCode from UniversalGS where IsDisplay='1' order by RiskCode";
		DBAccess d = new DBAccess();
		return d.parseSQL(sql, new ArrayList());
	}
	
	/**
	 * 判断是否存在已经发布的记录
	 * @return boolean
	 */
	public boolean hasDisplay(){
		String sql = "SELECT distinct ID from UniversalGS where IsDisplay='1'";
		DBAccess d = new DBAccess();
		if(Data.hasValue(d.executeQuery(sql, new IndexMap(), 1, 1)))return true;
		else return false;
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
	/**
	 * 获取fValuationDate
	 * @return String
	 */
	public String getfValuationDate() {
		return fValuationDate;
	}
	/**
	 * 设置fValuationDate
	 * @param str 日期
	 */
	public void setfValuationDate(String str) {
		fValuationDate = str;
	}
	/**
	 * 获取tValuationDate
	 * @return String
	 */
	public String gettValuationDate() {
		return tValuationDate;
	}
	/**
	 * 设置tValuationDate
	 * @param str 日期
	 */
	public void settValuationDate(String str) {
		tValuationDate = str;
	}
	/**
	 * 获取fRateAssueStartDate
	 * @return String
	 */
	public String getfRateAssueStartDate() {
		return fRateAssueStartDate;
	}
	/**
	 * 设置fRateAssueStartDate
	 * @param str 日期
	 */
	public void setfRateAssueStartDate(String str) {
		fRateAssueStartDate = str;
	}
	/**
	 * 获取tRateAssueStartDate
	 * @return String
	 */
	public String gettRateAssueStartDate() {
		return tRateAssueStartDate;
	}
	/**
	 * 设置tRateAssueStartDate
	 * @param str 日期
	 */
	public void settRateAssueStartDate(String str) {
		tRateAssueStartDate = str;
	}
	/**
	 * 获取fRateAssueEndDate
	 * @return String
	 */
	public String getfRateAssueEndDate() {
		return fRateAssueEndDate;
	}
	/**
	 * 设置fRateAssueEndDate
	 * @param str 日期
	 */
	public void setfRateAssueEndDate(String str) {
		fRateAssueEndDate = str;
	}
	/**
	 * 获取tRateAssueEndDate
	 * @return String
	 */
	public String gettRateAssueEndDate() {
		return tRateAssueEndDate;
	}
	/**
	 * 设置tRateAssueEndDate
	 * @param str 日期
	 */
	public void settRateAssueEndDate(String str) {
		tRateAssueEndDate = str;
	}
	/**
	 * 获取fRangeStartDate
	 * @return String
	 */
	public String getfRangeStartDate() {
		return fRangeStartDate;
	}
	/**
	 * 设置fRangeStartDate
	 * @param str 日期
	 */
	public void setfRangeStartDate(String str) {
		fRangeStartDate = str;
	}
	/**
	 * 获取tRangeStartDate
	 * @return String
	 */
	public String gettRangeStartDate() {
		return tRangeStartDate;
	}
	/**
	 * 设置tRangeStartDate
	 * @param str 日期
	 */
	public void settRangeStartDate(String str) {
		tRangeStartDate = str;
	}
	/**
	 * 获取fRangeEndDate
	 * @return String
	 */
	public String getfRangeEndDate() {
		return fRangeEndDate;
	}
	/**
	 * 设置fRangeEndDate
	 * @param str 日期
	 */
	public void setfRangeEndDate(String str) {
		fRangeEndDate = str;
	}
	/**
	 * 获取tRangeEndDate
	 * @return String
	 */
	public String gettRangeEndDate() {
		return tRangeEndDate;
	}
	/**
	 * 设置tRangeEndDate
	 * @param str 日期
	 */
	public void settRangeEndDate(String str) {
		tRangeEndDate = str;
	}
	/**
	 * 获取fMakeDate
	 * @return String
	 */
	public String getfMakeDate() {
		return fMakeDate;
	}
	/**
	 * 设置fMakeDate
	 * @param str 日期
	 */
	public void setfMakeDate(String str) {
		fMakeDate = str;
	}
	/**
	 * 获取tMakeDate
	 * @return String
	 */
	public String gettMakeDate() {
		return tMakeDate;
	}
	/**
	 * 设置tMakeDate
	 * @param str 日期
	 */
	public void settMakeDate(String str) {
		tMakeDate = str;
	}
}