组织架构-员工管理技术设计

1、员工管理技术设员工管理技术设2018-06-文档控职123456789职新建版日作版修文档控职123456789职新建版日作版修目文档控更目文档控更审分目总体介依赖关配置信用例时序*数据库设E-R应用设 *类算开发参规步未决问未决问总体介依赖关配置信无无总体介依赖关配置信无无*数据 *数据 employee_id(20)NOTNULLAUTO_INCREMENTCOMMENT员工IDemployee_numvarchar(30)NOTNULLCOMMENT员工编码namevarchar(60)NOTNULLCOMMENT员name_envarchar(60)DEFAULTNULLCOMMENT

2、员工英文名tenant_id(20)NOTNULLCOMMENTvarchar(60)DEFAULTNULLCOMMENT电子邮件mobilevarchar(60)DEFAULTNULLCOMMENT移gender(1)NOTNULLCOMMENT0: 1: 女cidvarchar(60DEFAULTNULLCOMMENTenable_flag(1)NOTNULLCOMMENT启用状态_number(20NOTNULLDEFAULT1COMMENTcreation_date datetime NOT NULL DEFAULT CURRENT_TIMESTONUPDATE COMMENT 创建时

3、间 ,created_by(20)NOTNULLDEFAULT1COMMENT创建人last_update_date datetime NOT NULL DEFAULT CURRENT_TIMESTONUPDATE COMMENT 最后更新时间,last_updated_by big(20NOTNULLDEFAULT1COMMENT最后更新人, PRIMARY KEY (employee_id),KEYidk_tenant_id(tenant_id), KEY idk_name (name),UNIQUEKEYuk_employee_num(employee_num), UNIQUE KEY

4、uk_cid (cid)ENGINE=InnoDBDEFAULTCHARSET=utf8COLLATE=utf8_binAUTO_INCREMENT=30002 E-R E-R *原型图设*应用服务方 ApiOperation(value=获取*原型图设*应用服务方 ApiOperation(value=获取员工信息列表) Login = true)TpublicResponseEntitylist(Employeeemployee,ApiIgnoreSortDefault(value=employeeId, direction = Sort.Direction.DESC) PageReque

5、st pageRequest) Pagelist= returnc = Login= Employeeemployee=returnc = LoginpublicResponseEntitylist(Employeeemployee,ApiIgnoreSortDefault(value=employeeId, direction = Sort.Direction.DESC) PageRequest pageRequest) Pagelist= returnc = Login= Employeeemployee=returnc = Login= if sErrors()logger.error(validerror:,rror -etField()+ +thrownewreturnc = Login= if sErrors()logger.error(validerror:,rror -etField()+ +thrownewreturnc = Login=publicRes