private void setBackupContent(string backupContent)
{
BackupContents bcs = new BackupContents();
try
{
bcs = JsonClassHelper.Json2Class <BackupContents>(backupContent);
}catch (Exception eg) {
return;
}
if (bcs == null || bcs.content == null)
{
return;
}
foreach (BackupContent bc in bcs.content)
{
TreeView tv = new TreeView();
if (bc.Name == "dmp")
{
tv = treeView1;
}
else if (bc.Name == "app")
{
tv = treeView2;
}
else if (bc.Name == "sde")
{
tv = treeView3;
}
foreach (BackupContentType bct in bc.Type)
{
foreach (TreeNode tn in tv.Nodes[0].Nodes)
{
string name = "";
if (tn.Tag is ServiceApp)
{
name = (tn.Tag as ServiceApp).Name;
}
else if (tn.Tag is WebApp)
{
name = (tn.Tag as WebApp).Name;
}
else if (tn.Tag is App)
{
name = (tn.Tag as App).Name;
}
else if (tn.Tag is Ftp)
{
name = (tn.Tag as Ftp).Name;
}
else if (tn.Tag is Gxml)
{
name = (tn.Tag as Gxml).Name;
}
else if (tn.Tag is DbUser)
{
name = (tn.Tag as DbUser).Name;
}
else if (tn.Tag is DbSdeUser)
{
name = (tn.Tag as DbSdeUser).Name;
}
if (name == bct.Name)
{
tn.Checked = true;
if (bct.Set != null && bct.Set.Count > 0)
{
tn.Nodes.Clear();
foreach (BackupContentSet set in bct.Set)
{
TreeNode node = new TreeNode(set.SetValue);
node.Tag = set.SetKey;
node.ForeColor = Color.Red;
node.Checked = true;
tn.Nodes.Add(node);
tn.Expand();
}
}
}
}
}
}
}
public void backup(Set set, string toolsFolder, string toolsTempFolder)
{
BackupContents bcs = new BackupContents();
bcs = JsonClassHelper.Json2Class <BackupContents>(set.Backup.Content);
if (bcs == null || bcs.content == null)
{
return;
}
else
{
exp_tem_path = toolsFolder;
exp_path = toolsTempFolder;
dayString = DateTime.Now.Year + "-" + (DateTime.Now.Month < 10 ? "0" + DateTime.Now.Month : DateTime.Now.Month + "") + "-" + (DateTime.Now.Day < 10 ? "0" + DateTime.Now.Day : DateTime.Now.Day + ""); //DateTime.Now.ToShortDateString();
string timeString = DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "--" + DateTime.Now.Second.ToString();
backup_path = set.Backup.Path + "\\backup-" + dayString + "\\" + timeString;
if (!System.IO.Directory.Exists(backup_path))
{
System.IO.Directory.CreateDirectory(backup_path);
}
setConfig setconfig = new setConfig();
string ansStr = "开始备份数据\r\n";
if (bcs.content.Find((BackupContent bc) => bc.Name == "sde") != null && bcs.content.Find((BackupContent bc) => bc.Name == "sde").Type.Count > 0)
{
//备份 sde库
//初始化 esri授权
setArcgis.init();
setArcgis.grant();
}
foreach (BackupContent bc in bcs.content)
{
if (bc.Type == null)
{
continue;
}
foreach (BackupContentType bctype in bc.Type)
{
if (bc.Name == "dmp")
{
string name = bctype.Name;
DbUser dbuser = set.Db.DbUserList.Find((DbUser du) => du.Name == name);
if (bctype.Set != null && bctype.Set.Count > 0)
{
string remoteInfo = bctype.Set.Find((BackupContentSet bcsset) => bcsset.SetKey == "remoteInfo").SetValue;
string [] remoteInfos = remoteInfo.Split(',');
setBAT.OracleExpdp(exp_tem_path, exp_path, dbuser.User, dbuser.Password, set.Db.Datasource, dbuser.Label, backup_path, remoteInfos[0], remoteInfos[1], remoteInfos[2], bctype.getValueList("excludeTable"), true);
setBAT.FilePackage(exp_tem_path, exp_path, "正在压缩" + dbuser.Label + "dmpdp文件", backup_path + "\\EXP-" + dbuser.User.ToUpper() + ".DMPDP", backup_path + "\\exp-" + dbuser.User, false, null, null, true);
File.Delete(backup_path + "\\exp-" + dbuser.User + ".dmpdp");
ansStr += dbuser.Label + "数据expdp导出完成\r\n";
}
else
{
setBAT.OracleExp(exp_tem_path, exp_path, dbuser.User, dbuser.Password, set.Db.Datasource, dbuser.Label, backup_path, true);
setBAT.FilePackage(exp_tem_path, exp_path, "正在压缩" + dbuser.Label + "dmp文件", backup_path + "\\exp-" + dbuser.User + ".dmp", backup_path + "\\exp-" + dbuser.User, false, null, null, true);
File.Delete(backup_path + "\\exp-" + dbuser.User + ".dmp");
ansStr += dbuser.Label + "数据导出完成\r\n";
}
}
else if (bc.Name == "app")
{
string type = bctype.Type;
string name = bctype.Name;
string labelStr = "";
string appfolder = "";
string appfilename = "";
dynamic typeObject = System.Reflection.Assembly.Load("QuickConfig.Model").CreateInstance(type, false);;
if (typeObject is ServiceApp)
{
ServiceApp dbuser = set.Apps.ServiceAppList.Find((ServiceApp du) => du.Name == name);
labelStr = dbuser.Label;
appfolder = dbuser.Path;
appfilename = dbuser.Label;
}
else if (typeObject is WebApp)
{
WebApp dbuser = set.Apps.WebAppList.Find((WebApp du) => du.Name == name);
labelStr = dbuser.Label;
appfolder = dbuser.Path;
appfilename = dbuser.Label;
}
else if (typeObject is App)
{
App dbuser = set.Apps.AppList.Find((App du) => du.Name == name);
labelStr = dbuser.Label;
appfolder = dbuser.Path;
appfilename = dbuser.Label;
}
else if (typeObject is Ftp)
{
Ftp dbuser = set.Apps.FtpList.Find((Ftp du) => du.Name == name);
labelStr = dbuser.Label;
appfolder = dbuser.Path;
appfilename = dbuser.Label;
}
else if (typeObject is Gxml)
{
Gxml dbuser = set.Apps.GxmlList.Find((Gxml du) => du.Name == name);
labelStr = dbuser.Label;
appfolder = dbuser.Path;
appfilename = dbuser.Label;
}
setBAT.FilePackage(exp_tem_path, exp_path, labelStr, appfolder, backup_path + "\\" + appfilename, true, bctype.getValueList("excludeFolder"), bctype.getValueList("excludeFile"), true);
ansStr += appfilename + "程序备份完成\r\n";
}
else if (bc.Name == "sde")
{
string name = bctype.Name;
DbSdeUser dbuser = set.Db.DbSdeUserList.Find((DbSdeUser du) => du.Name == name);
EngineDatabase engine = new EngineDatabase();
engine.createGDBFile(backup_path, dbuser.Tablespace + ".gdb");
string ans1 = engine.exportSDE2GDBWithWorkspace(set.Db.Ip, "sde:oracle10g:" + set.Db.Datasource, dbuser.User, dbuser.Password, backup_path + "\\" + dbuser.Tablespace + ".gdb");
// setBAT.FilePackage(exp_tem_path, exp_path, "正在压缩" + dbuser.Label + "gdb文件", backup_path + "\\" + dbuser.Tablespace + ".gdb", backup_path + "\\" + dbuser.User,true,null,null, true);
ansStr += dbuser.Label + "导出结果如下:\r\n" + ans1 + "\r\n";
ansStr += dbuser.Label + "导出导出完成\r\n";
}
}
}
ansStr += "备份结束\r\n";
StreamWriter sw = null;
if (!File.Exists(backup_path + "\\" + dayString + ".log"))
{
//不存在就新建一个文本文件,并写入一些内容
sw = File.CreateText(backup_path + "\\" + dayString + ".log");
}
else
{
sw = new StreamWriter(backup_path + "\\" + dayString + ".log");
}
sw.Write(ansStr);
sw.Close();
}
}
private string getBackupContent()
{
BackupContents bcs = new BackupContents();
bcs.content = new List <BackupContent>();
string contentStr = "";
//数据备份
BackupContent bc_dmp = new BackupContent();
bc_dmp.Name = "dmp";
bc_dmp.Type = new List <BackupContentType>();
if (this.treeView1.Nodes[0].Nodes.Count > 0)
{
foreach (TreeNode tn in treeView1.Nodes[0].Nodes)
{
if (tn.Checked == true)
{
BackupContentType type_dmp = new BackupContentType();
type_dmp.Name = (tn.Tag as DbUser).Name;
type_dmp.Type = (tn.Tag as DbUser).GetType().ToString();
type_dmp.Set = new List <BackupContentSet>();
if (tn.Nodes != null)
{
foreach (TreeNode tablenode in tn.Nodes)
{
if (tablenode.Tag.ToString() == "remoteInfo")
{
BackupContentSet bcs_table = new BackupContentSet();
bcs_table.SetKey = "remoteInfo";
bcs_table.SetValue = tablenode.Text;
type_dmp.Set.Add(bcs_table);
}
else if (tablenode.Tag.ToString() == "excludeTable")
{
BackupContentSet bcs_table = new BackupContentSet();
bcs_table.SetKey = "excludeTable";
bcs_table.SetValue = tablenode.Text;
type_dmp.Set.Add(bcs_table);
}
}
}
bc_dmp.Type.Add(type_dmp);
}
}
}
bcs.content.Add(bc_dmp);
//程序备份
BackupContent bc_app = new BackupContent();
bc_app.Name = "app";
bc_app.Type = new List <BackupContentType>();
if (this.treeView2.Nodes[0].Nodes.Count > 0)
{
foreach (TreeNode tn in treeView2.Nodes[0].Nodes)
{
if (tn.Checked == true)
{
BackupContentType type_app = new BackupContentType();
if (tn.Tag is ServiceApp)
{
type_app.Name = (tn.Tag as ServiceApp).Name;
type_app.Type = (tn.Tag as ServiceApp).GetType().ToString();
}
else if (tn.Tag is WebApp)
{
type_app.Name = (tn.Tag as WebApp).Name;
type_app.Type = (tn.Tag as WebApp).GetType().ToString();
}
else if (tn.Tag is App)
{
type_app.Name = (tn.Tag as App).Name;
type_app.Type = (tn.Tag as App).GetType().ToString();
}
else if (tn.Tag is Ftp)
{
type_app.Name = (tn.Tag as Ftp).Name;
type_app.Type = (tn.Tag as Ftp).GetType().ToString();
}
else if (tn.Tag is Gxml)
{
type_app.Name = (tn.Tag as Gxml).Name;
type_app.Type = (tn.Tag as Gxml).GetType().ToString();
}
type_app.Set = new List <BackupContentSet>();
if (tn.Nodes != null)
{
foreach (TreeNode tablenode in tn.Nodes)
{
if (tablenode.Tag.ToString() == "folder")
{
BackupContentSet bcs_table = new BackupContentSet();
bcs_table.SetKey = "excludeFolder";
bcs_table.SetValue = tablenode.Text;
type_app.Set.Add(bcs_table);
}
else if (tablenode.Tag.ToString() == "file")
{
BackupContentSet bcs_table = new BackupContentSet();
bcs_table.SetKey = "excludeFile";
bcs_table.SetValue = tablenode.Text;
type_app.Set.Add(bcs_table);
}
}
}
bc_app.Type.Add(type_app);
}
}
}
bcs.content.Add(bc_app);
//sde备份
BackupContent bc_sde = new BackupContent();
bc_sde.Name = "sde";
bc_sde.Type = new List <BackupContentType>();
if (this.treeView3.Nodes[0].Nodes.Count > 0)
{
foreach (TreeNode tn in treeView3.Nodes[0].Nodes)
{
if (tn.Checked == true)
{
BackupContentType type_sde = new BackupContentType();
type_sde.Name = (tn.Tag as DbSdeUser).Name;
type_sde.Type = (tn.Tag as DbSdeUser).GetType().ToString();
type_sde.Set = new List <BackupContentSet>();
bc_sde.Type.Add(type_sde);
}
}
}
bcs.content.Add(bc_sde);
return(contentStr = JsonClassHelper.Class2Json <BackupContents>(bcs));
}
