Queryable.Union 方法实现json格式的字符串合并的具体实例

发布时间:2022-04-16 发布网站:脚本宝典
脚本宝典收集整理的这篇文章主要介绍了Queryable.Union 方法实现json格式的字符串合并的具体实例脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。

1.在数据库中以json字符串格式保存,如:[{"name":"张三","time":"8.592","area":"27.27033","conc":"4.12136"},{"name":"李四","time":"9.100","area":"56.21229","conc":"4.57692"}]

2.添加新内容后合并不相同的数据。如果name相同,以最新的数据替换原来的数据。

如:数据库中原保存的数据是[{"name":"张三","time":"8.592","area":"27.27033","conc":"4.12136"},{"name":"李四","time":"9.100","area":"56.21229","conc":"4.57692"}]

新加的数据为[{"name":"张三","time":"12","area":"27.70533","conc":"4.12136"},{"name":"王五","time":"4","area":"77","conc":"8.788"}]

 则替换后的数据为[{"name":"张三","time":"12","area":"27.70533","conc":"4.12136"},{"name":"王五","time":"4","area":"77","conc":"8.788"},{"name":"李四","time":"9.100","area":"56.21229","conc":"4.57692"}]

代码如下:

复制代码 代码如下:

public void InsertOrUpdateOnlyITem(List<tblLims_Ana_LE_Import_Common> listLe)
        {
            VAR listLeinsert = new List<tblLims_Ana_LE_Import_Common>();
            var listLeUpdate = new List<tblLims_Ana_LE_Import_Common>();
            foreach (var le in listLe)
            {
                tblLims_Ana_LE_Import_Common model = le;
                var own = currentRepository.Find(a => a.fldTaskID == model.fldTaskID
                && a.fldBizCatID == model.fldBizCatID
                && a.fldItemCode == model.fldItemCode
                && a.fldNumber == model.fldNumber
                && a.fldSampleCode == model.fldSampleCode);
                if (own != null)
                {
                    var ser = new JavaScriptSerializer();

                    var listown = ser.Deserialize<List<Dictionary<string, string>>>(own.fldImportData);  //原数据
                    var listmodel = ser.Deserialize<List<Dictionary<string, string>>>(model.fldImportData); //新数据
                    IEqualityComparer<Dictionary<string, string>> ec = new EntityComparer();   //自定义的比较类
                    own.fldImportData = ser.Serialize(listmodel.Union(listown, ec));  //合并数据


                    listLeUpdate.Add(own);
                }
                else
                {
                    listLeInsert.Add(model);
                }
            }
            CurrentRepository.UpdateAll(listLeUpdate);
            CurrentRepository.InsertAll(listLeInsert);
            CurrentRepository.Save();
        }


tblLims_Ana_LE_Import_Common 为数据库中存数据的表

Union() 方法中用到的自定义比较类:

复制代码 代码如下:

/// <summary>
    /// 自定义比较类
    /// </summary>
    public class EntityComparer : IEqualityComparer<Dictionary<string, string>>
    {
        public bool Equals(Dictionary<string, string> x, Dictionary<string, string> y)
        {
            if (ReferenceEquals(x, y)) return true;

            if (ReferenceEquals(x, null) || ReferenceEquals(y, null))
                return false;

            return x["name"] == y["name"];  //如果名称相同就不追加
        }

        public int GetHashCode(Dictionary<string, string> obj)
        {
            if (ReferenceEquals(obj, null)) return 0;
            int hashName = obj["name"] == null ? 0 : obj["name"].GetHashCode();
            int hashCode = obj["name"] == null ? 0 : obj["name"].GetHashCode();
            return hashName ^ hashCode;
        }
    }

脚本宝典总结

以上是脚本宝典为你收集整理的Queryable.Union 方法实现json格式的字符串合并的具体实例全部内容,希望文章能够帮你解决Queryable.Union 方法实现json格式的字符串合并的具体实例所遇到的问题。

如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签:jsonjson