//public bool HasFile(string dbname, int folderid, int fileid) //{ // DbConnectionExtension.SafeChangeDatabase(m_conn.SystemConnection, dbname); // WantStructure(false); // if (m_mode == Mode.Clear) return false; // using (DbCommand cmd = m_conn.SystemConnection.CreateCommand()) // { // cmd.CommandText = String.Format("SELECT id FROM d2dx_file WHERE folder_id={0} AND id='{1}'", folderid, fileid); // using (DbDataReader reader = cmd.ExecuteReader()) // { // return reader.Read(); // } // } //} private void LoadFileData(string dbname, int folderid, string filename, out string data, out string type) { DbConnectionExtension.SafeChangeDatabase(m_conn.SystemConnection, dbname); WantStructure(false); using (DbCommand cmd = m_conn.SystemConnection.CreateCommand()) { cmd.CommandText = String.Format("SELECT data_type, file_data FROM d2dx_file WHERE folder_id={0} AND file_name='{1}'", folderid, filename); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { type = reader[0].SafeToString(); object val = reader[1]; if (val is byte[]) { data = Encoding.UTF8.GetString((byte[])val); } else { data = val.SafeToString(); } return; } throw new InternalError("DAE-00027 File not found:" + filename); } } }
public void RenameFile(string dbname, int folderid, string filename, string newname) { DbConnectionExtension.SafeChangeDatabase(m_conn.SystemConnection, dbname); WantStructure(true); using (DbCommand cmd = m_conn.SystemConnection.CreateCommand()) { cmd.CommandText = String.Format("UPDATE d2dx_file SET file_name='{0}' WHERE folder_id={1} AND file_name='{2}'", newname, folderid, filename); cmd.ExecuteNonQuery(); } }