快捷導(dǎo)航

C#控制臺(tái)程序?qū)崿F(xiàn)開(kāi)啟、關(guān)閉SQLServer服務(wù)的代碼分享

更新時(shí)間：2014年05月08日 11:47:28 作者：

這篇文章主要介紹了C#控制臺(tái)程序?qū)崿F(xiàn)開(kāi)啟、關(guān)閉SQLServer服務(wù)的代碼分享,需要的朋友可以參考下

用了近一天的時(shí)間研究了C#如何開(kāi)啟SqlServer數(shù)據(jù)庫(kù)的服務(wù),起先應(yīng)用的是C#自帶的System.ServiceProcess.ServiceContorller類,但個(gè)人認(rèn)為它在win7下效果不佳,或許由于個(gè)人系統(tǒng)問(wèn)題,最終決定放棄去選擇應(yīng)用C#的system.diagnostice.process.start方法執(zhí)行cmd指令,下面我示范開(kāi)啟SqlServer最具代表的兩個(gè)服務(wù)mssqlserver與mssqlserveragent,下面是本人練習(xí)寫(xiě)的控制臺(tái)下的代碼,經(jīng)由多次測(cè)試均可成功

復(fù)制代碼代碼如下:

using System;
using System.Collections.Generic;
using System.Management;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            while (1 == 1)
            { 
                Console.Write('\n\n 可選操作 : \n\n 1.啟動(dòng)數(shù)據(jù)庫(kù)服務(wù) 2.停止數(shù)據(jù)庫(kù)服務(wù) \n\n 開(kāi)始執(zhí)行 : ');
                string strQueryState = Console.ReadLine();
                if (strQueryState.Trim() == '1')
                {
                    string strFilePath = GetFilePath('Start');
                    System.IO.File.AppendAllText(strFilePath, GetCmdStr('start'), System.Text.Encoding.GetEncoding('gb2312'));
                    System.Diagnostics.Process.Start(strFilePath);
                }
                else if (strQueryState.Trim() == '2')
                {
                    string strFilePath = GetFilePath('Stop');
                    System.IO.File.AppendAllText(strFilePath, GetCmdStr('stop'), System.Text.Encoding.GetEncoding('gb2312'));
                    System.Diagnostics.Process.Start(strFilePath);
                }
            }

        }

        /// <summary>
        /// 操作所需的Cmd指令
        /// </summary>
        /// <param name='StateStr'>操作</param>
        /// <returns>Cmd指令</returns>
        private static string GetCmdStr(string StateStr)
        {
            string cmdStr = '';
            if (StateStr.ToLower().Trim() == 'start')
            {
                cmdStr = @'@echo. & del %0 & @echo off & @echo.正在啟動(dòng)服務(wù) MSSQLSERVER and MSSQLSERVERAGENT ...... & '
                        + '@echo. & @net start MSSQLSERVER & @net start SQLSERVERAGENT & @echo.服務(wù)啟動(dòng)完畢!';
            }
            else if (StateStr.ToLower().Trim() == 'stop')
            {
                cmdStr = @'@echo. & del %0 & @echo off & @echo.正在停止服務(wù) MSSQLSERVER and MSSQLSERVERAGENT ...... & '
                        + '@echo. & @net stop sqlserveragent &  @net stop mssqlserver & @echo.服務(wù)停止完畢!';
            }
            return cmdStr;
        }

        /// <summary>
        /// 獲取一個(gè)文件是否存在于磁盤
        /// </summary>
        /// <param name='PathStr'>文件名稱</param>
        /// <returns>返回可創(chuàng)建文件路徑</returns>
        private static string GetFilePath(string strFileName)
        {
            string strTem = '';//用于存儲(chǔ)要保存文件路徑
            string[] strPath = new string[] {@'C:\\',@'D:\\',@'E:\\',@'F:\\'};//檢測(cè)的盤符
            strFileName += DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString()
                + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString().Trim()+'.cmd';//為防止重復(fù)為文件重新命名

            foreach (string pathStr in strPath)//循環(huán)判斷文件目錄存在性
            {
                if (!System.IO.Directory.Exists(pathStr))//判斷目錄存在
                {
                    continue;
                }
                else
                {
                    if (System.IO.File.Exists(pathStr + strFileName))//判斷文件存在
                    {
                        continue;
                    }
                    else
                    {
                        strTem = pathStr + strFileName;
                        break;
                    }
                }
            }
            return strTem;//返回可建文件路徑
        }
    }
}