Sql_SysUser_gen.go 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. package models
  2. var Insert_sys_user = `
  3. insert into sys_user
  4. (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)
  5. values
  6. (?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)
  7. `
  8. var Update_sys_user = `
  9. update sys_user set
  10. login_id = ?login_id,
  11. password = ?password,
  12. name = ?name,
  13. full_name = ?full_name,
  14. email = ?email,
  15. org_id = ?org_id,
  16. type = ?type,
  17. status = ?status,
  18. domain = ?domain,
  19. create_by = ?create_by,
  20. create_time = ?create_time,
  21. last_update_by = ?last_update_by,
  22. last_update_date = ?last_update_date,
  23. del_flag = ?del_flag
  24. where id = ?id
  25. `
  26. var Deleteone_sys_user = `
  27. delete from sys_user
  28. where id =?id
  29. `
  30. var Selectone_sys_user = `
  31. select
  32. 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
  33. from sys_user
  34. where id = ?id
  35. `
  36. var Selectall_sys_user = `
  37. select
  38. 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
  39. from sys_user
  40. `