using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
using?System.xml;
using?System.xml.Schema;
using?System.xml.Serialization;
using?System.xml.XPath;
using?System.xml.Xsl;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;

namespace?DAL
{
????public?class?DBHelper
????{
????????private?static?SqlConnection?connection;
????????public?static?SqlConnection?Connection
????????{
????????????get
????????????{
????????????????string?connectionString?=?System.Configuration.ConfigurationManager.ConnectionStrings[“OAConn“].ConnectionString;
????????????????if?（connection?==?null）
????????????????{
????????????????????connection?=?new?SqlConnection（connectionString）;
????????????????????connection.Open（）;
????????????????}
????????????????else?if?（connection.State?==?System.Data.ConnectionState.Closed）
????????????????{
????????????????????connection.Open（）;
????????????????}
????????????????else?if?（connection.State?==?System.Data.ConnectionState.Broken）
????????????????{
????????????????????connection.Close（）;
????????????????????connection.Open（）;
????????????????}
????????????????return?connection;
????????????}
????????}
????????///?

????????///?通過SQL語句和條件增刪改一條數據
????????///?

????????///?存儲過程名
????????///?數據庫信息數量
????????public?static?int?ExecuteCommand（string?safeSql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Connection）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????int?result?=?cmd.ExecuteNonQuery（）;
????????????return?result;
????????}
????????///?

????????///?通過SQL語句增刪改至少一條數據庫信息
????????///?

????????///?存儲過程名
????????///?存儲過程參數值
????????///?數據庫信息數量
????????public?static?int?ExecuteCommand（string?safeSql?params?SqlParameter[]?values）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Connection）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????cmd.Parameters.AddRange（values）;
????????????return?cmd.ExecuteNonQuery（）;
????????}

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

????????///?通過SQL語句查詢一條數據庫信息
????????///?

????????///?存儲過程名
????????///?數據庫信息數量
????????public?static?int?GetScalar（string?safeSql）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Connection）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????int?result?=?Convert.ToInt32（cmd.ExecuteScalar（））;
????????????return?result;
????????}
????????public?static?int?GetScalarBySql（string?safeSql?params?SqlParameter[]?values）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（safeSql?Connection）;
????????????cmd.Parameters.AddRange（values）;
????????????//?cmd.CommandType?=?CommandType.StoredProcedure;
???????

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

?????文件??????14115??2009-12-10?21:02??DBHelper.cs

-----------?---------??----------?-----??----

????????????????14115????????????????????1