private void btnYes_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textServerIp.Text)) { System.Windows.Forms.MessageBox.Show(this, "数据库IP地址不能为空"); return; } if (rdbWindowsServer.Checked == false && rdbDeskttopClient.Checked == false) { System.Windows.Forms.MessageBox.Show(this, "请选择一种启动方式"); return; } AppConfigurator.UpdateAppConfig("DatabaseServerIP", textServerIp.Text.Trim()); AppConfigurator.UpdateAppConfig("DatabaseUser", textUser.Text.Trim()); AppConfigurator.UpdateAppConfig("DatabasePwd", textPwd.Text.Trim()); if (rdbWindowsServer.Checked) { //windows服务模式 //进入服务设置UI 安装\卸载 启动\停止 服务设置 切换为桌面客户端等 this.Hide(); FrmServiceSetup dlg = new FrmServiceSetup(); dlg.ShowDialog(); Close(); //整个程序退出 } else { SingletonInfo.GetInstance().SqlServerIP = textServerIp.Text.Trim(); SingletonInfo.GetInstance().SqlServerUser = textUser.Text.Trim(); SingletonInfo.GetInstance().SqlServerPWD = textPwd.Text.Trim(); //桌面客户端模式 this.Hide(); FormMain dlg = new FormMain(); dlg.ShowDialog(); Close(); } }
private void StartForm_Load(object sender, EventArgs e) { textServerIp.Text = AppConfigurator.GetAppConfig("DatabaseServerIP"); textUser.Text = AppConfigurator.GetAppConfig("DatabaseUser"); textPwd.Text = AppConfigurator.GetAppConfig("DatabasePwd"); SingletonInfo.GetInstance().SqlServerIP = textServerIp.Text.Trim(); SingletonInfo.GetInstance().SqlServerUser = textUser.Text.Trim(); SingletonInfo.GetInstance().SqlServerPWD = textPwd.Text.Trim(); if (IsServerAlreadyExisted()) { //进入服务设置UI 安装\卸载 启动\停止 服务设置 切换为桌面客户端等 this.Hide(); FrmServiceSetup dlg = new FrmServiceSetup(); dlg.ShowDialog(); Close(); //整个程序退出 } else { //进入选择模式UI 选择程序启动模式 windows服务 或者 桌面客户端 } }
/// <summary> /// sqlite中 数据库连接信息设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void UpdateSqlConnection() { try { string strPath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase; AppConfigurator.UpdateConnectionStringsConfig("SqliteConn", "Data Source=" + strPath + "module-config.sqlite", "Dos.ORM.Sqlite", strPath + "MixManagementService.exe"); string sql = "SELECT * FROM SQLServerInfo"; string connStr = @"Data Source=" + strPath + @"module-config.sqlite;Initial Catalog=sqlite;Integrated Security=True;Max Pool Size=10"; using (SQLiteConnection conn = new SQLiteConnection(connStr)) { conn.Open(); using (SQLiteDataAdapter ap = new SQLiteDataAdapter(sql, conn)) { DataSet ds = new DataSet(); ap.Fill(ds); DataTable dt = ds.Tables[0]; string sql_ = ""; if (dt.Rows.Count > 0) { //更新 sql_ = string.Format("update SQLServerInfo set IP='{0}',USER='******',PWD='{2}' WHERE id=1", SingletonInfo.GetInstance().SqlServerIP, SingletonInfo.GetInstance().SqlServerUser, SingletonInfo.GetInstance().SqlServerPWD); } else { //插入 sql_ = string.Format("INSERT INTO SQLServerInfo (id,IP,USER,PWD) values ({0},{1},{2},{3})", "1", SingletonInfo.GetInstance().SqlServerIP, SingletonInfo.GetInstance().SqlServerUser, SingletonInfo.GetInstance().SqlServerPWD); } using (SQLiteCommand command = new SQLiteCommand(sql_, conn)) { command.ExecuteNonQuery(); } } conn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }