package db import ( "context" "gorm.io/gorm" "youngee_m_api/model/gorm_model" ) //企业ID查找 func GetEnterpriseByEnterpriseID(ctx context.Context, EnterpriseID int64) (*gorm_model.Enterprise, error) { db := GetReadDB(ctx) enterprise := gorm_model.Enterprise{} err := db.Where("enterprise_id = ?", EnterpriseID).First(&enterprise).Error if err != nil { if err == gorm.ErrRecordNotFound { return nil, nil } else { return nil, err } } return &enterprise, nil } // 支付-修改企业账户余额 func UpdateEnterpriseBalance(ctx context.Context, EnterpriseID int64, balance float64, availableBalance float64, frozenBalance float64) (*float64, error) { db := GetReadDB(ctx) err := db.Model(gorm_model.Enterprise{}).Where("enterprise_id", EnterpriseID). Updates(map[string]interface{}{"balance": gorm.Expr("balance + ?", balance), "available_balance": gorm.Expr("available_balance + ?", availableBalance), "frozen_balance": gorm.Expr("frozen_balance + ?", frozenBalance)}).Error if err != nil { return nil, err } enterprise := gorm_model.Enterprise{} err = db.Model(gorm_model.Enterprise{}).Where("enterprise_id", EnterpriseID).Scan(&enterprise).Error if err != nil { return nil, err } return &enterprise.Balance, nil }