81 lines
2.1 KiB
Go
81 lines
2.1 KiB
Go
package dao
|
|
|
|
import (
|
|
"gorm.io/gorm"
|
|
"hospital-admin-api/api/model"
|
|
"hospital-admin-api/global"
|
|
)
|
|
|
|
type UserCaCertDao struct {
|
|
}
|
|
|
|
// GetUserCaCertById 获取监管证书数据-监管证书id
|
|
func (r *UserCaCertDao) GetUserCaCertById(certId int64) (m *model.UserCaCert, err error) {
|
|
err = global.Db.First(&m, certId).Error
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return m, nil
|
|
}
|
|
|
|
// GetUserCaCertByUserId 获取监管证书数据-监管证书id
|
|
func (r *UserCaCertDao) GetUserCaCertByUserId(userId int64) (m *model.UserCaCert, err error) {
|
|
err = global.Db.Where("user_id = ?", userId).First(&m).Error
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return m, nil
|
|
}
|
|
|
|
// GetUserCaCertListByUserId 获取监管证书数据-监管证书id
|
|
func (r *UserCaCertDao) GetUserCaCertListByUserId(userId int64) (m []*model.UserCaCert, err error) {
|
|
err = global.Db.Where("user_id = ?", userId).Find(&m).Error
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return m, nil
|
|
}
|
|
|
|
// AddUserCaCert 新增监管证书
|
|
func (r *UserCaCertDao) AddUserCaCert(tx *gorm.DB, model *model.UserCaCert) (*model.UserCaCert, error) {
|
|
if err := tx.Create(model).Error; err != nil {
|
|
return nil, err
|
|
}
|
|
return model, nil
|
|
}
|
|
|
|
// GetUserCaCertList 获取监管证书列表
|
|
func (r *UserCaCertDao) GetUserCaCertList(maps interface{}) (m []*model.UserCaCert, err error) {
|
|
err = global.Db.Where(maps).Find(&m).Error
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return m, nil
|
|
}
|
|
|
|
// GetUserCaCert 获取监管证书
|
|
func (r *UserCaCertDao) GetUserCaCert(maps interface{}) (m *model.UserCaCert, err error) {
|
|
err = global.Db.Where(maps).First(&m).Error
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
return m, nil
|
|
}
|
|
|
|
// DeleteUserCaCertById 删除监管证书-监管证书id
|
|
func (r *UserCaCertDao) DeleteUserCaCertById(tx *gorm.DB, certId int64) error {
|
|
if err := tx.Delete(&model.UserCaCert{}, certId).Error; err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|
|
|
|
// EditUserCaCertById 修改监管证书-监管证书id
|
|
func (r *UserCaCertDao) EditUserCaCertById(tx *gorm.DB, certId int64, data interface{}) error {
|
|
err := tx.Model(&model.UserCaCert{}).Where("cert_id = ?", certId).Updates(data).Error
|
|
if err != nil {
|
|
return err
|
|
}
|
|
return nil
|
|
}
|