info.go 452 Bytes
Newer Older
haoyanbin's avatar
1  
haoyanbin committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
package utils

import "database/sql"

func GetChainIDByStr(db *sql.DB, chainCode string) (int, error) {
	var chainID int
	err := db.QueryRow(`select id from chain_main where chain_code = ?`, chainCode).Scan(&chainID)
	return chainID, err
}

func GetHospitalIDByStr(db *sql.DB, chainCode string) (int, error) {
	var chainID int
	err := db.QueryRow(`select id from hospital_main where hospital_code = ?`, chainCode).Scan(&chainID)
	return chainID, err
}