public void insertNewLSVehInfo(List <VEHICLEHISTROYSTATE> aci) { if (aci.Count > 0) { foreach (VEHICLEHISTROYSTATE item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }
public void insertNewSSVehInfo(List <VEHICLEREALSTATUS> aci) { if (aci.Count > 0) { foreach (VEHICLEREALSTATUS item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); bool HaveVeh = SelSql.GetBoolHaveVeh(item.VEHICLECARD); LogHelper.WriteLog("VEHICLEREALSTATUS开始" + HaveVeh + "," + item.VEHICLECARD); if (HaveVeh == true) { ParameterSql parSql = DataExchangeDataAccessUpdateSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS更新数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS更新数据失败。"); } } else { ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } else { LogHelper.WriteLog("VEHICLEREALSTATUS插入数据成功。"); } } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }
public void insertNewEventInfo(List <ALARM_EVENT_INFO> aci) { if (aci.Count > 0) { foreach (ALARM_EVENT_INFO item in aci) { try { DataExchangeDataAccessSelectSql SelSql = new DataExchangeDataAccessSelectSql(); bool Have_ALARM_EVENT = SelSql.GetBoolHave_ALARM_EVENT(item.DATATIME); LogHelper.WriteLog("ALARM_EVENT_INFO开始" + Have_ALARM_EVENT + "," + item.DATATIME); if (Have_ALARM_EVENT == true) { ParameterSql parSql = DataExchangeDataAccessUpdateSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("ALARM_EVENT_INFO更新数据成功。"); } else { LogHelper.WriteLog("ALARM_EVENT_INFO更新数据失败。"); } } else { ParameterSql parSql = DataExchangeDataAccessSql.GetDataExchangeDataAccessSql(item); int i = DB120Helpcle.ExecuteSql(parSql.StrSql, parSql.OrclPar); if (i > 0) { LogHelper.WriteLog("ALARM_EVENT_INFO插入数据成功。"); } else { LogHelper.WriteLog("ALARM_EVENT_INFO插入数据成功。"); } } } catch (Exception ex) { LogHelper.WriteLog("", ex); } } } }