using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;

namespace?shangpingliulan
{
????class?DBHelper
????{
????????//數據庫鏈接字符串
????????public?static?string?ConnString?=?“Data?Source=.;Initial?Catalog=NIKEDB;Integrated?Security=True“;


????????//數據庫鏈接對象
????????private?static?SqlConnection?Conn?=?null;

????????//初始化數據庫鏈接
????????private?static?void?InitConnection（）
????????{
????????????if?（Conn?==?null）
????????????????Conn?=?new?SqlConnection（ConnString）;
????????????if?（Conn.State?==?ConnectionState.Closed）
????????????????Conn.Open（）;
????????????if?（Conn.State?==?ConnectionState.Broken）
????????????{
????????????????Conn.Close（）;
????????????????Conn.Open（）;
????????????}
????????}

????????//查詢，獲取DataReader
????????public?static?SqlDataReader?GetDataReader（string?sqlStr）
????????{
????????????InitConnection（）;
????????????SqlCommand?cmd?=?new?SqlCommand（sqlStrConn）;
????????????return?cmd.ExecuteReader（CommandBehavior.CloseConnection）;
????????}

????????//查詢，獲取DataSet
????????public?static?DataSet?GetDataSet（string?sqlStr）
????????{
????????????InitConnection（）;
????????????DataSet?ds?=?new?DataSet（）;
????????????SqlDataAdapter?dap?=?new?SqlDataAdapter（sqlStrConn）;
????????????dap.Fill（ds）;
????????????Conn.Close（）;
????????????return?ds;
????????}

?????????//查詢，獲取DataTable
????????public?static?DataTable?GetDataTable（string?sqlStr）
????????{
????????????return?GetDataSet（sqlStr）.Tables[0];
????????}

????????//增改刪
????????public?static?bool?ExecuteNonQuery（string?sqlStr）
????????{
????????????InitConnection（）;
????????????SqlCommand?cmd?=?new?SqlCommand（sqlStr?Conn）;
????????????int?result?=?cmd.ExecuteNonQuery（）;
????????????Conn.Close（）;
????????????return?result?>?0;
????????}

????????//執行集合函數
????????public?static?object?ExecuteScalar（string?sqlStr）
????????{
????????????InitConnection（）;
????????????SqlCommand?cmd?=?new?SqlCommand（sqlStr?Conn）;
????????????object?result?=?cmd.ExecuteScalar（）;
????????????Conn.Close（）;
????????????return?result;
????????}
????}
}

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

?????文件????5242880??2018-01-12?12:32??DB_51aspx\NIKE數據庫\Nike.mdf

?????文件????2097152??2018-01-12?12:32??DB_51aspx\NIKE數據庫\Nike_log.ldf

?????文件?????338117??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKEDB.rar

????..A..H.?????67584??2018-01-12?12:31??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\.vs\NIKE專賣店銷售系統\v14\.suo

?????文件????????568??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\ADForm.cs

?????文件???????1659??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\ADForm.Designer.cs

?????文件???????5817??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\ADForm.resx

?????文件????????187??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\App.config

?????文件??????79538??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\AdImage\ad1.jpg

?????文件?????516096??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\IrisSkin2.dll

?????文件?????306688??2018-01-11?12:39??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.exe

?????文件????????187??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.exe.config

?????文件?????146944??2018-01-11?12:39??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.pdb

?????文件??????22696??2018-01-11?12:56??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.vshost.exe

?????文件????????187??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.vshost.exe.config

?????文件????????490??2017-03-19?05:00??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\NIKE專賣店銷售系統.vshost.exe.manifest

?????文件??????20139??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\Calmness.ssk

?????文件??????20271??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\CalmnessColor1.ssk

?????文件??????20208??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\CalmnessColor2.ssk

?????文件???????5032??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\DeepCyan.ssk

?????文件???????5037??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\DeepGreen.ssk

?????文件???????4908??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\DeepOrange.ssk

?????文件??????16021??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\DiamondBlue.ssk

?????文件??????16669??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\DiamondGreen.ssk

?????文件??????10439??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\Eighteen.ssk

?????文件??????10382??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\EighteenColor1.ssk

?????文件???????9746??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\EighteenColor2.ssk

?????文件??????12666??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\Emerald.ssk

?????文件??????12261??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\EmeraldColor1.ssk

?????文件??????12360??2013-09-11?11:25??NIKE專賣店銷售系統項目參考\NIKE專賣店銷售系統\NIKE專賣店銷售系統\bin\Debug\skin\EmeraldColor2.ssk

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