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 GG_USER 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("loginname", "String");
		KEYS.put("password", "String");
		KEYS.put("zhlx", "Integer");
		KEYS.put("zsxm", "String");
		KEYS.put("age", "Integer");
		KEYS.put("xingb", "String");
		KEYS.put("beiz", "String");
		KEYS.put("bgdh", "String");
		KEYS.put("sjhm", "String");
		KEYS.put("zt", "Integer");
		KEYS.put("zhaop", "String");
		KEYS.put("ssbmbh", "String");
		KEYS.put("yjbmbh", "String");
		KEYS.put("ejbmbh", "String");
		KEYS.put("sjbmbh", "String");
		KEYS.put("sijbmbh", "String");
		KEYS.put("sscj", "Integer");
		KEYS.put("bmpx", "Integer");
		KEYS.put("qq", "String");
		KEYS.put("email", "String");
		KEYS.put("gwmc", "String");
		KEYS.put("logintype", "Integer");
		KEYS.put("accounttype", "Integer");
		KEYS.put("deskid", "String");
		KEYS.put("is_init", "Integer");
		KEYS.put("iswechat", "Integer");
		KEYS.put("open_id", "String");
		KEYS.put("qq_open_id", "String");
		KEYS.put("isemail", "Integer");
		KEYS.put("isphone", "Integer");
		KEYS.put("photopath", "String");
		KEYS.put("note", "String");
		KEYS.put("remind_type", "String");
		KEYS.put("ime", "String");
		KEYS.put("km_score", "Integer");
		KEYS.put("wechat_nickname", "String");
		KEYS.put("wechat_login_open_id", "String");
		KEYS.put("gh", "String");
		KEYS.put("is_tp", "Integer");
	}
	public Map getColumnMap(){
		return KEYS;
	}

	private String id;
	private Boolean isSetted_id = false;;
	
	private String loginname;
	private Boolean isSetted_loginname = false;
	private String password;
	private Boolean isSetted_password = false;
	private Integer zhlx;
	private Boolean isSetted_zhlx = false;
	private String zsxm;
	private Boolean isSetted_zsxm = false;
	private Integer age;
	private Boolean isSetted_age = false;
	private String xingb;
	private Boolean isSetted_xingb = false;
	private String beiz;
	private Boolean isSetted_beiz = false;
	private String bgdh;
	private Boolean isSetted_bgdh = false;
	private String sjhm;
	private Boolean isSetted_sjhm = false;
	private Integer zt;
	private Boolean isSetted_zt = false;
	private String zhaop;
	private Boolean isSetted_zhaop = false;
	private String ssbmbh;
	private Boolean isSetted_ssbmbh = false;
	private String yjbmbh;
	private Boolean isSetted_yjbmbh = false;
	private String ejbmbh;
	private Boolean isSetted_ejbmbh = false;
	private String sjbmbh;
	private Boolean isSetted_sjbmbh = false;
	private String sijbmbh;
	private Boolean isSetted_sijbmbh = false;
	private Integer sscj;
	private Boolean isSetted_sscj = false;
	private Integer bmpx;
	private Boolean isSetted_bmpx = false;
	private String qq;
	private Boolean isSetted_qq = false;
	private String email;
	private Boolean isSetted_email = false;
	private String gwmc;
	private Boolean isSetted_gwmc = false;
	private Integer logintype;
	private Boolean isSetted_logintype = false;
	private Integer accounttype;
	private Boolean isSetted_accounttype = false;
	private String deskid;
	private Boolean isSetted_deskid = false;
	private Integer is_init;
	private Boolean isSetted_is_init = false;
	private Integer iswechat;
	private Boolean isSetted_iswechat = false;
	private String open_id;
	private Boolean isSetted_open_id = false;
	private String qq_open_id;
	private Boolean isSetted_qq_open_id = false;
	private Integer isemail;
	private Boolean isSetted_isemail = false;
	private Integer isphone;
	private Boolean isSetted_isphone = false;
	private String photopath;
	private Boolean isSetted_photopath = false;
	private String note;
	private Boolean isSetted_note = false;
	private String remind_type;
	private Boolean isSetted_remind_type = false;
	private String ime;
	private Boolean isSetted_ime = false;
	private Integer km_score;
	private Boolean isSetted_km_score = false;
	private String wechat_nickname;
	private Boolean isSetted_wechat_nickname = false;
	private String wechat_login_open_id;
	private Boolean isSetted_wechat_login_open_id = false;
	private String gh;
	private Boolean isSetted_gh = false;
	private Integer is_tp;
	private Boolean isSetted_is_tp = false;

	private void initBeanValues(){
		BEAN_VALUES = new HashMap<String, Object>();
		BEAN_VALUES.put("id",id);
			BEAN_VALUES.put("loginname", null);
			BEAN_VALUES.put("password", null);
			BEAN_VALUES.put("zhlx", null);
			BEAN_VALUES.put("zsxm", null);
			BEAN_VALUES.put("age", null);
			BEAN_VALUES.put("xingb", null);
			BEAN_VALUES.put("beiz", null);
			BEAN_VALUES.put("bgdh", null);
			BEAN_VALUES.put("sjhm", null);
			BEAN_VALUES.put("zt", null);
			BEAN_VALUES.put("zhaop", null);
			BEAN_VALUES.put("ssbmbh", null);
			BEAN_VALUES.put("yjbmbh", null);
			BEAN_VALUES.put("ejbmbh", null);
			BEAN_VALUES.put("sjbmbh", null);
			BEAN_VALUES.put("sijbmbh", null);
			BEAN_VALUES.put("sscj", null);
			BEAN_VALUES.put("bmpx", null);
			BEAN_VALUES.put("qq", null);
			BEAN_VALUES.put("email", null);
			BEAN_VALUES.put("gwmc", null);
			BEAN_VALUES.put("logintype", null);
			BEAN_VALUES.put("accounttype", null);
			BEAN_VALUES.put("deskid", null);
			BEAN_VALUES.put("is_init", null);
			BEAN_VALUES.put("iswechat", null);
			BEAN_VALUES.put("open_id", null);
			BEAN_VALUES.put("qq_open_id", null);
			BEAN_VALUES.put("isemail", null);
			BEAN_VALUES.put("isphone", null);
			BEAN_VALUES.put("photopath", null);
			BEAN_VALUES.put("note", null);
			BEAN_VALUES.put("remind_type", null);
			BEAN_VALUES.put("ime", null);
			BEAN_VALUES.put("km_score", null);
			BEAN_VALUES.put("wechat_nickname", null);
			BEAN_VALUES.put("wechat_login_open_id", null);
			BEAN_VALUES.put("gh", null);
			BEAN_VALUES.put("is_tp", null);
	}
	
	public GG_USER() {
		initBeanValues();
	}
	
	public GG_USER(String id) {
		super();
		this.id = id;
		initBeanValues();
		BEAN_VALUES.put("id",id);
	}

    /**
     * 获取ID
     */
	public String getId() {
		return this.id;
	}
	/**
     * 设置ID
     */
	public GG_USER 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 GG_USER set ");
			if (isSetted_loginname) {
				sBuffer.append("loginname=:loginname,");
			}
			if (isSetted_password) {
				sBuffer.append("password=:password,");
			}
			if (isSetted_zhlx) {
				sBuffer.append("zhlx=:zhlx,");
			}
			if (isSetted_zsxm) {
				sBuffer.append("zsxm=:zsxm,");
			}
			if (isSetted_age) {
				sBuffer.append("age=:age,");
			}
			if (isSetted_xingb) {
				sBuffer.append("xingb=:xingb,");
			}
			if (isSetted_beiz) {
				sBuffer.append("beiz=:beiz,");
			}
			if (isSetted_bgdh) {
				sBuffer.append("bgdh=:bgdh,");
			}
			if (isSetted_sjhm) {
				sBuffer.append("sjhm=:sjhm,");
			}
			if (isSetted_zt) {
				sBuffer.append("zt=:zt,");
			}
			if (isSetted_zhaop) {
				sBuffer.append("zhaop=:zhaop,");
			}
			if (isSetted_ssbmbh) {
				sBuffer.append("ssbmbh=:ssbmbh,");
			}
			if (isSetted_yjbmbh) {
				sBuffer.append("yjbmbh=:yjbmbh,");
			}
			if (isSetted_ejbmbh) {
				sBuffer.append("ejbmbh=:ejbmbh,");
			}
			if (isSetted_sjbmbh) {
				sBuffer.append("sjbmbh=:sjbmbh,");
			}
			if (isSetted_sijbmbh) {
				sBuffer.append("sijbmbh=:sijbmbh,");
			}
			if (isSetted_sscj) {
				sBuffer.append("sscj=:sscj,");
			}
			if (isSetted_bmpx) {
				sBuffer.append("bmpx=:bmpx,");
			}
			if (isSetted_qq) {
				sBuffer.append("qq=:qq,");
			}
			if (isSetted_email) {
				sBuffer.append("email=:email,");
			}
			if (isSetted_gwmc) {
				sBuffer.append("gwmc=:gwmc,");
			}
			if (isSetted_logintype) {
				sBuffer.append("logintype=:logintype,");
			}
			if (isSetted_accounttype) {
				sBuffer.append("accounttype=:accounttype,");
			}
			if (isSetted_deskid) {
				sBuffer.append("deskid=:deskid,");
			}
			if (isSetted_is_init) {
				sBuffer.append("is_init=:is_init,");
			}
			if (isSetted_iswechat) {
				sBuffer.append("iswechat=:iswechat,");
			}
			if (isSetted_open_id) {
				sBuffer.append("open_id=:open_id,");
			}
			if (isSetted_qq_open_id) {
				sBuffer.append("qq_open_id=:qq_open_id,");
			}
			if (isSetted_isemail) {
				sBuffer.append("isemail=:isemail,");
			}
			if (isSetted_isphone) {
				sBuffer.append("isphone=:isphone,");
			}
			if (isSetted_photopath) {
				sBuffer.append("photopath=:photopath,");
			}
			if (isSetted_note) {
				sBuffer.append("note=:note,");
			}
			if (isSetted_remind_type) {
				sBuffer.append("remind_type=:remind_type,");
			}
			if (isSetted_ime) {
				sBuffer.append("ime=:ime,");
			}
			if (isSetted_km_score) {
				sBuffer.append("km_score=:km_score,");
			}
			if (isSetted_wechat_nickname) {
				sBuffer.append("wechat_nickname=:wechat_nickname,");
			}
			if (isSetted_wechat_login_open_id) {
				sBuffer.append("wechat_login_open_id=:wechat_login_open_id,");
			}
			if (isSetted_gh) {
				sBuffer.append("gh=:gh,");
			}
			if (isSetted_is_tp) {
				sBuffer.append("is_tp=:is_tp,");
			}
		String sql = sBuffer.toString();
		return StringUtils.removeEnd(sql, ",") + " where id=:id";
	}
	
	
	@Override
	public String getInsertSql() {
		StringBuffer sBuffer = new StringBuffer("insert into GG_USER(");
		StringBuffer fileds = new StringBuffer("id,");
		StringBuffer values = new StringBuffer(":id,");		
			fileds.append("loginname,");
			values.append(":loginname,");
			fileds.append("password,");
			values.append(":password,");
			fileds.append("zhlx,");
			values.append(":zhlx,");
			fileds.append("zsxm,");
			values.append(":zsxm,");
			fileds.append("age,");
			values.append(":age,");
			fileds.append("xingb,");
			values.append(":xingb,");
			fileds.append("beiz,");
			values.append(":beiz,");
			fileds.append("bgdh,");
			values.append(":bgdh,");
			fileds.append("sjhm,");
			values.append(":sjhm,");
			fileds.append("zt,");
			values.append(":zt,");
			fileds.append("zhaop,");
			values.append(":zhaop,");
			fileds.append("ssbmbh,");
			values.append(":ssbmbh,");
			fileds.append("yjbmbh,");
			values.append(":yjbmbh,");
			fileds.append("ejbmbh,");
			values.append(":ejbmbh,");
			fileds.append("sjbmbh,");
			values.append(":sjbmbh,");
			fileds.append("sijbmbh,");
			values.append(":sijbmbh,");
			fileds.append("sscj,");
			values.append(":sscj,");
			fileds.append("bmpx,");
			values.append(":bmpx,");
			fileds.append("qq,");
			values.append(":qq,");
			fileds.append("email,");
			values.append(":email,");
			fileds.append("gwmc,");
			values.append(":gwmc,");
			fileds.append("logintype,");
			values.append(":logintype,");
			fileds.append("accounttype,");
			values.append(":accounttype,");
			fileds.append("deskid,");
			values.append(":deskid,");
			fileds.append("is_init,");
			values.append(":is_init,");
			fileds.append("iswechat,");
			values.append(":iswechat,");
			fileds.append("open_id,");
			values.append(":open_id,");
			fileds.append("qq_open_id,");
			values.append(":qq_open_id,");
			fileds.append("isemail,");
			values.append(":isemail,");
			fileds.append("isphone,");
			values.append(":isphone,");
			fileds.append("photopath,");
			values.append(":photopath,");
			fileds.append("note,");
			values.append(":note,");
			fileds.append("remind_type,");
			values.append(":remind_type,");
			fileds.append("ime,");
			values.append(":ime,");
			fileds.append("km_score,");
			values.append(":km_score,");
			fileds.append("wechat_nickname,");
			values.append(":wechat_nickname,");
			fileds.append("wechat_login_open_id,");
			values.append(":wechat_login_open_id,");
			fileds.append("gh,");
			values.append(":gh,");
			fileds.append("is_tp,");
			values.append(":is_tp,");
		sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")");
		return sBuffer.toString();
	}
	

		/**
		 * 获取登录名<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getLoginname() {
			return loginname;
		}
		/**
		 * 设置登录名<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setLoginname(String loginname) {
			this.loginname = loginname;
			this.isSetted_loginname = true;
			BEAN_VALUES.put("loginname",loginname);
			return this;
		}
		/**
		 * 获取密码<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getPassword() {
			return password;
		}
		/**
		 * 设置密码<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setPassword(String password) {
			this.password = password;
			this.isSetted_password = true;
			BEAN_VALUES.put("password",password);
			return this;
		}
		/**
		 * 获取帐号类型（1=系统维护；2=系统运营）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getZhlx() {
			return zhlx;
		}
		/**
		 * 设置帐号类型（1=系统维护；2=系统运营）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setZhlx(Integer zhlx) {
			this.zhlx = zhlx;
			this.isSetted_zhlx = true;
			BEAN_VALUES.put("zhlx",zhlx);
			return this;
		}
		/**
		 * 获取真实姓名<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getZsxm() {
			return zsxm;
		}
		/**
		 * 设置真实姓名<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setZsxm(String zsxm) {
			this.zsxm = zsxm;
			this.isSetted_zsxm = true;
			BEAN_VALUES.put("zsxm",zsxm);
			return this;
		}
		/**
		 * 获取年龄<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getAge() {
			return age;
		}
		/**
		 * 设置年龄<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setAge(Integer age) {
			this.age = age;
			this.isSetted_age = true;
			BEAN_VALUES.put("age",age);
			return this;
		}
		/**
		 * 获取性别<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getXingb() {
			return xingb;
		}
		/**
		 * 设置性别<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setXingb(String xingb) {
			this.xingb = xingb;
			this.isSetted_xingb = true;
			BEAN_VALUES.put("xingb",xingb);
			return this;
		}
		/**
		 * 获取备注<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getBeiz() {
			return beiz;
		}
		/**
		 * 设置备注<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setBeiz(String beiz) {
			this.beiz = beiz;
			this.isSetted_beiz = true;
			BEAN_VALUES.put("beiz",beiz);
			return this;
		}
		/**
		 * 获取办公电话<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getBgdh() {
			return bgdh;
		}
		/**
		 * 设置办公电话<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setBgdh(String bgdh) {
			this.bgdh = bgdh;
			this.isSetted_bgdh = true;
			BEAN_VALUES.put("bgdh",bgdh);
			return this;
		}
		/**
		 * 获取手机号码<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getSjhm() {
			return sjhm;
		}
		/**
		 * 设置手机号码<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setSjhm(String sjhm) {
			this.sjhm = sjhm;
			this.isSetted_sjhm = true;
			BEAN_VALUES.put("sjhm",sjhm);
			return this;
		}
		/**
		 * 获取状态（1=正常；2=禁用）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getZt() {
			return zt;
		}
		/**
		 * 设置状态（1=正常；2=禁用）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setZt(Integer zt) {
			this.zt = zt;
			this.isSetted_zt = true;
			BEAN_VALUES.put("zt",zt);
			return this;
		}
		/**
		 * 获取照片路径<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getZhaop() {
			return zhaop;
		}
		/**
		 * 设置照片路径<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setZhaop(String zhaop) {
			this.zhaop = zhaop;
			this.isSetted_zhaop = true;
			BEAN_VALUES.put("zhaop",zhaop);
			return this;
		}
		/**
		 * 获取主职所属部门编号<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getSsbmbh() {
			return ssbmbh;
		}
		/**
		 * 设置主职所属部门编号<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setSsbmbh(String ssbmbh) {
			this.ssbmbh = ssbmbh;
			this.isSetted_ssbmbh = true;
			BEAN_VALUES.put("ssbmbh",ssbmbh);
			return this;
		}
		/**
		 * 获取主职一级部门编号（上级部门编号）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getYjbmbh() {
			return yjbmbh;
		}
		/**
		 * 设置主职一级部门编号（上级部门编号）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setYjbmbh(String yjbmbh) {
			this.yjbmbh = yjbmbh;
			this.isSetted_yjbmbh = true;
			BEAN_VALUES.put("yjbmbh",yjbmbh);
			return this;
		}
		/**
		 * 获取二级部门编号<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getEjbmbh() {
			return ejbmbh;
		}
		/**
		 * 设置二级部门编号<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setEjbmbh(String ejbmbh) {
			this.ejbmbh = ejbmbh;
			this.isSetted_ejbmbh = true;
			BEAN_VALUES.put("ejbmbh",ejbmbh);
			return this;
		}
		/**
		 * 获取三级部门编号<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getSjbmbh() {
			return sjbmbh;
		}
		/**
		 * 设置三级部门编号<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setSjbmbh(String sjbmbh) {
			this.sjbmbh = sjbmbh;
			this.isSetted_sjbmbh = true;
			BEAN_VALUES.put("sjbmbh",sjbmbh);
			return this;
		}
		/**
		 * 获取四级部门编号<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getSijbmbh() {
			return sijbmbh;
		}
		/**
		 * 设置四级部门编号<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setSijbmbh(String sijbmbh) {
			this.sijbmbh = sijbmbh;
			this.isSetted_sijbmbh = true;
			BEAN_VALUES.put("sijbmbh",sijbmbh);
			return this;
		}
		/**
		 * 获取所属层级<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getSscj() {
			return sscj;
		}
		/**
		 * 设置所属层级<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setSscj(Integer sscj) {
			this.sscj = sscj;
			this.isSetted_sscj = true;
			BEAN_VALUES.put("sscj",sscj);
			return this;
		}
		/**
		 * 获取部门排序<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getBmpx() {
			return bmpx;
		}
		/**
		 * 设置部门排序<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setBmpx(Integer bmpx) {
			this.bmpx = bmpx;
			this.isSetted_bmpx = true;
			BEAN_VALUES.put("bmpx",bmpx);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getQq() {
			return qq;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setQq(String qq) {
			this.qq = qq;
			this.isSetted_qq = true;
			BEAN_VALUES.put("qq",qq);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getEmail() {
			return email;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setEmail(String email) {
			this.email = email;
			this.isSetted_email = true;
			BEAN_VALUES.put("email",email);
			return this;
		}
		/**
		 * 获取岗位名称<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getGwmc() {
			return gwmc;
		}
		/**
		 * 设置岗位名称<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setGwmc(String gwmc) {
			this.gwmc = gwmc;
			this.isSetted_gwmc = true;
			BEAN_VALUES.put("gwmc",gwmc);
			return this;
		}
		/**
		 * 获取登录策略（1=密码登录；2=USBKey登录）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getLogintype() {
			return logintype;
		}
		/**
		 * 设置登录策略（1=密码登录；2=USBKey登录）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setLogintype(Integer logintype) {
			this.logintype = logintype;
			this.isSetted_logintype = true;
			BEAN_VALUES.put("logintype",logintype);
			return this;
		}
		/**
		 * 获取账户类型（1=系统管理员；2：警务人员 3：文职）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getAccounttype() {
			return accounttype;
		}
		/**
		 * 设置账户类型（1=系统管理员；2：警务人员 3：文职）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setAccounttype(Integer accounttype) {
			this.accounttype = accounttype;
			this.isSetted_accounttype = true;
			BEAN_VALUES.put("accounttype",accounttype);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getDeskid() {
			return deskid;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setDeskid(String deskid) {
			this.deskid = deskid;
			this.isSetted_deskid = true;
			BEAN_VALUES.put("deskid",deskid);
			return this;
		}
		/**
		 * 获取是否已初始化数据（1=是；2=否）<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getIs_init() {
			return is_init;
		}
		/**
		 * 设置是否已初始化数据（1=是；2=否）<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIs_init(Integer is_init) {
			this.is_init = is_init;
			this.isSetted_is_init = true;
			BEAN_VALUES.put("is_init",is_init);
			return this;
		}
		/**
		 * 获取是否绑定微信账号 1：未绑定 2：已绑定<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getIswechat() {
			return iswechat;
		}
		/**
		 * 设置是否绑定微信账号 1：未绑定 2：已绑定<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIswechat(Integer iswechat) {
			this.iswechat = iswechat;
			this.isSetted_iswechat = true;
			BEAN_VALUES.put("iswechat",iswechat);
			return this;
		}
		/**
		 * 获取微信用户对应该公众号的唯一id<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getOpen_id() {
			return open_id;
		}
		/**
		 * 设置微信用户对应该公众号的唯一id<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setOpen_id(String open_id) {
			this.open_id = open_id;
			this.isSetted_open_id = true;
			BEAN_VALUES.put("open_id",open_id);
			return this;
		}
		/**
		 * 获取qq账号绑定ID<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getQq_open_id() {
			return qq_open_id;
		}
		/**
		 * 设置qq账号绑定ID<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setQq_open_id(String qq_open_id) {
			this.qq_open_id = qq_open_id;
			this.isSetted_qq_open_id = true;
			BEAN_VALUES.put("qq_open_id",qq_open_id);
			return this;
		}
		/**
		 * 获取邮箱绑定：1：未绑定；2：已绑定<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getIsemail() {
			return isemail;
		}
		/**
		 * 设置邮箱绑定：1：未绑定；2：已绑定<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIsemail(Integer isemail) {
			this.isemail = isemail;
			this.isSetted_isemail = true;
			BEAN_VALUES.put("isemail",isemail);
			return this;
		}
		/**
		 * 获取电话号码绑定：1：未绑定；2：已绑定<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getIsphone() {
			return isphone;
		}
		/**
		 * 设置电话号码绑定：1：未绑定；2：已绑定<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIsphone(Integer isphone) {
			this.isphone = isphone;
			this.isSetted_isphone = true;
			BEAN_VALUES.put("isphone",isphone);
			return this;
		}
		/**
		 * 获取头像路径<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getPhotopath() {
			return photopath;
		}
		/**
		 * 设置头像路径<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setPhotopath(String photopath) {
			this.photopath = photopath;
			this.isSetted_photopath = true;
			BEAN_VALUES.put("photopath",photopath);
			return this;
		}
		/**
		 * 获取备注1<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getNote() {
			return note;
		}
		/**
		 * 设置备注1<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setNote(String note) {
			this.note = note;
			this.isSetted_note = true;
			BEAN_VALUES.put("note",note);
			return this;
		}
		/**
		 * 获取提醒方式（没有提醒=null；有提醒共保存三位数字，第一位表示短信（1=提醒；0=不提醒），第二位表示邮箱（1=提醒；0=不提醒）,第三位表示微信（1=提醒；0=不提醒））<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getRemind_type() {
			return remind_type;
		}
		/**
		 * 设置提醒方式（没有提醒=null；有提醒共保存三位数字，第一位表示短信（1=提醒；0=不提醒），第二位表示邮箱（1=提醒；0=不提醒）,第三位表示微信（1=提醒；0=不提醒））<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setRemind_type(String remind_type) {
			this.remind_type = remind_type;
			this.isSetted_remind_type = true;
			BEAN_VALUES.put("remind_type",remind_type);
			return this;
		}
		/**
		 * 获取手机IME码<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getIme() {
			return ime;
		}
		/**
		 * 设置手机IME码<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIme(String ime) {
			this.ime = ime;
			this.isSetted_ime = true;
			BEAN_VALUES.put("ime",ime);
			return this;
		}
		/**
		 * 获取知识库积分数量<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getKm_score() {
			return km_score;
		}
		/**
		 * 设置知识库积分数量<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setKm_score(Integer km_score) {
			this.km_score = km_score;
			this.isSetted_km_score = true;
			BEAN_VALUES.put("km_score",km_score);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getWechat_nickname() {
			return wechat_nickname;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setWechat_nickname(String wechat_nickname) {
			this.wechat_nickname = wechat_nickname;
			this.isSetted_wechat_nickname = true;
			BEAN_VALUES.put("wechat_nickname",wechat_nickname);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getWechat_login_open_id() {
			return wechat_login_open_id;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setWechat_login_open_id(String wechat_login_open_id) {
			this.wechat_login_open_id = wechat_login_open_id;
			this.isSetted_wechat_login_open_id = true;
			BEAN_VALUES.put("wechat_login_open_id",wechat_login_open_id);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public String getGh() {
			return gh;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setGh(String gh) {
			this.gh = gh;
			this.isSetted_gh = true;
			BEAN_VALUES.put("gh",gh);
			return this;
		}
		/**
		 * 获取<BR/>
		 * 䣺2018-22-18 hh:04
		 */
		public Integer getIs_tp() {
			return is_tp;
		}
		/**
		 * 设置<BR/>
		 * 2018-22-18 hh:04
		 */
		public GG_USER setIs_tp(Integer is_tp) {
			this.is_tp = is_tp;
			this.isSetted_is_tp = true;
			BEAN_VALUES.put("is_tp",is_tp);
			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 GG_USER getInstanceById() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("获取Bean时ID不能为空");
			}
			return dao.queryForBean("select * from " + getTableName() + " where id=:id", BEAN_VALUES, this);
		}
	
		
		
		@Override
		public GG_USER queryForBean() {
			StringBuffer sBuffer = new StringBuffer("select * from GG_USER where ");
			if(isSetted_id){
				sBuffer.append("id=:id and ");
			}
				if (isSetted_loginname) {
					sBuffer.append("loginname=:loginname and ");
				}
				if (isSetted_password) {
					sBuffer.append("password=:password and ");
				}
				if (isSetted_zhlx) {
					sBuffer.append("zhlx=:zhlx and ");
				}
				if (isSetted_zsxm) {
					sBuffer.append("zsxm=:zsxm and ");
				}
				if (isSetted_age) {
					sBuffer.append("age=:age and ");
				}
				if (isSetted_xingb) {
					sBuffer.append("xingb=:xingb and ");
				}
				if (isSetted_beiz) {
					sBuffer.append("beiz=:beiz and ");
				}
				if (isSetted_bgdh) {
					sBuffer.append("bgdh=:bgdh and ");
				}
				if (isSetted_sjhm) {
					sBuffer.append("sjhm=:sjhm and ");
				}
				if (isSetted_zt) {
					sBuffer.append("zt=:zt and ");
				}
				if (isSetted_zhaop) {
					sBuffer.append("zhaop=:zhaop and ");
				}
				if (isSetted_ssbmbh) {
					sBuffer.append("ssbmbh=:ssbmbh and ");
				}
				if (isSetted_yjbmbh) {
					sBuffer.append("yjbmbh=:yjbmbh and ");
				}
				if (isSetted_ejbmbh) {
					sBuffer.append("ejbmbh=:ejbmbh and ");
				}
				if (isSetted_sjbmbh) {
					sBuffer.append("sjbmbh=:sjbmbh and ");
				}
				if (isSetted_sijbmbh) {
					sBuffer.append("sijbmbh=:sijbmbh and ");
				}
				if (isSetted_sscj) {
					sBuffer.append("sscj=:sscj and ");
				}
				if (isSetted_bmpx) {
					sBuffer.append("bmpx=:bmpx and ");
				}
				if (isSetted_qq) {
					sBuffer.append("qq=:qq and ");
				}
				if (isSetted_email) {
					sBuffer.append("email=:email and ");
				}
				if (isSetted_gwmc) {
					sBuffer.append("gwmc=:gwmc and ");
				}
				if (isSetted_logintype) {
					sBuffer.append("logintype=:logintype and ");
				}
				if (isSetted_accounttype) {
					sBuffer.append("accounttype=:accounttype and ");
				}
				if (isSetted_deskid) {
					sBuffer.append("deskid=:deskid and ");
				}
				if (isSetted_is_init) {
					sBuffer.append("is_init=:is_init and ");
				}
				if (isSetted_iswechat) {
					sBuffer.append("iswechat=:iswechat and ");
				}
				if (isSetted_open_id) {
					sBuffer.append("open_id=:open_id and ");
				}
				if (isSetted_qq_open_id) {
					sBuffer.append("qq_open_id=:qq_open_id and ");
				}
				if (isSetted_isemail) {
					sBuffer.append("isemail=:isemail and ");
				}
				if (isSetted_isphone) {
					sBuffer.append("isphone=:isphone and ");
				}
				if (isSetted_photopath) {
					sBuffer.append("photopath=:photopath and ");
				}
				if (isSetted_note) {
					sBuffer.append("note=:note and ");
				}
				if (isSetted_remind_type) {
					sBuffer.append("remind_type=:remind_type and ");
				}
				if (isSetted_ime) {
					sBuffer.append("ime=:ime and ");
				}
				if (isSetted_km_score) {
					sBuffer.append("km_score=:km_score and ");
				}
				if (isSetted_wechat_nickname) {
					sBuffer.append("wechat_nickname=:wechat_nickname and ");
				}
				if (isSetted_wechat_login_open_id) {
					sBuffer.append("wechat_login_open_id=:wechat_login_open_id and ");
				}
				if (isSetted_gh) {
					sBuffer.append("gh=:gh and ");
				}
				if (isSetted_is_tp) {
					sBuffer.append("is_tp=:is_tp and ");
				}
			String sql = sBuffer.toString();
			sql = StringUtils.removeEnd(sql, " and ");
			return dao.queryForBean(sql,this);
		}
	
		@Override
		public String getTableName() {
			return "GG_USER";
		}
		
		
		public Map getBeanValues(){
			return this.BEAN_VALUES;
		}
	
		@Override
		public GG_USER insert() {
			if (StringUtils.isBlank(id)) {
				this.setId(StringUtil.getUUID());
			}
			dao.execute(getInsertSql(),BEAN_VALUES);
			return this;
		}
	
		@Override
		public GG_USER update() {
			if (StringUtils.isBlank(id)) {
				throw new RuntimeException("更新Bean时ID不能为空");
			}
			dao.execute(getUpdateSql(),BEAN_VALUES);
			return this;
		}  
		
		public GG_USER 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 GG_USER 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("LOGINNAME");
			BEAN_VALUES.put("loginname",obj);
				this.setLoginname(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("PASSWORD");
			BEAN_VALUES.put("password",obj);
				this.setPassword(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("ZHLX");
			BEAN_VALUES.put("zhlx",obj);
				this.setZhlx(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("ZSXM");
			BEAN_VALUES.put("zsxm",obj);
				this.setZsxm(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("AGE");
			BEAN_VALUES.put("age",obj);
				this.setAge(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("XINGB");
			BEAN_VALUES.put("xingb",obj);
				this.setXingb(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BEIZ");
			BEAN_VALUES.put("beiz",obj);
				this.setBeiz(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("BGDH");
			BEAN_VALUES.put("bgdh",obj);
				this.setBgdh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SJHM");
			BEAN_VALUES.put("sjhm",obj);
				this.setSjhm(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("ZT");
			BEAN_VALUES.put("zt",obj);
				this.setZt(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("ZHAOP");
			BEAN_VALUES.put("zhaop",obj);
				this.setZhaop(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SSBMBH");
			BEAN_VALUES.put("ssbmbh",obj);
				this.setSsbmbh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("YJBMBH");
			BEAN_VALUES.put("yjbmbh",obj);
				this.setYjbmbh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("EJBMBH");
			BEAN_VALUES.put("ejbmbh",obj);
				this.setEjbmbh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SJBMBH");
			BEAN_VALUES.put("sjbmbh",obj);
				this.setSjbmbh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SIJBMBH");
			BEAN_VALUES.put("sijbmbh",obj);
				this.setSijbmbh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("SSCJ");
			BEAN_VALUES.put("sscj",obj);
				this.setSscj(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("BMPX");
			BEAN_VALUES.put("bmpx",obj);
				this.setBmpx(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("QQ");
			BEAN_VALUES.put("qq",obj);
				this.setQq(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("EMAIL");
			BEAN_VALUES.put("email",obj);
				this.setEmail(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("GWMC");
			BEAN_VALUES.put("gwmc",obj);
				this.setGwmc(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("LOGINTYPE");
			BEAN_VALUES.put("logintype",obj);
				this.setLogintype(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("ACCOUNTTYPE");
			BEAN_VALUES.put("accounttype",obj);
				this.setAccounttype(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("DESKID");
			BEAN_VALUES.put("deskid",obj);
				this.setDeskid(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("IS_INIT");
			BEAN_VALUES.put("is_init",obj);
				this.setIs_init(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("ISWECHAT");
			BEAN_VALUES.put("iswechat",obj);
				this.setIswechat(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("OPEN_ID");
			BEAN_VALUES.put("open_id",obj);
				this.setOpen_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("QQ_OPEN_ID");
			BEAN_VALUES.put("qq_open_id",obj);
				this.setQq_open_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("ISEMAIL");
			BEAN_VALUES.put("isemail",obj);
				this.setIsemail(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("ISPHONE");
			BEAN_VALUES.put("isphone",obj);
				this.setIsphone(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("PHOTOPATH");
			BEAN_VALUES.put("photopath",obj);
				this.setPhotopath(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("NOTE");
			BEAN_VALUES.put("note",obj);
				this.setNote(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("REMIND_TYPE");
			BEAN_VALUES.put("remind_type",obj);
				this.setRemind_type(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("IME");
			BEAN_VALUES.put("ime",obj);
				this.setIme(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("KM_SCORE");
			BEAN_VALUES.put("km_score",obj);
				this.setKm_score(ConvertUtil.obj2Integer(obj));
			obj = rs.getObject("WECHAT_NICKNAME");
			BEAN_VALUES.put("wechat_nickname",obj);
				this.setWechat_nickname(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("WECHAT_LOGIN_OPEN_ID");
			BEAN_VALUES.put("wechat_login_open_id",obj);
				this.setWechat_login_open_id(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("GH");
			BEAN_VALUES.put("gh",obj);
				this.setGh(ConvertUtil.obj2Str(obj));
			obj = rs.getObject("IS_TP");
			BEAN_VALUES.put("is_tp",obj);
				this.setIs_tp(ConvertUtil.obj2Integer(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 GG_USER newInstance(){
			return new GG_USER();
		}



















}