InversionesDataSet.Designer.vb 207 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212
  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("InversionesDataSet"), _
  20. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")> _
  21. Partial Public Class InversionesDataSet
  22. Inherits Global.System.Data.DataSet
  23. Private tablePIN0 As PIN0DataTable
  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", "15.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", "15.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("PIN0")) Is Nothing) Then
  52. MyBase.Tables.Add(New PIN0DataTable(ds.Tables("PIN0")))
  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", "15.0.0.0"), _
  72. Global.System.ComponentModel.Browsable(false), _
  73. Global.System.ComponentModel.DesignerSerializationVisibility(Global.System.ComponentModel.DesignerSerializationVisibility.Content)> _
  74. Public ReadOnly Property PIN0() As PIN0DataTable
  75. Get
  76. Return Me.tablePIN0
  77. End Get
  78. End Property
  79. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  80. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.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", "15.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", "15.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", "15.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", "15.0.0.0")> _
  116. Public Overrides Function Clone() As Global.System.Data.DataSet
  117. Dim cln As InversionesDataSet = CType(MyBase.Clone,InversionesDataSet)
  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", "15.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", "15.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", "15.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("PIN0")) Is Nothing) Then
  140. MyBase.Tables.Add(New PIN0DataTable(ds.Tables("PIN0")))
  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", "15.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", "15.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", "15.0.0.0")> _
  170. Friend Overloads Sub InitVars(ByVal initTable As Boolean)
  171. Me.tablePIN0 = CType(MyBase.Tables("PIN0"),PIN0DataTable)
  172. If (initTable = true) Then
  173. If (Not (Me.tablePIN0) Is Nothing) Then
  174. Me.tablePIN0.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", "15.0.0.0")> _
  180. Private Sub InitClass()
  181. Me.DataSetName = "InversionesDataSet"
  182. Me.Prefix = ""
  183. Me.Namespace = "http://tempuri.org/InversionesDataSet.xsd"
  184. Me.EnforceConstraints = true
  185. Me.SchemaSerializationMode = Global.System.Data.SchemaSerializationMode.IncludeSchema
  186. Me.tablePIN0 = New PIN0DataTable()
  187. MyBase.Tables.Add(Me.tablePIN0)
  188. End Sub
  189. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  190. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  191. Private Function ShouldSerializePIN0() As Boolean
  192. Return false
  193. End Function
  194. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  195. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.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", "15.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 InversionesDataSet = New InversionesDataSet()
  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", "15.0.0.0")> _
  247. Public Delegate Sub PIN0RowChangeEventHandler(ByVal sender As Object, ByVal e As PIN0RowChangeEvent)
  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 PIN0DataTable
  254. Inherits Global.System.Data.TypedTableBase(Of PIN0Row)
  255. Private columnDocId As Global.System.Data.DataColumn
  256. Private columnCodInv As Global.System.Data.DataColumn
  257. Private columnDocEst As Global.System.Data.DataColumn
  258. Private columnAsunto As Global.System.Data.DataColumn
  259. Private columnCodEmpr As Global.System.Data.DataColumn
  260. Private columnCodIF As Global.System.Data.DataColumn
  261. Private columnCodEmis As Global.System.Data.DataColumn
  262. Private columnCodCalRi As Global.System.Data.DataColumn
  263. Private columnCodECalRi As Global.System.Data.DataColumn
  264. Private columnOFon As Global.System.Data.DataColumn
  265. Private columnComent As Global.System.Data.DataColumn
  266. Private columnJust As Global.System.Data.DataColumn
  267. Private columnTipoOper As Global.System.Data.DataColumn
  268. Private columnDocBase As Global.System.Data.DataColumn
  269. Private columnMontoInv As Global.System.Data.DataColumn
  270. Private columnPrecio As Global.System.Data.DataColumn
  271. Private columnRendimiento As Global.System.Data.DataColumn
  272. Private columnPlazo As Global.System.Data.DataColumn
  273. Private columnPlazoFact As Global.System.Data.DataColumn
  274. Private columnIngresos As Global.System.Data.DataColumn
  275. Private columnFechaDoc As Global.System.Data.DataColumn
  276. Private columnAutEstado As Global.System.Data.DataColumn
  277. Private columnTipoMerc As Global.System.Data.DataColumn
  278. Private columnCodPais As Global.System.Data.DataColumn
  279. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  280. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  281. Public Sub New()
  282. MyBase.New
  283. Me.TableName = "PIN0"
  284. Me.BeginInit
  285. Me.InitClass
  286. Me.EndInit
  287. End Sub
  288. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  289. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  290. Friend Sub New(ByVal table As Global.System.Data.DataTable)
  291. MyBase.New
  292. Me.TableName = table.TableName
  293. If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
  294. Me.CaseSensitive = table.CaseSensitive
  295. End If
  296. If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
  297. Me.Locale = table.Locale
  298. End If
  299. If (table.Namespace <> table.DataSet.Namespace) Then
  300. Me.Namespace = table.Namespace
  301. End If
  302. Me.Prefix = table.Prefix
  303. Me.MinimumCapacity = table.MinimumCapacity
  304. End Sub
  305. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  306. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  307. Protected Sub New(ByVal info As Global.System.Runtime.Serialization.SerializationInfo, ByVal context As Global.System.Runtime.Serialization.StreamingContext)
  308. MyBase.New(info, context)
  309. Me.InitVars
  310. End Sub
  311. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  312. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  313. Public ReadOnly Property DocIdColumn() As Global.System.Data.DataColumn
  314. Get
  315. Return Me.columnDocId
  316. End Get
  317. End Property
  318. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  319. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  320. Public ReadOnly Property CodInvColumn() As Global.System.Data.DataColumn
  321. Get
  322. Return Me.columnCodInv
  323. End Get
  324. End Property
  325. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  326. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  327. Public ReadOnly Property DocEstColumn() As Global.System.Data.DataColumn
  328. Get
  329. Return Me.columnDocEst
  330. End Get
  331. End Property
  332. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  333. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  334. Public ReadOnly Property AsuntoColumn() As Global.System.Data.DataColumn
  335. Get
  336. Return Me.columnAsunto
  337. End Get
  338. End Property
  339. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  340. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  341. Public ReadOnly Property CodEmprColumn() As Global.System.Data.DataColumn
  342. Get
  343. Return Me.columnCodEmpr
  344. End Get
  345. End Property
  346. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  347. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  348. Public ReadOnly Property CodIFColumn() As Global.System.Data.DataColumn
  349. Get
  350. Return Me.columnCodIF
  351. End Get
  352. End Property
  353. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  354. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  355. Public ReadOnly Property CodEmisColumn() As Global.System.Data.DataColumn
  356. Get
  357. Return Me.columnCodEmis
  358. End Get
  359. End Property
  360. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  361. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  362. Public ReadOnly Property CodCalRiColumn() As Global.System.Data.DataColumn
  363. Get
  364. Return Me.columnCodCalRi
  365. End Get
  366. End Property
  367. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  368. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  369. Public ReadOnly Property CodECalRiColumn() As Global.System.Data.DataColumn
  370. Get
  371. Return Me.columnCodECalRi
  372. End Get
  373. End Property
  374. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  375. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  376. Public ReadOnly Property OFonColumn() As Global.System.Data.DataColumn
  377. Get
  378. Return Me.columnOFon
  379. End Get
  380. End Property
  381. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  382. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  383. Public ReadOnly Property ComentColumn() As Global.System.Data.DataColumn
  384. Get
  385. Return Me.columnComent
  386. End Get
  387. End Property
  388. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  389. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  390. Public ReadOnly Property JustColumn() As Global.System.Data.DataColumn
  391. Get
  392. Return Me.columnJust
  393. End Get
  394. End Property
  395. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  396. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  397. Public ReadOnly Property TipoOperColumn() As Global.System.Data.DataColumn
  398. Get
  399. Return Me.columnTipoOper
  400. End Get
  401. End Property
  402. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  403. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  404. Public ReadOnly Property DocBaseColumn() As Global.System.Data.DataColumn
  405. Get
  406. Return Me.columnDocBase
  407. End Get
  408. End Property
  409. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  410. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  411. Public ReadOnly Property MontoInvColumn() As Global.System.Data.DataColumn
  412. Get
  413. Return Me.columnMontoInv
  414. End Get
  415. End Property
  416. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  417. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  418. Public ReadOnly Property PrecioColumn() As Global.System.Data.DataColumn
  419. Get
  420. Return Me.columnPrecio
  421. End Get
  422. End Property
  423. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  424. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  425. Public ReadOnly Property RendimientoColumn() As Global.System.Data.DataColumn
  426. Get
  427. Return Me.columnRendimiento
  428. End Get
  429. End Property
  430. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  431. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  432. Public ReadOnly Property PlazoColumn() As Global.System.Data.DataColumn
  433. Get
  434. Return Me.columnPlazo
  435. End Get
  436. End Property
  437. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  438. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  439. Public ReadOnly Property PlazoFactColumn() As Global.System.Data.DataColumn
  440. Get
  441. Return Me.columnPlazoFact
  442. End Get
  443. End Property
  444. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  445. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  446. Public ReadOnly Property IngresosColumn() As Global.System.Data.DataColumn
  447. Get
  448. Return Me.columnIngresos
  449. End Get
  450. End Property
  451. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  452. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  453. Public ReadOnly Property FechaDocColumn() As Global.System.Data.DataColumn
  454. Get
  455. Return Me.columnFechaDoc
  456. End Get
  457. End Property
  458. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  459. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  460. Public ReadOnly Property AutEstadoColumn() As Global.System.Data.DataColumn
  461. Get
  462. Return Me.columnAutEstado
  463. End Get
  464. End Property
  465. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  466. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  467. Public ReadOnly Property TipoMercColumn() As Global.System.Data.DataColumn
  468. Get
  469. Return Me.columnTipoMerc
  470. End Get
  471. End Property
  472. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  473. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  474. Public ReadOnly Property CodPaisColumn() As Global.System.Data.DataColumn
  475. Get
  476. Return Me.columnCodPais
  477. End Get
  478. End Property
  479. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  480. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  481. Global.System.ComponentModel.Browsable(false)> _
  482. Public ReadOnly Property Count() As Integer
  483. Get
  484. Return Me.Rows.Count
  485. End Get
  486. End Property
  487. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  488. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  489. Public Default ReadOnly Property Item(ByVal index As Integer) As PIN0Row
  490. Get
  491. Return CType(Me.Rows(index),PIN0Row)
  492. End Get
  493. End Property
  494. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  495. Public Event PIN0RowChanging As PIN0RowChangeEventHandler
  496. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  497. Public Event PIN0RowChanged As PIN0RowChangeEventHandler
  498. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  499. Public Event PIN0RowDeleting As PIN0RowChangeEventHandler
  500. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  501. Public Event PIN0RowDeleted As PIN0RowChangeEventHandler
  502. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  503. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  504. Public Overloads Sub AddPIN0Row(ByVal row As PIN0Row)
  505. Me.Rows.Add(row)
  506. End Sub
  507. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  508. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  509. Public Overloads Function AddPIN0Row( _
  510. ByVal CodInv As String, _
  511. ByVal DocEst As String, _
  512. ByVal Asunto As String, _
  513. ByVal CodEmpr As String, _
  514. ByVal CodIF As String, _
  515. ByVal CodEmis As Integer, _
  516. ByVal CodCalRi As String, _
  517. ByVal CodECalRi As String, _
  518. ByVal OFon As String, _
  519. ByVal Coment As String, _
  520. ByVal Just As String, _
  521. ByVal TipoOper As String, _
  522. ByVal DocBase As Integer, _
  523. ByVal MontoInv As Decimal, _
  524. ByVal Precio As Decimal, _
  525. ByVal Rendimiento As Decimal, _
  526. ByVal Plazo As Integer, _
  527. ByVal PlazoFact As String, _
  528. ByVal Ingresos As Decimal, _
  529. ByVal FechaDoc As Date, _
  530. ByVal AutEstado As String, _
  531. ByVal TipoMerc As String, _
  532. ByVal CodPais As String) As PIN0Row
  533. Dim rowPIN0Row As PIN0Row = CType(Me.NewRow,PIN0Row)
  534. Dim columnValuesArray() As Object = New Object() {Nothing, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais}
  535. rowPIN0Row.ItemArray = columnValuesArray
  536. Me.Rows.Add(rowPIN0Row)
  537. Return rowPIN0Row
  538. End Function
  539. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  540. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  541. Public Function FindByDocId(ByVal DocId As Integer) As PIN0Row
  542. Return CType(Me.Rows.Find(New Object() {DocId}),PIN0Row)
  543. End Function
  544. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  545. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  546. Public Overrides Function Clone() As Global.System.Data.DataTable
  547. Dim cln As PIN0DataTable = CType(MyBase.Clone,PIN0DataTable)
  548. cln.InitVars
  549. Return cln
  550. End Function
  551. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  552. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  553. Protected Overrides Function CreateInstance() As Global.System.Data.DataTable
  554. Return New PIN0DataTable()
  555. End Function
  556. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  557. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  558. Friend Sub InitVars()
  559. Me.columnDocId = MyBase.Columns("DocId")
  560. Me.columnCodInv = MyBase.Columns("CodInv")
  561. Me.columnDocEst = MyBase.Columns("DocEst")
  562. Me.columnAsunto = MyBase.Columns("Asunto")
  563. Me.columnCodEmpr = MyBase.Columns("CodEmpr")
  564. Me.columnCodIF = MyBase.Columns("CodIF")
  565. Me.columnCodEmis = MyBase.Columns("CodEmis")
  566. Me.columnCodCalRi = MyBase.Columns("CodCalRi")
  567. Me.columnCodECalRi = MyBase.Columns("CodECalRi")
  568. Me.columnOFon = MyBase.Columns("OFon")
  569. Me.columnComent = MyBase.Columns("Coment")
  570. Me.columnJust = MyBase.Columns("Just")
  571. Me.columnTipoOper = MyBase.Columns("TipoOper")
  572. Me.columnDocBase = MyBase.Columns("DocBase")
  573. Me.columnMontoInv = MyBase.Columns("MontoInv")
  574. Me.columnPrecio = MyBase.Columns("Precio")
  575. Me.columnRendimiento = MyBase.Columns("Rendimiento")
  576. Me.columnPlazo = MyBase.Columns("Plazo")
  577. Me.columnPlazoFact = MyBase.Columns("PlazoFact")
  578. Me.columnIngresos = MyBase.Columns("Ingresos")
  579. Me.columnFechaDoc = MyBase.Columns("FechaDoc")
  580. Me.columnAutEstado = MyBase.Columns("AutEstado")
  581. Me.columnTipoMerc = MyBase.Columns("TipoMerc")
  582. Me.columnCodPais = MyBase.Columns("CodPais")
  583. End Sub
  584. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  585. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  586. Private Sub InitClass()
  587. Me.columnDocId = New Global.System.Data.DataColumn("DocId", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
  588. MyBase.Columns.Add(Me.columnDocId)
  589. Me.columnCodInv = New Global.System.Data.DataColumn("CodInv", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  590. MyBase.Columns.Add(Me.columnCodInv)
  591. Me.columnDocEst = New Global.System.Data.DataColumn("DocEst", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  592. MyBase.Columns.Add(Me.columnDocEst)
  593. Me.columnAsunto = New Global.System.Data.DataColumn("Asunto", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  594. MyBase.Columns.Add(Me.columnAsunto)
  595. Me.columnCodEmpr = New Global.System.Data.DataColumn("CodEmpr", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  596. MyBase.Columns.Add(Me.columnCodEmpr)
  597. Me.columnCodIF = New Global.System.Data.DataColumn("CodIF", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  598. MyBase.Columns.Add(Me.columnCodIF)
  599. Me.columnCodEmis = New Global.System.Data.DataColumn("CodEmis", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
  600. MyBase.Columns.Add(Me.columnCodEmis)
  601. Me.columnCodCalRi = New Global.System.Data.DataColumn("CodCalRi", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  602. MyBase.Columns.Add(Me.columnCodCalRi)
  603. Me.columnCodECalRi = New Global.System.Data.DataColumn("CodECalRi", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  604. MyBase.Columns.Add(Me.columnCodECalRi)
  605. Me.columnOFon = New Global.System.Data.DataColumn("OFon", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  606. MyBase.Columns.Add(Me.columnOFon)
  607. Me.columnComent = New Global.System.Data.DataColumn("Coment", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  608. MyBase.Columns.Add(Me.columnComent)
  609. Me.columnJust = New Global.System.Data.DataColumn("Just", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  610. MyBase.Columns.Add(Me.columnJust)
  611. Me.columnTipoOper = New Global.System.Data.DataColumn("TipoOper", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  612. MyBase.Columns.Add(Me.columnTipoOper)
  613. Me.columnDocBase = New Global.System.Data.DataColumn("DocBase", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
  614. MyBase.Columns.Add(Me.columnDocBase)
  615. Me.columnMontoInv = New Global.System.Data.DataColumn("MontoInv", GetType(Decimal), Nothing, Global.System.Data.MappingType.Element)
  616. MyBase.Columns.Add(Me.columnMontoInv)
  617. Me.columnPrecio = New Global.System.Data.DataColumn("Precio", GetType(Decimal), Nothing, Global.System.Data.MappingType.Element)
  618. MyBase.Columns.Add(Me.columnPrecio)
  619. Me.columnRendimiento = New Global.System.Data.DataColumn("Rendimiento", GetType(Decimal), Nothing, Global.System.Data.MappingType.Element)
  620. MyBase.Columns.Add(Me.columnRendimiento)
  621. Me.columnPlazo = New Global.System.Data.DataColumn("Plazo", GetType(Integer), Nothing, Global.System.Data.MappingType.Element)
  622. MyBase.Columns.Add(Me.columnPlazo)
  623. Me.columnPlazoFact = New Global.System.Data.DataColumn("PlazoFact", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  624. MyBase.Columns.Add(Me.columnPlazoFact)
  625. Me.columnIngresos = New Global.System.Data.DataColumn("Ingresos", GetType(Decimal), Nothing, Global.System.Data.MappingType.Element)
  626. MyBase.Columns.Add(Me.columnIngresos)
  627. Me.columnFechaDoc = New Global.System.Data.DataColumn("FechaDoc", GetType(Date), Nothing, Global.System.Data.MappingType.Element)
  628. MyBase.Columns.Add(Me.columnFechaDoc)
  629. Me.columnAutEstado = New Global.System.Data.DataColumn("AutEstado", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  630. MyBase.Columns.Add(Me.columnAutEstado)
  631. Me.columnTipoMerc = New Global.System.Data.DataColumn("TipoMerc", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  632. MyBase.Columns.Add(Me.columnTipoMerc)
  633. Me.columnCodPais = New Global.System.Data.DataColumn("CodPais", GetType(String), Nothing, Global.System.Data.MappingType.Element)
  634. MyBase.Columns.Add(Me.columnCodPais)
  635. Me.Constraints.Add(New Global.System.Data.UniqueConstraint("Constraint1", New Global.System.Data.DataColumn() {Me.columnDocId}, true))
  636. Me.columnDocId.AutoIncrement = true
  637. Me.columnDocId.AutoIncrementSeed = -1
  638. Me.columnDocId.AutoIncrementStep = -1
  639. Me.columnDocId.AllowDBNull = false
  640. Me.columnDocId.ReadOnly = true
  641. Me.columnDocId.Unique = true
  642. Me.columnCodInv.MaxLength = 20
  643. Me.columnDocEst.MaxLength = 1
  644. Me.columnAsunto.MaxLength = 100
  645. Me.columnCodEmpr.MaxLength = 10
  646. Me.columnCodIF.MaxLength = 10
  647. Me.columnCodCalRi.MaxLength = 8
  648. Me.columnCodECalRi.MaxLength = 8
  649. Me.columnOFon.MaxLength = 10
  650. Me.columnComent.MaxLength = 100
  651. Me.columnJust.MaxLength = 100
  652. Me.columnTipoOper.MaxLength = 1
  653. Me.columnPlazoFact.MaxLength = 1
  654. Me.columnAutEstado.MaxLength = 1
  655. Me.columnTipoMerc.MaxLength = 1
  656. Me.columnCodPais.MaxLength = 3
  657. End Sub
  658. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  659. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  660. Public Function NewPIN0Row() As PIN0Row
  661. Return CType(Me.NewRow,PIN0Row)
  662. End Function
  663. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  664. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  665. Protected Overrides Function NewRowFromBuilder(ByVal builder As Global.System.Data.DataRowBuilder) As Global.System.Data.DataRow
  666. Return New PIN0Row(builder)
  667. End Function
  668. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  669. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  670. Protected Overrides Function GetRowType() As Global.System.Type
  671. Return GetType(PIN0Row)
  672. End Function
  673. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  674. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  675. Protected Overrides Sub OnRowChanged(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  676. MyBase.OnRowChanged(e)
  677. If (Not (Me.PIN0RowChangedEvent) Is Nothing) Then
  678. RaiseEvent PIN0RowChanged(Me, New PIN0RowChangeEvent(CType(e.Row,PIN0Row), e.Action))
  679. End If
  680. End Sub
  681. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  682. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  683. Protected Overrides Sub OnRowChanging(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  684. MyBase.OnRowChanging(e)
  685. If (Not (Me.PIN0RowChangingEvent) Is Nothing) Then
  686. RaiseEvent PIN0RowChanging(Me, New PIN0RowChangeEvent(CType(e.Row,PIN0Row), e.Action))
  687. End If
  688. End Sub
  689. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  690. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  691. Protected Overrides Sub OnRowDeleted(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  692. MyBase.OnRowDeleted(e)
  693. If (Not (Me.PIN0RowDeletedEvent) Is Nothing) Then
  694. RaiseEvent PIN0RowDeleted(Me, New PIN0RowChangeEvent(CType(e.Row,PIN0Row), e.Action))
  695. End If
  696. End Sub
  697. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  698. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  699. Protected Overrides Sub OnRowDeleting(ByVal e As Global.System.Data.DataRowChangeEventArgs)
  700. MyBase.OnRowDeleting(e)
  701. If (Not (Me.PIN0RowDeletingEvent) Is Nothing) Then
  702. RaiseEvent PIN0RowDeleting(Me, New PIN0RowChangeEvent(CType(e.Row,PIN0Row), e.Action))
  703. End If
  704. End Sub
  705. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  706. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  707. Public Sub RemovePIN0Row(ByVal row As PIN0Row)
  708. Me.Rows.Remove(row)
  709. End Sub
  710. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  711. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  712. Public Shared Function GetTypedTableSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType
  713. Dim type As Global.System.Xml.Schema.XmlSchemaComplexType = New Global.System.Xml.Schema.XmlSchemaComplexType()
  714. Dim sequence As Global.System.Xml.Schema.XmlSchemaSequence = New Global.System.Xml.Schema.XmlSchemaSequence()
  715. Dim ds As InversionesDataSet = New InversionesDataSet()
  716. Dim any1 As Global.System.Xml.Schema.XmlSchemaAny = New Global.System.Xml.Schema.XmlSchemaAny()
  717. any1.Namespace = "http://www.w3.org/2001/XMLSchema"
  718. any1.MinOccurs = New Decimal(0)
  719. any1.MaxOccurs = Decimal.MaxValue
  720. any1.ProcessContents = Global.System.Xml.Schema.XmlSchemaContentProcessing.Lax
  721. sequence.Items.Add(any1)
  722. Dim any2 As Global.System.Xml.Schema.XmlSchemaAny = New Global.System.Xml.Schema.XmlSchemaAny()
  723. any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"
  724. any2.MinOccurs = New Decimal(1)
  725. any2.ProcessContents = Global.System.Xml.Schema.XmlSchemaContentProcessing.Lax
  726. sequence.Items.Add(any2)
  727. Dim attribute1 As Global.System.Xml.Schema.XmlSchemaAttribute = New Global.System.Xml.Schema.XmlSchemaAttribute()
  728. attribute1.Name = "namespace"
  729. attribute1.FixedValue = ds.Namespace
  730. type.Attributes.Add(attribute1)
  731. Dim attribute2 As Global.System.Xml.Schema.XmlSchemaAttribute = New Global.System.Xml.Schema.XmlSchemaAttribute()
  732. attribute2.Name = "tableTypeName"
  733. attribute2.FixedValue = "PIN0DataTable"
  734. type.Attributes.Add(attribute2)
  735. type.Particle = sequence
  736. Dim dsSchema As Global.System.Xml.Schema.XmlSchema = ds.GetSchemaSerializable
  737. If xs.Contains(dsSchema.TargetNamespace) Then
  738. Dim s1 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  739. Dim s2 As Global.System.IO.MemoryStream = New Global.System.IO.MemoryStream()
  740. Try
  741. Dim schema As Global.System.Xml.Schema.XmlSchema = Nothing
  742. dsSchema.Write(s1)
  743. Dim schemas As Global.System.Collections.IEnumerator = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator
  744. Do While schemas.MoveNext
  745. schema = CType(schemas.Current,Global.System.Xml.Schema.XmlSchema)
  746. s2.SetLength(0)
  747. schema.Write(s2)
  748. If (s1.Length = s2.Length) Then
  749. s1.Position = 0
  750. s2.Position = 0
  751. Do While ((s1.Position <> s1.Length) _
  752. AndAlso (s1.ReadByte = s2.ReadByte))
  753. Loop
  754. If (s1.Position = s1.Length) Then
  755. Return type
  756. End If
  757. End If
  758. Loop
  759. Finally
  760. If (Not (s1) Is Nothing) Then
  761. s1.Close
  762. End If
  763. If (Not (s2) Is Nothing) Then
  764. s2.Close
  765. End If
  766. End Try
  767. End If
  768. xs.Add(dsSchema)
  769. Return type
  770. End Function
  771. End Class
  772. '''<summary>
  773. '''Represents strongly named DataRow class.
  774. '''</summary>
  775. Partial Public Class PIN0Row
  776. Inherits Global.System.Data.DataRow
  777. Private tablePIN0 As PIN0DataTable
  778. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  779. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  780. Friend Sub New(ByVal rb As Global.System.Data.DataRowBuilder)
  781. MyBase.New(rb)
  782. Me.tablePIN0 = CType(Me.Table,PIN0DataTable)
  783. End Sub
  784. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  785. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  786. Public Property DocId() As Integer
  787. Get
  788. Return CType(Me(Me.tablePIN0.DocIdColumn),Integer)
  789. End Get
  790. Set
  791. Me(Me.tablePIN0.DocIdColumn) = value
  792. End Set
  793. End Property
  794. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  795. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  796. Public Property CodInv() As String
  797. Get
  798. Try
  799. Return CType(Me(Me.tablePIN0.CodInvColumn),String)
  800. Catch e As Global.System.InvalidCastException
  801. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodInv' de la tabla 'PIN0' es DBNull.", e)
  802. End Try
  803. End Get
  804. Set
  805. Me(Me.tablePIN0.CodInvColumn) = value
  806. End Set
  807. End Property
  808. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  809. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  810. Public Property DocEst() As String
  811. Get
  812. Try
  813. Return CType(Me(Me.tablePIN0.DocEstColumn),String)
  814. Catch e As Global.System.InvalidCastException
  815. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'DocEst' de la tabla 'PIN0' es DBNull.", e)
  816. End Try
  817. End Get
  818. Set
  819. Me(Me.tablePIN0.DocEstColumn) = value
  820. End Set
  821. End Property
  822. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  823. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  824. Public Property Asunto() As String
  825. Get
  826. Try
  827. Return CType(Me(Me.tablePIN0.AsuntoColumn),String)
  828. Catch e As Global.System.InvalidCastException
  829. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Asunto' de la tabla 'PIN0' es DBNull.", e)
  830. End Try
  831. End Get
  832. Set
  833. Me(Me.tablePIN0.AsuntoColumn) = value
  834. End Set
  835. End Property
  836. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  837. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  838. Public Property CodEmpr() As String
  839. Get
  840. Try
  841. Return CType(Me(Me.tablePIN0.CodEmprColumn),String)
  842. Catch e As Global.System.InvalidCastException
  843. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodEmpr' de la tabla 'PIN0' es DBNull.", e)
  844. End Try
  845. End Get
  846. Set
  847. Me(Me.tablePIN0.CodEmprColumn) = value
  848. End Set
  849. End Property
  850. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  851. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  852. Public Property CodIF() As String
  853. Get
  854. Try
  855. Return CType(Me(Me.tablePIN0.CodIFColumn),String)
  856. Catch e As Global.System.InvalidCastException
  857. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodIF' de la tabla 'PIN0' es DBNull.", e)
  858. End Try
  859. End Get
  860. Set
  861. Me(Me.tablePIN0.CodIFColumn) = value
  862. End Set
  863. End Property
  864. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  865. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  866. Public Property CodEmis() As Integer
  867. Get
  868. Try
  869. Return CType(Me(Me.tablePIN0.CodEmisColumn),Integer)
  870. Catch e As Global.System.InvalidCastException
  871. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodEmis' de la tabla 'PIN0' es DBNull.", e)
  872. End Try
  873. End Get
  874. Set
  875. Me(Me.tablePIN0.CodEmisColumn) = value
  876. End Set
  877. End Property
  878. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  879. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  880. Public Property CodCalRi() As String
  881. Get
  882. Try
  883. Return CType(Me(Me.tablePIN0.CodCalRiColumn),String)
  884. Catch e As Global.System.InvalidCastException
  885. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodCalRi' de la tabla 'PIN0' es DBNull.", e)
  886. End Try
  887. End Get
  888. Set
  889. Me(Me.tablePIN0.CodCalRiColumn) = value
  890. End Set
  891. End Property
  892. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  893. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  894. Public Property CodECalRi() As String
  895. Get
  896. Try
  897. Return CType(Me(Me.tablePIN0.CodECalRiColumn),String)
  898. Catch e As Global.System.InvalidCastException
  899. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodECalRi' de la tabla 'PIN0' es DBNull.", e)
  900. End Try
  901. End Get
  902. Set
  903. Me(Me.tablePIN0.CodECalRiColumn) = value
  904. End Set
  905. End Property
  906. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  907. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  908. Public Property OFon() As String
  909. Get
  910. Try
  911. Return CType(Me(Me.tablePIN0.OFonColumn),String)
  912. Catch e As Global.System.InvalidCastException
  913. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'OFon' de la tabla 'PIN0' es DBNull.", e)
  914. End Try
  915. End Get
  916. Set
  917. Me(Me.tablePIN0.OFonColumn) = value
  918. End Set
  919. End Property
  920. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  921. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  922. Public Property Coment() As String
  923. Get
  924. Try
  925. Return CType(Me(Me.tablePIN0.ComentColumn),String)
  926. Catch e As Global.System.InvalidCastException
  927. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Coment' de la tabla 'PIN0' es DBNull.", e)
  928. End Try
  929. End Get
  930. Set
  931. Me(Me.tablePIN0.ComentColumn) = value
  932. End Set
  933. End Property
  934. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  935. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  936. Public Property Just() As String
  937. Get
  938. Try
  939. Return CType(Me(Me.tablePIN0.JustColumn),String)
  940. Catch e As Global.System.InvalidCastException
  941. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Just' de la tabla 'PIN0' es DBNull.", e)
  942. End Try
  943. End Get
  944. Set
  945. Me(Me.tablePIN0.JustColumn) = value
  946. End Set
  947. End Property
  948. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  949. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  950. Public Property TipoOper() As String
  951. Get
  952. Try
  953. Return CType(Me(Me.tablePIN0.TipoOperColumn),String)
  954. Catch e As Global.System.InvalidCastException
  955. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'TipoOper' de la tabla 'PIN0' es DBNull.", e)
  956. End Try
  957. End Get
  958. Set
  959. Me(Me.tablePIN0.TipoOperColumn) = value
  960. End Set
  961. End Property
  962. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  963. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  964. Public Property DocBase() As Integer
  965. Get
  966. Try
  967. Return CType(Me(Me.tablePIN0.DocBaseColumn),Integer)
  968. Catch e As Global.System.InvalidCastException
  969. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'DocBase' de la tabla 'PIN0' es DBNull.", e)
  970. End Try
  971. End Get
  972. Set
  973. Me(Me.tablePIN0.DocBaseColumn) = value
  974. End Set
  975. End Property
  976. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  977. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  978. Public Property MontoInv() As Decimal
  979. Get
  980. Try
  981. Return CType(Me(Me.tablePIN0.MontoInvColumn),Decimal)
  982. Catch e As Global.System.InvalidCastException
  983. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'MontoInv' de la tabla 'PIN0' es DBNull.", e)
  984. End Try
  985. End Get
  986. Set
  987. Me(Me.tablePIN0.MontoInvColumn) = value
  988. End Set
  989. End Property
  990. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  991. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  992. Public Property Precio() As Decimal
  993. Get
  994. Try
  995. Return CType(Me(Me.tablePIN0.PrecioColumn),Decimal)
  996. Catch e As Global.System.InvalidCastException
  997. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Precio' de la tabla 'PIN0' es DBNull.", e)
  998. End Try
  999. End Get
  1000. Set
  1001. Me(Me.tablePIN0.PrecioColumn) = value
  1002. End Set
  1003. End Property
  1004. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1005. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1006. Public Property Rendimiento() As Decimal
  1007. Get
  1008. Try
  1009. Return CType(Me(Me.tablePIN0.RendimientoColumn),Decimal)
  1010. Catch e As Global.System.InvalidCastException
  1011. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Rendimiento' de la tabla 'PIN0' es DBNull.", e)
  1012. End Try
  1013. End Get
  1014. Set
  1015. Me(Me.tablePIN0.RendimientoColumn) = value
  1016. End Set
  1017. End Property
  1018. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1019. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1020. Public Property Plazo() As Integer
  1021. Get
  1022. Try
  1023. Return CType(Me(Me.tablePIN0.PlazoColumn),Integer)
  1024. Catch e As Global.System.InvalidCastException
  1025. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Plazo' de la tabla 'PIN0' es DBNull.", e)
  1026. End Try
  1027. End Get
  1028. Set
  1029. Me(Me.tablePIN0.PlazoColumn) = value
  1030. End Set
  1031. End Property
  1032. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1033. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1034. Public Property PlazoFact() As String
  1035. Get
  1036. Try
  1037. Return CType(Me(Me.tablePIN0.PlazoFactColumn),String)
  1038. Catch e As Global.System.InvalidCastException
  1039. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'PlazoFact' de la tabla 'PIN0' es DBNull.", e)
  1040. End Try
  1041. End Get
  1042. Set
  1043. Me(Me.tablePIN0.PlazoFactColumn) = value
  1044. End Set
  1045. End Property
  1046. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1047. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1048. Public Property Ingresos() As Decimal
  1049. Get
  1050. Try
  1051. Return CType(Me(Me.tablePIN0.IngresosColumn),Decimal)
  1052. Catch e As Global.System.InvalidCastException
  1053. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'Ingresos' de la tabla 'PIN0' es DBNull.", e)
  1054. End Try
  1055. End Get
  1056. Set
  1057. Me(Me.tablePIN0.IngresosColumn) = value
  1058. End Set
  1059. End Property
  1060. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1061. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1062. Public Property FechaDoc() As Date
  1063. Get
  1064. Try
  1065. Return CType(Me(Me.tablePIN0.FechaDocColumn),Date)
  1066. Catch e As Global.System.InvalidCastException
  1067. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'FechaDoc' de la tabla 'PIN0' es DBNull.", e)
  1068. End Try
  1069. End Get
  1070. Set
  1071. Me(Me.tablePIN0.FechaDocColumn) = value
  1072. End Set
  1073. End Property
  1074. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1075. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1076. Public Property AutEstado() As String
  1077. Get
  1078. Try
  1079. Return CType(Me(Me.tablePIN0.AutEstadoColumn),String)
  1080. Catch e As Global.System.InvalidCastException
  1081. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'AutEstado' de la tabla 'PIN0' es DBNull.", e)
  1082. End Try
  1083. End Get
  1084. Set
  1085. Me(Me.tablePIN0.AutEstadoColumn) = value
  1086. End Set
  1087. End Property
  1088. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1089. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1090. Public Property TipoMerc() As String
  1091. Get
  1092. Try
  1093. Return CType(Me(Me.tablePIN0.TipoMercColumn),String)
  1094. Catch e As Global.System.InvalidCastException
  1095. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'TipoMerc' de la tabla 'PIN0' es DBNull.", e)
  1096. End Try
  1097. End Get
  1098. Set
  1099. Me(Me.tablePIN0.TipoMercColumn) = value
  1100. End Set
  1101. End Property
  1102. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1103. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1104. Public Property CodPais() As String
  1105. Get
  1106. Try
  1107. Return CType(Me(Me.tablePIN0.CodPaisColumn),String)
  1108. Catch e As Global.System.InvalidCastException
  1109. Throw New Global.System.Data.StrongTypingException("El valor de la columna 'CodPais' de la tabla 'PIN0' es DBNull.", e)
  1110. End Try
  1111. End Get
  1112. Set
  1113. Me(Me.tablePIN0.CodPaisColumn) = value
  1114. End Set
  1115. End Property
  1116. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1117. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1118. Public Function IsCodInvNull() As Boolean
  1119. Return Me.IsNull(Me.tablePIN0.CodInvColumn)
  1120. End Function
  1121. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1122. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1123. Public Sub SetCodInvNull()
  1124. Me(Me.tablePIN0.CodInvColumn) = Global.System.Convert.DBNull
  1125. End Sub
  1126. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1127. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1128. Public Function IsDocEstNull() As Boolean
  1129. Return Me.IsNull(Me.tablePIN0.DocEstColumn)
  1130. End Function
  1131. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1132. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1133. Public Sub SetDocEstNull()
  1134. Me(Me.tablePIN0.DocEstColumn) = Global.System.Convert.DBNull
  1135. End Sub
  1136. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1137. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1138. Public Function IsAsuntoNull() As Boolean
  1139. Return Me.IsNull(Me.tablePIN0.AsuntoColumn)
  1140. End Function
  1141. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1142. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1143. Public Sub SetAsuntoNull()
  1144. Me(Me.tablePIN0.AsuntoColumn) = Global.System.Convert.DBNull
  1145. End Sub
  1146. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1147. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1148. Public Function IsCodEmprNull() As Boolean
  1149. Return Me.IsNull(Me.tablePIN0.CodEmprColumn)
  1150. End Function
  1151. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1152. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1153. Public Sub SetCodEmprNull()
  1154. Me(Me.tablePIN0.CodEmprColumn) = Global.System.Convert.DBNull
  1155. End Sub
  1156. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1157. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1158. Public Function IsCodIFNull() As Boolean
  1159. Return Me.IsNull(Me.tablePIN0.CodIFColumn)
  1160. End Function
  1161. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1162. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1163. Public Sub SetCodIFNull()
  1164. Me(Me.tablePIN0.CodIFColumn) = Global.System.Convert.DBNull
  1165. End Sub
  1166. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1167. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1168. Public Function IsCodEmisNull() As Boolean
  1169. Return Me.IsNull(Me.tablePIN0.CodEmisColumn)
  1170. End Function
  1171. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1172. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1173. Public Sub SetCodEmisNull()
  1174. Me(Me.tablePIN0.CodEmisColumn) = Global.System.Convert.DBNull
  1175. End Sub
  1176. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1177. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1178. Public Function IsCodCalRiNull() As Boolean
  1179. Return Me.IsNull(Me.tablePIN0.CodCalRiColumn)
  1180. End Function
  1181. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1182. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1183. Public Sub SetCodCalRiNull()
  1184. Me(Me.tablePIN0.CodCalRiColumn) = Global.System.Convert.DBNull
  1185. End Sub
  1186. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1187. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1188. Public Function IsCodECalRiNull() As Boolean
  1189. Return Me.IsNull(Me.tablePIN0.CodECalRiColumn)
  1190. End Function
  1191. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1192. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1193. Public Sub SetCodECalRiNull()
  1194. Me(Me.tablePIN0.CodECalRiColumn) = Global.System.Convert.DBNull
  1195. End Sub
  1196. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1197. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1198. Public Function IsOFonNull() As Boolean
  1199. Return Me.IsNull(Me.tablePIN0.OFonColumn)
  1200. End Function
  1201. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1202. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1203. Public Sub SetOFonNull()
  1204. Me(Me.tablePIN0.OFonColumn) = Global.System.Convert.DBNull
  1205. End Sub
  1206. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1207. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1208. Public Function IsComentNull() As Boolean
  1209. Return Me.IsNull(Me.tablePIN0.ComentColumn)
  1210. End Function
  1211. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1212. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1213. Public Sub SetComentNull()
  1214. Me(Me.tablePIN0.ComentColumn) = Global.System.Convert.DBNull
  1215. End Sub
  1216. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1217. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1218. Public Function IsJustNull() As Boolean
  1219. Return Me.IsNull(Me.tablePIN0.JustColumn)
  1220. End Function
  1221. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1222. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1223. Public Sub SetJustNull()
  1224. Me(Me.tablePIN0.JustColumn) = Global.System.Convert.DBNull
  1225. End Sub
  1226. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1227. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1228. Public Function IsTipoOperNull() As Boolean
  1229. Return Me.IsNull(Me.tablePIN0.TipoOperColumn)
  1230. End Function
  1231. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1232. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1233. Public Sub SetTipoOperNull()
  1234. Me(Me.tablePIN0.TipoOperColumn) = Global.System.Convert.DBNull
  1235. End Sub
  1236. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1237. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1238. Public Function IsDocBaseNull() As Boolean
  1239. Return Me.IsNull(Me.tablePIN0.DocBaseColumn)
  1240. End Function
  1241. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1242. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1243. Public Sub SetDocBaseNull()
  1244. Me(Me.tablePIN0.DocBaseColumn) = Global.System.Convert.DBNull
  1245. End Sub
  1246. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1247. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1248. Public Function IsMontoInvNull() As Boolean
  1249. Return Me.IsNull(Me.tablePIN0.MontoInvColumn)
  1250. End Function
  1251. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1252. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1253. Public Sub SetMontoInvNull()
  1254. Me(Me.tablePIN0.MontoInvColumn) = Global.System.Convert.DBNull
  1255. End Sub
  1256. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1257. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1258. Public Function IsPrecioNull() As Boolean
  1259. Return Me.IsNull(Me.tablePIN0.PrecioColumn)
  1260. End Function
  1261. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1262. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1263. Public Sub SetPrecioNull()
  1264. Me(Me.tablePIN0.PrecioColumn) = Global.System.Convert.DBNull
  1265. End Sub
  1266. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1267. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1268. Public Function IsRendimientoNull() As Boolean
  1269. Return Me.IsNull(Me.tablePIN0.RendimientoColumn)
  1270. End Function
  1271. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1272. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1273. Public Sub SetRendimientoNull()
  1274. Me(Me.tablePIN0.RendimientoColumn) = Global.System.Convert.DBNull
  1275. End Sub
  1276. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1277. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1278. Public Function IsPlazoNull() As Boolean
  1279. Return Me.IsNull(Me.tablePIN0.PlazoColumn)
  1280. End Function
  1281. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1282. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1283. Public Sub SetPlazoNull()
  1284. Me(Me.tablePIN0.PlazoColumn) = Global.System.Convert.DBNull
  1285. End Sub
  1286. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1287. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1288. Public Function IsPlazoFactNull() As Boolean
  1289. Return Me.IsNull(Me.tablePIN0.PlazoFactColumn)
  1290. End Function
  1291. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1292. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1293. Public Sub SetPlazoFactNull()
  1294. Me(Me.tablePIN0.PlazoFactColumn) = Global.System.Convert.DBNull
  1295. End Sub
  1296. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1297. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1298. Public Function IsIngresosNull() As Boolean
  1299. Return Me.IsNull(Me.tablePIN0.IngresosColumn)
  1300. End Function
  1301. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1302. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1303. Public Sub SetIngresosNull()
  1304. Me(Me.tablePIN0.IngresosColumn) = Global.System.Convert.DBNull
  1305. End Sub
  1306. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1307. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1308. Public Function IsFechaDocNull() As Boolean
  1309. Return Me.IsNull(Me.tablePIN0.FechaDocColumn)
  1310. End Function
  1311. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1312. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1313. Public Sub SetFechaDocNull()
  1314. Me(Me.tablePIN0.FechaDocColumn) = Global.System.Convert.DBNull
  1315. End Sub
  1316. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1317. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1318. Public Function IsAutEstadoNull() As Boolean
  1319. Return Me.IsNull(Me.tablePIN0.AutEstadoColumn)
  1320. End Function
  1321. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1322. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1323. Public Sub SetAutEstadoNull()
  1324. Me(Me.tablePIN0.AutEstadoColumn) = Global.System.Convert.DBNull
  1325. End Sub
  1326. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1327. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1328. Public Function IsTipoMercNull() As Boolean
  1329. Return Me.IsNull(Me.tablePIN0.TipoMercColumn)
  1330. End Function
  1331. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1332. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1333. Public Sub SetTipoMercNull()
  1334. Me(Me.tablePIN0.TipoMercColumn) = Global.System.Convert.DBNull
  1335. End Sub
  1336. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1337. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1338. Public Function IsCodPaisNull() As Boolean
  1339. Return Me.IsNull(Me.tablePIN0.CodPaisColumn)
  1340. End Function
  1341. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1342. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1343. Public Sub SetCodPaisNull()
  1344. Me(Me.tablePIN0.CodPaisColumn) = Global.System.Convert.DBNull
  1345. End Sub
  1346. End Class
  1347. '''<summary>
  1348. '''Row event argument class
  1349. '''</summary>
  1350. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1351. Public Class PIN0RowChangeEvent
  1352. Inherits Global.System.EventArgs
  1353. Private eventRow As PIN0Row
  1354. Private eventAction As Global.System.Data.DataRowAction
  1355. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1356. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1357. Public Sub New(ByVal row As PIN0Row, ByVal action As Global.System.Data.DataRowAction)
  1358. MyBase.New
  1359. Me.eventRow = row
  1360. Me.eventAction = action
  1361. End Sub
  1362. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1363. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1364. Public ReadOnly Property Row() As PIN0Row
  1365. Get
  1366. Return Me.eventRow
  1367. End Get
  1368. End Property
  1369. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1370. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1371. Public ReadOnly Property Action() As Global.System.Data.DataRowAction
  1372. Get
  1373. Return Me.eventAction
  1374. End Get
  1375. End Property
  1376. End Class
  1377. End Class
  1378. Namespace InversionesDataSetTableAdapters
  1379. '''<summary>
  1380. '''Represents the connection and commands used to retrieve and save data.
  1381. '''</summary>
  1382. <Global.System.ComponentModel.DesignerCategoryAttribute("code"), _
  1383. Global.System.ComponentModel.ToolboxItem(true), _
  1384. Global.System.ComponentModel.DataObjectAttribute(true), _
  1385. Global.System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner"& _
  1386. ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), _
  1387. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  1388. Partial Public Class PIN0TableAdapter
  1389. Inherits Global.System.ComponentModel.Component
  1390. Private WithEvents _adapter As Global.System.Data.SqlClient.SqlDataAdapter
  1391. Private _connection As Global.System.Data.SqlClient.SqlConnection
  1392. Private _transaction As Global.System.Data.SqlClient.SqlTransaction
  1393. Private _commandCollection() As Global.System.Data.SqlClient.SqlCommand
  1394. Private _clearBeforeFill As Boolean
  1395. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1396. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1397. Public Sub New()
  1398. MyBase.New
  1399. Me.ClearBeforeFill = true
  1400. End Sub
  1401. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1402. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1403. Protected Friend ReadOnly Property Adapter() As Global.System.Data.SqlClient.SqlDataAdapter
  1404. Get
  1405. If (Me._adapter Is Nothing) Then
  1406. Me.InitAdapter
  1407. End If
  1408. Return Me._adapter
  1409. End Get
  1410. End Property
  1411. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1412. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1413. Friend Property Connection() As Global.System.Data.SqlClient.SqlConnection
  1414. Get
  1415. If (Me._connection Is Nothing) Then
  1416. Me.InitConnection
  1417. End If
  1418. Return Me._connection
  1419. End Get
  1420. Set
  1421. Me._connection = value
  1422. If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
  1423. Me.Adapter.InsertCommand.Connection = value
  1424. End If
  1425. If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
  1426. Me.Adapter.DeleteCommand.Connection = value
  1427. End If
  1428. If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
  1429. Me.Adapter.UpdateCommand.Connection = value
  1430. End If
  1431. Dim i As Integer = 0
  1432. Do While (i < Me.CommandCollection.Length)
  1433. If (Not (Me.CommandCollection(i)) Is Nothing) Then
  1434. CType(Me.CommandCollection(i),Global.System.Data.SqlClient.SqlCommand).Connection = value
  1435. End If
  1436. i = (i + 1)
  1437. Loop
  1438. End Set
  1439. End Property
  1440. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1441. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1442. Friend Property Transaction() As Global.System.Data.SqlClient.SqlTransaction
  1443. Get
  1444. Return Me._transaction
  1445. End Get
  1446. Set
  1447. Me._transaction = value
  1448. Dim i As Integer = 0
  1449. Do While (i < Me.CommandCollection.Length)
  1450. Me.CommandCollection(i).Transaction = Me._transaction
  1451. i = (i + 1)
  1452. Loop
  1453. If ((Not (Me.Adapter) Is Nothing) _
  1454. AndAlso (Not (Me.Adapter.DeleteCommand) Is Nothing)) Then
  1455. Me.Adapter.DeleteCommand.Transaction = Me._transaction
  1456. End If
  1457. If ((Not (Me.Adapter) Is Nothing) _
  1458. AndAlso (Not (Me.Adapter.InsertCommand) Is Nothing)) Then
  1459. Me.Adapter.InsertCommand.Transaction = Me._transaction
  1460. End If
  1461. If ((Not (Me.Adapter) Is Nothing) _
  1462. AndAlso (Not (Me.Adapter.UpdateCommand) Is Nothing)) Then
  1463. Me.Adapter.UpdateCommand.Transaction = Me._transaction
  1464. End If
  1465. End Set
  1466. End Property
  1467. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1468. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1469. Protected ReadOnly Property CommandCollection() As Global.System.Data.SqlClient.SqlCommand()
  1470. Get
  1471. If (Me._commandCollection Is Nothing) Then
  1472. Me.InitCommandCollection
  1473. End If
  1474. Return Me._commandCollection
  1475. End Get
  1476. End Property
  1477. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1478. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1479. Public Property ClearBeforeFill() As Boolean
  1480. Get
  1481. Return Me._clearBeforeFill
  1482. End Get
  1483. Set
  1484. Me._clearBeforeFill = value
  1485. End Set
  1486. End Property
  1487. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1488. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1489. Private Sub InitAdapter()
  1490. Me._adapter = New Global.System.Data.SqlClient.SqlDataAdapter()
  1491. Dim tableMapping As Global.System.Data.Common.DataTableMapping = New Global.System.Data.Common.DataTableMapping()
  1492. tableMapping.SourceTable = "Table"
  1493. tableMapping.DataSetTable = "PIN0"
  1494. tableMapping.ColumnMappings.Add("DocId", "DocId")
  1495. tableMapping.ColumnMappings.Add("CodInv", "CodInv")
  1496. tableMapping.ColumnMappings.Add("DocEst", "DocEst")
  1497. tableMapping.ColumnMappings.Add("Asunto", "Asunto")
  1498. tableMapping.ColumnMappings.Add("CodEmpr", "CodEmpr")
  1499. tableMapping.ColumnMappings.Add("CodIF", "CodIF")
  1500. tableMapping.ColumnMappings.Add("CodEmis", "CodEmis")
  1501. tableMapping.ColumnMappings.Add("CodCalRi", "CodCalRi")
  1502. tableMapping.ColumnMappings.Add("CodECalRi", "CodECalRi")
  1503. tableMapping.ColumnMappings.Add("OFon", "OFon")
  1504. tableMapping.ColumnMappings.Add("Coment", "Coment")
  1505. tableMapping.ColumnMappings.Add("Just", "Just")
  1506. tableMapping.ColumnMappings.Add("TipoOper", "TipoOper")
  1507. tableMapping.ColumnMappings.Add("DocBase", "DocBase")
  1508. tableMapping.ColumnMappings.Add("MontoInv", "MontoInv")
  1509. tableMapping.ColumnMappings.Add("Precio", "Precio")
  1510. tableMapping.ColumnMappings.Add("Rendimiento", "Rendimiento")
  1511. tableMapping.ColumnMappings.Add("Plazo", "Plazo")
  1512. tableMapping.ColumnMappings.Add("PlazoFact", "PlazoFact")
  1513. tableMapping.ColumnMappings.Add("Ingresos", "Ingresos")
  1514. tableMapping.ColumnMappings.Add("FechaDoc", "FechaDoc")
  1515. tableMapping.ColumnMappings.Add("AutEstado", "AutEstado")
  1516. tableMapping.ColumnMappings.Add("TipoMerc", "TipoMerc")
  1517. tableMapping.ColumnMappings.Add("CodPais", "CodPais")
  1518. Me._adapter.TableMappings.Add(tableMapping)
  1519. Me._adapter.DeleteCommand = New Global.System.Data.SqlClient.SqlCommand()
  1520. Me._adapter.DeleteCommand.Connection = Me.Connection
  1521. Me._adapter.DeleteCommand.CommandText = "DELETE FROM [dbo].[PIN0] WHERE (([DocId] = @Original_DocId) AND ((@IsNull_CodInv "& _
  1522. "= 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_CodInv)) AND ((@IsNull_DocEst"& _
  1523. " = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_DocEst)) AND ((@IsNull_Asunt"& _
  1524. "o = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_Asunto)) AND ((@IsNull_CodE"& _
  1525. "mpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Original_CodEmpr)) AND ((@IsNull"& _
  1526. "_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Original_CodIF)) AND ((@IsNull_Co"& _
  1527. "dEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Original_CodEmis)) AND ((@IsNu"& _
  1528. "ll_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi] = @Original_CodCalRi)) AN"& _
  1529. "D ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR ([CodECalRi] = @Original_C"& _
  1530. "odECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) OR ([OFon] = @Original_OFo"& _
  1531. "n)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR ([Coment] = @Original_Come"& _
  1532. "nt)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([Just] = @Original_Just)) AN"& _
  1533. "D ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR ([TipoOper] = @Original_Tipo"& _
  1534. "Oper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL) OR ([DocBase] = @Origina"& _
  1535. "l_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] IS NULL) OR ([MontoInv] = "& _
  1536. "@Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Precio] IS NULL) OR ([Precio]"& _
  1537. " = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AND [Rendimiento] IS NULL) O"& _
  1538. "R ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNull_Plazo = 1 AND [Plazo] I"& _
  1539. "S NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_PlazoFact = 1 AND [PlazoFa"& _
  1540. "ct] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) AND ((@IsNull_Ingresos = 1 "& _
  1541. "AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ingresos)) AND ((@IsNull_Fech"& _
  1542. "aDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Original_FechaDoc)) AND ((@Is"& _
  1543. "Null_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEstado] = @Original_AutEstad"& _
  1544. "o)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL) OR ([TipoMerc] = @Origina"& _
  1545. "l_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] IS NULL) OR ([CodPais] = @O"& _
  1546. "riginal_CodPais)))"
  1547. Me._adapter.DeleteCommand.CommandType = Global.System.Data.CommandType.Text
  1548. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocId", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocId", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1549. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodInv", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1550. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodInv", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1551. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_DocEst", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1552. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocEst", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1553. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Asunto", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1554. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Asunto", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1555. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodEmpr", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmpr", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1556. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodEmpr", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmpr", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1557. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodIF", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1558. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodIF", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1559. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1560. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1561. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodCalRi", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1562. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodCalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1563. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodECalRi", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1564. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodECalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1565. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_OFon", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1566. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_OFon", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1567. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Coment", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1568. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Coment", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1569. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Just", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1570. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Just", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1571. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_TipoOper", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1572. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_TipoOper", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1573. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1574. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1575. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_MontoInv", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "MontoInv", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1576. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_MontoInv", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "MontoInv", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1577. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Precio", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Precio", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1578. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Precio", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Precio", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1579. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Rendimiento", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Rendimiento", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1580. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Rendimiento", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Rendimiento", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1581. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1582. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1583. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_PlazoFact", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1584. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_PlazoFact", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1585. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Ingresos", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Ingresos", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1586. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Ingresos", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Ingresos", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1587. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_FechaDoc", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1588. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_FechaDoc", Global.System.Data.SqlDbType.DateTime, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1589. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_AutEstado", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1590. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_AutEstado", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1591. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_TipoMerc", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1592. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_TipoMerc", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1593. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodPais", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1594. Me._adapter.DeleteCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodPais", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1595. Me._adapter.InsertCommand = New Global.System.Data.SqlClient.SqlCommand()
  1596. Me._adapter.InsertCommand.Connection = Me.Connection
  1597. Me._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[PIN0] ([CodInv], [DocEst], [Asunto], [CodEmpr], [CodIF], [CodE"& _
  1598. "mis], [CodCalRi], [CodECalRi], [OFon], [Coment], [Just], [TipoOper], [DocBase], "& _
  1599. "[MontoInv], [Precio], [Rendimiento], [Plazo], [PlazoFact], [Ingresos], [FechaDoc"& _
  1600. "], [AutEstado], [TipoMerc], [CodPais]) VALUES (@CodInv, @DocEst, @Asunto, @CodEm"& _
  1601. "pr, @CodIF, @CodEmis, @CodCalRi, @CodECalRi, @OFon, @Coment, @Just, @TipoOper, @"& _
  1602. "DocBase, @MontoInv, @Precio, @Rendimiento, @Plazo, @PlazoFact, @Ingresos, @Fecha"& _
  1603. "Doc, @AutEstado, @TipoMerc, @CodPais);"&Global.Microsoft.VisualBasic.ChrW(13)&Global.Microsoft.VisualBasic.ChrW(10)&"SELECT DocId, CodInv, DocEst, Asunto, Co"& _
  1604. "dEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBas"& _
  1605. "e, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstad"& _
  1606. "o, TipoMerc, CodPais FROM PIN0 WHERE (DocId = SCOPE_IDENTITY())"
  1607. Me._adapter.InsertCommand.CommandType = Global.System.Data.CommandType.Text
  1608. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodInv", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1609. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@DocEst", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1610. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Asunto", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1611. 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, "", "", ""))
  1612. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodIF", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1613. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1614. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodCalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1615. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodECalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1616. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@OFon", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1617. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Coment", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1618. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Just", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1619. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@TipoOper", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1620. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1621. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@MontoInv", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "MontoInv", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1622. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Precio", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Precio", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1623. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Rendimiento", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Rendimiento", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1624. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1625. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@PlazoFact", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1626. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Ingresos", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Ingresos", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1627. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@FechaDoc", Global.System.Data.SqlDbType.DateTime, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1628. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@AutEstado", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1629. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@TipoMerc", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1630. Me._adapter.InsertCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodPais", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1631. Me._adapter.UpdateCommand = New Global.System.Data.SqlClient.SqlCommand()
  1632. Me._adapter.UpdateCommand.Connection = Me.Connection
  1633. Me._adapter.UpdateCommand.CommandText = "UPDATE [dbo].[PIN0] SET [CodInv] = @CodInv, [DocEst] = @DocEst, [Asunto] = @Asunt"& _
  1634. "o, [CodEmpr] = @CodEmpr, [CodIF] = @CodIF, [CodEmis] = @CodEmis, [CodCalRi] = @C"& _
  1635. "odCalRi, [CodECalRi] = @CodECalRi, [OFon] = @OFon, [Coment] = @Coment, [Just] = "& _
  1636. "@Just, [TipoOper] = @TipoOper, [DocBase] = @DocBase, [MontoInv] = @MontoInv, [Pr"& _
  1637. "ecio] = @Precio, [Rendimiento] = @Rendimiento, [Plazo] = @Plazo, [PlazoFact] = @"& _
  1638. "PlazoFact, [Ingresos] = @Ingresos, [FechaDoc] = @FechaDoc, [AutEstado] = @AutEst"& _
  1639. "ado, [TipoMerc] = @TipoMerc, [CodPais] = @CodPais WHERE (([DocId] = @Original_Do"& _
  1640. "cId) AND ((@IsNull_CodInv = 1 AND [CodInv] IS NULL) OR ([CodInv] = @Original_Cod"& _
  1641. "Inv)) AND ((@IsNull_DocEst = 1 AND [DocEst] IS NULL) OR ([DocEst] = @Original_Do"& _
  1642. "cEst)) AND ((@IsNull_Asunto = 1 AND [Asunto] IS NULL) OR ([Asunto] = @Original_A"& _
  1643. "sunto)) AND ((@IsNull_CodEmpr = 1 AND [CodEmpr] IS NULL) OR ([CodEmpr] = @Origin"& _
  1644. "al_CodEmpr)) AND ((@IsNull_CodIF = 1 AND [CodIF] IS NULL) OR ([CodIF] = @Origina"& _
  1645. "l_CodIF)) AND ((@IsNull_CodEmis = 1 AND [CodEmis] IS NULL) OR ([CodEmis] = @Orig"& _
  1646. "inal_CodEmis)) AND ((@IsNull_CodCalRi = 1 AND [CodCalRi] IS NULL) OR ([CodCalRi]"& _
  1647. " = @Original_CodCalRi)) AND ((@IsNull_CodECalRi = 1 AND [CodECalRi] IS NULL) OR "& _
  1648. "([CodECalRi] = @Original_CodECalRi)) AND ((@IsNull_OFon = 1 AND [OFon] IS NULL) "& _
  1649. "OR ([OFon] = @Original_OFon)) AND ((@IsNull_Coment = 1 AND [Coment] IS NULL) OR "& _
  1650. "([Coment] = @Original_Coment)) AND ((@IsNull_Just = 1 AND [Just] IS NULL) OR ([J"& _
  1651. "ust] = @Original_Just)) AND ((@IsNull_TipoOper = 1 AND [TipoOper] IS NULL) OR (["& _
  1652. "TipoOper] = @Original_TipoOper)) AND ((@IsNull_DocBase = 1 AND [DocBase] IS NULL"& _
  1653. ") OR ([DocBase] = @Original_DocBase)) AND ((@IsNull_MontoInv = 1 AND [MontoInv] "& _
  1654. "IS NULL) OR ([MontoInv] = @Original_MontoInv)) AND ((@IsNull_Precio = 1 AND [Pre"& _
  1655. "cio] IS NULL) OR ([Precio] = @Original_Precio)) AND ((@IsNull_Rendimiento = 1 AN"& _
  1656. "D [Rendimiento] IS NULL) OR ([Rendimiento] = @Original_Rendimiento)) AND ((@IsNu"& _
  1657. "ll_Plazo = 1 AND [Plazo] IS NULL) OR ([Plazo] = @Original_Plazo)) AND ((@IsNull_"& _
  1658. "PlazoFact = 1 AND [PlazoFact] IS NULL) OR ([PlazoFact] = @Original_PlazoFact)) A"& _
  1659. "ND ((@IsNull_Ingresos = 1 AND [Ingresos] IS NULL) OR ([Ingresos] = @Original_Ing"& _
  1660. "resos)) AND ((@IsNull_FechaDoc = 1 AND [FechaDoc] IS NULL) OR ([FechaDoc] = @Ori"& _
  1661. "ginal_FechaDoc)) AND ((@IsNull_AutEstado = 1 AND [AutEstado] IS NULL) OR ([AutEs"& _
  1662. "tado] = @Original_AutEstado)) AND ((@IsNull_TipoMerc = 1 AND [TipoMerc] IS NULL)"& _
  1663. " OR ([TipoMerc] = @Original_TipoMerc)) AND ((@IsNull_CodPais = 1 AND [CodPais] I"& _
  1664. "S NULL) OR ([CodPais] = @Original_CodPais)));"&Global.Microsoft.VisualBasic.ChrW(13)&Global.Microsoft.VisualBasic.ChrW(10)&"SELECT DocId, CodInv, DocEst, Asu"& _
  1665. "nto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper,"& _
  1666. " DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, A"& _
  1667. "utEstado, TipoMerc, CodPais FROM PIN0 WHERE (DocId = @DocId)"
  1668. Me._adapter.UpdateCommand.CommandType = Global.System.Data.CommandType.Text
  1669. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodInv", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1670. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@DocEst", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1671. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Asunto", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1672. Me._adapter.UpdateCommand.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, "", "", ""))
  1673. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodIF", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1674. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1675. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodCalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1676. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodECalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1677. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@OFon", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1678. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Coment", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1679. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Just", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1680. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@TipoOper", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1681. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1682. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@MontoInv", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "MontoInv", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1683. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Precio", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Precio", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1684. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Rendimiento", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Rendimiento", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1685. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1686. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@PlazoFact", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1687. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Ingresos", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Ingresos", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1688. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@FechaDoc", Global.System.Data.SqlDbType.DateTime, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1689. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@AutEstado", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1690. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@TipoMerc", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1691. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@CodPais", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1692. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocId", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocId", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1693. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodInv", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1694. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodInv", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodInv", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1695. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_DocEst", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1696. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocEst", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocEst", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1697. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Asunto", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1698. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Asunto", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Asunto", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1699. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodEmpr", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmpr", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1700. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodEmpr", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmpr", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1701. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodIF", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1702. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodIF", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodIF", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1703. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1704. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodEmis", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodEmis", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1705. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodCalRi", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1706. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodCalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodCalRi", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1707. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodECalRi", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1708. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodECalRi", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodECalRi", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1709. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_OFon", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1710. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_OFon", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "OFon", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1711. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Coment", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1712. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Coment", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Coment", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1713. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Just", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1714. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Just", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Just", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1715. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_TipoOper", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1716. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_TipoOper", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoOper", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1717. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1718. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_DocBase", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "DocBase", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1719. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_MontoInv", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "MontoInv", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1720. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_MontoInv", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "MontoInv", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1721. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Precio", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Precio", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1722. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Precio", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Precio", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1723. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Rendimiento", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Rendimiento", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1724. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Rendimiento", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Rendimiento", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1725. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1726. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Plazo", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Plazo", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1727. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_PlazoFact", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1728. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_PlazoFact", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "PlazoFact", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1729. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_Ingresos", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "Ingresos", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1730. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_Ingresos", Global.System.Data.SqlDbType.[Decimal], 0, Global.System.Data.ParameterDirection.Input, 18, 6, "Ingresos", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1731. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_FechaDoc", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1732. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_FechaDoc", Global.System.Data.SqlDbType.DateTime, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "FechaDoc", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1733. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_AutEstado", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1734. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_AutEstado", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "AutEstado", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1735. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_TipoMerc", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1736. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_TipoMerc", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "TipoMerc", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1737. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@IsNull_CodPais", Global.System.Data.SqlDbType.Int, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Original, true, Nothing, "", "", ""))
  1738. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@Original_CodPais", Global.System.Data.SqlDbType.VarChar, 0, Global.System.Data.ParameterDirection.Input, 0, 0, "CodPais", Global.System.Data.DataRowVersion.Original, false, Nothing, "", "", ""))
  1739. Me._adapter.UpdateCommand.Parameters.Add(New Global.System.Data.SqlClient.SqlParameter("@DocId", Global.System.Data.SqlDbType.Int, 4, Global.System.Data.ParameterDirection.Input, 0, 0, "DocId", Global.System.Data.DataRowVersion.Current, false, Nothing, "", "", ""))
  1740. End Sub
  1741. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1742. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1743. Private Sub InitConnection()
  1744. Me._connection = New Global.System.Data.SqlClient.SqlConnection()
  1745. Me._connection.ConnectionString = Global.Inversiones.My.MySettings.Default.InversionesConnectionString
  1746. End Sub
  1747. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1748. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  1749. Private Sub InitCommandCollection()
  1750. Me._commandCollection = New Global.System.Data.SqlClient.SqlCommand(0) {}
  1751. Me._commandCollection(0) = New Global.System.Data.SqlClient.SqlCommand()
  1752. Me._commandCollection(0).Connection = Me.Connection
  1753. Me._commandCollection(0).CommandText = "SELECT DocId, CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalR"& _
  1754. "i, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, "& _
  1755. "PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais FROM dbo.PIN0"
  1756. Me._commandCollection(0).CommandType = Global.System.Data.CommandType.Text
  1757. End Sub
  1758. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1759. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1760. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  1761. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Fill, true)> _
  1762. Public Overloads Overridable Function Fill(ByVal dataTable As InversionesDataSet.PIN0DataTable) As Integer
  1763. Me.Adapter.SelectCommand = Me.CommandCollection(0)
  1764. If (Me.ClearBeforeFill = true) Then
  1765. dataTable.Clear
  1766. End If
  1767. Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
  1768. Return returnValue
  1769. End Function
  1770. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1771. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1772. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  1773. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.[Select], true)> _
  1774. Public Overloads Overridable Function GetData() As InversionesDataSet.PIN0DataTable
  1775. Me.Adapter.SelectCommand = Me.CommandCollection(0)
  1776. Dim dataTable As InversionesDataSet.PIN0DataTable = New InversionesDataSet.PIN0DataTable()
  1777. Me.Adapter.Fill(dataTable)
  1778. Return dataTable
  1779. End Function
  1780. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1781. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1782. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  1783. Public Overloads Overridable Function Update(ByVal dataTable As InversionesDataSet.PIN0DataTable) As Integer
  1784. Return Me.Adapter.Update(dataTable)
  1785. End Function
  1786. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1787. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1788. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  1789. Public Overloads Overridable Function Update(ByVal dataSet As InversionesDataSet) As Integer
  1790. Return Me.Adapter.Update(dataSet, "PIN0")
  1791. End Function
  1792. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1793. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1794. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  1795. Public Overloads Overridable Function Update(ByVal dataRow As Global.System.Data.DataRow) As Integer
  1796. Return Me.Adapter.Update(New Global.System.Data.DataRow() {dataRow})
  1797. End Function
  1798. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1799. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1800. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")> _
  1801. Public Overloads Overridable Function Update(ByVal dataRows() As Global.System.Data.DataRow) As Integer
  1802. Return Me.Adapter.Update(dataRows)
  1803. End Function
  1804. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  1805. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  1806. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  1807. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Delete, true)> _
  1808. Public Overloads Overridable Function Delete( _
  1809. ByVal Original_DocId As Integer, _
  1810. ByVal Original_CodInv As String, _
  1811. ByVal Original_DocEst As String, _
  1812. ByVal Original_Asunto As String, _
  1813. ByVal Original_CodEmpr As String, _
  1814. ByVal Original_CodIF As String, _
  1815. ByVal Original_CodEmis As Global.System.Nullable(Of Integer), _
  1816. ByVal Original_CodCalRi As String, _
  1817. ByVal Original_CodECalRi As String, _
  1818. ByVal Original_OFon As String, _
  1819. ByVal Original_Coment As String, _
  1820. ByVal Original_Just As String, _
  1821. ByVal Original_TipoOper As String, _
  1822. ByVal Original_DocBase As Global.System.Nullable(Of Integer), _
  1823. ByVal Original_MontoInv As Global.System.Nullable(Of Decimal), _
  1824. ByVal Original_Precio As Global.System.Nullable(Of Decimal), _
  1825. ByVal Original_Rendimiento As Global.System.Nullable(Of Decimal), _
  1826. ByVal Original_Plazo As Global.System.Nullable(Of Integer), _
  1827. ByVal Original_PlazoFact As String, _
  1828. ByVal Original_Ingresos As Global.System.Nullable(Of Decimal), _
  1829. ByVal Original_FechaDoc As Global.System.Nullable(Of Date), _
  1830. ByVal Original_AutEstado As String, _
  1831. ByVal Original_TipoMerc As String, _
  1832. ByVal Original_CodPais As String) As Integer
  1833. Me.Adapter.DeleteCommand.Parameters(0).Value = CType(Original_DocId,Integer)
  1834. If (Original_CodInv Is Nothing) Then
  1835. Me.Adapter.DeleteCommand.Parameters(1).Value = CType(1,Object)
  1836. Me.Adapter.DeleteCommand.Parameters(2).Value = Global.System.DBNull.Value
  1837. Else
  1838. Me.Adapter.DeleteCommand.Parameters(1).Value = CType(0,Object)
  1839. Me.Adapter.DeleteCommand.Parameters(2).Value = CType(Original_CodInv,String)
  1840. End If
  1841. If (Original_DocEst Is Nothing) Then
  1842. Me.Adapter.DeleteCommand.Parameters(3).Value = CType(1,Object)
  1843. Me.Adapter.DeleteCommand.Parameters(4).Value = Global.System.DBNull.Value
  1844. Else
  1845. Me.Adapter.DeleteCommand.Parameters(3).Value = CType(0,Object)
  1846. Me.Adapter.DeleteCommand.Parameters(4).Value = CType(Original_DocEst,String)
  1847. End If
  1848. If (Original_Asunto Is Nothing) Then
  1849. Me.Adapter.DeleteCommand.Parameters(5).Value = CType(1,Object)
  1850. Me.Adapter.DeleteCommand.Parameters(6).Value = Global.System.DBNull.Value
  1851. Else
  1852. Me.Adapter.DeleteCommand.Parameters(5).Value = CType(0,Object)
  1853. Me.Adapter.DeleteCommand.Parameters(6).Value = CType(Original_Asunto,String)
  1854. End If
  1855. If (Original_CodEmpr Is Nothing) Then
  1856. Me.Adapter.DeleteCommand.Parameters(7).Value = CType(1,Object)
  1857. Me.Adapter.DeleteCommand.Parameters(8).Value = Global.System.DBNull.Value
  1858. Else
  1859. Me.Adapter.DeleteCommand.Parameters(7).Value = CType(0,Object)
  1860. Me.Adapter.DeleteCommand.Parameters(8).Value = CType(Original_CodEmpr,String)
  1861. End If
  1862. If (Original_CodIF Is Nothing) Then
  1863. Me.Adapter.DeleteCommand.Parameters(9).Value = CType(1,Object)
  1864. Me.Adapter.DeleteCommand.Parameters(10).Value = Global.System.DBNull.Value
  1865. Else
  1866. Me.Adapter.DeleteCommand.Parameters(9).Value = CType(0,Object)
  1867. Me.Adapter.DeleteCommand.Parameters(10).Value = CType(Original_CodIF,String)
  1868. End If
  1869. If (Original_CodEmis.HasValue = true) Then
  1870. Me.Adapter.DeleteCommand.Parameters(11).Value = CType(0,Object)
  1871. Me.Adapter.DeleteCommand.Parameters(12).Value = CType(Original_CodEmis.Value,Integer)
  1872. Else
  1873. Me.Adapter.DeleteCommand.Parameters(11).Value = CType(1,Object)
  1874. Me.Adapter.DeleteCommand.Parameters(12).Value = Global.System.DBNull.Value
  1875. End If
  1876. If (Original_CodCalRi Is Nothing) Then
  1877. Me.Adapter.DeleteCommand.Parameters(13).Value = CType(1,Object)
  1878. Me.Adapter.DeleteCommand.Parameters(14).Value = Global.System.DBNull.Value
  1879. Else
  1880. Me.Adapter.DeleteCommand.Parameters(13).Value = CType(0,Object)
  1881. Me.Adapter.DeleteCommand.Parameters(14).Value = CType(Original_CodCalRi,String)
  1882. End If
  1883. If (Original_CodECalRi Is Nothing) Then
  1884. Me.Adapter.DeleteCommand.Parameters(15).Value = CType(1,Object)
  1885. Me.Adapter.DeleteCommand.Parameters(16).Value = Global.System.DBNull.Value
  1886. Else
  1887. Me.Adapter.DeleteCommand.Parameters(15).Value = CType(0,Object)
  1888. Me.Adapter.DeleteCommand.Parameters(16).Value = CType(Original_CodECalRi,String)
  1889. End If
  1890. If (Original_OFon Is Nothing) Then
  1891. Me.Adapter.DeleteCommand.Parameters(17).Value = CType(1,Object)
  1892. Me.Adapter.DeleteCommand.Parameters(18).Value = Global.System.DBNull.Value
  1893. Else
  1894. Me.Adapter.DeleteCommand.Parameters(17).Value = CType(0,Object)
  1895. Me.Adapter.DeleteCommand.Parameters(18).Value = CType(Original_OFon,String)
  1896. End If
  1897. If (Original_Coment Is Nothing) Then
  1898. Me.Adapter.DeleteCommand.Parameters(19).Value = CType(1,Object)
  1899. Me.Adapter.DeleteCommand.Parameters(20).Value = Global.System.DBNull.Value
  1900. Else
  1901. Me.Adapter.DeleteCommand.Parameters(19).Value = CType(0,Object)
  1902. Me.Adapter.DeleteCommand.Parameters(20).Value = CType(Original_Coment,String)
  1903. End If
  1904. If (Original_Just Is Nothing) Then
  1905. Me.Adapter.DeleteCommand.Parameters(21).Value = CType(1,Object)
  1906. Me.Adapter.DeleteCommand.Parameters(22).Value = Global.System.DBNull.Value
  1907. Else
  1908. Me.Adapter.DeleteCommand.Parameters(21).Value = CType(0,Object)
  1909. Me.Adapter.DeleteCommand.Parameters(22).Value = CType(Original_Just,String)
  1910. End If
  1911. If (Original_TipoOper Is Nothing) Then
  1912. Me.Adapter.DeleteCommand.Parameters(23).Value = CType(1,Object)
  1913. Me.Adapter.DeleteCommand.Parameters(24).Value = Global.System.DBNull.Value
  1914. Else
  1915. Me.Adapter.DeleteCommand.Parameters(23).Value = CType(0,Object)
  1916. Me.Adapter.DeleteCommand.Parameters(24).Value = CType(Original_TipoOper,String)
  1917. End If
  1918. If (Original_DocBase.HasValue = true) Then
  1919. Me.Adapter.DeleteCommand.Parameters(25).Value = CType(0,Object)
  1920. Me.Adapter.DeleteCommand.Parameters(26).Value = CType(Original_DocBase.Value,Integer)
  1921. Else
  1922. Me.Adapter.DeleteCommand.Parameters(25).Value = CType(1,Object)
  1923. Me.Adapter.DeleteCommand.Parameters(26).Value = Global.System.DBNull.Value
  1924. End If
  1925. If (Original_MontoInv.HasValue = true) Then
  1926. Me.Adapter.DeleteCommand.Parameters(27).Value = CType(0,Object)
  1927. Me.Adapter.DeleteCommand.Parameters(28).Value = CType(Original_MontoInv.Value,Decimal)
  1928. Else
  1929. Me.Adapter.DeleteCommand.Parameters(27).Value = CType(1,Object)
  1930. Me.Adapter.DeleteCommand.Parameters(28).Value = Global.System.DBNull.Value
  1931. End If
  1932. If (Original_Precio.HasValue = true) Then
  1933. Me.Adapter.DeleteCommand.Parameters(29).Value = CType(0,Object)
  1934. Me.Adapter.DeleteCommand.Parameters(30).Value = CType(Original_Precio.Value,Decimal)
  1935. Else
  1936. Me.Adapter.DeleteCommand.Parameters(29).Value = CType(1,Object)
  1937. Me.Adapter.DeleteCommand.Parameters(30).Value = Global.System.DBNull.Value
  1938. End If
  1939. If (Original_Rendimiento.HasValue = true) Then
  1940. Me.Adapter.DeleteCommand.Parameters(31).Value = CType(0,Object)
  1941. Me.Adapter.DeleteCommand.Parameters(32).Value = CType(Original_Rendimiento.Value,Decimal)
  1942. Else
  1943. Me.Adapter.DeleteCommand.Parameters(31).Value = CType(1,Object)
  1944. Me.Adapter.DeleteCommand.Parameters(32).Value = Global.System.DBNull.Value
  1945. End If
  1946. If (Original_Plazo.HasValue = true) Then
  1947. Me.Adapter.DeleteCommand.Parameters(33).Value = CType(0,Object)
  1948. Me.Adapter.DeleteCommand.Parameters(34).Value = CType(Original_Plazo.Value,Integer)
  1949. Else
  1950. Me.Adapter.DeleteCommand.Parameters(33).Value = CType(1,Object)
  1951. Me.Adapter.DeleteCommand.Parameters(34).Value = Global.System.DBNull.Value
  1952. End If
  1953. If (Original_PlazoFact Is Nothing) Then
  1954. Me.Adapter.DeleteCommand.Parameters(35).Value = CType(1,Object)
  1955. Me.Adapter.DeleteCommand.Parameters(36).Value = Global.System.DBNull.Value
  1956. Else
  1957. Me.Adapter.DeleteCommand.Parameters(35).Value = CType(0,Object)
  1958. Me.Adapter.DeleteCommand.Parameters(36).Value = CType(Original_PlazoFact,String)
  1959. End If
  1960. If (Original_Ingresos.HasValue = true) Then
  1961. Me.Adapter.DeleteCommand.Parameters(37).Value = CType(0,Object)
  1962. Me.Adapter.DeleteCommand.Parameters(38).Value = CType(Original_Ingresos.Value,Decimal)
  1963. Else
  1964. Me.Adapter.DeleteCommand.Parameters(37).Value = CType(1,Object)
  1965. Me.Adapter.DeleteCommand.Parameters(38).Value = Global.System.DBNull.Value
  1966. End If
  1967. If (Original_FechaDoc.HasValue = true) Then
  1968. Me.Adapter.DeleteCommand.Parameters(39).Value = CType(0,Object)
  1969. Me.Adapter.DeleteCommand.Parameters(40).Value = CType(Original_FechaDoc.Value,Date)
  1970. Else
  1971. Me.Adapter.DeleteCommand.Parameters(39).Value = CType(1,Object)
  1972. Me.Adapter.DeleteCommand.Parameters(40).Value = Global.System.DBNull.Value
  1973. End If
  1974. If (Original_AutEstado Is Nothing) Then
  1975. Me.Adapter.DeleteCommand.Parameters(41).Value = CType(1,Object)
  1976. Me.Adapter.DeleteCommand.Parameters(42).Value = Global.System.DBNull.Value
  1977. Else
  1978. Me.Adapter.DeleteCommand.Parameters(41).Value = CType(0,Object)
  1979. Me.Adapter.DeleteCommand.Parameters(42).Value = CType(Original_AutEstado,String)
  1980. End If
  1981. If (Original_TipoMerc Is Nothing) Then
  1982. Me.Adapter.DeleteCommand.Parameters(43).Value = CType(1,Object)
  1983. Me.Adapter.DeleteCommand.Parameters(44).Value = Global.System.DBNull.Value
  1984. Else
  1985. Me.Adapter.DeleteCommand.Parameters(43).Value = CType(0,Object)
  1986. Me.Adapter.DeleteCommand.Parameters(44).Value = CType(Original_TipoMerc,String)
  1987. End If
  1988. If (Original_CodPais Is Nothing) Then
  1989. Me.Adapter.DeleteCommand.Parameters(45).Value = CType(1,Object)
  1990. Me.Adapter.DeleteCommand.Parameters(46).Value = Global.System.DBNull.Value
  1991. Else
  1992. Me.Adapter.DeleteCommand.Parameters(45).Value = CType(0,Object)
  1993. Me.Adapter.DeleteCommand.Parameters(46).Value = CType(Original_CodPais,String)
  1994. End If
  1995. Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.DeleteCommand.Connection.State
  1996. If ((Me.Adapter.DeleteCommand.Connection.State And Global.System.Data.ConnectionState.Open) _
  1997. <> Global.System.Data.ConnectionState.Open) Then
  1998. Me.Adapter.DeleteCommand.Connection.Open
  1999. End If
  2000. Try
  2001. Dim returnValue As Integer = Me.Adapter.DeleteCommand.ExecuteNonQuery
  2002. Return returnValue
  2003. Finally
  2004. If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Then
  2005. Me.Adapter.DeleteCommand.Connection.Close
  2006. End If
  2007. End Try
  2008. End Function
  2009. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2010. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2011. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  2012. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Insert, true)> _
  2013. Public Overloads Overridable Function Insert( _
  2014. ByVal CodInv As String, _
  2015. ByVal DocEst As String, _
  2016. ByVal Asunto As String, _
  2017. ByVal CodEmpr As String, _
  2018. ByVal CodIF As String, _
  2019. ByVal CodEmis As Global.System.Nullable(Of Integer), _
  2020. ByVal CodCalRi As String, _
  2021. ByVal CodECalRi As String, _
  2022. ByVal OFon As String, _
  2023. ByVal Coment As String, _
  2024. ByVal Just As String, _
  2025. ByVal TipoOper As String, _
  2026. ByVal DocBase As Global.System.Nullable(Of Integer), _
  2027. ByVal MontoInv As Global.System.Nullable(Of Decimal), _
  2028. ByVal Precio As Global.System.Nullable(Of Decimal), _
  2029. ByVal Rendimiento As Global.System.Nullable(Of Decimal), _
  2030. ByVal Plazo As Global.System.Nullable(Of Integer), _
  2031. ByVal PlazoFact As String, _
  2032. ByVal Ingresos As Global.System.Nullable(Of Decimal), _
  2033. ByVal FechaDoc As Global.System.Nullable(Of Date), _
  2034. ByVal AutEstado As String, _
  2035. ByVal TipoMerc As String, _
  2036. ByVal CodPais As String) As Integer
  2037. If (CodInv Is Nothing) Then
  2038. Me.Adapter.InsertCommand.Parameters(0).Value = Global.System.DBNull.Value
  2039. Else
  2040. Me.Adapter.InsertCommand.Parameters(0).Value = CType(CodInv,String)
  2041. End If
  2042. If (DocEst Is Nothing) Then
  2043. Me.Adapter.InsertCommand.Parameters(1).Value = Global.System.DBNull.Value
  2044. Else
  2045. Me.Adapter.InsertCommand.Parameters(1).Value = CType(DocEst,String)
  2046. End If
  2047. If (Asunto Is Nothing) Then
  2048. Me.Adapter.InsertCommand.Parameters(2).Value = Global.System.DBNull.Value
  2049. Else
  2050. Me.Adapter.InsertCommand.Parameters(2).Value = CType(Asunto,String)
  2051. End If
  2052. If (CodEmpr Is Nothing) Then
  2053. Me.Adapter.InsertCommand.Parameters(3).Value = Global.System.DBNull.Value
  2054. Else
  2055. Me.Adapter.InsertCommand.Parameters(3).Value = CType(CodEmpr,String)
  2056. End If
  2057. If (CodIF Is Nothing) Then
  2058. Me.Adapter.InsertCommand.Parameters(4).Value = Global.System.DBNull.Value
  2059. Else
  2060. Me.Adapter.InsertCommand.Parameters(4).Value = CType(CodIF,String)
  2061. End If
  2062. If (CodEmis.HasValue = true) Then
  2063. Me.Adapter.InsertCommand.Parameters(5).Value = CType(CodEmis.Value,Integer)
  2064. Else
  2065. Me.Adapter.InsertCommand.Parameters(5).Value = Global.System.DBNull.Value
  2066. End If
  2067. If (CodCalRi Is Nothing) Then
  2068. Me.Adapter.InsertCommand.Parameters(6).Value = Global.System.DBNull.Value
  2069. Else
  2070. Me.Adapter.InsertCommand.Parameters(6).Value = CType(CodCalRi,String)
  2071. End If
  2072. If (CodECalRi Is Nothing) Then
  2073. Me.Adapter.InsertCommand.Parameters(7).Value = Global.System.DBNull.Value
  2074. Else
  2075. Me.Adapter.InsertCommand.Parameters(7).Value = CType(CodECalRi,String)
  2076. End If
  2077. If (OFon Is Nothing) Then
  2078. Me.Adapter.InsertCommand.Parameters(8).Value = Global.System.DBNull.Value
  2079. Else
  2080. Me.Adapter.InsertCommand.Parameters(8).Value = CType(OFon,String)
  2081. End If
  2082. If (Coment Is Nothing) Then
  2083. Me.Adapter.InsertCommand.Parameters(9).Value = Global.System.DBNull.Value
  2084. Else
  2085. Me.Adapter.InsertCommand.Parameters(9).Value = CType(Coment,String)
  2086. End If
  2087. If (Just Is Nothing) Then
  2088. Me.Adapter.InsertCommand.Parameters(10).Value = Global.System.DBNull.Value
  2089. Else
  2090. Me.Adapter.InsertCommand.Parameters(10).Value = CType(Just,String)
  2091. End If
  2092. If (TipoOper Is Nothing) Then
  2093. Me.Adapter.InsertCommand.Parameters(11).Value = Global.System.DBNull.Value
  2094. Else
  2095. Me.Adapter.InsertCommand.Parameters(11).Value = CType(TipoOper,String)
  2096. End If
  2097. If (DocBase.HasValue = true) Then
  2098. Me.Adapter.InsertCommand.Parameters(12).Value = CType(DocBase.Value,Integer)
  2099. Else
  2100. Me.Adapter.InsertCommand.Parameters(12).Value = Global.System.DBNull.Value
  2101. End If
  2102. If (MontoInv.HasValue = true) Then
  2103. Me.Adapter.InsertCommand.Parameters(13).Value = CType(MontoInv.Value,Decimal)
  2104. Else
  2105. Me.Adapter.InsertCommand.Parameters(13).Value = Global.System.DBNull.Value
  2106. End If
  2107. If (Precio.HasValue = true) Then
  2108. Me.Adapter.InsertCommand.Parameters(14).Value = CType(Precio.Value,Decimal)
  2109. Else
  2110. Me.Adapter.InsertCommand.Parameters(14).Value = Global.System.DBNull.Value
  2111. End If
  2112. If (Rendimiento.HasValue = true) Then
  2113. Me.Adapter.InsertCommand.Parameters(15).Value = CType(Rendimiento.Value,Decimal)
  2114. Else
  2115. Me.Adapter.InsertCommand.Parameters(15).Value = Global.System.DBNull.Value
  2116. End If
  2117. If (Plazo.HasValue = true) Then
  2118. Me.Adapter.InsertCommand.Parameters(16).Value = CType(Plazo.Value,Integer)
  2119. Else
  2120. Me.Adapter.InsertCommand.Parameters(16).Value = Global.System.DBNull.Value
  2121. End If
  2122. If (PlazoFact Is Nothing) Then
  2123. Me.Adapter.InsertCommand.Parameters(17).Value = Global.System.DBNull.Value
  2124. Else
  2125. Me.Adapter.InsertCommand.Parameters(17).Value = CType(PlazoFact,String)
  2126. End If
  2127. If (Ingresos.HasValue = true) Then
  2128. Me.Adapter.InsertCommand.Parameters(18).Value = CType(Ingresos.Value,Decimal)
  2129. Else
  2130. Me.Adapter.InsertCommand.Parameters(18).Value = Global.System.DBNull.Value
  2131. End If
  2132. If (FechaDoc.HasValue = true) Then
  2133. Me.Adapter.InsertCommand.Parameters(19).Value = CType(FechaDoc.Value,Date)
  2134. Else
  2135. Me.Adapter.InsertCommand.Parameters(19).Value = Global.System.DBNull.Value
  2136. End If
  2137. If (AutEstado Is Nothing) Then
  2138. Me.Adapter.InsertCommand.Parameters(20).Value = Global.System.DBNull.Value
  2139. Else
  2140. Me.Adapter.InsertCommand.Parameters(20).Value = CType(AutEstado,String)
  2141. End If
  2142. If (TipoMerc Is Nothing) Then
  2143. Me.Adapter.InsertCommand.Parameters(21).Value = Global.System.DBNull.Value
  2144. Else
  2145. Me.Adapter.InsertCommand.Parameters(21).Value = CType(TipoMerc,String)
  2146. End If
  2147. If (CodPais Is Nothing) Then
  2148. Me.Adapter.InsertCommand.Parameters(22).Value = Global.System.DBNull.Value
  2149. Else
  2150. Me.Adapter.InsertCommand.Parameters(22).Value = CType(CodPais,String)
  2151. End If
  2152. Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.InsertCommand.Connection.State
  2153. If ((Me.Adapter.InsertCommand.Connection.State And Global.System.Data.ConnectionState.Open) _
  2154. <> Global.System.Data.ConnectionState.Open) Then
  2155. Me.Adapter.InsertCommand.Connection.Open
  2156. End If
  2157. Try
  2158. Dim returnValue As Integer = Me.Adapter.InsertCommand.ExecuteNonQuery
  2159. Return returnValue
  2160. Finally
  2161. If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Then
  2162. Me.Adapter.InsertCommand.Connection.Close
  2163. End If
  2164. End Try
  2165. End Function
  2166. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2167. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2168. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  2169. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Update, true)> _
  2170. Public Overloads Overridable Function Update( _
  2171. ByVal CodInv As String, _
  2172. ByVal DocEst As String, _
  2173. ByVal Asunto As String, _
  2174. ByVal CodEmpr As String, _
  2175. ByVal CodIF As String, _
  2176. ByVal CodEmis As Global.System.Nullable(Of Integer), _
  2177. ByVal CodCalRi As String, _
  2178. ByVal CodECalRi As String, _
  2179. ByVal OFon As String, _
  2180. ByVal Coment As String, _
  2181. ByVal Just As String, _
  2182. ByVal TipoOper As String, _
  2183. ByVal DocBase As Global.System.Nullable(Of Integer), _
  2184. ByVal MontoInv As Global.System.Nullable(Of Decimal), _
  2185. ByVal Precio As Global.System.Nullable(Of Decimal), _
  2186. ByVal Rendimiento As Global.System.Nullable(Of Decimal), _
  2187. ByVal Plazo As Global.System.Nullable(Of Integer), _
  2188. ByVal PlazoFact As String, _
  2189. ByVal Ingresos As Global.System.Nullable(Of Decimal), _
  2190. ByVal FechaDoc As Global.System.Nullable(Of Date), _
  2191. ByVal AutEstado As String, _
  2192. ByVal TipoMerc As String, _
  2193. ByVal CodPais As String, _
  2194. ByVal Original_DocId As Integer, _
  2195. ByVal Original_CodInv As String, _
  2196. ByVal Original_DocEst As String, _
  2197. ByVal Original_Asunto As String, _
  2198. ByVal Original_CodEmpr As String, _
  2199. ByVal Original_CodIF As String, _
  2200. ByVal Original_CodEmis As Global.System.Nullable(Of Integer), _
  2201. ByVal Original_CodCalRi As String, _
  2202. ByVal Original_CodECalRi As String, _
  2203. ByVal Original_OFon As String, _
  2204. ByVal Original_Coment As String, _
  2205. ByVal Original_Just As String, _
  2206. ByVal Original_TipoOper As String, _
  2207. ByVal Original_DocBase As Global.System.Nullable(Of Integer), _
  2208. ByVal Original_MontoInv As Global.System.Nullable(Of Decimal), _
  2209. ByVal Original_Precio As Global.System.Nullable(Of Decimal), _
  2210. ByVal Original_Rendimiento As Global.System.Nullable(Of Decimal), _
  2211. ByVal Original_Plazo As Global.System.Nullable(Of Integer), _
  2212. ByVal Original_PlazoFact As String, _
  2213. ByVal Original_Ingresos As Global.System.Nullable(Of Decimal), _
  2214. ByVal Original_FechaDoc As Global.System.Nullable(Of Date), _
  2215. ByVal Original_AutEstado As String, _
  2216. ByVal Original_TipoMerc As String, _
  2217. ByVal Original_CodPais As String, _
  2218. ByVal DocId As Integer) As Integer
  2219. If (CodInv Is Nothing) Then
  2220. Me.Adapter.UpdateCommand.Parameters(0).Value = Global.System.DBNull.Value
  2221. Else
  2222. Me.Adapter.UpdateCommand.Parameters(0).Value = CType(CodInv,String)
  2223. End If
  2224. If (DocEst Is Nothing) Then
  2225. Me.Adapter.UpdateCommand.Parameters(1).Value = Global.System.DBNull.Value
  2226. Else
  2227. Me.Adapter.UpdateCommand.Parameters(1).Value = CType(DocEst,String)
  2228. End If
  2229. If (Asunto Is Nothing) Then
  2230. Me.Adapter.UpdateCommand.Parameters(2).Value = Global.System.DBNull.Value
  2231. Else
  2232. Me.Adapter.UpdateCommand.Parameters(2).Value = CType(Asunto,String)
  2233. End If
  2234. If (CodEmpr Is Nothing) Then
  2235. Me.Adapter.UpdateCommand.Parameters(3).Value = Global.System.DBNull.Value
  2236. Else
  2237. Me.Adapter.UpdateCommand.Parameters(3).Value = CType(CodEmpr,String)
  2238. End If
  2239. If (CodIF Is Nothing) Then
  2240. Me.Adapter.UpdateCommand.Parameters(4).Value = Global.System.DBNull.Value
  2241. Else
  2242. Me.Adapter.UpdateCommand.Parameters(4).Value = CType(CodIF,String)
  2243. End If
  2244. If (CodEmis.HasValue = true) Then
  2245. Me.Adapter.UpdateCommand.Parameters(5).Value = CType(CodEmis.Value,Integer)
  2246. Else
  2247. Me.Adapter.UpdateCommand.Parameters(5).Value = Global.System.DBNull.Value
  2248. End If
  2249. If (CodCalRi Is Nothing) Then
  2250. Me.Adapter.UpdateCommand.Parameters(6).Value = Global.System.DBNull.Value
  2251. Else
  2252. Me.Adapter.UpdateCommand.Parameters(6).Value = CType(CodCalRi,String)
  2253. End If
  2254. If (CodECalRi Is Nothing) Then
  2255. Me.Adapter.UpdateCommand.Parameters(7).Value = Global.System.DBNull.Value
  2256. Else
  2257. Me.Adapter.UpdateCommand.Parameters(7).Value = CType(CodECalRi,String)
  2258. End If
  2259. If (OFon Is Nothing) Then
  2260. Me.Adapter.UpdateCommand.Parameters(8).Value = Global.System.DBNull.Value
  2261. Else
  2262. Me.Adapter.UpdateCommand.Parameters(8).Value = CType(OFon,String)
  2263. End If
  2264. If (Coment Is Nothing) Then
  2265. Me.Adapter.UpdateCommand.Parameters(9).Value = Global.System.DBNull.Value
  2266. Else
  2267. Me.Adapter.UpdateCommand.Parameters(9).Value = CType(Coment,String)
  2268. End If
  2269. If (Just Is Nothing) Then
  2270. Me.Adapter.UpdateCommand.Parameters(10).Value = Global.System.DBNull.Value
  2271. Else
  2272. Me.Adapter.UpdateCommand.Parameters(10).Value = CType(Just,String)
  2273. End If
  2274. If (TipoOper Is Nothing) Then
  2275. Me.Adapter.UpdateCommand.Parameters(11).Value = Global.System.DBNull.Value
  2276. Else
  2277. Me.Adapter.UpdateCommand.Parameters(11).Value = CType(TipoOper,String)
  2278. End If
  2279. If (DocBase.HasValue = true) Then
  2280. Me.Adapter.UpdateCommand.Parameters(12).Value = CType(DocBase.Value,Integer)
  2281. Else
  2282. Me.Adapter.UpdateCommand.Parameters(12).Value = Global.System.DBNull.Value
  2283. End If
  2284. If (MontoInv.HasValue = true) Then
  2285. Me.Adapter.UpdateCommand.Parameters(13).Value = CType(MontoInv.Value,Decimal)
  2286. Else
  2287. Me.Adapter.UpdateCommand.Parameters(13).Value = Global.System.DBNull.Value
  2288. End If
  2289. If (Precio.HasValue = true) Then
  2290. Me.Adapter.UpdateCommand.Parameters(14).Value = CType(Precio.Value,Decimal)
  2291. Else
  2292. Me.Adapter.UpdateCommand.Parameters(14).Value = Global.System.DBNull.Value
  2293. End If
  2294. If (Rendimiento.HasValue = true) Then
  2295. Me.Adapter.UpdateCommand.Parameters(15).Value = CType(Rendimiento.Value,Decimal)
  2296. Else
  2297. Me.Adapter.UpdateCommand.Parameters(15).Value = Global.System.DBNull.Value
  2298. End If
  2299. If (Plazo.HasValue = true) Then
  2300. Me.Adapter.UpdateCommand.Parameters(16).Value = CType(Plazo.Value,Integer)
  2301. Else
  2302. Me.Adapter.UpdateCommand.Parameters(16).Value = Global.System.DBNull.Value
  2303. End If
  2304. If (PlazoFact Is Nothing) Then
  2305. Me.Adapter.UpdateCommand.Parameters(17).Value = Global.System.DBNull.Value
  2306. Else
  2307. Me.Adapter.UpdateCommand.Parameters(17).Value = CType(PlazoFact,String)
  2308. End If
  2309. If (Ingresos.HasValue = true) Then
  2310. Me.Adapter.UpdateCommand.Parameters(18).Value = CType(Ingresos.Value,Decimal)
  2311. Else
  2312. Me.Adapter.UpdateCommand.Parameters(18).Value = Global.System.DBNull.Value
  2313. End If
  2314. If (FechaDoc.HasValue = true) Then
  2315. Me.Adapter.UpdateCommand.Parameters(19).Value = CType(FechaDoc.Value,Date)
  2316. Else
  2317. Me.Adapter.UpdateCommand.Parameters(19).Value = Global.System.DBNull.Value
  2318. End If
  2319. If (AutEstado Is Nothing) Then
  2320. Me.Adapter.UpdateCommand.Parameters(20).Value = Global.System.DBNull.Value
  2321. Else
  2322. Me.Adapter.UpdateCommand.Parameters(20).Value = CType(AutEstado,String)
  2323. End If
  2324. If (TipoMerc Is Nothing) Then
  2325. Me.Adapter.UpdateCommand.Parameters(21).Value = Global.System.DBNull.Value
  2326. Else
  2327. Me.Adapter.UpdateCommand.Parameters(21).Value = CType(TipoMerc,String)
  2328. End If
  2329. If (CodPais Is Nothing) Then
  2330. Me.Adapter.UpdateCommand.Parameters(22).Value = Global.System.DBNull.Value
  2331. Else
  2332. Me.Adapter.UpdateCommand.Parameters(22).Value = CType(CodPais,String)
  2333. End If
  2334. Me.Adapter.UpdateCommand.Parameters(23).Value = CType(Original_DocId,Integer)
  2335. If (Original_CodInv Is Nothing) Then
  2336. Me.Adapter.UpdateCommand.Parameters(24).Value = CType(1,Object)
  2337. Me.Adapter.UpdateCommand.Parameters(25).Value = Global.System.DBNull.Value
  2338. Else
  2339. Me.Adapter.UpdateCommand.Parameters(24).Value = CType(0,Object)
  2340. Me.Adapter.UpdateCommand.Parameters(25).Value = CType(Original_CodInv,String)
  2341. End If
  2342. If (Original_DocEst Is Nothing) Then
  2343. Me.Adapter.UpdateCommand.Parameters(26).Value = CType(1,Object)
  2344. Me.Adapter.UpdateCommand.Parameters(27).Value = Global.System.DBNull.Value
  2345. Else
  2346. Me.Adapter.UpdateCommand.Parameters(26).Value = CType(0,Object)
  2347. Me.Adapter.UpdateCommand.Parameters(27).Value = CType(Original_DocEst,String)
  2348. End If
  2349. If (Original_Asunto Is Nothing) Then
  2350. Me.Adapter.UpdateCommand.Parameters(28).Value = CType(1,Object)
  2351. Me.Adapter.UpdateCommand.Parameters(29).Value = Global.System.DBNull.Value
  2352. Else
  2353. Me.Adapter.UpdateCommand.Parameters(28).Value = CType(0,Object)
  2354. Me.Adapter.UpdateCommand.Parameters(29).Value = CType(Original_Asunto,String)
  2355. End If
  2356. If (Original_CodEmpr Is Nothing) Then
  2357. Me.Adapter.UpdateCommand.Parameters(30).Value = CType(1,Object)
  2358. Me.Adapter.UpdateCommand.Parameters(31).Value = Global.System.DBNull.Value
  2359. Else
  2360. Me.Adapter.UpdateCommand.Parameters(30).Value = CType(0,Object)
  2361. Me.Adapter.UpdateCommand.Parameters(31).Value = CType(Original_CodEmpr,String)
  2362. End If
  2363. If (Original_CodIF Is Nothing) Then
  2364. Me.Adapter.UpdateCommand.Parameters(32).Value = CType(1,Object)
  2365. Me.Adapter.UpdateCommand.Parameters(33).Value = Global.System.DBNull.Value
  2366. Else
  2367. Me.Adapter.UpdateCommand.Parameters(32).Value = CType(0,Object)
  2368. Me.Adapter.UpdateCommand.Parameters(33).Value = CType(Original_CodIF,String)
  2369. End If
  2370. If (Original_CodEmis.HasValue = true) Then
  2371. Me.Adapter.UpdateCommand.Parameters(34).Value = CType(0,Object)
  2372. Me.Adapter.UpdateCommand.Parameters(35).Value = CType(Original_CodEmis.Value,Integer)
  2373. Else
  2374. Me.Adapter.UpdateCommand.Parameters(34).Value = CType(1,Object)
  2375. Me.Adapter.UpdateCommand.Parameters(35).Value = Global.System.DBNull.Value
  2376. End If
  2377. If (Original_CodCalRi Is Nothing) Then
  2378. Me.Adapter.UpdateCommand.Parameters(36).Value = CType(1,Object)
  2379. Me.Adapter.UpdateCommand.Parameters(37).Value = Global.System.DBNull.Value
  2380. Else
  2381. Me.Adapter.UpdateCommand.Parameters(36).Value = CType(0,Object)
  2382. Me.Adapter.UpdateCommand.Parameters(37).Value = CType(Original_CodCalRi,String)
  2383. End If
  2384. If (Original_CodECalRi Is Nothing) Then
  2385. Me.Adapter.UpdateCommand.Parameters(38).Value = CType(1,Object)
  2386. Me.Adapter.UpdateCommand.Parameters(39).Value = Global.System.DBNull.Value
  2387. Else
  2388. Me.Adapter.UpdateCommand.Parameters(38).Value = CType(0,Object)
  2389. Me.Adapter.UpdateCommand.Parameters(39).Value = CType(Original_CodECalRi,String)
  2390. End If
  2391. If (Original_OFon Is Nothing) Then
  2392. Me.Adapter.UpdateCommand.Parameters(40).Value = CType(1,Object)
  2393. Me.Adapter.UpdateCommand.Parameters(41).Value = Global.System.DBNull.Value
  2394. Else
  2395. Me.Adapter.UpdateCommand.Parameters(40).Value = CType(0,Object)
  2396. Me.Adapter.UpdateCommand.Parameters(41).Value = CType(Original_OFon,String)
  2397. End If
  2398. If (Original_Coment Is Nothing) Then
  2399. Me.Adapter.UpdateCommand.Parameters(42).Value = CType(1,Object)
  2400. Me.Adapter.UpdateCommand.Parameters(43).Value = Global.System.DBNull.Value
  2401. Else
  2402. Me.Adapter.UpdateCommand.Parameters(42).Value = CType(0,Object)
  2403. Me.Adapter.UpdateCommand.Parameters(43).Value = CType(Original_Coment,String)
  2404. End If
  2405. If (Original_Just Is Nothing) Then
  2406. Me.Adapter.UpdateCommand.Parameters(44).Value = CType(1,Object)
  2407. Me.Adapter.UpdateCommand.Parameters(45).Value = Global.System.DBNull.Value
  2408. Else
  2409. Me.Adapter.UpdateCommand.Parameters(44).Value = CType(0,Object)
  2410. Me.Adapter.UpdateCommand.Parameters(45).Value = CType(Original_Just,String)
  2411. End If
  2412. If (Original_TipoOper Is Nothing) Then
  2413. Me.Adapter.UpdateCommand.Parameters(46).Value = CType(1,Object)
  2414. Me.Adapter.UpdateCommand.Parameters(47).Value = Global.System.DBNull.Value
  2415. Else
  2416. Me.Adapter.UpdateCommand.Parameters(46).Value = CType(0,Object)
  2417. Me.Adapter.UpdateCommand.Parameters(47).Value = CType(Original_TipoOper,String)
  2418. End If
  2419. If (Original_DocBase.HasValue = true) Then
  2420. Me.Adapter.UpdateCommand.Parameters(48).Value = CType(0,Object)
  2421. Me.Adapter.UpdateCommand.Parameters(49).Value = CType(Original_DocBase.Value,Integer)
  2422. Else
  2423. Me.Adapter.UpdateCommand.Parameters(48).Value = CType(1,Object)
  2424. Me.Adapter.UpdateCommand.Parameters(49).Value = Global.System.DBNull.Value
  2425. End If
  2426. If (Original_MontoInv.HasValue = true) Then
  2427. Me.Adapter.UpdateCommand.Parameters(50).Value = CType(0,Object)
  2428. Me.Adapter.UpdateCommand.Parameters(51).Value = CType(Original_MontoInv.Value,Decimal)
  2429. Else
  2430. Me.Adapter.UpdateCommand.Parameters(50).Value = CType(1,Object)
  2431. Me.Adapter.UpdateCommand.Parameters(51).Value = Global.System.DBNull.Value
  2432. End If
  2433. If (Original_Precio.HasValue = true) Then
  2434. Me.Adapter.UpdateCommand.Parameters(52).Value = CType(0,Object)
  2435. Me.Adapter.UpdateCommand.Parameters(53).Value = CType(Original_Precio.Value,Decimal)
  2436. Else
  2437. Me.Adapter.UpdateCommand.Parameters(52).Value = CType(1,Object)
  2438. Me.Adapter.UpdateCommand.Parameters(53).Value = Global.System.DBNull.Value
  2439. End If
  2440. If (Original_Rendimiento.HasValue = true) Then
  2441. Me.Adapter.UpdateCommand.Parameters(54).Value = CType(0,Object)
  2442. Me.Adapter.UpdateCommand.Parameters(55).Value = CType(Original_Rendimiento.Value,Decimal)
  2443. Else
  2444. Me.Adapter.UpdateCommand.Parameters(54).Value = CType(1,Object)
  2445. Me.Adapter.UpdateCommand.Parameters(55).Value = Global.System.DBNull.Value
  2446. End If
  2447. If (Original_Plazo.HasValue = true) Then
  2448. Me.Adapter.UpdateCommand.Parameters(56).Value = CType(0,Object)
  2449. Me.Adapter.UpdateCommand.Parameters(57).Value = CType(Original_Plazo.Value,Integer)
  2450. Else
  2451. Me.Adapter.UpdateCommand.Parameters(56).Value = CType(1,Object)
  2452. Me.Adapter.UpdateCommand.Parameters(57).Value = Global.System.DBNull.Value
  2453. End If
  2454. If (Original_PlazoFact Is Nothing) Then
  2455. Me.Adapter.UpdateCommand.Parameters(58).Value = CType(1,Object)
  2456. Me.Adapter.UpdateCommand.Parameters(59).Value = Global.System.DBNull.Value
  2457. Else
  2458. Me.Adapter.UpdateCommand.Parameters(58).Value = CType(0,Object)
  2459. Me.Adapter.UpdateCommand.Parameters(59).Value = CType(Original_PlazoFact,String)
  2460. End If
  2461. If (Original_Ingresos.HasValue = true) Then
  2462. Me.Adapter.UpdateCommand.Parameters(60).Value = CType(0,Object)
  2463. Me.Adapter.UpdateCommand.Parameters(61).Value = CType(Original_Ingresos.Value,Decimal)
  2464. Else
  2465. Me.Adapter.UpdateCommand.Parameters(60).Value = CType(1,Object)
  2466. Me.Adapter.UpdateCommand.Parameters(61).Value = Global.System.DBNull.Value
  2467. End If
  2468. If (Original_FechaDoc.HasValue = true) Then
  2469. Me.Adapter.UpdateCommand.Parameters(62).Value = CType(0,Object)
  2470. Me.Adapter.UpdateCommand.Parameters(63).Value = CType(Original_FechaDoc.Value,Date)
  2471. Else
  2472. Me.Adapter.UpdateCommand.Parameters(62).Value = CType(1,Object)
  2473. Me.Adapter.UpdateCommand.Parameters(63).Value = Global.System.DBNull.Value
  2474. End If
  2475. If (Original_AutEstado Is Nothing) Then
  2476. Me.Adapter.UpdateCommand.Parameters(64).Value = CType(1,Object)
  2477. Me.Adapter.UpdateCommand.Parameters(65).Value = Global.System.DBNull.Value
  2478. Else
  2479. Me.Adapter.UpdateCommand.Parameters(64).Value = CType(0,Object)
  2480. Me.Adapter.UpdateCommand.Parameters(65).Value = CType(Original_AutEstado,String)
  2481. End If
  2482. If (Original_TipoMerc Is Nothing) Then
  2483. Me.Adapter.UpdateCommand.Parameters(66).Value = CType(1,Object)
  2484. Me.Adapter.UpdateCommand.Parameters(67).Value = Global.System.DBNull.Value
  2485. Else
  2486. Me.Adapter.UpdateCommand.Parameters(66).Value = CType(0,Object)
  2487. Me.Adapter.UpdateCommand.Parameters(67).Value = CType(Original_TipoMerc,String)
  2488. End If
  2489. If (Original_CodPais Is Nothing) Then
  2490. Me.Adapter.UpdateCommand.Parameters(68).Value = CType(1,Object)
  2491. Me.Adapter.UpdateCommand.Parameters(69).Value = Global.System.DBNull.Value
  2492. Else
  2493. Me.Adapter.UpdateCommand.Parameters(68).Value = CType(0,Object)
  2494. Me.Adapter.UpdateCommand.Parameters(69).Value = CType(Original_CodPais,String)
  2495. End If
  2496. Me.Adapter.UpdateCommand.Parameters(70).Value = CType(DocId,Integer)
  2497. Dim previousConnectionState As Global.System.Data.ConnectionState = Me.Adapter.UpdateCommand.Connection.State
  2498. If ((Me.Adapter.UpdateCommand.Connection.State And Global.System.Data.ConnectionState.Open) _
  2499. <> Global.System.Data.ConnectionState.Open) Then
  2500. Me.Adapter.UpdateCommand.Connection.Open
  2501. End If
  2502. Try
  2503. Dim returnValue As Integer = Me.Adapter.UpdateCommand.ExecuteNonQuery
  2504. Return returnValue
  2505. Finally
  2506. If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Then
  2507. Me.Adapter.UpdateCommand.Connection.Close
  2508. End If
  2509. End Try
  2510. End Function
  2511. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2512. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2513. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), _
  2514. Global.System.ComponentModel.DataObjectMethodAttribute(Global.System.ComponentModel.DataObjectMethodType.Update, true)> _
  2515. Public Overloads Overridable Function Update( _
  2516. ByVal CodInv As String, _
  2517. ByVal DocEst As String, _
  2518. ByVal Asunto As String, _
  2519. ByVal CodEmpr As String, _
  2520. ByVal CodIF As String, _
  2521. ByVal CodEmis As Global.System.Nullable(Of Integer), _
  2522. ByVal CodCalRi As String, _
  2523. ByVal CodECalRi As String, _
  2524. ByVal OFon As String, _
  2525. ByVal Coment As String, _
  2526. ByVal Just As String, _
  2527. ByVal TipoOper As String, _
  2528. ByVal DocBase As Global.System.Nullable(Of Integer), _
  2529. ByVal MontoInv As Global.System.Nullable(Of Decimal), _
  2530. ByVal Precio As Global.System.Nullable(Of Decimal), _
  2531. ByVal Rendimiento As Global.System.Nullable(Of Decimal), _
  2532. ByVal Plazo As Global.System.Nullable(Of Integer), _
  2533. ByVal PlazoFact As String, _
  2534. ByVal Ingresos As Global.System.Nullable(Of Decimal), _
  2535. ByVal FechaDoc As Global.System.Nullable(Of Date), _
  2536. ByVal AutEstado As String, _
  2537. ByVal TipoMerc As String, _
  2538. ByVal CodPais As String, _
  2539. ByVal Original_DocId As Integer, _
  2540. ByVal Original_CodInv As String, _
  2541. ByVal Original_DocEst As String, _
  2542. ByVal Original_Asunto As String, _
  2543. ByVal Original_CodEmpr As String, _
  2544. ByVal Original_CodIF As String, _
  2545. ByVal Original_CodEmis As Global.System.Nullable(Of Integer), _
  2546. ByVal Original_CodCalRi As String, _
  2547. ByVal Original_CodECalRi As String, _
  2548. ByVal Original_OFon As String, _
  2549. ByVal Original_Coment As String, _
  2550. ByVal Original_Just As String, _
  2551. ByVal Original_TipoOper As String, _
  2552. ByVal Original_DocBase As Global.System.Nullable(Of Integer), _
  2553. ByVal Original_MontoInv As Global.System.Nullable(Of Decimal), _
  2554. ByVal Original_Precio As Global.System.Nullable(Of Decimal), _
  2555. ByVal Original_Rendimiento As Global.System.Nullable(Of Decimal), _
  2556. ByVal Original_Plazo As Global.System.Nullable(Of Integer), _
  2557. ByVal Original_PlazoFact As String, _
  2558. ByVal Original_Ingresos As Global.System.Nullable(Of Decimal), _
  2559. ByVal Original_FechaDoc As Global.System.Nullable(Of Date), _
  2560. ByVal Original_AutEstado As String, _
  2561. ByVal Original_TipoMerc As String, _
  2562. ByVal Original_CodPais As String) As Integer
  2563. Return Me.Update(CodInv, DocEst, Asunto, CodEmpr, CodIF, CodEmis, CodCalRi, CodECalRi, OFon, Coment, Just, TipoOper, DocBase, MontoInv, Precio, Rendimiento, Plazo, PlazoFact, Ingresos, FechaDoc, AutEstado, TipoMerc, CodPais, Original_DocId, Original_CodInv, Original_DocEst, Original_Asunto, Original_CodEmpr, Original_CodIF, Original_CodEmis, Original_CodCalRi, Original_CodECalRi, Original_OFon, Original_Coment, Original_Just, Original_TipoOper, Original_DocBase, Original_MontoInv, Original_Precio, Original_Rendimiento, Original_Plazo, Original_PlazoFact, Original_Ingresos, Original_FechaDoc, Original_AutEstado, Original_TipoMerc, Original_CodPais, Original_DocId)
  2564. End Function
  2565. End Class
  2566. '''<summary>
  2567. '''TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
  2568. '''</summary>
  2569. <Global.System.ComponentModel.DesignerCategoryAttribute("code"), _
  2570. Global.System.ComponentModel.ToolboxItem(true), _
  2571. Global.System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD"& _
  2572. "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"), _
  2573. Global.System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")> _
  2574. Partial Public Class TableAdapterManager
  2575. Inherits Global.System.ComponentModel.Component
  2576. Private _updateOrder As UpdateOrderOption
  2577. Private _pIN0TableAdapter As PIN0TableAdapter
  2578. Private _backupDataSetBeforeUpdate As Boolean
  2579. Private _connection As Global.System.Data.IDbConnection
  2580. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2581. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2582. Public Property UpdateOrder() As UpdateOrderOption
  2583. Get
  2584. Return Me._updateOrder
  2585. End Get
  2586. Set
  2587. Me._updateOrder = value
  2588. End Set
  2589. End Property
  2590. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2591. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2592. Global.System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso"& _
  2593. "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3"& _
  2594. "a", "System.Drawing.Design.UITypeEditor")> _
  2595. Public Property PIN0TableAdapter() As PIN0TableAdapter
  2596. Get
  2597. Return Me._pIN0TableAdapter
  2598. End Get
  2599. Set
  2600. Me._pIN0TableAdapter = value
  2601. End Set
  2602. End Property
  2603. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2604. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2605. Public Property BackupDataSetBeforeUpdate() As Boolean
  2606. Get
  2607. Return Me._backupDataSetBeforeUpdate
  2608. End Get
  2609. Set
  2610. Me._backupDataSetBeforeUpdate = value
  2611. End Set
  2612. End Property
  2613. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2614. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2615. Global.System.ComponentModel.Browsable(false)> _
  2616. Public Property Connection() As Global.System.Data.IDbConnection
  2617. Get
  2618. If (Not (Me._connection) Is Nothing) Then
  2619. Return Me._connection
  2620. End If
  2621. If ((Not (Me._pIN0TableAdapter) Is Nothing) _
  2622. AndAlso (Not (Me._pIN0TableAdapter.Connection) Is Nothing)) Then
  2623. Return Me._pIN0TableAdapter.Connection
  2624. End If
  2625. Return Nothing
  2626. End Get
  2627. Set
  2628. Me._connection = value
  2629. End Set
  2630. End Property
  2631. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2632. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0"), _
  2633. Global.System.ComponentModel.Browsable(false)> _
  2634. Public ReadOnly Property TableAdapterInstanceCount() As Integer
  2635. Get
  2636. Dim count As Integer = 0
  2637. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2638. count = (count + 1)
  2639. End If
  2640. Return count
  2641. End Get
  2642. End Property
  2643. '''<summary>
  2644. '''Update rows in top-down order.
  2645. '''</summary>
  2646. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2647. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2648. Private Function UpdateUpdatedRows(ByVal dataSet As InversionesDataSet, 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
  2649. Dim result As Integer = 0
  2650. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2651. Dim updatedRows() As Global.System.Data.DataRow = dataSet.PIN0.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.ModifiedCurrent)
  2652. updatedRows = Me.GetRealUpdatedRows(updatedRows, allAddedRows)
  2653. If ((Not (updatedRows) Is Nothing) _
  2654. AndAlso (0 < updatedRows.Length)) Then
  2655. result = (result + Me._pIN0TableAdapter.Update(updatedRows))
  2656. allChangedRows.AddRange(updatedRows)
  2657. End If
  2658. End If
  2659. Return result
  2660. End Function
  2661. '''<summary>
  2662. '''Insert rows in top-down order.
  2663. '''</summary>
  2664. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2665. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2666. Private Function UpdateInsertedRows(ByVal dataSet As InversionesDataSet, ByVal allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Integer
  2667. Dim result As Integer = 0
  2668. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2669. Dim addedRows() As Global.System.Data.DataRow = dataSet.PIN0.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.Added)
  2670. If ((Not (addedRows) Is Nothing) _
  2671. AndAlso (0 < addedRows.Length)) Then
  2672. result = (result + Me._pIN0TableAdapter.Update(addedRows))
  2673. allAddedRows.AddRange(addedRows)
  2674. End If
  2675. End If
  2676. Return result
  2677. End Function
  2678. '''<summary>
  2679. '''Delete rows in bottom-up order.
  2680. '''</summary>
  2681. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2682. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2683. Private Function UpdateDeletedRows(ByVal dataSet As InversionesDataSet, ByVal allChangedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)) As Integer
  2684. Dim result As Integer = 0
  2685. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2686. Dim deletedRows() As Global.System.Data.DataRow = dataSet.PIN0.Select(Nothing, Nothing, Global.System.Data.DataViewRowState.Deleted)
  2687. If ((Not (deletedRows) Is Nothing) _
  2688. AndAlso (0 < deletedRows.Length)) Then
  2689. result = (result + Me._pIN0TableAdapter.Update(deletedRows))
  2690. allChangedRows.AddRange(deletedRows)
  2691. End If
  2692. End If
  2693. Return result
  2694. End Function
  2695. '''<summary>
  2696. '''Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
  2697. '''</summary>
  2698. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2699. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2700. 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()
  2701. If ((updatedRows Is Nothing) _
  2702. OrElse (updatedRows.Length < 1)) Then
  2703. Return updatedRows
  2704. End If
  2705. If ((allAddedRows Is Nothing) _
  2706. OrElse (allAddedRows.Count < 1)) Then
  2707. Return updatedRows
  2708. End If
  2709. Dim realUpdatedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  2710. Dim i As Integer = 0
  2711. Do While (i < updatedRows.Length)
  2712. Dim row As Global.System.Data.DataRow = updatedRows(i)
  2713. If (allAddedRows.Contains(row) = false) Then
  2714. realUpdatedRows.Add(row)
  2715. End If
  2716. i = (i + 1)
  2717. Loop
  2718. Return realUpdatedRows.ToArray
  2719. End Function
  2720. '''<summary>
  2721. '''Update all changes to the dataset.
  2722. '''</summary>
  2723. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2724. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2725. Public Overridable Function UpdateAll(ByVal dataSet As InversionesDataSet) As Integer
  2726. If (dataSet Is Nothing) Then
  2727. Throw New Global.System.ArgumentNullException("dataSet")
  2728. End If
  2729. If (dataSet.HasChanges = false) Then
  2730. Return 0
  2731. End If
  2732. If ((Not (Me._pIN0TableAdapter) Is Nothing) _
  2733. AndAlso (Me.MatchTableAdapterConnection(Me._pIN0TableAdapter.Connection) = false)) Then
  2734. Throw New Global.System.ArgumentException("Todos los TableAdapters administrados por un TableAdapterManager deben usar la mi"& _
  2735. "sma cadena de conexión.")
  2736. End If
  2737. Dim workConnection As Global.System.Data.IDbConnection = Me.Connection
  2738. If (workConnection Is Nothing) Then
  2739. Throw New Global.System.ApplicationException("TableAdapterManager no contiene información de conexión. Establezca cada propieda"& _
  2740. "d TableAdapterManager TableAdapter en una instancia TableAdapter válida.")
  2741. End If
  2742. Dim workConnOpened As Boolean = false
  2743. If ((workConnection.State And Global.System.Data.ConnectionState.Broken) _
  2744. = Global.System.Data.ConnectionState.Broken) Then
  2745. workConnection.Close
  2746. End If
  2747. If (workConnection.State = Global.System.Data.ConnectionState.Closed) Then
  2748. workConnection.Open
  2749. workConnOpened = true
  2750. End If
  2751. Dim workTransaction As Global.System.Data.IDbTransaction = workConnection.BeginTransaction
  2752. If (workTransaction Is Nothing) Then
  2753. Throw New Global.System.ApplicationException("La transacción no puede comenzar. La conexión de datos actual no es compatible co"& _
  2754. "n las transacciones o el estado actual no permite que comience la transacción.")
  2755. End If
  2756. Dim allChangedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  2757. Dim allAddedRows As Global.System.Collections.Generic.List(Of Global.System.Data.DataRow) = New Global.System.Collections.Generic.List(Of Global.System.Data.DataRow)()
  2758. 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)()
  2759. 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)()
  2760. Dim result As Integer = 0
  2761. Dim backupDataSet As Global.System.Data.DataSet = Nothing
  2762. If Me.BackupDataSetBeforeUpdate Then
  2763. backupDataSet = New Global.System.Data.DataSet()
  2764. backupDataSet.Merge(dataSet)
  2765. End If
  2766. Try
  2767. '---- Prepare for update -----------
  2768. '
  2769. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2770. revertConnections.Add(Me._pIN0TableAdapter, Me._pIN0TableAdapter.Connection)
  2771. Me._pIN0TableAdapter.Connection = CType(workConnection,Global.System.Data.SqlClient.SqlConnection)
  2772. Me._pIN0TableAdapter.Transaction = CType(workTransaction,Global.System.Data.SqlClient.SqlTransaction)
  2773. If Me._pIN0TableAdapter.Adapter.AcceptChangesDuringUpdate Then
  2774. Me._pIN0TableAdapter.Adapter.AcceptChangesDuringUpdate = false
  2775. adaptersWithAcceptChangesDuringUpdate.Add(Me._pIN0TableAdapter.Adapter)
  2776. End If
  2777. End If
  2778. '
  2779. '---- Perform updates -----------
  2780. '
  2781. If (Me.UpdateOrder = UpdateOrderOption.UpdateInsertDelete) Then
  2782. result = (result + Me.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows))
  2783. result = (result + Me.UpdateInsertedRows(dataSet, allAddedRows))
  2784. Else
  2785. result = (result + Me.UpdateInsertedRows(dataSet, allAddedRows))
  2786. result = (result + Me.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows))
  2787. End If
  2788. result = (result + Me.UpdateDeletedRows(dataSet, allChangedRows))
  2789. '
  2790. '---- Commit updates -----------
  2791. '
  2792. workTransaction.Commit
  2793. If (0 < allAddedRows.Count) Then
  2794. Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
  2795. allAddedRows.CopyTo(rows)
  2796. Dim i As Integer = 0
  2797. Do While (i < rows.Length)
  2798. Dim row As Global.System.Data.DataRow = rows(i)
  2799. row.AcceptChanges
  2800. i = (i + 1)
  2801. Loop
  2802. End If
  2803. If (0 < allChangedRows.Count) Then
  2804. Dim rows((allChangedRows.Count) - 1) As Global.System.Data.DataRow
  2805. allChangedRows.CopyTo(rows)
  2806. Dim i As Integer = 0
  2807. Do While (i < rows.Length)
  2808. Dim row As Global.System.Data.DataRow = rows(i)
  2809. row.AcceptChanges
  2810. i = (i + 1)
  2811. Loop
  2812. End If
  2813. Catch ex As Global.System.Exception
  2814. workTransaction.Rollback
  2815. '---- Restore the dataset -----------
  2816. If Me.BackupDataSetBeforeUpdate Then
  2817. Global.System.Diagnostics.Debug.Assert((Not (backupDataSet) Is Nothing))
  2818. dataSet.Clear
  2819. dataSet.Merge(backupDataSet)
  2820. Else
  2821. If (0 < allAddedRows.Count) Then
  2822. Dim rows((allAddedRows.Count) - 1) As Global.System.Data.DataRow
  2823. allAddedRows.CopyTo(rows)
  2824. Dim i As Integer = 0
  2825. Do While (i < rows.Length)
  2826. Dim row As Global.System.Data.DataRow = rows(i)
  2827. row.AcceptChanges
  2828. row.SetAdded
  2829. i = (i + 1)
  2830. Loop
  2831. End If
  2832. End If
  2833. Throw ex
  2834. Finally
  2835. If workConnOpened Then
  2836. workConnection.Close
  2837. End If
  2838. If (Not (Me._pIN0TableAdapter) Is Nothing) Then
  2839. Me._pIN0TableAdapter.Connection = CType(revertConnections(Me._pIN0TableAdapter),Global.System.Data.SqlClient.SqlConnection)
  2840. Me._pIN0TableAdapter.Transaction = Nothing
  2841. End If
  2842. If (0 < adaptersWithAcceptChangesDuringUpdate.Count) Then
  2843. Dim adapters((adaptersWithAcceptChangesDuringUpdate.Count) - 1) As Global.System.Data.Common.DataAdapter
  2844. adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters)
  2845. Dim i As Integer = 0
  2846. Do While (i < adapters.Length)
  2847. Dim adapter As Global.System.Data.Common.DataAdapter = adapters(i)
  2848. adapter.AcceptChangesDuringUpdate = true
  2849. i = (i + 1)
  2850. Loop
  2851. End If
  2852. End Try
  2853. Return result
  2854. End Function
  2855. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2856. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2857. Protected Overridable Sub SortSelfReferenceRows(ByVal rows() As Global.System.Data.DataRow, ByVal relation As Global.System.Data.DataRelation, ByVal childFirst As Boolean)
  2858. Global.System.Array.Sort(Of Global.System.Data.DataRow)(rows, New SelfReferenceComparer(relation, childFirst))
  2859. End Sub
  2860. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2861. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2862. Protected Overridable Function MatchTableAdapterConnection(ByVal inputConnection As Global.System.Data.IDbConnection) As Boolean
  2863. If (Not (Me._connection) Is Nothing) Then
  2864. Return true
  2865. End If
  2866. If ((Me.Connection Is Nothing) _
  2867. OrElse (inputConnection Is Nothing)) Then
  2868. Return true
  2869. End If
  2870. If String.Equals(Me.Connection.ConnectionString, inputConnection.ConnectionString, Global.System.StringComparison.Ordinal) Then
  2871. Return true
  2872. End If
  2873. Return false
  2874. End Function
  2875. '''<summary>
  2876. '''Update Order Option
  2877. '''</summary>
  2878. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2879. Public Enum UpdateOrderOption
  2880. InsertUpdateDelete = 0
  2881. UpdateInsertDelete = 1
  2882. End Enum
  2883. '''<summary>
  2884. '''Used to sort self-referenced table's rows
  2885. '''</summary>
  2886. <Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2887. Private Class SelfReferenceComparer
  2888. Inherits Object
  2889. Implements Global.System.Collections.Generic.IComparer(Of Global.System.Data.DataRow)
  2890. Private _relation As Global.System.Data.DataRelation
  2891. Private _childFirst As Integer
  2892. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2893. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2894. Friend Sub New(ByVal relation As Global.System.Data.DataRelation, ByVal childFirst As Boolean)
  2895. MyBase.New
  2896. Me._relation = relation
  2897. If childFirst Then
  2898. Me._childFirst = -1
  2899. Else
  2900. Me._childFirst = 1
  2901. End If
  2902. End Sub
  2903. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2904. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2905. Private Function GetRoot(ByVal row As Global.System.Data.DataRow, ByRef distance As Integer) As Global.System.Data.DataRow
  2906. Global.System.Diagnostics.Debug.Assert((Not (row) Is Nothing))
  2907. Dim root As Global.System.Data.DataRow = row
  2908. distance = 0
  2909. 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)()
  2910. traversedRows(row) = row
  2911. Dim parent As Global.System.Data.DataRow = row.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.[Default])
  2912. Do While ((Not (parent) Is Nothing) _
  2913. AndAlso (traversedRows.ContainsKey(parent) = false))
  2914. distance = (distance + 1)
  2915. root = parent
  2916. traversedRows(parent) = parent
  2917. parent = parent.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.[Default])
  2918. Loop
  2919. If (distance = 0) Then
  2920. traversedRows.Clear
  2921. traversedRows(row) = row
  2922. parent = row.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.Original)
  2923. Do While ((Not (parent) Is Nothing) _
  2924. AndAlso (traversedRows.ContainsKey(parent) = false))
  2925. distance = (distance + 1)
  2926. root = parent
  2927. traversedRows(parent) = parent
  2928. parent = parent.GetParentRow(Me._relation, Global.System.Data.DataRowVersion.Original)
  2929. Loop
  2930. End If
  2931. Return root
  2932. End Function
  2933. <Global.System.Diagnostics.DebuggerNonUserCodeAttribute(), _
  2934. Global.System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "15.0.0.0")> _
  2935. 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
  2936. If Object.ReferenceEquals(row1, row2) Then
  2937. Return 0
  2938. End If
  2939. If (row1 Is Nothing) Then
  2940. Return -1
  2941. End If
  2942. If (row2 Is Nothing) Then
  2943. Return 1
  2944. End If
  2945. Dim distance1 As Integer = 0
  2946. Dim root1 As Global.System.Data.DataRow = Me.GetRoot(row1, distance1)
  2947. Dim distance2 As Integer = 0
  2948. Dim root2 As Global.System.Data.DataRow = Me.GetRoot(row2, distance2)
  2949. If Object.ReferenceEquals(root1, root2) Then
  2950. Return (Me._childFirst * distance1.CompareTo(distance2))
  2951. Else
  2952. Global.System.Diagnostics.Debug.Assert(((Not (root1.Table) Is Nothing) _
  2953. AndAlso (Not (root2.Table) Is Nothing)))
  2954. If (root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2)) Then
  2955. Return -1
  2956. Else
  2957. Return 1
  2958. End If
  2959. End If
  2960. End Function
  2961. End Class
  2962. End Class
  2963. End Namespace