基本信息
源码名称:自动备份数据库 windows 服务 源码
源码大小:0.19M
文件格式:.rar
开发语言:C#
更新时间:2014-03-20
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300

本次赞助数额为: 2 元 
   源码介绍
因为是windows服务 所以最后要手动安装一下这个服务程序,在cmd窗口输入命令:InstallUnit BackupFileService.exe。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using FX.CADA.Common;
using System.Threading;
using System.Diagnostics;
using BackupFileConfig;
using System.ServiceProcess;

namespace BackupFile
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void btnCompleteConfig_Click(object sender, EventArgs e)
        {
            if (!ValidateInput())
            {
                return;
            }
            //先保存界面上输入的配置参数
            ParameterConfig config = new ParameterConfig();
            config.ExcuteTime = Convert.ToDateTime(txtBackupTime.Text);
            config.FileServerIp = txtFileServerIp.Text.ToString();
            config.UserName = txtUserName.Text.ToString();
            config.Pwd = txtPwd.Text.ToString();
            config.FileSource = txtFileSource.Text.ToString();
            config.FileBackupPath = txtFileBackupPath.Text.ToString();
            config.DbUserName = txtDbUserName.Text.ToString();
            config.DbPwd = txtDbPwd.Text.ToString();
            config.DbServerName = txtDbServerName.Text.ToString();
            config.DbBackupPath = txtDbBackupPath.Text.ToString();
            //判断源路径是否存在
            if (!Directory.Exists(txtFileSource.Text))
            {
                MessageBox.Show("影像文件路径不存在,请输入正确的影像文件路径!");
                return;
            }
            //判断目标路径是否存在
            if (!Directory.Exists(txtFileBackupPath.Text))
            {
                Directory.CreateDirectory(txtFileBackupPath.Text);
            }
            //是否开起共享
            if (Connect.connect(txtFileServerIp.Text.ToString(), txtUserName.Text.ToString(), txtPwd.Text.ToString()))
            {
            //保存到配置文件中
            ConfigLoader.Instance.SaveParameterConfig(config);
            MessageBox.Show("保存设置成功,已开启服务!");
            RestartService();
            }
            else
            {
                MessageBox.Show("文件服务器与备份服务器连接不上,请检查!");
                return;
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //读取配置文件里面的信息
            ParameterConfig config = ConfigLoader.Instance.ParameterConfig;
            txtBackupTime.Text = config.ExcuteTime.ToString("HH:mm");
            txtFileServerIp.Text = config.FileServerIp.ToString();
            txtUserName.Text = config.UserName.ToString();
            txtPwd.Text = config.Pwd.ToString();
            txtFileSource.Text = config.FileSource.ToString();
            txtFileBackupPath.Text = config.FileBackupPath.ToString();
            txtDbUserName.Text = config.DbUserName.ToString();
            txtDbPwd.Text = config.DbPwd.ToString();
            txtDbServerName.Text = config.DbServerName.ToString();
            txtDbBackupPath.Text = config.DbBackupPath.ToString();
        }
        /// <summary>
        /// 验证
        /// </summary>
        /// <returns></returns>
        private bool ValidateInput()
        {
            if (string.IsNullOrEmpty(txtBackupTime.Text.ToString()))
            {
                MessageBox.Show("时间不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtFileServerIp.Text.ToString()))
            {
                MessageBox.Show("文件服务器IP不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtUserName.Text.ToString()))
            {
                MessageBox.Show("文件服务器登录帐号不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtPwd.Text.ToString()))
            {
                MessageBox.Show("文件服务器密码不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtFileSource.Text.ToString()))
            {
                MessageBox.Show("文件源路径不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtFileBackupPath.Text.ToString()))
            {
                MessageBox.Show("文件备份路径不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtDbUserName.Text.ToString()))
            {
                MessageBox.Show("数据库登录名不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtDbPwd.Text.ToString()))
            {
                MessageBox.Show("数据库密码不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtDbServerName.Text.ToString()))
            {
                MessageBox.Show("数据库服务名不能为空!");
                return false;
            }
            if (string.IsNullOrEmpty(txtDbBackupPath.Text.ToString()))
            {
                MessageBox.Show("数据库备份路径不能为空!");
                return false;
            }
            return true;
        }
        /// <summary>
        /// 重启服务
        /// </summary>
        private void RestartService()
        {
            //然后再重启服务
            ServiceController service = new ServiceController("BakSvrInstaller");
            try
            {
                if (service.Status == ServiceControllerStatus.Running)
                {
                    service.Stop();
                    service.WaitForStatus(ServiceControllerStatus.Stopped);
                }
                service.Start();
                service.WaitForStatus(ServiceControllerStatus.Running);
            }
            catch (Exception)
            {
            }
        }
        /// <summary>
        /// 备份文件
        /// </summary>
        /// <param name="source">文件源路径</param>
        /// <param name="backupPath">文件备份路径</param>
        private void BackupFile(string source, string backupPath)
        {
            //判断源路径是否存在
            if (!Directory.Exists(source))
            {
                return;
            }
            //判断目标路径是否存在
            if (!Directory.Exists(backupPath))
            {
                Directory.CreateDirectory(backupPath);
            }
            //进行copy操作
            CopyDirectoryHelper _Info = new CopyDirectoryHelper(source, backupPath);
            _Info.StarCopy();
        }

        private void btnStopService_Click(object sender, EventArgs e)
        {
            ServiceController service = new ServiceController("BakSvrInstaller");
            if (service.Status == ServiceControllerStatus.Running)
            {
                service.Stop();
                service.WaitForStatus(ServiceControllerStatus.Stopped);
                MessageBox.Show("服务已停止!");
            }
            else
            {
                MessageBox.Show("服务还未开启!");
            }
        }
    }
}