AuthorityDao.go 1.9 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. package manage
  2. import (
  3. "demo/configs"
  4. "demo/data/domain"
  5. "demo/data/domain/vo"
  6. )
  7. func GetAuthorityById(id int64) (domain.Authority, error) {
  8. var authority domain.Authority
  9. _, err := configs.Engine.Table("authority").Where("id = ?", id).Get(&authority)
  10. if err != nil {
  11. return authority, err
  12. }
  13. return authority, nil
  14. }
  15. func GetAuthorityListInId(ids []int64) ([]domain.Authority, error) {
  16. rows, err := configs.Engine.Table("authority").In("id", ids).Rows(&domain.Authority{})
  17. if err != nil {
  18. return make([]domain.Authority, 0), err
  19. }
  20. defer rows.Close()
  21. var list []domain.Authority
  22. for rows.Next() {
  23. var u domain.Authority
  24. rows.Scan(&u)
  25. list = append(list, u)
  26. }
  27. return list, nil
  28. }
  29. func GetAuthorityList(authority domain.Authority, pageNum, pageSize int) (vo.BaseListVo, error) {
  30. var arr []domain.Authority
  31. Count, err := configs.Engine.Table("authority").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &authority)
  32. var vo vo.BaseListVo
  33. if err != nil {
  34. return vo, err
  35. }
  36. if err != nil {
  37. return vo, err
  38. }
  39. vo.PageNum = pageNum
  40. vo.PageSize = pageSize
  41. vo.List = make([]any, len(arr))
  42. for i, v := range arr {
  43. vo.List[i] = v
  44. }
  45. vo.Total = int(Count)
  46. return vo, nil
  47. }
  48. func SaveAuthority(authority *domain.Authority) (domain.Authority, error) {
  49. _, err := configs.Engine.Table("authority").Insert(&authority)
  50. if err != nil {
  51. return *authority, err
  52. }
  53. return *authority, nil
  54. }
  55. func SetAuthority(authorityMap map[string]interface{}, id int64) (domain.Authority, bool, error) {
  56. var authority domain.Authority
  57. _, err := configs.Engine.Table("authority").Where("id = ?", id).Update(authorityMap)
  58. if err != nil {
  59. return authority, false, err
  60. }
  61. return authority, true, nil
  62. }
  63. func DeleteAuthority(id int64) bool {
  64. var authority domain.Authority
  65. i, err := configs.Engine.Table("authority").Where("id = ?", id).Delete(&authority)
  66. if err != nil {
  67. return false
  68. }
  69. return i > 0
  70. }