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

namespace?BasClass
{
????public?class?SQLHelper
????{
????????public?SQLHelper（）?{?}

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

????????///?返回數(shù)據(jù)庫連接字符串
????????///?

????????///?
????????public?static?String?GetSqlConnection（）
????????{
????????????String?conn?=?“server=.;database=MYW;uid=sa;pwd=123456“;
????????????//要使用ConfigurationManager類，必須在當前類庫項目中手工添加對System.configuration命名空間的引用
????????????//String?conn?=?ConfigurationManager.AppSettings[“ConnectionString“].ToString（）;
????????????//String?conn?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;
????????????return?conn;
????????}

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

????????///??獲得參數(shù)對象?
????????///?

????????///?參數(shù)名稱
????????///?數(shù)據(jù)類型
????????///?長度
????????///?源列名稱
????????///?參數(shù)實值
????????///?
????????public?static?SqlParameter?GetParameter（String?paramName?SqlDbType?paramType?Int32?paramSize?String?ColName?object?paramValue）
????????{
????????????SqlParameter?param?=?new?SqlParameter（paramName?paramType?paramSize?ColName）;
????????????param.Value?=?paramValue;
????????????return?param;
????????}

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

????????///?獲得參數(shù)對象
????????///?

????????///?參數(shù)名稱
????????///?數(shù)據(jù)類型
????????///?長度
????????///?源列名稱
????????///?
????????public?static?SqlParameter?GetParameter（String?paramName?SqlDbType?paramType?Int32?paramSize?String?ColName）
????????{
????????????SqlParameter?param?=?new?SqlParameter（paramName?paramType?paramSize?ColName）;
????????????return?param;
????????}

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

????????///?獲得參數(shù)對象
????????///?

????????///?參數(shù)名稱
????????///?數(shù)據(jù)類型
????????///?長度
????????///?源列名稱
????????///?
????????public?static?SqlParameter?GetParameter（String?paramName?SqlDbType?paramType?object?paramValue）
????????{
????????????SqlParameter?param?=?new?SqlParameter（paramName?paramType）;
????????????param.Value?=?paramValue;
????????????return?param;
????????}

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

????????///?執(zhí)行帶參SQL語句
????????///?

????????///?SQL語句
????????///?參數(shù)對象數(shù)組
????????///?
????????public?static?int?ExecuteSql（String?Sqlstr?SqlParameter[]?param）
????????{
????????????String?ConnStr?=?SQLHelper.GetSqlConnection（）;
????????????using?（SqlConnection?c

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

?????文件???????2306??2017-06-06?13:40??OperationSQL\BasClass\BasClass.csproj

?????文件???????6656??2017-06-06?14:20??OperationSQL\BasClass\bin\Debug\BasClass.dll

?????文件??????17920??2017-06-06?14:20??OperationSQL\BasClass\bin\Debug\BasClass.pdb

?????文件???????7405??2017-06-06?14:06??OperationSQL\BasClass\DBHelper.cs

?????文件????????340??2017-06-06?13:56??OperationSQL\BasClass\obj\Debug\BasClass.csproj.FileListAbsolute.txt

?????文件???????6656??2017-06-06?14:20??OperationSQL\BasClass\obj\Debug\BasClass.dll

?????文件??????17920??2017-06-06?14:20??OperationSQL\BasClass\obj\Debug\BasClass.pdb

?????文件???????5726??2017-06-06?14:20??OperationSQL\BasClass\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1370??2017-06-06?11:44??OperationSQL\BasClass\Properties\AssemblyInfo.cs

?????文件???????1517??2017-06-06?11:53??OperationSQL\BasClass\xmlHelper.cs

?????文件???????2348??2017-06-06?11:29??OperationSQL\BassClass\BassClass.csproj

?????文件???????2701??2017-06-06?11:19??OperationSQL\BassClass\DBHelper.cs

?????文件???????5728??2017-06-06?11:20??OperationSQL\BassClass\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1372??2017-06-06?11:11??OperationSQL\BassClass\Properties\AssemblyInfo.cs

?????文件???????1242??2017-06-06?11:25??OperationSQL\BassClass\xmlHelper.cs

?????文件???????6656??2017-06-06?14:20??OperationSQL\BLL\bin\Debug\BasClass.dll

?????文件??????17920??2017-06-06?14:20??OperationSQL\BLL\bin\Debug\BasClass.pdb

?????文件???????4608??2017-06-07?08:05??OperationSQL\BLL\bin\Debug\BLL.dll

?????文件??????13824??2017-06-07?08:05??OperationSQL\BLL\bin\Debug\BLL.pdb

?????文件???????6144??2017-06-07?08:05??OperationSQL\BLL\bin\Debug\DAL.dll

?????文件??????13824??2017-06-07?08:05??OperationSQL\BLL\bin\Debug\DAL.pdb

?????文件???????4608??2017-06-06?14:20??OperationSQL\BLL\bin\Debug\MODEL.dll

?????文件??????13824??2017-06-06?14:20??OperationSQL\BLL\bin\Debug\MODEL.pdb

?????文件???????2667??2017-06-06?14:20??OperationSQL\BLL\BLL.csproj

?????文件????????872??2017-06-06?14:20??OperationSQL\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????11669??2017-06-07?08:05??OperationSQL\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache

?????文件???????4608??2017-06-07?08:05??OperationSQL\BLL\obj\Debug\BLL.dll

?????文件??????13824??2017-06-07?08:05??OperationSQL\BLL\obj\Debug\BLL.pdb

?????文件???????5878??2017-06-07?08:05??OperationSQL\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1360??2017-06-06?10:55??OperationSQL\BLL\Properties\AssemblyInfo.cs

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