| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 |
- // Package postgre
- /**
- * @ File:
- * @ Date: 2021/5/6 11:30
- * @ Author: JYQ
- * @ Description:
- */
- package postgre
- type PGHr struct {
- }
- func (PGHr) PublicSensorQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_public_sensor_query(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) PrivateSensorQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_private_sensor_query(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) PublicSensorsAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_public_sensor_add(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) PrivateSensorsAdd(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_private_sensor_add(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) SensorsEdit(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_sensor_edit(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) SensorsDel(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_sensor_del(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) PkGroupChg(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_pk_group_chg(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) CrBind(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_cr_bind(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) CrUnBind(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_cr_unbind(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
- func (PGHr) UnBindSensorsQuery(optUserId int64, objectShopId int64, jsonStr string, verfStr string) (result string, err error) {
- err = getClient().Raw("select fn_unbind_sensors_query(? ,? ,? )", optUserId, objectShopId, jsonStr, verfStr).
- Scan(&result).Error
- return
- }
|