解决修改失败bug

yangliGit · yangliGit · commit 347509eaecd3 · 2018-11-29T18:51:07.000+08:00
diff --git a/APIJSON.NET/APIJSON.NET/Controllers/JsonController.cs b/APIJSON.NET/APIJSON.NET/Controllers/JsonController.cs
@@ -251,15 +251,14 @@ public ActionResult Edit([FromBody]string json)
                     }
 
                     var dt = new Dictionary<string, object>();
-                    dt.Add("id", value["id"].ToString());
                     foreach (var f in value)
                     {
-                        if (f.Key.ToLower() != "id"&& selectTable.IsCol(key,f.Key) && (role.Update.Column.Contains ("*")||role.Update.Column.Contains(f.Key, StringComparer.CurrentCultureIgnoreCase)))
+                        if (f.Key.ToLower() != "id" && selectTable.IsCol(key, f.Key) && (role.Update.Column.Contains("*") || role.Update.Column.Contains(f.Key, StringComparer.CurrentCultureIgnoreCase)))
                         {
                             dt.Add(f.Key, f.Value);
                         }
                     }
-                    db.Db.Updateable(dt).AS(key).ExecuteCommand();
+                    db.Db.Updateable(dt).AS(key).Where("id=@id", new { id = value["id"].ToString() }).ExecuteCommand();
                     ht.Add(key, JToken.FromObject(new { code = 200, msg = "success", id = value["id"].ToString() }));
                 }
             }

Original file line number	Diff line number	Diff line change
`@@ -251,15 +251,14 @@ public ActionResult Edit([FromBody]string json)`
`251`	`251`	`}`
`252`	`252`
`253`	`253`	`var dt = new Dictionary<string, object>();`
`254`		`- dt.Add("id", value["id"].ToString());`
`255`	`254`	`foreach (var f in value)`
`256`	`255`	`{`
`257`		`- if (f.Key.ToLower() != "id"&& selectTable.IsCol(key,f.Key) && (role.Update.Column.Contains ("*")\|\|role.Update.Column.Contains(f.Key, StringComparer.CurrentCultureIgnoreCase)))`
	`256`	`+ if (f.Key.ToLower() != "id" && selectTable.IsCol(key, f.Key) && (role.Update.Column.Contains("*") \|\| role.Update.Column.Contains(f.Key, StringComparer.CurrentCultureIgnoreCase)))`
`258`	`257`	`{`
`259`	`258`	`dt.Add(f.Key, f.Value);`
`260`	`259`	`}`
`261`	`260`	`}`
`262`		`- db.Db.Updateable(dt).AS(key).ExecuteCommand();`
	`261`	`+ db.Db.Updateable(dt).AS(key).Where("id=@id", new { id = value["id"].ToString() }).ExecuteCommand();`
`263`	`262`	`ht.Add(key, JToken.FromObject(new { code = 200, msg = "success", id = value["id"].ToString() }));`
`264`	`263`	`}`
`265`	`264`	`}`