当前位置：Gxlcms > 数据库问题 > .net core WebAPI+EF 动态接收前台json，并动态修改数据库

.net core WebAPI+EF 动态接收前台json，并动态修改数据库

时间：2021-07-01 10:21:17 帮助过：17人阅读

async Task<IActionResult> PutModel(DTO model) { 　　_context.Entry(model).State = EntityState.Modified; 　　var result = await _context.SaveChangesAsync().ConfigureAwait(false); 　　return OK("修改实体成功!"); }

这样做后台是很方便，可是EF全部更新效率实在太低，而且没必要，而且前台就需要把所有的DTO对象都传过来，如果有不想要修改的怎么办？好吧。用EF的

  1. 　　_context.Entry(model).Property(m => m.<span class="tlid-translation translation" lang="en"><span title="">Field1</span></span>).IsModified = <span style="color: #0000ff;">false</span>;
  1. 　　_context.Entry(model).Property(m => m.<span class="tlid-translation translation" lang="en"><span title="">Field2).IsModified = <span style="color: #0000ff;">false;</span></span></span>

如果一个表中有50个字段，有20个需要更新，30个不需要更新，难道写30个_context.Entry(model).Property(m => m.Field1).IsModified = false;这样的语句？或者写20个_context.Entry(model).Property(m => m.Field2).IsModified = true;这样的语句？这样开发效率实在太低。。好吧。还有方法2，针对每个表需要修改的部分都建不同的DTO，再用model.Field1=DTO.Field1,  这要去对每个修改的对象都赋值再更改，如果有一百张表呢？那岂不是要建一百个DTO，，我的天，那多累，程序猿无疑是最懒的，如果换作你，你愿意花时间建100个DTO吗？换作我是的话，我肯定不愿意。有没有更捷径的方法呢？肯定有，那就是用动态传参[dynamic]，这样后台就不需要针对每个要修改的表都建DTO，前台也不需要把表所有的字段都传过来，只需要传页面表单有的字段，也就是修改过的字段，灵活性大大提高，而且提高了开发效率。好了，不废话了。开始正题。

由于dynamic不支持跨域，首先要解决跨域问题，在Startup.cs文件里添加如下代码

  1. <span style="color: #0000ff;">　　　　public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> ConfigureServices(IServiceCollection services)
  2.         {
  3.             </span><span style="color: #008000;">//</span><span style="color: #008000;">跨域设置</span>
  4.             services.AddCors(options =><span style="color: #000000;">
  5.             {
  6.                 options.AddPolicy(</span><span style="color: #800000;">"</span><span style="color: #800000;">allow_all</span><span style="color: #800000;">"</span>, builder =><span style="color: #000000;">
  7.                 {
  8.                     builder.AllowAnyMethod().AllowAnyHeader().AllowAnyOrigin();</span><span style="color: #008000;">//</span><span style="color: #008000;">允许所有域名访问
  9. 　　　　　　　　　　　 </span><span style="color: #008000;">//</span><span style="color: #008000;">builder.WithOrigins("</span><span style="color: #008000; text-decoration: underline;">http://localhost</span><span style="color: #008000;">:8088").AllowAnyHeader();</span><span style="color: #008000;">//</span><span style="color: #008000;">允许指定域名访问</span>
  10. <span style="color: #000000;">                });
  11.             });
  12. 　　　　　}
  13. 　　　　</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> Configure(IApplicationBuilder app, IWebHostEnvironment env, IHttpContextAccessor httpContextAccessor)
  14.         {
  15.             app.UseCors(</span><span style="color: #800000;">"</span><span style="color: #800000;">allow_all</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  16.         }</span>

跨域问题解决之后，添加动态修改数据库的方法。

  1. <span style="color: #0000ff;">using</span><span style="color: #000000;"> Microsoft.AspNetCore.Mvc;
  2. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> Microsoft.EntityFrameworkCore;
  3. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> Newtonsoft.Json;
  4. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  5. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  6. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.ComponentModel.DataAnnotations;
  7. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  8. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Reflection;
  9. </span><span style="color: #0000ff;">namespace</span><span style="color: #000000;"> ASP.NET.Core.EF
  10. {
  11.     </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">页面基类</span><span style="color: #808080;"></summary></span>
  12.     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> PageBase : ControllerBase
  13.     {
  14.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">数据连接</span><span style="color: #808080;"></summary></span>
  15.         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">readonly</span> DBContext _context;<span style="color: #008000;">//</span><span style="color: #008000;">方式1</span>
  16.         <span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">构造函数 初始化数据库连接</span><span style="color: #808080;"></summary></span>
  17.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="context"></span><span style="color: #008000;">数据连接</span><span style="color: #808080;"></param></span>
  18.         <span style="color: #0000ff;">public</span><span style="color: #000000;"> PageBase(DBContext context)
  19.         {
  20.             _context </span>=<span style="color: #000000;"> context;
  21.         }
  22.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  23.         <span style="color: #808080;">///</span><span style="color: #008000;"> 更新指定实体
  24.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  25.         <span style="color: #808080;">///</span> <span style="color: #808080;"><typeparam name="T"></span><span style="color: #008000;">数据表实体Model模型</span><span style="color: #808080;"></typeparam></span>
  26.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="modelNew"></span><span style="color: #008000;">动态Json数据</span><span style="color: #808080;"></param></span>
  27.         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">virtual</span> <span style="color: #0000ff;">void</span> Update<T>(<span style="color: #0000ff;">dynamic</span><span style="color: #000000;"> modelNew)
  28.         {
  29.             </span><span style="color: #008000;">//</span><span style="color: #008000;">序列化动态Json为字符串</span>
  30.             <span style="color: #0000ff;">string</span> json =<span style="color: #000000;"> modelNew.ToString();
  31.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为数据表中的实体对象</span>
  32.             T model = JsonConvert.DeserializeObject<T><span style="color: #000000;">(json);
  33.             </span><span style="color: #008000;">//</span><span style="color: #008000;">把状态全部变为不可更改</span>
  34.             _context.Entry(model).State =<span style="color: #000000;"> EntityState.Unchanged;
  35.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为动态对象中的属性</span>
  36.             <span style="color: #0000ff;">var</span> jsonModel = JsonConvert.DeserializeObject<<span style="color: #0000ff;">dynamic</span>><span style="color: #000000;">(json);
  37.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义一个List来添加属性</span>
  38.             List<<span style="color: #0000ff;">string</span>> listName = <span style="color: #0000ff;">new</span> List<<span style="color: #0000ff;">string</span>><span style="color: #000000;">();
  39.             </span><span style="color: #008000;">//</span><span style="color: #008000;">动态添加要修改的字段</span>
  40.             <span style="color: #0000ff;">foreach</span> (PropertyInfo info <span style="color: #0000ff;">in</span><span style="color: #000000;"> model.GetType().GetProperties())
  41.             {
  42.                 </span><span style="color: #008000;">//</span><span style="color: #008000;">如果EF表中有实体对象，则排除，否则更新会报错,保留枚举</span>
  43.                 <span style="color: #0000ff;">if</span> ((info.PropertyType.IsClass && info.PropertyType == <span style="color: #0000ff;">typeof</span>(String)) || info.PropertyType.IsClass == <span style="color: #0000ff;">false</span><span style="color: #000000;">)
  44.                 {
  45.                     </span><span style="color: #008000;">//</span><span style="color: #008000;">解决大小写问题</span>
  46.                     <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">var</span> property <span style="color: #0000ff;">in</span><span style="color: #000000;"> jsonModel)
  47.                     {
  48.                         </span><span style="color: #0000ff;">if</span> (info.Name.ToLower().Trim() ==<span style="color: #000000;"> property.Name.ToLower().Trim())
  49.                         {
  50.                             listName.Add(info.Name);
  51.                         }
  52.                     }
  53.                 }
  54.             }
  55.             </span><span style="color: #008000;">//</span><span style="color: #008000;">转换要修改的字段为数组</span>
  56.             <span style="color: #0000ff;">string</span>[] ProNames = <span style="color: #0000ff;">string</span>.Join(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>, listName).Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  57.             </span><span style="color: #008000;">//</span><span style="color: #008000;">寻找主键</span>
  58.             PropertyInfo pkProp = <span style="color: #0000ff;">typeof</span>(T).GetProperties().Where(p => p.GetCustomAttributes(<span style="color: #0000ff;">typeof</span>(KeyAttribute), <span style="color: #0000ff;">false</span>).Length > <span style="color: #800080;">0</span><span style="color: #000000;">).FirstOrDefault();
  59.             </span><span style="color: #008000;">//</span><span style="color: #008000;">遍历修改,并排除主键</span>
  60.             <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">string</span> Name <span style="color: #0000ff;">in</span><span style="color: #000000;"> ProNames)
  61.             {
  62.                 </span><span style="color: #0000ff;">if</span> (Name.ToLower() !=<span style="color: #000000;"> pkProp.Name.ToLower())
  63.                 {
  64.                     _context.Entry(model).Property(Name).IsModified </span>= <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  65.                 }
  66.             }
  67.             </span><span style="color: #008000;">//</span><span style="color: #008000;">return db.SaveChanges();</span>
  68. <span style="color: #000000;">        }
  69.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  70.         <span style="color: #808080;">///</span><span style="color: #008000;"> 更新指定实体,不更新指定字段
  71.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  72.         <span style="color: #808080;">///</span> <span style="color: #808080;"><typeparam name="T"></span><span style="color: #008000;">数据表实体Model模型</span><span style="color: #808080;"></typeparam></span>
  73.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="modelNew"></span><span style="color: #008000;">动态Json数据</span><span style="color: #808080;"></param></span>
  74.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="fieldProNames"></span><span style="color: #008000;">不更新的字段列表数组</span><span style="color: #808080;"></param></span>
  75.         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">virtual</span> <span style="color: #0000ff;">void</span> Update<T>(<span style="color: #0000ff;">dynamic</span> modelNew, <span style="color: #0000ff;">string</span><span style="color: #000000;"> fieldProNames)
  76.         {
  77.             </span><span style="color: #008000;">//</span><span style="color: #008000;">序列化动态Json为字符串</span>
  78.             <span style="color: #0000ff;">string</span> json =<span style="color: #000000;"> modelNew.ToString();
  79.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为数据表中的实体对象</span>
  80.             T model = JsonConvert.DeserializeObject<T><span style="color: #000000;">(json);
  81.             </span><span style="color: #008000;">//</span><span style="color: #008000;">把状态全部变为不可更改</span>
  82.             _context.Entry(model).State =<span style="color: #000000;"> EntityState.Unchanged;
  83.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为动态对象中的属性</span>
  84.             <span style="color: #0000ff;">var</span> jsonModel = JsonConvert.DeserializeObject<<span style="color: #0000ff;">dynamic</span>><span style="color: #000000;">(json);
  85.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义一个List来添加属性</span>
  86.             List<<span style="color: #0000ff;">string</span>> listName = <span style="color: #0000ff;">new</span> List<<span style="color: #0000ff;">string</span>><span style="color: #000000;">();
  87.             </span><span style="color: #008000;">//</span><span style="color: #008000;">动态添加要修改的字段</span>
  88.             <span style="color: #0000ff;">foreach</span> (PropertyInfo info <span style="color: #0000ff;">in</span><span style="color: #000000;"> model.GetType().GetProperties())
  89.             {
  90.                 </span><span style="color: #008000;">//</span><span style="color: #008000;">如果EF表中有实体对象，则排除，否则更新会报错,保留枚举</span>
  91.                 <span style="color: #0000ff;">if</span> ((info.PropertyType.IsClass && info.PropertyType == <span style="color: #0000ff;">typeof</span>(String)) || info.PropertyType.IsClass == <span style="color: #0000ff;">false</span><span style="color: #000000;">)
  92.                 {
  93.                     </span><span style="color: #008000;">//</span><span style="color: #008000;">解决大小写问题</span>
  94.                     <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">var</span> property <span style="color: #0000ff;">in</span><span style="color: #000000;"> jsonModel)
  95.                     {
  96.                         </span><span style="color: #0000ff;">if</span> (info.Name.ToLower().Trim() ==<span style="color: #000000;"> property.Name.ToLower().Trim())
  97.                         {
  98.                             listName.Add(info.Name);
  99.                         }
  100.                     }
  101.                 }
  102.             }
  103.             </span><span style="color: #008000;">//</span><span style="color: #008000;">转换要修改的字段为数组</span>
  104.             <span style="color: #0000ff;">string</span>[] ProNames = <span style="color: #0000ff;">string</span>.Join(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>, listName).Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  105.             </span><span style="color: #008000;">//</span><span style="color: #008000;">寻找主键</span>
  106.             PropertyInfo pkProp = <span style="color: #0000ff;">typeof</span>(T).GetProperties().Where(p => p.GetCustomAttributes(<span style="color: #0000ff;">typeof</span>(KeyAttribute), <span style="color: #0000ff;">false</span>).Length > <span style="color: #800080;">0</span><span style="color: #000000;">).FirstOrDefault();
  107.             </span><span style="color: #008000;">//</span><span style="color: #008000;">遍历修改,并排除主键</span>
  108.             <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">string</span> Name <span style="color: #0000ff;">in</span><span style="color: #000000;"> ProNames)
  109.             {
  110.                 </span><span style="color: #0000ff;">if</span> (Name.ToLower() != pkProp.Name.ToLower() && !fieldProNames.Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>).Select(n =><span style="color: #000000;"> n.ToLower()).Contains(Name.ToLower()))
  111.                 {
  112.                     _context.Entry(model).Property(Name).IsModified </span>= <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  113.                 }
  114.             }
  115.             </span><span style="color: #008000;">//</span><span style="color: #008000;">return db.SaveChanges();</span>
  116. <span style="color: #000000;">        }
  117.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  118.         <span style="color: #808080;">///</span><span style="color: #008000;"> 更新指定实体,不更新指定字段,如果每个表中有相同不更新的字段，可以这样写
  119.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  120.         <span style="color: #808080;">///</span> <span style="color: #808080;"><typeparam name="T"></span><span style="color: #008000;">数据表实体Model模型</span><span style="color: #808080;"></typeparam></span>
  121.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="modelNew"></span><span style="color: #008000;">动态Json数据</span><span style="color: #808080;"></param></span>
  122.         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">virtual</span> <span style="color: #0000ff;">void</span> UpdateSpecify<T>(<span style="color: #0000ff;">dynamic</span><span style="color: #000000;"> modelNew)
  123.         {
  124.             </span><span style="color: #008000;">//</span><span style="color: #008000;">序列化动态Json为字符串</span>
  125.             <span style="color: #0000ff;">string</span> json =<span style="color: #000000;"> modelNew.ToString();
  126.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为数据表中的实体对象</span>
  127.             T model = JsonConvert.DeserializeObject<T><span style="color: #000000;">(json);
  128.             </span><span style="color: #008000;">//</span><span style="color: #008000;">把状态全部变为不可更改</span>
  129.             _context.Entry(model).State =<span style="color: #000000;"> EntityState.Unchanged;
  130.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为动态对象中的属性</span>
  131.             <span style="color: #0000ff;">var</span> jsonModel = JsonConvert.DeserializeObject<<span style="color: #0000ff;">dynamic</span>><span style="color: #000000;">(json);
  132.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义一个List来添加属性</span>
  133.             List<<span style="color: #0000ff;">string</span>> listName = <span style="color: #0000ff;">new</span> List<<span style="color: #0000ff;">string</span>><span style="color: #000000;">();
  134.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义不需要更新的字段</span>
  135.             <span style="color: #0000ff;">string</span> fieldProNames = <span style="color: #800000;">"</span><span style="color: #800000;">field1,field2,field3,CreateDate,Creator,IsDel,Updator,UpdateDate</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  136.             </span><span style="color: #008000;">//</span><span style="color: #008000;">动态添加要修改的字段</span>
  137.             <span style="color: #0000ff;">foreach</span> (PropertyInfo info <span style="color: #0000ff;">in</span><span style="color: #000000;"> model.GetType().GetProperties())
  138.             {
  139.                 </span><span style="color: #008000;">//</span><span style="color: #008000;">如果EF表中有实体对象，则排除，否则更新会报错,保留枚举</span>
  140.                 <span style="color: #0000ff;">if</span> ((info.PropertyType.IsClass && info.PropertyType == <span style="color: #0000ff;">typeof</span>(String)) || info.PropertyType.IsClass == <span style="color: #0000ff;">false</span><span style="color: #000000;">)
  141.                 {
  142.                     </span><span style="color: #008000;">//</span><span style="color: #008000;">解决大小写问题</span>
  143.                     <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">var</span> property <span style="color: #0000ff;">in</span> jsonModel && !fieldProNames.Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>).Select(n =><span style="color: #000000;"> n.ToLower()).Contains(info.Name.ToLower()))
  144.                     {
  145.                         </span><span style="color: #0000ff;">if</span> (info.Name.ToLower().Trim() ==<span style="color: #000000;"> property.Name.ToLower().Trim())
  146.                         {
  147.                             listName.Add(info.Name);
  148.                         }
  149.                     }
  150.                 }
  151.             }
  152.             </span><span style="color: #008000;">//</span><span style="color: #008000;">转换要修改的字段为数组</span>
  153.             <span style="color: #0000ff;">string</span>[] ProNames = <span style="color: #0000ff;">string</span>.Join(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>, listName).Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  154.             </span><span style="color: #008000;">//</span><span style="color: #008000;">寻找主键</span>
  155.             PropertyInfo pkProp = <span style="color: #0000ff;">typeof</span>(T).GetProperties().Where(p => p.GetCustomAttributes(<span style="color: #0000ff;">typeof</span>(KeyAttribute), <span style="color: #0000ff;">false</span>).Length > <span style="color: #800080;">0</span><span style="color: #000000;">).FirstOrDefault();
  156.             </span><span style="color: #008000;">//</span><span style="color: #008000;">遍历修改,并排除主键</span>
  157.             <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">string</span> Name <span style="color: #0000ff;">in</span><span style="color: #000000;"> ProNames)
  158.             {
  159.                 </span><span style="color: #0000ff;">if</span> (Name.ToLower() !=<span style="color: #000000;"> pkProp.Name.ToLower())
  160.                 {
  161.                     _context.Entry(model).Property(Name).IsModified </span>= <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  162.                 }
  163.             }
  164.             </span><span style="color: #008000;">//</span><span style="color: #008000;">return db.SaveChanges();</span>
  165. <span style="color: #000000;">        }
  166.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span>
  167.         <span style="color: #808080;">///</span><span style="color: #008000;"> 更新指定实体,不更新指定字段,如果每个表中有相同不更新的字段，可以这样写,扩展方法
  168.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"></summary></span>
  169.         <span style="color: #808080;">///</span> <span style="color: #808080;"><typeparam name="T"></span><span style="color: #008000;">数据表实体Model模型</span><span style="color: #808080;"></typeparam></span>
  170.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="modelNew"></span><span style="color: #008000;">动态Json数据</span><span style="color: #808080;"></param></span>
  171.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="fieldProNames"></span><span style="color: #008000;">不更新的字段列表数组</span><span style="color: #808080;"></param></span>
  172.         <span style="color: #0000ff;">protected</span> <span style="color: #0000ff;">virtual</span> <span style="color: #0000ff;">void</span> UpdateSpecify<T>(<span style="color: #0000ff;">dynamic</span> modelNew, <span style="color: #0000ff;">string</span><span style="color: #000000;"> fieldProNames)
  173.         {
  174.             </span><span style="color: #008000;">//</span><span style="color: #008000;">序列化动态Json为字符串</span>
  175.             <span style="color: #0000ff;">string</span> json =<span style="color: #000000;"> modelNew.ToString();
  176.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为数据表中的实体对象</span>
  177.             T model = JsonConvert.DeserializeObject<T><span style="color: #000000;">(json);
  178.             </span><span style="color: #008000;">//</span><span style="color: #008000;">把状态全部变为不可更改</span>
  179.             _context.Entry(model).State =<span style="color: #000000;"> EntityState.Unchanged;
  180.             </span><span style="color: #008000;">//</span><span style="color: #008000;">反序列化为动态对象中的属性</span>
  181.             <span style="color: #0000ff;">var</span> jsonModel = JsonConvert.DeserializeObject<<span style="color: #0000ff;">dynamic</span>><span style="color: #000000;">(json);
  182.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义一个List来添加属性</span>
  183.             List<<span style="color: #0000ff;">string</span>> listName = <span style="color: #0000ff;">new</span> List<<span style="color: #0000ff;">string</span>><span style="color: #000000;">();
  184.             </span><span style="color: #008000;">//</span><span style="color: #008000;">定义不需要更新的字段</span>
  185.             <span style="color: #0000ff;">string</span> fieldProNameses = <span style="color: #800000;">"</span><span style="color: #800000;">field1,field2,field3,CreateDate,Creator,IsDel,Updator,UpdateDate,</span><span style="color: #800000;">"</span> +<span style="color: #000000;"> fieldProNames;
  186.             </span><span style="color: #008000;">//</span><span style="color: #008000;">动态添加要修改的字段</span>
  187.             <span style="color: #0000ff;">foreach</span> (PropertyInfo info <span style="color: #0000ff;">in</span><span style="color: #000000;"> model.GetType().GetProperties())
  188.             {
  189.                 </span><span style="color: #008000;">//</span><span style="color: #008000;">如果EF表中有实体对象，则排除，否则更新会报错,保留枚举</span>
  190.                 <span style="color: #0000ff;">if</span> ((info.PropertyType.IsClass && info.PropertyType == <span style="color: #0000ff;">typeof</span>(String)) || info.PropertyType.IsClass == <span style="color: #0000ff;">false</span><span style="color: #000000;">)
  191.                 {
  192.                     </span><span style="color: #008000;">//</span><span style="color: #008000;">解决大小写问题</span>
  193.                     <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">var</span> property <span style="color: #0000ff;">in</span> jsonModel && !fieldProNameses.Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>).Select(n =><span style="color: #000000;"> n.ToLower()).Contains(info.Name.ToLower()))
  194.                     {
  195.                         </span><span style="color: #0000ff;">if</span> (info.Name.ToLower().Trim() ==<span style="color: #000000;"> property.Name.ToLower().Trim())
  196.                         {
  197.                             listName.Add(info.Name);
  198.                         }
  199.                     }
  200.                 }
  201.             }
  202.             </span><span style="color: #008000;">//</span><span style="color: #008000;">转换要修改的字段为数组</span>
  203.             <span style="color: #0000ff;">string</span>[] ProNames = <span style="color: #0000ff;">string</span>.Join(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span>, listName).Split(<span style="color: #800000;">"</span><span style="color: #800000;">,</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  204.             </span><span style="color: #008000;">//</span><span style="color: #008000;">寻找主键</span>
  205.             PropertyInfo pkProp = <span style="color: #0000ff;">typeof</span>(T).GetProperties().Where(p => p.GetCustomAttributes(<span style="color: #0000ff;">typeof</span>(KeyAttribute), <span style="color: #0000ff;">false</span>).Length > <span style="color: #800080;">0</span><span style="color: #000000;">).FirstOrDefault();
  206.             </span><span style="color: #008000;">//</span><span style="color: #008000;">遍历修改,并排除主键</span>
  207.             <span style="color: #0000ff;">foreach</span> (<span style="color: #0000ff;">string</span> Name <span style="color: #0000ff;">in</span><span style="color: #000000;"> ProNames)
  208.             {
  209.                 </span><span style="color: #0000ff;">if</span> (Name.ToLower() !=<span style="color: #000000;"> pkProp.Name.ToLower())
  210.                 {
  211.                     _context.Entry(model).Property(Name).IsModified </span>= <span style="color: #0000ff;">true</span><span style="color: #000000;">;
  212.                 }
  213.             }
  214.             </span><span style="color: #008000;">//</span><span style="color: #008000;">return db.SaveChanges();</span>
  215. <span style="color: #000000;">        }
  216.     }
  217. }</span>

利用泛型+反射 添加动态修改数据表的方法完成之后去测试吧。新建个Controller

  1. <span style="color: #0000ff;">using</span><span style="color: #000000;"> Microsoft.AspNetCore.Mvc;
  2. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Threading.Tasks;
  3. </span><span style="color: #0000ff;">namespace</span><span style="color: #000000;"> <span style="color: #000000;">ASP.NET.Core.EF</span>
  4. {
  5.     </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">测试修改控制器</span><span style="color: #808080;"></summary></span>
  6.     [Route(<span style="color: #800000;">"</span><span style="color: #800000;">api/[controller]</span><span style="color: #800000;">"</span><span style="color: #000000;">)]
  7.     [ApiController]
  8.     </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> DemoController : PageBase
  9.     {
  10.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">构造函数</span><span style="color: #808080;"></summary></span>
  11.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="context"></span><span style="color: #008000;">依赖注入数据库连接SQL</span><span style="color: #808080;"></param></span>
  12.         <span style="color: #0000ff;">public</span> DemoController(DBContext context) : <span style="color: #0000ff;">base</span><span style="color: #000000;">(context)
  13.         {
  14.         }
  15.         </span><span style="color: #808080;">///</span> <span style="color: #808080;"><summary></span><span style="color: #008000;">测试修改数据</span><span style="color: #808080;"></summary></span>
  16.         <span style="color: #808080;">///</span> <span style="color: #808080;"><param name="modelModify"></span><span style="color: #008000;">动态修改的Json实体</span><span style="color: #808080;"></param></span>
  17.         <span style="color: #808080;">///</span> <span style="color: #808080;"><returns></returns></span>
  18. <span style="color: #000000;">        [HttpPut]
  19.         </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">async</span> Task<IActionResult> PutModel(<span style="color: #0000ff;">dynamic</span><span style="color: #000000;"> modelModify)
  20.         {
  21.             Update</span><MemberModel><span style="color: #000000;">(modelModify);
  22.             Update</span><MemberModel>(modelModify, <span style="color: #800000;">"</span><span style="color: #800000;">testField1,testField2,testField3</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  23.             UpdateSpecify</span><MemberModel><span style="color: #000000;">(modelModify);
  24.             UpdateSpecify</span><MemberModel>(modelModify, <span style="color: #800000;">"</span><span style="color: #800000;">testField1,testField2,testField3</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  25.             </span><span style="color: #0000ff;">return</span> Ok(<span style="color: #800000;">"</span><span style="color: #800000;">修改成功，请查询数据库</span><span style="color: #800000;">"</span><span style="color: #000000;">);
  26.         }
  27.     }
  28. }</span>

前端测试Json数据

  1. <span style="color: #000000;">{
  2.     </span>"id": 1<span style="color: #000000;">,
  3.     </span>"testField1": "demo1"<span style="color: #000000;">,
  4.     </span>"testField2": "demo2"<span style="color: #000000;">,
  5.     </span>"testField3": "demo3"<span style="color: #000000;">,
  6. }</span>

好了，完功，这样后端开发就很舒服了，可以说轻松加愉快，对于前端也很舒服！解脱了很多时间！！

 

.net core WebAPI+EF 动态接收前台json，并动态修改数据库

标签：前端测试   res   赋值   函数   serialize   构造   context   trim   bapi   

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！