private void CreateSDE(InstallProgress.SetShow setShow)
{
this.Invoke(setShow, new object[] { "创建地理空间库", 26 });
writeLog("创建地理空间库");
int numStart = 26;
int numMax = 30;
Common.setArcgis.init();
Common.EngineDatabase engine = new Common.EngineDatabase();
try
{
Common.setDB setdb = new Common.setDB(set.Db.DbSystemUser.User, set.Db.DbSystemUser.Password, set.Db.Datasource);
foreach (DbSdeUser dbsdeuser in set.Db.DbSdeUserList)
{
if (setdb.isUserExist(dbsdeuser.User))
{
if (MessageBox.Show(dbsdeuser.Label + "已存在,是否删除已有的" + dbsdeuser.Label, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
bool res = setdb.deleteUser(dbsdeuser.User);
if (res == true)
{
//MessageBox.Show(dbsdeuser.Label + "删除成功!");
writeLog(dbsdeuser.Label + "删除成功!");
}
else
{
//MessageBox.Show(dbsdeuser.Label + "删除失败!");
writeLog(dbsdeuser.Label + "删除失败!");
}
}
}
else
{
string ans1 = engine.createSDE("Oracle", set.Db.Datasource, set.Db.DbSystemUser.User, set.Db.DbSystemUser.Password, dbsdeuser.User, dbsdeuser.Password, dbsdeuser.Tablespace, Tools.getSdeEcpFile());
setdb.grantUser(dbsdeuser.User);
writeLog(ans1);
if (numStart != numMax)
{
this.Invoke(setShow, new object[] { dbsdeuser.Label + "空间库创建结束", numStart });
writeLog(dbsdeuser.Label + "空间库创建结果：" + ans1 + "\r\n");
writeLog(dbsdeuser.Label + "空间库创建结束");
}
}
}
}
catch (Exception eg)
{
MessageBox.Show(eg.Message.ToString());
}
this.Invoke(setShow, new object[] { "企业空间库操作结束", 30 });
writeLog("企业空间库操作结束");
}
private void InitSDE(InstallProgress.SetShow setShow)
{
this.Invoke(setShow, new object[] { "初始化空间库", 31 });
writeLog("初始化空间库");
if (MessageBox.Show("初始化空间库，会删除空间库原有内容，\r\n,请先备空间库库!\r\n继续请点击确定，放弃请点击取消。", "初始化空间库", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Cancel)
{
return;
}
//初始化 esri授权
Common.setArcgis.init();
Common.setArcgis.grant();
Common.EngineDatabase engine = new Common.EngineDatabase();
try
{
Common.setDB setdb = new Common.setDB(set.Db.DbSystemUser.User, set.Db.DbSystemUser.Password, set.Db.Datasource);
foreach (DbSdeUser dbsdeuser in set.Db.DbSdeUserList)
{
string ans1 = "";
if (setdb.isUserExist(dbsdeuser.User))
{
setdb.grantUser(dbsdeuser.User);
ans1 = "用户 " + dbsdeuser.User + "授权成功\r\n";
writeLog(ans1);
}
ans1 = engine.importGDB2SDEWithWorkspace(set.Db.Ip, "sde:oracle10g:" + set.Db.Datasource, dbsdeuser.User, dbsdeuser.Password, dbsdeuser.Gdbfile, set.Db.CS_TYPE, set.Db.WKID, set.Db.Prjpath);
//MessageBox.Show(dbsdeuser.Label + "创建结果如下:\r\n" + ans1);
writeLog(dbsdeuser.Label + "创建结果如下:\r\n" + ans1);
}
}
catch (Exception eg)
{
// MessageBox.Show(eg.Message.ToString());
writeLog(eg.Message.ToString());
}
// MessageBox.Show("企业空间库初始化完成");
this.Invoke(setShow, new object[] { "企业空间库初始化完成", 40 });
writeLog("企业空间库初始化完成");
}
