From 78177cc89c8340302bb0f3eb29504b1f62d8b00c Mon Sep 17 00:00:00 2001
From: 554325746@qq.com <554325746@qq.com>
Date: 星期一, 11 一月 2021 11:40:42 +0800
Subject: [PATCH] 无车牌不推送，表格中和车位数都不占用
---
models/userCar.go | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/models/userCar.go b/models/userCar.go
index 881e48c..2b70962 100644
--- a/models/userCar.go
+++ b/models/userCar.go
@@ -1,6 +1,9 @@
package models
-import "github.com/astaxie/beego/orm"
+import (
+ "fmt"
+ "github.com/astaxie/beego/orm"
+)
type UserCar struct {
Id string `orm:"pk;size(50);column(id)" json:"id"`
@@ -19,7 +22,7 @@
func (uc *UserCar) GetByUserId(userId string) (all []UserCar,err error) {
o := orm.NewOrm()
- _, err = o.Raw("select * from ? where userId=?", uc.TableName(), userId).QueryRows(&all)
+ _, err = o.QueryTable(uc.TableName()).Filter("userId", userId).All(&all)
if err != nil {
return nil, err
}
@@ -36,9 +39,10 @@
return false
}
-func (uc *UserCar) DeleteByUserId(userId string) (int64, error) {
+func (uc *UserCar) Delete(userId string, plateNo string) (int64, error) {
o := orm.NewOrm()
- result, err := o.Raw("delete from ? where userId=?", uc.TableName(), userId).Exec()
+ sql := fmt.Sprintf("delete from "+uc.TableName()+" where userId='%s' and plateNo='%s'", userId, plateNo)
+ result, err := o.Raw(sql).Exec()
if err != nil {
return 0, err
}
--
Gitblit v1.8.0