| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- package models
- var Insert_sys_user = `
- insert into sys_user
- (id,login_id,password,name,full_name,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag)
- values
- (?id,?login_id,?password,?name,?full_name,?email,?org_id,?type,?status,?domain,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)
- `
- var Update_sys_user = `
- update sys_user set
- login_id = ?login_id,
- password = ?password,
- name = ?name,
- full_name = ?full_name,
- email = ?email,
- org_id = ?org_id,
- type = ?type,
- status = ?status,
- domain = ?domain,
- create_by = ?create_by,
- create_time = ?create_time,
- last_update_by = ?last_update_by,
- last_update_date = ?last_update_date,
- del_flag = ?del_flag
- where id = ?id
- `
- var Deleteone_sys_user = `
- delete from sys_user
- where id =?id
- `
- var Selectone_sys_user = `
- select
- id,login_id,password,name,full_name,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
- from sys_user
- where id = ?id
- `
- var Selectall_sys_user = `
- select
- id,login_id,password,name,full_name,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
- from sys_user
- `
|