Sistema de Ventas Parte - Mantenimiento de Clientes - Proforma [Hervert Navarro Vela]

Ado .NET

Proyecto : Sistema de Ventas

Flujo de Formularios

1. Mantenimiento de Clientes

Click en el botón :

UserLinuxPlug – Hervert Navarro Vela - 17 - [email protected]

1

123456

789

101112

1314

15

2

Ado .NET

Juridico :


3

17181920

21222324252627282930313233

4

Ado .NET

2. Proforma:

Enviar datos a proforma

Nuevo Cliente : Llama al mantenimiento de ClientesCliente Existente :

Nota : En todas las consultas la información se envía al hacer doble click en la fila del datagrid.

Codificación del Formulario Mantenimiento de Clientes


5

3435363738

3940414243

4445

464748495051525354

6

Ado .NET

Modulo : Variables.vb

Imports System.Data.SqlClientModule Variables Public cadsql$ Public estado% = 0 Public vima% = 0 Public i%, b%, f%, c%, cj%, pro%, ct%'son las variables para la matriz Public alfa% = 0 Public beta% = 0 Public remision% = 0 Public asa% = 0 Sub sololetras_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) If e.KeyChar.IsLetter(e.KeyChar) Then e.Handled = False ElseIf e.KeyChar.IsControl(e.KeyChar) Then e.Handled = False ElseIf e.KeyChar.IsSeparator(e.KeyChar) Then e.Handled = False Else MsgBox("Solo letras") e.Handled = True End If End Sub


7

55565758596061626364656667686970717273747576777879808182

8

Ado .NET

Sub solonumeros_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) If e.KeyChar.IsDigit(e.KeyChar) Then e.Handled = False ElseIf e.KeyChar.IsControl(e.KeyChar) Then e.Handled = False Else MsgBox("Solo Numeros") e.Handled = True End If End SubEnd Module

Formulario : MClientes.vb

Option Explicit OffImports LibreriaMantenimientoPublic Class MClientes

Dim clase As New ClaseMetodos

#Region "variables" Private estado% = 0 Public coddep$, codpro$, coddis$ Dim total%, pos% Dim cod$, apep$, apem$, nom$, dni$, email$, dir$, tel$, ob$, depa$, prov$, dist$ Dim cadsql$, tip$ Dim razon$, ruc$, conta$#End Region

#Region "Procedimientos" Sub mostrarprov(ByVal nomdep$) Me.cbprovincia.Items.Clear() clase.datos.Clear() clase.verdatos("select iddepartamento from departamentos where nomdepartamento='" & nomdep & "'") coddep = clase.datos.Tables("x").Rows(0).Item(0) clase.verdatos("select nomprovincia from provincias where iddepartamento='" & coddep & "'")

For p = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbprovincia.Items.Add(clase.datos.Tables("x").Rows(p).Item(0)) Next ' MsgBox(coddep) End Sub Sub mostrardist(ByVal nompro$) Me.cbdistrito.Items.Clear() clase.datos.Clear() clase.verdatos("select idprovincia from Provincias where

nomprovincia='" & nompro & "'") codpro = clase.datos.Tables("x").Rows(0).Item(0) clase.verdatos("select nomdistrito from Distritos where idprovincia='" & codpro & "'") For p = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbdistrito.Items.Add(clase.datos.Tables("x").Rows(p).Item(0)) NextEnd Sub

Sub llenarcombos()


9

838485868788899091929394

95

96979899100101

102103

104105106107108109110111112113

114115116117118119120121122123124125126127128129130131132133134135136137138139140141

142143

10

Ado .NET

Me.cbdepar.Items.Clear() Me.cbprovincia.Items.Clear() Me.cbdistrito.Items.Clear() clase.verdatos("select * from Departamentos ORDER BY NOMDEPARTAMENTO") For a = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbdepar.Items.Add(clase.datos.Tables("x").Rows(a).Item(1)) Nextclase.verdatos("select * from provincias ORDER BY NOMPROVINCIA") For a = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbprovincia.Items.Add(clase.datos.Tables("x").Rows(a).Item(1)) Next clase.verdatos("select * from distritos ORDER BY NOMDISTRITO ") For a = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbdistrito.Items.Add(clase.datos.Tables("x").Rows(a).Item(1)) Next End Sub

Sub LIMPIARTEXTOS() For Each o In Me.GroupBox2.Controls If TypeOf o Is TextBox Then o.clear() End If Next Me.txtdir.Text = "" Me.cbdepar.Text = "" Me.cbprovincia.Text = "" Me.cbdistrito.Text = "" End Sub Sub autogenera() Dim ncliente$ clase.datos.Clear() clase.verdatos("Select * from Clientes") ncliente = clase.datos.Tables("x").Rows.Count + 1 Me.txtCodigo.Text = Mid("C0000", 1, 6 - Len(Str(ncliente))) & (ncliente + 1).ToString Me.txtapp.Focus() End Sub Sub Ver() If total = 0 Then MsgBox("Tabla Vacia", MsgBoxStyle.Information) OCULTARBOTONES(False) DESACTIVARBOTONES(False) Else With clase.datos.Tables("x").Rows(pos) Me.txtCodigo.Text = .Item(0) Me.txttipo.Text = .Item(1) Me.txtapp.Text = .Item(2) Me.txtapm.Text = .Item(3) Me.txtnom.Text = .Item(4) Me.txtdni.Text = .Item(5) Me.txtdir.Text = .Item(6) Me.txttel.Text = .Item(7) Me.txtob.Text = .Item(8) Me.txtemail.Text = .Item(9) Me.cbdepar.Text = .Item(10) Me.cbprovincia.Text = .Item(11) Me.cbdistrito.Text = .Item(12) End With Me.btnmensaje.Text = "Registro...>" + (pos + 1).ToString + Space(2) + "de..>" + Space(2) + total.ToString


11

144145146147148149150151152153154155156157158159160

161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204

12

Ado .NET

End If End Sub Sub OCULTARBOTONES(ByVal valor As Boolean) For Each o In Me.GroupBox6.Controls If TypeOf o Is Button Then o.enabled = valor End If Next End Sub Sub DESACTIVARBOTONES(ByVal valor As Boolean) For Each o In Me.Controls If TypeOf o Is Button Then If o.name = "nuevo" Or o.name = "actualiza" Then o.enabled = Not valor Else o.enabled = valor End If End If Next End Sub Sub ACTUALIZAR() clase.datos.Clear() clase.verdatos("SELECT dbo.clientes.idcliente, dbo.clientes.idtipo, dbo.clientes.apematerno, dbo.clientes.apepaterno, dbo.clientes.nombres, dbo.clientes.dni," & _" dbo.clientes.direccion, dbo.clientes.telefono, dbo.clientes.observaciones, dbo.clientes.email, dbo.departamentos.nomdepartamento, " & _" dbo.provincias.nomprovincia, dbo.distritos.nomdistrito" & _" FROM dbo.clientes INNER JOIN" & _" dbo.departamentos ON dbo.clientes.Iddepartamento = dbo.departamentos.Iddepartamento INNER JOIN" & _" dbo.provincias ON dbo.clientes.idprovincia = dbo.provincias.idprovincia AND " & _" dbo.departamentos.Iddepartamento = dbo.provincias.Iddepartamento INNER JOIN" & _" dbo.distritos ON dbo.clientes.iddistrito = dbo.distritos.iddistrito AND dbo.provincias.idprovincia = dbo.distritos.idprovincia" & _" where dbo.clientes.idtipo='T1'") total = clase.datos.Tables("x").Rows.Count pos = 0 Ver() End Sub#End Region

#Region "Procedimiento2" Sub ACTUALIZAR2() clase.datos.Clear() clase.verdatos(" SELECT dbo.clientes.idcliente, dbo.clientes.idtipo, dbo.departamentos.nomdepartamento, dbo.provincias.nomprovincia, dbo.distritos.nomdistrito, " & _" dbo.clientes.razonsocial, dbo.clientes.contacto, dbo.clientes.ruc, dbo.clientes.observaciones, dbo.clientes.direccion" & _" FROM dbo.clientes INNER JOIN" & _" dbo.departamentos ON dbo.clientes.Iddepartamento = dbo.departamentos.Iddepartamento INNER JOIN" & _" dbo.provincias ON dbo.clientes.idprovincia = dbo.provincias.idprovincia AND " & _" dbo.departamentos.Iddepartamento = dbo.provincias.Iddepartamento INNER JOIN" & _


13

205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248

249250251252253254255256257258259260261262263264

14

Ado .NET

" dbo.distritos ON dbo.clientes.iddistrito = dbo.distritos.iddistrito AND dbo.provincias.idprovincia = dbo.distritos.idprovincia where dbo.clientes.idtipo='T2'") total = clase.datos.Tables("x").Rows.Count pos = 0 Ver2() End Sub Sub Ver2() If total = 0 Then MsgBox("Tabla Vacia", MsgBoxStyle.Information) OCULTARBOTONES(False) DESACTIVARBOTONES(False) Else With clase.datos.Tables("x").Rows(pos) Me.txtCodigo.Text = .Item(0) Me.txttipo.Text = .Item(1) Me.txtrazon.Text = .Item(5) Me.txtconta.Text = .Item(6) Me.txtruc.Text = .Item(7) Me.txtdir.Text = .Item(9) Me.txtob.Text = .Item(8) Me.cbdepar.Text = .Item(2) Me.cbprovincia.Text = .Item(3) Me.cbdistrito.Text = .Item(4) End With Me.btnmensaje.Text = "Registro...>" + (pos + 1).ToString + Space(2) + "de..>" + Space(2) + total.ToString End If End Sub Dim o As New Object Sub LIMPIARTEXTOS2() For Each o In Me.GroupBox3.Controls If TypeOf o Is TextBox Then o.clear() End If Next Me.txtdir.Text = "" Me.cbdepar.Text = "" Me.cbprovincia.Text = "" Me.cbdistrito.Text = "" End Sub#End Region Private Sub MClientes_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Height = 112 clase.conectar("(local)", "sisventas_HNV", "sa", "123") End Sub

Private Sub cbdepar_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbdepar.SelectedIndexChanged If estado = 0 Then mostrarprov(Me.cbdepar.Text) End If End Sub

Private Sub cbprovincia_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbprovincia.SelectedIndexChanged If estado = 0 Then mostrardist(Me.cbprovincia.Text)


15

265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311

312313314315316317318319

320321322323324325

16

Ado .NET

End If End Sub Private Sub cbdistrito_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbdistrito.SelectedIndexChanged If estado = 0 Then clase.datos.Clear() clase.verdatos("select * from Distritos where idprovincia='" & codpro & "' and nomdistrito='" & Me.cbdistrito.Text & "'")

coddis = clase.datos.Tables("x").Rows(0).Item(0) End If End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles siguiente.Click If Me.tipo.Text = "Natural" Then If pos < clase.datos.Tables("x").Rows.Count - 1 Then pos += 1 Ver() Else MsgBox("Final") End If ElseIf Me.tipo.Text = "Juridico" Then If pos < clase.datos.Tables("x").Rows.Count - 1 Then pos += 1 Ver2() Else MsgBox("Final") End If End If End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles primero.Click If Me.tipo.Text = "Natural" Then pos = 0 Ver() ElseIf Me.tipo.Text = "Juridico" Then pos = 0 Ver2() End If End Sub

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ultimo.Click If Me.tipo.Text = "Natural" Then pos = clase.datos.Tables("x").Rows.Count - 1 Ver() ElseIf Me.tipo.Text = "Juridico" Then pos = clase.datos.Tables("x").Rows.Count - 1 Ver2() End If End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles anterior.Click If Me.tipo.Text = "Natural" Then If pos > 0 Then pos -= 1 Ver()


17

326327328329330331332333334335

336337338339340341342343344345346347348349350351352353354355356357

358359360361362363364365366367368

369370371372373374375376377378379

380381382383384385386

18

Ado .NET

Else MsgBox("Inicio") End If ElseIf Me.tipo.Text = "Juridico" Then If pos > 0 Then pos -= 1 Ver2() Else MsgBox("Inicio") End If End If End Sub

Private Sub tipo_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tipo.SelectedIndexChanged If Me.tipo.Text = "Natural" Then Me.GroupBox2.Visible = True Me.GroupBox3.Visible = False clase.verdatos("SELECT dbo.clientes.idcliente, dbo.clientes.idtipo, dbo.clientes.apematerno, dbo.clientes.apepaterno, dbo.clientes.nombres, dbo.clientes.dni," & _" dbo.clientes.direccion, dbo.clientes.telefono, dbo.clientes.observaciones, dbo.clientes.email, dbo.departamentos.nomdepartamento, " & _" dbo.provincias.nomprovincia, dbo.distritos.nomdistrito" & _" FROM dbo.clientes INNER JOIN" & _" dbo.departamentos ON dbo.clientes.Iddepartamento = dbo.departamentos.Iddepartamento INNER JOIN" & _" dbo.provincias ON dbo.clientes.idprovincia = dbo.provincias.idprovincia AND " & _" dbo.departamentos.Iddepartamento = dbo.provincias.Iddepartamento INNER JOIN" & _" dbo.distritos ON dbo.clientes.iddistrito = dbo.distritos.iddistrito AND dbo.provincias.idprovincia = dbo.distritos.idprovincia" & _" where dbo.clientes.idtipo='T1'")ACTUALIZAR()Me.Height = 496

ElseIf Me.tipo.Text = "Juridico" Then Me.GroupBox2.Visible = False Me.GroupBox3.Visible = True clase.verdatos("SELECT dbo.clientes.idcliente, " & _ "dbo.clientes.idtipo, dbo.departamentos.nomdepartamento, " & _ "dbo.provincias.nomprovincia, dbo.distritos.nomdistrito, " & _ " dbo.clientes.razonsocial, dbo.clientes.contacto, " & _ "dbo.clientes.ruc, dbo.clientes.observaciones" & _ " FROM dbo.clientes INNER JOIN" & _ " dbo.departamentos ON " & _ " dbo.clientes.Iddepartamento = dbo.departamentos.Iddepartamento " & _ " INNER JOIN" & _ " dbo.provincias ON " & _ " dbo.clientes.idprovincia = dbo.provincias.idprovincia AND " & _ " dbo.departamentos.Iddepartamento = dbo.provincias.Iddepartamento " & _ " INNER JOIN dbo.distritos ON " & _ " dbo.clientes.iddistrito = dbo.distritos.iddistrito AND " & _ " dbo.provincias.idprovincia = dbo.distritos.idprovincia" & _ " where dbo.clientes.idtipo='T2'") ACTUALIZAR2()


19

387388389390391392393394395396397398

399400401402403404405406407408409410411412413414415416417418419420421422423424

425426427428429430431432433434435436437438439440441442443444445446447

20

Ado .NET

Me.Height = 496 End If End Sub Private Sub nuevo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles nuevo.Click If Me.tipo.Text = "Natural" Then If nuevo.Text = "Nuevo" Then estado = 0 LIMPIARTEXTOS() If Me.tipo.Text = "Natural" Then Me.txttipo.Text = "T1" Else Me.txttipo.Text = "T2" End If llenarcombos() autogenera() Me.txtapp.Focus() OCULTARBOTONES(False) Me.btnmensaje.Text = "Ingrese Registro" DESACTIVARBOTONES(False) Me.nuevo.Text = "Grabar" Me.nuevo.ImageIndex = 7 Me.actualiza.Text = "Cancelar" Me.actualiza.ImageIndex = 8 Else 'datos.Clear() cod = Me.txtCodigo.Text apep = Me.txtapp.Text apem = Me.txtapm.Text nom = Me.txtnom.Text dni = Me.txtdni.Text email = Me.txtemail.Text dir = Me.txtdir.Text tel = Me.txttel.Text ob = Me.txtob.Text depa = Me.cbdepar.Text prov = Me.cbprovincia.Text dist = Me.cbdistrito.Text tip = Me.txttipo.Text cadsql = "insert into clientes values ('" & cod & "','" & tip & "','" & razon & "','" & apep & "','" & apem & "','" & nom & "','" & dni & "','" & conta & "','" & ruc & "','" & dir & "','" & coddep & "','" & codpro & "','" & coddis & "','" & tel & "','" & email & "','" & ob & "')" clase.ejecutarsql(cadsql) estado = 1 ACTUALIZAR() MsgBox("Registro Insertado") OCULTARBOTONES(True) DESACTIVARBOTONES(True) Me.nuevo.Enabled = True Me.actualiza.Enabled = True Me.nuevo.Text = "Nuevo" Me.nuevo.ImageIndex = 0 Me.actualiza.Text = "Actualizar" Me.actualiza.ImageIndex = 1 End If ElseIf Me.tipo.Text = "Juridico" Then If nuevo.Text = "Nuevo" Then estado = 0


21

448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508

22

Ado .NET

LIMPIARTEXTOS2() If Me.tipo.Text = "Natural" Then Me.txttipo.Text = "T1" Else Me.txttipo.Text = "T2" End If llenarcombos() autogenera() Me.txtapp.Focus() OCULTARBOTONES(False) Me.btnmensaje.Text = "Ingrese Registro" DESACTIVARBOTONES(False) Me.nuevo.Text = "Grabar" Me.nuevo.ImageIndex = 7 Me.actualiza.Text = "Cancelar" Me.actualiza.ImageIndex = 8 Else 'datos.Clear() cod = Me.txtCodigo.Text razon = Me.txtrazon.Text conta = Me.txtconta.Text ruc = Me.txtruc.Text ob = Me.txtob.Text depa = Me.cbdepar.Text dir = Me.txtdir.Text prov = Me.cbprovincia.Text dist = Me.cbdistrito.Text tip = Me.txttipo.Text '''''''' apep = "-" : apem = "-" nom = "-" : dni = "-" email = "-" : tel = "-" ''''''''' cadsql = "insert into clientes values ('" & cod & "','" & tip & "','" & razon & "','" & apep & "','" & apem & "','" & nom & "','" & dni & "','" & conta & "','" & ruc & "','" & dir & "','" & coddep & "','" & codpro & "','" & coddis & "','" & tel & "','" & email & "','" & ob & "')" clase.ejecutarsql(cadsql) estado = 1 ACTUALIZAR2() MsgBox("Registro Insertado") OCULTARBOTONES(True) DESACTIVARBOTONES(True) Me.nuevo.Enabled = True Me.actualiza.Enabled = True Me.nuevo.Text = "Nuevo" Me.nuevo.ImageIndex = 0 Me.actualiza.Text = "Actualizar" Me.actualiza.ImageIndex = 1 End If End If End Sub

Private Sub actualiza_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles actualiza.Click If Me.tipo.Text = "Natural" Then If Me.actualiza.Text = "Actualizar" Then If (MsgBox("esta seguro de editar", MsgBoxStyle.YesNo + MsgBoxStyle.Question, "Aviso") = MsgBoxResult.Yes) Then cod = Me.txtCodigo.Text


23

509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561

562563564565566567568569

24

Ado .NET

apep = Me.txtapp.Text apem = Me.txtapm.Text nom = Me.txtnom.Text dni = Me.txtdni.Text email = Me.txtemail.Text dir = Me.txtdir.Text tel = Me.txttel.Text ob = Me.txtob.Text depa = Me.cbdepar.Text prov = Me.cbprovincia.Text dist = Me.cbdistrito.Text tip = Me.txttipo.Text mostrardist(Me.cbprovincia.Text) mostrarprov(Me.cbdepar.Text)

clase.verdatos("select iddistrito from Distritos where idprovincia='" & codpro & "'")

Dim p% For p = 0 To clase.datos.Tables("x").Rows.Count - 1 coddis = clase.datos.Tables("x").Rows(p).Item(0) Next

cadsql = "update clientes set idtipo='" & tip & "',razonsocial='" & razon & "',apepaterno='" & apep & "',apematerno='" & apem & "',nombres='" & nom & "',dni='" & dni & "',contacto='" & conta & "',ruc='" & ruc & "',direccion='" & dir & "',iddepartamento='" & coddep & "',idprovincia='" & codpro & "',iddistrito='" & coddis & "',telefono='" & tel & "',email='" & email & "',observaciones='" & ob & "' where idcliente='" & cod & "'"

clase.ejecutarsql(cadsql) estado = 1 ACTUALIZAR() MsgBox("registro Aditado", MsgBoxStyle.Information, "Actualizado") Else MsgBox("Edicion Anulada", MsgBoxStyle.Critical, "Anulado") ACTUALIZAR() End If Else MsgBox("Inserccion Anulada", MsgBoxStyle.Critical, "Anulada") estado = 1 Me.actualiza.Text = "Actualizar" Me.actualiza.ImageIndex = 3 Me.nuevo.Text = "Nuevo" Me.nuevo.ImageIndex = 0 OCULTARBOTONES(True) DESACTIVARBOTONES(True) Me.nuevo.Enabled = True Me.actualiza.Enabled = True ACTUALIZAR() End If ElseIf Me.tipo.Text = "Juridico" Then If Me.actualiza.Text = "Actualizar" Then If (MsgBox("esta seguro de editar",

MsgBoxStyle.YesNo + MsgBoxStyle.Question, "Aviso") = MsgBoxResult.Yes) Then

cod = Me.txtCodigo.Text razon = Me.txtrazon.Text conta = Me.txtconta.Text ruc = Me.txtruc.Text ob = Me.txtob.Text dir = Me.txtdir.Text


25

570571572573574575576577578579580581582583584585586587588589

590591592593594595596597

598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630

26

Ado .NET

depa = Me.cbdepar.Text prov = Me.cbprovincia.Text dist = Me.cbdistrito.Text tip = Me.txttipo.Text mostrardist(Me.cbprovincia.Text) mostrarprov(Me.cbdepar.Text) clase.verdatos("select iddistrito from Distritos where idprovincia='" & codpro & "'") Dim p% For p = 0 To clase.datos.Tables("x").Rows.Count - 1 coddis = clase.datos.Tables("x").Rows(p).Item(0) Next

cadsql = "update clientes set idtipo='" & tip & "',razonsocial='" & razon & "',apepaterno='" & apep & "',apematerno='" & apem & "',nombres='" & nom & "',dni='" & dni & "',contacto='" & conta & "',ruc='" & ruc & "',direccion='" & dir & "',iddepartamento='" & coddep & "',idprovincia='" & codpro & "',iddistrito='" & coddis & "',telefono='" & tel & "',email='" & email & "',observaciones='" & ob & "' where idcliente='" & cod & "'" clase.ejecutarsql(cadsql) estado = 1 ACTUALIZAR2()MsgBox("registro Aditado", MsgBoxStyle.Information, "Actualizado") ElseMsgBox("Edicion Anulada", MsgBoxStyle.Critical, "Anulado") ACTUALIZAR2() End If ElseMsgBox("Inserccion Anulada", MsgBoxStyle.Critical, "Anulada") estado = 1 Me.actualiza.Text = "Cancelar" Me.actualiza.ImageIndex = 3 Me.nuevo.Text = "Nuevo" Me.nuevo.ImageIndex = 0 OCULTARBOTONES(True) DESACTIVARBOTONES(True) Me.nuevo.Enabled = True Me.actualiza.Enabled = True ACTUALIZAR2() End If End If End Sub

Private Sub eliminar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles eliminar.Click If Me.tipo.Text = "Natural" Then If MsgBox("esta seguro ?", MsgBoxStyle.YesNo + MsgBoxStyle.Question, "Aviso") = MsgBoxResult.Yes Then cod = Me.txtCodigo.Text cadsql = "delete from clientes where idcliente='" & cod & "'" clase.ejecutarsql(cadsql) MsgBox("Registro eliminado", MsgBoxStyle.Exclamation, "Eliminado") ACTUALIZAR() End If ElseIf Me.tipo.Text = "Juridico" Then If MsgBox("esta seguro ?", MsgBoxStyle.YesNo + MsgBoxStyle.Question, "Aviso") = MsgBoxResult.Yes Then cod = Me.txtCodigo.Text


27

631632633634635636637638639640641642

643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673

674675676677678679680681682683684685686687688689690691

28

Ado .NET

cadsql = "delete from clientes where idcliente='" & cod & "'" clase.ejecutarsql(cadsql) MsgBox("Registro eliminado", MsgBoxStyle.Exclamation, "Eliminado") ACTUALIZAR2() End If End If End Sub

Private Sub consultar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles consultar.Click Dim ce As New Cons_Clientes ce.ShowDialog() End Sub Private Sub Button4_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Me.Timer1.Enabled = True End Sub Dim pro As New Proforma Private Sub LinkLabel1_LinkClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles LinkLabel1.LinkClicked cod = Me.txtCodigo.Text apep = Me.txtapp.Text apem = Me.txtapm.Text nom = Me.txtnom.Text dni = Me.txtdni.Text email = Me.txtemail.Text dir = Me.txtdir.Text tel = Me.txttel.Text ob = Me.txtob.Text depa = Me.cbdepar.Text prov = Me.cbprovincia.Text dist = Me.cbdistrito.Text tip = Me.txttipo.Text matriz(asa, 0) = cod pro.txtnombres.Text = nom + " " + apep + " " + apem pro.txtdireccion.Text = dir pro.txttelefono.Text = tel Me.Hide() pro.ShowDialog()

End Sub Dim cont% = 0, t% Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick If cont = 0 Then t += 1 Me.Opacity = t / 100 If t = 100 Then Me.Timer1.Enabled = False cont = 1 End If Else t -= 1 Me.Opacity = t / 100 If t = 1 Then Me.Close() End If End If


29

692693694695696697698699700

701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733

734735736737738739740741742743744745746747748749750751752

30

Ado .NET

End Sub '----Validar Private Sub txtdni_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtdni.KeyPress solonumeros_KeyPress(Me, e) End Sub Private Sub txtapp_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtapp.KeyPress sololetras_KeyPress(Me, e) End Sub Private Sub txtapm_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtapm.KeyPress sololetras_KeyPress(Me, e) End Sub Private Sub txtnom_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtnom.KeyPress sololetras_KeyPress(Me, e) End Sub Private Sub txttel_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txttel.KeyPress solonumeros_KeyPress(Me, e) End Sub

Private Sub txtruc_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtruc.KeyPress solonumeros_KeyPress(Me, e) End SubEnd Class


31

753754755756757758759760761762763764765766767768769770771772773774

775776777778779780

781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812

32

Ado .NET

Codificación del Formulario Proforma

[proforma.vb]

1. Declarar las siguientes variables en el módulo :

'------------------------------ Public nombresclientes$ Public estadoproforma% = 0 Public codclientep$ Public tipoclientep$ Public codigotipo$

'------------------------------------

2. Cambiar la codificación del link Enviar datos a proforma del formulario MClientes.vb.

Private Sub LinkLabel1_LinkClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles LinkLabel1.LinkClicked

cod = Me.txtCodigo.Text apep = Me.txtapp.Text apem = Me.txtapm.Text nom = Me.txtnom.Text dir = Me.txtdir.Text tel = Me.txttel.Text estadoproforma = 1 pro.tbdireccion.Text = dir pro.tbtelefono.Text = tel codclientep = cod tipoclientep = Me.tipo.Text.Trim If tipoclientep = "Natural" Then codigotipo = "T1" pro.tbnombres.Text = nom + " " + apep + " " + apem Else codigotipo = "T2" pro.tbnombres.Text = Me.txtrazon.Text End If Me.Hide() pro.ShowDialog()

End Sub

3. Crear el formulario proforma .vb.


33

813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870

34

Ado .NET

4. Codificar el formulario proforma.vb

Option Explicit OffImports LibreriaMantenimientoImports System.Data.SqlClient

Public Class Proforma

'--------------------------------------------------------------------- Private tabla As New DataTable Private subtotal%, igv%, total%, dsto%, dst%, pn% Private ig%, tl%, treg%, l%, q%, pos% Private cod$, nom$, ape$, ama$, raz$, dir$, ruc$, dni$ Private tipo$, tel$, ema$, obs$, contac$ Private pos2% = -1 Private npro$, nreg1$ Dim clase As New ClaseMetodos Private fecha As Date '-----------------------------------------------------------------------


35

871872873874875876877878879880881882883884885886887888889890891

893894895896897898899900901902903904905906907908909

910911912913914915916917918919920921

36

Ado .NET

Function generarcodigo() As String clase.verdatos("select * from proforma") Dim nreg1% = clase.datos.Tables("x").Rows.Count Return Mid("P000000", 1, 8 - Len(Str(nreg1))) + Trim(Str(nreg1 + 1)) End Function

Private Sub Proforma_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load clase.conectar("(local)", "sisventas_HNV", "", "") Bloquea(True) Me.Label23.Text = ususistema tabla.Columns.Add("Item") tabla.Columns.Add("cantidad") tabla.Columns.Add("Descripcion") tabla.Columns.Add("P. Unit") tabla.Columns.Add("Dsto") tabla.Columns.Add("Importe") 'Me.Label23.Text = ususistema fecha = CDate(Mid(Me.DateTimePicker1.Value, 1, 10)) Me.DataGrid1.CaptionText = "Detalle de Productos" Me.DataGrid1.DataSource = tabla Me.StatusBar1.Text = Now() ''''' Me.cbproducto.Items.Clear() clase.verdatos("select * from Producto") For p = 0 To clase.datos.Tables("x").Rows.Count - 1 Me.cbproducto.Items.Add(clase.datos.Tables("x").Rows(p).Item(2)) Next End Sub Dim o As New Object Sub Bloquea(ByVal valor As Boolean) For Each o In Me.GroupBox2.Controls If TypeOf o Is TextBox Then o.readonly = valor End If Next For Each o In Me.GroupBox4.Controls If TypeOf o Is TextBox Then o.readonly = valor End If Next Me.DateTimePicker1.Enabled = Not valor Me.DataGrid1.Enabled = Not valor Me.DataGrid1.ReadOnly = True Me.cbproducto.Enabled = Not valor End Sub Sub desactivarbotones(ByVal valor As Boolean) For x = 0 To Me.ToolBar1.Buttons.Count - 1 If x = 4 Or x = 5 Then Me.ToolBar1.Buttons(x).enabled = Not valor Else Me.ToolBar1.Buttons(x).enabled = valor End If Next End Sub Private Sub ToolBar1_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar1.ButtonClick Select Case Me.ToolBar1.Buttons.IndexOf(e.Button) Case 0 'nuevo pos = 0 Dim f As New Formu_tipoCliente f.ShowDialog() Case 1 'buscar Dim bp As New Cons_Proforma bp.ShowDialog() Case 2 'eliminar Try 'eliminado detalle boleta Dim cmdeliminadetalleproforma As New SqlCommand(elimina_detaproforma, clase.con) cmdeliminadetalleproforma.CommandType = CommandType.StoredProcedure Dim elidetpro As Object = New SqlParameter("@cdp", Me.lblnroproforma.Text) cmdeliminadetalleproforma.Parameters.Add(elidetpro) cmdeliminadetalleproforma.ExecuteNonQuery() : cmdeliminadetalleproforma.Dispose()


37

922923924925926

927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996

38

Ado .NET

'eliminando boleta Dim cmdeliminaboleta As New SqlCommand(elimina_proforma, clase.con) cmdeliminaboleta.CommandType = CommandType.StoredProcedure Dim elipro As Object = New SqlParameter("@cp", Me.lblnroproforma.Text) cmdeliminaboleta.Parameters.Add(elipro) cmdeliminaboleta.ExecuteNonQuery() : cmdeliminaboleta.Dispose() Catch ex As Exception MsgBox(ex.Message.ToString) End Try Case 3 'reportar Dim rp As New Reporte rp.ShowDialog() Case 6 'salir Me.Hide() Case 4 'Grabar '********************************* usua = Trim(Me.Label23.Text) dst = CInt(Trim(Me.TextBox9.Text)) 'descuento pn = CInt(Trim(Me.TextBox8.Text)) ' pago neto ig = CInt(Trim(Me.TextBox11.Text)) 'igv 'dir = Trim(Me.txtdireccion.Text) 'direccion tl = CInt(Trim(Me.TextBox7.Text)) 'total usua = "hnv" '************Varaible Global*********************** If tipoclientep = "Natural" Then Try npro = generarcodigo() Me.lblnroproforma.Text = npro 'numero factura

cadsql = "insert into proforma values('" & npro & "','" & codclientep & "','" & fecha & "','" & usua & "','" & tl & "')"

clase.ejecutarsql(cadsql) Dim y% For y = 0 To Me.DataGrid1.VisibleRowCount - 1 clase.datos.Clear() clase.verdatos("select * from producto") Dim codproducto$ clase.verdatos("select * from producto where nombreprod='" &

Me.DataGrid1.Item(y, 2) & "'") codproducto = clase.datos.Tables("x").Rows(0).Item(0) Dim ivgp%, tlp% igvp = (Val(Me.DataGrid1.Item(y, 1)) * Val(Me.DataGrid1.Item(y, 3))) –

Val(Me.DataGrid1.Item(y, 4)) tlp = igvp cadsql = "insert into detaproforma values('" & npro & "','" & codproducto & "','" &

Val(Me.DataGrid1.Item(y, 1)) & "','" & Val(Me.DataGrid1.Item(y, 4)) & "','" & Val(Me.DataGrid1.Item(y, 5)) & "','" & igvp & "','" & "" & "')"

clase.ejecutarsql(cadsql) Next MsgBox("Proforma Grabada Correctamente - Cliente Natural") Catch ex As Exception 'MsgBox(ex.Message.ToString) End Try Else Try npro = generarcodigo() Me.lblnroproforma.Text = npro 'numero factura cadsql = "insert into proforma values('" & npro & "','" & codclientep & "','" & fecha & "','"

& usua & "','" & tl & "')" clase.ejecutarsql(cadsql) Dim y% For y = 0 To Me.DataGrid1.VisibleRowCount - 1 clase.datos.Clear() clase.verdatos("select * from producto") Dim codproducto$ clase.verdatos("select * from producto where nombreprod='" &

Me.DataGrid1.Item(y, 2) & "'") codproducto = clase.datos.Tables("x").Rows(0).Item(0) cadsql = "insert into detaproforma values('" & npro & "','" & codproducto & "','" & Val(Me.DataGrid1.Item(y, 1)) & "','" & Val(Me.DataGrid1.Item(y, 4)) & "','" &

Val(Me.DataGrid1.Item(y, 5)) & "','" & igvp & "','" & "" & "')" clase.ejecutarsql(cadsql) Next MsgBox("Proforma Grabada Correctamente - Cliente Juridico")


39

997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071

40

Ado .NET

Catch ex As Exception 'MsgBox(ex.Message.ToString) End Try desactivarbotones(True) End If estadoproforma = 0 tabla.Clear() Bloquea(True) nuevo() desactivarbotones(True)

Case 5 'Cancelar tabla.Clear() Bloquea(True) MsgBox("Inserción anulada") nuevo() desactivarbotones(True) estadoproforma = 0 End Select End Sub Sub nuevo() For Each o In Me.GroupBox2.Controls If TypeOf o Is TextBox Then o.clear() End If Next For Each o In Me.GroupBox5.Controls If TypeOf o Is TextBox Then o.clear() End If Next For Each o In Me.GroupBox4.Controls If TypeOf o Is TextBox Then o.clear() End If Next Me.cbproducto.Text = "" Me.tbnombres.Focus() End Sub Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Me.StatusBar1.Text = Now() End Sub Sub calcular() subtotal += Val(Me.tbprecio.Text) * Val(Me.tbcantidad.Text) igv = subtotal * 0.19 total = subtotal + igv Me.TextBox9.Text = dsto Me.TextBox8.Text = subtotal Me.TextBox11.Text = igv Me.TextBox7.Text = total End Sub Private Sub TextBox5_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles tbcantidad.KeyDown If e.KeyCode = Keys.Enter Then

If pos < 50 Then Dim posexiste% = -1 With Me.DataGrid1 For x = 0 To .VisibleRowCount - 1 If Me.cbproducto.Text.Trim = .Item(x, 2) Then posexiste = x End If Next End With If posexiste = -1 Then Me.BindingContext(tabla).AddNew() With Me.DataGrid1 .Item(pos, 0) = (pos + 1).ToString .Item(pos, 1) = Me.tbcantidad.Text .Item(pos, 2) = Me.cbproducto.Text .Item(pos, 3) = Me.tbprecio.Text .Item(pos, 4) = Me.tbdescuento.Text .Item(pos, 5) = Val(tbprecio.Text) * Val(tbcantidad.Text) - Val(tbdescuento.Text)


41

1072107310741075107610771078107910801081

108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126

11271128112911301131113211331134113511361137113811391140114111421143114411451146

42

Ado .NET

End With dsto += Val(tbdescuento.Text) calcular() pos += 1 Else Me.DataGrid1.Item(posexiste, 1) = Str(Val(Me.DataGrid1.Item(posexiste, 1)) + Val(Me.tbcantidad.Text)) Me.DataGrid1.Item(posexiste, 5) = Val(Me.DataGrid1.Item(posexiste, 1)) * Val(Me.DataGrid1.Item(posexiste, 3)) - Val(Me.tbdescuento.Text) calcular() End If Else MsgBox("No + Productos") End If End If End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbproducto.SelectedIndexChanged clase.verdatos("select * from producto") Me.tbprecio.Text = clase.datos.Tables("x").Rows(Me.cbproducto.SelectedIndex).Item(3) Me.tbdescuento.Text = clase.datos.Tables("x").Rows(Me.cbproducto.SelectedIndex).Item(4) Me.tbcantidad.ReadOnly = False Me.tbcantidad.BackColor = Color.Red Me.tbcantidad.Clear() : Me.tbcantidad.Focus() End Sub

Private Sub DataGrid1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.DoubleClick pos2 = Me.DataGrid1.CurrentRowIndex End Sub

Private Sub DateTimePicker1_CloseUp(ByVal sender As Object, ByVal e As System.EventArgs) Handles DateTimePicker1.CloseUp fecha = CDate(Mid(Me.DateTimePicker1.Value, 1, 10)) End Sub

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim mc As New MClientes mc.Show() End Sub Private Sub Proforma_Activated(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Activated If estadoproforma = 1 Then desactivarbotones(False) Me.cbproducto.Enabled = True Me.lblnroproforma.Text = generarcodigo() ElseIf estadoproforma = 2 Then Me.tbnombres.Text = nombresclientes ElseIf codigotipo <> "" Then Me.lblnroproforma.Text = generarcodigo() Bloquea(False) nuevo() desactivarbotones(False) End If End Sub Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click Dim mc As New MClientes mc.ShowDialog() End Sub Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click Dim cn As New Cons_Pro_Clientes cn.ShowDialog() End Sub

End Class5. Crear el formulario formuTipoCliente.vb.


43

1147114811491150115111521153115411551156115711581159116011611162

11631164116511661167116811691170117111721173

11741175117611771178

11791180118111821183

118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213

12141215

12161217121812191220

44

Ado .NET

Public Class Formu_tipoCliente

Dim cont% Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick cont += 1 If cont <= 10 Then Me.Button1.Visible = Not Me.Button1.Visible Else Me.Timer1.Enabled = False Me.Close() End If End Sub

Private Sub RadioButton1_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged Me.Timer1.Enabled = True codigotipo = "T1" tipoclientep = "Natural" End Sub

Private Sub RadioButton2_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged Me.Button1.ImageIndex = 1 Me.Timer1.Enabled = True codigotipo = "T2" tipoclientep = "Juridico" End Sub

Private Sub LinkLabel1_LinkClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles LinkLabel1.LinkClicked Me.Close() End SubEnd Class

6. Crear el formulario cons_Pro_Clientes.vb.

Imports LibreriaMantenimientoPublic Class Cons_Pro_Clientes

Private vista As New DataViewDim clase As New ClaseMetodos Private Sub Label4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label4.Click Me.Hide() End Sub


45

122112221223122412251226

122712281229123012311232123312341235123612371238

1239124012411242124312441245

12461247124812491250125112521253

125412551256125712581259

1260126112621263126412651266126712681269127012711272127312741275127612771278127912801281

1282128312841285128612871288

1289

46

Ado .NET

Private Sub Cons_Pro_Clientes_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load clase.conectar("(local)", "sisventas_HNV", "", "") : Me.Height = 88 clase.verdatos("SELECT dbo.clientes.idcliente, dbo.clientes.razonsocial, " & _ "dbo.clientes.apematerno, dbo.clientes.apepaterno, " & _ "dbo.clientes.nombres, dbo.clientes.dni, dbo.clientes.contacto, " & _ "dbo.clientes.ruc, dbo.clientes.direccion, dbo.clientes.telefono, " & _ "dbo.distritos.nomdistrito, dbo.provincias.nomprovincia, " & _ "dbo.departamentos.nomdepartamento, dbo.clientes.email, " & _ "dbo.clientes.observaciones fROM dbo.clientes INNER JOIN " & _ "dbo.departamentos ON dbo.clientes.Iddepartamento = dbo.departamentos.Iddepartamento " & _ "INNER JOIN dbo.distritos ON dbo.clientes.iddistrito = dbo.distritos.iddistrito " & _ " INNER JOIN dbo.provincias ON dbo.clientes.idprovincia = dbo.provincias.idprovincia " & _ "AND dbo.departamentos.Iddepartamento = dbo.provincias.Iddepartamento " & _ "AND dbo.distritos.idprovincia = dbo.provincias.idprovincia where clientes.idtipo = '" & codigotipo & "'") Me.DataGrid1.SetDataBinding(clase.datos, "x") End Sub

Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged Select Case True Case Me.RadioButton1.Checked = True vista.Table = clase.datos.Tables("x") vista.RowFilter = "idcliente like '" & Me.TextBox1.Text & "%'" Me.DataGrid1.DataSource = vista Me.DataGrid1.Update() Case Me.RadioButton2.Checked = True vista.Table = clase.datos.Tables("x") vista.RowFilter = "nombres like '" & Me.TextBox1.Text & "%'" Me.DataGrid1.DataSource = vista Me.DataGrid1.Update() Case Me.RadioButton3.Checked = True vista.Table = clase.datos.Tables("x") vista.RowFilter = "razonsocial like '" & Me.TextBox1.Text & "%'" Me.DataGrid1.DataSource = vista Me.DataGrid1.Update() End Select End Sub

Private Sub TextBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown If e.KeyCode = Keys.Enter Then estado = 1 matriz(c, 0) = DataGrid1.Item(c, 0) matriz(c, 1) = DataGrid1.Item(c, 1) matriz(c, 2) = DataGrid1.Item(c, 2) matriz(c, 3) = DataGrid1.Item(c, 3) matriz(c, 4) = DataGrid1.Item(c, 4) matriz(c, 5) = DataGrid1.Item(c, 5) matriz(c, 6) = DataGrid1.Item(c, 6) matriz(c, 7) = DataGrid1.Item(c, 7) matriz(c, 8) = DataGrid1.Item(c, 8) matriz(c, 9) = DataGrid1.Item(c, 9) matriz(c, 10) = DataGrid1.Item(c, 10) matriz(c, 11) = DataGrid1.Item(c, 11) matriz(c, 12) = DataGrid1.Item(c, 12) matriz(c, 13) = DataGrid1.Item(c, 13) matriz(c, 14) = DataGrid1.Item(c, 14) Me.Hide() End If End Sub Private Sub RadioButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadioButton1.Click Me.TextBox1.Clear() : Me.TextBox1.Focus() : Me.Height = 296 End Sub Private Sub RadioButton2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadioButton2.Click Me.TextBox1.Clear() : Me.TextBox1.Focus() : Me.Height = 296 End Sub Private Sub RadioButton3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadioButton3.Click Me.TextBox1.Clear() : Me.TextBox1.Focus() : Me.Height = 296 End Sub


47

1290129112921293129412951296129712981299130013011302130313041305130613071308

130913101311131213131314131513161317131813191320132113221323132413251326132713281329

13301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364

48

Ado .NET

Private Sub DataGrid1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.DoubleClick estadoproforma = 2 If tipoclientep = "Natural" Then codclientep = Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 0) nombresclientes = Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 4) + " " + _ Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 3) + " " + _ Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 2) Else nombresclientes = Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 1) codclientep = Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 0) End If Me.Close() End SubEnd Class


49

1365136613671368136913701371137213731374137513761377137813791380

1381

50

Sistema de Ventas Parte - Mantenimiento de Clientes - Proforma [Hervert Navarro Vela]

Documents

Transcript of Sistema de Ventas Parte - Mantenimiento de Clientes - Proforma [Hervert Navarro Vela]