manage/backups/Add_backups.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

 using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;
using System.Data.SqlClient;

public partial class Add_backups : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ((Label)Master.FindControl("titleMsg")).Text  = "添加备份";
        
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        //验证输入
        string err = "";

        if (txt_bfmc.Text == "")
        {
            err += "备份名称不能为空！\\n";
        }
       

        if (err != "")
        {
            MessageBox.Show(this, err);
            return;
        }

        string addr = DateTime.Now.ToString("yyyyMMddhhmmssfff") + ".bak";

        string sql = String.Format(@"use ordering; backup database ordering to disk='{0}'",
                                       Server.MapPath("~\\bakDb\\") + addr);

        SqlHelper.ExecuteNonQuery(sql);

        //设置添加sql
        StringBuilder strSql = new StringBuilder();
        strSql.Append(@"insert into Backups ( bfmc,bflj,bfsj ) ");
        strSql.Append(@" values (@bfmc,@bflj,@bfsj)");

        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@bfmc", SqlDbType.VarChar,50),
            new SqlParameter("@bflj", SqlDbType.VarChar,50),
            new SqlParameter("@bfsj", SqlDbType.DateTime,8)        };

        parameters[0].Value =txt_bfmc.Text;
        parameters[1].Value = addr;