/// <summary> /// 返回查询集合 /// </summary> /// <param name="commandText"></param> /// <param name="commandParameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public DataSet ExecuteDataset(String commandText, IDataParameter[] commandParameters = null, CommandType commandType = CommandType.Text, IDbTransaction transaction = null) { return(MSSQLDBServer.ExecuteDataset(ConnectString, commandText, commandParameters, commandType, transaction)); }
/// <summary> /// 返回受影响的行数 /// </summary> /// <param name="commandText"></param> /// <param name="commandParameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public Int32 ExecuteNonQuery(String commandText, IDataParameter[] commandParameters = null, CommandType commandType = CommandType.Text, IDbTransaction transaction = null) { return(MSSQLDBServer.ExecuteNonQuery(ConnectString, commandText, commandParameters, commandType, transaction)); }
/// <summary> /// 带Out或Output的查询表 /// </summary> /// <param name="commandText"></param> /// <param name="outParameters"></param> /// <param name="commandParameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public DataTable ExecuteDatatable(String commandText, out Dictionary <String, Object> outParameters, IDataParameter[] commandParameters, CommandType commandType = CommandType.StoredProcedure, IDbTransaction transaction = null) { return(MSSQLDBServer.ExecuteDatatable(ConnectString, commandText, out outParameters, commandParameters, commandType, transaction)); }
/// <summary> /// 批量导入 /// </summary> /// <param name="dataTable"></param> /// <param name="batchSize"></param> /// <param name="bulkCopyTimeout"></param> /// <param name="copyOptions"></param> /// <returns></returns> public Boolean ExecuteBulkCopy(DataTable dataTable, Int32 batchSize = 10000, Int32 bulkCopyTimeout = 60, SqlBulkCopyOptions copyOptions = SqlBulkCopyOptions.Default) { return(MSSQLDBServer.SQLBulkCopy(ConnectString, dataTable, batchSize, bulkCopyTimeout, copyOptions)); }