You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
1.2 KiB
43 lines
1.2 KiB
package dao |
|
|
|
import ( |
|
"go-common/app/job/main/vip/model" |
|
"go-common/library/database/sql" |
|
|
|
"github.com/pkg/errors" |
|
) |
|
|
|
//GetAbleCode get able code |
|
func (d *Dao) GetAbleCode(tx *sql.Tx, batchCodeID int64) (code string, err error) { |
|
row := tx.QueryRow(_getAbleCodeSQL, batchCodeID) |
|
if err = row.Scan(&code); err != nil { |
|
if err == sql.ErrNoRows { |
|
err = nil |
|
return |
|
} |
|
err = errors.WithStack(err) |
|
} |
|
return |
|
} |
|
|
|
//UpdateCodeRelationID update code relationID |
|
func (d *Dao) UpdateCodeRelationID(tx *sql.Tx, code, relationID string, bmid int64) (err error) { |
|
if _, err = tx.Exec(_updateCodeRelationIDSQL, relationID, bmid, code); err != nil { |
|
err = errors.WithStack(err) |
|
} |
|
return |
|
} |
|
|
|
//SelBatchCodeByID . |
|
func (d *Dao) SelBatchCodeByID(tx *sql.Tx, batchCodeID int64) (r *model.VipResourceBatchCode, err error) { |
|
row := tx.QueryRow(_selBatchCodeSQL, batchCodeID) |
|
r = new(model.VipResourceBatchCode) |
|
if err = row.Scan(&r.ID, &r.BusinessID, &r.PoolID, &r.Status, &r.Type, &r.BatchName, &r.Reason, &r.Unit, &r.Count, &r.SurplusCount, &r.Price, &r.StartTime, &r.EndTime); err != nil { |
|
if err == sql.ErrNoRows { |
|
err = nil |
|
return |
|
} |
|
err = errors.WithStack(err) |
|
} |
|
return |
|
}
|
|
|