using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.IO;
using?System.Data.SqlClient;
using?System.Diagnostics;
using?System.Threading;

namespace?建庫測試程序
{
????public?partial?class?Form1?:?Form
????{
????????protected?string[]?sqlPathTag;??//?SQL腳本文件數(shù)組（文件名包含路徑）

????????protected?string[]?sqlTxtTag;???//?SQL腳本文件數(shù)組
?
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????//?初始化

????????????tIP.Text?=?“127.0.0.1“;
????????????tDatabase.Text?=?“NT_QMS“;
????????????tUser.Text?=?“sa“;
????????????tPassword.Text?=?“123456“;

????????????//tIP.Text?=?“120.24.98.114“;
????????????//tDatabase.Text?=?“YY_QMS“;
????????????//tUser.Text?=?“sa“;
????????????//tPassword.Text?=?“ABCabc123“;

????????????//tIP.Text?=?“127.0.0.1“;
????????????//tDatabase.Text?=?“YY_QMS“;
????????????//tUser.Text?=?“sa“;
????????????//tPassword.Text?=?“ABCabc123“;

????????}

????????#region?選擇?SQL?腳本文件
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????//?選擇SQL腳本文件

????????????try
????????????{
????????????????OpenFileDialog?ofd?=?new?OpenFileDialog（）;

????????????????ofd.Multiselect?=?true;??//?允許多選

????????????????ofd.InitialDirectory?=?GetExecutePath（）?+?“\\數(shù)據(jù)庫結(jié)構(gòu)SQL“;

????????????????ofd.title?=?“請選擇SQL腳本文件“;

????????????????ofd.Filter?=?“腳本文件（*.sql）|*.sql“;

????????????????if?（ofd.ShowDialog（）?==?DialogResult.OK）
????????????????{
????????????????????//tSqltxt.Text?=?ofd.FileName;

????????????????????tSqltxt.Text?=?““;

????????????????????sqlPathTag?=?ofd.FileNames;

????????????????????sqlTxtTag?=?ofd.SafeFileNames;

????????????????????for?（int?i?=?0;?i?????????????????????{
????????????????????????AddList（string.Format（“選擇的腳本文件?{0}?：{1}“?Convert.ToString（i?+?1）?sqlPathTag[i]））;
????????????????????}

????????????????????for?（int?j?=?0;?j?????????????????????{
????????????????????????tSqltxt.Text?+=?“[“?+?sqlTxtTag[j]?+?“]“;
????????????????????}

????????????????????tSqltxt.Text?=?tSqltxt.Text.Substring（0?tSqltxt.Text.Length?-?1）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????AddList（ex.Message）;
????????????}

????????}
????????#endregion

????????#region?創(chuàng)建數(shù)據(jù)庫
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????//?創(chuàng)建數(shù)據(jù)庫

????????????if?（tIP.Text.Trim（）?==?““）
????????????{
????????????????MessageBox.Show（“請輸入數(shù)據(jù)庫服務(wù)器IP地址！“?“提示“）;
????????????????return;
????????????}

????????????if?（tUser.Text.Trim（）?==?““）
????????????{
????????????????MessageBox.Show（“請輸入數(shù)據(jù)庫用戶名！“?“提示“）;
????????????????return;
????????????}

????????????if?（tPassword.T

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

?????文件???????5612??2016-12-09?14:56??建庫測試程序\建庫測試程序\Properties\Resources.resx

?????文件????????249??2016-12-09?14:56??建庫測試程序\建庫測試程序\Properties\Settings.settings

?????文件???????1360??2016-12-09?14:56??建庫測試程序\建庫測試程序\Properties\AssemblyInfo.cs

?????文件???????2888??2016-12-09?14:56??建庫測試程序\建庫測試程序\Properties\Resources.Designer.cs

?????文件???????1105??2016-12-09?14:56??建庫測試程序\建庫測試程序\Properties\Settings.Designer.cs

?????文件??????14767??2016-12-21?09:59??建庫測試程序\建庫測試程序\Form1.Designer.cs

?????文件?????204862??2016-12-13?15:25??建庫測試程序\建庫測試程序\123.ico

?????文件???????3901??2016-12-13?15:55??建庫測試程序\建庫測試程序\建庫測試程序.csproj

?????文件????????490??2010-03-17?22:39??建庫測試程序\建庫測試程序\bin\Debug\建庫測試程序.vshost.exe.manifest

?????文件??????24216??2016-12-21?10:02??建庫測試程序\建庫測試程序\bin\Debug\.NET建庫程序.vshost.exe

?????文件?????104054??2016-12-14?09:44??建庫測試程序\建庫測試程序\bin\Debug\數(shù)據(jù)庫結(jié)構(gòu)SQL\CreatOthers.sql

?????文件??????65224??2016-12-14?09:51??建庫測試程序\建庫測試程序\bin\Debug\數(shù)據(jù)庫結(jié)構(gòu)SQL\CreatTable.sql

?????文件??????66862??2016-12-14?09:47??建庫測試程序\建庫測試程序\bin\Debug\數(shù)據(jù)庫結(jié)構(gòu)SQL\CreatTableAndData.sql

?????文件???????2626??2016-12-13?17:03??建庫測試程序\建庫測試程序\bin\Debug\數(shù)據(jù)庫結(jié)構(gòu)SQL\Proc_ClearStationData.sql

?????文件?????200418??2016-12-14?09:54??建庫測試程序\建庫測試程序\bin\Debug\數(shù)據(jù)庫結(jié)構(gòu)SQL\庫對象創(chuàng)建腳本\CreateDatabase.sql

?????文件????????490??2010-03-17?22:39??建庫測試程序\建庫測試程序\bin\Debug\.NET建庫程序.vshost.exe.manifest

?????文件?????223744??2016-12-21?10:02??建庫測試程序\建庫測試程序\bin\Debug\.NET建庫程序.exe

?????文件??????30208??2016-12-21?10:02??建庫測試程序\建庫測試程序\bin\Debug\.NET建庫程序.pdb

?????文件???????6962??2016-12-13?15:55??建庫測試程序\建庫測試程序\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1567??2016-12-13?15:06??建庫測試程序\建庫測試程序\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件????????180??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\建庫測試程序.Form1.resources

?????文件????????180??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\建庫測試程序.Properties.Resources.resources

?????文件????????977??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\建庫測試程序.csproj.GenerateResource.Cache

?????文件??????30208??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\.NET建庫程序.pdb

?????文件?????223744??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\.NET建庫程序.exe

?????文件????????890??2016-12-21?10:02??建庫測試程序\建庫測試程序\obj\Debug\建庫測試程序.csproj.FileListAbsolute.txt

?????文件???????5817??2016-12-21?09:59??建庫測試程序\建庫測試程序\Form1.resx

?????文件??????10663??2016-12-21?10:02??建庫測試程序\建庫測試程序\Form1.cs

?????文件????????499??2016-12-09?14:56??建庫測試程序\建庫測試程序\Program.cs

?????文件???????1023??2016-12-09?14:56??建庫測試程序\建庫測試程序.sln

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