cardpolicy.java

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

/**
 * 卡式保单
 */
package com.NCL;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import com.sinosoft.common.DBAccess;
import com.sinosoft.common.IndexMap;
import java.io.*;
import com.sinosoft.common.*;

public class CardPolicy {
	protected IndexMap propList;
	protected HashSet Property;
	protected String fMakeDate;
	protected String tMakeDate;
	private List strList = new ArrayList();
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public CardPolicy(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ProductID");			//产品代码
		Property.add("ProductName");		//产品名称
		Property.add("CategoryNo");			//单证类型码
		Property.add("RecognizeeNo");		//被保人人数
		Property.add("AppointEffectWay");	//指定生效期日
		Property.add("EffectDate");			//生效日期
		Property.add("facePic");			//卡正面图片文件名
		Property.add("reversoPic");			//卡背面图片文件名	
		Property.add("MakeDate");			//创建日期
		Property.add("Company");			//所属机构
	}
	/**
	 * 初始化
	 * @param productID 产品ID
	 */
	public void init(String productID){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from CardPolicy where ProductID=?";
		this.propList = d.init(sql,productID,this.Property);		
	}
	/**
	 * 创建
	 * @return boolean
	 */
	public boolean createCardPolicy(){
		String sql = "INSERT into CardPolicy values (?,?,?,?,?,?,?,?,sysdate,?)";
		DBAccess d  = new DBAccess();
		return d.execute(sql,this.propList);
	}
	/**
	 * 删除
	 * @param cp 对象
	 * @param root 图片路径
	 * @param root2 相关信息路径
	 * @return boolean
	 */	
	public boolean deleteCardPolicy(CardPolicy cp,String root,String root2){
		DBAccess DBA= new DBAccess();
		String SQL = "DELETE from CardPolicy WHERE ProductID=?";		
		boolean bl = DBA.executeDelete(SQL,cp.get("ProductID"));
		if(bl){
			//删除产品相关信息
			ProductRelatedInfo pri = new ProductRelatedInfo();
			pri.set("ProductID",cp.get("ProductID"));
			String priResult = pri.findProductRelatedInfo(pri,0,1);
			String[] info=null;
			String[] InfoContent=new String[4];
			String[] ID=new String[4];
			if(priResult != null && !"".equals(priResult)){
				List l = new ArrayList();
				info = priResult.split(",");
				for(int i = 0; i < info.length; i++){
					pri.init(info[i]);
					InfoContent[i]=pri.get("InfoContent");
					ID[i]=pri.get("ID");
					String[] priID = new String[1];
					priID[0] = info[i];
					l.add(priID);
				}
				bl = pri.mulDeleteProductRelatedInfo(l);
				if(bl){
					 String fileName1 = cp.get("facePic");
					 String fileName2 = cp.get("reversoPic");
					 File file1 = new File(root + fileName1);
					 File file2 = new File(root + fileName2);
					 if(file1.exists()){
						file1.delete();				
					 }
					 if(file2.exists()){
						file2.delete();
					 }
					 for(int i = 0; i < info.length; i++){
						pri.set("InfoContent",InfoContent[i]);
						pri.set("ID",ID[i]);
						pri.doEdit(pri,"delete",root2);
						 }
					}
			}
			//删除产品激活输入项信息
			ActivationItem ai = new ActivationItem();
			ai.set("ProductID",cp.get("ProductID"));
			String aiResult = ai.findActivationItem(ai,0,1);
			if(aiResult != null && !"".equals(aiResult)){
				List l = new ArrayList();
				String[] strResult = aiResult.split(",");
				for(int i = 0; i < strResult.length; i++){
					String[] aiID = new String[1];
					aiID[0] = strResult[i];
					l.add(aiID);
				}
				bl = ai.mulDeleteActivationItem(l);
			}
		}
		return bl;
	}
	/**
	 * 根据条件查询
	 * @param cp 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return String
	 */
	public String findCardPolicy(CardPolicy cp,int pageSize,int pageIndex){
		String result = "";
		StringBuffer SQL = new StringBuffer("SELECT ProductID from CardPolicy where 1=1");
		String ProductID = cp.get("ProductID");
		String ProductName = cp.get("ProductName");
		String CategoryNo = cp.get("CategoryNo");
		String company = cp.get("Company");
		if(Data.hasValue(ProductID))
			SQL.append(" and ProductID=?");
		if(Data.hasValue(ProductName))
			SQL.append(" and ProductName like ?");
		if(Data.hasValue(CategoryNo))
			SQL.append(" and CategoryNo=?");
		if(Data.hasValue(cp.getFMakeDate()) && cp.getFMakeDate().length() == 10)
			SQL.append(" and MakeDate>=to_date(" + Data.formatValue(this.getFMakeDate()) + ",'yyyy-MM-dd')");
		if(Data.hasValue(cp.getTMakeDate()) && cp.getTMakeDate().length() == 10)
			SQL.append(" and MakeDate<=to_date(" + Data.formatValue(this.getTMakeDate() + " 23:59:59") + ",'yyyy-MM-dd hh24:mi:ss')");	
		if(Data.hasValue(company))
			SQL.append(" and Company=?");
		SQL.append(" order by MakeDate desc");
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL.toString(),cp.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;				
	}
	/**
	 * 根据分公司查询
	 * @param cp 对象
	 * @param pageSize 分页大小
	 * @param pageIndex 分页页码
	 * @return String
	 */
	public String findCPByComCode(CardPolicy cp,int pageSize,int pageIndex){
		String result = "";
		String SQL = "SELECT ProductID from CardPolicy where 1=1";
		String comCode = cp.get("Company");
		if(Data.hasValue(comCode)){
			SQL += " and Company=?";
			SQL += " or Company='86'";
		}
		DBAccess d  = new DBAccess();
		result = d.executeQuery(SQL,cp.propList,pageSize,pageIndex);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;
	}
	/**
	 * 更新
	 * @param cp 对象
	 * @param operate 操作类型
	 * @param root 图片路径
	 * @param root2 其他相关信息路径
	 * @return boolean
	 */
	 public boolean doEdit(CardPolicy cp,String operate,String root,String root2){
		 boolean bl = false;
		 if("update".equals(operate)){
			 bl = cp.updateCardPolicy();
		 }else if("delete".equals(operate)){
			 bl = cp.deleteCardPolicy(cp,root,root2);
		}
		 return bl;
	 }
	/**
	 * 更新
	 * @return boolean
	 */
	public boolean updateCardPolicy(){
		try{
			StringBuffer sql = new StringBuffer("update CardPolicy 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 ProductID=?");
			l.add(this.get("ProductID"));
			strList.clear();
			DBAccess q = new DBAccess();
			return q.executeUpdate(sql.toString(),l);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("CardPolicy.updateCardPolicy():" + e.getMessage());
			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();
	}
	/**
	 * 返回fMakeDate
	 * @return String
	 */
	public String getFMakeDate() {
		return fMakeDate;
	}
	/**
	 * 设置fMakeDate
	 * @param makeDate 日期
	 */
	public void setFMakeDate(String makeDate) {
		fMakeDate = makeDate;
	}
	/**
	 * 返回tMakeDate
	 * @return String
	 */
	public String getTMakeDate() {
		return tMakeDate;
	}
	/**
	 * 设置tMakeDate
	 * @param makeDate 日期
	 */
	public void setTMakeDate(String makeDate) {
		tMakeDate = makeDate;
	}
	
	public static void main(String []args){
	}
}