public void ReadCatalog() { AStatic.Catalog = new List<ALibModel>(); string sql = "select tag, category, pyindex, pyfspell from accounts order by pyindex asc"; ADbInteractive db = new ADbInteractive(AStatic.DbPath); using (SQLiteDataReader reader = db.ExecReader(sql, null)) { while (reader.Read()) { AStatic.Catalog.Add(new ALibModel(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3))); } reader.Close(); } }
public void ReadAccount(string t) { string sql = "select * from accounts where tag='" + t + "'"; ADbInteractive db = new ADbInteractive(AStatic.DbPath); using (SQLiteDataReader reader = db.ExecReader(sql, null)) { while (reader.Read()) { tag = reader.GetString(1); category = reader.GetString(2); url = reader.GetString(3); user = reader.GetString(4); password = reader.GetString(5); phone = reader.GetString(6); mail = reader.GetString(7); notes = reader.GetString(8); } reader.Close(); } }
public void HtmlExport(string fname) { using (StreamReader fs = new StreamReader("share\\head.html")) { head = fs.ReadToEnd(); } head += "<h2>Accounts</h2>\n"; DateTime dt = DateTime.Now; head += "<p>" + dt.ToString() + "</p>\n"; body = "<table class=\"dataintable\">\n<tbody>\n"; body += "<tr>"; for (int i = 1; i < 10; i++) { body += "<th>"+title[i - 1] + "</th>\n"; } body += "</tr>\n"; string sql = "select * from accounts order by pyindex asc"; ADbInteractive db = new ADbInteractive(AStatic.DbPath); using (SQLiteDataReader reader = db.ExecReader(sql, null)) { while (reader.Read()) { body += "<tr>\n"; for (int i = 1; i < 10; i++) { body += "<td>" + reader.GetString(i) + "</td>\n"; } body += "</tr>\n"; } reader.Close(); } using (StreamWriter fw = new StreamWriter(fname, false)) { fw.Write(head + body + tail); } }
public void TxtExport(string fname) { string sql = "select * from accounts order by pyindex asc"; FileStream fs = new FileStream(fname, FileMode.Create); StreamWriter sw = new StreamWriter(fs); string result = ""; for (int i = 1; i < 10; i++) { result += title[i - 1] + ","; } sw.Write(result + "\r\n"); result = ""; ADbInteractive db = new ADbInteractive(AStatic.DbPath); using (SQLiteDataReader reader = db.ExecReader(sql, null)) { while (reader.Read()) { for (int i = 1; i < 10; i++) { result += reader.GetString(i) + ","; } result += "\r\n"; } reader.Close(); } sw.Write(result); sw.Close(); fs.Close(); }