| | |
| | | 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() |