From 03880bf61cf059f063e252ef17dfea50c932c9dc Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期三, 12 十一月 2025 09:11:03 +0800
Subject: [PATCH] 清理数据接口修改
---
camera-common/models/camera.go | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/camera-common/models/camera.go b/camera-common/models/camera.go
index 4161961..e7ff4b8 100644
--- a/camera-common/models/camera.go
+++ b/camera-common/models/camera.go
@@ -331,6 +331,41 @@
return result.RowsAffected > 0
}
+func (camera *Camera) DelLink(id int64) (err error) {
+
+ //鍒犻櫎鍏宠仈妫�娴嬪唴瀹�
+ dbdel1 := db.Exec("delete from mal_task_check_link where task_id=?", id)
+ err = dbdel1.Error
+ if err != nil || dbdel1.RowsAffected == 0 {
+ return err
+ }
+ //鍒犻櫎鍏宠仈棰勮瑙勫垯
+ dbdel2 := db.Exec("delete from mal_task_rule_link where task_id=?", id)
+ err = dbdel2.Error
+ if err != nil || dbdel2.RowsAffected == 0 {
+ return err
+ }
+ //鍒犻櫎鍏宠仈鎽勫儚鏈轰换鍔�
+ dbdel3 := db.Exec("delete from mal_task_video_link where task_id=?", id)
+ err = dbdel3.Error
+ if err != nil || dbdel3.RowsAffected == 0 {
+ return err
+ }
+ //鍒犻櫎鍏宠仈宸ヤ綔鏃堕棿
+ dbdel4 := db.Exec("delete from mal_task_work_time_link where task_id=?", id)
+ err = dbdel4.Error
+ if err != nil || dbdel4.RowsAffected == 0 {
+ return err
+ }
+ //鍒犻櫎鍏宠仈鐭ヨ瘑搴�
+ dbdel5 := db.Exec("delete from mal_knowledge_link where task_id=?", id)
+ err = dbdel5.Error
+ if err != nil || dbdel5.RowsAffected == 0 {
+ return err
+ }
+ return
+}
+
func (camera *Camera) Delete(cid string) (int64, error) {
var err error
tx := GetDB().Begin()
--
Gitblit v1.8.0