InversionesDEVDataSet3.Designer.vb 82 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549
  1. '------------------------------------------------------------------------------
  2. ' <auto-generated>
  3. ' Este código fue generado por una herramienta.
  4. ' Versión de runtime:4.0.30319.42000
  5. '
  6. ' Los cambios en este archivo podrían causar un comportamiento incorrecto y se perderán si
  7. ' se vuelve a generar el código.
  8. ' </auto-generated>
  9. '------------------------------------------------------------------------------
  10. Option Strict Off
  11. Option Explicit On
  12. '''<summary>
  13. '''Represents a strongly typed in-memory cache of data.
  14. '''</summary>
  15. <Global.System.Serializable(), _
  16. Global.System.ComponentModel.DesignerCategoryAttribute("code"), _
  17. Global.System.ComponentModel.ToolboxItem(true), _
  18. Global.System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema"), _
  19. Global.System.Xml.Serialization.XmlRootAttribute("InversionesDEVDataSet3"), _
  20. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")> _
  21. Partial Public Class InversionesDEVDataSet3
  22. Inherits Global.System.Data.DataSet
  23. Private tableBAN1 As BAN1DataTable
  24. Private _schemaSerializationMode As Global.System.Data.SchemaSerializationMode = Global.System.Data.SchemaSerializationMode.IncludeSchema
  25. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  26. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  27. Public Sub New()
  28. MyBase.New
  29. Me.BeginInit
  30. Me.InitClass
  31. Dim schemaChangedHandler As Global.System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
  32. AddHandler MyBase.Tables.CollectionChanged, schemaChangedHandler
  33. AddHandler MyBase.Relations.CollectionChanged, schemaChangedHandler
  34. Me.EndInit
  35. End Sub
  36. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  37. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  38. Protected Sub New(ByVal info As Global.System.Runtime.Serialization.SerializationInfo, ByVal context As Global.System.Runtime.Serialization.StreamingContext)
  39. MyBase.New(info, context, false)
  40. If (Me.IsBinarySerialized(info, context) = true) Then
  41. Me.InitVars(false)
  42. Dim schemaChangedHandler1 As Global.System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
  43. AddHandler Me.Tables.CollectionChanged, schemaChangedHandler1
  44. AddHandler Me.Relations.CollectionChanged, schemaChangedHandler1
  45. Return
  46. End If
  47. Dim strSchema As String = CType(info.GetValue("XmlSchema", GetType(String)),String)
  48. If (Me.DetermineSchemaSerializationMode(info, context) = Global.System.Data.SchemaSerializationMode.IncludeSchema) Then
  49. Dim ds As Global.System.Data.DataSet = New Global.System.Data.DataSet()
  50. ds.ReadXmlSchema(New Global.System.Xml.XmlTextReader(New Global.System.IO.StringReader(strSchema)))
  51. If (Not (ds.Tables("BAN1")) Is Nothing) Then
  52. MyBase.Tables.Add(New BAN1DataTable(ds.Tables("BAN1")))
  53. End If
  54. Me.DataSetName = ds.DataSetName
  55. Me.Prefix = ds.Prefix
  56. Me.Namespace = ds.Namespace
  57. Me.Locale = ds.Locale
  58. Me.CaseSensitive = ds.CaseSensitive
  59. Me.EnforceConstraints = ds.EnforceConstraints
  60. Me.Merge(ds, false, Global.System.Data.MissingSchemaAction.Add)
  61. Me.InitVars
  62. Else
  63. Me.ReadXmlSchema(New Global.System.Xml.XmlTextReader(New Global.System.IO.StringReader(strSchema)))
  64. End If
  65. Me.GetSerializationData(info, context)
  66. Dim schemaChangedHandler As Global.System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
  67. AddHandler MyBase.Tables.CollectionChanged, schemaChangedHandler
  68. AddHandler Me.Relations.CollectionChanged, schemaChangedHandler
  69. End Sub
  70. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  71. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  72. Global.System.ComponentModel.Browsable(false), _
  73. Global.System.ComponentModel.DesignerSerializationVisibility(Global.System.ComponentModel.DesignerSerializationVisibility.Content)> _
  74. Public ReadOnly Property BAN1() As BAN1DataTable
  75. Get
  76. Return Me.tableBAN1
  77. End Get
  78. End Property
  79. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  80. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  81. Global.System.ComponentModel.BrowsableAttribute(true), _
  82. Global.System.ComponentModel.DesignerSerializationVisibilityAttribute(Global.System.ComponentModel.DesignerSerializationVisibility.Visible)> _
  83. Public Overrides Property SchemaSerializationMode() As Global.System.Data.SchemaSerializationMode
  84. Get
  85. Return Me._schemaSerializationMode
  86. End Get
  87. Set
  88. Me._schemaSerializationMode = value
  89. End Set
  90. End Property
  91. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  92. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  93. Global.System.ComponentModel.DesignerSerializationVisibilityAttribute(Global.System.ComponentModel.DesignerSerializationVisibility.Hidden)> _
  94. Public Shadows ReadOnly Property Tables() As Global.System.Data.DataTableCollection
  95. Get
  96. Return MyBase.Tables
  97. End Get
  98. End Property
  99. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  100. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  101. Global.System.ComponentModel.DesignerSerializationVisibilityAttribute(Global.System.ComponentModel.DesignerSerializationVisibility.Hidden)> _
  102. Public Shadows ReadOnly Property Relations() As Global.System.Data.DataRelationCollection
  103. Get
  104. Return MyBase.Relations
  105. End Get
  106. End Property
  107. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  108. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  109. Protected Overrides Sub InitializeDerivedDataSet()
  110. Me.BeginInit
  111. Me.InitClass
  112. Me.EndInit
  113. End Sub
  114. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  115. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  116. Public Overrides Function Clone() As Global.System.Data.DataSet
  117. Dim cln As InversionesDEVDataSet3 = CType(MyBase.Clone,InversionesDEVDataSet3)
  118. cln.InitVars
  119. cln.SchemaSerializationMode = Me.SchemaSerializationMode
  120. Return cln
  121. End Function
  122. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  123. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  124. Protected Overrides Function ShouldSerializeTables() As Boolean
  125. Return false
  126. End Function
  127. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  128. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  129. Protected Overrides Function ShouldSerializeRelations() As Boolean
  130. Return false
  131. End Function
  132. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  133. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  134. Protected Overrides Sub ReadXmlSerializable(ByVal reader As Global.System.Xml.XmlReader)
  135. If (Me.DetermineSchemaSerializationMode(reader) = Global.System.Data.SchemaSerializationMode.IncludeSchema) Then
  136. Me.Reset
  137. Dim ds As Global.System.Data.DataSet = New Global.System.Data.DataSet()
  138. ds.ReadXml(reader)
  139. If (Not (ds.Tables("BAN1")) Is Nothing) Then
  140. MyBase.Tables.Add(New BAN1DataTable(ds.Tables("BAN1")))
  141. End If
  142. Me.DataSetName = ds.DataSetName
  143. Me.Prefix = ds.Prefix
  144. Me.Namespace = ds.Namespace
  145. Me.Locale = ds.Locale
  146. Me.CaseSensitive = ds.CaseSensitive
  147. Me.EnforceConstraints = ds.EnforceConstraints
  148. Me.Merge(ds, false, Global.System.Data.MissingSchemaAction.Add)
  149. Me.InitVars
  150. Else
  151. Me.ReadXml(reader)
  152. Me.InitVars
  153. End If
  154. End Sub
  155. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  156. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  157. Protected Overrides Function GetSchemaSerializable() As Global.System.Xml.Schema.XmlSchema
  158. Dim stream As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  159. Me.WriteXmlSchema(New Global.System.Xml.XmlTextWriter(stream, Nothing))
  160. stream.Position = 0
  161. Return Global.System.Xml.Schema.XmlSchema.Read(New Global.System.Xml.XmlTextReader(stream), Nothing)
  162. End Function
  163. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  164. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  165. Friend Overloads Sub InitVars()
  166. Me.InitVars(true)
  167. End Sub
  168. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  169. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  170. Friend Overloads Sub InitVars(ByVal initTable As Boolean)
  171. Me.tableBAN1 = CType(MyBase.Tables("BAN1"),BAN1DataTable)
  172. If (initTable = true) Then
  173. If (Not (Me.tableBAN1) Is Nothing) Then
  174. Me.tableBAN1.InitVars
  175. End If
  176. End If
  177. End Sub
  178. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  179. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  180. Private Sub InitClass()
  181. Me.DataSetName = "InversionesDEVDataSet3"
  182. Me.Prefix = ""
  183. Me.Namespace = "http://tempuri.org/InversionesDEVDataSet3.xsd"
  184. Me.EnforceConstraints = true
  185. Me.SchemaSerializationMode = Global.System.Data.SchemaSerializationMode.IncludeSchema
  186. Me.tableBAN1 = New BAN1DataTable()
  187. MyBase.Tables.Add(Me.tableBAN1)
  188. End Sub
  189. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  190. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  191. Private Function ShouldSerializeBAN1() As Boolean
  192. Return false
  193. End Function
  194. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  195. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  196. Private Sub SchemaChanged(ByVal sender As Object, ByVal e As Global.System.ComponentModel.CollectionChangeEventArgs)
  197. If (e.Action = Global.System.ComponentModel.CollectionChangeAction.Remove) Then
  198. Me.InitVars
  199. End If
  200. End Sub
  201. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  202. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  203. Public Shared Function GetTypedDataSetSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType
  204. Dim ds As InversionesDEVDataSet3 = New InversionesDEVDataSet3()
  205. Dim type As Global.System.Xml.Schema.XmlSchemaComplexType = New Global.System.Xml.Schema.XmlSchemaComplexType()
  206. Dim sequence As Global.System.Xml.Schema.XmlSchemaSequence = New Global.System.Xml.Schema.XmlSchemaSequence()
  207. Dim any As Global.System.Xml.Schema.XmlSchemaAny = New Global.System.Xml.Schema.XmlSchemaAny()
  208. any.Namespace = ds.Namespace
  209. sequence.Items.Add(any)
  210. type.Particle = sequence
  211. Dim dsSchema As Global.System.Xml.Schema.XmlSchema = ds.GetSchemaSerializable
  212. If xs.Contains(dsSchema.TargetNamespace) Then
  213. Dim s1 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  214. Dim s2 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  215. Try
  216. Dim schema As Global.System.Xml.Schema.XmlSchema = Nothing
  217. dsSchema.Write(s1)
  218. Dim schemas As Global.System.Collections.IEnumerator = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator
  219. Do While schemas.MoveNext
  220. schema = CType(schemas.Current,Global.System.Xml.Schema.XmlSchema)
  221. s2.SetLength(0)
  222. schema.Write(s2)
  223. If (s1.Length = s2.Length) Then
  224. s1.Position = 0
  225. s2.Position = 0
  226. Do While ((s1.Position <> s1.Length) _
  227. AndAlso (s1.ReadByte = s2.ReadByte))
  228. Loop
  229. If (s1.Position = s1.Length) Then
  230. Return type
  231. End If
  232. End If
  233. Loop
  234. Finally
  235. If (Not (s1) Is Nothing) Then
  236. s1.Close
  237. End If
  238. If (Not (s2) Is Nothing) Then
  239. s2.Close
  240. End If
  241. End Try
  242. End If
  243. xs.Add(dsSchema)
  244. Return type
  245. End Function
  246. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  247. Public Delegate Sub BAN1RowChangeEventHandler(ByVal sender As Object, ByVal e As BAN1RowChangeEvent)
  248. '''<summary>
  249. '''Represents the strongly named DataTable class.
  250. '''</summary>
  251. <Global.System.Serializable(), _
  252. Global.System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")> _
  253. Partial Public Class BAN1DataTable
  254. Inherits Global.System.Data.TypedTableBase(Of BAN1Row)
  255. Private columnId As Global.System.Data.DataColumn
  256. Private columnCodBanco As Global.System.Data.DataColumn
  257. Private columnCodEmpr As Global.System.Data.DataColumn
  258. Private columnNumCuenta As Global.System.Data.DataColumn
  259. Private columnActivo As Global.System.Data.DataColumn
  260. Private columnNombreCuenta As Global.System.Data.DataColumn
  261. Private columnTipoCuenta As Global.System.Data.DataColumn
  262. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  263. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  264. Public Sub New()
  265. MyBase.New
  266. Me.TableName = "BAN1"
  267. Me.BeginInit
  268. Me.InitClass
  269. Me.EndInit
  270. End Sub
  271. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  272. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  273. Friend Sub New(ByVal table As Global.System.Data.DataTable)
  274. MyBase.New
  275. Me.TableName = table.TableName
  276. If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
  277. Me.CaseSensitive = table.CaseSensitive
  278. End If
  279. If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
  280. Me.Locale = table.Locale
  281. End If
  282. If (table.Namespace <> table.DataSet.Namespace) Then
  283. Me.Namespace = table.Namespace
  284. End If
  285. Me.Prefix = table.Prefix
  286. Me.MinimumCapacity = table.MinimumCapacity
  287. End Sub
  288. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  289. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  290. Protected Sub New(ByVal info As Global.System.Runtime.Serialization.SerializationInfo, ByVal context As Global.System.Runtime.Serialization.StreamingContext)
  291. MyBase.New(info, context)
  292. Me.InitVars
  293. End Sub
  294. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  295. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  296. Public ReadOnly Property IdColumn() As Global.System.Data.DataColumn
  297. Get
  298. Return Me.columnId
  299. End Get
  300. End Property
  301. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  302. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  303. Public ReadOnly Property CodBancoColumn() As Global.System.Data.DataColumn
  304. Get
  305. Return Me.columnCodBanco
  306. End Get
  307. End Property
  308. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  309. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  310. Public ReadOnly Property CodEmprColumn() As Global.System.Data.DataColumn
  311. Get
  312. Return Me.columnCodEmpr
  313. End Get
  314. End Property
  315. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  316. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  317. Public ReadOnly Property NumCuentaColumn() As Global.System.Data.DataColumn
  318. Get
  319. Return Me.columnNumCuenta
  320. End Get
  321. End Property
  322. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  323. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  324. Public ReadOnly Property ActivoColumn() As Global.System.Data.DataColumn
  325. Get
  326. Return Me.columnActivo
  327. End Get
  328. End Property
  329. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  330. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  331. Public ReadOnly Property NombreCuentaColumn() As Global.System.Data.DataColumn
  332. Get
  333. Return Me.columnNombreCuenta
  334. End Get
  335. End Property
  336. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  337. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  338. Public ReadOnly Property TipoCuentaColumn() As Global.System.Data.DataColumn
  339. Get
  340. Return Me.columnTipoCuenta
  341. End Get
  342. End Property
  343. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  344. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  345. Global.System.ComponentModel.Browsable(false)> _
  346. Public ReadOnly Property Count() As Integer
  347. Get
  348. Return Me.Rows.Count
  349. End Get
  350. End Property
  351. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  352. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  353. Public Default ReadOnly Property Item(ByVal index As Integer) As BAN1Row
  354. Get
  355. Return CType(Me.Rows(index),BAN1Row)
  356. End Get
  357. End Property
  358. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  359. Public Event BAN1RowChanging As BAN1RowChangeEventHandler
  360. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  361. Public Event BAN1RowChanged As BAN1RowChangeEventHandler
  362. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  363. Public Event BAN1RowDeleting As BAN1RowChangeEventHandler
  364. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  365. Public Event BAN1RowDeleted As BAN1RowChangeEventHandler
  366. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  367. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  368. Public Overloads Sub AddBAN1Row(ByVal row As BAN1Row)
  369. Me.Rows.Add(row)
  370. End Sub
  371. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  372. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  373. Public Overloads Function AddBAN1Row(ByVal CodBanco As String, ByVal CodEmpr As String, ByVal NumCuenta As String, ByVal Activo As Boolean, ByVal NombreCuenta As String, ByVal TipoCuenta As String) As BAN1Row
  374. Dim rowBAN1Row As BAN1Row = CType(Me.NewRow,BAN1Row)
  375. Dim columnValuesArray() As Object = New Object() {Nothing, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta}
  376. rowBAN1Row.ItemArray = columnValuesArray
  377. Me.Rows.Add(rowBAN1Row)
  378. Return rowBAN1Row
  379. End Function
  380. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  381. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  382. Public Overrides Function Clone() As Global.System.Data.DataTable
  383. Dim cln As BAN1DataTable = CType(MyBase.Clone,BAN1DataTable)
  384. cln.InitVars
  385. Return cln
  386. End Function
  387. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  388. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  389. Protected Overrides Function CreateInstance() As Global.System.Data.DataTable
  390. Return New BAN1DataTable()
  391. End Function
  392. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  393. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  394. Friend Sub InitVars()
  395. Me.columnId = MyBase.Columns("Id")
  396. Me.columnCodBanco = MyBase.Columns("CodBanco")
  397. Me.columnCodEmpr = MyBase.Columns("CodEmpr")
  398. Me.columnNumCuenta = MyBase.Columns("NumCuenta")
  399. Me.columnActivo = MyBase.Columns("Activo")
  400. Me.columnNombreCuenta = MyBase.Columns("NombreCuenta")
  401. Me.columnTipoCuenta = MyBase.Columns("TipoCuenta")
  402. End Sub
  403. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  404. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  405. Private Sub InitClass()
  406. Me.columnId = New Global.System.Data.DataColumn("Id", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
  407. MyBase.Columns.Add(Me.columnId)
  408. Me.columnCodBanco = New Global.System.Data.DataColumn("CodBanco", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  409. MyBase.Columns.Add(Me.columnCodBanco)
  410. Me.columnCodEmpr = New Global.System.Data.DataColumn("CodEmpr", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  411. MyBase.Columns.Add(Me.columnCodEmpr)
  412. Me.columnNumCuenta = New Global.System.Data.DataColumn("NumCuenta", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  413. MyBase.Columns.Add(Me.columnNumCuenta)
  414. Me.columnActivo = New Global.System.Data.DataColumn("Activo", GetType(Boolean), Nothing, Global.System.Data.MappingType.Element)
  415. MyBase.Columns.Add(Me.columnActivo)
  416. Me.columnNombreCuenta = New Global.System.Data.DataColumn("NombreCuenta", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  417. MyBase.Columns.Add(Me.columnNombreCuenta)
  418. Me.columnTipoCuenta = New Global.System.Data.DataColumn("TipoCuenta", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  419. MyBase.Columns.Add(Me.columnTipoCuenta)
  420. Me.columnId.AutoIncrement = true
  421. Me.columnId.AutoIncrementSeed = -1
  422. Me.columnId.AutoIncrementStep = -1
  423. Me.columnId.AllowDBNull = false
  424. Me.columnId.ReadOnly = true
  425. Me.columnCodBanco.MaxLength = 30
  426. Me.columnCodEmpr.MaxLength = 10
  427. Me.columnNumCuenta.MaxLength = 50
  428. Me.columnNombreCuenta.MaxLength = 100
  429. Me.columnTipoCuenta.MaxLength = 10
  430. End Sub
  431. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  432. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  433. Public Function NewBAN1Row() As BAN1Row
  434. Return CType(Me.NewRow,BAN1Row)
  435. End Function
  436. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  437. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  438. Protected Overrides Function NewRowFromBuilder(ByVal builder As Global.System.Data.DataRowBuilder) As Global.System.Data.DataRow
  439. Return New BAN1Row(builder)
  440. End Function
  441. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  442. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  443. Protected Overrides Function GetRowType() As Global.System.Type
  444. Return GetType(BAN1Row)
  445. End Function
  446. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  447. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  448. Protected Overrides Sub OnRowChanged(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  449. MyBase.OnRowChanged(e)
  450. If (Not (Me.BAN1RowChangedEvent) Is Nothing) Then
  451. RaiseEvent BAN1RowChanged(Me, New BAN1RowChangeEvent(CType(e.Row,BAN1Row), e.Action))
  452. End If
  453. End Sub
  454. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  455. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  456. Protected Overrides Sub OnRowChanging(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  457. MyBase.OnRowChanging(e)
  458. If (Not (Me.BAN1RowChangingEvent) Is Nothing) Then
  459. RaiseEvent BAN1RowChanging(Me, New BAN1RowChangeEvent(CType(e.Row,BAN1Row), e.Action))
  460. End If
  461. End Sub
  462. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  463. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  464. Protected Overrides Sub OnRowDeleted(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  465. MyBase.OnRowDeleted(e)
  466. If (Not (Me.BAN1RowDeletedEvent) Is Nothing) Then
  467. RaiseEvent BAN1RowDeleted(Me, New BAN1RowChangeEvent(CType(e.Row,BAN1Row), e.Action))
  468. End If
  469. End Sub
  470. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  471. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  472. Protected Overrides Sub OnRowDeleting(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  473. MyBase.OnRowDeleting(e)
  474. If (Not (Me.BAN1RowDeletingEvent) Is Nothing) Then
  475. RaiseEvent BAN1RowDeleting(Me, New BAN1RowChangeEvent(CType(e.Row,BAN1Row), e.Action))
  476. End If
  477. End Sub
  478. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  479. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  480. Public Sub RemoveBAN1Row(ByVal row As BAN1Row)
  481. Me.Rows.Remove(row)
  482. End Sub
  483. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  484. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  485. Public Shared Function GetTypedTableSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType
  486. Dim type As Global.System.Xml.Schema.XmlSchemaComplexType = New Global.System.Xml.Schema.XmlSchemaComplexType()
  487. Dim sequence As Global.System.Xml.Schema.XmlSchemaSequence = New Global.System.Xml.Schema.XmlSchemaSequence()
  488. Dim ds As InversionesDEVDataSet3 = New InversionesDEVDataSet3()
  489. Dim any1 As Global.System.Xml.Schema.XmlSchemaAny = New Global.System.Xml.Schema.XmlSchemaAny()
  490. any1.Namespace = "http://www.w3.org/2001/XMLSchema"
  491. any1.MinOccurs = New Decimal(0)
  492. any1.MaxOccurs = Decimal.MaxValue
  493. any1.ProcessContents = Global.System.Xml.Schema.XmlSchemaContentProcessing.Lax
  494. sequence.Items.Add(any1)
  495. Dim any2 As Global.System.Xml.Schema.XmlSchemaAny = New Global.System.Xml.Schema.XmlSchemaAny()
  496. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
  497. any2.MinOccurs = New Decimal(1)
  498. any2.ProcessContents = Global.System.Xml.Schema.XmlSchemaContentProcessing.Lax
  499. sequence.Items.Add(any2)
  500. Dim attribute1 As Global.System.Xml.Schema.XmlSchemaAttribute = New Global.System.Xml.Schema.XmlSchemaAttribute()
  501. attribute1.Name = "namespace"
  502. attribute1.FixedValue = ds.Namespace
  503. type.Attributes.Add(attribute1)
  504. Dim attribute2 As Global.System.Xml.Schema.XmlSchemaAttribute = New Global.System.Xml.Schema.XmlSchemaAttribute()
  505. attribute2.Name = "tableTypeName"
  506. attribute2.FixedValue = "BAN1DataTable"
  507. type.Attributes.Add(attribute2)
  508. type.Particle = sequence
  509. Dim dsSchema As Global.System.Xml.Schema.XmlSchema = ds.GetSchemaSerializable
  510. If xs.Contains(dsSchema.TargetNamespace) Then
  511. Dim s1 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  512. Dim s2 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  513. Try
  514. Dim schema As Global.System.Xml.Schema.XmlSchema = Nothing
  515. dsSchema.Write(s1)
  516. Dim schemas As Global.System.Collections.IEnumerator = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator
  517. Do While schemas.MoveNext
  518. schema = CType(schemas.Current,Global.System.Xml.Schema.XmlSchema)
  519. s2.SetLength(0)
  520. schema.Write(s2)
  521. If (s1.Length = s2.Length) Then
  522. s1.Position = 0
  523. s2.Position = 0
  524. Do While ((s1.Position <> s1.Length) _
  525. AndAlso (s1.ReadByte = s2.ReadByte))
  526. Loop
  527. If (s1.Position = s1.Length) Then
  528. Return type
  529. End If
  530. End If
  531. Loop
  532. Finally
  533. If (Not (s1) Is Nothing) Then
  534. s1.Close
  535. End If
  536. If (Not (s2) Is Nothing) Then
  537. s2.Close
  538. End If
  539. End Try
  540. End If
  541. xs.Add(dsSchema)
  542. Return type
  543. End Function
  544. End Class
  545. '''<summary>
  546. '''Represents strongly named DataRow class.
  547. '''</summary>
  548. Partial Public Class BAN1Row
  549. Inherits Global.System.Data.DataRow
  550. Private tableBAN1 As BAN1DataTable
  551. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  552. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  553. Friend Sub New(ByVal rb As Global.System.Data.DataRowBuilder)
  554. MyBase.New(rb)
  555. Me.tableBAN1 = CType(Me.Table,BAN1DataTable)
  556. End Sub
  557. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  558. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  559. Public Property Id() As Integer
  560. Get
  561. Return CType(Me(Me.tableBAN1.IdColumn),Integer)
  562. End Get
  563. Set
  564. Me(Me.tableBAN1.IdColumn) = value
  565. End Set
  566. End Property
  567. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  568. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  569. Public Property CodBanco() As String
  570. Get
  571. Try
  572. Return CType(Me(Me.tableBAN1.CodBancoColumn),String)
  573. Catch e As Global.System.InvalidCastException
  574. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodBanco' de la tabla 'BAN1' es DBNull.", e)
  575. End Try
  576. End Get
  577. Set
  578. Me(Me.tableBAN1.CodBancoColumn) = value
  579. End Set
  580. End Property
  581. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  582. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  583. Public Property CodEmpr() As String
  584. Get
  585. Try
  586. Return CType(Me(Me.tableBAN1.CodEmprColumn),String)
  587. Catch e As Global.System.InvalidCastException
  588. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodEmpr' de la tabla 'BAN1' es DBNull.", e)
  589. End Try
  590. End Get
  591. Set
  592. Me(Me.tableBAN1.CodEmprColumn) = value
  593. End Set
  594. End Property
  595. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  596. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  597. Public Property NumCuenta() As String
  598. Get
  599. Try
  600. Return CType(Me(Me.tableBAN1.NumCuentaColumn),String)
  601. Catch e As Global.System.InvalidCastException
  602. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'NumCuenta' de la tabla 'BAN1' es DBNull.", e)
  603. End Try
  604. End Get
  605. Set
  606. Me(Me.tableBAN1.NumCuentaColumn) = value
  607. End Set
  608. End Property
  609. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  610. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  611. Public Property Activo() As Boolean
  612. Get
  613. Try
  614. Return CType(Me(Me.tableBAN1.ActivoColumn),Boolean)
  615. Catch e As Global.System.InvalidCastException
  616. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Activo' de la tabla 'BAN1' es DBNull.", e)
  617. End Try
  618. End Get
  619. Set
  620. Me(Me.tableBAN1.ActivoColumn) = value
  621. End Set
  622. End Property
  623. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  624. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  625. Public Property NombreCuenta() As String
  626. Get
  627. Try
  628. Return CType(Me(Me.tableBAN1.NombreCuentaColumn),String)
  629. Catch e As Global.System.InvalidCastException
  630. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'NombreCuenta' de la tabla 'BAN1' es DBNull.", e)
  631. End Try
  632. End Get
  633. Set
  634. Me(Me.tableBAN1.NombreCuentaColumn) = value
  635. End Set
  636. End Property
  637. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  638. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  639. Public Property TipoCuenta() As String
  640. Get
  641. Try
  642. Return CType(Me(Me.tableBAN1.TipoCuentaColumn),String)
  643. Catch e As Global.System.InvalidCastException
  644. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'TipoCuenta' de la tabla 'BAN1' es DBNull.", e)
  645. End Try
  646. End Get
  647. Set
  648. Me(Me.tableBAN1.TipoCuentaColumn) = value
  649. End Set
  650. End Property
  651. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  652. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  653. Public Function IsCodBancoNull() As Boolean
  654. Return Me.IsNull(Me.tableBAN1.CodBancoColumn)
  655. End Function
  656. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  657. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  658. Public Sub SetCodBancoNull()
  659. Me(Me.tableBAN1.CodBancoColumn) = Global.System.Convert.DBNull
  660. End Sub
  661. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  662. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  663. Public Function IsCodEmprNull() As Boolean
  664. Return Me.IsNull(Me.tableBAN1.CodEmprColumn)
  665. End Function
  666. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  667. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  668. Public Sub SetCodEmprNull()
  669. Me(Me.tableBAN1.CodEmprColumn) = Global.System.Convert.DBNull
  670. End Sub
  671. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  672. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  673. Public Function IsNumCuentaNull() As Boolean
  674. Return Me.IsNull(Me.tableBAN1.NumCuentaColumn)
  675. End Function
  676. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  677. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  678. Public Sub SetNumCuentaNull()
  679. Me(Me.tableBAN1.NumCuentaColumn) = Global.System.Convert.DBNull
  680. End Sub
  681. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  682. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  683. Public Function IsActivoNull() As Boolean
  684. Return Me.IsNull(Me.tableBAN1.ActivoColumn)
  685. End Function
  686. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  687. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  688. Public Sub SetActivoNull()
  689. Me(Me.tableBAN1.ActivoColumn) = Global.System.Convert.DBNull
  690. End Sub
  691. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  692. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  693. Public Function IsNombreCuentaNull() As Boolean
  694. Return Me.IsNull(Me.tableBAN1.NombreCuentaColumn)
  695. End Function
  696. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  697. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  698. Public Sub SetNombreCuentaNull()
  699. Me(Me.tableBAN1.NombreCuentaColumn) = Global.System.Convert.DBNull
  700. End Sub
  701. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  702. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  703. Public Function IsTipoCuentaNull() As Boolean
  704. Return Me.IsNull(Me.tableBAN1.TipoCuentaColumn)
  705. End Function
  706. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  707. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  708. Public Sub SetTipoCuentaNull()
  709. Me(Me.tableBAN1.TipoCuentaColumn) = Global.System.Convert.DBNull
  710. End Sub
  711. End Class
  712. '''<summary>
  713. '''Row event argument class
  714. '''</summary>
  715. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  716. Public Class BAN1RowChangeEvent
  717. Inherits Global.System.EventArgs
  718. Private eventRow As BAN1Row
  719. Private eventAction As Global.System.Data.DataRowAction
  720. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  721. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  722. Public Sub New(ByVal row As BAN1Row, ByVal action As Global.System.Data.DataRowAction)
  723. MyBase.New
  724. Me.eventRow = row
  725. Me.eventAction = action
  726. End Sub
  727. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  728. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  729. Public ReadOnly Property Row() As BAN1Row
  730. Get
  731. Return Me.eventRow
  732. End Get
  733. End Property
  734. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  735. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  736. Public ReadOnly Property Action() As Global.System.Data.DataRowAction
  737. Get
  738. Return Me.eventAction
  739. End Get
  740. End Property
  741. End Class
  742. End Class
  743. Namespace InversionesDEVDataSet3TableAdapters
  744. '''<summary>
  745. '''Represents the connection and commands used to retrieve and save data.
  746. '''</summary>
  747. <Global.System.ComponentModel.DesignerCategoryAttribute("code"), _
  748. Global.System.ComponentModel.ToolboxItem(true), _
  749. Global.System.ComponentModel.DataObjectAttribute(true), _
  750. Global.System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner"& _
  751. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), _
  752. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  753. Partial Public Class BAN1TableAdapter
  754. Inherits Global.System.ComponentModel.Component
  755. Private WithEvents _adapter As Global.System.Data.SqlClient.SqlDataAdapter
  756. Private _connection As Global.System.Data.SqlClient.SqlConnection
  757. Private _transaction As Global.System.Data.SqlClient.SqlTransaction
  758. Private _commandCollection() As Global.System.Data.SqlClient.SqlCommand
  759. Private _clearBeforeFill As Boolean
  760. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  761. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  762. Public Sub New()
  763. MyBase.New
  764. Me.ClearBeforeFill = true
  765. End Sub
  766. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  767. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  768. Protected Friend ReadOnly Property Adapter() As Global.System.Data.SqlClient.SqlDataAdapter
  769. Get
  770. If (Me._adapter Is Nothing) Then
  771. Me.InitAdapter
  772. End If
  773. Return Me._adapter
  774. End Get
  775. End Property
  776. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  777. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  778. Friend Property Connection() As Global.System.Data.SqlClient.SqlConnection
  779. Get
  780. If (Me._connection Is Nothing) Then
  781. Me.InitConnection
  782. End If
  783. Return Me._connection
  784. End Get
  785. Set
  786. Me._connection = value
  787. If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
  788. Me.Adapter.InsertCommand.Connection = value
  789. End If
  790. If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
  791. Me.Adapter.DeleteCommand.Connection = value
  792. End If
  793. If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
  794. Me.Adapter.UpdateCommand.Connection = value
  795. End If
  796. Dim i As Integer = 0
  797. Do While (i < Me.CommandCollection.Length)
  798. If (Not (Me.CommandCollection(i)) Is Nothing) Then
  799. CType(Me.CommandCollection(i),Global.System.Data.SqlClient.SqlCommand).Connection = value
  800. End If
  801. i = (i + 1)
  802. Loop
  803. End Set
  804. End Property
  805. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  806. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  807. Friend Property Transaction() As Global.System.Data.SqlClient.SqlTransaction
  808. Get
  809. Return Me._transaction
  810. End Get
  811. Set
  812. Me._transaction = value
  813. Dim i As Integer = 0
  814. Do While (i < Me.CommandCollection.Length)
  815. Me.CommandCollection(i).Transaction = Me._transaction
  816. i = (i + 1)
  817. Loop
  818. If ((Not (Me.Adapter) Is Nothing) _
  819. AndAlso (Not (Me.Adapter.DeleteCommand) Is Nothing)) Then
  820. Me.Adapter.DeleteCommand.Transaction = Me._transaction
  821. End If
  822. If ((Not (Me.Adapter) Is Nothing) _
  823. AndAlso (Not (Me.Adapter.InsertCommand) Is Nothing)) Then
  824. Me.Adapter.InsertCommand.Transaction = Me._transaction
  825. End If
  826. If ((Not (Me.Adapter) Is Nothing) _
  827. AndAlso (Not (Me.Adapter.UpdateCommand) Is Nothing)) Then
  828. Me.Adapter.UpdateCommand.Transaction = Me._transaction
  829. End If
  830. End Set
  831. End Property
  832. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  833. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  834. Protected ReadOnly Property CommandCollection() As Global.System.Data.SqlClient.SqlCommand()
  835. Get
  836. If (Me._commandCollection Is Nothing) Then
  837. Me.InitCommandCollection
  838. End If
  839. Return Me._commandCollection
  840. End Get
  841. End Property
  842. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  843. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  844. Public Property ClearBeforeFill() As Boolean
  845. Get
  846. Return Me._clearBeforeFill
  847. End Get
  848. Set
  849. Me._clearBeforeFill = value
  850. End Set
  851. End Property
  852. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  853. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  854. Private Sub InitAdapter()
  855. Me._adapter = New Global.System.Data.SqlClient.SqlDataAdapter()
  856. Dim tableMapping As Global.System.Data.Common.DataTableMapping = New Global.System.Data.Common.DataTableMapping()
  857. tableMapping.SourceTable = "Table"
  858. tableMapping.DataSetTable = "BAN1"
  859. tableMapping.ColumnMappings.Add("Id", "Id")
  860. tableMapping.ColumnMappings.Add("CodBanco", "CodBanco")
  861. tableMapping.ColumnMappings.Add("CodEmpr", "CodEmpr")
  862. tableMapping.ColumnMappings.Add("NumCuenta", "NumCuenta")
  863. tableMapping.ColumnMappings.Add("Activo", "Activo")
  864. tableMapping.ColumnMappings.Add("NombreCuenta", "NombreCuenta")
  865. tableMapping.ColumnMappings.Add("TipoCuenta", "TipoCuenta")
  866. Me._adapter.TableMappings.Add(tableMapping)
  867. Me._adapter.InsertCommand = New Global.System.Data.SqlClient.SqlCommand()
  868. Me._adapter.InsertCommand.Connection = Me.Connection
  869. Me._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[BAN1] ([CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCu"& _
  870. "enta], [TipoCuenta]) VALUES (@CodBanco, @CodEmpr, @NumCuenta, @Activo, @NombreCu"& _
  871. "enta, @TipoCuenta)"
  872. Me._adapter.InsertCommand.CommandType = Global.System.Data.CommandType.Text
  873. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodBanco", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodBanco", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  874. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodEmpr", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmpr", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  875. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@NumCuenta", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "NumCuenta", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  876. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Activo", Global.System.Data.SqlDbType.Bit, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Activo", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  877. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@NombreCuenta", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "NombreCuenta", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  878. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@TipoCuenta", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoCuenta", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  879. End Sub
  880. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  881. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  882. Private Sub InitConnection()
  883. Me._connection = New Global.System.Data.SqlClient.SqlConnection()
  884. Me._connection.ConnectionString = Global.Inversiones.My.MySettings.Default.InversionesConnectionString
  885. End Sub
  886. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  887. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  888. Private Sub InitCommandCollection()
  889. Me._commandCollection = New Global.System.Data.SqlClient.SqlCommand(0) {}
  890. Me._commandCollection(0) = New Global.System.Data.SqlClient.SqlCommand()
  891. Me._commandCollection(0).Connection = Me.Connection
  892. Me._commandCollection(0).CommandText = "SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta FROM db"& _
  893. "o.BAN1"
  894. Me._commandCollection(0).CommandType = Global.System.Data.CommandType.Text
  895. End Sub
  896. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  897. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  898. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  899. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Fill, true)> _
  900. Public Overloads Overridable Function Fill(ByVal dataTable As InversionesDEVDataSet3.BAN1DataTable) As Integer
  901. Me.Adapter.SelectCommand = Me.CommandCollection(0)
  902. If (Me.ClearBeforeFill = true) Then
  903. dataTable.Clear
  904. End If
  905. Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
  906. Return returnValue
  907. End Function
  908. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  909. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  910. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  911. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.[Select], true)> _
  912. Public Overloads Overridable Function GetData() As InversionesDEVDataSet3.BAN1DataTable
  913. Me.Adapter.SelectCommand = Me.CommandCollection(0)
  914. Dim dataTable As InversionesDEVDataSet3.BAN1DataTable = New InversionesDEVDataSet3.BAN1DataTable()
  915. Me.Adapter.Fill(dataTable)
  916. Return dataTable
  917. End Function
  918. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  919. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  920. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  921. Public Overloads Overridable Function Update(ByVal dataTable As InversionesDEVDataSet3.BAN1DataTable) As Integer
  922. Return Me.Adapter.Update(dataTable)
  923. End Function
  924. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  925. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  926. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  927. Public Overloads Overridable Function Update(ByVal dataSet As InversionesDEVDataSet3) As Integer
  928. Return Me.Adapter.Update(dataSet, "BAN1")
  929. End Function
  930. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  931. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  932. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  933. Public Overloads Overridable Function Update(ByVal dataRow As Global.System.Data.DataRow) As Integer
  934. Return Me.Adapter.Update(New Global.System.Data.DataRow() {dataRow})
  935. End Function
  936. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  937. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  938. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  939. Public Overloads Overridable Function Update(ByVal dataRows() As Global.System.Data.DataRow) As Integer
  940. Return Me.Adapter.Update(dataRows)
  941. End Function
  942. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  943. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  944. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  945. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Insert, true)> _
  946. Public Overloads Overridable Function Insert(ByVal CodBanco As String, ByVal CodEmpr As String, ByVal NumCuenta As String, ByVal Activo As Global.System.Nullable(Of Boolean), ByVal NombreCuenta As String, ByVal TipoCuenta As String) As Integer
  947. If (CodBanco Is Nothing) Then
  948. Me.Adapter.InsertCommand.Parameters(0).Value = Global.System.DBNull.Value
  949. Else
  950. Me.Adapter.InsertCommand.Parameters(0).Value = CType(CodBanco,String)
  951. End If
  952. If (CodEmpr Is Nothing) Then
  953. Me.Adapter.InsertCommand.Parameters(1).Value = Global.System.DBNull.Value
  954. Else
  955. Me.Adapter.InsertCommand.Parameters(1).Value = CType(CodEmpr,String)
  956. End If
  957. If (NumCuenta Is Nothing) Then
  958. Me.Adapter.InsertCommand.Parameters(2).Value = Global.System.DBNull.Value
  959. Else
  960. Me.Adapter.InsertCommand.Parameters(2).Value = CType(NumCuenta,String)
  961. End If
  962. If (Activo.HasValue = true) Then
  963. Me.Adapter.InsertCommand.Parameters(3).Value = CType(Activo.Value,Boolean)
  964. Else
  965. Me.Adapter.InsertCommand.Parameters(3).Value = Global.System.DBNull.Value
  966. End If
  967. If (NombreCuenta Is Nothing) Then
  968. Me.Adapter.InsertCommand.Parameters(4).Value = Global.System.DBNull.Value
  969. Else
  970. Me.Adapter.InsertCommand.Parameters(4).Value = CType(NombreCuenta,String)
  971. End If
  972. If (TipoCuenta Is Nothing) Then
  973. Me.Adapter.InsertCommand.Parameters(5).Value = Global.System.DBNull.Value
  974. Else
  975. Me.Adapter.InsertCommand.Parameters(5).Value = CType(TipoCuenta,String)
  976. End If
  977. Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
  978. If ((Me.Adapter.InsertCommand.Connection.State And Global.System.Data.ConnectionState.Open) _
  979. <> Global.System.Data.ConnectionState.Open) Then
  980. Me.Adapter.InsertCommand.Connection.Open
  981. End If
  982. Try
  983. Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
  984. Return returnValue
  985. Finally
  986. If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Then
  987. Me.Adapter.InsertCommand.Connection.Close
  988. End If
  989. End Try
  990. End Function
  991. End Class
  992. '''<summary>
  993. '''TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  994. '''</summary>
  995. <Global.System.ComponentModel.DesignerCategoryAttribute("code"), _
  996. Global.System.ComponentModel.ToolboxItem(true), _
  997. Global.System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD"& _
  998. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), _
  999. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")> _
  1000. Partial Public Class TableAdapterManager
  1001. Inherits Global.System.ComponentModel.Component
  1002. Private _updateOrder As UpdateOrderOption
  1003. Private _bAN1TableAdapter As BAN1TableAdapter
  1004. Private _backupDataSetBeforeUpdate As Boolean
  1005. Private _connection As Global.System.Data.IDbConnection
  1006. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1007. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1008. Public Property UpdateOrder() As UpdateOrderOption
  1009. Get
  1010. Return Me._updateOrder
  1011. End Get
  1012. Set
  1013. Me._updateOrder = value
  1014. End Set
  1015. End Property
  1016. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1017. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  1018. Global.System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso"& _
  1019. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3"& _
  1020. "a", "System.Drawing.Design.UITypeEditor")> _
  1021. Public Property BAN1TableAdapter() As BAN1TableAdapter
  1022. Get
  1023. Return Me._bAN1TableAdapter
  1024. End Get
  1025. Set
  1026. Me._bAN1TableAdapter = value
  1027. End Set
  1028. End Property
  1029. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1030. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1031. Public Property BackupDataSetBeforeUpdate() As Boolean
  1032. Get
  1033. Return Me._backupDataSetBeforeUpdate
  1034. End Get
  1035. Set
  1036. Me._backupDataSetBeforeUpdate = value
  1037. End Set
  1038. End Property
  1039. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1040. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  1041. Global.System.ComponentModel.Browsable(false)> _
  1042. Public Property Connection() As Global.System.Data.IDbConnection
  1043. Get
  1044. If (Not (Me._connection) Is Nothing) Then
  1045. Return Me._connection
  1046. End If
  1047. If ((Not (Me._bAN1TableAdapter) Is Nothing) _
  1048. AndAlso (Not (Me._bAN1TableAdapter.Connection) Is Nothing)) Then
  1049. Return Me._bAN1TableAdapter.Connection
  1050. End If
  1051. Return Nothing
  1052. End Get
  1053. Set
  1054. Me._connection = value
  1055. End Set
  1056. End Property
  1057. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1058. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0"), _
  1059. Global.System.ComponentModel.Browsable(false)> _
  1060. Public ReadOnly Property TableAdapterInstanceCount() As Integer
  1061. Get
  1062. Dim count As Integer = 0
  1063. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1064. count = (count + 1)
  1065. End If
  1066. Return count
  1067. End Get
  1068. End Property
  1069. '''<summary>
  1070. '''Update rows in top-down order.
  1071. '''</summary>
  1072. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1073. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1074. Private Function UpdateUpdatedRows(ByVal dataSet As InversionesDEVDataSet3, ByVal allChangedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow), ByVal allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Integer
  1075. Dim result As Integer = 0
  1076. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1077. Dim updatedRows() As Global.System.Data.DataRow = dataSet.BAN1.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.ModifiedCurrent)
  1078. updatedRows = Me.GetRealUpdatedRows(updatedRows, allAddedRows)
  1079. If ((Not (updatedRows) Is Nothing) _
  1080. AndAlso (0 < updatedRows.Length)) Then
  1081. result = (result + Me._bAN1TableAdapter.Update(updatedRows))
  1082. allChangedRows.AddRange(updatedRows)
  1083. End If
  1084. End If
  1085. Return result
  1086. End Function
  1087. '''<summary>
  1088. '''Insert rows in top-down order.
  1089. '''</summary>
  1090. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1091. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1092. Private Function UpdateInsertedRows(ByVal dataSet As InversionesDEVDataSet3, ByVal allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Integer
  1093. Dim result As Integer = 0
  1094. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1095. Dim addedRows() As Global.System.Data.DataRow = dataSet.BAN1.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.Added)
  1096. If ((Not (addedRows) Is Nothing) _
  1097. AndAlso (0 < addedRows.Length)) Then
  1098. result = (result + Me._bAN1TableAdapter.Update(addedRows))
  1099. allAddedRows.AddRange(addedRows)
  1100. End If
  1101. End If
  1102. Return result
  1103. End Function
  1104. '''<summary>
  1105. '''Delete rows in bottom-up order.
  1106. '''</summary>
  1107. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1108. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1109. Private Function UpdateDeletedRows(ByVal dataSet As InversionesDEVDataSet3, ByVal allChangedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Integer
  1110. Dim result As Integer = 0
  1111. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1112. Dim deletedRows() As Global.System.Data.DataRow = dataSet.BAN1.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.Deleted)
  1113. If ((Not (deletedRows) Is Nothing) _
  1114. AndAlso (0 < deletedRows.Length)) Then
  1115. result = (result + Me._bAN1TableAdapter.Update(deletedRows))
  1116. allChangedRows.AddRange(deletedRows)
  1117. End If
  1118. End If
  1119. Return result
  1120. End Function
  1121. '''<summary>
  1122. '''Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  1123. '''</summary>
  1124. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1125. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1126. Private Function GetRealUpdatedRows(ByVal updatedRows() As Global.System.Data.DataRow, ByVal allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Global.System.Data.DataRow()
  1127. If ((updatedRows Is Nothing) _
  1128. OrElse (updatedRows.Length < 1)) Then
  1129. Return updatedRows
  1130. End If
  1131. If ((allAddedRows Is Nothing) _
  1132. OrElse (allAddedRows.Count < 1)) Then
  1133. Return updatedRows
  1134. End If
  1135. Dim realUpdatedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  1136. Dim i As Integer = 0
  1137. Do While (i < updatedRows.Length)
  1138. Dim row As Global.System.Data.DataRow = updatedRows(i)
  1139. If (allAddedRows.Contains(row) = false) Then
  1140. realUpdatedRows.Add(row)
  1141. End If
  1142. i = (i + 1)
  1143. Loop
  1144. Return realUpdatedRows.ToArray
  1145. End Function
  1146. '''<summary>
  1147. '''Update all changes to the dataset.
  1148. '''</summary>
  1149. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1150. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1151. Public Overridable Function UpdateAll(ByVal dataSet As InversionesDEVDataSet3) As Integer
  1152. If (dataSet Is Nothing) Then
  1153. Throw New Global.System.ArgumentNullException("dataSet")
  1154. End If
  1155. If (dataSet.HasChanges = false) Then
  1156. Return 0
  1157. End If
  1158. If ((Not (Me._bAN1TableAdapter) Is Nothing) _
  1159. AndAlso (Me.MatchTableAdapterConnection(Me._bAN1TableAdapter.Connection) = false)) Then
  1160. Throw New Global.System.ArgumentException("Todos los TableAdapters administrados por un TableAdapterManager deben usar la mi"& _
  1161. "sma cadena de conexión.")
  1162. End If
  1163. Dim workConnection As Global.System.Data.IDbConnection = Me.Connection
  1164. If (workConnection Is Nothing) Then
  1165. Throw New Global.System.ApplicationException("TableAdapterManager no contiene información de conexión. Establezca cada propieda"& _
  1166. "d TableAdapterManager TableAdapter en una instancia TableAdapter válida.")
  1167. End If
  1168. Dim workConnOpened As Boolean = false
  1169. If ((workConnection.State And Global.System.Data.ConnectionState.Broken) _
  1170. = Global.System.Data.ConnectionState.Broken) Then
  1171. workConnection.Close
  1172. End If
  1173. If (workConnection.State = Global.System.Data.ConnectionState.Closed) Then
  1174. workConnection.Open
  1175. workConnOpened = true
  1176. End If
  1177. Dim workTransaction As Global.System.Data.IDbTransaction = workConnection.BeginTransaction
  1178. If (workTransaction Is Nothing) Then
  1179. Throw New Global.System.ApplicationException("La transacción no puede comenzar. La conexión de datos actual no es compatible co"& _
  1180. "n las transacciones o el estado actual no permite que comience la transacción.")
  1181. End If
  1182. Dim allChangedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  1183. Dim allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  1184. Dim adaptersWithAcceptChangesDuringUpdate As Global.System.Collections.Generic.List(Of Global.System.Data.Common.DataAdapter) = New Global.System.Collections.Generic.List(Of Global.System.Data.Common.DataAdapter)()
  1185. Dim revertConnections As Global.System.Collections.Generic.Dictionary(Of Object, Global.System.Data.IDbConnection) = New Global.System.Collections.Generic.Dictionary(Of Object, Global.System.Data.IDbConnection)()
  1186. Dim result As Integer = 0
  1187. Dim backupDataSet As Global.System.Data.DataSet = Nothing
  1188. If Me.BackupDataSetBeforeUpdate Then
  1189. backupDataSet = New Global.System.Data.DataSet()
  1190. backupDataSet.Merge(dataSet)
  1191. End If
  1192. Try
  1193. '---- Prepare for update -----------
  1194. '
  1195. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1196. revertConnections.Add(Me._bAN1TableAdapter, Me._bAN1TableAdapter.Connection)
  1197. Me._bAN1TableAdapter.Connection = CType(workConnection,Global.System.Data.SqlClient.SqlConnection)
  1198. Me._bAN1TableAdapter.Transaction = CType(workTransaction,Global.System.Data.SqlClient.SqlTransaction)
  1199. If Me._bAN1TableAdapter.Adapter.AcceptChangesDuringUpdate Then
  1200. Me._bAN1TableAdapter.Adapter.AcceptChangesDuringUpdate = false
  1201. adaptersWithAcceptChangesDuringUpdate.Add(Me._bAN1TableAdapter.Adapter)
  1202. End If
  1203. End If
  1204. '
  1205. '---- Perform updates -----------
  1206. '
  1207. If (Me.UpdateOrder = UpdateOrderOption.UpdateInsertDelete) Then
  1208. result = (result + Me.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows))
  1209. result = (result + Me.UpdateInsertedRows(dataSet, allAddedRows))
  1210. Else
  1211. result = (result + Me.UpdateInsertedRows(dataSet, allAddedRows))
  1212. result = (result + Me.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows))
  1213. End If
  1214. result = (result + Me.UpdateDeletedRows(dataSet, allChangedRows))
  1215. '
  1216. '---- Commit updates -----------
  1217. '
  1218. workTransaction.Commit
  1219. If (0 < allAddedRows.Count) Then
  1220. Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
  1221. allAddedRows.CopyTo(rows)
  1222. Dim i As Integer = 0
  1223. Do While (i < rows.Length)
  1224. Dim row As Global.System.Data.DataRow = rows(i)
  1225. row.AcceptChanges
  1226. i = (i + 1)
  1227. Loop
  1228. End If
  1229. If (0 < allChangedRows.Count) Then
  1230. Dim rows((allChangedRows.Count) - 1) As Global.System.Data.DataRow
  1231. allChangedRows.CopyTo(rows)
  1232. Dim i As Integer = 0
  1233. Do While (i < rows.Length)
  1234. Dim row As Global.System.Data.DataRow = rows(i)
  1235. row.AcceptChanges
  1236. i = (i + 1)
  1237. Loop
  1238. End If
  1239. Catch ex As Global.System.Exception
  1240. workTransaction.Rollback
  1241. '---- Restore the dataset -----------
  1242. If Me.BackupDataSetBeforeUpdate Then
  1243. Global.System.Diagnostics.Debug.Assert((Not (backupDataSet) Is Nothing))
  1244. dataSet.Clear
  1245. dataSet.Merge(backupDataSet)
  1246. Else
  1247. If (0 < allAddedRows.Count) Then
  1248. Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
  1249. allAddedRows.CopyTo(rows)
  1250. Dim i As Integer = 0
  1251. Do While (i < rows.Length)
  1252. Dim row As Global.System.Data.DataRow = rows(i)
  1253. row.AcceptChanges
  1254. row.SetAdded
  1255. i = (i + 1)
  1256. Loop
  1257. End If
  1258. End If
  1259. Throw ex
  1260. Finally
  1261. If workConnOpened Then
  1262. workConnection.Close
  1263. End If
  1264. If (Not (Me._bAN1TableAdapter) Is Nothing) Then
  1265. Me._bAN1TableAdapter.Connection = CType(revertConnections(Me._bAN1TableAdapter),Global.System.Data.SqlClient.SqlConnection)
  1266. Me._bAN1TableAdapter.Transaction = Nothing
  1267. End If
  1268. If (0 < adaptersWithAcceptChangesDuringUpdate.Count) Then
  1269. Dim adapters((adaptersWithAcceptChangesDuringUpdate.Count) - 1) As Global.System.Data.Common.DataAdapter
  1270. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters)
  1271. Dim i As Integer = 0
  1272. Do While (i < adapters.Length)
  1273. Dim adapter As Global.System.Data.Common.DataAdapter = adapters(i)
  1274. adapter.AcceptChangesDuringUpdate = true
  1275. i = (i + 1)
  1276. Loop
  1277. End If
  1278. End Try
  1279. Return result
  1280. End Function
  1281. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1282. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1283. Protected Overridable Sub SortSelfReferenceRows(ByVal rows() As Global.System.Data.DataRow, ByVal relation As Global.System.Data.DataRelation, ByVal childFirst As Boolean)
  1284. Global.System.Array.Sort(Of Global.System.Data.DataRow)(rows, New SelfReferenceComparer(relation, childFirst))
  1285. End Sub
  1286. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1287. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1288. Protected Overridable Function MatchTableAdapterConnection(ByVal inputConnection As Global.System.Data.IDbConnection) As Boolean
  1289. If (Not (Me._connection) Is Nothing) Then
  1290. Return true
  1291. End If
  1292. If ((Me.Connection Is Nothing) _
  1293. OrElse (inputConnection Is Nothing)) Then
  1294. Return true
  1295. End If
  1296. If String.Equals(Me.Connection.ConnectionString, inputConnection.ConnectionString, Global.System.StringComparison.Ordinal) Then
  1297. Return true
  1298. End If
  1299. Return false
  1300. End Function
  1301. '''<summary>
  1302. '''Update Order Option
  1303. '''</summary>
  1304. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1305. Public Enum UpdateOrderOption
  1306. InsertUpdateDelete = 0
  1307. UpdateInsertDelete = 1
  1308. End Enum
  1309. '''<summary>
  1310. '''Used to sort self-referenced table's rows
  1311. '''</summary>
  1312. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1313. Private Class SelfReferenceComparer
  1314. Inherits Object
  1315. Implements Global.System.Collections.Generic.IComparer(Of Global.System.Data.DataRow)
  1316. Private _relation As Global.System.Data.DataRelation
  1317. Private _childFirst As Integer
  1318. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1319. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1320. Friend Sub New(ByVal relation As Global.System.Data.DataRelation, ByVal childFirst As Boolean)
  1321. MyBase.New
  1322. Me._relation = relation
  1323. If childFirst Then
  1324. Me._childFirst = -1
  1325. Else
  1326. Me._childFirst = 1
  1327. End If
  1328. End Sub
  1329. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1330. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1331. Private Function GetRoot(ByVal row As Global.System.Data.DataRow, ByRef distance As Integer) As Global.System.Data.DataRow
  1332. Global.System.Diagnostics.Debug.Assert((Not (row) Is Nothing))
  1333. Dim root As Global.System.Data.DataRow = row
  1334. distance = 0
  1335. Dim traversedRows As Global.System.Collections.Generic.IDictionary(Of Global.System.Data.DataRow, Global.System.Data.DataRow) = New Global.System.Collections.Generic.Dictionary(Of Global.System.Data.DataRow, Global.System.Data.DataRow)()
  1336. traversedRows(row) = row
  1337. Dim parent As Global.System.Data.DataRow = row.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.[Default])
  1338. Do While ((Not (parent) Is Nothing) _
  1339. AndAlso (traversedRows.ContainsKey(parent) = false))
  1340. distance = (distance + 1)
  1341. root = parent
  1342. traversedRows(parent) = parent
  1343. parent = parent.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.[Default])
  1344. Loop
  1345. If (distance = 0) Then
  1346. traversedRows.Clear
  1347. traversedRows(row) = row
  1348. parent = row.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.Original)
  1349. Do While ((Not (parent) Is Nothing) _
  1350. AndAlso (traversedRows.ContainsKey(parent) = false))
  1351. distance = (distance + 1)
  1352. root = parent
  1353. traversedRows(parent) = parent
  1354. parent = parent.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.Original)
  1355. Loop
  1356. End If
  1357. Return root
  1358. End Function
  1359. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1360. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")> _
  1361. Public Function Compare(ByVal row1 As Global.System.Data.DataRow, ByVal row2 As Global.System.Data.DataRow) As Integer Implements Global.System.Collections.Generic.IComparer(Of Global.System.Data.DataRow).Compare
  1362. If Object.ReferenceEquals(row1, row2) Then
  1363. Return 0
  1364. End If
  1365. If (row1 Is Nothing) Then
  1366. Return -1
  1367. End If
  1368. If (row2 Is Nothing) Then
  1369. Return 1
  1370. End If
  1371. Dim distance1 As Integer = 0
  1372. Dim root1 As Global.System.Data.DataRow = Me.GetRoot(row1, distance1)
  1373. Dim distance2 As Integer = 0
  1374. Dim root2 As Global.System.Data.DataRow = Me.GetRoot(row2, distance2)
  1375. If Object.ReferenceEquals(root1, root2) Then
  1376. Return (Me._childFirst * distance1.CompareTo(distance2))
  1377. Else
  1378. Global.System.Diagnostics.Debug.Assert(((Not (root1.Table) Is Nothing) _
  1379. AndAlso (Not (root2.Table) Is Nothing)))
  1380. If (root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2)) Then
  1381. Return -1
  1382. Else
  1383. Return 1
  1384. End If
  1385. End If
  1386. End Function
  1387. End Class
  1388. End Class
  1389. End Namespace