//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();
}
}