package cn.ksource.beans;

import cn.ksource.core.dao.BaseBean;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.StringUtil;
import org.apache.commons.lang.StringUtils;

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

/**
 * 变更管理
 */
public class SC_WORKFLOW_CHANGE 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("order_code", "String");
		KEYS.put("name", "String");
		KEYS.put("descrip", "String");
		KEYS.put("first_category_id", "String");
		KEYS.put("first_category_name", "String");
		KEYS.put("second_category_id", "String");
		KEYS.put("second_category_name", "String");
		KEYS.put("third_category_id", "String");
		KEYS.put("third_category_name", "String");
		KEYS.put("customer_id", "String");
		KEYS.put("customer_name", "String");
		KEYS.put("sub_customer_id", "String");
		KEYS.put("sub_customer_name", "String");
		KEYS.put("contact_name", "String");
		KEYS.put("contact_phone", "String");
		KEYS.put("create_user_id", "String");
		KEYS.put("create_user_name", "String");
		KEYS.put("create_time", "Long");
		KEYS.put("type", "String");
		KEYS.put("source_id", "String");
		KEYS.put("source_name", "String");
		KEYS.put("risk_level_id", "String");
		KEYS.put("risk_level_name", "String");
		KEYS.put("department", "String");
		KEYS.put("business_sys", "String");
		KEYS.put("state", "Integer");
		KEYS.put("resolve_user_id", "String");
		KEYS.put("resolve_user_name", "String");
		KEYS.put("resolve_time", "Long");
		KEYS.put("resolve_type_id", "String");
		KEYS.put("resolve_type_name", "String");
		KEYS.put("flow_id", "String");
		KEYS.put("flow_name", "String");
		KEYS.put("partner_id", "String");
		KEYS.put("plan_start_time", "Long");
		KEYS.put("request_deal_time", "Long");
		KEYS.put("project_id", "String");
		KEYS.put("project_name", "String");
		KEYS.put("change_note", "String");
		KEYS.put("resolve", "Integer");
		KEYS.put("ssbz", "String");
		KEYS.put("htbz", "String");
		KEYS.put("sys_fzr", "String");
		KEYS.put("fzr_mobile", "String");
		KEYS.put("change_fzr", "String");
		KEYS.put("change_mobile", "String");
		KEYS.put("fxfx", "String");
		KEYS.put("bgsjfw", "String");
		KEYS.put("bgbz", "String");
		KEYS.put("test_plan", "String");
		KEYS.put("back_bz", "String");
		KEYS.put("change_dept", "String");
		KEYS.put("note", "String");
		KEYS.put("is_release", "Integer");
		KEYS.put("release_id", "String");
		KEYS.put("is_sys_change", "Integer");
		KEYS.put("app_dept", "String");
		KEYS.put("app_date", "Long");
		KEYS.put("change_gain", "String");
		KEYS.put("dev_hour", "String");
		KEYS.put("solve_program", "String");
		KEYS.put("sign_user", "String");
		KEYS.put("sign_date", "Long");
		KEYS.put("feed_user", "String");
		KEYS.put("feed_date", "Long");
		KEYS.put("feed_res", "String");
		KEYS.put("key_user", "String");
		KEYS.put("confirm_date", "Long");
		KEYS.put("confirm_res", "String");
		KEYS.put("oa_id", "String");
	}
	public Map getColumnMap(){
		return KEYS;
	}

	private String id;
	private Boolean isSetted_id = false;;
	
	private String order_code;
	private Boolean isSetted_order_code = false;
	private String name;
	private Boolean isSetted_name = false;
	private String descrip;
	private Boolean isSetted_descrip = false;
	private String first_category_id;
	private Boolean isSetted_first_category_id = false;
	private String first_category_name;
	private Boolean isSetted_first_category_name = false;
	private String second_category_id;
	private Boolean isSetted_second_category_id = false;
	private String second_category_name;
	private Boolean isSetted_second_category_name = false;
	private String third_category_id;
	private Boolean isSetted_third_category_id = false;
	private String third_category_name;
	private Boolean isSetted_third_category_name = false;
	private String customer_id;
	private Boolean isSetted_customer_id = false;
	private String customer_name;
	private Boolean isSetted_customer_name = false;
	private String sub_customer_id;
	private Boolean isSetted_sub_customer_id = false;
	private String sub_customer_name;
	private Boolean isSetted_sub_customer_name = false;
	private String contact_name;
	private Boolean isSetted_contact_name = false;
	private String contact_phone;
	private Boolean isSetted_contact_phone = false;
	private String create_user_id;
	private Boolean isSetted_create_user_id = false;
	private String create_user_name;
	private Boolean isSetted_create_user_name = false;
	private Long create_time;
	private Boolean isSetted_create_time = false;
	private String type;
	private Boolean isSetted_type = false;
	private String source_id;
	private Boolean isSetted_source_id = false;
	private String source_name;
	private Boolean isSetted_source_name = false;
	private String risk_level_id;
	private Boolean isSetted_risk_level_id = false;
	private String risk_level_name;
	private Boolean isSetted_risk_level_name = false;
	private String department;
	private Boolean isSetted_department = false;
	private String business_sys;
	private Boolean isSetted_business_sys = false;
	private Integer state;
	private Boolean isSetted_state = false;
	private String resolve_user_id;
	private Boolean isSetted_resolve_user_id = false;
	private String resolve_user_name;
	private Boolean isSetted_resolve_user_name = false;
	private Long resolve_time;
	private Boolean isSetted_resolve_time = false;
	private String resolve_type_id;
	private Boolean isSetted_resolve_type_id = false;
	private String resolve_type_name;
	private Boolean isSetted_resolve_type_name = false;
	private String flow_id;
	private Boolean isSetted_flow_id = false;
	private String flow_name;
	private Boolean isSetted_flow_name = false;
	private String partner_id;
	private Boolean isSetted_partner_id = false;
	private Long plan_start_time;
	private Boolean isSetted_plan_start_time = false;
	private Long request_deal_time;
	private Boolean isSetted_request_deal_time = false;
	private String project_id;
	private Boolean isSetted_project_id = false;
	private String project_name;
	private Boolean isSetted_project_name = false;
	private String change_note;
	private Boolean isSetted_change_note = false;
	private Integer resolve;
	private Boolean isSetted_resolve = false;
	private String ssbz;
	private Boolean isSetted_ssbz = false;
	private String htbz;
	private Boolean isSetted_htbz = false;
	private String sys_fzr;
	private Boolean isSetted_sys_fzr = false;
	private String fzr_mobile;
	private Boolean isSetted_fzr_mobile = false;
	private String change_fzr;
	private Boolean isSetted_change_fzr = false;
	private String change_mobile;
	private Boolean isSetted_change_mobile = false;
	private String fxfx;
	private Boolean isSetted_fxfx = false;
	private String bgsjfw;
	private Boolean isSetted_bgsjfw = false;
	private String bgbz;
	private Boolean isSetted_bgbz = false;
	private String test_plan;
	private Boolean isSetted_test_plan = false;
	private String back_bz;
	private Boolean isSetted_back_bz = false;
	private String change_dept;
	private Boolean isSetted_change_dept = false;
	private String note;
	private Boolean isSetted_note = false;
	private Integer is_release;
	private Boolean isSetted_is_release = false;
	private String release_id;
	private Boolean isSetted_release_id = false;
	private Integer is_sys_change;
	private Boolean isSetted_is_sys_change = false;
	private String app_dept;
	private Boolean isSetted_app_dept = false;
	private Long app_date;
	private Boolean isSetted_app_date = false;
	private String change_gain;
	private Boolean isSetted_change_gain = false;
	private String dev_hour;
	private Boolean isSetted_dev_hour = false;
	private String solve_program;
	private Boolean isSetted_solve_program = false;
	private String sign_user;
	private Boolean isSetted_sign_user = false;
	private Long sign_date;
	private Boolean isSetted_sign_date = false;
	private String feed_user;
	private Boolean isSetted_feed_user = false;
	private Long feed_date;
	private Boolean isSetted_feed_date = false;
	private String feed_res;
	private Boolean isSetted_feed_res = false;
	private String key_user;
	private Boolean isSetted_key_user = false;
	private Long confirm_date;
	private Boolean isSetted_confirm_date = false;
	private String confirm_res;
	private Boolean isSetted_confirm_res = false;
	private String oa_id;
	private Boolean isSetted_oa_id = false;

	private void initBeanValues(){
		BEAN_VALUES = new HashMap<String, Object>();
		BEAN_VALUES.put("id",id);
			BEAN_VALUES.put("order_code", null);
			BEAN_VALUES.put("name", null);
			BEAN_VALUES.put("descrip", null);
			BEAN_VALUES.put("first_category_id", null);
			BEAN_VALUES.put("first_category_name", null);
			BEAN_VALUES.put("second_category_id", null);
			BEAN_VALUES.put("second_category_name", null);
			BEAN_VALUES.put("third_category_id", null);
			BEAN_VALUES.put("third_category_name", null);
			BEAN_VALUES.put("customer_id", null);
			BEAN_VALUES.put("customer_name", null);
			BEAN_VALUES.put("sub_customer_id", null);
			BEAN_VALUES.put("sub_customer_name", null);
			BEAN_VALUES.put("contact_name", null);
			BEAN_VALUES.put("contact_phone", null);
			BEAN_VALUES.put("create_user_id", null);
			BEAN_VALUES.put("create_user_name", null);
			BEAN_VALUES.put("create_time", null);
			BEAN_VALUES.put("type", null);
			BEAN_VALUES.put("source_id", null);
			BEAN_VALUES.put("source_name", null);
			BEAN_VALUES.put("risk_level_id", null);
			BEAN_VALUES.put("risk_level_name", null);
			BEAN_VALUES.put("department", null);
			BEAN_VALUES.put("business_sys", null);
			BEAN_VALUES.put("state", null);
			BEAN_VALUES.put("resolve_user_id", null);
			BEAN_VALUES.put("resolve_user_name", null);
			BEAN_VALUES.put("resolve_time", null);
			BEAN_VALUES.put("resolve_type_id", null);
			BEAN_VALUES.put("resolve_type_name", null);
			BEAN_VALUES.put("flow_id", null);
			BEAN_VALUES.put("flow_name", null);
			BEAN_VALUES.put("partner_id", null);
			BEAN_VALUES.put("plan_start_time", null);
			BEAN_VALUES.put("request_deal_time", null);
			BEAN_VALUES.put("project_id", null);
			BEAN_VALUES.put("project_name", null);
			BEAN_VALUES.put("change_note", null);
			BEAN_VALUES.put("resolve", null);
			BEAN_VALUES.put("ssbz", null);
			BEAN_VALUES.put("htbz", null);
			BEAN_VALUES.put("sys_fzr", null);
			BEAN_VALUES.put("fzr_mobile", null);
			BEAN_VALUES.put("change_fzr", null);
			BEAN_VALUES.put("change_mobile", null);
			BEAN_VALUES.put("fxfx", null);
			BEAN_VALUES.put("bgsjfw", null);
			BEAN_VALUES.put("bgbz", null);
			BEAN_VALUES.put("test_plan", null);
			BEAN_VALUES.put("back_bz", null);
			BEAN_VALUES.put("change_dept", null);
			BEAN_VALUES.put("note", null);
			BEAN_VALUES.put("is_release", null);
			BEAN_VALUES.put("release_id", null);
			BEAN_VALUES.put("is_sys_change", null);
			BEAN_VALUES.put("app_dept", null);
			BEAN_VALUES.put("app_date", null);
			BEAN_VALUES.put("change_gain", null);
			BEAN_VALUES.put("dev_hour", null);
			BEAN_VALUES.put("solve_program", null);
			BEAN_VALUES.put("sign_user", null);
			BEAN_VALUES.put("sign_date", null);
			BEAN_VALUES.put("feed_user", null);
			BEAN_VALUES.put("feed_date", null);
			BEAN_VALUES.put("feed_res", null);
			BEAN_VALUES.put("key_user", null);
			BEAN_VALUES.put("confirm_date", null);
			BEAN_VALUES.put("confirm_res", null);
			BEAN_VALUES.put("oa_id", null);
	}
	
	public SC_WORKFLOW_CHANGE() {
		initBeanValues();
	}
	
	public SC_WORKFLOW_CHANGE(String id) {
		super();
		this.id = id;
		initBeanValues();
		BEAN_VALUES.put("id",id);
	}

    /**
     * 获取ID
     */
	public String getId() {
		return this.id;
	}
	/**
     * 设置ID
     */
	public SC_WORKFLOW_CHANGE 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 SC_WORKFLOW_CHANGE set ");
			if (isSetted_order_code) {
				sBuffer.append("order_code=:order_code,");
			}
			if (isSetted_name) {
				sBuffer.append("name=:name,");
			}
			if (isSetted_descrip) {
				sBuffer.append("descrip=:descrip,");
			}
			if (isSetted_first_category_id) {
				sBuffer.append("first_category_id=:first_category_id,");
			}
			if (isSetted_first_category_name) {
				sBuffer.append("first_category_name=:first_category_name,");
			}
			if (isSetted_second_category_id) {
				sBuffer.append("second_category_id=:second_category_id,");
			}
			if (isSetted_second_category_name) {
				sBuffer.append("second_category_name=:second_category_name,");
			}
			if (isSetted_third_category_id) {
				sBuffer.append("third_category_id=:third_category_id,");
			}
			if (isSetted_third_category_name) {
				sBuffer.append("third_category_name=:third_category_name,");
			}
			if (isSetted_customer_id) {
				sBuffer.append("customer_id=:customer_id,");
			}
			if (isSetted_customer_name) {
				sBuffer.append("customer_name=:customer_name,");
			}
			if (isSetted_sub_customer_id) {
				sBuffer.append("sub_customer_id=:sub_customer_id,");
			}
			if (isSetted_sub_customer_name) {
				sBuffer.append("sub_customer_name=:sub_customer_name,");
			}
			if (isSetted_contact_name) {
				sBuffer.append("contact_name=:contact_name,");
			}
			if (isSetted_contact_phone) {
				sBuffer.append("contact_phone=:contact_phone,");
			}
			if (isSetted_create_user_id) {
				sBuffer.append("create_user_id=:create_user_id,");
			}
			if (isSetted_create_user_name) {
				sBuffer.append("create_user_name=:create_user_name,");
			}
			if (isSetted_create_time) {
				sBuffer.append("create_time=:create_time,");
			}
			if (isSetted_type) {
				sBuffer.append("type=:type,");
			}
			if (isSetted_source_id) {
				sBuffer.append("source_id=:source_id,");
			}
			if (isSetted_source_name) {
				sBuffer.append("source_name=:source_name,");
			}
			if (isSetted_risk_level_id) {
				sBuffer.append("risk_level_id=:risk_level_id,");
			}
			if (isSetted_risk_level_name) {
				sBuffer.append("risk_level_name=:risk_level_name,");
			}
			if (isSetted_department) {
				sBuffer.append("department=:department,");
			}
			if (isSetted_business_sys) {
				sBuffer.append("business_sys=:business_sys,");
			}
			if (isSetted_state) {
				sBuffer.append("state=:state,");
			}
			if (isSetted_resolve_user_id) {
				sBuffer.append("resolve_user_id=:resolve_user_id,");
			}
			if (isSetted_resolve_user_name) {
				sBuffer.append("resolve_user_name=:resolve_user_name,");
			}
			if (isSetted_resolve_time) {
				sBuffer.append("resolve_time=:resolve_time,");
			}
			if (isSetted_resolve_type_id) {
				sBuffer.append("resolve_type_id=:resolve_type_id,");
			}
			if (isSetted_resolve_type_name) {
				sBuffer.append("resolve_type_name=:resolve_type_name,");
			}
			if (isSetted_flow_id) {
				sBuffer.append("flow_id=:flow_id,");
			}
			if (isSetted_flow_name) {
				sBuffer.append("flow_name=:flow_name,");
			}
			if (isSetted_partner_id) {
				sBuffer.append("partner_id=:partner_id,");
			}
			if (isSetted_plan_start_time) {
				sBuffer.append("plan_start_time=:plan_start_time,");
			}
			if (isSetted_request_deal_time) {
				sBuffer.append("request_deal_time=:request_deal_time,");
			}
			if (isSetted_project_id) {
				sBuffer.append("project_id=:project_id,");
			}
			if (isSetted_project_name) {
				sBuffer.append("project_name=:project_name,");
			}
			if (isSetted_change_note) {
				sBuffer.append("change_note=:change_note,");
			}
			if (isSetted_resolve) {
				sBuffer.append("resolve=:resolve,");
			}
			if (isSetted_ssbz) {
				sBuffer.append("ssbz=:ssbz,");
			}
			if (isSetted_htbz) {
				sBuffer.append("htbz=:htbz,");
			}
			if (isSetted_sys_fzr) {
				sBuffer.append("sys_fzr=:sys_fzr,");
			}
			if (isSetted_fzr_mobile) {
				sBuffer.append("fzr_mobile=:fzr_mobile,");
			}
			if (isSetted_change_fzr) {
				sBuffer.append("change_fzr=:change_fzr,");
			}
			if (isSetted_change_mobile) {
				sBuffer.append("change_mobile=:change_mobile,");
			}
			if (isSetted_fxfx) {
				sBuffer.append("fxfx=:fxfx,");
			}
			if (isSetted_bgsjfw) {
				sBuffer.append("bgsjfw=:bgsjfw,");
			}
			if (isSetted_bgbz) {
				sBuffer.append("bgbz=:bgbz,");
			}
			if (isSetted_test_plan) {
				sBuffer.append("test_plan=:test_plan,");
			}
			if (isSetted_back_bz) {
				sBuffer.append("back_bz=:back_bz,");
			}
			if (isSetted_change_dept) {
				sBuffer.append("change_dept=:change_dept,");
			}
			if (isSetted_note) {
				sBuffer.append("note=:note,");
			}
			if (isSetted_is_release) {
				sBuffer.append("is_release=:is_release,");
			}
			if (isSetted_release_id) {
				sBuffer.append("release_id=:release_id,");
			}
			if (isSetted_is_sys_change) {
				sBuffer.append("is_sys_change=:is_sys_change,");
			}
			if (isSetted_app_dept) {
				sBuffer.append("app_dept=:app_dept,");
			}
			if (isSetted_app_date) {
				sBuffer.append("app_date=:app_date,");
			}
			if (isSetted_change_gain) {
				sBuffer.append("change_gain=:change_gain,");
			}
			if (isSetted_dev_hour) {
				sBuffer.append("dev_hour=:dev_hour,");
			}
			if (isSetted_solve_program) {
				sBuffer.append("solve_program=:solve_program,");
			}
			if (isSetted_sign_user) {
				sBuffer.append("sign_user=:sign_user,");
			}
			if (isSetted_sign_date) {
				sBuffer.append("sign_date=:sign_date,");
			}
			if (isSetted_feed_user) {
				sBuffer.append("feed_user=:feed_user,");
			}
			if (isSetted_feed_date) {
				sBuffer.append("feed_date=:feed_date,");
			}
			if (isSetted_feed_res) {
				sBuffer.append("feed_res=:feed_res,");
			}
			if (isSetted_key_user) {
				sBuffer.append("key_user=:key_user,");
			}
			if (isSetted_confirm_date) {
				sBuffer.append("confirm_date=:confirm_date,");
			}
			if (isSetted_confirm_res) {
				sBuffer.append("confirm_res=:confirm_res,");
			}
			if (isSetted_oa_id) {
				sBuffer.append("oa_id=:oa_id,");
			}
		String sql = sBuffer.toString();
		return StringUtils.removeEnd(sql, ",") + " where id=:id";
	}
	
	
	@Override
	public String getInsertSql() {
		StringBuffer sBuffer = new StringBuffer("insert into SC_WORKFLOW_CHANGE(");
		StringBuffer fileds = new StringBuffer("id,");
		StringBuffer values = new StringBuffer(":id,");		
			fileds.append("order_code,");
			values.append(":order_code,");
			fileds.append("name,");
			values.append(":name,");
			fileds.append("descrip,");
			values.append(":descrip,");
			fileds.append("first_category_id,");
			values.append(":first_category_id,");
			fileds.append("first_category_name,");
			values.append(":first_category_name,");
			fileds.append("second_category_id,");
			values.append(":second_category_id,");
			fileds.append("second_category_name,");
			values.append(":second_category_name,");
			fileds.append("third_category_id,");
			values.append(":third_category_id,");
			fileds.append("third_category_name,");
			values.append(":third_category_name,");
			fileds.append("customer_id,");
			values.append(":customer_id,");
			fileds.append("customer_name,");
			values.append(":customer_name,");
			fileds.append("sub_customer_id,");
			values.append(":sub_customer_id,");
			fileds.append("sub_customer_name,");
			values.append(":sub_customer_name,");
			fileds.append("contact_name,");
			values.append(":contact_name,");
			fileds.append("contact_phone,");
			values.append(":contact_phone,");
			fileds.append("create_user_id,");
			values.append(":create_user_id,");
			fileds.append("create_user_name,");
			values.append(":create_user_name,");
			fileds.append("create_time,");
			values.append(":create_time,");
			fileds.append("type,");
			values.append(":type,");
			fileds.append("source_id,");
			values.append(":source_id,");
			fileds.append("source_name,");
			values.append(":source_name,");
			fileds.append("risk_level_id,");
			values.append(":risk_level_id,");
			fileds.append("risk_level_name,");
			values.append(":risk_level_name,");
			fileds.append("department,");
			values.append(":department,");
			fileds.append("business_sys,");
			values.append(":business_sys,");
			fileds.append("state,");
			values.append(":state,");
			fileds.append("resolve_user_id,");
			values.append(":resolve_user_id,");
			fileds.append("resolve_user_name,");
			values.append(":resolve_user_name,");
			fileds.append("resolve_time,");
			values.append(":resolve_time,");
			fileds.append("resolve_type_id,");
			values.append(":resolve_type_id,");
			fileds.append("resolve_type_name,");
			values.append(":resolve_type_name,");
			fileds.append("flow_id,");
			values.append(":flow_id,");
			fileds.append("flow_name,");
			values.append(":flow_name,");
			fileds.append("partner_id,");
			values.append(":partner_id,");
			fileds.append("plan_start_time,");
			values.append(":plan_start_time,");
			fileds.append("request_deal_time,");
			values.append(":request_deal_time,");
			fileds.append("project_id,");
			values.append(":project_id,");
			fileds.append("project_name,");
			values.append(":project_name,");
			fileds.append("change_note,");
			values.append(":change_note,");
			fileds.append("resolve,");
			values.append(":resolve,");
			fileds.append("ssbz,");
			values.append(":ssbz,");
			fileds.append("htbz,");
			values.append(":htbz,");
			fileds.append("sys_fzr,");
			values.append(":sys_fzr,");
			fileds.append("fzr_mobile,");
			values.append(":fzr_mobile,");
			fileds.append("change_fzr,");
			values.append(":change_fzr,");
			fileds.append("change_mobile,");
			values.append(":change_mobile,");
			fileds.append("fxfx,");
			values.append(":fxfx,");
			fileds.append("bgsjfw,");
			values.append(":bgsjfw,");
			fileds.append("bgbz,");
			values.append(":bgbz,");
			fileds.append("test_plan,");
			values.append(":test_plan,");
			fileds.append("back_bz,");
			values.append(":back_bz,");
			fileds.append("change_dept,");
			values.append(":change_dept,");
			fileds.append("note,");
			values.append(":note,");
			fileds.append("is_release,");
			values.append(":is_release,");
			fileds.append("release_id,");
			values.append(":release_id,");
			fileds.append("is_sys_change,");
			values.append(":is_sys_change,");
			fileds.append("app_dept,");
			values.append(":app_dept,");
			fileds.append("app_date,");
			values.append(":app_date,");
			fileds.append("change_gain,");
			values.append(":change_gain,");
			fileds.append("dev_hour,");
			values.append(":dev_hour,");
			fileds.append("solve_program,");
			values.append(":solve_program,");
			fileds.append("sign_user,");
			values.append(":sign_user,");
			fileds.append("sign_date,");
			values.append(":sign_date,");
			fileds.append("feed_user,");
			values.append(":feed_user,");
			fileds.append("feed_date,");
			values.append(":feed_date,");
			fileds.append("feed_res,");
			values.append(":feed_res,");
			fileds.append("key_user,");
			values.append(":key_user,");
			fileds.append("confirm_date,");
			values.append(":confirm_date,");
			fileds.append("confirm_res,");
			values.append(":confirm_res,");
			fileds.append("oa_id,");
			values.append(":oa_id,");
		sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+ StringUtils.removeEnd(values.toString(), ",")+")");
		return sBuffer.toString();
	}
	

		/**
		 * 获取工单编码<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getOrder_code() {
			return order_code;
		}
		/**
		 * 设置工单编码<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setOrder_code(String order_code) {
			this.order_code = order_code;
			this.isSetted_order_code = true;
			BEAN_VALUES.put("order_code",order_code);
			return this;
		}
		/**
		 * 获取变更名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getName() {
			return name;
		}
		/**
		 * 设置变更名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setName(String name) {
			this.name = name;
			this.isSetted_name = true;
			BEAN_VALUES.put("name",name);
			return this;
		}
		/**
		 * 获取变更描述<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getDescrip() {
			return descrip;
		}
		/**
		 * 设置变更描述<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setDescrip(String descrip) {
			this.descrip = descrip;
			this.isSetted_descrip = true;
			BEAN_VALUES.put("descrip",descrip);
			return this;
		}
		/**
		 * 获取服务目录一级编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFirst_category_id() {
			return first_category_id;
		}
		/**
		 * 设置服务目录一级编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFirst_category_id(String first_category_id) {
			this.first_category_id = first_category_id;
			this.isSetted_first_category_id = true;
			BEAN_VALUES.put("first_category_id",first_category_id);
			return this;
		}
		/**
		 * 获取服务目录一级名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFirst_category_name() {
			return first_category_name;
		}
		/**
		 * 设置服务目录一级名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFirst_category_name(String first_category_name) {
			this.first_category_name = first_category_name;
			this.isSetted_first_category_name = true;
			BEAN_VALUES.put("first_category_name",first_category_name);
			return this;
		}
		/**
		 * 获取服务目录二级编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSecond_category_id() {
			return second_category_id;
		}
		/**
		 * 设置服务目录二级编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSecond_category_id(String second_category_id) {
			this.second_category_id = second_category_id;
			this.isSetted_second_category_id = true;
			BEAN_VALUES.put("second_category_id",second_category_id);
			return this;
		}
		/**
		 * 获取服务目录二级名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSecond_category_name() {
			return second_category_name;
		}
		/**
		 * 设置服务目录二级名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSecond_category_name(String second_category_name) {
			this.second_category_name = second_category_name;
			this.isSetted_second_category_name = true;
			BEAN_VALUES.put("second_category_name",second_category_name);
			return this;
		}
		/**
		 * 获取服务目录三级编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getThird_category_id() {
			return third_category_id;
		}
		/**
		 * 设置服务目录三级编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setThird_category_id(String third_category_id) {
			this.third_category_id = third_category_id;
			this.isSetted_third_category_id = true;
			BEAN_VALUES.put("third_category_id",third_category_id);
			return this;
		}
		/**
		 * 获取服务目录三级名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getThird_category_name() {
			return third_category_name;
		}
		/**
		 * 设置服务目录三级名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setThird_category_name(String third_category_name) {
			this.third_category_name = third_category_name;
			this.isSetted_third_category_name = true;
			BEAN_VALUES.put("third_category_name",third_category_name);
			return this;
		}
		/**
		 * 获取客户编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getCustomer_id() {
			return customer_id;
		}
		/**
		 * 设置客户编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setCustomer_id(String customer_id) {
			this.customer_id = customer_id;
			this.isSetted_customer_id = true;
			BEAN_VALUES.put("customer_id",customer_id);
			return this;
		}
		/**
		 * 获取客户名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getCustomer_name() {
			return customer_name;
		}
		/**
		 * 设置客户名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setCustomer_name(String customer_name) {
			this.customer_name = customer_name;
			this.isSetted_customer_name = true;
			BEAN_VALUES.put("customer_name",customer_name);
			return this;
		}
		/**
		 * 获取下级单位编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSub_customer_id() {
			return sub_customer_id;
		}
		/**
		 * 设置下级单位编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSub_customer_id(String sub_customer_id) {
			this.sub_customer_id = sub_customer_id;
			this.isSetted_sub_customer_id = true;
			BEAN_VALUES.put("sub_customer_id",sub_customer_id);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSub_customer_name() {
			return sub_customer_name;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSub_customer_name(String sub_customer_name) {
			this.sub_customer_name = sub_customer_name;
			this.isSetted_sub_customer_name = true;
			BEAN_VALUES.put("sub_customer_name",sub_customer_name);
			return this;
		}
		/**
		 * 获取客户联系人名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getContact_name() {
			return contact_name;
		}
		/**
		 * 设置客户联系人名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setContact_name(String contact_name) {
			this.contact_name = contact_name;
			this.isSetted_contact_name = true;
			BEAN_VALUES.put("contact_name",contact_name);
			return this;
		}
		/**
		 * 获取客户联系方式<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getContact_phone() {
			return contact_phone;
		}
		/**
		 * 设置客户联系方式<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setContact_phone(String contact_phone) {
			this.contact_phone = contact_phone;
			this.isSetted_contact_phone = true;
			BEAN_VALUES.put("contact_phone",contact_phone);
			return this;
		}
		/**
		 * 获取创建人编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getCreate_user_id() {
			return create_user_id;
		}
		/**
		 * 设置创建人编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setCreate_user_id(String create_user_id) {
			this.create_user_id = create_user_id;
			this.isSetted_create_user_id = true;
			BEAN_VALUES.put("create_user_id",create_user_id);
			return this;
		}
		/**
		 * 获取创建人名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getCreate_user_name() {
			return create_user_name;
		}
		/**
		 * 设置创建人名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setCreate_user_name(String create_user_name) {
			this.create_user_name = create_user_name;
			this.isSetted_create_user_name = true;
			BEAN_VALUES.put("create_user_name",create_user_name);
			return this;
		}
		/**
		 * 获取创建时间<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getCreate_time() {
			return create_time;
		}
		/**
		 * 设置创建时间<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setCreate_time(Long create_time) {
			this.create_time = create_time;
			this.isSetted_create_time = true;
			BEAN_VALUES.put("create_time",create_time);
			return this;
		}
		/**
		 * 获取变更类型（1=简单变更；2=标准变更；3=紧急变更）<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getType() {
			return type;
		}
		/**
		 * 设置变更类型（1=简单变更；2=标准变更；3=紧急变更）<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setType(String type) {
			this.type = type;
			this.isSetted_type = true;
			BEAN_VALUES.put("type",type);
			return this;
		}
		/**
		 * 获取变更来源编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSource_id() {
			return source_id;
		}
		/**
		 * 设置变更来源编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSource_id(String source_id) {
			this.source_id = source_id;
			this.isSetted_source_id = true;
			BEAN_VALUES.put("source_id",source_id);
			return this;
		}
		/**
		 * 获取变更来源名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSource_name() {
			return source_name;
		}
		/**
		 * 设置变更来源名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSource_name(String source_name) {
			this.source_name = source_name;
			this.isSetted_source_name = true;
			BEAN_VALUES.put("source_name",source_name);
			return this;
		}
		/**
		 * 获取风险等级编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getRisk_level_id() {
			return risk_level_id;
		}
		/**
		 * 设置风险等级编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setRisk_level_id(String risk_level_id) {
			this.risk_level_id = risk_level_id;
			this.isSetted_risk_level_id = true;
			BEAN_VALUES.put("risk_level_id",risk_level_id);
			return this;
		}
		/**
		 * 获取风险等级名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getRisk_level_name() {
			return risk_level_name;
		}
		/**
		 * 设置风险等级名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setRisk_level_name(String risk_level_name) {
			this.risk_level_name = risk_level_name;
			this.isSetted_risk_level_name = true;
			BEAN_VALUES.put("risk_level_name",risk_level_name);
			return this;
		}
		/**
		 * 获取变更需求部门<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getDepartment() {
			return department;
		}
		/**
		 * 设置变更需求部门<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setDepartment(String department) {
			this.department = department;
			this.isSetted_department = true;
			BEAN_VALUES.put("department",department);
			return this;
		}
		/**
		 * 获取业务系统<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getBusiness_sys() {
			return business_sys;
		}
		/**
		 * 设置业务系统<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setBusiness_sys(String business_sys) {
			this.business_sys = business_sys;
			this.isSetted_business_sys = true;
			BEAN_VALUES.put("business_sys",business_sys);
			return this;
		}
		/**
		 * 获取变更状态（1=已受理；2=需求审批中；3=方案制定中；4=方案审批中；9=已解决；10=已关闭；11=已评价）<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Integer getState() {
			return state;
		}
		/**
		 * 设置变更状态（1=已受理；2=需求审批中；3=方案制定中；4=方案审批中；9=已解决；10=已关闭；11=已评价）<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setState(Integer state) {
			this.state = state;
			this.isSetted_state = true;
			BEAN_VALUES.put("state",state);
			return this;
		}
		/**
		 * 获取解决人编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getResolve_user_id() {
			return resolve_user_id;
		}
		/**
		 * 设置解决人编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve_user_id(String resolve_user_id) {
			this.resolve_user_id = resolve_user_id;
			this.isSetted_resolve_user_id = true;
			BEAN_VALUES.put("resolve_user_id",resolve_user_id);
			return this;
		}
		/**
		 * 获取解决人姓名<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getResolve_user_name() {
			return resolve_user_name;
		}
		/**
		 * 设置解决人姓名<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve_user_name(String resolve_user_name) {
			this.resolve_user_name = resolve_user_name;
			this.isSetted_resolve_user_name = true;
			BEAN_VALUES.put("resolve_user_name",resolve_user_name);
			return this;
		}
		/**
		 * 获取解决时间<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getResolve_time() {
			return resolve_time;
		}
		/**
		 * 设置解决时间<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve_time(Long resolve_time) {
			this.resolve_time = resolve_time;
			this.isSetted_resolve_time = true;
			BEAN_VALUES.put("resolve_time",resolve_time);
			return this;
		}
		/**
		 * 获取解决方式编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getResolve_type_id() {
			return resolve_type_id;
		}
		/**
		 * 设置解决方式编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve_type_id(String resolve_type_id) {
			this.resolve_type_id = resolve_type_id;
			this.isSetted_resolve_type_id = true;
			BEAN_VALUES.put("resolve_type_id",resolve_type_id);
			return this;
		}
		/**
		 * 获取解决方式名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getResolve_type_name() {
			return resolve_type_name;
		}
		/**
		 * 设置解决方式名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve_type_name(String resolve_type_name) {
			this.resolve_type_name = resolve_type_name;
			this.isSetted_resolve_type_name = true;
			BEAN_VALUES.put("resolve_type_name",resolve_type_name);
			return this;
		}
		/**
		 * 获取流程编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFlow_id() {
			return flow_id;
		}
		/**
		 * 设置流程编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFlow_id(String flow_id) {
			this.flow_id = flow_id;
			this.isSetted_flow_id = true;
			BEAN_VALUES.put("flow_id",flow_id);
			return this;
		}
		/**
		 * 获取流程名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFlow_name() {
			return flow_name;
		}
		/**
		 * 设置流程名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFlow_name(String flow_name) {
			this.flow_name = flow_name;
			this.isSetted_flow_name = true;
			BEAN_VALUES.put("flow_name",flow_name);
			return this;
		}
		/**
		 * 获取加盟商编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getPartner_id() {
			return partner_id;
		}
		/**
		 * 设置加盟商编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setPartner_id(String partner_id) {
			this.partner_id = partner_id;
			this.isSetted_partner_id = true;
			BEAN_VALUES.put("partner_id",partner_id);
			return this;
		}
		/**
		 * 获取计划开始时间<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getPlan_start_time() {
			return plan_start_time;
		}
		/**
		 * 设置计划开始时间<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setPlan_start_time(Long plan_start_time) {
			this.plan_start_time = plan_start_time;
			this.isSetted_plan_start_time = true;
			BEAN_VALUES.put("plan_start_time",plan_start_time);
			return this;
		}
		/**
		 * 获取计划解决时间<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getRequest_deal_time() {
			return request_deal_time;
		}
		/**
		 * 设置计划解决时间<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setRequest_deal_time(Long request_deal_time) {
			this.request_deal_time = request_deal_time;
			this.isSetted_request_deal_time = true;
			BEAN_VALUES.put("request_deal_time",request_deal_time);
			return this;
		}
		/**
		 * 获取项目编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getProject_id() {
			return project_id;
		}
		/**
		 * 设置项目编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setProject_id(String project_id) {
			this.project_id = project_id;
			this.isSetted_project_id = true;
			BEAN_VALUES.put("project_id",project_id);
			return this;
		}
		/**
		 * 获取项目名称<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getProject_name() {
			return project_name;
		}
		/**
		 * 设置项目名称<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setProject_name(String project_name) {
			this.project_name = project_name;
			this.isSetted_project_name = true;
			BEAN_VALUES.put("project_name",project_name);
			return this;
		}
		/**
		 * 获取变更需求说明<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getChange_note() {
			return change_note;
		}
		/**
		 * 设置变更需求说明<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setChange_note(String change_note) {
			this.change_note = change_note;
			this.isSetted_change_note = true;
			BEAN_VALUES.put("change_note",change_note);
			return this;
		}
		/**
		 * 获取实施结果(1=实施成功；2=实施失败)<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Integer getResolve() {
			return resolve;
		}
		/**
		 * 设置实施结果(1=实施成功；2=实施失败)<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setResolve(Integer resolve) {
			this.resolve = resolve;
			this.isSetted_resolve = true;
			BEAN_VALUES.put("resolve",resolve);
			return this;
		}
		/**
		 * 获取实施步骤<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSsbz() {
			return ssbz;
		}
		/**
		 * 设置实施步骤<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSsbz(String ssbz) {
			this.ssbz = ssbz;
			this.isSetted_ssbz = true;
			BEAN_VALUES.put("ssbz",ssbz);
			return this;
		}
		/**
		 * 获取回退步骤<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getHtbz() {
			return htbz;
		}
		/**
		 * 设置回退步骤<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setHtbz(String htbz) {
			this.htbz = htbz;
			this.isSetted_htbz = true;
			BEAN_VALUES.put("htbz",htbz);
			return this;
		}
		/**
		 * 获取系统负责人<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSys_fzr() {
			return sys_fzr;
		}
		/**
		 * 设置系统负责人<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSys_fzr(String sys_fzr) {
			this.sys_fzr = sys_fzr;
			this.isSetted_sys_fzr = true;
			BEAN_VALUES.put("sys_fzr",sys_fzr);
			return this;
		}
		/**
		 * 获取系统负责人联系电话<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFzr_mobile() {
			return fzr_mobile;
		}
		/**
		 * 设置系统负责人联系电话<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFzr_mobile(String fzr_mobile) {
			this.fzr_mobile = fzr_mobile;
			this.isSetted_fzr_mobile = true;
			BEAN_VALUES.put("fzr_mobile",fzr_mobile);
			return this;
		}
		/**
		 * 获取变更负责人<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getChange_fzr() {
			return change_fzr;
		}
		/**
		 * 设置变更负责人<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setChange_fzr(String change_fzr) {
			this.change_fzr = change_fzr;
			this.isSetted_change_fzr = true;
			BEAN_VALUES.put("change_fzr",change_fzr);
			return this;
		}
		/**
		 * 获取变更负责人联系电话<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getChange_mobile() {
			return change_mobile;
		}
		/**
		 * 设置变更负责人联系电话<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setChange_mobile(String change_mobile) {
			this.change_mobile = change_mobile;
			this.isSetted_change_mobile = true;
			BEAN_VALUES.put("change_mobile",change_mobile);
			return this;
		}
		/**
		 * 获取风险分析<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFxfx() {
			return fxfx;
		}
		/**
		 * 设置风险分析<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFxfx(String fxfx) {
			this.fxfx = fxfx;
			this.isSetted_fxfx = true;
			BEAN_VALUES.put("fxfx",fxfx);
			return this;
		}
		/**
		 * 获取变更涉及范围<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getBgsjfw() {
			return bgsjfw;
		}
		/**
		 * 设置变更涉及范围<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setBgsjfw(String bgsjfw) {
			this.bgsjfw = bgsjfw;
			this.isSetted_bgsjfw = true;
			BEAN_VALUES.put("bgsjfw",bgsjfw);
			return this;
		}
		/**
		 * 获取变更步骤<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getBgbz() {
			return bgbz;
		}
		/**
		 * 设置变更步骤<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setBgbz(String bgbz) {
			this.bgbz = bgbz;
			this.isSetted_bgbz = true;
			BEAN_VALUES.put("bgbz",bgbz);
			return this;
		}
		/**
		 * 获取测试计划及测试步骤<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getTest_plan() {
			return test_plan;
		}
		/**
		 * 设置测试计划及测试步骤<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setTest_plan(String test_plan) {
			this.test_plan = test_plan;
			this.isSetted_test_plan = true;
			BEAN_VALUES.put("test_plan",test_plan);
			return this;
		}
		/**
		 * 获取回退步骤和回退条件<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getBack_bz() {
			return back_bz;
		}
		/**
		 * 设置回退步骤和回退条件<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setBack_bz(String back_bz) {
			this.back_bz = back_bz;
			this.isSetted_back_bz = true;
			BEAN_VALUES.put("back_bz",back_bz);
			return this;
		}
		/**
		 * 获取变更需要通知部门<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getChange_dept() {
			return change_dept;
		}
		/**
		 * 设置变更需要通知部门<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setChange_dept(String change_dept) {
			this.change_dept = change_dept;
			this.isSetted_change_dept = true;
			BEAN_VALUES.put("change_dept",change_dept);
			return this;
		}
		/**
		 * 获取备注说明<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getNote() {
			return note;
		}
		/**
		 * 设置备注说明<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setNote(String note) {
			this.note = note;
			this.isSetted_note = true;
			BEAN_VALUES.put("note",note);
			return this;
		}
		/**
		 * 获取是否发布（1=是；2=否）<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Integer getIs_release() {
			return is_release;
		}
		/**
		 * 设置是否发布（1=是；2=否）<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setIs_release(Integer is_release) {
			this.is_release = is_release;
			this.isSetted_is_release = true;
			BEAN_VALUES.put("is_release",is_release);
			return this;
		}
		/**
		 * 获取发布工单编号<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getRelease_id() {
			return release_id;
		}
		/**
		 * 设置发布工单编号<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setRelease_id(String release_id) {
			this.release_id = release_id;
			this.isSetted_release_id = true;
			BEAN_VALUES.put("release_id",release_id);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Integer getIs_sys_change() {
			return is_sys_change;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setIs_sys_change(Integer is_sys_change) {
			this.is_sys_change = is_sys_change;
			this.isSetted_is_sys_change = true;
			BEAN_VALUES.put("is_sys_change",is_sys_change);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getApp_dept() {
			return app_dept;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setApp_dept(String app_dept) {
			this.app_dept = app_dept;
			this.isSetted_app_dept = true;
			BEAN_VALUES.put("app_dept",app_dept);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getApp_date() {
			return app_date;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setApp_date(Long app_date) {
			this.app_date = app_date;
			this.isSetted_app_date = true;
			BEAN_VALUES.put("app_date",app_date);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getChange_gain() {
			return change_gain;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setChange_gain(String change_gain) {
			this.change_gain = change_gain;
			this.isSetted_change_gain = true;
			BEAN_VALUES.put("change_gain",change_gain);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getDev_hour() {
			return dev_hour;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setDev_hour(String dev_hour) {
			this.dev_hour = dev_hour;
			this.isSetted_dev_hour = true;
			BEAN_VALUES.put("dev_hour",dev_hour);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSolve_program() {
			return solve_program;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSolve_program(String solve_program) {
			this.solve_program = solve_program;
			this.isSetted_solve_program = true;
			BEAN_VALUES.put("solve_program",solve_program);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getSign_user() {
			return sign_user;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSign_user(String sign_user) {
			this.sign_user = sign_user;
			this.isSetted_sign_user = true;
			BEAN_VALUES.put("sign_user",sign_user);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getSign_date() {
			return sign_date;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setSign_date(Long sign_date) {
			this.sign_date = sign_date;
			this.isSetted_sign_date = true;
			BEAN_VALUES.put("sign_date",sign_date);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFeed_user() {
			return feed_user;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFeed_user(String feed_user) {
			this.feed_user = feed_user;
			this.isSetted_feed_user = true;
			BEAN_VALUES.put("feed_user",feed_user);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getFeed_date() {
			return feed_date;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFeed_date(Long feed_date) {
			this.feed_date = feed_date;
			this.isSetted_feed_date = true;
			BEAN_VALUES.put("feed_date",feed_date);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getFeed_res() {
			return feed_res;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setFeed_res(String feed_res) {
			this.feed_res = feed_res;
			this.isSetted_feed_res = true;
			BEAN_VALUES.put("feed_res",feed_res);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getKey_user() {
			return key_user;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setKey_user(String key_user) {
			this.key_user = key_user;
			this.isSetted_key_user = true;
			BEAN_VALUES.put("key_user",key_user);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public Long getConfirm_date() {
			return confirm_date;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setConfirm_date(Long confirm_date) {
			this.confirm_date = confirm_date;
			this.isSetted_confirm_date = true;
			BEAN_VALUES.put("confirm_date",confirm_date);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getConfirm_res() {
			return confirm_res;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setConfirm_res(String confirm_res) {
			this.confirm_res = confirm_res;
			this.isSetted_confirm_res = true;
			BEAN_VALUES.put("confirm_res",confirm_res);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2017-03-28 hh:02
		 */
		public String getOa_id() {
			return oa_id;
		}
		/**
		 * 设置<BR/>
		 * 2017-03-28 hh:02
		 */
		public SC_WORKFLOW_CHANGE setOa_id(String oa_id) {
			this.oa_id = oa_id;
			this.isSetted_oa_id = true;
			BEAN_VALUES.put("oa_id",oa_id);
			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 SC_WORKFLOW_CHANGE getInstanceById() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("获取Bean时ID不能为空");
			}
			return dao.queryForBean("select * from " + getTableName() + " where id=:id", BEAN_VALUES, this);
		}
	
		
		
		@Override
		public SC_WORKFLOW_CHANGE queryForBean() {
			StringBuffer sBuffer = new StringBuffer("select * from SC_WORKFLOW_CHANGE where ");
			if(isSetted_id){
				sBuffer.append("id=:id and ");
			}
				if (isSetted_order_code) {
					sBuffer.append("order_code=:order_code and ");
				}
				if (isSetted_name) {
					sBuffer.append("name=:name and ");
				}
				if (isSetted_descrip) {
					sBuffer.append("descrip=:descrip and ");
				}
				if (isSetted_first_category_id) {
					sBuffer.append("first_category_id=:first_category_id and ");
				}
				if (isSetted_first_category_name) {
					sBuffer.append("first_category_name=:first_category_name and ");
				}
				if (isSetted_second_category_id) {
					sBuffer.append("second_category_id=:second_category_id and ");
				}
				if (isSetted_second_category_name) {
					sBuffer.append("second_category_name=:second_category_name and ");
				}
				if (isSetted_third_category_id) {
					sBuffer.append("third_category_id=:third_category_id and ");
				}
				if (isSetted_third_category_name) {
					sBuffer.append("third_category_name=:third_category_name and ");
				}
				if (isSetted_customer_id) {
					sBuffer.append("customer_id=:customer_id and ");
				}
				if (isSetted_customer_name) {
					sBuffer.append("customer_name=:customer_name and ");
				}
				if (isSetted_sub_customer_id) {
					sBuffer.append("sub_customer_id=:sub_customer_id and ");
				}
				if (isSetted_sub_customer_name) {
					sBuffer.append("sub_customer_name=:sub_customer_name and ");
				}
				if (isSetted_contact_name) {
					sBuffer.append("contact_name=:contact_name and ");
				}
				if (isSetted_contact_phone) {
					sBuffer.append("contact_phone=:contact_phone and ");
				}
				if (isSetted_create_user_id) {
					sBuffer.append("create_user_id=:create_user_id and ");
				}
				if (isSetted_create_user_name) {
					sBuffer.append("create_user_name=:create_user_name and ");
				}
				if (isSetted_create_time) {
					sBuffer.append("create_time=:create_time and ");
				}
				if (isSetted_type) {
					sBuffer.append("type=:type and ");
				}
				if (isSetted_source_id) {
					sBuffer.append("source_id=:source_id and ");
				}
				if (isSetted_source_name) {
					sBuffer.append("source_name=:source_name and ");
				}
				if (isSetted_risk_level_id) {
					sBuffer.append("risk_level_id=:risk_level_id and ");
				}
				if (isSetted_risk_level_name) {
					sBuffer.append("risk_level_name=:risk_level_name and ");
				}
				if (isSetted_department) {
					sBuffer.append("department=:department and ");
				}
				if (isSetted_business_sys) {
					sBuffer.append("business_sys=:business_sys and ");
				}
				if (isSetted_state) {
					sBuffer.append("state=:state and ");
				}
				if (isSetted_resolve_user_id) {
					sBuffer.append("resolve_user_id=:resolve_user_id and ");
				}
				if (isSetted_resolve_user_name) {
					sBuffer.append("resolve_user_name=:resolve_user_name and ");
				}
				if (isSetted_resolve_time) {
					sBuffer.append("resolve_time=:resolve_time and ");
				}
				if (isSetted_resolve_type_id) {
					sBuffer.append("resolve_type_id=:resolve_type_id and ");
				}
				if (isSetted_resolve_type_name) {
					sBuffer.append("resolve_type_name=:resolve_type_name and ");
				}
				if (isSetted_flow_id) {
					sBuffer.append("flow_id=:flow_id and ");
				}
				if (isSetted_flow_name) {
					sBuffer.append("flow_name=:flow_name and ");
				}
				if (isSetted_partner_id) {
					sBuffer.append("partner_id=:partner_id and ");
				}
				if (isSetted_plan_start_time) {
					sBuffer.append("plan_start_time=:plan_start_time and ");
				}
				if (isSetted_request_deal_time) {
					sBuffer.append("request_deal_time=:request_deal_time and ");
				}
				if (isSetted_project_id) {
					sBuffer.append("project_id=:project_id and ");
				}
				if (isSetted_project_name) {
					sBuffer.append("project_name=:project_name and ");
				}
				if (isSetted_change_note) {
					sBuffer.append("change_note=:change_note and ");
				}
				if (isSetted_resolve) {
					sBuffer.append("resolve=:resolve and ");
				}
				if (isSetted_ssbz) {
					sBuffer.append("ssbz=:ssbz and ");
				}
				if (isSetted_htbz) {
					sBuffer.append("htbz=:htbz and ");
				}
				if (isSetted_sys_fzr) {
					sBuffer.append("sys_fzr=:sys_fzr and ");
				}
				if (isSetted_fzr_mobile) {
					sBuffer.append("fzr_mobile=:fzr_mobile and ");
				}
				if (isSetted_change_fzr) {
					sBuffer.append("change_fzr=:change_fzr and ");
				}
				if (isSetted_change_mobile) {
					sBuffer.append("change_mobile=:change_mobile and ");
				}
				if (isSetted_fxfx) {
					sBuffer.append("fxfx=:fxfx and ");
				}
				if (isSetted_bgsjfw) {
					sBuffer.append("bgsjfw=:bgsjfw and ");
				}
				if (isSetted_bgbz) {
					sBuffer.append("bgbz=:bgbz and ");
				}
				if (isSetted_test_plan) {
					sBuffer.append("test_plan=:test_plan and ");
				}
				if (isSetted_back_bz) {
					sBuffer.append("back_bz=:back_bz and ");
				}
				if (isSetted_change_dept) {
					sBuffer.append("change_dept=:change_dept and ");
				}
				if (isSetted_note) {
					sBuffer.append("note=:note and ");
				}
				if (isSetted_is_release) {
					sBuffer.append("is_release=:is_release and ");
				}
				if (isSetted_release_id) {
					sBuffer.append("release_id=:release_id and ");
				}
				if (isSetted_is_sys_change) {
					sBuffer.append("is_sys_change=:is_sys_change and ");
				}
				if (isSetted_app_dept) {
					sBuffer.append("app_dept=:app_dept and ");
				}
				if (isSetted_app_date) {
					sBuffer.append("app_date=:app_date and ");
				}
				if (isSetted_change_gain) {
					sBuffer.append("change_gain=:change_gain and ");
				}
				if (isSetted_dev_hour) {
					sBuffer.append("dev_hour=:dev_hour and ");
				}
				if (isSetted_solve_program) {
					sBuffer.append("solve_program=:solve_program and ");
				}
				if (isSetted_sign_user) {
					sBuffer.append("sign_user=:sign_user and ");
				}
				if (isSetted_sign_date) {
					sBuffer.append("sign_date=:sign_date and ");
				}
				if (isSetted_feed_user) {
					sBuffer.append("feed_user=:feed_user and ");
				}
				if (isSetted_feed_date) {
					sBuffer.append("feed_date=:feed_date and ");
				}
				if (isSetted_feed_res) {
					sBuffer.append("feed_res=:feed_res and ");
				}
				if (isSetted_key_user) {
					sBuffer.append("key_user=:key_user and ");
				}
				if (isSetted_confirm_date) {
					sBuffer.append("confirm_date=:confirm_date and ");
				}
				if (isSetted_confirm_res) {
					sBuffer.append("confirm_res=:confirm_res and ");
				}
				if (isSetted_oa_id) {
					sBuffer.append("oa_id=:oa_id and ");
				}
			String sql = sBuffer.toString();
			sql = StringUtils.removeEnd(sql, " and ");
			return dao.queryForBean(sql,this);
		}
	
		@Override
		public String getTableName() {
			return "SC_WORKFLOW_CHANGE";
		}
		
		
		public Map getBeanValues(){
			return this.BEAN_VALUES;
		}
	
		@Override
		public SC_WORKFLOW_CHANGE insert() {
			if (StringUtils.isBlank(id)) {
				this.setId(StringUtil.getUUID());
			}
			dao.execute(getInsertSql(),BEAN_VALUES);
			return this;
		}
	
		@Override
		public SC_WORKFLOW_CHANGE update() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("更新Bean时ID不能为空");
			}
			dao.execute(getUpdateSql(),BEAN_VALUES);
			return this;
		}  
		
		public SC_WORKFLOW_CHANGE 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 SC_WORKFLOW_CHANGE 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("ORDER_CODE");
			BEAN_VALUES.put("order_code",obj);
				this.setOrder_code(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("NAME");
			BEAN_VALUES.put("name",obj);
				this.setName(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DESCRIP");
			BEAN_VALUES.put("descrip",obj);
				this.setDescrip(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FIRST_CATEGORY_ID");
			BEAN_VALUES.put("first_category_id",obj);
				this.setFirst_category_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FIRST_CATEGORY_NAME");
			BEAN_VALUES.put("first_category_name",obj);
				this.setFirst_category_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SECOND_CATEGORY_ID");
			BEAN_VALUES.put("second_category_id",obj);
				this.setSecond_category_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SECOND_CATEGORY_NAME");
			BEAN_VALUES.put("second_category_name",obj);
				this.setSecond_category_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("THIRD_CATEGORY_ID");
			BEAN_VALUES.put("third_category_id",obj);
				this.setThird_category_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("THIRD_CATEGORY_NAME");
			BEAN_VALUES.put("third_category_name",obj);
				this.setThird_category_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CUSTOMER_ID");
			BEAN_VALUES.put("customer_id",obj);
				this.setCustomer_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CUSTOMER_NAME");
			BEAN_VALUES.put("customer_name",obj);
				this.setCustomer_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SUB_CUSTOMER_ID");
			BEAN_VALUES.put("sub_customer_id",obj);
				this.setSub_customer_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SUB_CUSTOMER_NAME");
			BEAN_VALUES.put("sub_customer_name",obj);
				this.setSub_customer_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CONTACT_NAME");
			BEAN_VALUES.put("contact_name",obj);
				this.setContact_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CONTACT_PHONE");
			BEAN_VALUES.put("contact_phone",obj);
				this.setContact_phone(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CREATE_USER_ID");
			BEAN_VALUES.put("create_user_id",obj);
				this.setCreate_user_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CREATE_USER_NAME");
			BEAN_VALUES.put("create_user_name",obj);
				this.setCreate_user_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CREATE_TIME");
			BEAN_VALUES.put("create_time",obj);
				this.setCreate_time(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("TYPE");
			BEAN_VALUES.put("type",obj);
				this.setType(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SOURCE_ID");
			BEAN_VALUES.put("source_id",obj);
				this.setSource_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SOURCE_NAME");
			BEAN_VALUES.put("source_name",obj);
				this.setSource_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RISK_LEVEL_ID");
			BEAN_VALUES.put("risk_level_id",obj);
				this.setRisk_level_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RISK_LEVEL_NAME");
			BEAN_VALUES.put("risk_level_name",obj);
				this.setRisk_level_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEPARTMENT");
			BEAN_VALUES.put("department",obj);
				this.setDepartment(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BUSINESS_SYS");
			BEAN_VALUES.put("business_sys",obj);
				this.setBusiness_sys(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("STATE");
			BEAN_VALUES.put("state",obj);
				this.setState(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("RESOLVE_USER_ID");
			BEAN_VALUES.put("resolve_user_id",obj);
				this.setResolve_user_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RESOLVE_USER_NAME");
			BEAN_VALUES.put("resolve_user_name",obj);
				this.setResolve_user_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RESOLVE_TIME");
			BEAN_VALUES.put("resolve_time",obj);
				this.setResolve_time(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("RESOLVE_TYPE_ID");
			BEAN_VALUES.put("resolve_type_id",obj);
				this.setResolve_type_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RESOLVE_TYPE_NAME");
			BEAN_VALUES.put("resolve_type_name",obj);
				this.setResolve_type_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FLOW_ID");
			BEAN_VALUES.put("flow_id",obj);
				this.setFlow_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FLOW_NAME");
			BEAN_VALUES.put("flow_name",obj);
				this.setFlow_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("PARTNER_ID");
			BEAN_VALUES.put("partner_id",obj);
				this.setPartner_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("PLAN_START_TIME");
			BEAN_VALUES.put("plan_start_time",obj);
				this.setPlan_start_time(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("REQUEST_DEAL_TIME");
			BEAN_VALUES.put("request_deal_time",obj);
				this.setRequest_deal_time(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("PROJECT_ID");
			BEAN_VALUES.put("project_id",obj);
				this.setProject_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("PROJECT_NAME");
			BEAN_VALUES.put("project_name",obj);
				this.setProject_name(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CHANGE_NOTE");
			BEAN_VALUES.put("change_note",obj);
				this.setChange_note(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("RESOLVE");
			BEAN_VALUES.put("resolve",obj);
				this.setResolve(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("SSBZ");
			BEAN_VALUES.put("ssbz",obj);
				this.setSsbz(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("HTBZ");
			BEAN_VALUES.put("htbz",obj);
				this.setHtbz(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SYS_FZR");
			BEAN_VALUES.put("sys_fzr",obj);
				this.setSys_fzr(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FZR_MOBILE");
			BEAN_VALUES.put("fzr_mobile",obj);
				this.setFzr_mobile(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CHANGE_FZR");
			BEAN_VALUES.put("change_fzr",obj);
				this.setChange_fzr(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CHANGE_MOBILE");
			BEAN_VALUES.put("change_mobile",obj);
				this.setChange_mobile(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FXFX");
			BEAN_VALUES.put("fxfx",obj);
				this.setFxfx(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BGSJFW");
			BEAN_VALUES.put("bgsjfw",obj);
				this.setBgsjfw(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BGBZ");
			BEAN_VALUES.put("bgbz",obj);
				this.setBgbz(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("TEST_PLAN");
			BEAN_VALUES.put("test_plan",obj);
				this.setTest_plan(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BACK_BZ");
			BEAN_VALUES.put("back_bz",obj);
				this.setBack_bz(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CHANGE_DEPT");
			BEAN_VALUES.put("change_dept",obj);
				this.setChange_dept(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("NOTE");
			BEAN_VALUES.put("note",obj);
				this.setNote(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("IS_RELEASE");
			BEAN_VALUES.put("is_release",obj);
				this.setIs_release(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("RELEASE_ID");
			BEAN_VALUES.put("release_id",obj);
				this.setRelease_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("IS_SYS_CHANGE");
			BEAN_VALUES.put("is_sys_change",obj);
				this.setIs_sys_change(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("APP_DEPT");
			BEAN_VALUES.put("app_dept",obj);
				this.setApp_dept(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("APP_DATE");
			BEAN_VALUES.put("app_date",obj);
				this.setApp_date(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("CHANGE_GAIN");
			BEAN_VALUES.put("change_gain",obj);
				this.setChange_gain(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("DEV_HOUR");
			BEAN_VALUES.put("dev_hour",obj);
				this.setDev_hour(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SOLVE_PROGRAM");
			BEAN_VALUES.put("solve_program",obj);
				this.setSolve_program(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SIGN_USER");
			BEAN_VALUES.put("sign_user",obj);
				this.setSign_user(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SIGN_DATE");
			BEAN_VALUES.put("sign_date",obj);
				this.setSign_date(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("FEED_USER");
			BEAN_VALUES.put("feed_user",obj);
				this.setFeed_user(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("FEED_DATE");
			BEAN_VALUES.put("feed_date",obj);
				this.setFeed_date(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("FEED_RES");
			BEAN_VALUES.put("feed_res",obj);
				this.setFeed_res(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("KEY_USER");
			BEAN_VALUES.put("key_user",obj);
				this.setKey_user(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("CONFIRM_DATE");
			BEAN_VALUES.put("confirm_date",obj);
				this.setConfirm_date(ConvertUtil.obj2Long(obj));
			obj = rs.getObject("CONFIRM_RES");
			BEAN_VALUES.put("confirm_res",obj);
				this.setConfirm_res(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("OA_ID");
			BEAN_VALUES.put("oa_id",obj);
				this.setOa_id(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 SC_WORKFLOW_CHANGE newInstance(){
			return new SC_WORKFLOW_CHANGE();
		}



















}