sms_backup.cs

库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace FORU_SMS_
{
    public partial class SMS_BackUp : Form
    {
        BaseClass.DataConn Dconn = new FORU_SMS_.BaseClass.DataConn();
        BaseClass.DataClass Dclass = new FORU_SMS_.BaseClass.DataClass();

        public SMS_BackUp()
        {
            InitializeComponent();
        }

        private void btnSel_Click(object sender, EventArgs e)
        {
            folderBrowserDialog.ShowDialog();
            this.txtDSPath.Text = folderBrowserDialog.SelectedPath.ToString().Trim() + "\\";
        }

        private void btnDStore_Click(object sender, EventArgs e)
        {
            if (this.txtDSPath.Text.Trim() == "")
            {
                MessageBox.Show("请选择要备份的文件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                try
                {
                    if (File.Exists(this.txtDSPath.Text.Trim() + ".bak"))
                    {
                        MessageBox.Show("该文件已存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        Dclass.ExecuteSql("use master;backup database FORUSMS to disk='" + this.txtDSPath.Text.Trim() + ".bak'");
                        MessageBox.Show("备份成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}