Esempio n. 1
0
        private void btnUpgrade_Click(object sender, EventArgs e)
        {
            // Button will become to be "Close" after deployment is done.
            if (this.btnUpgrade.Text == "关闭") {
                Application.Exit();
                return;
            }

            StartSqlServer();
            try {
                var appPath = ConfigurationManager.AppSettings["AppPath"];
                if (!Directory.Exists(appPath)) {
                    MessageBox.Show("报表系统的安装路径不存在:\r\n" + appPath, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                var binPath = Path.Combine(appPath, "Bin");
                var dbPath = Path.Combine(appPath, "Database");
                var upgradePath = System.Environment.CurrentDirectory;
                var dbScript = Path.Combine(upgradePath, "Scripts");
                var backupPath = Path.Combine(appPath, "Backup", DateTime.Now.ToString("yyMMddHHmmss"));

                if (Directory.Exists(dbScript)) { // Upgrade db with existing data reserved
                    if (MessageBox.Show(string.Format("请确认报表系统没在运行,然后选择【确定】开始{0}的升级。", this.lblVersionText.Text), this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) {
                        return;
                    }
                    // Update db schema or data
                    Process process = new Process();
                    process.StartInfo.FileName = "cmd";
                    process.StartInfo.Arguments = string.Format("/k cd {0} && run.bat", dbScript);
                    process.Start();
                    process.WaitForExit();
                    process.Close();

                    // Replace bin files
                    if (Directory.Exists(Path.Combine(upgradePath, "bin"))) {
                        process.StartInfo.FileName = "cmd";
                        process.StartInfo.Arguments = string.Format("/k xcopy /E /Y \"{0}\" \"{1}\"&&exit", Path.Combine(upgradePath, "bin"), binPath);
                        process.Start();
                        process.WaitForExit();
                        process.Close();
                    }

                    MessageBox.Show("升级完毕", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else { // Re-deploy and a new db will be created.
                    if (MessageBox.Show(string.Format("请确认报表系统没在运行,然后选择【确定】开始部署{0}。", this.lblVersionText.Text), this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) {
                        return;
                    }
                    // Backups
                    DetachDB();
                    if (Directory.Exists(dbPath)) {
                        if (!Directory.Exists(backupPath)) {
                            Directory.CreateDirectory(backupPath);
                        }
                        Directory.Move(dbPath, Path.Combine(backupPath, "Database"));
                    }
                    if (Directory.Exists(binPath)) {
                        if (!Directory.Exists(backupPath)) {
                            Directory.CreateDirectory(backupPath);
                        }
                        Directory.Move(binPath, Path.Combine(backupPath, "Bin"));
                    }

                    // Create new db
                    var dbPathInfo = Directory.CreateDirectory(dbPath);
                    var dataFilePath = Path.Combine(dbPath, "YuLin.mdf");
                    var logFilePath = Path.Combine(dbPath, "YuLin_log.ldf");
                    File.Copy(Path.Combine(upgradePath, @"database\YuLin.mdf"), dataFilePath, true);
                    File.Copy(Path.Combine(upgradePath, @"database\YuLin_log.ldf"), logFilePath, true);
                    var dao = new SqlDbHelper(ConfigurationManager.ConnectionStrings["master"].ConnectionString);
                    dao.ExecuteNonQuery(string.Format("CREATE DATABASE YuLin ON (FILENAME='{0}'), (FILENAME='{1}') FOR ATTACH", dataFilePath, logFilePath));

                    // Create new bin
                    Directory.CreateDirectory(binPath);
                    Process process = new Process();
                    process.StartInfo.FileName = "cmd";
                    process.StartInfo.Arguments = string.Format("/k xcopy /E \"{0}\" \"{1}\"&&exit", Path.Combine(upgradePath, "bin"), binPath);
                    process.Start();
                    process.WaitForExit();
                    process.Close();

                    MessageBox.Show("部署完毕", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                }

                this.btnUpgrade.Text = "关闭";
            }
            catch (Exception ex) {
                if (ex.Message.IndexOf("Operating system error 5") > 0) {
                    MessageBox.Show("无权限挂载数据库,请把SQL Server服务的启动帐号加入系统管理员用户群组,然后重启该服务。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else {
                    MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Esempio n. 2
0
		private void btnUpgrade_Click(object sender, EventArgs e) {
			// Button will become to be "Close" after deployment is done.
			if (this.btnUpgrade.Text == "关闭") {
				Application.Exit();
				return;
			}

			//StartSqlServer(); 1. May not deploy on the db server. 2. May not update db (only *.dll files)
			try {
				var appPath = ConfigurationManager.AppSettings["AppPath"];
				if (!Directory.Exists(appPath)) {
					MessageBox.Show("报表系统的安装路径不存在:\r\n" + appPath, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
					return;
				}
				var binPath = Path.Combine(appPath, "Bin");
				var dbPath = Path.Combine(appPath, "Database");
				var upgradePath = System.Environment.CurrentDirectory;
				var dbScript = Path.Combine(upgradePath, "Scripts");
				var backupPath = Path.Combine(appPath, "Backup", DateTime.Now.ToString("yyMMddHHmmss"));

				if (!IsInstall()) { // Upgrade db with existing data reserved
					if (MessageBox.Show(string.Format("请确认报表系统没在运行,然后选择【确定】开始{0}的升级。", this.lblVersionText.Text), this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) {
						return;
					}
					// Update db schema or data
					if (Directory.Exists(Path.Combine(upgradePath, "Scripts"))) {
						Process process = new Process();
						process.StartInfo.FileName = "cmd";
						process.StartInfo.Arguments = string.Format("/k cd {0} && run.bat", dbScript);
						process.Start();
						process.WaitForExit();
						process.Close();
					}

					// Replace bin files
					if (Directory.Exists(Path.Combine(upgradePath, "bin"))) {
						Process process = new Process();
						process.StartInfo.FileName = "cmd";
						process.StartInfo.Arguments = string.Format("/k xcopy /E /Y \"{0}\" \"{1}\"&&exit", Path.Combine(upgradePath, "bin"), binPath);
						process.Start();
						process.WaitForExit();
						process.Close();
					}

					MessageBox.Show("升级完毕", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
				}
				else { // Re-deploy and a new db will be created.
					if (MessageBox.Show(string.Format("请确认报表系统没在运行,然后选择【确定】开始部署{0}。", this.lblVersionText.Text), this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) {
						return;
					}
					// Backups
					DetachDB();
					if (Directory.Exists(dbPath)) {
						if (!Directory.Exists(backupPath)) {
							Directory.CreateDirectory(backupPath);
						}
						Directory.Move(dbPath, Path.Combine(backupPath, "Database"));
					}
					if (Directory.Exists(binPath)) {
						if (!Directory.Exists(backupPath)) {
							Directory.CreateDirectory(backupPath);
						}
						Directory.Move(binPath, Path.Combine(backupPath, "Bin"));
					}

					// Create new db
					var dbPathInfo = Directory.CreateDirectory(dbPath);
					var dataFilePath = Path.Combine(dbPath, "YuLin.mdf");
					var logFilePath = Path.Combine(dbPath, "YuLin_log.ldf");
					File.Copy(Path.Combine(upgradePath, @"database\YuLin.mdf"), dataFilePath, true);
					File.Copy(Path.Combine(upgradePath, @"database\YuLin_log.ldf"), logFilePath, true);
					var dao = new SqlDbHelper(ConfigurationManager.ConnectionStrings["master"].ConnectionString);
					dao.ExecuteNonQuery(string.Format("CREATE DATABASE YuLin ON (FILENAME='{0}'), (FILENAME='{1}') FOR ATTACH", dataFilePath, logFilePath));

					// Create new bin
					Directory.CreateDirectory(binPath);
					Process process = new Process();
					process.StartInfo.FileName = "cmd";
					process.StartInfo.Arguments = string.Format("/k xcopy /E \"{0}\" \"{1}\"&&exit", Path.Combine(upgradePath, "bin"), binPath);
					process.Start();
					process.WaitForExit();
					process.Close();

					MessageBox.Show("部署完毕", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
				}

				this.btnUpgrade.Text = "关闭";
			}
			catch (Exception ex) {
				if (ex.Message.IndexOf("Operating system error 5") > 0) {
					MessageBox.Show("无权限挂载数据库,请把SQL Server服务的启动帐号加入系统管理员用户群组,然后重启该服务。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
				else {
					MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
				}
			}
		}
Esempio n. 3
0
 private void DetachDB()
 {
     var dao = new SqlDbHelper(ConfigurationManager.ConnectionStrings["master"].ConnectionString);
     var table = dao.ExecuteDataTable("select spid from sys.sysprocesses where dbid = DB_ID('YuLin')");
     foreach (var row in table.Rows) {
         dao.ExecuteNonQuery("kill " + ((DataRow) row)[0]);
     }
     var sql = new StringBuilder();
     sql.AppendLine("IF DB_ID('YuLin') IS NOT NULL BEGIN");
     sql.AppendLine("	EXEC sp_detach_db 'YuLin'");
     sql.AppendLine("END");
     dao.ExecuteNonQuery(sql.ToString());
 }