public static void SharingFile_Update(SharingInfo sf) { if (PreKeyring.SharingFile_Query(sf.CopyRef) == null) { SharingFile_Insert(sf); } else { lock (PreKeyring.conn) { String sql = string.Format(SQLStatement.SharingFile_Update, sf.CopyRef, sf.FileName, sf.ID_From, sf.CKEY_E, sf.CKEY_F, sf.CKEY_U, sf.CKEY_W); if (conn.State == ConnectionState.Closed) { conn.Open(); } using (SqliteCommand cmd = new SqliteCommand()) { cmd.Connection = PreKeyring.conn; cmd.CommandText = sql; if (cmd.ExecuteNonQuery() != 1) { throw new DBException(); } } } } }
public static void SharingFile_TEST() { PreKeyring.SharingFile_Update( new SharingInfo { CopyRef = "ref1", FileName = "file", ID_From = "Hjnubys", CKEY_E = "testE", CKEY_F = "testF", CKEY_U = "testU", CKEY_W = "testW" }); PreKeyring.SharingFile_Update(new SharingInfo { CopyRef = "ref2", FileName = "file2", ID_From = "Hjnubys", CKEY_E = "testE", CKEY_F = "testF", CKEY_U = "testU", CKEY_W = "testW" }); PreKeyring.SharingFile_Update(new SharingInfo { CopyRef = "ref3", FileName = "file2", ID_From = "Hjnubys", CKEY_E = "testE", CKEY_F = "testF", CKEY_U = "testU", CKEY_W = "testW" }); SharingInfo sf = PreKeyring.SharingFile_Query("ref1"); Console.WriteLine( (sf == null) ? "The SharingFileInfo is not exist" : "Find the file info of the copyref with ref"); PreKeyring.SharingFile_Delete(new String[] { "ref1", "ref3" }); List <SharingInfo> sharingfileList = PreKeyring.GetSharingFileList(); foreach (SharingInfo f in sharingfileList) { Console.WriteLine(f.CopyRef + " " + f.FileName + " " + f.ID_From + " " + f.CKEY_E + " " + f.CKEY_F + " " + f.CKEY_U + " " + f.CKEY_W + " "); } }