private bool checkSDEimportSet()
{
string errStr = "";
//导入数据文件检查
Db db = QuickConfig.Common.setXml.getConfig(ConfigName).Db;
if (!Common.checkFolder(db.Impfolder))
{
errStr += "数据文件存放地址必须填写,请重新设置\r\n";
}
foreach (Control ctl in dbControlList)
{
if (ctl is gdbChoose && ((gdbChoose)ctl).Check == true)
{
string Name = ((gdbChoose)ctl).Name;
DbSdeUser dbsdeuser = db.DbSdeUserList.Find((DbSdeUser ds) => ds.Name == Name);
if (!Common.checkGDBFolder(dbsdeuser.Gdbfile))
{
errStr += dbsdeuser.Label + "的GDB文件夹不存在,请重新设置\r\n";
}
}
}
if (errStr != "")
{
MessageBox.Show(errStr, "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
return(true);
}
public void SetValue(DbSdeUser dbsdeuser)
{
this._name = dbsdeuser.Name;
this.label.Text = dbsdeuser.Label;
this.tablespace.Text = dbsdeuser.Tablespace;
this.user.Text = dbsdeuser.User;
this.password.Text = dbsdeuser.Password;
}
public void SetValue(DbSdeUser dbSdeUser)
{
this._name = dbSdeUser.Name;
this.gdb_label.Text = dbSdeUser.Label;
this._user = dbSdeUser.User;
this._password = dbSdeUser.Password;
this.gdb_folderPath.Text = dbSdeUser.Gdbfile;
}
public void setValue(DbSdeUser dbsdeuser)
{
this.txt_name.Text = dbsdeuser.Name;
this.txt_label.Text = dbsdeuser.Label;
this.txt_tablespace.Text = dbsdeuser.Tablespace;
this.txt_user.Text = dbsdeuser.User;
this.txt_password.Text = dbsdeuser.Password;
this.txt_gdbpath.Text = dbsdeuser.Gdbfile;
this.txt_relativepath.Text = dbsdeuser.Relativepath;
}
private void loadDbInit()
{
Db db = configset.Db;
List <Control> dbCtlsList = new List <Control>();
//设置数据主目录
impdataFolder impdatafolder = new impdataFolder();
impdatafolder.SetValue(db);
DbInitControlAdd(impdatafolder);
//设置普通用户初始化
if (db.DbUserList.Count > 0)
{
for (int i = 0; i < db.DbUserList.Count; i++)
{
DbUser dbuser = db.DbUserList[i];
dmpChoose dmpchoose = new dmpChoose();
dmpchoose.SetValue(dbuser);
DbInitControlAdd(dmpchoose);
dbCtlsList.Add(dmpchoose);
}
}
//设置sde用户初始化
if (db.DbSdeUserList.Count > 0)
{
for (int i = 0; i < db.DbSdeUserList.Count; i++)
{
DbSdeUser dbsdeuser = db.DbSdeUserList[i];
gdbChoose gdbchoose = new gdbChoose();
gdbchoose.SetValue(dbsdeuser);
DbInitControlAdd(gdbchoose);
dbCtlsList.Add(gdbchoose);
}
sdeCoordinateSystemSet sdecss = new sdeCoordinateSystemSet();
sdecss.CS_TYPE = db.CS_TYPE;
sdecss.WKID = db.WKID;
sdecss.Prjpath = db.Prjpath;
DbInitControlAdd(sdecss);
dbCtlsList.Add(sdecss);
}
dbInit dbinit = new dbInit();
dbinit.dbControlList = dbCtlsList;
dbinit.SetButtons(db);
dbinit.ConfigName = configName;
DbInitControlAdd(dbinit);
}
private void loadDbSetControls()
{
Db db = configset.Db;
//设置表头
dbTableTitleSet dbtabletitleset = new dbTableTitleSet();
DbSetControlAdd(dbtabletitleset);
//设置普通用户
if (db.DbUserList.Count > 0)
{
for (int i = 0; i < db.DbUserList.Count; i++)
{
DbUser dbuser = db.DbUserList[i];
dbUserSet dbuserset = new dbUserSet();
dbuserset.SetValue(dbuser);
DbSetControlAdd(dbuserset);
}
}
//设置sde用户
if (db.DbSdeUserList.Count > 0)
{
for (int i = 0; i < db.DbSdeUserList.Count; i++)
{
DbSdeUser dbsdeuser = db.DbSdeUserList[i];
dbSdeUserSet dbsdeuserset = new dbSdeUserSet();
dbsdeuserset.SetValue(dbsdeuser);
DbSetControlAdd(dbsdeuserset);
}
}
//设置system用户
if (db.DbSystemUser != null)
{
dbSystemuserSet dbsystemuserset = new dbSystemuserSet();
dbsystemuserset.SetValue(db.DbSystemUser);
DbSetControlAdd(dbsystemuserset);
//设置数据源
dbSet dbset = new dbSet();
dbset.SetValue(db);
dbset.SetSystemUserSet(dbsystemuserset);
DbSetControlAdd(dbset);
}
}
public Object getValue()
{
DbSdeUser dbsdeuser = new DbSdeUser();
dbsdeuser.Name = this.txt_name.Text;
dbsdeuser.Label = this.txt_label.Text;
dbsdeuser.Tablespace = this.txt_tablespace.Text;
dbsdeuser.User = this.txt_user.Text;
dbsdeuser.Password = this.txt_password.Text;
dbsdeuser.Gdbfile = this.txt_gdbpath.Text;
dbsdeuser.Relativepath = this.txt_relativepath.Text;
return(dbsdeuser);
}
private void btnCreateSde_Click(object sender, EventArgs e)
{
setArcgis.init();
EngineDatabase engine = new EngineDatabase();
Db db = QuickConfig.Common.setXml.getConfig(ConfigName).Db;
try
{
setDB setdb = new setDB(db.DbSystemUser.User, db.DbSystemUser.Password, db.Datasource);
foreach (Control ctl in dbControlList)
{
if (ctl is gdbChoose && ((gdbChoose)ctl).Check == true)
{
string Name = ((gdbChoose)ctl).Name;
DbSdeUser dbsdeuser = db.DbSdeUserList.Find((DbSdeUser ds) => ds.Name == Name);
if (setdb.isUserExist(dbsdeuser.User))
{
// MessageBox.Show("现势库已存在");
if (MessageBox.Show("现势库已存在,是否删除已有的现势库", "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
bool res = setdb.deleteUser(dbsdeuser.User);
if (res == true)
{
MessageBox.Show("现势库删除成功!");
}
else
{
MessageBox.Show("现势库删除失败!");
}
}
}
else
{
string ans1 = engine.createSDE("Oracle", db.Datasource, db.DbSystemUser.User, db.DbSystemUser.Password, dbsdeuser.User, dbsdeuser.Password, dbsdeuser.Tablespace, Common.getSdeEcpFile());
setdb.grantUser(dbsdeuser.User);
MessageBox.Show("现势库创建结果如下:\r\n" + ans1);
}
}
}
}
catch (Exception eg)
{
MessageBox.Show(eg.Message.ToString());
}
MessageBox.Show("企业空间库操作结束");
}
private void btnCreateTablespace_Click(object sender, EventArgs e)
{
Db db = QuickConfig.Common.setXml.getConfig(ConfigName).Db;
try
{
setDB setdb = new setDB(db.DbSystemUser.User, db.DbSystemUser.Password, db.Datasource);
string ansStr = "开始创建表空间\r\n";
foreach (Control ctl in dbControlList)
{
if (ctl is dmpChoose && ((dmpChoose)ctl).Check == true)
{
string Name = ((dmpChoose)ctl).Name;
DbUser dbuser = db.DbUserList.Find((DbUser ds) => ds.Name == Name);
bool ans = setdb.createTabelspace(dbuser.Tablespace, db.Datafolder + "\\" + dbuser.Tablespace + ".DBF", "50m");
if (ans == true)
{
ansStr += "表空间 " + dbuser.Tablespace + "创建成功\r\n";
}
else
{
ansStr += "表空间" + dbuser.Tablespace + "创建失败\r\n";
}
}
else if (ctl is gdbChoose && ((gdbChoose)ctl).Check == true)
{
string Name = ((gdbChoose)ctl).Name;
DbSdeUser dbsdeuser = db.DbSdeUserList.Find((DbSdeUser ds) => ds.Name == Name);
bool ans = setdb.createTabelspace(dbsdeuser.Tablespace, db.Datafolder + "\\" + dbsdeuser.Tablespace + ".DBF", "50m");
if (ans == true)
{
ansStr += "表空间" + dbsdeuser.Tablespace + "创建成功\r\n";
}
else
{
ansStr += "表空间" + dbsdeuser.Tablespace + "创建失败\r\n";
}
}
}
ansStr += "结束创建\r\n";
MessageBox.Show(ansStr);
}
catch (Exception eg)
{
MessageBox.Show(eg.Message.ToString());
}
}
private void btnInitSde_Click(object sender, EventArgs e)
{
if (MessageBox.Show("初始化空间库，会删除空间库原有内容，\r\n,请先备空间库库!\r\n继续请点击确定，放弃请点击取消。", "初始化空间库", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Cancel)
{
return;
}
if (!checkSDEimportSet())
{
return;
}
//初始化 esri授权
setArcgis.init();
setArcgis.grant();
EngineDatabase engine = new EngineDatabase();
Db db = QuickConfig.Common.setXml.getConfig(ConfigName).Db;
try
{
setDB setdb = new setDB(db.DbSystemUser.User, db.DbSystemUser.Password, db.Datasource);
foreach (Control ctl in dbControlList)
{
if (ctl is gdbChoose && ((gdbChoose)ctl).Check == true)
{
string Name = ((gdbChoose)ctl).Name;
DbSdeUser dbsdeuser = db.DbSdeUserList.Find((DbSdeUser ds) => ds.Name == Name);
string ans1 = "";
if (setdb.isUserExist(dbsdeuser.User))
{
setdb.grantUser(dbsdeuser.User);
ans1 += "用户 " + dbsdeuser.User + "授权成功\r\n";
}
ans1 += engine.importGDB2SDEWithWorkspace(db.Ip, "sde:oracle10g:" + db.Datasource, dbsdeuser.User, dbsdeuser.Password, dbsdeuser.Gdbfile, db.CS_TYPE, db.WKID, db.Prjpath);
MessageBox.Show(dbsdeuser.Label + "创建结果如下:\r\n" + ans1);
}
}
}
catch (Exception eg)
{
MessageBox.Show(eg.Message.ToString());
}
MessageBox.Show("企业空间库初始化完成");
}
private void btnSaveConfig_Click(object sender, EventArgs e)
{
if (allControl.Count > 0)
{
#region 序
Control mfctl = allControl.Find((Control ctl) => (ctl is mainFolder));
Apps apps = new Apps();
mainFolder mf = mfctl as mainFolder;
apps.Name = mf.Name;
apps.Label = mf.Label;
apps.Path = mf.FolderPath;
//-- 服务
List <ServiceApp> serviceapps = new List <ServiceApp>();
List <Control> servicesctl = allControl.FindAll((Control ctl) => (ctl is serviceSet));
if (servicesctl != null && servicesctl.Count > 0)
{
foreach (Control ctl in servicesctl)
{
serviceSet serviceset = ctl as serviceSet;
ServiceApp serviceapp = new ServiceApp();
serviceapp.Name = serviceset.Name;
serviceapp.Label = serviceset.Label;
serviceapp.Path = serviceset.FolderPath;
serviceapp.ConfigFolder = serviceset.ConfigFolder;
serviceapp.Ip = serviceset.Ip;
serviceapp.Port = serviceset.Port;
ServiceApp oldServiceapp = configset.Apps.ServiceAppList.Find((ServiceApp sa) => sa.Name == serviceset.Name);
serviceapp.Relativepath = oldServiceapp.Relativepath;
serviceapp.Servicename = oldServiceapp.Servicename;
serviceapp.Installbat = oldServiceapp.Installbat;
serviceapp.Removebat = oldServiceapp.Removebat;
serviceapps.Add(serviceapp);
}
}
apps.ServiceAppList = serviceapps;
//-- 网站
List <WebApp> webapps = new List <WebApp>();
List <Control> webappsctl = allControl.FindAll((Control ctl) => (ctl is webSiteSet));
if (webappsctl != null && webappsctl.Count > 0)
{
foreach (Control ctl in webappsctl)
{
webSiteSet websiteset = ctl as webSiteSet;
WebApp webapp = new WebApp();
webapp.Name = websiteset.Name;
webapp.Label = websiteset.Label;
webapp.Path = websiteset.FolderPath;
webapp.ConfigFolder = websiteset.ConfigFolder;
webapp.SiteName = websiteset.SiteName;
webapp.Ip = websiteset.Ip;
webapp.Port = websiteset.Port;
webapp.X86bit = websiteset.X86bit;
WebApp oldWebapp = configset.Apps.WebAppList.Find((WebApp sa) => sa.Name == websiteset.Name);
webapp.Relativepath = oldWebapp.Relativepath;
webapp.VirtualDirList = websiteset.VirtualDirList;
webapps.Add(webapp);
}
}
apps.WebAppList = webapps;
//--程序
List <App> appList = new List <App>();
List <Control> appsctl = allControl.FindAll((Control ctl) => (ctl is appFolder));
if (appsctl != null && appsctl.Count > 0)
{
foreach (Control ctl in appsctl)
{
appFolder appfolder = ctl as appFolder;
App app = new App();
app.Name = appfolder.Name;
app.Label = appfolder.Label;
app.Path = appfolder.FolderPath;
app.ConfigFolder = appfolder.ConfigFolder;
App oldApp = configset.Apps.AppList.Find((App sa) => sa.Name == appfolder.Name);
app.Relativepath = oldApp.Relativepath;
appList.Add(app);
}
}
apps.AppList = appList;
//--ftp站点
List <Ftp> ftpList = new List <Ftp>();
List <Control> ftpsctl = allControl.FindAll((Control ctl) => (ctl is ftpSiteSet));
if (ftpsctl != null && ftpsctl.Count > 0)
{
foreach (Control ctl in ftpsctl)
{
ftpSiteSet ftpsiteset = ctl as ftpSiteSet;
Ftp ftp = new Ftp();
ftp.Name = ftpsiteset.Name;
ftp.Label = ftpsiteset.Label;
ftp.Path = ftpsiteset.FolderPath;
ftp.Ip = ftpsiteset.Ip;
ftp.User = ftpsiteset.User;
ftp.Password = ftpsiteset.Password;
Ftp oldFtp = configset.Apps.FtpList.Find((Ftp sa) => sa.Name == ftpsiteset.Name);
ftp.Relativepath = oldFtp.Relativepath;
ftpList.Add(ftp);
}
}
apps.FtpList = ftpList;
//--共享目录
List <Gxml> gxmlList = new List <Gxml>();
List <Control> gxmlsctl = allControl.FindAll((Control ctl) => (ctl is gxmlSet));
if (gxmlsctl != null && gxmlsctl.Count > 0)
{
foreach (Control ctl in gxmlsctl)
{
gxmlSet gxmlset = ctl as gxmlSet;
Gxml gxml = new Gxml();
gxml.Name = gxmlset.Name;
gxml.Label = gxmlset.Label;
gxml.Path = gxmlset.FolderPath;
gxml.Ip = gxmlset.Ip;
gxml.User = gxmlset.User;
gxml.Password = gxmlset.Password;
Gxml oldGxml = configset.Apps.GxmlList.Find((Gxml sa) => sa.Name == gxmlset.Name);
gxml.Relativepath = oldGxml.Relativepath;
gxmlList.Add(gxml);
}
}
apps.GxmlList = gxmlList;
#endregion
#region 数据
Control datasourcectl = allControl.Find((Control ctl) => (ctl is dbSet));
Control dataimpctl = allControl.Find((Control ctl) => (ctl is impdataFolder));
dbSet dbset = datasourcectl as dbSet;
impdataFolder impdatafolder = dataimpctl as impdataFolder;
Db db = new Db();
db.Name = dbset.Name;
db.Label = impdatafolder.Label;
db.Ip = dbset.Ip;
db.Datasource = dbset.Datasource;
db.Datafolder_type = dbset.DataFolder_type;
db.Datafolder = dbset.DataFolder;
db.Relativepath = configset.Db.Relativepath;
Control scs = allControl.Find((Control ctl) => (ctl is sdeCoordinateSystemSet));
if (scs != null)
{
db.CS_TYPE = ((sdeCoordinateSystemSet)scs).CS_TYPE;
db.WKID = ((sdeCoordinateSystemSet)scs).WKID;
db.Prjpath = ((sdeCoordinateSystemSet)scs).Prjpath;
}
else
{
db.CS_TYPE = "";
db.WKID = "";
db.Prjpath = "";
}
db.Impfolder = impdatafolder.FolderPath;
//-- system用户
Control systemuserctl = allControl.Find((Control ctl) => (ctl is dbSystemuserSet));
dbSystemuserSet dbsystemuserset = systemuserctl as dbSystemuserSet;
DbSystemUser dbsystemuser = new DbSystemUser();
dbsystemuser.Name = dbsystemuserset.Name;
dbsystemuser.Label = dbsystemuserset.Label;
dbsystemuser.User = dbsystemuserset.User;
dbsystemuser.Password = dbsystemuserset.Password;
db.DbSystemUser = dbsystemuser;
//-- 普通用户
List <DbUser> dbuserList = new List <DbUser>();
List <Control> dbusersctl = allControl.FindAll((Control ctl) => (ctl is dbUserSet));
if (dbusersctl != null && dbusersctl.Count > 0)
{
foreach (Control ctl in dbusersctl)
{
dbUserSet dbuserset = ctl as dbUserSet;
DbUser dbuser = new DbUser();
dbuser.Name = dbuserset.Name;
dbuser.Label = dbuserset.Label;
dbuser.Tablespace = dbuserset.Tablespace;
dbuser.User = dbuserset.User;
dbuser.Password = dbuserset.Password;
Control dmpchoosectl = allControl.Find((Control cc) => (cc is dmpChoose) && ((cc as dmpChoose).Name == dbuserset.Name));
dmpChoose dmpchoose = dmpchoosectl as dmpChoose;
dbuser.Dmpfile = dmpchoose.FilePath;
DbUser oldDbuser = configset.Db.DbUserList.Find((DbUser sa) => sa.Name == dbuserset.Name);
dbuser.Relativepath = oldDbuser.Relativepath;
dbuserList.Add(dbuser);
}
}
db.DbUserList = dbuserList;
//-- sde 用户
List <DbSdeUser> dbsdeuserList = new List <DbSdeUser>();
List <Control> dbsdeusersctl = allControl.FindAll((Control ctl) => (ctl is dbSdeUserSet));
if (dbsdeusersctl != null && dbsdeusersctl.Count > 0)
{
foreach (Control ctl in dbsdeusersctl)
{
dbSdeUserSet dbsdeuserset = ctl as dbSdeUserSet;
DbSdeUser dbsdeuser = new DbSdeUser();
dbsdeuser.Name = dbsdeuserset.Name;
dbsdeuser.Label = dbsdeuserset.Label;
dbsdeuser.Tablespace = dbsdeuserset.Tablespace;
dbsdeuser.User = dbsdeuserset.User;
dbsdeuser.Password = dbsdeuserset.Password;
Control gdbchoosectl = allControl.Find((Control cc) => (cc is gdbChoose) && ((cc as gdbChoose).Name == dbsdeuserset.Name));
gdbChoose gdbchoose = gdbchoosectl as gdbChoose;
dbsdeuser.Gdbfile = gdbchoose.FolderPath;
DbSdeUser oldDbsdeuser = configset.Db.DbSdeUserList.Find((DbSdeUser sa) => sa.Name == dbsdeuserset.Name);
dbsdeuser.Relativepath = oldDbsdeuser.Relativepath;
dbsdeuserList.Add(dbsdeuser);
}
}
db.DbSdeUserList = dbsdeuserList;
#endregion
#region 参数
Pars pars = new Pars();
List <Par> parList = new List <Par>();
List <Control> parsctl = allControl.FindAll((Control ctl) => (ctl is parSet));
if (parsctl != null && parsctl.Count > 0)
{
foreach (Control ctl in parsctl)
{
parSet parset = ctl as parSet;
Par par = new Par();
par.Key = parset.Key;
par.Label = parset.Label;
par.Value = parset.Value;
parList.Add(par);
}
}
pars.ParList = parList;
#endregion
#region 工具
Definebtns definebtns = new Definebtns();
List <Btn> btnList = new List <Btn>();
List <Control> btnsctl = allControl.FindAll((Control ctl) => (ctl is btnSet));
if (btnsctl != null && btnsctl.Count > 0)
{
foreach (Control ctl in btnsctl)
{
btnSet btnset = ctl as btnSet;
Btn btn = new Btn();
btn = btnset.btn;
btnList.Add(btn);
}
}
definebtns.BtnList = btnList;
#endregion
#region 备份
Backup backup = new Backup();
Control backupfolderctl = allControl.Find((Control ctl) => (ctl is backupFolder));
backupFolder backupfolder = backupfolderctl as backupFolder;
Control backupcontentsetctl = allControl.Find((Control ctl) => (ctl is backupContentSet));
backupContentSet backupcontentset = backupcontentsetctl as backupContentSet;
Control backupsetctl = allControl.Find((Control ctl) => (ctl is backupSet));
backupSet backupset = backupsetctl as backupSet;
backup.Name = backupfolder.Name;
backup.Label = backupfolder.Label;
backup.Content = backupcontentset.BackupContent;
backup.Path = backupfolder.BackupFolderPath;
backup.Type = backupset.Type;
backup.Type_daytime = backupset.Type_daytime;
backup.Type_week = backupset.Type_week;
backup.Type_weektime = backupset.Type_weektime;
backup.Type_month = backupset.Type_month;
backup.Type_monthtime = backupset.Type_monthtime;
#endregion
//保存成Set
configset.Apps = apps;
configset.Db = db;
configset.Pars = pars;
configset.Definebtns = definebtns;
configset.Backup = backup;
saveConfig();
setMessage.MessageShow("", "保存成功!", this.btnSaveConfig);
}
}
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 void CopyFile(InstallProgress.SetShow setShow)
{
this.Invoke(setShow, new object[] { "复制文件", 1 });
writeLog("复制文件");
int numStart = 1;
int numMax = 15;
Common.setConfig setconfig = new Common.setConfig();
Common.setXml setxml = new Common.setXml();
DataTable dt = setxml.readInstallXML(Tools.getInstallConfigFolder());
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string type = dt.Rows[i]["type"].ToString();
string name = dt.Rows[i]["name"].ToString();
string xmlname = dt.Rows[i]["xmlname"].ToString();
string packagefilepath = Tools.getInstallPackagesFolder() + "\\" + name + ".7z";
string targetFolder = "";
string label = "";
if (type == "serviceapp")
{
ServiceApp sa = set.Apps.ServiceAppList.Find((ServiceApp du) => du.Name == xmlname);
targetFolder = set.Apps.Path + "\\" + sa.Relativepath;
label = sa.Label;
}
else if (type == "webapp")
{
WebApp sa = set.Apps.WebAppList.Find((WebApp du) => du.Name == xmlname);
targetFolder = set.Apps.Path + "\\" + sa.Relativepath;
label = sa.Label;
}
else if (type == "app")
{
App sa = set.Apps.AppList.Find((App du) => du.Name == xmlname);
targetFolder = set.Apps.Path + "\\" + sa.Relativepath;
label = sa.Label;
}
else if (type == "dmp")
{
DbUser sa = set.Db.DbUserList.Find((DbUser du) => du.Name == xmlname);
targetFolder = set.Apps.Path + "\\" + set.Db.Relativepath;
label = sa.Label;
}
else if (type == "gdb")
{
DbSdeUser sa = set.Db.DbSdeUserList.Find((DbSdeUser du) => du.Name == xmlname);
targetFolder = set.Apps.Path + "\\" + sa.Relativepath;
label = sa.Label;
}
if (!Directory.Exists(targetFolder))
{
Directory.CreateDirectory(targetFolder);
}
Common.setBAT.FileExtract(Tools.getToolsFolder(), Tools.getToolsTempFolder(), label, packagefilepath, targetFolder, false);
if (numStart != numMax)
{
this.Invoke(setShow, new object[] { type + "文件:" + label + "复制完成", numStart });
writeLog(type + "文件:" + label + "复制完成");
numStart++;
}
}
}
}
private void changeDefaultPath(string mainFolder)
{
List <Control> servicectl = allControl.FindAll((Control ctl) => (ctl is serviceSet));
if (servicectl != null && servicectl.Count > 0)
{
foreach (Control ctl in servicectl)
{
ServiceApp serviceapp = set.Apps.ServiceAppList.Find((ServiceApp sa) => sa.Name == ((serviceSet)ctl).Name);
((serviceSet)ctl).FolderPath = mainFolder + "\\" + serviceapp.Relativepath;
}
}
List <Control> websitectl = allControl.FindAll((Control ctl) => (ctl is webSiteSet));
if (websitectl != null && websitectl.Count > 0)
{
foreach (Control ctl in websitectl)
{
WebApp webapp = set.Apps.WebAppList.Find((WebApp sa) => sa.Name == ((webSiteSet)ctl).Name);
((webSiteSet)ctl).FolderPath = mainFolder + "\\" + webapp.Relativepath;
}
}
List <Control> appctl = allControl.FindAll((Control ctl) => (ctl is appFolder));
if (appctl != null && appctl.Count > 0)
{
foreach (Control ctl in appctl)
{
App app = set.Apps.AppList.Find((App sa) => sa.Name == ((appFolder)ctl).Name);
((appFolder)ctl).FolderPath = mainFolder + "\\" + app.Relativepath;
}
}
List <Control> ftpctl = allControl.FindAll((Control ctl) => (ctl is ftpSiteSet));
if (ftpctl != null && ftpctl.Count > 0)
{
foreach (Control ctl in ftpctl)
{
Ftp ftp = set.Apps.FtpList.Find((Ftp sa) => sa.Name == ((ftpSiteSet)ctl).Name);
((ftpSiteSet)ctl).FolderPath = mainFolder + "\\" + ftp.Relativepath;
}
}
List <Control> gxmlctl = allControl.FindAll((Control ctl) => (ctl is gxmlSet));
if (gxmlctl != null && gxmlctl.Count > 0)
{
foreach (Control ctl in gxmlctl)
{
Gxml gxml = set.Apps.GxmlList.Find((Gxml sa) => sa.Name == ((gxmlSet)ctl).Name);
((gxmlSet)ctl).FolderPath = mainFolder + "\\" + gxml.Relativepath;
}
}
List <Control> impdatafolderctl = allControl.FindAll((Control ctl) => (ctl is impdataFolder));
if (impdatafolderctl != null && impdatafolderctl.Count > 0)
{
foreach (Control ctl in impdatafolderctl)
{
((impdataFolder)ctl).FolderPath = mainFolder + "\\" + set.Db.Relativepath;
}
}
List <Control> dmpctl = allControl.FindAll((Control ctl) => (ctl is dmpChoose));
if (dmpctl != null && dmpctl.Count > 0)
{
foreach (Control ctl in dmpctl)
{
DbUser dbuser = set.Db.DbUserList.Find((DbUser sa) => sa.Name == ((dmpChoose)ctl).Name);
((dmpChoose)ctl).FilePath = mainFolder + "\\" + dbuser.Relativepath;
}
}
List <Control> gdbctl = allControl.FindAll((Control ctl) => (ctl is gdbChoose));
if (gdbctl != null && gdbctl.Count > 0)
{
foreach (Control ctl in gdbctl)
{
DbSdeUser dbsdeuser = set.Db.DbSdeUserList.Find((DbSdeUser sa) => sa.Name == ((gdbChoose)ctl).Name);
((gdbChoose)ctl).FolderPath = mainFolder + "\\" + dbsdeuser.Relativepath;
}
}
}
