async public static Task <FileInfoCollection> GetFileList()
{
FileInfoCollection fileInfos = new FileInfoCollection();
try
{
DataTable table = await MySqlDB.GetDataTableAsync(conStr : _conStr, query : SELECT_FILE_LIST).ConfigureAwait(false);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
uint id = ConvertUtil.StringToUint(row[ColumnNames.ID].ToString());
string fileName = row[ColumnNames.NAME].ToString();
string fileType = row[ColumnNames.TYPE].ToString();
fileInfos.Add(new FileInfo(id: id, fileName: fileName, fileType: fileType));
}
}
}
catch (Exception)
{
throw;
}
return(fileInfos);
}