construction_management/dao/permission_account_dao.go

/*
 * @description: 账号权限
 * @Author: CP
 * @Date: 2021-01-26 15:09:10
 * @FilePath: \construction_management\dao\permission_account_dao.go
 */

package dao

import (
	"errors"

	"github.com/go-xorm/xorm"
	"go.mod/models"
)

//数据库操作引擎
type PermissionAccountDao struct {
	engine *xorm.Engine
}

//获得一个DAO对象
func NewPermissionAccountDao(engine *xorm.Engine) *PermissionAccountDao {
	return &PermissionAccountDao{
		engine: engine,
	}
}

// 获得标段下账号权限
func (d *PermissionAccountDao) GetBidsectionId(bidsectionId int) []models.CmPermissionAccount {
	datalist := make([]models.CmPermissionAccount, 0)
	_ = d.engine.
		Where(" bidsection_id=?  ", bidsectionId).
		Find(&datalist)
	return datalist
}

//更新
func (d *PermissionAccountDao) Update(data *models.CmPermissionAccount, columns []string) error {
	//_, err := d.engine.Id(data.Id).MustCols(columns...).Update(data)
	_, err := d.engine.Where("project_id = ? and bidsection_id = ? and account_id= ? ", data.ProjectId, data.BidsectionId, data.AccountId).MustCols(columns...).Update(data)
	if err != nil {
		return errors.New("更新权限-账号失败")
	}
	return nil
}