1![](/Images/OutliningIndicators/ContractedBlock.gif)
Imports#Region "Imports"
2
Imports System.Data.OracleClient
3
#End Region
4![](/Images/OutliningIndicators/None.gif)
5![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
Public Class DbManagerClass DbManager
6![](/Images/OutliningIndicators/InBlock.gif)
7![](/Images/OutliningIndicators/ContractedSubBlock.gif)
Private Fields#Region "Private Fields"
8
Private isInTransaction As Boolean = False
9
Private oraConn As OracleConnection
10
Private oraCommand As OracleCommand
11
Private oraTransaction As OracleTransaction
12
Private strConnectString As String = System.Configuration.ConfigurationSettings.AppSettings("ConnectString")
13
#End Region
14![](/Images/OutliningIndicators/InBlock.gif)
15![](/Images/OutliningIndicators/ContractedSubBlock.gif)
Public Functions#Region "Public Functions"
16![](/Images/OutliningIndicators/InBlock.gif)
17![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function openOracleDB()Function openOracleDB()
18
If oraConn Is Nothing Then
19
If strConnectString Is Nothing Or strConnectString = "" Then
20
strConnectString = "data source=TEST;user id=aaa;password=TEST"
21
End If
22![](/Images/OutliningIndicators/InBlock.gif)
23
oraConn = New OracleConnection(strConnectString)
24
oraConn.Open()
25
oraCommand = New OracleCommand
26
oraCommand.Connection = oraConn
27
End If
28
End Function
29![](/Images/OutliningIndicators/InBlock.gif)
30![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function closeOracleDB()Function closeOracleDB()
31
If isInTransaction Then
32
Return Nothing
33
End If
34
If Not oraConn Is Nothing Then
35
If oraConn.State = ConnectionState.Open Then
36
oraConn.Close()
37
End If
38
End If
39
If Not oraCommand Is Nothing Then
40
oraCommand.Dispose()
41
End If
42
End Function
43![](/Images/OutliningIndicators/InBlock.gif)
44![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function beginTransaction()Function beginTransaction()
45
openOracleDB()
46![](/Images/OutliningIndicators/InBlock.gif)
47
oraTransaction = oraConn.BeginTransaction
48
oraCommand.Transaction = oraTransaction
49
isInTransaction = True
50
End Function
51![](/Images/OutliningIndicators/InBlock.gif)
52![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function commitTransaction()Function commitTransaction()
53![](/Images/OutliningIndicators/InBlock.gif)
54
oraTransaction.Commit()
55
isInTransaction = False
56
closeOracleDB()
57![](/Images/OutliningIndicators/InBlock.gif)
58
End Function
59![](/Images/OutliningIndicators/InBlock.gif)
60![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function rollbackTransaction()Function rollbackTransaction()
61![](/Images/OutliningIndicators/InBlock.gif)
62
oraTransaction.Rollback()
63
isInTransaction = False
64
closeOracleDB()
65![](/Images/OutliningIndicators/InBlock.gif)
66
End Function
67![](/Images/OutliningIndicators/InBlock.gif)
68![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_ExecuteNonquery()Function Db_ExecuteNonquery(ByVal strSQL As String)
69![](/Images/OutliningIndicators/InBlock.gif)
70
openOracleDB()
71
oraCommand.CommandText = strSQL
72
oraCommand.ExecuteNonQuery()
73
closeOracleDB()
74![](/Images/OutliningIndicators/InBlock.gif)
75
End Function
76![](/Images/OutliningIndicators/InBlock.gif)
77![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_ExecuteNonquery()Function Db_ExecuteNonquery(ByVal strSQL As String, ByVal argParameters As OracleParameter())
78
openOracleDB()
79
oraCommand.CommandText = strSQL
80
For i As Integer = 0 To argParameters.Length - 1
81
oraCommand.Parameters.Add(argParameters(i))
82
Next
83
oraCommand.ExecuteNonQuery()
84
closeOracleDB()
85
End Function
86![](/Images/OutliningIndicators/InBlock.gif)
87![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateReader()Function Db_CreateReader(ByVal strSQL As String) As OracleDataReader
88
openOracleDB()
89
oraCommand.CommandText = strSQL
90
Dim oraReader As OracleDataReader = oraCommand.ExecuteReader()
91![](/Images/OutliningIndicators/InBlock.gif)
92
Return oraReader
93
End Function
94![](/Images/OutliningIndicators/InBlock.gif)
95![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateReader()Function Db_CreateReader(ByVal strSQL As String, ByVal argParameters As OracleParameter()) As OracleDataReader
96
openOracleDB()
97
oraCommand.CommandText = strSQL
98
For i As Integer = 0 To argParameters.Length - 1
99
oraCommand.Parameters.Add(argParameters(i))
100
Next
101
Dim oraReader As OracleDataReader = oraCommand.ExecuteReader()
102
103
Return oraReader
104
End Function
105![](/Images/OutliningIndicators/InBlock.gif)
106![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateDataSet()Function Db_CreateDataSet(ByVal strSQL As String) As DataSet
107
openOracleDB()
108
oraCommand.CommandText = strSQL
109
Dim oraDap As New OracleDataAdapter(oraCommand)
110
Dim oraDst As New DataSet
111
oraDap.Fill(oraDst)
112
closeOracleDB()
113
Return oraDst
114
End Function
115![](/Images/OutliningIndicators/InBlock.gif)
116![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateDataSet()Function Db_CreateDataSet(ByVal strSQL As String, ByVal argParameters As OracleParameter()) As DataSet
117
openOracleDB()
118
oraCommand.CommandText = strSQL
119
For i As Integer = 0 To argParameters.Length - 1
120
oraCommand.Parameters.Add(argParameters(i))
121
Next
122
Dim oraDap As New OracleDataAdapter(oraCommand)
123
Dim oraDst As New DataSet
124
oraDap.Fill(oraDst)
125
closeOracleDB()
126
Return oraDst
127
End Function
128![](/Images/OutliningIndicators/InBlock.gif)
129![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateDataTable()Function Db_CreateDataTable(ByVal strSQL As String) As DataTable
130
Dim oraDst As DataSet = Db_CreateDataSet(strSQL)
131
Dim oraDt As DataTable = oraDst.Tables(0)
132
Return oraDt
133
End Function
134![](/Images/OutliningIndicators/InBlock.gif)
135![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
Public Function Db_CreateDataTable()Function Db_CreateDataTable(ByVal strSQL As String, ByVal argParameters As OracleParameter()) As DataTable
136
Dim oraDst As DataSet = Db_CreateDataSet(strSQL, argParameters)
137
Dim oraDt As DataTable = oraDst.Tables(0)
138
Return oraDt
139
End Function
140
#End Region
141![](/Images/OutliningIndicators/InBlock.gif)
142
End Class
143![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](/Images/OutliningIndicators/InBlock.gif)
3
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/InBlock.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/InBlock.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/InBlock.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
107
![](/Images/OutliningIndicators/InBlock.gif)
108
![](/Images/OutliningIndicators/InBlock.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/InBlock.gif)
111
![](/Images/OutliningIndicators/InBlock.gif)
112
![](/Images/OutliningIndicators/InBlock.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
115
![](/Images/OutliningIndicators/InBlock.gif)
116
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
117
![](/Images/OutliningIndicators/InBlock.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/InBlock.gif)
120
![](/Images/OutliningIndicators/InBlock.gif)
121
![](/Images/OutliningIndicators/InBlock.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/InBlock.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/InBlock.gif)
127
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/InBlock.gif)
132
![](/Images/OutliningIndicators/InBlock.gif)
133
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
134
![](/Images/OutliningIndicators/InBlock.gif)
135
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
136
![](/Images/OutliningIndicators/InBlock.gif)
137
![](/Images/OutliningIndicators/InBlock.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
140
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
141
![](/Images/OutliningIndicators/InBlock.gif)
142
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
143
![](/Images/OutliningIndicators/None.gif)