Sql_SysOrg_gen.go 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. package models
  2. var Insert_sys_org = `
  3. insert into sys_org
  4. (id,parent,name,full_name,leader,type,order,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag)
  5. values
  6. (?id,?parent,?name,?full_name,?leader,?type,?order,?status,?domain,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)
  7. `
  8. var Update_sys_org = `
  9. update sys_org set
  10. parent = ?parent,
  11. name = ?name,
  12. full_name = ?full_name,
  13. leader = ?leader,
  14. type = ?type,
  15. order = ?order,
  16. status = ?status,
  17. domain = ?domain,
  18. create_by = ?create_by,
  19. create_time = ?create_time,
  20. last_update_by = ?last_update_by,
  21. last_update_date = ?last_update_date,
  22. del_flag = ?del_flag
  23. where id = ?id
  24. `
  25. var Deleteone_sys_org = `
  26. delete from sys_org
  27. where id =?id
  28. `
  29. var Selectone_sys_org = `
  30. select
  31. id,parent,name,full_name,leader,type,order,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  32. from sys_org
  33. where id = ?id
  34. `
  35. var Selectall_sys_org = `
  36. select
  37. id,parent,name,full_name,leader,type,order,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  38. from sys_org
  39. `