Sql_SysRole_gen.go 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. package models
  2. var Insert_sys_role = `
  3. insert into sys_role
  4. (id,name,code,remark,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag)
  5. values
  6. (?id,?name,?code,?remark,?status,?domain,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)
  7. `
  8. var Update_sys_role = `
  9. update sys_role set
  10. name = ?name,
  11. code = ?code,
  12. remark = ?remark,
  13. status = ?status,
  14. domain = ?domain,
  15. create_by = ?create_by,
  16. create_time = ?create_time,
  17. last_update_by = ?last_update_by,
  18. last_update_date = ?last_update_date,
  19. del_flag = ?del_flag
  20. where id = ?id
  21. `
  22. var Deleteone_sys_role = `
  23. delete from sys_role
  24. where id =?id
  25. `
  26. var Selectone_sys_role = `
  27. select
  28. id,name,code,remark,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  29. from sys_role
  30. where id = ?id
  31. `
  32. var Selectall_sys_role = `
  33. select
  34. id,name,code,remark,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
  35. from sys_role
  36. `