uteSqlDs(string,string)，Return Type：DataSet ");
return ExecuteSqlDs(new SqlCommand(strSql, this.conn), strTableName);
}
///
/// Execute SQL Command,return DataSet.
///
/// SQL Command which will be Executed
/// SQL Parameter Collection
/// table name
/// return DataSet.
public DataSet ExecuteSqlDs(string strSql, SqlParameter[] sqlParameters, string strTableName)
{
debug("Now Execute DataBaseAccess's Method:ExecuteSqlDs(string,SqlParameter[],string)，Return Type：DataSet ");
return ExecuteSqlDs(SQLHelper.CreateCommand(strSql, sqlParameters, this.conn), strTableName);
}
#endregion
#region ExecuteSqlFillDs
///
/// Execute SQL Command,add new resultset into current ref DataSet.
///
/// SQL Command which will be Executed
/// table name
/// current Dataset
public void ExecuteSqlFillDs(SqlCommand sqlcmd, string strTableName, ref DataSet dsRef)
{
debug("Now Execute DataBaseAccess's Method:ExecuteSqlFillDs(SqlCommand,string,ref DataSet)");
sqlcmd.Connection = this.conn;
SqlDataAdapter sqlda = new SqlDataAdapter(sqlcmd);
try
{
debug("Execute SQL Command：" + sqlcmd.CommandText);
this.conn.Open();
sqlda.Fill(dsRef, strTableName);
}
catch (SqlException ex)
{
debug("Exception information：" + ex.ToString());
throw ex;
}
finally
{
sqlcmd.Dispose();
sqlda.Dispose();
this.conn.Close();
}
}
///
/// Execute SQL Command,add new resultset into current ref DataSet.
///
/// SQL Command which will be Executed
/// table name
/// current Dataset
public void ExecuteSqlFillDs(string strSql, string strTableName, ref DataSet dsRef)
{
debug("Now Execute DataBaseAccess's Method:ExecuteSqlFillDs(string,string,ref DataSet)");
ExecuteSqlFillDs(new SqlCommand(strSql),strTableName, ref dsRef);
}
///
/// Execute SQL Command,add new resultset into current ref DataSet.
///
/// SQL Command which will be Executed
/// SQL Parameters Collection
/// table name
/// Current Dataset
public void ExecuteSqlFillDs(string strSql, SqlParameter[] sqlParameters, string strTableName, ref DataSet dsRef)
{
debug("Now Execute DataBaseAccess's Method:ExecuteSqlFillDs(string strSql, SqlParameter[], string, ref DataSet)");
ExecuteSqlFillDs(SQLHelper.CreateCommand(strSql, sqlParameters, this.conn), strTableName, ref dsRef);
}
#endregion
#region ExecuteSqlDsEx
///
/// Define pagination(Execute SQL Command,return DataSet).
///
/// SQL Command which will be Executed
/// index of StartRecord
/// number of Records
/// table name
/// return DataSet
public DataSet ExecuteSqlDsEx(SqlCommand sqlcmd, int iStartRecord, int iMaxRecord, string strTableName)
{