public int Insert(Entry entry) { var command = new SQLiteCommand(conn); command.CommandText = "insert into FlashUploader (filename, path, length, uploadtime, checksum) values (\""+ entry.filename+"\", \""+ entry.path+"\", "+entry.length.ToString()+", "+entry.time.ToString()+", \""+entry.checksum+"\")"; var reader = command.ExecuteReader(); if (reader == null) return -1; if (!reader.Read()) return -1; command = new SQLiteCommand(conn); command.CommandText = "select max(ID) from FlashUploader"; var result = command.ExecuteScalar(); return (int)result; }
public Entry QueryByChecksum(string checksum) { var command = new SQLiteCommand(conn); checksum = checksum.Replace('\"', '_'); command.CommandText = "select ID, filename, path, length, uploadtime, checksum from FlashUploader where checksum=\"" + checksum+"\""; var reader = command.ExecuteReader(); if (reader == null) return null; if (!reader.Read()) return null; var result=new Entry { ID = reader.GetInt32(0), filename = reader.GetString(1), path = reader.GetString(2), length = reader.GetInt32(3), time = reader.GetInt64(4), checksum = reader.GetString(5) }; reader.Close(); return result; }
public Entry QueryByID(int ID) { var command = new SQLiteCommand(conn); command.CommandText = "select ID, filename, path, length, uploadtime, checksum from FlashUploader where ID=" + ID.ToString(); var reader = command.ExecuteReader(); if (reader == null) return null; if (!reader.Read()) return null; var result= new Entry { ID = reader.GetInt32(0), filename = reader.GetString(1), path=reader.GetString(2), length = reader.GetInt32(3), time = reader.GetInt64(4), checksum = reader.GetString(5) }; reader.Close(); return result; }