using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?DAL;
using?Model;
using?System.Data;
using?System.Data.SqlClient;
namespace?BLL
{
???public?class?CommTool
????{
????????///?

????????///?執行一個查詢語句，返回數據表對象
????????///?

????????///?要查詢的表或視圖名稱
????????///?要查詢的咧
????????///?條件
????????///?datatable
????????public?DataTable?getDataBycondition（string?tablename?string?columns?string?condition）
????????{
????????????SqlParameter[]?pars=?new?SqlParameter[]{
?????????new?SqlParameter（“@tablename“tablename）
?????????new?SqlParameter（“@conlumns“columns）
?????????new?SqlParameter（“@condition“condition）
?????????};
????????????return?DAL.SqlDataHelper.SelectSqlReturnDataTable（“sp_getdatabyCondition“CommandType.StoredProcedurepars）;
????????}
????????????///?

????????????///?執行一個sql語句返回一條記錄（數據閱讀器）
????????????///?

????????????///?
????????????///?
????????????///?
????????????///?
????????public?SqlDataReader?getDataByCond（string?tablename?string?columns?string?condition）
????????{
????????????SqlParameter[]?pars?=?new?SqlParameter[]{
????????????new?SqlParameter（“@tablename“tablename）
????????????new?SqlParameter（“@conlumns“columns）
????????????new?SqlParameter（“@condition“condition）
?????????};
????????????return?DAL.SqlDataHelper.ExcuteSqlReturnReader（“sp_getdatabyCondition“?CommandType.StoredProcedure?pars）;
????????}
???????///?

???????///?根據條件刪除表對象
???????///?

???????///?tablename
???????///?
???????///?int
????????public?int?deletetable（string?tablename?string?condition）
????????{?
????????SqlParameter[]?pars?=new?SqlParameter[]{
????????new?SqlParameter（“@tablename“tablename）
????????new?SqlParameter（“@condition“condition）
????????};

????????????return??DAL.SqlDataHelper.ExcuteSQLReturnInt（“sp_daletetable“CommandType.StoredProcedurepars?）;
????????}
???????///?

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

???????///?頁碼
???????///?每頁顯示的條數
???????///?表名
???????///?列名
???????///?條件
???????///?主鍵
???????///?
????????public?DataTable?getpageindex（int?pageindex?int?pagesize?string?tablename?string?columns?string?conditions?string?pk）
????????{
????????????SqlParameter[]?pars?=?new?SqlParameter[]{
???????????new?SqlParameter（“@pageindex“pageindex）
???????????new?SqlParameter（“@pagesize“pagesize）
???????????new?SqlParameter（“@tablename“tablename）
?????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-09-16?09:49??company\
?????目錄???????????0??2018-09-16?09:49??company\.vs\
?????目錄???????????0??2018-09-16?09:49??company\.vs\company\
?????目錄???????????0??2018-09-16?09:49??company\.vs\company\DesignTimeBuild\
?????文件?????????244??2018-06-09?12:59??company\.vs\company\DesignTimeBuild\.dtbcache
?????目錄???????????0??2018-09-16?09:49??company\.vs\company\v15\
?????文件??????102912??2018-06-09?12:59??company\.vs\company\v15\.suo
?????目錄???????????0??2018-09-16?09:49??company\.vs\company\v15\Server\
?????目錄???????????0??2018-09-16?09:49??company\.vs\company\v15\Server\sqlite3\
?????文件???????????0??2018-06-08?19:29??company\.vs\company\v15\Server\sqlite3\db.lock
?????文件????????4096??2018-06-08?19:29??company\.vs\company\v15\Server\sqlite3\storage.ide
?????文件???????32768??2018-06-09?12:59??company\.vs\company\v15\Server\sqlite3\storage.ide-shm
?????文件??????931152??2018-06-09?12:59??company\.vs\company\v15\Server\sqlite3\storage.ide-wal
?????目錄???????????0??2018-09-16?09:49??company\.vs\config\
?????文件???????85553??2018-06-09?12:58??company\.vs\config\applicationhost.config
?????文件?????1085440??2018-06-08?19:33??company\.vs\slnx.sqlite
?????文件?????????179??2018-06-08?19:33??company\.vs\VSWorkspaceState.json
?????目錄???????????0??2018-10-16?17:03??company\BLL\
?????目錄???????????0??2018-09-16?09:49??company\BLL\bin\
?????目錄???????????0??2018-11-07?16:22??company\BLL\bin\Debug\
?????文件???????16896??2018-11-07?23:25??company\BLL\bin\Debug\BLL.dll
?????文件???????50688??2018-11-07?23:25??company\BLL\bin\Debug\BLL.pdb
?????文件???????12800??2018-11-07?23:25??company\BLL\bin\Debug\DAL.dll
?????文件???????30208??2018-11-07?23:25??company\BLL\bin\Debug\DAL.pdb
?????文件???????11776??2018-11-07?16:22??company\BLL\bin\Debug\Modle.dll
?????文件???????58880??2018-11-07?16:22??company\BLL\bin\Debug\Modle.pdb
?????目錄???????????0??2018-06-02?14:27??company\BLL\bin\Release\
?????文件????????3173??2018-10-16?17:34??company\BLL\BLL.csproj
?????文件?????????227??2018-06-02?23:30??company\BLL\BLL.csproj.user
?????文件????????4098??2018-09-22?21:05??company\BLL\CommTool.cs
?????文件????????2696??2018-09-18?19:35??company\BLL\CompanyInfoBll.cs
............此處省略6219個文件信息