 insert into obpm2.tenant_users (id,authenticated_status,checked_status,created_time,head_photo,im_identity,name,sex,stature,telephone,user_type,selected_credential_id,household_type,one_inch_color_white_photo,two_inch_color_blue_photo,
			education,marital_status,military_status,nation,native_place,politics_status,cid,last_updated_time,background_screening_status,last_background_screening_time,
						   third_party_login_no) values('#{id}','#{authenticated_status}','#{checked_status}','#{created_time}','#{head_photo}','#{im_identity}','#{name}','#{sex}','#{stature}','#{telephone}','#{user_type}','#{selected_credential_id}','#{household_type}','#{one_inch_color_white_photo}','#{two_inch_color_blue_photo}',
			'#{education}','#{marital_status}','#{military_status}','#{nation}','#{native_place}','#{politics_status}','#{cid}','#{LASTMODIFIED}','#{background_screening_status}','#{last_background_screening_time}','#{third_party_login_no}') ON DUPLICATE KEY UPDATE last_updated_time='#{LASTMODIFIED}';
			
 insert into obpm2.tenant_employees (id,created_time,job_number,last_updated_time,leave_note,leave_operator_created_time,leave_operator_id,leave_operator_name,leave_time,master_slave_type,occupation_type,position,salary,salary_bank_number,status,work_place,organization_id,tenant_user_id,unique_offset,department_id,insure,is_domain_admin) values('#{employee_id}','#{employee_created_time}','#{employee_job_number}','#{employee_last_updated_time}','#{employee_leave_note}','#{employee_leave_operator_created_time}','#{employee_leave_operator_id}','#{employee_leave_operator_name}','#{employee_leave_time}','#{employee_master_slave_type}','#{employee_occupation_type}','#{employee_position}','#{employee_salary}','#{employee_salary_bank_number}','#{employee_status}','#{employee_work_place}','#{domainid}','#{employee_tenant_user_id}','#{employee_unique_offset}','#{employee_department_id}','#{employee_insure}','#{employee_is_domain_admin}') ON DUPLICATE KEY UPDATE last_updated_time='#{employee_last_updated_time}';
 
insert into obpm2.tenant_department_employee_relations (id,created_time,master_slave_type,department_id,employee_id) values('#{department_relations_id}','#{department_relations_created_time}','#{department_relations_master_slave_type}','#{department_relations_department_id}','#{department_relations_employee_id}')  ON DUPLICATE KEY UPDATE created_time='#{department_relations_created_time}';

 insert into obpm2.identity_user (id,created_time,NAME,telephone,tenant_user_id,note) values('#{identity_user_id}','#{identity_user_created_time}','#{identity_user_name}','#{identity_user_telephone}','#{identity_user_tenant_user_id}','#{identity_user_note}') ON DUPLICATE KEY UPDATE NAME='#{identity_user_name}';
 
insert into obpm2.identity_principals (id,created_time,last_login_time,last_status_changed_time,last_updated_time,status,identity_user_id) values('#{principals_id}','#{principals_created_time}','#{principals_last_login_time}','#{principals_last_status_changed_time}','#{principals_last_updated_time}','#{principals_status}','#{principals_identity_user_id}') ON DUPLICATE KEY UPDATE identity_user_id='#{principals_identity_user_id}';

 insert into obpm2.identity_userpassword (id,algorithm_type,password,user_name) values('#{userpassword_id}','#{userpassword_algorithm_type}','#{userpassword_password}','#{userpassword_user_name}') ON DUPLICATE KEY UPDATE user_name='#{userpassword_user_name}';
 
  insert into obpm2.t_user (id,DEFAULTDEPARTMENT,LOGINNO,LOGINPWD,NAME,STATUS,DOMAINID,ISDOMAINUSER,ORDERBYNO,FIELD13,
	PWDTYPE	,TELEPHONEPUBLIC,TELEPHONEPUBLIC2,EMAILPUBLIC,USERINFOPUBLIC,LASTMODIFYTIME) values('#{employee_id}','#{employee_department_id}','#{userpassword_user_name}','#{userpassword_password}','#{name}','1','#{domainid}','0','10000','已提交','SM2','1','1','1','1','#{principals_last_updated_time}')  ON DUPLICATE KEY UPDATE STATUS=1;
 
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__gznw4iZWbPKh114QPN9')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__R5sJSjWmK3ckW0SuQjD')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__F0mxUSlh6l7pdfQMhjM')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__hNnMIoSqyNjLXq4fkKx')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__BmNHuhvjmSsisJqc6ls')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__71i5A1UlQNHntcZOMh3')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__AgNju9oSOdZha4OnnWT')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__Ggz9hoU31YMB6ItkjdZ')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__2x0yQDY9USMnrlwlIgc')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';
insert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values('#{department_relations_id}','#{department_relations_department_id}','#{employee_id}','__geu9euXznBvuyr3U8ja')  ON DUPLICATE KEY UPDATE DEPARTMENTID='#{department_relations_department_id}';