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(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); //原數據
var listmodel = ser.DeserializeListDictionarystring, string>>>(model.fldImportData); //新數據
IEqualityComparerDictionarystring, 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 : 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;
}
}
您可能感興趣的文章:- JS實現合并json對象的方法
- JavaScript簡單實現合并兩個Json對象的方法示例
- JavaScript實現JSON合并操作示例【遞歸深度合并】
- js根據json數據中的某一個屬性來給數據分組的方法
- Javascript中JSON數據分組優化實踐及JS操作JSON總結
- JS遍歷JSON數組及獲取JSON數組長度操作示例【測試可用】
- JavaScript實現構造json數組的方法分析
- JS實現鍵值對遍歷json數組功能示例
- JavaScript數組，JSON對象實現動態添加、修改、刪除功能示例
- js實現json數組分組合并操作示例
