一、前言

       最近忙里偷闲，做了一个部署数据库及IIS网站站点的WPF应用程序工具。

二、内容

       此工具的目的是：

  1. 根据.sql文件在本机上部署数据库
  2. 在本机部署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="" Width="" 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="" BorderThickness="" Margin="5,10" Grid.Row="">

            <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="" Grid.Column="" Text="Server Address" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="User" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="Password" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="Script Path" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding ServerAddress, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding User, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <PasswordBox Grid.Row="" Grid.Column="" PasswordChar="*" local:PasswordBoxHelper.Password="{Binding Password, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="">

                    <i:Interaction.Behaviors>

                        <local:PasswordBoxBehavior />

                    </i:Interaction.Behaviors>

                </PasswordBox>

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding SqlPath, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Browse" Click="FilePathBrowse_Click"/>

            </Grid>

        </GroupBox>

        <GroupBox Header="WebSite And Pool" FontSize="" BorderThickness="" Margin="5,10" Grid.Row="">

            <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="" Grid.Column="" Text="WebSite Name" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="WebSite ID" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="WebSite PhysicalPath" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="WebSite Port" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height="" />

                <TextBlock Grid.Row="" Grid.Column="" Text="Application Pool Name" HorizontalAlignment="Center" VerticalAlignment="Center" FontSize="" Height=""/>

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding WebSiteName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding WebSiteID, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding PhysicalPath, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding WebSitePort, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <TextBox Grid.Row="" Grid.Column="" Text="{Binding PoolName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}"

                     HorizontalAlignment="Left" VerticalAlignment="Center" FontSize="" Width="" Height="" />

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSiteNameCheck_Click"/>

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSiteIDCheck_Click"/>

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Browse" Click="PathBrowse_Click"/>

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="WebSitePortCheck_Click"/>

                <Button Grid.Row="" Grid.Column="" Width="" Height="" Margin="0,0,10,0"

                        HorizontalAlignment="Left" VerticalAlignment="Center" Content="Check" Click="PoolNameCheck_Click"/>

            </Grid>

        </GroupBox>

        <StackPanel Grid.Row="" Orientation="Horizontal" HorizontalAlignment="Right" VerticalAlignment="Center" Margin="">

            <Button Width="" Height="" Content="OK" Click="Deploy_Click"/>

            <Button Width="" Height="" 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));

        }

    }

}

最新文章

  1. ring3硬件断点
  2. Get和Post区别
  3. android 控件在不同状态下的内容样式与背景样式
  4. CentOS配置本地光盘yum源
  5. git remote 相关用法
  6. jmeter接口测试教程
  7. kuangbin_ShortPath R (HDU 4370)
  8. jQuery 工具类库集锦
  9. 下了个C-Free，结果点新建，出来的就是.cpp 怎么变成.c呢。。。他默认新建文件是c++的啊，
  10. C++的运算符
  11. hdu 2896 病毒侵袭 AC自动机 基础题
  12. 解决tomcat占用8080端口
  13. Roundabout for jQuery
  14. 使用IDA静态分析解密《舰娘Collection》的lua脚本
  15. UVa11212，Editing a Book
  16. LocalDate、LocalDateTime、LocalTime开发小结
  17. #Java学习之路——基础阶段（第九篇）
  18. 掌握PHP垃圾回收机制
  19. MySql中的事务、JDBC事务、事务隔离级别
  20. elment ui 图片上传遇到的一些问题

热门文章

  1. 人工智能AI芯片与Maker创意接轨 （中）
  2. 一个很NB的404页面
  3. sqli-labs学习笔记 DAY7
  4. Hands on Machine Learning with Sklearn and TensorFlow学习笔记——机器学习概览
  5. 11.15 Daily Scrum
  6. 爱码室Crawler &amp; classification module项目工作分配
  7. 第二阶段Sprint冲刺会议4
  8. DataTime日期格式化
  9. 四则运算&lt;C++&gt;
  10. Linux系统（X32）安装Oracle11g完整安装图文教程另附基本操作