适用场景:接口数据,已有值不做处理,只做新增处理。
DataTable dt1 = new DataTable();
dt1 = SQLHelper.ExecuteSql($"重复值查询语句",str_sql_conn);
if (dt1 != null && dt1.Rows.Count > 0)
{
List<string> litId = dt1.AsEnumerable().Select(d => d.Field<string>("重复字段名称")).ToList();
foreach (var item in data)
{
DataRow dr = dt.NewRow();
JObject jbt = (JObject)item;
if (litId.Exists(p => p == jbt["重复字段名称"].ToString()))
{
continue;
}
else
{
foreach (var v in jbt)
{
dr[v.Key] = (v.Value.ToString() == "" ? null : v.Value.ToString());
}
}
dt.Rows.Add(dr);
}
}