Queryable.Union 方法實(shí)現(xiàn)json格式的字符串合并的具體實(shí)例

public void InsertOrUpdateOnlyItem(ListtblLims_Ana_LE_Import_Common> listLe)
        {
            var listLeInsert = new ListtblLims_Ana_LE_Import_Common>();
            var listLeUpdate = new ListtblLims_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.DeserializeListDictionarystring, string>>>(own.fldImportData);  //原數(shù)據(jù)
                    var listmodel = ser.DeserializeListDictionarystring, string>>>(model.fldImportData); //新數(shù)據(jù)
                    IEqualityComparerDictionarystring, string>> ec = new EntityComparer();   //自定義的比較類
                    own.fldImportData = ser.Serialize(listmodel.Union(listown, ec));  //合并數(shù)據(jù)

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

/// summary>
    /// 自定義比較類
    /// /summary>
    public class EntityComparer : IEqualityComparerDictionarystring, string>>
    {
        public bool Equals(Dictionarystring, string> x, Dictionarystring, 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(Dictionarystring, 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;
        }
    }