using?System;
using?System.Data;
using?System.IO;
using?System.Linq;
using?System.Text;
using?MySql.Data.MySqlClient;

namespace?Helpers
{
????///?

????///?MySqlHelper操作類
????///?

????public?sealed?partial?class?MySqlHelper
????{
????????///?

????????///?批量操作每批次記錄數(shù)
????????///?

????????public?static?int?BatchSize?=?2000;

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

????????///?超時時間
????????///?

????????public?static?int?CommandTimeOut?=?600;

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

????????///初始化MySqlHelper實例
????????///?

????????///?數(shù)據(jù)庫連接字符串
????????public?MySqlHelper（string?connectionString）
????????{
????????????this.ConnectionString?=?connectionString;
????????}

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

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

????????public?string?ConnectionString?{?get;?set;?}

????????#region?實例方法

????????#region?ExecuteNonQuery

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

????????///?執(zhí)行SQL語句返回影響的行數(shù)
????????///?

????????///?SQL語句
????????///?查詢參數(shù)
????????///?返回影響的行數(shù)
????????public?int?ExecuteNonQuery（string?commandText?params?MySqlParameter[]?parms）
????????{
????????????return?ExecuteNonQuery（ConnectionString?CommandType.Text?commandText?parms）;
????????}

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

????????///?執(zhí)行SQL語句返回影響的行數(shù)
????????///?

????????///?命令類型（存儲過程命令文本?其它.）
????????///?SQL語句或存儲過程名稱
????????///?查詢參數(shù)
????????///?返回影響的行數(shù)
????????public?int?ExecuteNonQuery（CommandType?commandType?string?commandText?params?MySqlParameter[]?parms）
????????{
????????????return?ExecuteNonQuery（ConnectionString?commandType?commandText?parms）;
????????}

????????#endregion?ExecuteNonQuery

????????#region?ExecuteScalar

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

????????///?執(zhí)行SQL語句返回結(jié)果集中的第一行第一列
????????///?

????????///?返回對象類型
????????///?SQL語句
????????///?查詢參數(shù)
????????///?返回結(jié)果集中的第一行第一列
????????public?T?ExecuteScalar（string?commandText?params?MySqlParameter[]?parms）
????????{
????????????return?ExecuteScalar（ConnectionString?commandText?parms）;
????????}

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

????????///?執(zhí)行SQL語句返回結(jié)果集中的第一行第一列
????????///?

????????///?SQL語句
????????///?查詢參數(shù)
????????///?返回結(jié)果集中的第一行第一列
????????public?object?ExecuteScalar（string?commandText?params?MySqlParameter[]?parms）
????????{
????????????return?ExecuteScalar（ConnectionString?CommandType.Text?commandText?parms）;
????????}

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

????????///?執(zhí)行SQL語句返回結(jié)果集中的第一行第一列
????????///?

????????///?命令類型（存儲過程命令文本?其它.）
?