public void sdk_LogsCSV()
{
// obtem todos os logs do equipamento
Access_Logs[] list = eqpt.List <Access_Logs>(null, OrderTypes.Descending);
// converte a lista para uma tabela
DataTable tbList = Util.Create <Access_Logs>(list);
// da tabela gera um CSV
Console.Write(TextCSV.Export(tbList));
// Poderia gerar um arquivo direto com o comendo abaixo
// TextCSV.ExportTo(tbList, "arquivo.csv");
}
public void sdk_backupCSV()
{
// id,time,event,device_id,identifier_id,user_id,portal_id,identification_rule_id
string[] cColumns = { "id", "time", "event", "device_id", "identifier_id", "user_id", "portal_id", "identification_rule_id" };
// Exemplo de dados: 1 ,1167799295, 3, 468480, 1651076864, 0, 0, 0
Type[] tColumns = { typeof(long), typeof(long), typeof(int), typeof(long), typeof(long), typeof(long), typeof(long), typeof(long) };
DataTable tb = TextCSV.LoadFrom(@"..\..\backup.csv", "access_logs", cColumns, tColumns, ',');
Console.WriteLine("CSV lido: " + tb.Rows.Count);
foreach (DataRow row in tb.Rows)
{
Console.WriteLine(string.Format("{0}: {1:dd/MM/yyyy HH:mm:ss} {2} d{3} i{4} u{5} p{6} r{7}",
row["id"], // 0
((long)row["time"]).FromUnix(), // 1
(EventTypes)(int)row["event"], // 2
row["device_id"], // 3
row["identifier_id"], // 4
row["user_id"], // 5
row["portal_id"], // 6
row["identification_rule_id"])); // 7
}
}
