本篇内容主要讲解“如何用Queryable.Union方法实现json格式的字符串合并”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何用Queryable.Union方法实现json格式的字符串合并”吧!
铜川ssl适用于网站、小程序/APP、API接口等需要进行数据传输应用场景，ssl证书未来市场广阔！成为
成都创新互联公司的ssl证书销售渠道，可以享受市场价格4-6折优惠！如果有意向欢迎电话联系或者加微信：18980820575（备注：SSL证书合作）期待与您的合作！
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 listLe)
{
var listLeInsert = new List();
var listLeUpdate = new List();
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>>(own.fldImportData); //原数据
var listmodel = ser.Deserialize>>(model.fldImportData); //新数据
IEqualityComparer> 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() 方法中用到的自定义比较类:
复制代码 代码如下:
///
/// 自定义比较类
///
public class EntityComparer : IEqualityComparer>
{
public bool Equals(Dictionary x, Dictionary 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 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格式的字符串合并-创新互联
本文链接：
http://www.cdkjz.cn/article/csoojh.html
