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

namespace?Com.Caresoft.BPM.Common
{
????public?abstract?class?DBHelper
????{
????????//數據庫連接字符串（web.config來配置）
????????protected?static?string?connectionString?=?System.Configuration.ConfigurationManager.ConnectionStrings[“Caresoft“].ConnectionString;
????????????
????????public?DBHelper（）
????????{
????????}

????????#region?公用方法

????????public?static?int?GetMaxID（string?FieldName?string?TableName）
????????{
????????????string?strsql?=?“select?max（“?+?FieldName?+?“）+1?from?“?+?TableName;
????????????object?obj?=?GetSingle（strsql）;
????????????if?（obj?==?null）
????????????{
????????????????return?1;
????????????}
????????????else
????????????{
????????????????return?int.Parse（obj.ToString（））;
????????????}
????????}
????????public?static?bool?Exists（string?strSql?params?SqlParameter[]?cmdParms）
????????{
????????????object?obj?=?GetSingle（strSql?cmdParms）;
????????????int?cmdresult;
????????????if?（（object.Equals（obj?null））?||?（object.Equals（obj?System.DBNull.Value）））
????????????{
????????????????cmdresult?=?0;
????????????}
????????????else
????????????{
????????????????cmdresult?=?int.Parse（obj.ToString（））;
????????????}
????????????if?（cmdresult?==?0）
????????????{
????????????????return?false;
????????????}
????????????else
????????????{
????????????????return?true;
????????????}
????????}
????????#endregion

????????//執行簡單SQL語句#region??執行簡單SQL語句

????????/**/
????????///?

????????///?執行SQL語句，返回影響的記錄數
????????///?

????????///?SQL語句
????????///?影響的記錄數
????????public?static?int?ExecuteSql（string?SQLString）
????????{
????????????using?（SqlConnection?connection?=?new?SqlConnection（connectionString））
????????????{
????????????????using?（SqlCommand?cmd?=?new?SqlCommand（SQLString?connection））
????????????????{
????????????????????try
????????????????????{
????????????????????????connection.Open（）;
????????????????????????int?rows?=?cmd.ExecuteNonQuery（）;
????????????????????????return?rows;
????????????????????}
????????????????????catch?（System.Data.SqlClient.SqlException?E）
????????????????????{
????????????????????????connection.Close（）;
????????????????????????throw?new?Exception（E.Message）;
????????????????????}
????????????????}
????????????}
????????}

????????/**/
????????///?

????????///?執行多條SQL語句，實現數據庫事務。
????????///?

????????///?多條SQL語句??
????????public?static?void?ExecuteSqlTran（ArrayList?SQLStringList）
????????{
????????????using?（SqlConnection?conn?=?new?SqlConnection（connectionString））
????????????{
????????????????conn.Open（）;
????????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????????cmd.Connection?=?conn;
?????