package cn.ksource.beans;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;


import cn.ksource.core.dao.BaseBean;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.StringUtil;

/**
 * 工作流程-节点
 */
public class WORKFLOW_NODE extends BaseBean{

	public final static Map<String, String> KEYS = new HashMap<String, String>();
	private Map BEAN_VALUES = null;
	
	static {
		KEYS.put("id", "String");
		KEYS.put("nodename", "String");
		KEYS.put("flowstate", "Integer");
		KEYS.put("flow_type", "Integer");
		KEYS.put("createtime", "Long");
		KEYS.put("answer_time", "Long");
		KEYS.put("dealtime", "Long");
		KEYS.put("flowid", "String");
		KEYS.put("node_template_id", "String");
		KEYS.put("deal_result", "Integer");
		KEYS.put("deal_type", "Integer");
		KEYS.put("current_dealer_id", "String");
		KEYS.put("current_dealer_name", "String");
		KEYS.put("current_deal_roleida", "String");
		KEYS.put("current_deal_rolename", "String");
		KEYS.put("deal_note_title", "String");
		KEYS.put("deal_note", "String");
		KEYS.put("deal_usetime", "Long");
		KEYS.put("answer_usertime", "Long");
		KEYS.put("is_admin", "Integer");
		KEYS.put("source_node_instance_id", "String");
		KEYS.put("same_node_key", "String");
		KEYS.put("pid", "String");
		KEYS.put("business_id", "String");
		KEYS.put("working_hours", "String");
		KEYS.put("level", "Integer");
		KEYS.put("note_key", "String");
		KEYS.put("note_val", "String");
	}
	public Map getColumnMap(){
		return KEYS;
	}

	private String id;
	private Boolean isSetted_id = false;;
	
	private String nodename;
	private Boolean isSetted_nodename = false;
	private Integer flowstate;
	private Boolean isSetted_flowstate = false;
	private Integer flow_type;
	private Boolean isSetted_flow_type = false;
	private Long createtime;
	private Boolean isSetted_createtime = false;
	private Long answer_time;
	private Boolean isSetted_answer_time = false;
	private Long dealtime;
	private Boolean isSetted_dealtime = false;
	private String flowid;
	private Boolean isSetted_flowid = false;
	private String node_template_id;
	private Boolean isSetted_node_template_id = false;
	private Integer deal_result;
	private Boolean isSetted_deal_result = false;
	private Integer deal_type;
	private Boolean isSetted_deal_type = false;
	private String current_dealer_id;
	private Boolean isSetted_current_dealer_id = false;
	private String current_dealer_name;
	private Boolean isSetted_current_dealer_name = false;
	private String current_deal_roleida;
	private Boolean isSetted_current_deal_roleida = false;
	private String current_deal_rolename;
	private Boolean isSetted_current_deal_rolename = false;
	private String deal_note_title;
	private Boolean isSetted_deal_note_title = false;
	private String deal_note;
	private Boolean isSetted_deal_note = false;
	private Long deal_usetime;
	private Boolean isSetted_deal_usetime = false;
	private Long answer_usertime;
	private Boolean isSetted_answer_usertime = false;
	private Integer is_admin;
	private Boolean isSetted_is_admin = false;
	private String source_node_instance_id;
	private Boolean isSetted_source_node_instance_id = false;
	private String same_node_key;
	private Boolean isSetted_same_node_key = false;
	private String pid;
	private Boolean isSetted_pid = false;
	private String business_id;
	private Boolean isSetted_business_id = false;
	private String working_hours;
	private Boolean isSetted_working_hours = false;
	private Integer level;
	private Boolean isSetted_level = false;
	private String note_key;
	private Boolean isSetted_note_key = false;
	private String note_val;
	private Boolean isSetted_note_val = false;

	private void initBeanValues(){
		BEAN_VALUES = new HashMap<String, Object>();
		BEAN_VALUES.put("id",id);
			BEAN_VALUES.put("nodename", null);
			BEAN_VALUES.put("flowstate", null);
			BEAN_VALUES.put("flow_type", null);
			BEAN_VALUES.put("createtime", null);
			BEAN_VALUES.put("answer_time", null);
			BEAN_VALUES.put("dealtime", null);
			BEAN_VALUES.put("flowid", null);
			BEAN_VALUES.put("node_template_id", null);
			BEAN_VALUES.put("deal_result", null);
			BEAN_VALUES.put("deal_type", null);
			BEAN_VALUES.put("current_dealer_id", null);
			BEAN_VALUES.put("current_dealer_name", null);
			BEAN_VALUES.put("current_deal_roleida", null);
			BEAN_VALUES.put("current_deal_rolename", null);
			BEAN_VALUES.put("deal_note_title", null);
			BEAN_VALUES.put("deal_note", null);
			BEAN_VALUES.put("deal_usetime", null);
			BEAN_VALUES.put("answer_usertime", null);
			BEAN_VALUES.put("is_admin", null);
			BEAN_VALUES.put("source_node_instance_id", null);
			BEAN_VALUES.put("same_node_key", null);
			BEAN_VALUES.put("pid", null);
			BEAN_VALUES.put("business_id", null);
			BEAN_VALUES.put("working_hours", null);
			BEAN_VALUES.put("level", null);
			BEAN_VALUES.put("note_key", null);
			BEAN_VALUES.put("note_val", null);
	}
	
	public WORKFLOW_NODE() {
		initBeanValues();
	}
	
	public WORKFLOW_NODE(String id) {
		super();
		this.id = id;
		initBeanValues();
		BEAN_VALUES.put("id",id);
	}

    /**
     * 获取ID
     */
	public String getId() {
		return this.id;
	}
	/**
     * 设置ID
     */
	public WORKFLOW_NODE setId(String id) {
		this.id = id;
		this.isSetted_id = true;
		BEAN_VALUES.put("id",id);
		return this;
	}
	
	@Override
	public String getUpdateSql() {
		StringBuffer sBuffer = new StringBuffer("update WORKFLOW_NODE set ");
			if (isSetted_nodename) {
				sBuffer.append("nodename=:nodename,");
			}
			if (isSetted_flowstate) {
				sBuffer.append("flowstate=:flowstate,");
			}
			if (isSetted_flow_type) {
				sBuffer.append("flow_type=:flow_type,");
			}
			if (isSetted_createtime) {
				sBuffer.append("createtime=:createtime,");
			}
			if (isSetted_answer_time) {
				sBuffer.append("answer_time=:answer_time,");
			}
			if (isSetted_dealtime) {
				sBuffer.append("dealtime=:dealtime,");
			}
			if (isSetted_flowid) {
				sBuffer.append("flowid=:flowid,");
			}
			if (isSetted_node_template_id) {
				sBuffer.append("node_template_id=:node_template_id,");
			}
			if (isSetted_deal_result) {
				sBuffer.append("deal_result=:deal_result,");
			}
			if (isSetted_deal_type) {
				sBuffer.append("deal_type=:deal_type,");
			}
			if (isSetted_current_dealer_id) {
				sBuffer.append("current_dealer_id=:current_dealer_id,");
			}
			if (isSetted_current_dealer_name) {
				sBuffer.append("current_dealer_name=:current_dealer_name,");
			}
			if (isSetted_current_deal_roleida) {
				sBuffer.append("current_deal_roleida=:current_deal_roleida,");
			}
			if (isSetted_current_deal_rolename) {
				sBuffer.append("current_deal_rolename=:current_deal_rolename,");
			}
			if (isSetted_deal_note_title) {
				sBuffer.append("deal_note_title=:deal_note_title,");
			}
			if (isSetted_deal_note) {
				sBuffer.append("deal_note=:deal_note,");
			}
			if (isSetted_deal_usetime) {
				sBuffer.append("deal_usetime=:deal_usetime,");
			}
			if (isSetted_answer_usertime) {
				sBuffer.append("answer_usertime=:answer_usertime,");
			}
			if (isSetted_is_admin) {
				sBuffer.append("is_admin=:is_admin,");
			}
			if (isSetted_source_node_instance_id) {
				sBuffer.append("source_node_instance_id=:source_node_instance_id,");
			}
			if (isSetted_same_node_key) {
				sBuffer.append("same_node_key=:same_node_key,");
			}
			if (isSetted_pid) {
				sBuffer.append("pid=:pid,");
			}
			if (isSetted_business_id) {
				sBuffer.append("business_id=:business_id,");
			}
			if (isSetted_working_hours) {
				sBuffer.append("working_hours=:working_hours,");
			}
			if (isSetted_level) {
				sBuffer.append("level=:level,");
			}
			if (isSetted_note_key) {
				sBuffer.append("note_key=:note_key,");
			}
			if (isSetted_note_val) {
				sBuffer.append("note_val=:note_val,");
			}
		String sql = sBuffer.toString();
		return StringUtils.removeEnd(sql, ",") + " where id=:id";
	}
	
	
	@Override
	public String getInsertSql() {
		StringBuffer sBuffer = new StringBuffer("insert into WORKFLOW_NODE(");
		StringBuffer fileds = new StringBuffer("id,");
		StringBuffer values = new StringBuffer(":id,");		
			fileds.append("nodename,");
			values.append(":nodename,");
			fileds.append("flowstate,");
			values.append(":flowstate,");
			fileds.append("flow_type,");
			values.append(":flow_type,");
			fileds.append("createtime,");
			values.append(":createtime,");
			fileds.append("answer_time,");
			values.append(":answer_time,");
			fileds.append("dealtime,");
			values.append(":dealtime,");
			fileds.append("flowid,");
			values.append(":flowid,");
			fileds.append("node_template_id,");
			values.append(":node_template_id,");
			fileds.append("deal_result,");
			values.append(":deal_result,");
			fileds.append("deal_type,");
			values.append(":deal_type,");
			fileds.append("current_dealer_id,");
			values.append(":current_dealer_id,");
			fileds.append("current_dealer_name,");
			values.append(":current_dealer_name,");
			fileds.append("current_deal_roleida,");
			values.append(":current_deal_roleida,");
			fileds.append("current_deal_rolename,");
			values.append(":current_deal_rolename,");
			fileds.append("deal_note_title,");
			values.append(":deal_note_title,");
			fileds.append("deal_note,");
			values.append(":deal_note,");
			fileds.append("deal_usetime,");
			values.append(":deal_usetime,");
			fileds.append("answer_usertime,");
			values.append(":answer_usertime,");
			fileds.append("is_admin,");
			values.append(":is_admin,");
			fileds.append("source_node_instance_id,");
			values.append(":source_node_instance_id,");
			fileds.append("same_node_key,");
			values.append(":same_node_key,");
			fileds.append("pid,");
			values.append(":pid,");
			fileds.append("business_id,");
			values.append(":business_id,");
			fileds.append("working_hours,");
			values.append(":working_hours,");
			fileds.append("level,");
			values.append(":level,");
			fileds.append("note_key,");
			values.append(":note_key,");
			fileds.append("note_val,");
			values.append(":note_val,");
		sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")");
		return sBuffer.toString();
	}
	

		/**
		 * 获取环节名称<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getNodename() {
			return nodename;
		}
		/**
		 * 设置环节名称<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setNodename(String nodename) {
			this.nodename = nodename;
			this.isSetted_nodename = true;
			BEAN_VALUES.put("nodename",nodename);
			return this;
		}
		/**
		 * 获取流转状态（1=待响应；2=进行中；3=已处理;）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getFlowstate() {
			return flowstate;
		}
		/**
		 * 设置流转状态（1=待响应；2=进行中；3=已处理;）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setFlowstate(Integer flowstate) {
			this.flowstate = flowstate;
			this.isSetted_flowstate = true;
			BEAN_VALUES.put("flowstate",flowstate);
			return this;
		}
		/**
		 * 获取流转类型（1=正常流转；2=回退）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getFlow_type() {
			return flow_type;
		}
		/**
		 * 设置流转类型（1=正常流转；2=回退）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setFlow_type(Integer flow_type) {
			this.flow_type = flow_type;
			this.isSetted_flow_type = true;
			BEAN_VALUES.put("flow_type",flow_type);
			return this;
		}
		/**
		 * 获取创建时间<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Long getCreatetime() {
			return createtime;
		}
		/**
		 * 设置创建时间<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setCreatetime(Long createtime) {
			this.createtime = createtime;
			this.isSetted_createtime = true;
			BEAN_VALUES.put("createtime",createtime);
			return this;
		}
		/**
		 * 获取响应时间（开始处理时间）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Long getAnswer_time() {
			return answer_time;
		}
		/**
		 * 设置响应时间（开始处理时间）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setAnswer_time(Long answer_time) {
			this.answer_time = answer_time;
			this.isSetted_answer_time = true;
			BEAN_VALUES.put("answer_time",answer_time);
			return this;
		}
		/**
		 * 获取处理时间<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Long getDealtime() {
			return dealtime;
		}
		/**
		 * 设置处理时间<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDealtime(Long dealtime) {
			this.dealtime = dealtime;
			this.isSetted_dealtime = true;
			BEAN_VALUES.put("dealtime",dealtime);
			return this;
		}
		/**
		 * 获取流程编号<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getFlowid() {
			return flowid;
		}
		/**
		 * 设置流程编号<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setFlowid(String flowid) {
			this.flowid = flowid;
			this.isSetted_flowid = true;
			BEAN_VALUES.put("flowid",flowid);
			return this;
		}
		/**
		 * 获取环节模版编号<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getNode_template_id() {
			return node_template_id;
		}
		/**
		 * 设置环节模版编号<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setNode_template_id(String node_template_id) {
			this.node_template_id = node_template_id;
			this.isSetted_node_template_id = true;
			BEAN_VALUES.put("node_template_id",node_template_id);
			return this;
		}
		/**
		 * 获取处理结果（1=通过；2=不通过;3=回退）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getDeal_result() {
			return deal_result;
		}
		/**
		 * 设置处理结果（1=通过；2=不通过;3=回退）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDeal_result(Integer deal_result) {
			this.deal_result = deal_result;
			this.isSetted_deal_result = true;
			BEAN_VALUES.put("deal_result",deal_result);
			return this;
		}
		/**
		 * 获取处理人类型（1=指定角色；2=指定人员；3=上一环节指定；4=流程发起人）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getDeal_type() {
			return deal_type;
		}
		/**
		 * 设置处理人类型（1=指定角色；2=指定人员；3=上一环节指定；4=流程发起人）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDeal_type(Integer deal_type) {
			this.deal_type = deal_type;
			this.isSetted_deal_type = true;
			BEAN_VALUES.put("deal_type",deal_type);
			return this;
		}
		/**
		 * 获取当前处理人编号<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getCurrent_dealer_id() {
			return current_dealer_id;
		}
		/**
		 * 设置当前处理人编号<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setCurrent_dealer_id(String current_dealer_id) {
			this.current_dealer_id = current_dealer_id;
			this.isSetted_current_dealer_id = true;
			BEAN_VALUES.put("current_dealer_id",current_dealer_id);
			return this;
		}
		/**
		 * 获取当前处理人名称<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getCurrent_dealer_name() {
			return current_dealer_name;
		}
		/**
		 * 设置当前处理人名称<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setCurrent_dealer_name(String current_dealer_name) {
			this.current_dealer_name = current_dealer_name;
			this.isSetted_current_dealer_name = true;
			BEAN_VALUES.put("current_dealer_name",current_dealer_name);
			return this;
		}
		/**
		 * 获取当前处理角色编号<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getCurrent_deal_roleida() {
			return current_deal_roleida;
		}
		/**
		 * 设置当前处理角色编号<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setCurrent_deal_roleida(String current_deal_roleida) {
			this.current_deal_roleida = current_deal_roleida;
			this.isSetted_current_deal_roleida = true;
			BEAN_VALUES.put("current_deal_roleida",current_deal_roleida);
			return this;
		}
		/**
		 * 获取当前处理角色名称<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getCurrent_deal_rolename() {
			return current_deal_rolename;
		}
		/**
		 * 设置当前处理角色名称<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setCurrent_deal_rolename(String current_deal_rolename) {
			this.current_deal_rolename = current_deal_rolename;
			this.isSetted_current_deal_rolename = true;
			BEAN_VALUES.put("current_deal_rolename",current_deal_rolename);
			return this;
		}
		/**
		 * 获取处理意见标题<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getDeal_note_title() {
			return deal_note_title;
		}
		/**
		 * 设置处理意见标题<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDeal_note_title(String deal_note_title) {
			this.deal_note_title = deal_note_title;
			this.isSetted_deal_note_title = true;
			BEAN_VALUES.put("deal_note_title",deal_note_title);
			return this;
		}
		/**
		 * 获取处理意见<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getDeal_note() {
			return deal_note;
		}
		/**
		 * 设置处理意见<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDeal_note(String deal_note) {
			this.deal_note = deal_note;
			this.isSetted_deal_note = true;
			BEAN_VALUES.put("deal_note",deal_note);
			return this;
		}
		/**
		 * 获取处理耗时<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Long getDeal_usetime() {
			return deal_usetime;
		}
		/**
		 * 设置处理耗时<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setDeal_usetime(Long deal_usetime) {
			this.deal_usetime = deal_usetime;
			this.isSetted_deal_usetime = true;
			BEAN_VALUES.put("deal_usetime",deal_usetime);
			return this;
		}
		/**
		 * 获取响应耗时<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Long getAnswer_usertime() {
			return answer_usertime;
		}
		/**
		 * 设置响应耗时<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setAnswer_usertime(Long answer_usertime) {
			this.answer_usertime = answer_usertime;
			this.isSetted_answer_usertime = true;
			BEAN_VALUES.put("answer_usertime",answer_usertime);
			return this;
		}
		/**
		 * 获取是否主要负责人（1=是；2=否）<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getIs_admin() {
			return is_admin;
		}
		/**
		 * 设置是否主要负责人（1=是；2=否）<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setIs_admin(Integer is_admin) {
			this.is_admin = is_admin;
			this.isSetted_is_admin = true;
			BEAN_VALUES.put("is_admin",is_admin);
			return this;
		}
		/**
		 * 获取源节点实例编号<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getSource_node_instance_id() {
			return source_node_instance_id;
		}
		/**
		 * 设置源节点实例编号<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setSource_node_instance_id(String source_node_instance_id) {
			this.source_node_instance_id = source_node_instance_id;
			this.isSetted_source_node_instance_id = true;
			BEAN_VALUES.put("source_node_instance_id",source_node_instance_id);
			return this;
		}
		/**
		 * 获取同环节标识<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getSame_node_key() {
			return same_node_key;
		}
		/**
		 * 设置同环节标识<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setSame_node_key(String same_node_key) {
			this.same_node_key = same_node_key;
			this.isSetted_same_node_key = true;
			BEAN_VALUES.put("same_node_key",same_node_key);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getPid() {
			return pid;
		}
		/**
		 * 设置<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setPid(String pid) {
			this.pid = pid;
			this.isSetted_pid = true;
			BEAN_VALUES.put("pid",pid);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getBusiness_id() {
			return business_id;
		}
		/**
		 * 设置<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setBusiness_id(String business_id) {
			this.business_id = business_id;
			this.isSetted_business_id = true;
			BEAN_VALUES.put("business_id",business_id);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getWorking_hours() {
			return working_hours;
		}
		/**
		 * 设置<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setWorking_hours(String working_hours) {
			this.working_hours = working_hours;
			this.isSetted_working_hours = true;
			BEAN_VALUES.put("working_hours",working_hours);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public Integer getLevel() {
			return level;
		}
		/**
		 * 设置<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setLevel(Integer level) {
			this.level = level;
			this.isSetted_level = true;
			BEAN_VALUES.put("level",level);
			return this;
		}
		/**
		 * 获取描述信息KEY<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getNote_key() {
			return note_key;
		}
		/**
		 * 设置描述信息KEY<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setNote_key(String note_key) {
			this.note_key = note_key;
			this.isSetted_note_key = true;
			BEAN_VALUES.put("note_key",note_key);
			return this;
		}
		/**
		 * 获取描述信息VAL<BR/>
		 * 䣺2020-11-02 hh:04
		 */
		public String getNote_val() {
			return note_val;
		}
		/**
		 * 设置描述信息VAL<BR/>
		 * 2020-11-02 hh:04
		 */
		public WORKFLOW_NODE setNote_val(String note_val) {
			this.note_val = note_val;
			this.isSetted_note_val = true;
			BEAN_VALUES.put("note_val",note_val);
			return this;
		}

		/**
		 * 使用ID删除Bean<BR/>
		 */
		public void deleteById() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("删除bean时ID不能为空");
			}
			dao.execute("delete from " + getTableName() + " where id = :id", BEAN_VALUES);
		}
	
		@Override
		public WORKFLOW_NODE getInstanceById() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("获取Bean时ID不能为空");
			}
			return dao.queryForBean("select * from " + getTableName() + " where id=:id", BEAN_VALUES, this);
		}
	
		
		
		@Override
		public WORKFLOW_NODE queryForBean() {
			StringBuffer sBuffer = new StringBuffer("select * from WORKFLOW_NODE where ");
			if(isSetted_id){
				sBuffer.append("id=:id and ");
			}
				if (isSetted_nodename) {
					sBuffer.append("nodename=:nodename and ");
				}
				if (isSetted_flowstate) {
					sBuffer.append("flowstate=:flowstate and ");
				}
				if (isSetted_flow_type) {
					sBuffer.append("flow_type=:flow_type and ");
				}
				if (isSetted_createtime) {
					sBuffer.append("createtime=:createtime and ");
				}
				if (isSetted_answer_time) {
					sBuffer.append("answer_time=:answer_time and ");
				}
				if (isSetted_dealtime) {
					sBuffer.append("dealtime=:dealtime and ");
				}
				if (isSetted_flowid) {
					sBuffer.append("flowid=:flowid and ");
				}
				if (isSetted_node_template_id) {
					sBuffer.append("node_template_id=:node_template_id and ");
				}
				if (isSetted_deal_result) {
					sBuffer.append("deal_result=:deal_result and ");
				}
				if (isSetted_deal_type) {
					sBuffer.append("deal_type=:deal_type and ");
				}
				if (isSetted_current_dealer_id) {
					sBuffer.append("current_dealer_id=:current_dealer_id and ");
				}
				if (isSetted_current_dealer_name) {
					sBuffer.append("current_dealer_name=:current_dealer_name and ");
				}
				if (isSetted_current_deal_roleida) {
					sBuffer.append("current_deal_roleida=:current_deal_roleida and ");
				}
				if (isSetted_current_deal_rolename) {
					sBuffer.append("current_deal_rolename=:current_deal_rolename and ");
				}
				if (isSetted_deal_note_title) {
					sBuffer.append("deal_note_title=:deal_note_title and ");
				}
				if (isSetted_deal_note) {
					sBuffer.append("deal_note=:deal_note and ");
				}
				if (isSetted_deal_usetime) {
					sBuffer.append("deal_usetime=:deal_usetime and ");
				}
				if (isSetted_answer_usertime) {
					sBuffer.append("answer_usertime=:answer_usertime and ");
				}
				if (isSetted_is_admin) {
					sBuffer.append("is_admin=:is_admin and ");
				}
				if (isSetted_source_node_instance_id) {
					sBuffer.append("source_node_instance_id=:source_node_instance_id and ");
				}
				if (isSetted_same_node_key) {
					sBuffer.append("same_node_key=:same_node_key and ");
				}
				if (isSetted_pid) {
					sBuffer.append("pid=:pid and ");
				}
				if (isSetted_business_id) {
					sBuffer.append("business_id=:business_id and ");
				}
				if (isSetted_working_hours) {
					sBuffer.append("working_hours=:working_hours and ");
				}
				if (isSetted_level) {
					sBuffer.append("level=:level and ");
				}
				if (isSetted_note_key) {
					sBuffer.append("note_key=:note_key and ");
				}
				if (isSetted_note_val) {
					sBuffer.append("note_val=:note_val and ");
				}
			String sql = sBuffer.toString();
			sql = StringUtils.removeEnd(sql, " and ");
			return dao.queryForBean(sql,this);
		}
	
		@Override
		public String getTableName() {
			return "WORKFLOW_NODE";
		}
		
		
		public Map getBeanValues(){
			return this.BEAN_VALUES;
		}
	
		@Override
		public WORKFLOW_NODE insert() {
			if (StringUtils.isBlank(id)) {
				this.setId(StringUtil.getUUID());
			}
			dao.execute(getInsertSql(),BEAN_VALUES);
			return this;
		}
	
		@Override
		public WORKFLOW_NODE update() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("更新Bean时ID不能为空");
			}
			dao.execute(getUpdateSql(),BEAN_VALUES);
			return this;
		}  
		
		public WORKFLOW_NODE insertOrUpdate(){
			if (StringUtils.isNotBlank(id)) {
				return update();
			} else {
				return insert();
			}
		}
		
		/**
		 * 通过ID获取该条信息的Map结构
		 */
		public Map getBeanMapById() {
			
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("ID不能为空!");
			}
			
			return dao.queryForMap("select * from WORKFLOW_NODE where id=:id",BEAN_VALUES);
		}

		public Object mapRow(ResultSet rs, int rownum) throws SQLException {
			Object id = rs.getObject("ID");
			this.setId(ConvertUtil.obj2Str(id));
			BEAN_VALUES.put("id",id);
			Object obj = null;
			obj = rs.getObject("NODENAME");
			BEAN_VALUES.put("nodename",obj);
				this.setNodename(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FLOWSTATE");
			BEAN_VALUES.put("flowstate",obj);
				this.setFlowstate(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("FLOW_TYPE");
			BEAN_VALUES.put("flow_type",obj);
				this.setFlow_type(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("CREATETIME");
			BEAN_VALUES.put("createtime",obj);
				this.setCreatetime(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("ANSWER_TIME");
			BEAN_VALUES.put("answer_time",obj);
				this.setAnswer_time(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("DEALTIME");
			BEAN_VALUES.put("dealtime",obj);
				this.setDealtime(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("FLOWID");
			BEAN_VALUES.put("flowid",obj);
				this.setFlowid(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("NODE_TEMPLATE_ID");
			BEAN_VALUES.put("node_template_id",obj);
				this.setNode_template_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEAL_RESULT");
			BEAN_VALUES.put("deal_result",obj);
				this.setDeal_result(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("DEAL_TYPE");
			BEAN_VALUES.put("deal_type",obj);
				this.setDeal_type(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("CURRENT_DEALER_ID");
			BEAN_VALUES.put("current_dealer_id",obj);
				this.setCurrent_dealer_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CURRENT_DEALER_NAME");
			BEAN_VALUES.put("current_dealer_name",obj);
				this.setCurrent_dealer_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CURRENT_DEAL_ROLEIDA");
			BEAN_VALUES.put("current_deal_roleida",obj);
				this.setCurrent_deal_roleida(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CURRENT_DEAL_ROLENAME");
			BEAN_VALUES.put("current_deal_rolename",obj);
				this.setCurrent_deal_rolename(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEAL_NOTE_TITLE");
			BEAN_VALUES.put("deal_note_title",obj);
				this.setDeal_note_title(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEAL_NOTE");
			BEAN_VALUES.put("deal_note",obj);
				this.setDeal_note(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEAL_USETIME");
			BEAN_VALUES.put("deal_usetime",obj);
				this.setDeal_usetime(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("ANSWER_USERTIME");
			BEAN_VALUES.put("answer_usertime",obj);
				this.setAnswer_usertime(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("IS_ADMIN");
			BEAN_VALUES.put("is_admin",obj);
				this.setIs_admin(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("SOURCE_NODE_INSTANCE_ID");
			BEAN_VALUES.put("source_node_instance_id",obj);
				this.setSource_node_instance_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SAME_NODE_KEY");
			BEAN_VALUES.put("same_node_key",obj);
				this.setSame_node_key(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("PID");
			BEAN_VALUES.put("pid",obj);
				this.setPid(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BUSINESS_ID");
			BEAN_VALUES.put("business_id",obj);
				this.setBusiness_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("WORKING_HOURS");
			BEAN_VALUES.put("working_hours",obj);
				this.setWorking_hours(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("LEVEL");
			BEAN_VALUES.put("level",obj);
				this.setLevel(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("NOTE_KEY");
			BEAN_VALUES.put("note_key",obj);
				this.setNote_key(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("NOTE_VAL");
			BEAN_VALUES.put("note_val",obj);
				this.setNote_val(ConvertUtil.obj2Str(obj));
			return this;
		}
		
		
		public String toString() {
			StringBuffer sb = new StringBuffer("[");
			for (Iterator iterator = KEYS.keySet().iterator(); iterator.hasNext();) {
				String key = (String) iterator.next();
				sb.append(key+"=" + BEAN_VALUES.get(key)+",");
			}
			sb.append("]");
			return sb.toString();
		}
		
		public WORKFLOW_NODE newInstance(){
			return new WORKFLOW_NODE();
		}



















}