基本信息
源码名称:自动备份数据库 windows 服务 源码
源码大小:0.19M
文件格式:.rar
开发语言:C#
更新时间:2014-03-20
友情提示:(无需注册或充值,赞助后即可获取资源下载链接)
嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 2 元×
微信扫码支付:2 元
×
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
源码介绍
因为是windows服务 所以最后要手动安装一下这个服务程序,在cmd窗口输入命令:InstallUnit BackupFileService.exe。
因为是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("服务还未开启!");
}
}
}
}