/*
?*?文件名：SqlHelp.cs
?*?Copyright?（c）?2008?一鍵通智能軟件公司
?*?功能：數(shù)據(jù)庫操作類?
?*?作者：pjc
?*?創(chuàng)建時間：2009/06/28
?*/
using?System;
using?System.Configuration;
using?System.Data;
using?System.Data.SqlClient;
using?System.Collections;
using?System.Web;
using?System.Data.OleDb;

namespace?YJT.DBDealHelp.OLE
{
????public?abstract?class?OleHelp
????{
????????//數(shù)據(jù)庫連接字符串
????????public?static?readonly?string?ConnectionStringLocalTransaction?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?source=|DataDirectory|App_Data\\BUDGET.mdb“;
????????//實例化?Hashtable?對象，存儲?parameters
????????private?static?Hashtable?parmCache?=?Hashtable.Synchronized（new?Hashtable（））;

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

????????///?依靠一個指定的數(shù)據(jù)庫連接字符串來執(zhí)行一個?SqlCommand?對象（無返回值）
????????///?使用給定參數(shù).
????????///?

????????///?
????????///?e.g.:??
????????///??int?result?=?ExecuteNonQuery（connString?CommandType.StoredProcedure?“PublishOrders“?new?SqlParameter（“@prodid“?24））;
????????///?
????????///?一個有效的數(shù)據(jù)庫連接字符串
????????///??CommandType?對象（存儲?procedure?text?etc.類型）
????????///?存儲過程名稱或?T-SQL?命令文本
????????///??SqlParamters?對象列表用來被執(zhí)行命令
????????///?命令執(zhí)行后返回受影響的行數(shù)
????????public?static?int?ExecuteNonQuery（string?connectionString?CommandType?cmdType?string?cmdText?params?OleDbParameter[]?commandParameters）
????????{

????????????OleDbCommand?cmd?=?new?OleDbCommand（）;

????????????using?（OleDbConnection?conn?=?new?OleDbConnection（connectionString））
????????????{
????????????????PrepareCommand（cmd?conn?null?cmdType?cmdText?commandParameters）;
????????????????int?val?=?cmd.ExecuteNonQuery（）;
????????????????cmd.Parameters.Clear（）;
????????????????conn.Close（）;
????????????????return?val;
????????????}
????????}

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

????????///?依靠一個現(xiàn)有的數(shù)據(jù)庫連接字符串來執(zhí)行一個?OleDbCommand?對象（無返回值）
????????///?使用給定參數(shù).
????????///?

????????///?
????????///?e.g.:??
????????///??int?result?=?ExecuteNonQuery（connString?CommandType.StoredProcedure?“PublishOrders“?new?SqlParameter（“@prodid“?24））;
????????///?
????????///?現(xiàn)有的數(shù)據(jù)庫連接對象?SqlConnection
????????///??CommandType?對象（存儲?procedure?text?etc.類型）
????????///?存儲過程名稱或?T-SQL?命令文本
????????///??SqlParamters?對象列表用來被執(zhí)行命令
????????///?命令執(zhí)行后返回受影響的行數(shù)
????????public?static?int?ExecuteNonQuery（OleDbConnection?connection?CommandType?cmdType?string?cmdText?params?OleDbParameter[]?commandParameters）
????????{

????????????OleDbCommand?cmd?=?new?OleDbCommand（）;

????????????PrepareCommand（cmd?connection?null?cmdType?cmdText?commandParameters）;
????????????int?val?=?cmd.ExecuteNonQuery（）;
????????????cmd.Parameters.Clear（）;
????????????connection.Clo

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

?????文件???????9728??2009-08-26?17:01??QLSoft\DBDealHelp\bin\Debug\DBDealHelp.dll

?????文件??????30208??2009-08-26?17:01??QLSoft\DBDealHelp\bin\Debug\DBDealHelp.pdb

?????文件???????2419??2009-08-25?10:42??QLSoft\DBDealHelp\DBDealHelp.csproj

?????文件????????276??2009-07-14?15:33??QLSoft\DBDealHelp\DBDealHelp.csproj.vspscc

?????文件????????169??2009-07-14?15:33??QLSoft\DBDealHelp\mssccprj.scc

?????文件????????146??2009-07-24?09:11??QLSoft\DBDealHelp\obj\DBDealHelp.csproj.FileList.txt

?????文件????????341??2009-08-03?16:39??QLSoft\DBDealHelp\obj\DBDealHelp.csproj.FileListAbsolute.txt

?????文件???????1715??2009-08-26?16:47??QLSoft\DBDealHelp\obj\Debug\DBDealHelp.csproj.FileListAbsolute.txt

?????文件???????9728??2009-08-26?17:01??QLSoft\DBDealHelp\obj\Debug\DBDealHelp.dll

?????文件??????30208??2009-08-26?17:01??QLSoft\DBDealHelp\obj\Debug\DBDealHelp.pdb

?????文件??????16384??2009-07-16?10:43??QLSoft\DBDealHelp\obj\Debug\Refactor\DBDealHelp.dll

?????文件??????14436??2009-07-14?15:33??QLSoft\DBDealHelp\OleHelp.cs

?????文件???????1363??2009-07-14?15:33??QLSoft\DBDealHelp\Properties\AssemblyInfo.cs

????..A.SHR???????110??2009-07-14?15:33??QLSoft\DBDealHelp\Properties\vssver2.scc

?????文件??????15873??2009-08-26?17:01??QLSoft\DBDealHelp\SqlHelp.cs

????..A.SHR???????196??2009-07-18?16:28??QLSoft\DBDealHelp\vssver2.scc

?????文件????????701??2009-08-27?08:14??QLSoft\Ql.Event.Client\App.config

?????文件??????10752??2009-08-27?08:46??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.exe

?????文件????????701??2009-08-27?08:14??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.exe.config

?????文件??????30208??2009-08-27?08:46??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.pdb

?????文件??????14328??2009-08-27?08:46??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.vshost.exe

?????文件????????701??2009-08-27?08:14??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.vshost.exe.config

?????文件????????490??2007-07-21?01:33??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Client.vshost.exe.manifest

?????文件???????7168??2009-08-27?08:24??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Core.dll

?????文件??????11776??2009-08-27?08:24??QLSoft\Ql.Event.Client\bin\Debug\Ql.Event.Core.pdb

?????文件???????2221??2009-08-27?08:46??QLSoft\Ql.Event.Client\Form1.cs

?????文件???????3303??2009-08-27?08:29??QLSoft\Ql.Event.Client\Form1.Designer.cs

?????文件???????5814??2009-08-27?08:29??QLSoft\Ql.Event.Client\Form1.resx

?????文件????????706??2009-08-27?08:46??QLSoft\Ql.Event.Client\obj\Debug\Ql.Event.Client.csproj.FileListAbsolute.txt

?????文件????????847??2009-08-27?08:29??QLSoft\Ql.Event.Client\obj\Debug\Ql.Event.Client.csproj.GenerateResource.Cache

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