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


namespace?phoneRecharge
{
????class?DBHelper
????{
????????private?static?string?connstr?=?“server=.;database=phoneInfo;uid=sa;pwd=123456;“;
????????private?static?SqlConnection?connect;
????????private?static?SqlDataAdapter?ada;
????????private?static?DBHelper?dbHelper;
????????private?static?SqlCommand?cmd;

????????public?DBHelper（）
????????{
????????????connect?=?new?SqlConnection（connstr）;
????????}

????????///?

????????///?初始化DBhelper實例
????????///?

????????///?
????????public?static?DBHelper?instance（）
????????{
????????????if?（dbHelper?==?null）
????????????{
????????????????dbHelper?=?new?DBHelper（）;
????????????}
????????????return?dbHelper;?
????????}

????????///?

????????///?打開連接
????????///?

????????public?void?DBOpen（）
????????{
????????????if?（connect.State?==?ConnectionState.Closed）
????????????{
????????????????connect.Open（）;
????????????}
????????}

????????///?

????????///?關(guān)閉連接
????????///?

????????public?void?DBClose（）
????????{
????????????if?（connect.State?==?ConnectionState.Open）
????????????{
????????????????connect.Close（）;
????????????}
????????}


????????///?

????????///?執(zhí)行SQL語句返回DataSet
????????///?

????????///?
????????///?
????????public?DataSet?GetDataSetBySql（string?sql）
????????{
????????????DBOpen（）;
????????????DataSet?ds?=?new?DataSet（）;
????????????ada?=?new?SqlDataAdapter（sqlconnect）;?
????????????ada.Fill（ds）;
????????????return?ds;
????????}

????????///?

????????///?SQL語句執(zhí)行增刪改
????????///?

????????///?
????????///?
????????public?bool?ExecuteSql（string?sql）?
????????{
????????????DBOpen（）;
????????????cmd?=?new?SqlCommand（sqlconnect）;

????????????try
????????????{
????????????????cmd.ExecuteNonQuery（）;
????????????????return?true;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.ToString（））;
????????????????return?false;
????????????}
????????????finally
????????????{
????????????????DBClose（）;
????????????}
????????}

????????///?

????????///?執(zhí)行SQL語句?返回datareader結(jié)果集
????????///?

????????///?
????????///?
????????public?SqlDataReader?ExecuteReaderBySql（string?sql）
????????{
????????????DBOpen（）;
????????????SqlCommand?commond?=?new?SqlCommand（sql?connect）;

????????????return?commond.ExecuteReader（）;
????????}
????}
}

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

?????文件????5242880??2015-08-13?08:22??C#Winform電話充值系統(tǒng)\Database\PhoneInfo.mdf

?????文件????2097152??2015-08-13?08:22??C#Winform電話充值系統(tǒng)\Database\PhoneInfo_log.ldf

?????文件??????16669??2009-04-03?14:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\DiamondGreen.ssk

?????文件?????516096??2009-04-03?14:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\IrisSkin2.dll

?????文件??????16292??2009-04-03?14:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\MSN.SSK

?????文件?????192000??2015-08-12?22:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\phoneRecharge.exe

?????文件??????21464??2016-09-12?10:58??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\phoneRecharge.vshost.exe

?????文件????????490??2013-06-18?20:28??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\bin\Debug\phoneRecharge.vshost.exe.manifest

?????文件???????2850??2015-08-12?22:30??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\DBHelper.cs

?????文件???????8122??2015-08-12?22:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneManager.cs

?????文件??????27497??2015-08-12?20:00??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneManager.Designer.cs

?????文件???????8224??2015-08-12?22:37??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneManager.resx

?????文件???????2083??2015-08-12?22:34??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneOpen.cs

?????文件??????13100??2015-08-12?22:23??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneOpen.Designer.cs

?????文件???????6189??2015-08-12?22:23??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneOpen.resx

?????文件???????3569??2015-08-12?22:30??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecharge.cs

?????文件??????15464??2015-08-12?22:24??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecharge.Designer.cs

?????文件???????6211??2015-08-12?22:24??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecharge.resx

?????文件???????2084??2015-08-12?22:30??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecord.cs

?????文件???????8211??2015-08-12?08:31??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecord.Designer.cs

?????文件???????7498??2015-08-12?08:31??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneRecord.resx

?????文件???????3376??2015-08-12?08:26??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneSimulate.cs

?????文件??????10977??2015-08-12?08:16??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneSimulate.Designer.cs

?????文件???????6211??2015-08-12?08:16??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\FromPhoneSimulate.resx

?????文件???????3964??2015-08-12?07:58??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\main.cs

?????文件??????15906??2015-08-12?07:56??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\main.Designer.cs

?????文件???????6589??2015-08-12?07:56??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\main.resx

?????文件??????12311??2016-09-09?14:47??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7545??2016-09-09?14:47??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1311??2016-09-12?10:58??C#Winform電話充值系統(tǒng)\phoneRecharge\phoneRecharge\obj\Debug\phoneRecharge.csproj.FileListAbsolute.txt

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