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

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

????????///?不帶參數(shù)的存儲(chǔ)過程調(diào)用方法
????????///?

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

????????///?帶參數(shù)的存儲(chǔ)過程所調(diào)用的方法
????????///?

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

????????#region?ExecuteDataSet方法：返回?cái)?shù)據(jù)集????????
????????public?static?DataSet?ExecuteDataSet（string?comTextparams?SqlParameter[]?ob）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteDataset（DataProvider.ConnectionStringcomTextob）;
????????}
????????///?

????????///?根據(jù)存儲(chǔ)過程查詢數(shù)據(jù)返回DataSet數(shù)據(jù)集.
????????///?

????????///?存儲(chǔ)過程名
????????///?數(shù)據(jù)集
????????public?static?DataSet?ExecuteDataSet（string?spName）
????????{
????????????return?SqlHelper.SqlHelper.ExecuteDataset（DataProvider.ConnectionString?spName）;
????????}
????????///?

????????///?根據(jù)存儲(chǔ)過程與指定的參數(shù)查詢數(shù)據(jù)返回DataSet數(shù)據(jù)集.
????????///?

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

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

????????///?根據(jù)存儲(chǔ)過程查詢數(shù)據(jù)返回結(jié)果集中的第一行第一列
????????///?

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

????????///?根據(jù)存儲(chǔ)過程和要求的參數(shù)查詢數(shù)據(jù)返回結(jié)果集中的第一行第一列
????????///?

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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????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\代碼\網(wǎng)絡(luò)商店\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\Debug\
?????文件???????16384??2008-06-10?00:19??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\Debug\DataCommand.dll
?????文件???????13824??2008-06-10?00:19??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\Debug\DataCommand.pdb
?????文件???????36864??2008-06-09?23:57??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\Debug\SqlHelper.dll
?????文件???????67072??2008-06-09?23:57??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\bin\Debug\SqlHelper.pdb
?????文件????????2179??2008-05-23?09:00??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\DataCommand.csproj
?????文件????????3368??2008-06-10?00:18??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\DataCommond.cs
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\
?????文件?????????200??2008-06-10?01:33??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\DataCommand.csproj.FileList.txt
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\
?????文件???????16384??2008-06-10?00:19??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\DataCommand.dll
?????文件???????13824??2008-06-10?00:19??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\DataCommand.pdb
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\Refactor\
?????文件???????16384??2008-05-24?06:54??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\Refactor\DataCommand.dll
?????文件????????4505??2008-06-09?23:57??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\obj\Debug\TempPE\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\Properties\
?????文件????????1333??2008-05-23?08:48??論文\bingbing\代碼\網(wǎng)絡(luò)商店\DataCommand\Properties\AssemblyInfo.cs
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\Datascript\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\Datascript\Change?scripts\
?????目錄???????????0??2011-05-15?21:14??論文\bingbing\代碼\網(wǎng)絡(luò)商店\Datascript\Change?scripts\back\
?????文件????????1292??2008-06-03?18:11??論文\bingbing\代碼\網(wǎng)絡(luò)商店\Datascript\Change?scripts\back\AddAirCondition.sql
............此處省略467個(gè)文件信息