国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > C# > 正文

C#部署數據庫及IIS站點

2019-10-29 21:03:16
字體:
來源:轉載
供稿:網友

一、前言

最近忙里偷閑,做了一個部署數據庫及IIS網站站點的WPF應用程序工具。 

二、內容

此工具的目的是:

  • 根據.sql文件在本機上部署數據庫
  • 在本機部署IIS站點,包括新建站點,新建應用程序池。只新建而不會對本機上原有的程序池或站點做修改操作

最終樣式:(Check按鈕的作用是防止與本機已有的站點或程序池有沖突)

C#,數據庫,IIS

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

以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持VEVB武林網。


注:相關教程知識閱讀請移步到c#教程頻道。
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 平原县| 衡水市| 德钦县| 菏泽市| 克拉玛依市| 白玉县| 沙河市| 离岛区| 云浮市| 翁牛特旗| 黔西县| 临澧县| 陆河县| 府谷县| 聂拉木县| 巴林右旗| 青河县| 攀枝花市| 巴楚县| 大悟县| 兴化市| 凉城县| 金乡县| 汝南县| 镇赉县| 聊城市| 长沙县| 上蔡县| 拉萨市| 玉溪市| 甘泉县| 景泰县| 宁夏| 镇安县| 浮梁县| 承德县| 静海县| 枣阳市| 彰化县| 奈曼旗| 淮安市|