1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using SqlHelper;
11using System.IO;
12using System.Net;
13
14public partial class DBBackup : System.Web.UI.Page
15...{
16    Helper he = new Helper();
17
18    protected void Page_Load(object sender, EventArgs e)
19    ...{
20        if (!IsPostBack)
21        ...{
22            if (he.IsAdmin(Session["username"].ToString()))
23            ...{
24                ;
25            }
26            else
27            ...{
28                Response.Write("<script>window.showModalDialog('IsAdmin.aspx','','resizable:yes;scroll:yes;status:no;dialogWidth=320px;dialogHeight=230px;center=yes;help=no');</script>");
29
30                Panel1.Visible = false;
31
32                return;
33            }
34        }
35    }
36    protected void BtnBackup_Click(object sender, EventArgs e)
37    ...{
38        Back back = new Back();
39
40        DateTime startTime = System.DateTime.Now;
41        DateTime endTime = System.DateTime.Now;
42
43        // 根据 ProgressBar.htm 显示进度条界面
44        string templateFileName = Path.Combine(Server.MapPath("."), "ProgressBar.htm");
45        StreamReader reader = new StreamReader(@templateFileName, System.Text.Encoding.GetEncoding("gb2312"));
46        string html = reader.ReadToEnd();
47        reader.Close();
48        Response.Write(html);
49        Response.Flush();
50        System.Threading.Thread.Sleep(1000);
51
52        string jsBlock;
53        // 处理完成
54        jsBlock = "<script>BeginTrans('开始处理...');</script>";
55        Response.Write(jsBlock);
56        Response.Flush();
57
58        System.Threading.Thread.Sleep(1000);
59
60        back.Backup();//开始备份数据库
61
62        // 根据处理任务处理情况更新进度条
63        for (int i = 1; i <= 100; i++)
64        ...{
65            System.Threading.Thread.Sleep(20);
66            jsBlock = "<script>SetPorgressBar('" + "数据库备份" + i.ToString() + "','" + i.ToString() + "');</script>";
67            Response.Write(jsBlock);
68            Response.Flush();
69        }
70
71        // 处理完成
72        jsBlock = "<script>EndTrans('数据库备份完毕。');</script>";
73        Response.Write(jsBlock);
74        Response.Flush();
75
76        // 用时
77        endTime = DateTime.Now;
78        jsBlock = "<script>SetTimeInfo('用时" + GetTimeSpan(startTime, endTime) + "');</script>";
79        Response.Write(jsBlock);
80        Response.Flush();
81    }
82    protected string GetTimeSpan(DateTime startTime, DateTime endTime)
83    ...{
84        string timeSpan = string.Empty;
85        TimeSpan ts = endTime - startTime;
86        if (ts.Days > 0)
87            timeSpan += ts.Days.ToString() + "天";
88        if (ts.Hours > 0)
89            timeSpan += ts.Hours.ToString() + "小时";
90        if (ts.Minutes > 0)
91            timeSpan += ts.Minutes.ToString() + "分钟";
92        if (ts.Seconds > 0)
93            timeSpan += ts.Seconds.ToString() + "秒";
94        return timeSpan;
95    }
96}
97