bas/bfhy/Sjkbf_Bf.aspx.cs

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

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

using System;
using System.Data.SqlClient;
using haoke365;

namespace hkpro.bas.bfhy
{
    public partial class Sjkbf_Bf : System.Web.UI.Page
    {
        mydb hkdb = new mydb();

        public static string sSaveName, sDbUrl, sUrl, sUser, sPwd, sName;
        public void Page_Load(object Sender, EventArgs E)
        {
            hkdb.VeriSess("4");

            //加载提示
            hkdb.PageWait();

            if (!IsPostBack)
            {
                hkdb.PassTo("60109", "0");

                if (Request.Cookies["haoke"].Values["sdate"].ToString() == "2001-01-01")
                {
                    Response.Write("<br>&nbsp;<img src=../../images/clock.gif></img><font size=2pt color=red>对不起。为确保其它用户的测试体验，试用环境下不能执行此操作 ！</font>");
                    Response.End();
                }

                SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_DbSet");
                if (datar1.Read())
                {
                    sSaveName = datar1["SaveName"].ToString();
                    sDbUrl = "" + sSaveName + "_" + System.DateTime.Now.Year.ToString() + "_" + System.DateTime.Now.Month.ToString() + "_" + System.DateTime.Now.Day.ToString() + "";
                    dburl.Text = "" + datar1["SavePath"].ToString() + "" + sSaveName + "_" + System.DateTime.Now.Year.ToString() + "_" + System.DateTime.Now.Month.ToString() + "_" + System.DateTime.Now.Day.ToString() + "";

                    sUrl = datar1["DbUrl"].ToString();
                    sUser = datar1["DbUser"].ToString();
                    sPwd = datar1["DbPwd"].ToString();
                    sName = datar1["DbName"].ToString();
                }
                datar1.Close();
            }
        }

        public void Save_Click(object Sender, EventArgs E)
        {
            try
            {
                SQLDMO.Backup backup = new SQLDMO.BackupClass();
                SQLDMO.SQLServer sqlserver = new SQLDMO.SQLServerClass();
                sqlserver.LoginSecure = false;
                sqlserver.Connect("" + sUrl + "", "" + sUser + "", "" + sPwd + "");    //连接
                backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
                backup.Database = "" + sName + "";                                        //数据库
                string str1 = this.dburl.Text;
                backup.Files = str1;                                                        //路径
                backup.BackupSetName = "" + sDbUrl + "";                                  //数据库名
                backup.BackupSetDescription = "数据库备份";
                backup.Initialize = true;
                backup.SQLBackup(sqlserver);