internal static List<GPSRelation> GetAllGPSCodeAndVehicleCode() { DbConnection dbConnection = null; string strSQL = "select gpscode,vehiclecode from gps_installation_info where abolish=0"; List<GPSRelation> relationList = new List<GPSRelation>(); try { DataTable table = new DataTable(); dbConnection = GetConnection(EnumDBOperationType.GlobalDB); if (dbConnection == null) return relationList; if (dbConnection.State != ConnectionState.Open) dbConnection.Open(); DbCommand command = dbConnection.CreateCommand(); command.CommandText = strSQL; DbDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = command; DataSet dataSet = new DataSet(); adapter.Fill(dataSet, "installation_info"); foreach (DataRow row in dataSet.Tables["installation_info"].Rows) { GPSRelation entity = new GPSRelation(); entity.GPSCode = row["gpscode"].ToString(); entity.VehicleCode = TryParseGuid(row["vehiclecode"].ToString()); entity.IsMovoVehicle = false; relationList.Add(entity); } dataSet.Dispose(); adapter.Dispose(); command = dbConnection.CreateCommand(); command.CommandText = "select gpscode,vehiclecode from movo_vehicle"; adapter = new MySqlDataAdapter(); adapter.SelectCommand = command; dataSet = new DataSet(); adapter.Fill(dataSet, "move_vehicle"); foreach (DataRow row in dataSet.Tables["move_vehicle"].Rows) { GPSRelation entity = new GPSRelation(); entity.GPSCode = row["gpscode"].ToString(); entity.VehicleCode = TryParseGuid(row["vehiclecode"].ToString()); entity.IsMovoVehicle = true; relationList.Add(entity); } dataSet.Dispose(); adapter.Dispose(); return relationList; } catch (Exception ex) { Loggers.LogInfo("GPSDataHelper.GetAllGPSCodeAndVehicleCode:" + ex); return relationList; } finally { CloseDBConnection(dbConnection); } }
/// <summary> /// 刷新单个GPS实时位置数据到缓存。 /// </summary> /// <param name="entity"></param> public static void RefreshGPSRelation(GPSRelation entity) { try { List<GPSRelation> entityList = new List<GPSRelation>(); entityList.Add(entity); RefreshGPSRelation(entityList); entityList = null; entity = null; } catch (Exception ex) { Loggers.LogInfo("PES.GPS.GPSStorage.CacheUtility.RefreshGPSDynamicData(single):" + ex); } }