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();
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
