using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?System.Data.Sql;
using?System.Windows.Forms;

namespace?數(shù)據(jù)庫備份還原工具
{
????public?class?Data
????{

????????public?static?SqlConnection?Conn;
????????///?

????????///?現(xiàn)在邏輯名
????????///?

????????public?static?string[]?drname=new?string[2];
????????///?

????????///?備份文件邏輯名
????????///?

????????public?static?string[]?drnameF?=?new?string[2];
????????///?

????????///?數(shù)據(jù)路徑名
????????///?

????????public?static?string[]?drfilename?=?new?string[2];

????????#region?生成SQL連接語句（數(shù)據(jù)庫地址數(shù)據(jù)庫名稱數(shù)據(jù)庫帳號數(shù)據(jù)庫密碼驗(yàn)證方式）
????????///?

????????///?生成SQL連接語句
????????///?

????????///?數(shù)據(jù)庫地址
????????///?數(shù)據(jù)庫名稱
????????///?數(shù)據(jù)庫帳號
????????///?數(shù)據(jù)庫密碼
????????///?驗(yàn)證方式
????????public?static?string?shengchengSQLstring（string?shujukudizhi?string?shujukumingcheng?string?shujukuzhanghao?string?shujukumima?bool?yanzhengfangshi）
????????{
????????????string?SQLstring;
????????????try
????????????{
????????????????if?（yanzhengfangshi?==?true）
????????????????{
????????????????????SQLstring?=?@“Data?Source=“?+?shujukudizhi?+?@“;Initial?Catalog=“?+?shujukumingcheng?+?@“;Integrated?Security=SSPI“;
????????????????????return?SQLstring;
????????????????}
????????????????else
????????????????{
????????????????????SQLstring?=?@“Data?Source=“?+?shujukudizhi?+?@“;Initial?Catalog=“?+?shujukumingcheng?+?@“;User?ID=“?+?shujukuzhanghao?+?“;Pwd=“?+?shujukumima;
????????????????????return?SQLstring;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
?????????????????MessageBox.Show（ex.Message?“生成SQL連接語句失敗“）;
????????????????return?null;
????????????}
????????}
????????#endregion

????????#region?獲取數(shù)據(jù)庫名稱數(shù)據(jù)源
????????///?

????????///?獲取數(shù)據(jù)庫名稱數(shù)據(jù)源
????????///?

????????///?
????????///?
????????///?
????????public?static?SqlDataReader?Get_Data（string?SQLstring?string?SQLchaxun）
????????{
????????????try
????????????{
????????????????Conn?=?new?SqlConnection（SQLstring）;
????????????????SqlCommand?cmd?=?new?SqlCommand（SQLchaxun?Conn）;
????????????????Conn.Open（）;
????????????????SqlDataReader?dr?=?cmd.ExecuteReader（）;
????????????????//Conn.Close（）;
????????????????return?dr;
????????????}
????????????catch（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message）;
????????????????return?null;
????????????}
????????}
????????#endregion

????????#region?時間生成ID
????????public?static?string?ID（）
????????{
????????????try
????????????{
????????????????Int64?idnum?=?0;
????????????????idnum?+=?（Convert.ToInt64（D

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3806??2012-08-16?00:13??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\數(shù)據(jù)庫備份還原工具.csproj.FileListAbsolute.txt

?????文件??????31232??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)bin\Debug\數(shù)據(jù)庫備份還原工具.exe

?????文件??????31232??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\數(shù)據(jù)庫備份還原工具.exe

?????文件??????11608??2012-08-16?00:13??數(shù)據(jù)庫備份還原工具\(yùn)bin\Debug\數(shù)據(jù)庫備份還原工具.vshost.exe

?????文件???????5476??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1523??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)Properties\AssemblyInfo.cs

?????文件???????6708??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)Data.cs

?????文件??????14650??2012-08-16?00:20??數(shù)據(jù)庫備份還原工具\(yùn)Main.cs

?????文件??????30800??2012-08-15?00:40??數(shù)據(jù)庫備份還原工具\(yùn)Main.Designer.cs

?????文件????????487??2012-08-12?16:28??數(shù)據(jù)庫備份還原工具\(yùn)Program.cs

?????文件???????2904??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具\(yùn)Properties\Resources.Designer.cs

?????文件???????1112??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具\(yùn)Properties\Settings.Designer.cs

?????文件???????3652??2012-08-12?17:24??數(shù)據(jù)庫備份還原工具\(yùn)數(shù)據(jù)庫備份還原工具.csproj

?????文件???????2238??2012-08-12?16:24??數(shù)據(jù)庫備份還原工具\(yùn)favicon.ico

?????文件????????490??2010-03-17?22:39??數(shù)據(jù)庫備份還原工具\(yùn)bin\Debug\數(shù)據(jù)庫備份還原工具.vshost.exe.manifest

?????文件??????54784??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)bin\Debug\數(shù)據(jù)庫備份還原工具.pdb

?????文件??????54784??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\數(shù)據(jù)庫備份還原工具.pdb

?????文件???????2804??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\數(shù)據(jù)庫備份還原工具.Main.resources

?????文件????????180??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\數(shù)據(jù)庫備份還原工具.Properties.Resources.resources

?????文件???????9477??2012-08-15?00:40??數(shù)據(jù)庫備份還原工具\(yùn)Main.resx

?????文件???????5612??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具\(yùn)Properties\Resources.resx

?????文件????????249??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具\(yùn)Properties\Settings.settings

?????文件????????923??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具.sln

????..A..H.?????20992??2012-08-16?01:43??數(shù)據(jù)庫備份還原工具.suo

?????文件????????802??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\GenerateResource-ResGen.read.1.tlog

?????文件????????854??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\GenerateResource-ResGen.write.1.tlog

?????目錄??????????0??2012-08-12?15:50??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug\TempPE

?????目錄??????????0??2012-08-16?00:31??數(shù)據(jù)庫備份還原工具\(yùn)obj\x86\Debug

?????目錄??????????0??2012-08-14?00:28??數(shù)據(jù)庫備份還原工具\(yùn)bin\Debug

?????目錄??????????0??2012-08-12?16:28??數(shù)據(jù)庫備份還原工具\(yùn)bin\Release

............此處省略8個文件信息