using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Configuration;
using?System.Data;

namespace?Movie
{
????public?class?DBHelper
????{

????????public?static?readonly?string?connString?=?“Data?Source=.;Initial?Catalog=Ticket;User?ID=sa;Password=123@qwe“;

????????private?static?SqlConnection?conn;
????????public?static?SqlConnection?Conn
????????{
????????????get
????????????{
????????????????if?（conn?==?null）
????????????????{
????????????????????conn?=?new?SqlConnection（connString）;
????????????????????conn.Open（）;
????????????????}
????????????????else?if?（conn.State?==?System.Data.ConnectionState.Closed）
????????????????{
????????????????????conn.Open（）;
????????????????}
????????????????else?if?（conn.State?==?System.Data.ConnectionState.Broken）
????????????????{
????????????????????conn.Close（）;
????????????????????conn.Open（）;
????????????????}
????????????????return?conn;
????????????}
????????}

????????public?static?int?GetCommand（string?safeSql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Conn）;
????????????int?result?=?cmd.ExecuteNonQuery（）;
????????????return?result;
????????}

????????public?static?int?GetCommand（string?sql?params?SqlParameter[]?values）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（sql?Conn）;
????????????cmd.Parameters.AddRange（values）;
????????????return?cmd.ExecuteNonQuery（）;
????????}
????????public?static?object?GetScalar（string?safeSql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Conn）;
????????????return?cmd.ExecuteScalar（）;
????????}

????????public?static?int?GetScalar（string?sql?params?SqlParameter[]?values）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（sql?Conn）;
????????????cmd.Parameters.AddRange（values）;
????????????int?result?=?Convert.ToInt32（cmd.ExecuteScalar（））;
????????????return?result;
????????}

????????public?static?SqlDataReader?GetReader（string?safeSql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Conn）;
????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????????return?reader;
????????}

????????public?static?SqlDataReader?GetReader（string?sql?params?SqlParameter[]?values）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（sql?Conn）;
????????????cmd.Parameters.AddRange（values）;
????????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????????return?reader;
????????}

????????public?static?DataTable?GetDataSet（string?safeSql）
????????{
????????????DataSet?ds?=?new?DataSet（）;
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Conn）;
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（cmd）;
????????????da.Fill（ds）;
????????????return?ds.Tables[0];
????????}

????????public?static?DataTable?GetDataSet（string?safeSql?params?SqlParameter[]?values）
????????{
????????????DataSet?ds?=?new?DataSet（）;
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Conn）;
??

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-19?21:22??Movie\
?????目錄???????????0??2018-06-19?14:29??Movie\.vs\
?????目錄???????????0??2018-06-19?14:29??Movie\.vs\Movie\
?????目錄???????????0??2018-06-19?14:29??Movie\.vs\Movie\v15\
?????文件???????53760??2018-06-26?13:09??Movie\.vs\Movie\v15\.suo
?????目錄???????????0??2018-06-19?14:29??Movie\.vs\Movie\v15\Server\
?????目錄???????????0??2018-06-26?13:09??Movie\.vs\Movie\v15\Server\sqlite3\
?????文件???????????0??2018-06-19?14:29??Movie\.vs\Movie\v15\Server\sqlite3\db.lock
?????文件??????679936??2018-06-26?13:09??Movie\.vs\Movie\v15\Server\sqlite3\storage.ide
?????目錄???????????0??2018-06-26?13:09??Movie\Movie\
?????文件?????????506??2018-06-19?21:17??Movie\Movie\App.config
?????文件????????5016??2018-06-26?12:41??Movie\Movie\DBHelper.cs
?????文件????????9724??2018-06-26?13:09??Movie\Movie\Movie.csproj
?????文件?????????599??2018-06-24?08:42??Movie\Movie\Movie.csproj.user
?????文件????????1700??2018-06-23?12:40??Movie\Movie\Movie_TemporaryKey.pfx
?????文件?????????517??2018-06-19?14:30??Movie\Movie\Program.cs
?????目錄???????????0??2018-06-19?14:29??Movie\Movie\Properties\
?????文件????????1308??2018-06-19?14:29??Movie\Movie\Properties\AssemblyInfo.cs
?????文件????????2823??2018-06-19?14:29??Movie\Movie\Properties\Resources.Designer.cs
?????文件????????5612??2018-06-19?14:29??Movie\Movie\Properties\Resources.resx
?????文件????????1092??2018-06-19?14:29??Movie\Movie\Properties\Settings.Designer.cs
?????文件?????????249??2018-06-19?14:29??Movie\Movie\Properties\Settings.settings
?????目錄???????????0??2018-06-19?14:29??Movie\Movie\bin\
?????目錄???????????0??2018-06-26?13:07??Movie\Movie\bin\Debug\
?????文件????????1811??2018-06-26?13:07??Movie\Movie\bin\Debug\Movie.application
?????文件???????94720??2018-06-26?13:07??Movie\Movie\bin\Debug\Movie.exe
?????文件?????????506??2018-06-19?21:17??Movie\Movie\bin\Debug\Movie.exe.config
?????文件????????3394??2018-06-26?13:07??Movie\Movie\bin\Debug\Movie.exe.manifest
?????文件??????128512??2018-06-26?13:07??Movie\Movie\bin\Debug\Movie.pdb
?????目錄???????????0??2018-06-26?13:07??Movie\Movie\bin\Debug\app.publish\
?????文件???????95712??2018-06-26?13:07??Movie\Movie\bin\Debug\app.publish\Movie.exe
............此處省略82個(gè)文件信息