1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
// Composition of file name in format yy/mm/dd
fileName = "AB" + actualDate.Substring(8, 2) + actualDate.Substring(3, 2)+ actualDate.Substring(0, 2);
// Search for number of files stored in the same day
nbResults = 0;
string filtFileName = "SELECT * FROM Results WHERE Filename LIKE '" + fileName + ".???'";
string filter = "SELECT COUNT(*) FROM ResultsWHERE Filename LIKE '" + fileName;
DataTable resultsFilter = dataAccess.GetDataTable(dataAccess.SendSqlRequest(filter));
DataTable resultsfiltFileName = dataAccess.GetDataTable(dataAccess.SendSqlRequest(filtFileName));
if (Convert.ToDouble(filter) != 0)
{
// c ici que je beugue pas mal :mrgreen::mrgreen:
}
else
{
nbResults = 0;
_fileName = _fileName + ".000";
} |