protected override bool UpdateItemsToDb(List <R_PbInfo> updateItems) { try { IEnumerable <IGrouping <string, R_PbInfo> > groupYYYYMMDD = updateItems.GroupBy(p => p.Starttime.ToString("yyyyMM")); foreach (IGrouping <string, R_PbInfo> info in groupYYYYMMDD) { var phjinfolist = info.ToList(); var phjModels = ObjectConverter.CopyList <R_PbInfo, R_PbModel>(phjinfolist); if (!pbRepositoty.BulkUpdate("PE_PersonAlarm" + info.Key, phjModels, BuildDataColumn(columns), "Id")) { int isconn = pbRepositoty.GetTotalRecord("DataToDb_GetDbServerIsNormal"); if (isconn <= 0) { AddDataToLocal(phjinfolist); } } } return(true); } catch (Exception ex) { LogHelper.Error("人员报警数据更新失败:" + "\r\n" + ex.Message); return(false); } }
public BasicResponse BacthUpdateAlarmRecord(R_PBBatchUpateRequest r_PbList) { try { var alarmInfos = r_PbList.PbInfoList; if (alarmInfos != null && alarmInfos.Any()) { IEnumerable <IGrouping <string, R_PbInfo> > groupYYYYMM = alarmInfos.GroupBy(p => p.Starttime.ToString("yyyyMM")); foreach (IGrouping <string, R_PbInfo> info in groupYYYYMM) { var alarminfolist = info.ToList(); var alarmModels = ObjectConverter.CopyList <R_PbInfo, R_PbModel>(alarminfolist); _Repository.BulkUpdate("PE_PersonAlarm" + info.Key, alarmModels, BuildDataColumn(columns), "ID"); } } } catch (Exception ex) { LogHelper.Error("批量更新人员报警记录失败:" + "\r\n" + ex.Message); } return(new BasicResponse()); }