complaintmessage.java

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

/**
 * 投诉留言
 */
package com.NCL;

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

public class ComplaintMessage {
	protected IndexMap propList;
	protected HashSet Property;
	private List strList = new ArrayList();
	protected String fMessageTime;
	protected String tMessageTime;
	protected String fAcceptTime;
	protected String tAcceptTime;
	protected String fDealTime;
	protected String tDealTime;
	private boolean EOF = false;
	private int COUNT;
	
	public ComplaintMessage(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("ID");					//ID
		Property.add("UserName");			//用户名
		Property.add("ComplaintContent");	//投诉内容
		Property.add("ComplaintOrg");		//投诉机构
		Property.add("Email");				//联系方式-mail
		Property.add("Phone");				//联系方式-电话
		Property.add("Address");			//通信地址
		Property.add("Mobile");				//手机
		Property.add("PostCode");			//邮政编码
		Property.add("AcceptFlag");			//受理标志位（0：未受理 1：已受理）
		Property.add("DealFlag");			//结案标志位（0：未结案 1：已结案）
		Property.add("AcceptTime");			//受理时间
		Property.add("DealTime");			//结案时间
		Property.add("MessageTime");		//投诉时间
	}
	/**
	 * 初始化投诉留言
	 * @param complaintID ID
	 */
	public void init(String complaintID){
		DBAccess d  = new DBAccess();
		String SQL = "SELECT * from ComplaintMessage where ID=?";
		this.propList = d.init(SQL,complaintID,this.Property);
	}
	/**
	 * 创建投诉留言
	 * @return boolean
	 */
	public boolean createComplaintMessage(){
		String SQL = "INSERT into ComplaintMessage(ID,UserName,ComplaintContent,ComplaintOrg,Email,Phone,Address,Mobile,PostCode,MessageTime) values("
					 + "ComplaintID_SQE.nextval,?,?,?,?,?,?,?,?,sysdate)";
		DBAccess d = new DBAccess();
		return d.execute(SQL.toString(),this.propList);
	}
	/**
	 * 更新投诉留言
	 * @return boolean
	 */
	public boolean updateComplaintMessage(){
		try{
			StringBuffer sql = new StringBuffer("update ComplaintMessage 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);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("ComplaintMessage.updateComplaintMessage():" + e.getMessage());
			return false;
		}
	}
	/**
	 * 删除投诉留言
	 * @param messageID ID
	 * @return boolean
	 */
	public boolean deleteComplaintMessage(String messageID){
		DBAccess DBA= new DBAccess();
		String SQL = "DELETE from ComplaintMessage WHERE ID=?";		
		return DBA.executeDelete(SQL,messageID);
	}
	/**
	 * 根据条件查询
	 * @param cm 		对象
	 * @param pageSize	分页大小
	 * @param pageIndex 分页页码
	 * @return
	 */
	public String findComplaintMessage(ComplaintMessage cm,int pageSize,int pageIndex){
		String result = "";
		StringBuffer SQL = new StringBuffer("SELECT ID from ComplaintMessage where 1=1");
		String id = cm.get("ID");
		String userName = cm.get("UserName");
		String complaintContent = cm.get("ComplaintContent");
		String complaintOrg = cm.get("ComplaintOrg");
		String email = cm.get("Email");
		String phone = cm.get("Phone");
		String address = cm.get("Address");
		String mobile = cm.get("Mobile");
		String postCode = cm.get("PostCode");
		String acceptFlag = cm.get("AcceptFlag");
		String dealFlag = cm.get("DealFlag");
		String fAcceptTime = cm.getFAcceptTime();
		String tAcceptTime = cm.getTAcceptTime();
		String fDealTime = cm.getFDealTime();
		String tDealTime = cm.getTDealTime();
		String fMessageTime = cm.getFMessageTime();
		String tMessageTime = cm.getTMessageTime();
		if(Data.hasValue(fAcceptTime) && fAcceptTime.length()!=10)return "";
		if(Data.hasValue(tAcceptTime) && tAcceptTime.length()!=10)return "";
		if(Data.hasValue(fDealTime) && fDealTime.length()!=10)return "";
		if(Data.hasValue(tDealTime) && tDealTime.length()!=10)return "";
		if(Data.hasValue(fMessageTime) && fMessageTime.length()!=10)return "";
		if(Data.hasValue(tMessageTime) && tMessageTime.length()!=10)return "";
		if(Data.hasValue(id))
			SQL.append(" and ID=?");
		if(Data.hasValue(userName))
			SQL.append(" and userName=?");
		if(Data.hasValue(complaintContent))
			SQL.append(" and complaintContent=?");
		if(Data.hasValue(complaintOrg))
			SQL.append(" and complaintOrg=?");
		if(Data.hasValue(email))
			SQL.append(" and email=?");
		if(Data.hasValue(phone))
			SQL.append(" and phone=?");
		if(Data.hasValue(address))
			SQL.append(" and address=?");
		if(Data.hasValue(mobile))
			SQL.append(" and mobile=?");
		if(Data.hasValue(postCode))
			SQL.append(" and postCode=?");
		if(Data.hasValue(acceptFlag))
			SQL.append(" and acceptFlag=?");
		if(Data.hasValue(dealFlag))
			SQL.append(" and dealFlag=?");
		if(Data.hasValue(this.getFAcceptTime()))
			SQL.append(" and AcceptTime>=to_date('" + fAcceptTime + "','yyyy-MM-dd')");
		if(Data.hasValue(this.getTAcceptTime()))
			SQL.append(" and AcceptTime<=to_date('" + tAcceptTime + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(this.getFDealTime()))
			SQL.append(" and DealTime>=to_date('" + fDealTime + "','yyyy-MM-dd')");
		if(Data.hasValue(this.getTDealTime()))
			SQL.append(" and DealTime<=to_date('" + tDealTime + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(this.getFMessageTime()))
			SQL.append(" and MessageTime>=to_date('" + fMessageTime + "','yyyy-MM-dd')");
		if(Data.hasValue(this.getTMessageTime()))
			SQL.append(" and MessageTime<=to_date('" + tMessageTime + " 23:59:59','yyyy-MM-dd hh24:mi:ss')");
		SQL.append(" order by MessageTime desc");
		DBAccess DBA = new DBAccess();	
		 result = DBA.executeQuery(SQL.toString(),cm.propList,pageSize,pageIndex);
		this.setCOUNT(DBA.COUNT);
		this.setEOF(DBA.EOF);
		return result;	
	}

	/**
	 * 在此映射中关联指定值与指定键
	 * @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();
	}
	/**
	 * 获取fMessageTime
	 * @return String
	 */
	public String getFMessageTime() {
		return fMessageTime;
	}
	/**
	 * 设置fMessageTime
	 * @param messageTime 日期
	 */
	public void setFMessageTime(String messageTime) {
		fMessageTime = messageTime;
	}
	/**
	 * 获取fAcceptTime
	 * @return String
	 */
	public String getFAcceptTime() {
		return fAcceptTime;
	}
	/**
	 * 设置fAcceptTime
	 * @param acceptTime 日期
	 */
	public void setFAcceptTime(String acceptTime) {
		fAcceptTime = acceptTime;
	}
	/**
	 * 获取fDealTime
	 * @return String
	 */
	public String getFDealTime() {
		return fDealTime;
	}
	/**
	 * 设置fDealTime
	 * @param dealTime 日期
	 */
	public void setFDealTime(String dealTime) {
		fDealTime = dealTime;
	}
	/**
	 * 获取tAcceptTime
	 * @return String
	 */
	public String getTAcceptTime() {
		return tAcceptTime;
	}
	/**
	 * 设置tAcceptTime
	 * @param acceptTime 日期
	 */
	public void setTAcceptTime(String acceptTime) {
		tAcceptTime = acceptTime;
	}
	/**
	 * 获取tDealTime
	 * @return String
	 */
	public String getTDealTime() {
		return tDealTime;
	}
	/**
	 * 设置tDealTime
	 * @param dealTime 日期
	 */
	public void setTDealTime(String dealTime) {
		tDealTime = dealTime;
	}
	/**
	 * 获取tMessageTime
	 * @return String
	 */
	public String getTMessageTime() {
		return tMessageTime;
	}
	/**
	 * 设置tMessageTime
	 * @param messageTime 日期
	 */
	public void setTMessageTime(String messageTime) {
		tMessageTime = messageTime;
	}
}