using?System.Data;
using?SqlHelper;
using?System.Data.SqlClient;

namespace?EnterpriseLibrary
{
????public??class?DataCommond
????{
????????#region?ExecuteNonQuery方法：執行命令，返回受影響的行數???????
????????///?

????????///?不帶參數的存儲過程調用方法
????????///?

????????///?存儲過程名
????????///?受影響的行數
????????public?static?int?ExecuteNonQuery（string?spName）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteNonQuery（DataProvider.ConnectionString?spName）;
????????}
????????///?

????????///?帶參數的存儲過程所調用的方法
????????///?

????????///?存儲過程名
????????///?輸入的參數數組
????????///?受影響的行數
????????public?static?int?ExecuteNonQuery（string?spNameparams?object[]?ob）
????????{
????????????return??SqlHelper.SqlHelper.ExecuteNonQuery（DataProvider.ConnectionString?spName?ob）;
????????}
????????#endregion????????

????????#region?ExecuteDataSet方法：返回數據集????????
????????public?static?DataSet?ExecuteDataSet（string?comTextparams?SqlParameter[]?ob）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteDataset（DataProvider.ConnectionStringcomTextob）;
????????}
????????///?

????????///?根據存儲過程查詢數據返回DataSet數據集.
????????///?

????????///?存儲過程名
????????///?數據集
????????public?static?DataSet?ExecuteDataSet（string?spName）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteDataset（DataProvider.ConnectionString?spName）;
????????}
????????///?

????????///?根據存儲過程與指定的參數查詢數據返回DataSet數據集.
????????///?

????????///?存儲過程名
????????///?參數數組
????????///?數據集
????????public?static?DataSet?ExecuteDataSet（string?spNameparams?object[]?ob）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteDataset（DataProvider.ConnectionString?spNameob）;
????????}
????????#endregion

????????#region?ExecuteScalar方法：返回結果集中的第一行第一列
????????///?

????????///?根據存儲過程查詢數據返回結果集中的第一行第一列
????????///?

????????///?存儲過程名
????????///?返回結果集中的第一行第一列
????????public?static?object?ExecuteScalar（string?spName）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteScalar（DataProvider.ConnectionString?spName）;
????????}
????????///?

????????///?根據存儲過程和要求的參數查詢數據返回結果集中的第一行第一列
????????///?

????????///?存儲過程名
????????///?參數數組
????????///?返回結果集中的第一行第一列
????????public?static?object?ExecuteScalar（string?spNameparams?object[]?ob）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteScalar（DataProvider.ConnectionString?spNameob）;
????????}
????????#endregion????????
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-05-15?21:14??論文\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\shuju\
?????文件?????1638400??2008-06-10?05:46??論文\bingbing\代碼\shuju\NetShop_Data.MDF
?????文件?????1048576??2008-06-10?05:47??論文\bingbing\代碼\shuju\NetShop_Log.LDF
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\bin\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\bin\Debug\
?????文件???????16384??2008-06-10?00:19??論文\bingbing\代碼\網絡商店\DataCommand\bin\Debug\DataCommand.dll
?????文件???????13824??2008-06-10?00:19??論文\bingbing\代碼\網絡商店\DataCommand\bin\Debug\DataCommand.pdb
?????文件???????36864??2008-06-09?23:57??論文\bingbing\代碼\網絡商店\DataCommand\bin\Debug\SqlHelper.dll
?????文件???????67072??2008-06-09?23:57??論文\bingbing\代碼\網絡商店\DataCommand\bin\Debug\SqlHelper.pdb
?????文件????????2179??2008-05-23?09:00??論文\bingbing\代碼\網絡商店\DataCommand\DataCommand.csproj
?????文件????????3368??2008-06-10?00:18??論文\bingbing\代碼\網絡商店\DataCommand\DataCommond.cs
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\obj\
?????文件?????????200??2008-06-10?01:33??論文\bingbing\代碼\網絡商店\DataCommand\obj\DataCommand.csproj.FileList.txt
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\
?????文件???????16384??2008-06-10?00:19??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\DataCommand.dll
?????文件???????13824??2008-06-10?00:19??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\DataCommand.pdb
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\Refactor\
?????文件???????16384??2008-05-24?06:54??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\Refactor\DataCommand.dll
?????文件????????4505??2008-06-09?23:57??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\obj\Debug\TempPE\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\DataCommand\Properties\
?????文件????????1333??2008-05-23?08:48??論文\bingbing\代碼\網絡商店\DataCommand\Properties\AssemblyInfo.cs
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\Datascript\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\Datascript\Change?scripts\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網絡商店\Datascript\Change?scripts\back\
?????文件????????1292??2008-06-03?18:11??論文\bingbing\代碼\網絡商店\Datascript\Change?scripts\back\AddAirCondition.sql
............此處省略467個文件信息