Update sys_dictionary.go

SliverHorn · web-flow · commit 347abdc31d81 · 2020-07-17T23:21:50.000+08:00
添加``，解决mysql关键字冲突
diff --git a/server/service/sys_dictionary.go b/server/service/sys_dictionary.go
@@ -85,16 +85,16 @@ func GetSysDictionaryInfoList(info request.SysDictionarySearch) (err error, list
 	var sysDictionarys []model.SysDictionary
 	// 如果有条件搜索 下方会自动创建搜索语句
 	if info.Name != "" {
-		db = db.Where("name LIKE ?", "%"+info.Name+"%")
+		db = db.Where("`name` LIKE ?", "%"+info.Name+"%")
 	}
 	if info.Type != "" {
-		db = db.Where("type LIKE ?", "%"+info.Type+"%")
+		db = db.Where("`type` LIKE ?", "%"+info.Type+"%")
 	}
 	if info.Status != nil {
-		db = db.Where("status = ?", info.Status)
+		db = db.Where("`status` = ?", info.Status)
 	}
 	if info.Desc != "" {
-		db = db.Where("desc LIKE ?", "%"+info.Desc+"%")
+		db = db.Where("`desc` LIKE ?", "%"+info.Desc+"%")
 	}
 	err = db.Count(&total).Error
 	err = db.Limit(limit).Offset(offset).Find(&sysDictionarys).Error

Original file line number	Diff line number	Diff line change
`@@ -85,16 +85,16 @@ func GetSysDictionaryInfoList(info request.SysDictionarySearch) (err error, list`
`85`	`85`	`var sysDictionarys []model.SysDictionary`
`86`	`86`	`// 如果有条件搜索下方会自动创建搜索语句`
`87`	`87`	`if info.Name != "" {`
`88`		`- db = db.Where("name LIKE ?", "%"+info.Name+"%")`
	`88`	+ db = db.Where("`name` LIKE ?", "%"+info.Name+"%")
`89`	`89`	`}`
`90`	`90`	`if info.Type != "" {`
`91`		`- db = db.Where("type LIKE ?", "%"+info.Type+"%")`
	`91`	+ db = db.Where("`type` LIKE ?", "%"+info.Type+"%")
`92`	`92`	`}`
`93`	`93`	`if info.Status != nil {`
`94`		`- db = db.Where("status = ?", info.Status)`
	`94`	+ db = db.Where("`status` = ?", info.Status)
`95`	`95`	`}`
`96`	`96`	`if info.Desc != "" {`
`97`		`- db = db.Where("desc LIKE ?", "%"+info.Desc+"%")`
	`97`	+ db = db.Where("`desc` LIKE ?", "%"+info.Desc+"%")
`98`	`98`	`}`
`99`	`99`	`err = db.Count(&total).Error`
`100`	`100`	`err = db.Limit(limit).Offset(offset).Find(&sysDictionarys).Error`