465 lines
20 KiB
VB.net
465 lines
20 KiB
VB.net
Public Class EstadoCat
|
||
Inherits System.Windows.Forms.Form
|
||
|
||
#Region " Windows Form Designer generated code "
|
||
|
||
Public Sub New()
|
||
MyBase.New()
|
||
|
||
'This call is required by the Windows Form Designer.
|
||
InitializeComponent()
|
||
|
||
'Add any initialization after the InitializeComponent() call
|
||
|
||
End Sub
|
||
|
||
'Form overrides dispose to clean up the component list.
|
||
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
|
||
If disposing Then
|
||
If Not (components Is Nothing) Then
|
||
components.Dispose()
|
||
End If
|
||
End If
|
||
MyBase.Dispose(disposing)
|
||
End Sub
|
||
|
||
'Required by the Windows Form Designer
|
||
Private components As System.ComponentModel.IContainer
|
||
|
||
'NOTE: The following procedure is required by the Windows Form Designer
|
||
'It can be modified using the Windows Form Designer.
|
||
'Do not modify it using the code editor.
|
||
Friend WithEvents btnAgrergar As System.Windows.Forms.ToolBarButton
|
||
Friend WithEvents btnActualizar As System.Windows.Forms.ToolBarButton
|
||
Friend WithEvents btnSalir As System.Windows.Forms.ToolBarButton
|
||
Friend WithEvents ImageList1 As System.Windows.Forms.ImageList
|
||
Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
|
||
Friend WithEvents C1TrueDBGrid1 As C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
||
Friend WithEvents pnlBotones As System.Windows.Forms.Panel
|
||
Friend WithEvents btnAceptar As System.Windows.Forms.Button
|
||
Friend WithEvents btnCancelar As System.Windows.Forms.Button
|
||
Friend WithEvents chkActivo As System.Windows.Forms.CheckBox
|
||
Friend WithEvents cmbPais As System.Windows.Forms.ComboBox
|
||
Friend WithEvents txtNombre As System.Windows.Forms.TextBox
|
||
Friend WithEvents txtClave As System.Windows.Forms.TextBox
|
||
Friend WithEvents Label4 As System.Windows.Forms.Label
|
||
Friend WithEvents Label1 As System.Windows.Forms.Label
|
||
Friend WithEvents Label2 As System.Windows.Forms.Label
|
||
Friend WithEvents Button1 As System.Windows.Forms.Button
|
||
Friend WithEvents ToolBar As System.Windows.Forms.ToolBar
|
||
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
||
Me.components = New System.ComponentModel.Container
|
||
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(EstadoCat))
|
||
Me.ToolBar = New System.Windows.Forms.ToolBar
|
||
Me.btnAgrergar = New System.Windows.Forms.ToolBarButton
|
||
Me.btnActualizar = New System.Windows.Forms.ToolBarButton
|
||
Me.btnSalir = New System.Windows.Forms.ToolBarButton
|
||
Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
|
||
Me.GroupBox1 = New System.Windows.Forms.GroupBox
|
||
Me.C1TrueDBGrid1 = New C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
||
Me.pnlBotones = New System.Windows.Forms.Panel
|
||
Me.btnAceptar = New System.Windows.Forms.Button
|
||
Me.btnCancelar = New System.Windows.Forms.Button
|
||
Me.chkActivo = New System.Windows.Forms.CheckBox
|
||
Me.cmbPais = New System.Windows.Forms.ComboBox
|
||
Me.txtNombre = New System.Windows.Forms.TextBox
|
||
Me.txtClave = New System.Windows.Forms.TextBox
|
||
Me.Label4 = New System.Windows.Forms.Label
|
||
Me.Label1 = New System.Windows.Forms.Label
|
||
Me.Label2 = New System.Windows.Forms.Label
|
||
Me.Button1 = New System.Windows.Forms.Button
|
||
Me.GroupBox1.SuspendLayout()
|
||
CType(Me.C1TrueDBGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
|
||
Me.pnlBotones.SuspendLayout()
|
||
Me.SuspendLayout()
|
||
'
|
||
'ToolBar
|
||
'
|
||
Me.ToolBar.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle
|
||
Me.ToolBar.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.btnAgrergar, Me.btnActualizar, Me.btnSalir})
|
||
Me.ToolBar.ButtonSize = New System.Drawing.Size(75, 40)
|
||
Me.ToolBar.DropDownArrows = True
|
||
Me.ToolBar.ImageList = Me.ImageList1
|
||
Me.ToolBar.Location = New System.Drawing.Point(0, 0)
|
||
Me.ToolBar.Name = "ToolBar"
|
||
Me.ToolBar.ShowToolTips = True
|
||
Me.ToolBar.Size = New System.Drawing.Size(526, 47)
|
||
Me.ToolBar.TabIndex = 50
|
||
'
|
||
'btnAgrergar
|
||
'
|
||
Me.btnAgrergar.ImageIndex = 6
|
||
Me.btnAgrergar.Text = "Agregar"
|
||
'
|
||
'btnActualizar
|
||
'
|
||
Me.btnActualizar.ImageIndex = 5
|
||
Me.btnActualizar.Text = "Actualizar"
|
||
'
|
||
'btnSalir
|
||
'
|
||
Me.btnSalir.ImageIndex = 4
|
||
Me.btnSalir.Text = "Salir"
|
||
'
|
||
'ImageList1
|
||
'
|
||
Me.ImageList1.ImageSize = New System.Drawing.Size(16, 16)
|
||
Me.ImageList1.ImageStream = CType(resources.GetObject("ImageList1.ImageStream"), System.Windows.Forms.ImageListStreamer)
|
||
Me.ImageList1.TransparentColor = System.Drawing.Color.Turquoise
|
||
'
|
||
'GroupBox1
|
||
'
|
||
Me.GroupBox1.Controls.Add(Me.C1TrueDBGrid1)
|
||
Me.GroupBox1.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.GroupBox1.Location = New System.Drawing.Point(6, 144)
|
||
Me.GroupBox1.Name = "GroupBox1"
|
||
Me.GroupBox1.Size = New System.Drawing.Size(516, 168)
|
||
Me.GroupBox1.TabIndex = 89
|
||
Me.GroupBox1.TabStop = False
|
||
'
|
||
'C1TrueDBGrid1
|
||
'
|
||
Me.C1TrueDBGrid1.AllowUpdate = False
|
||
Me.C1TrueDBGrid1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D
|
||
Me.C1TrueDBGrid1.Dock = System.Windows.Forms.DockStyle.Fill
|
||
Me.C1TrueDBGrid1.GroupByCaption = "Drag a column header here to group by that column"
|
||
Me.C1TrueDBGrid1.Images.Add(CType(resources.GetObject("resource"), System.Drawing.Image))
|
||
Me.C1TrueDBGrid1.Location = New System.Drawing.Point(3, 16)
|
||
Me.C1TrueDBGrid1.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.HighlightRow
|
||
Me.C1TrueDBGrid1.Name = "C1TrueDBGrid1"
|
||
Me.C1TrueDBGrid1.PreviewInfo.Location = New System.Drawing.Point(0, 0)
|
||
Me.C1TrueDBGrid1.PreviewInfo.Size = New System.Drawing.Size(0, 0)
|
||
Me.C1TrueDBGrid1.PreviewInfo.ZoomFactor = 75
|
||
Me.C1TrueDBGrid1.Size = New System.Drawing.Size(510, 149)
|
||
Me.C1TrueDBGrid1.TabIndex = 0
|
||
Me.C1TrueDBGrid1.Text = "C1TrueDBGrid1"
|
||
Me.C1TrueDBGrid1.PropBag = "<?xml version=""1.0""?><Blob><Styles type=""C1.Win.C1TrueDBGrid.Design.ContextWrappe" & _
|
||
"r""><Data>Group{BackColor:ControlDark;Border:None,,0, 0, 0, 0;AlignVert:Center;}E" & _
|
||
"ditor{}Style2{}Style5{}Style4{}Style7{}Style6{}EvenRow{BackColor:Aqua;}Selected{" & _
|
||
"ForeColor:HighlightText;BackColor:Highlight;}Style3{}Inactive{ForeColor:Inactive" & _
|
||
"CaptionText;BackColor:InactiveCaption;}FilterBar{}Footer{}Caption{AlignHorz:Cent" & _
|
||
"er;}Style9{}Normal{Font:Microsoft Sans Serif, 8.25pt, style=Bold;}HighlightRow{F" & _
|
||
"oreColor:Aqua;BackColor:Highlight;}Style14{}OddRow{}RecordSelector{AlignImage:Ce" & _
|
||
"nter;}Style15{}Heading{Wrap:True;AlignVert:Center;Border:Raised,,1, 1, 1, 1;Fore" & _
|
||
"Color:ControlText;BackColor:Control;}Style8{}Style10{AlignHorz:Near;}Style11{}St" & _
|
||
"yle12{}Style13{}Style1{}</Data></Styles><Splits><C1.Win.C1TrueDBGrid.MergeView N" & _
|
||
"ame="""" CaptionHeight=""17"" ColumnCaptionHeight=""17"" ColumnFooterHeight=""17"" Marqu" & _
|
||
"eeStyle=""HighlightRow"" RecordSelectorWidth=""16"" DefRecSelWidth=""16"" VerticalScro" & _
|
||
"llGroup=""1"" HorizontalScrollGroup=""1""><Height>145</Height><CaptionStyle parent=""" & _
|
||
"Style2"" me=""Style10"" /><EditorStyle parent=""Editor"" me=""Style5"" /><EvenRowStyle " & _
|
||
"parent=""EvenRow"" me=""Style8"" /><FilterBarStyle parent=""FilterBar"" me=""Style13"" /" & _
|
||
"><FooterStyle parent=""Footer"" me=""Style3"" /><GroupStyle parent=""Group"" me=""Style" & _
|
||
"12"" /><HeadingStyle parent=""Heading"" me=""Style2"" /><HighLightRowStyle parent=""Hi" & _
|
||
"ghlightRow"" me=""Style7"" /><InactiveStyle parent=""Inactive"" me=""Style4"" /><OddRow" & _
|
||
"Style parent=""OddRow"" me=""Style9"" /><RecordSelectorStyle parent=""RecordSelector""" & _
|
||
" me=""Style11"" /><SelectedStyle parent=""Selected"" me=""Style6"" /><Style parent=""No" & _
|
||
"rmal"" me=""Style1"" /><ClientRect>0, 0, 506, 145</ClientRect><BorderSide>0</Border" & _
|
||
"Side><BorderStyle>Sunken</BorderStyle></C1.Win.C1TrueDBGrid.MergeView></Splits><" & _
|
||
"NamedStyles><Style parent="""" me=""Normal"" /><Style parent=""Normal"" me=""Heading"" /" & _
|
||
"><Style parent=""Heading"" me=""Footer"" /><Style parent=""Heading"" me=""Caption"" /><S" & _
|
||
"tyle parent=""Heading"" me=""Inactive"" /><Style parent=""Normal"" me=""Selected"" /><St" & _
|
||
"yle parent=""Normal"" me=""Editor"" /><Style parent=""Normal"" me=""HighlightRow"" /><St" & _
|
||
"yle parent=""Normal"" me=""EvenRow"" /><Style parent=""Normal"" me=""OddRow"" /><Style p" & _
|
||
"arent=""Heading"" me=""RecordSelector"" /><Style parent=""Normal"" me=""FilterBar"" /><S" & _
|
||
"tyle parent=""Caption"" me=""Group"" /></NamedStyles><vertSplits>1</vertSplits><horz" & _
|
||
"Splits>1</horzSplits><Layout>None</Layout><DefaultRecSelWidth>16</DefaultRecSelW" & _
|
||
"idth><ClientArea>0, 0, 506, 145</ClientArea><PrintPageHeaderStyle parent="""" me=""" & _
|
||
"Style14"" /><PrintPageFooterStyle parent="""" me=""Style15"" /></Blob>"
|
||
'
|
||
'pnlBotones
|
||
'
|
||
Me.pnlBotones.Controls.Add(Me.btnAceptar)
|
||
Me.pnlBotones.Controls.Add(Me.btnCancelar)
|
||
Me.pnlBotones.Location = New System.Drawing.Point(400, 56)
|
||
Me.pnlBotones.Name = "pnlBotones"
|
||
Me.pnlBotones.Size = New System.Drawing.Size(120, 80)
|
||
Me.pnlBotones.TabIndex = 91
|
||
'
|
||
'btnAceptar
|
||
'
|
||
Me.btnAceptar.BackColor = System.Drawing.SystemColors.Control
|
||
Me.btnAceptar.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.btnAceptar.ForeColor = System.Drawing.Color.Black
|
||
Me.btnAceptar.Image = CType(resources.GetObject("btnAceptar.Image"), System.Drawing.Image)
|
||
Me.btnAceptar.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft
|
||
Me.btnAceptar.Location = New System.Drawing.Point(16, 8)
|
||
Me.btnAceptar.Name = "btnAceptar"
|
||
Me.btnAceptar.Size = New System.Drawing.Size(96, 23)
|
||
Me.btnAceptar.TabIndex = 2
|
||
Me.btnAceptar.Text = "Aceptar"
|
||
Me.btnAceptar.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
||
'
|
||
'btnCancelar
|
||
'
|
||
Me.btnCancelar.BackColor = System.Drawing.SystemColors.Control
|
||
Me.btnCancelar.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.btnCancelar.ForeColor = System.Drawing.Color.Black
|
||
Me.btnCancelar.Image = CType(resources.GetObject("btnCancelar.Image"), System.Drawing.Image)
|
||
Me.btnCancelar.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft
|
||
Me.btnCancelar.Location = New System.Drawing.Point(16, 40)
|
||
Me.btnCancelar.Name = "btnCancelar"
|
||
Me.btnCancelar.Size = New System.Drawing.Size(96, 23)
|
||
Me.btnCancelar.TabIndex = 3
|
||
Me.btnCancelar.Text = "Cancelar"
|
||
Me.btnCancelar.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
||
'
|
||
'chkActivo
|
||
'
|
||
Me.chkActivo.Font = New System.Drawing.Font("Microsoft Sans Serif", 9.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.chkActivo.ForeColor = System.Drawing.Color.Red
|
||
Me.chkActivo.Location = New System.Drawing.Point(238, 58)
|
||
Me.chkActivo.Name = "chkActivo"
|
||
Me.chkActivo.Size = New System.Drawing.Size(96, 16)
|
||
Me.chkActivo.TabIndex = 84
|
||
Me.chkActivo.Text = "Activo:"
|
||
'
|
||
'cmbPais
|
||
'
|
||
Me.cmbPais.Location = New System.Drawing.Point(138, 118)
|
||
Me.cmbPais.Name = "cmbPais"
|
||
Me.cmbPais.Size = New System.Drawing.Size(208, 21)
|
||
Me.cmbPais.TabIndex = 83
|
||
'
|
||
'txtNombre
|
||
'
|
||
Me.txtNombre.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper
|
||
Me.txtNombre.Location = New System.Drawing.Point(138, 86)
|
||
Me.txtNombre.Name = "txtNombre"
|
||
Me.txtNombre.Size = New System.Drawing.Size(208, 20)
|
||
Me.txtNombre.TabIndex = 82
|
||
Me.txtNombre.Text = ""
|
||
'
|
||
'txtClave
|
||
'
|
||
Me.txtClave.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper
|
||
Me.txtClave.Location = New System.Drawing.Point(138, 54)
|
||
Me.txtClave.Name = "txtClave"
|
||
Me.txtClave.ReadOnly = True
|
||
Me.txtClave.Size = New System.Drawing.Size(56, 20)
|
||
Me.txtClave.TabIndex = 85
|
||
Me.txtClave.Text = ""
|
||
'
|
||
'Label4
|
||
'
|
||
Me.Label4.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.Label4.Location = New System.Drawing.Point(90, 126)
|
||
Me.Label4.Name = "Label4"
|
||
Me.Label4.Size = New System.Drawing.Size(32, 16)
|
||
Me.Label4.TabIndex = 88
|
||
Me.Label4.Text = "Pa<EFBFBD>s:"
|
||
'
|
||
'Label1
|
||
'
|
||
Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.Label1.Location = New System.Drawing.Point(42, 62)
|
||
Me.Label1.Name = "Label1"
|
||
Me.Label1.Size = New System.Drawing.Size(80, 16)
|
||
Me.Label1.TabIndex = 86
|
||
Me.Label1.Text = "Clave Estado:"
|
||
'
|
||
'Label2
|
||
'
|
||
Me.Label2.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.Label2.Location = New System.Drawing.Point(74, 94)
|
||
Me.Label2.Name = "Label2"
|
||
Me.Label2.Size = New System.Drawing.Size(48, 16)
|
||
Me.Label2.TabIndex = 87
|
||
Me.Label2.Text = "Nombre:"
|
||
'
|
||
'Button1
|
||
'
|
||
Me.Button1.BackColor = System.Drawing.SystemColors.Control
|
||
Me.Button1.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
||
Me.Button1.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft
|
||
Me.Button1.Location = New System.Drawing.Point(408, 324)
|
||
Me.Button1.Name = "Button1"
|
||
Me.Button1.Size = New System.Drawing.Size(104, 24)
|
||
Me.Button1.TabIndex = 92
|
||
Me.Button1.Text = "Alias ..."
|
||
Me.Button1.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
||
'
|
||
'EstadoCat
|
||
'
|
||
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
||
Me.BackColor = System.Drawing.Color.White
|
||
Me.ClientSize = New System.Drawing.Size(526, 357)
|
||
Me.Controls.Add(Me.Button1)
|
||
Me.Controls.Add(Me.GroupBox1)
|
||
Me.Controls.Add(Me.pnlBotones)
|
||
Me.Controls.Add(Me.chkActivo)
|
||
Me.Controls.Add(Me.cmbPais)
|
||
Me.Controls.Add(Me.txtNombre)
|
||
Me.Controls.Add(Me.txtClave)
|
||
Me.Controls.Add(Me.Label4)
|
||
Me.Controls.Add(Me.Label1)
|
||
Me.Controls.Add(Me.Label2)
|
||
Me.Controls.Add(Me.ToolBar)
|
||
Me.Name = "EstadoCat"
|
||
Me.Text = "Catalogo: Estado"
|
||
Me.GroupBox1.ResumeLayout(False)
|
||
CType(Me.C1TrueDBGrid1, System.ComponentModel.ISupportInitialize).EndInit()
|
||
Me.pnlBotones.ResumeLayout(False)
|
||
Me.ResumeLayout(False)
|
||
|
||
End Sub
|
||
|
||
#End Region
|
||
|
||
Dim clCmp As New clsComplejo
|
||
Dim guardar As Boolean
|
||
|
||
Private Sub EstadoCat_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
||
guardar = False
|
||
txtNombre.Enabled = False
|
||
sbIniciaForma()
|
||
End Sub
|
||
|
||
Private Sub sbIniciaForma()
|
||
Try
|
||
'Llena combo y grid
|
||
clCmp.sbLlenaCombo("spListaPais ", Me.cmbPais)
|
||
clCmp.fdtDataSetTabla("spGridEstados 0")
|
||
Me.C1TrueDBGrid1.SetDataBinding(clCmp.ds, "Tabla") 'Llena el grid
|
||
Catch ex As Exception
|
||
MessageBox.Show(ex.Message, "MINDS", MessageBoxButtons.OK, MessageBoxIcon.Error)
|
||
End Try
|
||
End Sub
|
||
|
||
Private Sub Carga()
|
||
Dim lsComando As String
|
||
Dim clCmpPais As New clsComplejo
|
||
lsComando = "spGridEstados " & cmbPais.SelectedValue
|
||
clCmpPais.fdtDataSetTabla(lsComando)
|
||
Me.C1TrueDBGrid1.SetDataBinding(clCmpPais.ds, "Tabla") 'Llena el grid
|
||
End Sub
|
||
|
||
Private Sub cmbPais_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbPais.SelectedIndexChanged
|
||
'Al seleccionar otro pais se cambia el grid para mostrar sus estados correspondientes
|
||
'On Error Resume Next
|
||
Try
|
||
Me.txtNombre.Text = ""
|
||
'Llena el grid
|
||
Carga()
|
||
Catch ex As Exception
|
||
End Try
|
||
End Sub
|
||
|
||
Private Sub ToolBar_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar.ButtonClick
|
||
Select Case e.Button.Text
|
||
Case "Agregar"
|
||
guardar = True
|
||
txtNombre.Enabled = True
|
||
Limpiar()
|
||
Case "Actualizar"
|
||
guardar = True
|
||
txtNombre.Enabled = True
|
||
Case "Salir"
|
||
Me.Close()
|
||
End Select
|
||
End Sub
|
||
|
||
Private Sub Limpiar()
|
||
txtClave.Text = ""
|
||
txtNombre.Text = ""
|
||
txtNombre.Enabled = True
|
||
End Sub
|
||
|
||
Private Sub btnAceptar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAceptar.Click
|
||
sbGuardar()
|
||
txtNombre.Enabled = False
|
||
End Sub
|
||
|
||
Private Sub sbGuardar()
|
||
Dim lsMensaje As String
|
||
|
||
If MsgBox("<EFBFBD>Desea guardar los cambios?", MsgBoxStyle.Question + MsgBoxStyle.YesNo, "MINDS Cliente") = MsgBoxResult.No Then Exit Sub
|
||
If fbValidaGrabar() Then
|
||
lsMensaje = "Datos guardados correctamente"
|
||
'sbIniciaForma()
|
||
Carga()
|
||
Else
|
||
lsMensaje = "Los datos no fueron guardados"
|
||
End If
|
||
MsgBox(lsMensaje, MsgBoxStyle.Information + MsgBoxStyle.OKOnly, "Cliente")
|
||
End Sub
|
||
|
||
Private Function fbValidaGrabar() As Boolean
|
||
Dim liClave As Integer
|
||
Dim liClavePais As Integer
|
||
Dim liActivo As Integer
|
||
Dim lsNombre As String
|
||
Dim lsSQL As String
|
||
|
||
On Error GoTo eh
|
||
|
||
fbValidaGrabar = False
|
||
|
||
If cmbPais.SelectedIndex = -1 Then
|
||
MsgBox("Pa<EFBFBD>s no v<>lido", MsgBoxStyle.Information + MsgBoxStyle.OKOnly, "Cliente")
|
||
Exit Function
|
||
End If
|
||
|
||
If txtClave.Text = "" Then
|
||
liClave = -1
|
||
Else
|
||
liClave = Val(txtClave.Text)
|
||
End If
|
||
liClavePais = cmbPais.SelectedValue
|
||
liActivo = IIf(chkActivo.Checked, 1, 0)
|
||
lsNombre = txtNombre.Text.Trim
|
||
|
||
If Len(lsNombre.Trim) = 0 Then
|
||
MsgBox("Nombre no v<>lido", MsgBoxStyle.Information + MsgBoxStyle.OKOnly, "Cliente")
|
||
Exit Function
|
||
End If
|
||
lsSQL = ""
|
||
lsSQL = lsSQL & "spGrabaCatEstado "
|
||
lsSQL = lsSQL & liClave & ", "
|
||
lsSQL = lsSQL & liClavePais & ", 8, '"
|
||
lsSQL = lsSQL & lsNombre & "', "
|
||
lsSQL = lsSQL & liActivo
|
||
' MsgBox(lsSQL)
|
||
clCmp.sbGuardaModifica(lsSQL)
|
||
Return True
|
||
Exit Function
|
||
eh:
|
||
Return False
|
||
End Function
|
||
|
||
|
||
Private Sub C1TrueDBGrid1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles C1TrueDBGrid1.DoubleClick
|
||
'Recupera datos del grid y los asigna las cajas de texto
|
||
|
||
With Me.C1TrueDBGrid1
|
||
.Col = 0
|
||
txtClave.Text = .Columns(0).Value
|
||
.Col = 1
|
||
clCmp.sbBuscaEnCombo(.Columns(1).Value, Me.cmbPais)
|
||
.Col = 2
|
||
txtNombre.Text = .Columns(2).Value
|
||
.Col = 3
|
||
If .Columns(3).Text = "Activo" Then
|
||
chkActivo.Checked = True
|
||
Else
|
||
chkActivo.Checked = False
|
||
End If
|
||
End With
|
||
End Sub
|
||
|
||
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
|
||
If txtClave.Text <> "" Then
|
||
sbAlias()
|
||
Else
|
||
MessageBox.Show("Debe Selecionar un elemento", "Minds", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
|
||
End If
|
||
End Sub
|
||
|
||
Private Sub sbAlias()
|
||
Dim miAlias As New ActAlias
|
||
miAlias.Entra(8, txtClave.Text.Trim)
|
||
miAlias.Text = "Alias Estados"
|
||
miAlias.piCatalogo = 8
|
||
miAlias.Show()
|
||
End Sub
|
||
End Class
|