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 SC_WORKFLOW_RELEASE extends BaseBean{ public final static Map KEYS = new HashMap(); private Map BEAN_VALUES = null; static { KEYS.put("id", "String"); KEYS.put("order_code", "String"); KEYS.put("name", "String"); KEYS.put("customer_id", "String"); KEYS.put("customer_name", "String"); KEYS.put("create_time", "Long"); KEYS.put("flow_id", "String"); KEYS.put("partner_id", "String"); KEYS.put("plan_start_time", "Long"); KEYS.put("plan_end_time", "Long"); KEYS.put("project_id", "String"); KEYS.put("project_name", "String"); KEYS.put("sub_customer_id", "String"); KEYS.put("sub_customer_name", "String"); KEYS.put("source_id", "String"); KEYS.put("source_name", "String"); KEYS.put("second_part_name", "String"); KEYS.put("second_part_tel", "String"); KEYS.put("release_user_id", "String"); KEYS.put("release_user_name", "String"); KEYS.put("release_reason", "String"); KEYS.put("release_range", "String"); KEYS.put("workload", "String"); KEYS.put("test_step", "String"); KEYS.put("callback_step", "String"); KEYS.put("train_plan", "String"); KEYS.put("relation_depart", "String"); KEYS.put("relation_configure", "String"); KEYS.put("release_type_id", "String"); KEYS.put("release_type_name", "String"); KEYS.put("execute_id", "String"); KEYS.put("execute_name", "String"); KEYS.put("exec_step", "String"); KEYS.put("back_step", "String"); KEYS.put("sucess_flag", "Integer"); KEYS.put("source_change_id", "String"); KEYS.put("oa_id", "String"); KEYS.put("release_result", "Integer"); 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"); } 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 customer_id; private Boolean isSetted_customer_id = false; private String customer_name; private Boolean isSetted_customer_name = false; private Long create_time; private Boolean isSetted_create_time = false; private String flow_id; private Boolean isSetted_flow_id = 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 plan_end_time; private Boolean isSetted_plan_end_time = false; private String project_id; private Boolean isSetted_project_id = false; private String project_name; private Boolean isSetted_project_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 source_id; private Boolean isSetted_source_id = false; private String source_name; private Boolean isSetted_source_name = false; private String second_part_name; private Boolean isSetted_second_part_name = false; private String second_part_tel; private Boolean isSetted_second_part_tel = false; private String release_user_id; private Boolean isSetted_release_user_id = false; private String release_user_name; private Boolean isSetted_release_user_name = false; private String release_reason; private Boolean isSetted_release_reason = false; private String release_range; private Boolean isSetted_release_range = false; private String workload; private Boolean isSetted_workload = false; private String test_step; private Boolean isSetted_test_step = false; private String callback_step; private Boolean isSetted_callback_step = false; private String train_plan; private Boolean isSetted_train_plan = false; private String relation_depart; private Boolean isSetted_relation_depart = false; private String relation_configure; private Boolean isSetted_relation_configure = false; private String release_type_id; private Boolean isSetted_release_type_id = false; private String release_type_name; private Boolean isSetted_release_type_name = false; private String execute_id; private Boolean isSetted_execute_id = false; private String execute_name; private Boolean isSetted_execute_name = false; private String exec_step; private Boolean isSetted_exec_step = false; private String back_step; private Boolean isSetted_back_step = false; private Integer sucess_flag; private Boolean isSetted_sucess_flag = false; private String source_change_id; private Boolean isSetted_source_change_id = false; private String oa_id; private Boolean isSetted_oa_id = false; private Integer release_result; private Boolean isSetted_release_result = 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 void initBeanValues(){ BEAN_VALUES = new HashMap(); BEAN_VALUES.put("id",id); BEAN_VALUES.put("order_code", null); BEAN_VALUES.put("name", null); BEAN_VALUES.put("customer_id", null); BEAN_VALUES.put("customer_name", null); BEAN_VALUES.put("create_time", null); BEAN_VALUES.put("flow_id", null); BEAN_VALUES.put("partner_id", null); BEAN_VALUES.put("plan_start_time", null); BEAN_VALUES.put("plan_end_time", null); BEAN_VALUES.put("project_id", null); BEAN_VALUES.put("project_name", null); BEAN_VALUES.put("sub_customer_id", null); BEAN_VALUES.put("sub_customer_name", null); BEAN_VALUES.put("source_id", null); BEAN_VALUES.put("source_name", null); BEAN_VALUES.put("second_part_name", null); BEAN_VALUES.put("second_part_tel", null); BEAN_VALUES.put("release_user_id", null); BEAN_VALUES.put("release_user_name", null); BEAN_VALUES.put("release_reason", null); BEAN_VALUES.put("release_range", null); BEAN_VALUES.put("workload", null); BEAN_VALUES.put("test_step", null); BEAN_VALUES.put("callback_step", null); BEAN_VALUES.put("train_plan", null); BEAN_VALUES.put("relation_depart", null); BEAN_VALUES.put("relation_configure", null); BEAN_VALUES.put("release_type_id", null); BEAN_VALUES.put("release_type_name", null); BEAN_VALUES.put("execute_id", null); BEAN_VALUES.put("execute_name", null); BEAN_VALUES.put("exec_step", null); BEAN_VALUES.put("back_step", null); BEAN_VALUES.put("sucess_flag", null); BEAN_VALUES.put("source_change_id", null); BEAN_VALUES.put("oa_id", null); BEAN_VALUES.put("release_result", 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); } public SC_WORKFLOW_RELEASE() { initBeanValues(); } public SC_WORKFLOW_RELEASE(String id) { super(); this.id = id; initBeanValues(); BEAN_VALUES.put("id",id); } /** * 获取ID */ public String getId() { return this.id; } /** * 设置ID */ public SC_WORKFLOW_RELEASE 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_RELEASE set "); if (isSetted_order_code) { sBuffer.append("order_code=:order_code,"); } if (isSetted_name) { sBuffer.append("name=:name,"); } if (isSetted_customer_id) { sBuffer.append("customer_id=:customer_id,"); } if (isSetted_customer_name) { sBuffer.append("customer_name=:customer_name,"); } if (isSetted_create_time) { sBuffer.append("create_time=:create_time,"); } if (isSetted_flow_id) { sBuffer.append("flow_id=:flow_id,"); } 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_plan_end_time) { sBuffer.append("plan_end_time=:plan_end_time,"); } if (isSetted_project_id) { sBuffer.append("project_id=:project_id,"); } if (isSetted_project_name) { sBuffer.append("project_name=:project_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_source_id) { sBuffer.append("source_id=:source_id,"); } if (isSetted_source_name) { sBuffer.append("source_name=:source_name,"); } if (isSetted_second_part_name) { sBuffer.append("second_part_name=:second_part_name,"); } if (isSetted_second_part_tel) { sBuffer.append("second_part_tel=:second_part_tel,"); } if (isSetted_release_user_id) { sBuffer.append("release_user_id=:release_user_id,"); } if (isSetted_release_user_name) { sBuffer.append("release_user_name=:release_user_name,"); } if (isSetted_release_reason) { sBuffer.append("release_reason=:release_reason,"); } if (isSetted_release_range) { sBuffer.append("release_range=:release_range,"); } if (isSetted_workload) { sBuffer.append("workload=:workload,"); } if (isSetted_test_step) { sBuffer.append("test_step=:test_step,"); } if (isSetted_callback_step) { sBuffer.append("callback_step=:callback_step,"); } if (isSetted_train_plan) { sBuffer.append("train_plan=:train_plan,"); } if (isSetted_relation_depart) { sBuffer.append("relation_depart=:relation_depart,"); } if (isSetted_relation_configure) { sBuffer.append("relation_configure=:relation_configure,"); } if (isSetted_release_type_id) { sBuffer.append("release_type_id=:release_type_id,"); } if (isSetted_release_type_name) { sBuffer.append("release_type_name=:release_type_name,"); } if (isSetted_execute_id) { sBuffer.append("execute_id=:execute_id,"); } if (isSetted_execute_name) { sBuffer.append("execute_name=:execute_name,"); } if (isSetted_exec_step) { sBuffer.append("exec_step=:exec_step,"); } if (isSetted_back_step) { sBuffer.append("back_step=:back_step,"); } if (isSetted_sucess_flag) { sBuffer.append("sucess_flag=:sucess_flag,"); } if (isSetted_source_change_id) { sBuffer.append("source_change_id=:source_change_id,"); } if (isSetted_oa_id) { sBuffer.append("oa_id=:oa_id,"); } if (isSetted_release_result) { sBuffer.append("release_result=:release_result,"); } 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,"); } String sql = sBuffer.toString(); return StringUtils.removeEnd(sql, ",") + " where id=:id"; } @Override public String getInsertSql() { StringBuffer sBuffer = new StringBuffer("insert into SC_WORKFLOW_RELEASE("); 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("customer_id,"); values.append(":customer_id,"); fileds.append("customer_name,"); values.append(":customer_name,"); fileds.append("create_time,"); values.append(":create_time,"); fileds.append("flow_id,"); values.append(":flow_id,"); fileds.append("partner_id,"); values.append(":partner_id,"); fileds.append("plan_start_time,"); values.append(":plan_start_time,"); fileds.append("plan_end_time,"); values.append(":plan_end_time,"); fileds.append("project_id,"); values.append(":project_id,"); fileds.append("project_name,"); values.append(":project_name,"); fileds.append("sub_customer_id,"); values.append(":sub_customer_id,"); fileds.append("sub_customer_name,"); values.append(":sub_customer_name,"); fileds.append("source_id,"); values.append(":source_id,"); fileds.append("source_name,"); values.append(":source_name,"); fileds.append("second_part_name,"); values.append(":second_part_name,"); fileds.append("second_part_tel,"); values.append(":second_part_tel,"); fileds.append("release_user_id,"); values.append(":release_user_id,"); fileds.append("release_user_name,"); values.append(":release_user_name,"); fileds.append("release_reason,"); values.append(":release_reason,"); fileds.append("release_range,"); values.append(":release_range,"); fileds.append("workload,"); values.append(":workload,"); fileds.append("test_step,"); values.append(":test_step,"); fileds.append("callback_step,"); values.append(":callback_step,"); fileds.append("train_plan,"); values.append(":train_plan,"); fileds.append("relation_depart,"); values.append(":relation_depart,"); fileds.append("relation_configure,"); values.append(":relation_configure,"); fileds.append("release_type_id,"); values.append(":release_type_id,"); fileds.append("release_type_name,"); values.append(":release_type_name,"); fileds.append("execute_id,"); values.append(":execute_id,"); fileds.append("execute_name,"); values.append(":execute_name,"); fileds.append("exec_step,"); values.append(":exec_step,"); fileds.append("back_step,"); values.append(":back_step,"); fileds.append("sucess_flag,"); values.append(":sucess_flag,"); fileds.append("source_change_id,"); values.append(":source_change_id,"); fileds.append("oa_id,"); values.append(":oa_id,"); fileds.append("release_result,"); values.append(":release_result,"); 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,"); sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")"); return sBuffer.toString(); } /** * 获取工单编码
* 䣺2017-21-13 hh:03 */ public String getOrder_code() { return order_code; } /** * 设置工单编码
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setOrder_code(String order_code) { this.order_code = order_code; this.isSetted_order_code = true; BEAN_VALUES.put("order_code",order_code); return this; } /** * 获取发布名称
* 䣺2017-21-13 hh:03 */ public String getName() { return name; } /** * 设置发布名称
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setName(String name) { this.name = name; this.isSetted_name = true; BEAN_VALUES.put("name",name); return this; } /** * 获取客户编号
* 䣺2017-21-13 hh:03 */ public String getCustomer_id() { return customer_id; } /** * 设置客户编号
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setCustomer_id(String customer_id) { this.customer_id = customer_id; this.isSetted_customer_id = true; BEAN_VALUES.put("customer_id",customer_id); return this; } /** * 获取客户名称
* 䣺2017-21-13 hh:03 */ public String getCustomer_name() { return customer_name; } /** * 设置客户名称
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setCustomer_name(String customer_name) { this.customer_name = customer_name; this.isSetted_customer_name = true; BEAN_VALUES.put("customer_name",customer_name); return this; } /** * 获取创建时间
* 䣺2017-21-13 hh:03 */ public Long getCreate_time() { return create_time; } /** * 设置创建时间
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setCreate_time(Long create_time) { this.create_time = create_time; this.isSetted_create_time = true; BEAN_VALUES.put("create_time",create_time); return this; } /** * 获取流程编号
* 䣺2017-21-13 hh:03 */ public String getFlow_id() { return flow_id; } /** * 设置流程编号
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setFlow_id(String flow_id) { this.flow_id = flow_id; this.isSetted_flow_id = true; BEAN_VALUES.put("flow_id",flow_id); return this; } /** * 获取加盟商编号
* 䣺2017-21-13 hh:03 */ public String getPartner_id() { return partner_id; } /** * 设置加盟商编号
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setPartner_id(String partner_id) { this.partner_id = partner_id; this.isSetted_partner_id = true; BEAN_VALUES.put("partner_id",partner_id); return this; } /** * 获取计划开始时间
* 䣺2017-21-13 hh:03 */ public Long getPlan_start_time() { return plan_start_time; } /** * 设置计划开始时间
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取计划结束时间
* 䣺2017-21-13 hh:03 */ public Long getPlan_end_time() { return plan_end_time; } /** * 设置计划结束时间
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setPlan_end_time(Long plan_end_time) { this.plan_end_time = plan_end_time; this.isSetted_plan_end_time = true; BEAN_VALUES.put("plan_end_time",plan_end_time); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getProject_id() { return project_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setProject_id(String project_id) { this.project_id = project_id; this.isSetted_project_id = true; BEAN_VALUES.put("project_id",project_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getProject_name() { return project_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setProject_name(String project_name) { this.project_name = project_name; this.isSetted_project_name = true; BEAN_VALUES.put("project_name",project_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSub_customer_id() { return sub_customer_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSub_customer_name() { return sub_customer_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSource_id() { return source_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSource_id(String source_id) { this.source_id = source_id; this.isSetted_source_id = true; BEAN_VALUES.put("source_id",source_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSource_name() { return source_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSource_name(String source_name) { this.source_name = source_name; this.isSetted_source_name = true; BEAN_VALUES.put("source_name",source_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSecond_part_name() { return second_part_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSecond_part_name(String second_part_name) { this.second_part_name = second_part_name; this.isSetted_second_part_name = true; BEAN_VALUES.put("second_part_name",second_part_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSecond_part_tel() { return second_part_tel; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSecond_part_tel(String second_part_tel) { this.second_part_tel = second_part_tel; this.isSetted_second_part_tel = true; BEAN_VALUES.put("second_part_tel",second_part_tel); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_user_id() { return release_user_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_user_id(String release_user_id) { this.release_user_id = release_user_id; this.isSetted_release_user_id = true; BEAN_VALUES.put("release_user_id",release_user_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_user_name() { return release_user_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_user_name(String release_user_name) { this.release_user_name = release_user_name; this.isSetted_release_user_name = true; BEAN_VALUES.put("release_user_name",release_user_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_reason() { return release_reason; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_reason(String release_reason) { this.release_reason = release_reason; this.isSetted_release_reason = true; BEAN_VALUES.put("release_reason",release_reason); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_range() { return release_range; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_range(String release_range) { this.release_range = release_range; this.isSetted_release_range = true; BEAN_VALUES.put("release_range",release_range); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getWorkload() { return workload; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setWorkload(String workload) { this.workload = workload; this.isSetted_workload = true; BEAN_VALUES.put("workload",workload); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getTest_step() { return test_step; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setTest_step(String test_step) { this.test_step = test_step; this.isSetted_test_step = true; BEAN_VALUES.put("test_step",test_step); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getCallback_step() { return callback_step; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setCallback_step(String callback_step) { this.callback_step = callback_step; this.isSetted_callback_step = true; BEAN_VALUES.put("callback_step",callback_step); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getTrain_plan() { return train_plan; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setTrain_plan(String train_plan) { this.train_plan = train_plan; this.isSetted_train_plan = true; BEAN_VALUES.put("train_plan",train_plan); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelation_depart() { return relation_depart; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelation_depart(String relation_depart) { this.relation_depart = relation_depart; this.isSetted_relation_depart = true; BEAN_VALUES.put("relation_depart",relation_depart); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelation_configure() { return relation_configure; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelation_configure(String relation_configure) { this.relation_configure = relation_configure; this.isSetted_relation_configure = true; BEAN_VALUES.put("relation_configure",relation_configure); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_type_id() { return release_type_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_type_id(String release_type_id) { this.release_type_id = release_type_id; this.isSetted_release_type_id = true; BEAN_VALUES.put("release_type_id",release_type_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getRelease_type_name() { return release_type_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_type_name(String release_type_name) { this.release_type_name = release_type_name; this.isSetted_release_type_name = true; BEAN_VALUES.put("release_type_name",release_type_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getExecute_id() { return execute_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setExecute_id(String execute_id) { this.execute_id = execute_id; this.isSetted_execute_id = true; BEAN_VALUES.put("execute_id",execute_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getExecute_name() { return execute_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setExecute_name(String execute_name) { this.execute_name = execute_name; this.isSetted_execute_name = true; BEAN_VALUES.put("execute_name",execute_name); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getExec_step() { return exec_step; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setExec_step(String exec_step) { this.exec_step = exec_step; this.isSetted_exec_step = true; BEAN_VALUES.put("exec_step",exec_step); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getBack_step() { return back_step; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setBack_step(String back_step) { this.back_step = back_step; this.isSetted_back_step = true; BEAN_VALUES.put("back_step",back_step); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public Integer getSucess_flag() { return sucess_flag; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSucess_flag(Integer sucess_flag) { this.sucess_flag = sucess_flag; this.isSetted_sucess_flag = true; BEAN_VALUES.put("sucess_flag",sucess_flag); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSource_change_id() { return source_change_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setSource_change_id(String source_change_id) { this.source_change_id = source_change_id; this.isSetted_source_change_id = true; BEAN_VALUES.put("source_change_id",source_change_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getOa_id() { return oa_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setOa_id(String oa_id) { this.oa_id = oa_id; this.isSetted_oa_id = true; BEAN_VALUES.put("oa_id",oa_id); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public Integer getRelease_result() { return release_result; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE setRelease_result(Integer release_result) { this.release_result = release_result; this.isSetted_release_result = true; BEAN_VALUES.put("release_result",release_result); return this; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getFirst_category_id() { return first_category_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getFirst_category_name() { return first_category_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSecond_category_id() { return second_category_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getSecond_category_name() { return second_category_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getThird_category_id() { return third_category_id; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 获取
* 䣺2017-21-13 hh:03 */ public String getThird_category_name() { return third_category_name; } /** * 设置
* 2017-21-13 hh:03 */ public SC_WORKFLOW_RELEASE 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; } /** * 使用ID删除Bean
*/ 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_RELEASE 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_RELEASE queryForBean() { StringBuffer sBuffer = new StringBuffer("select * from SC_WORKFLOW_RELEASE 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_customer_id) { sBuffer.append("customer_id=:customer_id and "); } if (isSetted_customer_name) { sBuffer.append("customer_name=:customer_name and "); } if (isSetted_create_time) { sBuffer.append("create_time=:create_time and "); } if (isSetted_flow_id) { sBuffer.append("flow_id=:flow_id 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_plan_end_time) { sBuffer.append("plan_end_time=:plan_end_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_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_source_id) { sBuffer.append("source_id=:source_id and "); } if (isSetted_source_name) { sBuffer.append("source_name=:source_name and "); } if (isSetted_second_part_name) { sBuffer.append("second_part_name=:second_part_name and "); } if (isSetted_second_part_tel) { sBuffer.append("second_part_tel=:second_part_tel and "); } if (isSetted_release_user_id) { sBuffer.append("release_user_id=:release_user_id and "); } if (isSetted_release_user_name) { sBuffer.append("release_user_name=:release_user_name and "); } if (isSetted_release_reason) { sBuffer.append("release_reason=:release_reason and "); } if (isSetted_release_range) { sBuffer.append("release_range=:release_range and "); } if (isSetted_workload) { sBuffer.append("workload=:workload and "); } if (isSetted_test_step) { sBuffer.append("test_step=:test_step and "); } if (isSetted_callback_step) { sBuffer.append("callback_step=:callback_step and "); } if (isSetted_train_plan) { sBuffer.append("train_plan=:train_plan and "); } if (isSetted_relation_depart) { sBuffer.append("relation_depart=:relation_depart and "); } if (isSetted_relation_configure) { sBuffer.append("relation_configure=:relation_configure and "); } if (isSetted_release_type_id) { sBuffer.append("release_type_id=:release_type_id and "); } if (isSetted_release_type_name) { sBuffer.append("release_type_name=:release_type_name and "); } if (isSetted_execute_id) { sBuffer.append("execute_id=:execute_id and "); } if (isSetted_execute_name) { sBuffer.append("execute_name=:execute_name and "); } if (isSetted_exec_step) { sBuffer.append("exec_step=:exec_step and "); } if (isSetted_back_step) { sBuffer.append("back_step=:back_step and "); } if (isSetted_sucess_flag) { sBuffer.append("sucess_flag=:sucess_flag and "); } if (isSetted_source_change_id) { sBuffer.append("source_change_id=:source_change_id and "); } if (isSetted_oa_id) { sBuffer.append("oa_id=:oa_id and "); } if (isSetted_release_result) { sBuffer.append("release_result=:release_result 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 "); } String sql = sBuffer.toString(); sql = StringUtils.removeEnd(sql, " and "); return dao.queryForBean(sql,this); } @Override public String getTableName() { return "SC_WORKFLOW_RELEASE"; } public Map getBeanValues(){ return this.BEAN_VALUES; } @Override public SC_WORKFLOW_RELEASE insert() { if (StringUtils.isBlank(id)) { this.setId(StringUtil.getUUID()); } dao.execute(getInsertSql(),BEAN_VALUES); return this; } @Override public SC_WORKFLOW_RELEASE update() { if (StringUtils.isBlank(id)) { throw new RuntimeException("更新Bean时ID不能为空"); } dao.execute(getUpdateSql(),BEAN_VALUES); return this; } public SC_WORKFLOW_RELEASE 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_RELEASE 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("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("CREATE_TIME"); BEAN_VALUES.put("create_time",obj); this.setCreate_time(ConvertUtil.obj2Long(obj)); obj = rs.getObject("FLOW_ID"); BEAN_VALUES.put("flow_id",obj); this.setFlow_id(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("PLAN_END_TIME"); BEAN_VALUES.put("plan_end_time",obj); this.setPlan_end_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("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("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("SECOND_PART_NAME"); BEAN_VALUES.put("second_part_name",obj); this.setSecond_part_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("SECOND_PART_TEL"); BEAN_VALUES.put("second_part_tel",obj); this.setSecond_part_tel(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_USER_ID"); BEAN_VALUES.put("release_user_id",obj); this.setRelease_user_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_USER_NAME"); BEAN_VALUES.put("release_user_name",obj); this.setRelease_user_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_REASON"); BEAN_VALUES.put("release_reason",obj); this.setRelease_reason(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_RANGE"); BEAN_VALUES.put("release_range",obj); this.setRelease_range(ConvertUtil.obj2Str(obj)); obj = rs.getObject("WORKLOAD"); BEAN_VALUES.put("workload",obj); this.setWorkload(ConvertUtil.obj2Str(obj)); obj = rs.getObject("TEST_STEP"); BEAN_VALUES.put("test_step",obj); this.setTest_step(ConvertUtil.obj2Str(obj)); obj = rs.getObject("CALLBACK_STEP"); BEAN_VALUES.put("callback_step",obj); this.setCallback_step(ConvertUtil.obj2Str(obj)); obj = rs.getObject("TRAIN_PLAN"); BEAN_VALUES.put("train_plan",obj); this.setTrain_plan(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELATION_DEPART"); BEAN_VALUES.put("relation_depart",obj); this.setRelation_depart(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELATION_CONFIGURE"); BEAN_VALUES.put("relation_configure",obj); this.setRelation_configure(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_TYPE_ID"); BEAN_VALUES.put("release_type_id",obj); this.setRelease_type_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_TYPE_NAME"); BEAN_VALUES.put("release_type_name",obj); this.setRelease_type_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("EXECUTE_ID"); BEAN_VALUES.put("execute_id",obj); this.setExecute_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("EXECUTE_NAME"); BEAN_VALUES.put("execute_name",obj); this.setExecute_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("EXEC_STEP"); BEAN_VALUES.put("exec_step",obj); this.setExec_step(ConvertUtil.obj2Str(obj)); obj = rs.getObject("BACK_STEP"); BEAN_VALUES.put("back_step",obj); this.setBack_step(ConvertUtil.obj2Str(obj)); obj = rs.getObject("SUCESS_FLAG"); BEAN_VALUES.put("sucess_flag",obj); this.setSucess_flag(ConvertUtil.obj2Integer(obj)); obj = rs.getObject("SOURCE_CHANGE_ID"); BEAN_VALUES.put("source_change_id",obj); this.setSource_change_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("OA_ID"); BEAN_VALUES.put("oa_id",obj); this.setOa_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("RELEASE_RESULT"); BEAN_VALUES.put("release_result",obj); this.setRelease_result(ConvertUtil.obj2Integer(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)); 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_RELEASE newInstance(){ return new SC_WORKFLOW_RELEASE(); } }