private void InitDB(InstallProgress.SetShow setShow)
{
this.Invoke(setShow, new object[] { "初始化数据库", 25 });
writeLog("初始化数据库");
int numStart = 41;
int numMax = 50;
Common.setConfig setconfig = new Common.setConfig();
try
{
string ansStr = "开始导入数据\r\n";
writeLog(ansStr);
this.Invoke(setShow, new object[] { "开始导入数据", 25 });
writeLog("开始导入数据");
foreach (DbUser dbuser in set.Db.DbUserList)
{
Common.setBAT.OracleImp(Tools.getToolsFolder(), Tools.getToolsTempFolder(), dbuser.User, dbuser.Password, set.Db.Datasource, dbuser.Dmpfile, set.Db.Impfolder, false);
ansStr = dbuser.Label + "数据导入完成\r\n";
writeLog(ansStr);
if (numStart != numMax)
{
this.Invoke(setShow, new object[] { dbuser.Label + "数据导入完成", numStart });
numStart++;
}
}
ansStr = "导入结束\r\n";
writeLog(ansStr);
this.Invoke(setShow, new object[] { "数据导入结束", 50 });
}
catch (Exception eg)
{
MessageBox.Show(eg.Message.ToString());
}
}
public static void OpenFileWithNotepad(string toolsFolder, string toolsTempFolder, string filePath)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "file", filePath });
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "explorerFile.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\explorerFile.bat", true);
}
public static void ServiceRun(string toolsFolder, string toolsTempFolder, string servicedesc, string servicename, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "servicedesc", servicedesc });
dtPar.Rows.Add(new object[] { "servicename", servicename });
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "Service_Start.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\Service_Start.bat", isshow);
}
public static void RunBatByDefine(string toolsFolder, string toolsTempFolder, string filename, List <string[]> inputList, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
foreach (string[] str in inputList)
{
dtPar.Rows.Add(new object[] { str[0], str[1] });
}
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, filename + ".bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\" + filename + ".bat", isshow);
}
public static void FileExtract(string toolsFolder, string toolsTempFolder, string filedesc, string packagePath, string extractFolder, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "7zfolder", toolsFolder });
dtPar.Rows.Add(new object[] { "filename", filedesc });
dtPar.Rows.Add(new object[] { "targetfile", packagePath });
dtPar.Rows.Add(new object[] { "targetfolder", extractFolder });
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "7z_extract.bat", toolsTempFolder, dtPar);
Common.setBAT.RunBat(toolsTempFolder + @"\7z_extract.bat", isshow);
}
public static void OracleExpdp(string toolsFolder, string toolsTempFolder, string user, string password, string datasource, string dmpdesc, string exportpath, string remoteIP, string remoteAccount, string remotePassword, List <string> excludeTableList, bool isshow)
{
//设置空表导出参数
setDB setdb = new setDB(user, password, datasource);
setdb.setEXP();
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "dmpdesc", dmpdesc });
dtPar.Rows.Add(new object[] { "backupday", exportpath });
dtPar.Rows.Add(new object[] { "user", user });
dtPar.Rows.Add(new object[] { "password", password });
dtPar.Rows.Add(new object[] { "datasource", datasource });
dtPar.Rows.Add(new object[] { "remoteIP", remoteIP });
dtPar.Rows.Add(new object[] { "remoteAccount", remoteAccount });
dtPar.Rows.Add(new object[] { "remotePassword", remotePassword });
SqlExec(toolsFolder, toolsTempFolder, user, password, datasource, "sys_createdumpdir", new List <string[]>(), isshow);
if (excludeTableList != null && excludeTableList.Count > 0)
{
string tablesString = "";
foreach (string tablename in excludeTableList)
{
if (tablesString == "")
{
tablesString += "'" + tablename + "'";
}
else
{
tablesString += ",'" + tablename + "'";
}
}
dtPar.Rows.Add(new object[] { "excludeTable", "EXCLUDE=TABLE:\\\"IN (" + tablesString + ")\\\"" });
}
else
{
dtPar.Rows.Add(new object[] { "excludeTable", "" });
}
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "Oracle_expdp.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\Oracle_expdp.bat", isshow);
}
private void AppSet(InstallProgress.SetShow setShow)
{
this.Invoke(setShow, new object[] { "生成配置", 6 });
writeLog("生成配置");
int numStart = 6;
int numMax = 7;
Common.setXml xml = new Common.setXml();
xml.addCopyFileXML(Tools.getConfigFolder(), Tools.getConfigTemplateFolder(), configName, "copyPath");
Apps apps = QuickConfig.Common.setXml.getConfig(configName).Apps;
Common.setConfig setconfig = new Common.setConfig();
List <string[]> checkApp = new List <string[]>();
foreach (ServiceApp sa in set.Apps.ServiceAppList)
{
string[] configFolder = new string[2];
configFolder[0] = sa.ConfigFolder;
configFolder[1] = sa.Path;
checkApp.Add(configFolder);
}
foreach (WebApp sa in set.Apps.WebAppList)
{
string[] configFolder = new string[2];
configFolder[0] = sa.ConfigFolder;
configFolder[1] = sa.Path;
checkApp.Add(configFolder);
}
foreach (App sa in set.Apps.AppList)
{
string[] configFolder = new string[2];
configFolder[0] = sa.ConfigFolder;
configFolder[1] = sa.Path;
checkApp.Add(configFolder);
}
setconfig.config(Tools.getConfigTemplateFolder(), Tools.getConfigTemplateTempFolder(), configName, checkApp);
if (numStart != numMax)
{
this.Invoke(setShow, new object[] { "配置程序完成", numStart });
writeLog("配置程序完成");
numStart++;
}
}
public static void OracleImp(string toolsFolder, string toolsTempFolder, string user, string password, string datasource, string filepath, string impfolder, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "user", user });
dtPar.Rows.Add(new object[] { "password", password });
dtPar.Rows.Add(new object[] { "datasource", datasource });
dtPar.Rows.Add(new object[] { "dmpfile", filepath });
dtPar.Rows.Add(new object[] { "impfolder", impfolder });
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "oracle_imp.bat", toolsTempFolder, dtPar);
Common.setBAT.RunBat(toolsTempFolder + @"\oracle_imp.bat", isshow);
}
public static void OracleExp(string toolsFolder, string toolsTempFolder, string user, string password, string datasource, string dmpdesc, string exportpath, bool isshow)
{
//设置空表导出参数
setDB setdb = new setDB(user, password, datasource);
setdb.setEXP();
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "dmpdesc", dmpdesc });
dtPar.Rows.Add(new object[] { "backupday", exportpath });
dtPar.Rows.Add(new object[] { "user", user });
dtPar.Rows.Add(new object[] { "password", password });
dtPar.Rows.Add(new object[] { "datasource", datasource });
setConfig setconfig = new Common.setConfig();
setconfig.repalceParByDefine(toolsFolder, "Oracle_exp.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\Oracle_exp.bat", isshow);
}
public static void FilePackage(string toolsFolder, string toolsTempFolder, string filedesc, string filepath, string packagefilepath, bool isFolder, List <string> excludeFolderList, List <string> excludeFileList, bool isshow)
{
DataTable dtPar = new DataTable();
dtPar.Columns.Add("name", typeof(string));
dtPar.Columns.Add("value", typeof(string));
//然后把你想要加的数据加进DataTable 里
dtPar.Rows.Add(new object[] { "7zfolder", toolsFolder });
dtPar.Rows.Add(new object[] { "filename", filedesc });
dtPar.Rows.Add(new object[] { "target", packagefilepath + ".7z" });
dtPar.Rows.Add(new object[] { "orifolder", filepath });
string packageType = isFolder ? "\\*" : "";
dtPar.Rows.Add(new object[] { "FolderOrFile", packageType });
setConfig setconfig = new Common.setConfig();
if (excludeFolderList != null && excludeFolderList.Count > 0)
{
FilePackage_setExcludeFolder(toolsFolder, toolsTempFolder, filepath, excludeFolderList);
dtPar.Rows.Add(new object[] { "excludeFolder", "-xr@" + toolsTempFolder + @"\7z_package_excludeFolder.txt" });
}
else
{
dtPar.Rows.Add(new object[] { "excludeFolder", "" });
}
if (excludeFileList != null && excludeFileList.Count > 0)
{
FilePackage_setExcludeFile(toolsFolder, toolsTempFolder, filepath, excludeFileList);
dtPar.Rows.Add(new object[] { "excludeFile", "-x@" + toolsTempFolder + @"\7z_package_excludeFile.txt" });
}
else
{
dtPar.Rows.Add(new object[] { "excludeFile", "" });
}
setconfig.repalceParByDefine(toolsFolder, "7z_package.bat", toolsTempFolder, dtPar);
setBAT.RunBat(toolsTempFolder + @"\7z_package.bat", true);
}
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++;
}
}
}
}
