//true <=, false >=
private List<int> CheckDate(List<string> dateArray, DateTime periodDate, bool reverseDirection)
{
List<int> returnArray = new List<int>();
DateTime dateTime = new DateTime();
DDDClass.TimeReal timeReal;
int index = 0;
foreach (string record in dateArray)
{
timeReal = new DDDClass.TimeReal(record);
dateTime = timeReal.getTimeRealDate();
if (reverseDirection == false)
{
if (dateTime.Date >= periodDate.Date)
returnArray.Add(index);
}
else
{
if (dateTime.Date <= periodDate.Date)
returnArray.Add(index);
}
index++;
}
return returnArray;
}
public DDDClass.TimeReal Get_VehicleOverview_CurrentDateTime(int dataBlockId)
{
SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION());
long timeRealSeconds = sqldbRecords.Get_VOverview_CurrentDateTime(dataBlockId);
DDDClass.TimeReal CurrentDateTime = new DDDClass.TimeReal(timeRealSeconds);
return CurrentDateTime;
}
//Это не вся информация. Есть еще, смотреть CardUnit.CardUnitClass - нет информации в картах для отладки.
public List<DateTime> Get_StartEndPeriod(int dataBlockId)
{
SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION());
string paramName = "ef_driver_activity_data.activityDailyRecords";
string currentParamName;
List<DateTime> returnPeriod = new List<DateTime>();
List<string> activityRecordDate = new List<string>();
currentParamName = paramName + ".activityRecordDate";
activityRecordDate = sqldbRecords.Get_AllParamsArray(dataBlockId, currentParamName);
DateTime date;
if (activityRecordDate.Count > 0)
{
date = new DateTime();
date = new DDDClass.TimeReal(activityRecordDate[0]).getTimeRealDate();
returnPeriod.Add(date);
date = new DDDClass.TimeReal(activityRecordDate[activityRecordDate.Count - 1]).getTimeRealDate();
returnPeriod.Add(date);
}
else
{
date = new DateTime();
returnPeriod.Add(date);
date = new DateTime();
returnPeriod.Add(date);
}
return returnPeriod;
}
//Vehicle_Activities
public List<DDDClass.TimeReal> Get_VehicleActivities_DownloadedDayDate(int dataBlockId)
{
SQLDB_Records sqldbRecords = new SQLDB_Records(connectionString, sqlDB.GETMYSQLCONNECTION());
string paramName;
DDDClass.TimeReal downloadedDayDate = new DDDClass.TimeReal();
List<DDDClass.TimeReal> downloadedDayDateList = new List<DDDClass.TimeReal>();
List<string> downloadedDayDateStringList = new List<string>();
paramName = "vehicleActivities.downloadedDayDate";
downloadedDayDateStringList = sqldbRecords.Get_AllParamsArray(dataBlockId, paramName);
for (int i = 0; i < downloadedDayDateStringList.Count; i++)
{
downloadedDayDate = new DDDClass.TimeReal(Convert.ToInt64(downloadedDayDateStringList[i]));
downloadedDayDateList.Add(downloadedDayDate);
}
return downloadedDayDateList;
}
