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);
}
}
}
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);
}
}
}
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());
}