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

namespace?jiemian
{
????class?DBHelper
????{
????????//連接數(shù)據(jù)庫
????????public?static?string?connstr?=?“Data?Source=.;Initial?Catalog=haocheDB;Integrated?Security=True“;

????????public?static?DataTable?select（string?proc?params?SqlParameter[]?p）
????????{
????????????SqlConnection?con?=?new?SqlConnection（connstr）;
????????????SqlCommand?cmd?=?new?SqlCommand（proc?con）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????cmd.Parameters.AddRange（p）;
????????????SqlDataAdapter?dr?=?new?SqlDataAdapter（cmd）;
????????????DataTable?dt?=?new?DataTable（）;
????????????dr.Fill（dt）;
????????????return?dt;
????????}
????????public?static?bool?Execute（string?proc?params?SqlParameter[]?p）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（connstr）;
????????????conn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（proc?conn）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????cmd.Parameters.AddRange（p）;
????????????int?count?=?cmd.ExecuteNonQuery（）;
????????????conn.Close（）;
????????????return?count?>?0;
????????}
????????//增刪改
????????public?static?bool?Execute（string?sql）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（connstr）;
????????????conn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（sqlconn）;
????????????int?count?=?cmd.ExecuteNonQuery（）;
????????????conn.Close（）;
????????????return?count?>?0;
????????}

?????
????????//查詢
????????public?static?DataTable?select（string?sql）
????????{
????????????SqlConnection?conn?=?new?SqlConnection（connstr）;
????????????SqlDataAdapter?sda?=?new?SqlDataAdapter（sql?conn）;
????????????DataTable?dt?=?new?DataTable（）;
????????????sda.Fill（dt）;
????????????return?dt;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-03-26?08:26??豪車項(xiàng)目\
?????文件?????5242880??2019-01-11?12:56??豪車項(xiàng)目\haocheDB.mdf
?????文件?????2097152??2019-01-11?12:56??豪車項(xiàng)目\haocheDB_log.ldf
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\
?????文件?????????162??2018-06-06?14:31??豪車項(xiàng)目\豪車\~$銷售管理系統(tǒng)需求說明書.doc
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\
?????文件?????????187??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\App.config
?????文件????????1174??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Form1.Designer.cs
?????文件?????????405??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Form1.cs
?????文件?????????536??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Program.cs
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\
?????文件????????1368??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\AssemblyInfo.cs
?????文件????????2900??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\Resources.Designer.cs
?????文件????????5612??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\Resources.resx
?????文件????????1111??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\Settings.Designer.cs
?????文件?????????249??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\Properties\Settings.settings
?????文件????????4079??2018-05-03?14:03??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\WindowsFormsApplication1.csproj
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\bin\
?????目錄???????????0??2019-03-26?09:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\bin\Debug\
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\
?????目錄???????????0??2019-01-09?08:31??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\
?????文件????????6995??2018-05-03?14:03??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2019-03-26?09:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\TempPE\
?????文件???????????0??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件???????????0??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件???????????0??2018-05-03?14:02??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????文件???????12505??2018-05-03?14:03??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\商品信息錄入.Designer.cs
?????文件?????????514??2018-05-03?14:03??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\商品信息錄入.cs
?????文件????????5817??2018-05-03?14:03??豪車項(xiàng)目\豪車\豪車登錄\WindowsFormsApplication1\商品信息錄入.resx
?????目錄???????????0??2019-01-09?10:09??豪車項(xiàng)目\豪車\豪車登錄\jiemian\
............此處省略181個(gè)文件信息