C#部署数据库及IIS站点
作者:airforce094 发布时间:2024-01-17 07:50:08
标签:C#,数据库,IIS
一、前言
最近忙里偷闲,做了一个部署数据库及IIS网站站点的WPF应用程序工具。
二、内容
此工具的目的是:
根据.sql文件在本机上部署数据库
在本机部署IIS站点,包括新建站点,新建应用程序池。只新建而不会对本机上原有的程序池或站点做修改操作
最终样式:(Check按钮的作用是防止与本机已有的站点或程序池有冲突)
View:
<Window x:Class="AutoWebTool.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
xmlns:local="clr-namespace:AutoWebTool"
Title="Web Site Automatic Deployment" Height="500" Width="800" WindowStartupLocation="CenterScreen" ResizeMode="NoResize">
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="0.5*"/>
<RowDefinition Height="0.5*"/>
<RowDefinition Height="Auto"/>
</Grid.RowDefinitions>
<GroupBox Header="DataBase Configuration" FontSize="15" BorderThickness="3" Margin="5,10" Grid.Row="0">
<Grid>
<Grid.RowDefinitions>
<RowDefinition/>
<RowDefinition/>
<RowDefinition/>
<RowDefinition/>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="65*"/>
<ColumnDefinition Width="133*"/>
<ColumnDefinition Width="Auto"/>
</Grid.ColumnDefinitions>
<TextBlock Grid.Row="0" Grid.Column="0" Text="Server Address" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="1" Grid.Column="0" Text="User" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="2" Grid.Column="0" Text="Password" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="3" Grid.Column="0" Text="Script Path" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBox Grid.Row="0" Grid.Column="1" Text="{Binding ServerAddress, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<TextBox Grid.Row="1" Grid.Column="1" Text="{Binding User, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<PasswordBox Grid.Row="2" Grid.Column="1" PasswordChar="*" local:PasswordBoxHelper.Password="{Binding Password, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32">
<i:Interaction.Behaviors>
<local:PasswordBoxBehavior />
</i:Interaction.Behaviors>
</PasswordBox>
<TextBox Grid.Row="3" Grid.Column="1" Text="{Binding SqlPath, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<Button Grid.Row="4" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Browse" Click="FilePathBrowse_Click"/>
</Grid>
</GroupBox>
<GroupBox Header="WebSite And Pool" FontSize="15" BorderThickness="3" Margin="5,10" Grid.Row="1">
<Grid>
<Grid.RowDefinitions>
<RowDefinition/>
<RowDefinition/>
<RowDefinition/>
<RowDefinition/>
<RowDefinition/>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="65*"/>
<ColumnDefinition Width="133*"/>
<ColumnDefinition Width="Auto"/>
</Grid.ColumnDefinitions>
<TextBlock Grid.Row="0" Grid.Column="0" Text="WebSite Name" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="1" Grid.Column="0" Text="WebSite ID" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="2" Grid.Column="0" Text="WebSite PhysicalPath" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="3" Grid.Column="0" Text="WebSite Port" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26" />
<TextBlock Grid.Row="4" Grid.Column="0" Text="Application Pool Name" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="15" Height="26"/>
<TextBox Grid.Row="0" Grid.Column="1" Text="{Binding WebSiteName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<TextBox Grid.Row="1" Grid.Column="1" Text="{Binding WebSiteID, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<TextBox Grid.Row="2" Grid.Column="1" Text="{Binding PhysicalPath, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<TextBox Grid.Row="3" Grid.Column="1" Text="{Binding WebSitePort, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<TextBox Grid.Row="4" Grid.Column="1" Text="{Binding PoolName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"
HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="15" Width="450" Height="32" />
<Button Grid.Row="0" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSiteNameCheck_Click"/>
<Button Grid.Row="1" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSiteIDCheck_Click"/>
<Button Grid.Row="2" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Browse" Click="PathBrowse_Click"/>
<Button Grid.Row="3" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSitePortCheck_Click"/>
<Button Grid.Row="4" Grid.Column="2" Width="70" Height="25" Margin="0,0,10,0"
HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="PoolNameCheck_Click"/>
</Grid>
</GroupBox>
<StackPanel Grid.Row="2" Orientation="Horizontal" HorizontalAlignment="Right" VerticalAlignment="Center" Margin="10">
<Button Width="70" Height="25" Content="OK" Click="Deploy_Click"/>
<Button Width="70" Height="25" Content="Cancel" Margin="10,0,0,0" Click="Close_Click"/>
</StackPanel>
</Grid>
</Window>
View的后台文件:
using System.Windows;
using System.Windows.Controls;
using System.Windows.Interactivity;
namespace AutoWebTool
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
private AutoGenerationVM _vm;
public MainWindow()
{
InitializeComponent();
DataContext = new AutoGenerationVM();
_vm = DataContext as AutoGenerationVM;
}
private bool sqlPath;
private void FilePathBrowse_Click(object sender, RoutedEventArgs e)
{
sqlPath = _vm.GetSqlFilePath();
}
private void WebSiteNameCheck_Click(object sender, RoutedEventArgs e)
{
var isInUse = _vm.CheckNameAndID();
if (isInUse)
{
MessageBox.Show("1.This name is Empty \r\n2.This name is in use,please change name!");
}
else
{
MessageBox.Show("No Problem!");
}
}
private void WebSiteIDCheck_Click(object sender, RoutedEventArgs e)
{
var isInUse = _vm.CheckNameAndID();
if (isInUse)
{
MessageBox.Show("1.This ID is Empty \r\n2.This ID is in use,please change ID!");
}
else
{
MessageBox.Show("No Problem!");
}
}
private bool physicalPath;
private void PathBrowse_Click(object sender, RoutedEventArgs e)
{
physicalPath = _vm.GetFolderPath();
}
private void WebSitePortCheck_Click(object sender, RoutedEventArgs e)
{
var isInUse = _vm.CheckWebPort();
if (isInUse)
{
MessageBox.Show("1.This port is Empty \r\n2.This port is in use,please change port!");
}
else
{
MessageBox.Show("No Problem!");
}
}
private void PoolNameCheck_Click(object sender, RoutedEventArgs e)
{
var isInUse = _vm.CkeckPoolName();
if (isInUse)
{
MessageBox.Show("1.This pool name is Empty \r\n2.This name is in use,please change name!");
}
else
{
MessageBox.Show("No Problem!");
}
}
private void Deploy_Click(object sender, RoutedEventArgs e)
{
var dataBaseServerAddressChecked = string.IsNullOrEmpty(_vm.ServerAddress);
var dataBaseUserChecked = string.IsNullOrEmpty(_vm.User);
var dataBasePasswordChecked = string.IsNullOrEmpty(_vm.Password);
var dataBaseScriptChecked = sqlPath;
var dataBaseCondition = !dataBaseServerAddressChecked && !dataBaseUserChecked && !dataBasePasswordChecked && !dataBaseScriptChecked;
var webSiteNameAndIDChecked = _vm.CheckNameAndID();
var webSitePortChecked = _vm.CheckWebPort();
var applicationPoolNameChecked = _vm.CkeckPoolName();
var webSiteCondition = !webSiteNameAndIDChecked && !physicalPath && !webSitePortChecked && !applicationPoolNameChecked;
if (dataBaseCondition&& webSiteCondition)
{
_vm.Execute();
}
else {
MessageBox.Show("Please Check Your Input!");
}
}
private void Close_Click(object sender, RoutedEventArgs e)
{
Close();
}
}
public static class PasswordBoxHelper
{
public static readonly DependencyProperty PasswordProperty =
DependencyProperty.RegisterAttached("Password",
typeof(string), typeof(PasswordBoxHelper),
new FrameworkPropertyMetadata(string.Empty, OnPasswordPropertyChanged));
private static void OnPasswordPropertyChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)
{
var passwordBox = sender as PasswordBox;
string password = (string)e.NewValue;
if (passwordBox != null && passwordBox.Password != password)
{
passwordBox.Password = password;
}
}
public static string GetPassword(DependencyObject dp)
{
return (string)dp.GetValue(PasswordProperty);
}
public static void SetPassword(DependencyObject dp, string value)
{
dp.SetValue(PasswordProperty, value);
}
}
public class PasswordBoxBehavior : Behavior<PasswordBox>
{
protected override void OnAttached()
{
base.OnAttached();
AssociatedObject.PasswordChanged += OnPasswordChanged;
}
private static void OnPasswordChanged(object sender, RoutedEventArgs e)
{
var passwordBox = sender as PasswordBox;
string password = PasswordBoxHelper.GetPassword(passwordBox);
if (passwordBox != null && passwordBox.Password != password)
{
PasswordBoxHelper.SetPassword(passwordBox, passwordBox.Password);
}
}
protected override void OnDetaching()
{
base.OnDetaching();
AssociatedObject.PasswordChanged -= OnPasswordChanged;
}
}
}
ViewModel:
using System;
using System.DirectoryServices;
using System.ComponentModel;
using System.Linq;
using System.Net;
using System.Net.NetworkInformation;
using Microsoft.Web.Administration;
using System.Windows.Forms;
using System.Diagnostics;
using System.Data.SqlClient;
using System.IO;
namespace AutoWebTool
{
public class AutoGenerationVM : INotifyPropertyChanged
{
public AutoGenerationVM()
{
_physicalPath = AppDomain.CurrentDomain.BaseDirectory;
}
//DataBase ServerAddress
private string _serverAddress = string.Empty;
public string ServerAddress
{
get { return _serverAddress; }
set
{
if (_serverAddress != value)
{
_serverAddress = value;
NotifyPropertyChanged("ServerAddress");
}
}
}
//DataBase User
private string _user = string.Empty;
public string User
{
get { return _user; }
set
{
if (_user != value)
{
_user = value;
NotifyPropertyChanged("User");
}
}
}
//DataBase Password
private string _password = string.Empty;
public string Password
{
get { return _password; }
set
{
if (_password != value)
{
_password = value;
NotifyPropertyChanged("Password");
}
}
}
//DataBase SQLPath
private string _sqlPath = string.Empty;
public string SqlPath
{
get { return _sqlPath; }
set
{
if (_sqlPath != value)
{
_sqlPath = value;
NotifyPropertyChanged("SqlPath");
}
}
}
public bool GetSqlFilePath() {
var openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "数据库脚本文件|*.sql";
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
SqlPath = openFileDialog.FileName;
}
return false;
}
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//WebSite Name
private string _webSiteName = string.Empty;
public string WebSiteName
{
get { return _webSiteName; }
set
{
if (_webSiteName != value)
{
_webSiteName = value;
NotifyPropertyChanged("WebSiteName");
}
}
}
//WebSite ID
private string _webSiteID = string.Empty;
public string WebSiteID
{
get { return _webSiteID; }
set
{
if (_webSiteID != value)
{
_webSiteID = value;
NotifyPropertyChanged("WebSiteID");
}
}
}
/// <summary>
/// Check WebSite Name and ID
/// </summary>
/// <returns></returns>
public bool CheckNameAndID()
{
if (string.IsNullOrEmpty(WebSiteName) || string.IsNullOrEmpty(WebSiteID)) return true;
DirectoryEntry rootEntry = new DirectoryEntry("IIS://localhost/w3svc");
foreach (DirectoryEntry entry in rootEntry.Children)
{
if (entry.SchemaClassName.Equals("IIsWebServer", StringComparison.OrdinalIgnoreCase))
{
if (WebSiteID == entry.Name) {
return true;
}
if (entry.Properties["ServerComment"].Value.ToString() == WebSiteName)
{
return true;
}
}
}
return false;
}
//Physical Path
private string _physicalPath = string.Empty;
public string PhysicalPath
{
get { return _physicalPath; }
set
{
if (_physicalPath != value)
{
_physicalPath = value;
NotifyPropertyChanged("PhysicalPath");
}
}
}
/// <summary>
/// Get Path for WebSite
/// </summary>
public bool GetFolderPath()
{
if (string.IsNullOrEmpty(PhysicalPath)) return true;
var openFolderDialog = new FolderBrowserDialog();
if (openFolderDialog.ShowDialog() == DialogResult.OK)
{
PhysicalPath = openFolderDialog.SelectedPath;
}
return false;
}
//WebSite Port
private string _webSitePort = string.Empty;
public string WebSitePort
{
get { return _webSitePort; }
set
{
if (_webSitePort != value)
{
_webSitePort = value;
NotifyPropertyChanged("WebSitePort");
}
}
}
/// <summary>
/// Check WebSite Port
/// </summary>
/// <returns></returns>
public bool CheckWebPort()
{
try
{
IPGlobalProperties ipProperties = IPGlobalProperties.GetIPGlobalProperties();
IPEndPoint[] ipEndPoints = ipProperties.GetActiveTcpListeners();
foreach (IPEndPoint endPoint in ipEndPoints)
{
if (endPoint.Port == Convert.ToInt32(WebSitePort))
{
return true;
}
}
return false;
}
catch {
return true;
}
}
//Pool Name
private string _poolName = string.Empty;
public string PoolName
{
get { return _poolName; }
set
{
if (_poolName != value)
{
_poolName = value;
NotifyPropertyChanged("PoolName");
}
}
}
/// <summary>
/// Check Application Pool Name
/// </summary>
/// <returns></returns>
public bool CkeckPoolName()
{
if (string.IsNullOrEmpty(PoolName)) return true;
var manager = new ServerManager();
var list = manager.ApplicationPools;
var matchedItem = list.FirstOrDefault(x => x.Name == PoolName);
if (matchedItem != null)
return true;
return false;
}
/// <summary>
/// Execute Script
/// </summary>
public void Execute()
{
//Deploy DataBase
var tmpConn = new SqlConnection();
tmpConn.ConnectionString = "SERVER = " + ServerAddress +"; DATABASE = master; User ID = " + User+ "; Pwd = " + Password+ ";";
var scriptFile = new FileInfo(SqlPath);
var sqlCreateDBQuery = scriptFile.OpenText().ReadToEnd();
SqlCommand myCommand = new SqlCommand(sqlCreateDBQuery, tmpConn);
try
{
tmpConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("Database has been created successfully!","Create Database", MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Create Database", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
tmpConn.Close();
}
try
{
//Deploy WebSite and Application Pool
var script = "net start w3svc " +
"& cd c:/Windows/System32/inetsrv " +
"& appcmd add site /name:" + WebSiteName + " /id:" + WebSiteID +
" /physicalPath:" + PhysicalPath + " /bindings:http/*:" + WebSitePort + ":" + WebSiteName +
" & appcmd add apppool /name:" + PoolName + " /managedRuntimeVersion:v4.0 /managedPipelineMode:Integrated" +
" & appcmd set site /site.name:" + WebSiteName + " /[path='/'].applicationPool:" + PoolName;
ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.WorkingDirectory = @"C:\Windows\System32";
startInfo.FileName = @"C:\Windows\System32\cmd.exe";
startInfo.RedirectStandardInput = true;
startInfo.RedirectStandardOutput = true;
startInfo.RedirectStandardError = true;
startInfo.UseShellExecute = false;
startInfo.Verb = "RunAs";
Process process = new Process();
process.StartInfo = startInfo;
process.Start();
process.StandardInput.WriteLine(script);
process.StandardInput.WriteLine("&exit");
process.StandardInput.Flush();
process.StandardInput.Close();
process.WaitForExit();
MessageBox.Show("IIS WebSite and Application Pool Deployed Successfully!", "Create WebSite and Application Pool", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public event PropertyChangedEventHandler PropertyChanged;
private void NotifyPropertyChanged(string name)
{
PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(name));
}
}
}
来源:https://www.cnblogs.com/lovecsharp094/archive/2018/03/21/8618139.html
0
投稿
猜你喜欢
- 无聊的人在无聊的时间做无聊的事打发自己,结果在无聊的事情中发现了IE对内联文字解释的一些疑惑。以下问题在FF2中没发现,而我也只
- Python在字符串格式化的两种方式%format%,关于整数的输出%o:oct 八进制%d:dec 十进制%x:hex 十六进制print
- Python的全局变量:int string, list, dic(map) 如果存在global就能够修改它的值。而不管这个global是
- win10 Python3.7安装keras深度学习集成包 TensorFlow 和Ubuntu下安装keras在win10下安装安装时必须
- 本文实例讲述了python基于BeautifulSoup实现抓取网页指定内容的方法。分享给大家供大家参考。具体实现方法如下:# _*_ co
- Microsoft建立了一种既灵活又强大的安全管理机制,它能够对用户访问SQL Server服务器系统和数据库的安全进行全面地管理。按照本文
- 背景我们经常调侃程序员每天都在写bug,这确实是事实,没有测出bug不代表程序就真的不存在问题。传统的代码review、静态分析、人工测试和
- 相信大家都遇到过这种情况,下载文件的时候遇到压缩包又没有密码,或者说自己设置的加密密码,但是忘记了,就很难受~但是~在Python程序员面前
- 假如你目前需要在Microsoft Access数据库中指示不存在数据,可以在“文本”或&l
- 本文实例为大家分享了python tkinter库实现气泡屏保和锁屏的具体代码,供大家参考,具体内容如下显示效果如下:代码: im
- 1. 关于箱线图 及 plt.boxplot()方法箱线图又称箱形图,有的地方也可以叫盒须图。使用箱线图的好处是可以以一种相对稳定的方式描述
- 尽管可能是个比较老的话题了,但是我还是从来没有整理过。今天在《精通HTML》一书中看到,这里整理一下。在XHTML中,<html>
- 如果要问做什么事是最有吸引力,那就是创建Web应用。Web设计者们对设计交互式的Web没有什么更好的办法,却对我们做桌面软件的同事投去少许羡
- newstudent.asp<script LANGUAGE=″vbscript″ RUNAT=″Server″&
- 要想在不宽裕的页面展现丰富的内容,现在通用的做法使用tab,在一块区域通过tab切换来更换该区域的内容。这篇文章分析了tab设计很在理,今天
- 用来制作甘特图的专业工具也不少,常见的有:Microsoft Office Project、GanttProject、WARCHART XG
- 我们可以通过python 来实现这样一个简单的爬虫猜密码功能。下面就看看如何使用python来实现这样一个功能。这里我们知道用户的昵称为:h
- 引言微信群的用户添加逻辑是 —— 当群人数达到100人后,用户无法再通过扫描群二维码加入,只能让用户先添加群内联系人微信,再由联系人把用户拉
- Splash是一个javascript渲染服务。它是一个带有HTTP API的轻量级Web浏览器,使用Twisted和QT5在Python
- 比如 <div><img .../></div>想通过对这个div设置透明度来达到调整图片的透明度如果不