modelos de sistemas

Examen de Practico de Base de Datos I

INSTITUTO EDUCACION SUPERIORSAN EDUARDOCOMPUTACION E INFORMATICA

CaratPROYECTOS DE CICLO DEL CURSO

TALLER DE SISTEMASASESOR:Ing. Manuel Ulloa FlorinTRUJILLO PER

2010

SISTEMA DE VENTA

DE Computo

AUTORES:

Flores Morillas Melissa

Olivera Torres Sebastin

Ruiz Alva Jonathan

GESTOR DE BASE DE DATOS: SQL 2005LENGUAJE DE PROGRAMACIN: Visual Basic. Net 2005ACCESO AL SISTEMA

Imports System.Data : Imports System.Data.SqlClient

Public Class FRMLOGIN

Public acum As Integer

Private Sub aceptar(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNACEPTAR.Click

aceptar()

End Sub

Private Sub aceptar()

Dim cadenaconexion As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\VENTAS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

Using con As New SqlConnection(cadenaconexion)

con.Open()

Dim consulta As String = "Select * from usuario where USUARIO=" & _

"@usuario and Password=@password"

Dim comando As New SqlCommand(consulta, con)

comando.Parameters.AddWithValue("@usuario", Me.TXTUSUARIO.Text.Trim)

comando.Parameters.AddWithValue("@password", Me.txtpassword.Text.Trim)

Dim dt As New DataTable : Dim da As New SqlDataAdapter(comando)

da.Fill(dt)

If dt.Rows.Count > 0 Then

MsgBox("USUARIO LOGEADO EXITOSAMENTE", MsgBoxStyle.Information, "INGRESO")

MDISISTEMA.Show()

Finalize()

Else

If MsgBox("USUARIO O PASSWORD INCORRECTA", MsgBoxStyle.Exclamation, "ERROR") = MsgBoxResult.Ok Then

acum = acum + 1

txtpassword.Text = ""

TXTUSUARIO.Text = ""

TXTUSUARIO.Focus()

TXTUSUARIO.Select()

TXTUSUARIO.SelectionStart = 0

TXTUSUARIO.SelectionLength = 20

If acum = 3 Then

MsgBox("AH EXECEDIDO EL LIMITE DE INTENTOS", MsgBoxStyle.Critical, "LO SENTIMOS")

End

End If

MsgBox("Te queda:" + Str(3 - acum) + "oportunidad(es)", 16, "Clave incorrecta")

End If

End If

End Using

End Sub

Private Sub BTNCANCELAR_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNCANCELAR.Click

If MessageBox.Show("Desea Cancelar la Aplicacion", "salir", MessageBoxButtons.OKCancel) = Windows.Forms.DialogResult.OK Then

End

End If

End Sub

Private Sub txtpassword_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtpassword.KeyPress

If Asc(e.KeyChar) = 13 Then BTNACEPTAR.Focus()

End Sub

Private Sub TXTUSUARIO_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTUSUARIO.KeyPress

If Asc(e.KeyChar) = 13 Then txtpassword.Focus()

End Sub

Private Sub BTNACEPTAR_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNACEPTAR.Enter

aceptar()

End Sub

End Class

Mantenedor Vendedor

mports System.Data.SqlClient

Imports Microsoft.SqlServer

Public Class frmvendedor

Dim conexion As SqlConnection

Dim cmd As SqlCommand

Dim orden As SqlDataAdapter

Dim vendedor As DataSet

Dim dr As DataRow

Dim reg As Integer

Dim registro As SqlDataReader

Private Sub limpiar()

TXTnombre.Text = ""

txtapellido.Text = ""

txtdireccion.Text = ""

txttelefono.Text = ""

txtdni.Text = ""

txtcorreo.Text = ""

txtcodigo.Text = "VD00" + Format(DTS.Tables("vendedor").Rows.Count + 1)

End Sub

Private Sub activar()

TXTnombre.Enabled = True

txtapellido.Enabled = True

txttelefono.Enabled = True

txtdireccion.Enabled = True

txtdni.Enabled = True

txtcorreo.Enabled = True

End Sub

Private Sub desplazamiento(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnprimero.Click, btnanterior.Click, btnsiguiente.Click, btnultimo.Click

If sender Is btnprimero Then

reg = 0

ElseIf sender Is btnanterior Then

reg -= 1

If reg < 0 Then reg = 0

ElseIf sender Is btnsiguiente Then

reg += 1

If reg > DTS.Tables("vendedor").Rows.Count - 1 Then

reg = DTS.Tables("vendedor").Rows.Count - 1

End If

ElseIf sender Is btnultimo Then


End If

dr = DTS.Tables("vendedor").Rows(reg)

txtcodigo.Text = dr("idvendedor")

TXTnombre.Text = dr("nombre")

txtapellido.Text = dr("apellido")

txttelefono.Text = dr("telefono")

txtdireccion.Text = dr("direccion")

txtdni.Text = dr("dni")

txtcorreo.Text = dr("correo")









lblreg.Text = "Registro: " & reg + 1 & " de " & DTS.Tables("vendedor").Rows.Count

If reg = DTS.Tables("vendedor").Rows.Count - 1 Then

MsgBox("Ultimo Registro")

End If

If reg = 0 Then

MsgBox("primer registro")

End If

desactivar()

btnguardar.Enabled = False

btncancelar.Enabled = False

btneditar.Enabled = True

btnactualizar.Visible = False

btnguardar.Visible = True

End Sub

Private Sub desactivar()

TXTnombre.Enabled = False

txtapellido.Enabled = False

txttelefono.Enabled = False

txtdireccion.Enabled = False

txtdni.Enabled = False

txtcorreo.Enabled = False

End Sub

Private Sub txtapellido_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtapellido.KeyPress

If Asc(e.KeyChar) = 13 Then txttelefono.Focus()

If Char.IsLetter(e.KeyChar) Then

e.Handled = False

ElseIf Char.IsControl(e.KeyChar) Then

e.Handled = False

ElseIf Char.IsSeparator(e.KeyChar) Then

e.Handled = False

Else

e.Handled = True

End If

End Sub

Private Sub txtapellido_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtapellido.KeyUp

Clipboard.Clear()

End Sub

Private Sub txtapellido_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txtapellido.MouseDown

Clipboard.Clear()

End Sub

Private Sub TXTnombre_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTnombre.KeyPress

If Asc(e.KeyChar) = 13 Then txtapellido.Focus()


e.Handled = False


e.Handled = False


e.Handled = False

Else

e.Handled = True

End If

End Sub

Private Sub txttelefono_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txttelefono.KeyPress

If Asc(e.KeyChar) = 13 Then txtdni.Focus()

If InStr(1, "0123456789,-" & Chr(8), e.KeyChar) = 0 Then

e.KeyChar = ""

End If

End Sub

Private Sub txtdni_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtdni.KeyPress

If Asc(e.KeyChar) = 13 Then txtdireccion.Focus()


e.KeyChar = ""

End If

End Sub

Private Sub btnnuevo_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnnuevo.Click

limpiar()

activar()

TXTnombre.Focus()


btncancelar.Enabled = True

btnguardar.Enabled = True

btneditar.Enabled = False

btnnuevo.Enabled = False

btnprimero.Enabled = False

btnanterior.Enabled = False

btnsiguiente.Enabled = False

btnultimo.Enabled = False


End Sub

Private Sub btnguardar_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnguardar.Click

guardar()

End Sub

Private Sub guardar()

If TXTnombre.Text = "" Then

MsgBox("Por Favor. Ingrese Un Nombre!", MsgBoxStyle.Information, "MENSAJE")

TXTnombre.Focus()

ElseIf txtapellido.Text = "" Then

MsgBox("Por Favor. Ingrese Un Apellido!", MsgBoxStyle.Information, "MENSAJE")

txtapellido.Focus()

ElseIf txtdni.TextLength 8 Then

MsgBox("El Nmero de DNI Debe Contener 8 Digitos!", MsgBoxStyle.Information, "MENSAJE")

txtdni.Focus()

Else

conexion = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\VENTAS.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")

Try

conexion.Open()

cmd = New SqlCommand("insert into vendedor(idvendedor,nombre,apellido,telefono,direccion,dni,correo)values('" & txtcodigo.Text & "','" & TXTnombre.Text & "','" & txtapellido.Text & "','" & txttelefono.Text & "','" & txtdireccion.Text & "','" & txtdni.Text & "','" & txtcorreo.Text & "')", conexion)

vendedor = New DataSet

cmd.ExecuteNonQuery()

Dim ELEMENTO As ListViewItem

ELEMENTO = lsvvendedor.Items.Add(txtcodigo.Text)

ELEMENTO.SubItems.Add(TXTnombre.Text)

ELEMENTO.SubItems.Add(txtapellido.Text)

ELEMENTO.SubItems.Add(txttelefono.Text)

ELEMENTO.SubItems.Add(txtdni.Text)

ELEMENTO.SubItems.Add(txtdireccion.Text)

ELEMENTO.SubItems.Add(txtcorreo.Text)

conexion.Dispose()

MsgBox("DATO INGRESADO..", MsgBoxStyle.Information, "INGRESAR VENDEDOR.")

Catch ex As Exception

MsgBox("Error al Ingresar Datos..", MsgBoxStyle.Critical, "Error")

End Try

DAP = New SqlClient.SqlDataAdapter("select * from vendedor", cn)

DTS = New DataSet

AbrirConexion()

DAP.Fill(DTS, "vendedor")

cn.Close()


txtcodigo.Text = dr("Idvendedor")







cargadatos()

limpiar()

TXTnombre.Focus()


End If

End Sub

Private Sub btnsalir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsalir.Click

If MessageBox.Show("DESEA SALIR DE LA APLICACION...?", "SALIR...", MessageBoxButtons.OKCancel) = Windows.Forms.DialogResult.OK Then

Close()

End If

End Sub

Private Sub frmvendedor_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


DTS = New DataSet

AbrirConexion()


cn.Close()

reg = 0



TXTnombre.Text = dr("Nombre")

txtapellido.Text = dr("Apellido")

txttelefono.Text = dr("Telefono")

txtdireccion.Text = dr("Direccion")

txtdni.Text = dr("DNI")


cargadatos()

'mostrar en el lsvcliente

DAP = New SqlDataAdapter("select * from vendedor", cn)

DTS = New DataSet

AbrirConexion()


DT = DTS.Tables("vendedor")

For Each dr In DT.Rows

lista = lsvvendedor.Items.Add(dr.Item("idvendedor"))

lista.SubItems.Add(dr.Item("nombre"))

lista.SubItems.Add(dr.Item("apellido"))

lista.SubItems.Add(dr.Item("telefono"))

lista.SubItems.Add(dr.Item("dni"))

lista.SubItems.Add(dr.Item("direccion"))

lista.SubItems.Add(dr.Item("correo"))

Next

btnprimero.Enabled = True

btnanterior.Enabled = True

btnsiguiente.Enabled = True

btnultimo.Enabled = True

cargadatos()

btnnuevo.Focus()


End Sub

Private Sub cargadatos()










End Sub

Private Sub btneditar_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btneditar.Click

activar()

TXTnombre.Focus()







btnguardar.Visible = False

btnactualizar.Visible = True


btnactualizar.Enabled = True

EliminarEspacios()

End Sub

Private Sub btncancelar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncancelar.Click


















desactivar()



btnnuevo.Enabled = True








btnnuevo.Focus()

EliminarEspacios()

End Sub

Private Sub btnactualizar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnactualizar.Click

If TXTnombre.Text = "" Then

MsgBox("Por Favor. Ingrese Un Nombre!", MsgBoxStyle.Information, "MENSAJE")

TXTnombre.Focus()

ElseIf txtapellido.Text = "" Then

MsgBox("Por Favor. Ingrese Un Apellido!", MsgBoxStyle.Information, "MENSAJE")

txtapellido.Focus()

ElseIf txtdni.TextLength 8 Then

MsgBox("El Nmero de DNI Debe Contener 8 Digitos!", MsgBoxStyle.Information, "MENSAJE")

txtdni.Focus()

Else

codigo = txtcodigo.Text

nombre = TXTnombre.Text

apellido = txtapellido.Text

telefono = txttelefono.Text

direccion = txtdireccion.Text

rucdni = txtdni.Text

correo = txtcorreo.Text()

sentencia = "UPDATE vendedor set Nombre='" & nombre & "'," & _

"Apellido='" & apellido & "', " & _

"Telefono='" & telefono & "', " & _

"Direccion='" & direccion & "', " & _

"DNI='" & rucdni & "', " & _

"CORREO='" & correo & "'" & _

"WHERE idVENDEDOR='" & codigo & "'"

AbrirConexion()

Ejecutar(sentencia)

cn.Close()

MsgBox("Datos Modificados")

If lsvvendedor.SelectedItems.Count 0 Then

lsvvendedor.SelectedItems(0).SubItems(0).Text = txtcodigo.Text

lsvvendedor.SelectedItems(0).SubItems(1).Text = TXTnombre.Text

lsvvendedor.SelectedItems(0).SubItems(2).Text = txtapellido.Text

lsvvendedor.SelectedItems(0).SubItems(3).Text = txttelefono.Text

lsvvendedor.SelectedItems(0).SubItems(4).Text = txtdni.Text

lsvvendedor.SelectedItems(0).SubItems(5).Text = txtdireccion.Text

lsvvendedor.SelectedItems(0).SubItems(6).Text = txtcorreo.Text

End If


DTS = New DataSet

AbrirConexion()


cn.Close()









desactivar()









btnnuevo.Focus()

EliminarEspacios()

End If

End Sub

Private Sub EliminarEspacios()

TXTNOMBRE.Text = RTrim(TXTNOMBRE.Text)

TXTAPELLIDO.Text = RTrim(TXTAPELLIDO.Text)

TXTTELEFONO.Text = RTrim(TXTTELEFONO.Text)

TXTDIRECCION.Text = RTrim(TXTDIRECCION.Text)

txtdni.Text = RTrim(txtdni.Text)

txtcorreo.Text = RTrim(txtcorreo.Text)

End Sub

Private Sub txtdireccion_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtdireccion.KeyPress

If Asc(e.KeyChar) = 13 Then txtcorreo.Focus()

End Sub

Private Sub txtcorreo_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtcorreo.KeyPress

If Asc(e.KeyChar) = 13 Then btnguardar.Focus()

End Sub

Private Sub btnguardar_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnguardar.Enter

guardar()

End Sub

Private Sub BTNNUEVO_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnnuevo.MouseLeave

btnnuevo.BackColor = Color.Silver

End Sub

Private Sub BTNNUEVO_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btnnuevo.MouseMove

BTNNUEVO.BackColor = Color.Red

End Sub

Private Sub BTNEDITAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btneditar.MouseLeave

btneditar.BackColor = Color.Silver

End Sub

Private Sub BTNEDITAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btneditar.MouseMove

BTNEDITAR.BackColor = Color.Red

End Sub

Private Sub BTNGUARDAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnguardar.MouseLeave

btnguardar.BackColor = Color.Silver

End Sub

Private Sub BTNGUARDAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btnguardar.MouseMove

BTNGUARDAR.BackColor = Color.Red

End Sub

Private Sub BTNCANCELAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btncancelar.MouseLeave

btncancelar.BackColor = Color.Silver

End Sub

Private Sub BTNCANCELAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btncancelar.MouseMove

BTNCANCELAR.BackColor = Color.Red

End Sub

Private Sub btnsalir_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsalir.MouseLeave

btnsalir.BackColor = Color.Silver

End Sub

Private Sub btnsalir_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btnsalir.MouseMove

btnsalir.BackColor = Color.Red

End Sub

Private Sub TXTnombre_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TXTnombre.KeyUp

Clipboard.Clear()

End Sub

Private Sub TXTnombre_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles TXTnombre.MouseDown

Clipboard.Clear()

End Sub

Function MAYUSCULA(ByVal V) As Boolean

If (V >= 65 And V < 90) Then

MAYUSCULA = True

Else

MAYUSCULA = False

End If

End Function

Function MINUSCULA(ByVal V) As Boolean

If (V >= 97 And V < 122) Then

MINUSCULA = True

Else

MINUSCULA = False

End If

End Function

Private Sub lsvvendedor_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lsvvendedor.SelectedIndexChanged

If lsvvendedor.SelectedIndices.Count = 0 Then Exit Sub

txtcodigo.Text = lsvvendedor.SelectedItems(0).SubItems(0).Text

TXTnombre.Text = lsvvendedor.SelectedItems(0).SubItems(1).Text

txtapellido.Text = lsvvendedor.SelectedItems(0).SubItems(2).Text

txttelefono.Text = lsvvendedor.SelectedItems(0).SubItems(3).Text

txtdni.Text = lsvvendedor.SelectedItems(0).SubItems(4).Text

txtdireccion.Text = lsvvendedor.SelectedItems(0).SubItems(5).Text

txtcorreo.Text = lsvvendedor.SelectedItems(0).SubItems(6).Text

btneditar.Enabled = True

desactivar()

btnguardar.Visible = False



btnactualizar.Enabled = False


End Sub

Private Sub txttelefono_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txttelefono.KeyUp

Clipboard.Clear()

End Sub

Private Sub txttelefono_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txttelefono.MouseDown

Clipboard.Clear()

End Sub

Private Sub txtdni_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtdni.KeyUp

Clipboard.Clear()

End Sub

Private Sub txtdni_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txtdni.MouseDown

Clipboard.Clear()

End Sub

Private Sub txtdireccion_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtdireccion.KeyUp

Clipboard.Clear()

End Sub

Private Sub txtdireccion_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txtdireccion.MouseDown

Clipboard.Clear()

End Sub

Private Sub txtcorreo_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtcorreo.KeyUp

Clipboard.Clear()

End Sub

Private Sub txtcorreo_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txtcorreo.MouseDown

Clipboard.Clear()

End Sub

End Class

Mantenedor Cliente

Imports System.Data.SqlClient


Public Class Frmcliente




Dim cliente As DataSet

Dim dr As DataRow

Dim reg As Integer


Private Sub NUEVO(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNNUEVO.Click

NUEVO()

End Sub

Private Sub BTNEDITAR_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNEDITAR.Click

editar()

End Sub

Private Sub validanatural()

If TXTNOMBRE.Text = "" Then

MessageBox.Show("Igrese Un Nombre", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTNOMBRE.Focus()

ElseIf TXTAPELLIDO.Text = "" Then

MessageBox.Show("Ingrese un Apellido", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTAPELLIDO.Focus()

ElseIf TXTRUCDNI.Text = "" Then

MessageBox.Show("Ingrese un nmero de DNI", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

ElseIf TXTRUCDNI.TextLength 8 Then

MessageBox.Show("El nmero de DNI debe contener 8 digitos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

Else

guardar()

End If

End Sub

Private Sub validajuridico()



TXTNOMBRE.Focus()


MessageBox.Show(" Ingrese un Apellido", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTAPELLIDO.Focus()


MessageBox.Show(" Ingrese un nmero de RUC", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()


MessageBox.Show("El nmero de RUC debe contener 11 digitos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

ElseIf TXTRAZONSOCIAL.Text = "" Then

MessageBox.Show("Ingrese una Razon Social", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRAZONSOCIAL.Focus()

Else

guardar()

End If

End Sub

Private Sub guardarregistro(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNGUARDAR.Click

If rdbnatural.Checked = True Then

validanatural()

ElseIf rdbjuridico.Checked = True Then

validajuridico()

End If

End Sub

Private Sub guardar()


Try

conexion.Open()

cmd = New SqlCommand("insert into cliente(idcliente,nombre,apellido,telefono,direccion,rucdni,razonsocial,idtipocliente)values('" & TXTCODIGO.Text & "','" & TXTNOMBRE.Text & "','" & TXTAPELLIDO.Text & "','" & TXTTELEFONO.Text & "','" & TXTDIRECCION.Text & "','" & TXTRUCDNI.Text & "','" & TXTRAZONSOCIAL.Text & "','" & TXTTIPO.Text & "')", conexion)

cliente = New DataSet



ELEMENTO = lsvcliente.Items.Add(TXTCODIGO.Text)

ELEMENTO.SubItems.Add(TXTNOMBRE.Text)

ELEMENTO.SubItems.Add(TXTAPELLIDO.Text)

ELEMENTO.SubItems.Add(TXTTELEFONO.Text)

ELEMENTO.SubItems.Add(TXTRUCDNI.Text)

ELEMENTO.SubItems.Add(TXTDIRECCION.Text)

ELEMENTO.SubItems.Add(TXTRAZONSOCIAL.Text)

ELEMENTO.SubItems.Add(TXTTIPO.Text)

EliminarEspacios()

conexion.Dispose()

MsgBox("DATO INGRESADO..", MsgBoxStyle.Information, "INGRESAR CLIENTE.")

Catch ex As Exception

MsgBox("Error al Ingresar Datos..", MsgBoxStyle.Critical, "Error")

End Try

DAP = New SqlClient.SqlDataAdapter("select * from cliente", cn)

DTS = New DataSet

AbrirConexion()

DAP.Fill(DTS, "cliente")

cn.Close()

dr = DTS.Tables("cliente").Rows(reg)

TXTCODIGO.Text = dr("Idcliente")

TXTNOMBRE.Text = dr("nombre")

TXTAPELLIDO.Text = dr("apellido")

TXTTELEFONO.Text = dr("telefono")

TXTRUCDNI.Text = dr("rucdni")

TXTDIRECCION.Text = dr("direccion")

TXTRAZONSOCIAL.Text = dr("razonsocial")

TXTTIPO.Text = dr("idtipocliente")

cargadatos()

limpiar()

TXTNOMBRE.Focus()

BTNNUEVO.Enabled = False

rdbnatural.Enabled = True

rdbjuridico.Enabled = True

rdbnatural.Checked = True

End Sub

Private Sub SALIR(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsalir.Click

SALIR()

End Sub

Private Sub cancelar(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNCANCELAR.Click

reg = DTS.Tables("cliente").Rows.Count - 1

TXTCODIGO.Text = dr("idcliente")







TXTTIPO.Text = dr("IDtipocliente")

cargadatos()

desactivar()

BTNGUARDAR.Enabled = False

BTNCANCELAR.Enabled = False

BTNNUEVO.Enabled = True






BTNGUARDAR.Visible = True

BTNNUEVO.Focus()

rdbnatural.Enabled = False

rdbjuridico.Enabled = False

TXTRAZONSOCIAL.Enabled = False

End Sub

Private Sub EliminarEspacios()

TXTNOMBRE.Text = RTrim(TXTNOMBRE.Text)

TXTAPELLIDO.Text = RTrim(TXTAPELLIDO.Text)

TXTTELEFONO.Text = RTrim(TXTTELEFONO.Text)

TXTDIRECCION.Text = RTrim(TXTDIRECCION.Text)

TXTRUCDNI.Text = RTrim(TXTRUCDNI.Text)

TXTTIPO.Text = RTrim(TXTTIPO.Text)

TXTRAZONSOCIAL.Text = RTrim(TXTRAZONSOCIAL.Text)

End Sub

Private Sub Frmcliente_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

DAP = New SqlClient.SqlDataAdapter("select * from CLIENTE", cn)

DTS = New DataSet

AbrirConexion()

DAP.Fill(DTS, "CLIENTE")

cn.Close()

reg = 0

dr = DTS.Tables("CLIENTE").Rows(reg)

TXTCODIGO.Text = dr("IdCliente")

TXTNOMBRE.Text = dr("Nombre")

TXTAPELLIDO.Text = dr("Apellido")

TXTTELEFONO.Text = dr("Telefono")

TXTDIRECCION.Text = dr("Direccion")




cargadatos()



DAP = New SqlDataAdapter("select * from cliente", cn)

DTS = New DataSet

AbrirConexion()


DT = DTS.Tables("cliente")


lista = lsvcliente.Items.Add(dr.Item("idcliente"))



lista.SubItems.Add(dr.Item("telefono"))

lista.SubItems.Add(dr.Item("rucdni"))


lista.SubItems.Add(dr.Item("razonsocial"))

lista.SubItems.Add(dr.Item("idtipocliente"))

Next





cargadatos()


BTNNUEVO.Focus()

lblDNI.Text = "RUC"

End Sub

Private Sub DESPLAZAMIENTO(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnprimero.Click, btnultimo.Click, btnanterior.Click, btnsiguiente.Click

If sender Is btnprimero Then

reg = 0

ElseIf sender Is btnanterior Then

reg -= 1

If reg < 0 Then reg = 0

ElseIf sender Is btnsiguiente Then

reg += 1

If reg > DTS.Tables("cliente").Rows.Count - 1 Then


End If

ElseIf sender Is btnultimo Then


End If










cargadatos()

If reg = DTS.Tables("cliente").Rows.Count - 1 Then

MsgBox("Ultimo Registro")

End If

If reg = 0 Then

MsgBox("primer registro")

End If

desactivar()



BTNEDITAR.Enabled = True



End Sub

Private Sub mostrar(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnmostrar.Click

If btnmostrar.Enabled = True Then

lsvcliente.Visible = True

TXTNOMBRE.Focus()

End If

btnmostrar.Visible = False

End Sub


TXTNOMBRE.Text = ""

TXTAPELLIDO.Text = ""

TXTTELEFONO.Text = ""

TXTDIRECCION.Text = ""

TXTRUCDNI.Text = ""

TXTTIPO.Text = ""

TXTRAZONSOCIAL.Text = ""

rdbnatural.Checked = False

rdbjuridico.Checked = False

TXTCODIGO.Text = "CL00" + Format(DTS.Tables("cliente").Rows.Count + 1)

End Sub

Private Sub activar()

TXTNOMBRE.Enabled = True

TXTAPELLIDO.Enabled = True

TXTDIRECCION.Enabled = True

TXTTELEFONO.Enabled = True

TXTRUCDNI.Enabled = True

End Sub

Private Sub TXTDNI_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTRUCDNI.KeyPress

If Asc(e.KeyChar) = 13 Then TXTRAZONSOCIAL.Focus()


e.KeyChar = ""

End If

lblcliente.ForeColor = Color.BlueViolet

End Sub

Private Sub TXTDIRECCION_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTDIRECCION.KeyPress

If Asc(e.KeyChar) = 13 Then TXTRUCDNI.Focus()

lblcliente.ForeColor = Color.Pink

End Sub

Private Sub cargadatos()










lblreg.Text = "Registro: " & reg + 1 & " de " & DTS.Tables("cliente").Rows.Count

End Sub

Private Sub actuanatural()



TXTNOMBRE.Focus()



TXTAPELLIDO.Focus()


MessageBox.Show("Ingrese un nmero de DNI", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()


MessageBox.Show("El nmero de DNI debe contener 8 digitos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

Else

actualizar()

End If

End Sub

Private Sub actuajuridico()



TXTNOMBRE.Focus()


MessageBox.Show(" Ingrese un Apellido", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTAPELLIDO.Focus()


MessageBox.Show(" Ingrese un nmero de RUC", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()


MessageBox.Show("El nmero de RUC debe contener 11 digitos", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

ElseIf TXTRAZONSOCIAL.Text = "" Then

MessageBox.Show("Ingrese una Razon Social", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRAZONSOCIAL.Focus()

Else

actualizar()

End If

End Sub

Private Sub Actulaizar(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnactualizar.Click



TXTNOMBRE.Focus()



TXTAPELLIDO.Focus()


MessageBox.Show("Ingrese un nmero de RUC DNI", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)

TXTRUCDNI.Focus()

Else

codigo = TXTCODIGO.Text

nombre = TXTNOMBRE.Text

apellido = TXTAPELLIDO.Text

telefono = TXTTELEFONO.Text

direccion = TXTDIRECCION.Text

razonsocial = TXTRAZONSOCIAL.Text

rucdni = TXTRUCDNI.Text

idtipocliente = TXTTIPO.Text()

sentencia = "UPDATE CLIENTE set Nombre='" & nombre & "'," & _

"Apellido='" & apellido & "', " & _

"Telefono='" & telefono & "', " & _

"Direccion='" & direccion & "', " & _

"rucdni='" & rucdni & "', " & _

"razonsocial='" & razonsocial & "', " & _

"idtipocliente='" & idtipocliente & "'" & _

"WHERE idcliente='" & codigo & "'"

AbrirConexion()

Ejecutar(sentencia)

cn.Close()

If lsvcliente.SelectedItems.Count 0 Then

lsvcliente.SelectedItems(0).SubItems(1).Text = TXTNOMBRE.Text

lsvcliente.SelectedItems(0).SubItems(2).Text = TXTAPELLIDO.Text

lsvcliente.SelectedItems(0).SubItems(3).Text = TXTTELEFONO.Text

lsvcliente.SelectedItems(0).SubItems(4).Text = TXTRUCDNI.Text

lsvcliente.SelectedItems(0).SubItems(5).Text = TXTDIRECCION.Text

lsvcliente.SelectedItems(0).SubItems(7).Text = TXTTIPO.Text

lsvcliente.SelectedItems(0).SubItems(6).Text = TXTRAZONSOCIAL.Text

End If

MsgBox("Datos Modificados")

desactivar()

DAP = New SqlClient.SqlDataAdapter("select * from cliente", cn)

DTS = New DataSet

AbrirConexion()


cn.Close()


TXTCODIGO.Text = dr("Idcliente")








EliminarEspacios()










rdbnatural.Enabled = False

rdbjuridico.Enabled = False


End If

End Sub

Private Sub nuevo()

limpiar()

activar()

TXTNOMBRE.Focus()


BTNCANCELAR.Enabled = True

BTNGUARDAR.Enabled = True

BTNEDITAR.Enabled = False









rdbnatural.Checked = True

End Sub

Private Sub editar()

activar()

TXTNOMBRE.Focus()






BTNGUARDAR.Visible = False


btnactualizar.Enabled = True



EliminarEspacios()

BTNEDITAR.Enabled = False

End Sub

Private Sub desactivar()

TXTNOMBRE.Enabled = False

TXTAPELLIDO.Enabled = False

TXTDIRECCION.Enabled = False

TXTTELEFONO.Enabled = False

TXTRUCDNI.Enabled = False

rdbnatural.Checked = False

rdbjuridico.Checked = False

End Sub

Private Sub salir()


Close()

End If

End Sub

Private Sub TXTAPELLIDO_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTAPELLIDO.KeyPress

If Asc(e.KeyChar) = 13 Then TXTTELEFONO.Focus()

lblcliente.ForeColor = Color.Chocolate


e.Handled = False


e.Handled = False


e.Handled = False

Else

e.Handled = True

End If

End Sub

Private Sub TXTAPELLIDO_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TXTAPELLIDO.KeyUp

Clipboard.Clear()

End Sub

Private Sub TXTAPELLIDO_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles TXTAPELLIDO.MouseDown

Clipboard.Clear()

End Sub

Private Sub TXTNOMBRE_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTNOMBRE.KeyPress

If Asc(e.KeyChar) = 13 Then TXTAPELLIDO.Focus()

lblcliente.ForeColor = Color.Khaki


e.Handled = False


e.Handled = False


e.Handled = False

Else

e.Handled = True

End If

End Sub

Private Sub TXTNOMBRE_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TXTNOMBRE.KeyUp

Clipboard.Clear()

End Sub

Private Sub TXTNOMBRE_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles TXTNOMBRE.MouseDown

Clipboard.Clear()

End Sub

Private Sub TXTTELEFONO_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TXTTELEFONO.KeyPress

If Asc(e.KeyChar) = 13 Then TXTDIRECCION.Focus()


e.KeyChar = ""

End If

lblcliente.ForeColor = Color.MediumPurple

End Sub

Private Sub BTNNUEVO_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNNUEVO.MouseLeave

BTNNUEVO.BackColor = Color.Silver

End Sub

Private Sub BTNNUEVO_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles BTNNUEVO.MouseMove

BTNNUEVO.BackColor = Color.Red

End Sub

Private Sub BTNEDITAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNEDITAR.MouseLeave

BTNEDITAR.BackColor = Color.Silver

End Sub

Private Sub BTNEDITAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles BTNEDITAR.MouseMove

BTNEDITAR.BackColor = Color.Red

End Sub

Private Sub BTNGUARDAR_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNGUARDAR.Enter

guardar()

End Sub

Private Sub BTNGUARDAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNGUARDAR.MouseLeave

BTNGUARDAR.BackColor = Color.Silver

End Sub

Private Sub BTNGUARDAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles BTNGUARDAR.MouseMove

BTNGUARDAR.BackColor = Color.Red

End Sub

Private Sub BTNCANCELAR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNCANCELAR.MouseLeave

BTNCANCELAR.BackColor = Color.Silver

End Sub

Private Sub BTNCANCELAR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles BTNCANCELAR.MouseMove

BTNCANCELAR.BackColor = Color.Red

End Sub

Private Sub btnsalir_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsalir.MouseLeave

btnsalir.BackColor = Color.Silver

End Sub

Private Sub btnsalir_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles btnsalir.MouseMove

btnsalir.BackColor = Color.Red

End Sub

Private Sub lsvcliente_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lsvcliente.SelectedIndexChanged

If lsvcliente.SelectedIndices.Count = 0 Then Exit Sub

TXTCODIGO.Text = lsvcliente.SelectedItems(0).SubItems(0).Text

TXTNOMBRE.Text = lsvcliente.SelectedItems(0).SubItems(1).Text

TXTAPELLIDO.Text = lsvcliente.SelectedItems(0).SubItems(2).Text

TXTTELEFONO.Text = lsvcliente.SelectedItems(0).SubItems(3).Text

TXTRUCDNI.Text = lsvcliente.SelectedItems(0).SubItems(4).Text

TXTDIRECCION.Text = lsvcliente.SelectedItems(0).SubItems(5).Text

TXTTIPO.Text = lsvcliente.SelectedItems(0).SubItems(7).Text

TXTRAZONSOCIAL.Text = lsvcliente.SelectedItems(0).SubItems(6).Text

BTNEDITAR.Enabled = True

desactivar()

BTNGUARDAR.Visible = False



btnactualizar.Enabled = False


End Sub

Private Sub TXTTELEFONO_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TXTTELEFONO.KeyUp

Clipboard.Clear()

End Sub

Private Sub TXTTELEFONO_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles TXTTELEFONO.MouseDown

Clipboard.Clear()

End Sub

Private Sub TXTDNI_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TXTRUCDNI.KeyUp

Clipboard.Clear()

End Sub

Private Sub TXTDNI_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles TXTRUCDNI.MouseDown

Clipboard.Clear()

End Sub

Private Sub CMBTIPOCLIENTE_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs)

Clipboard.Clear()

End Sub

Private Sub CMBTIPOCLIENTE_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs)

Clipboard.Clear()

End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles rdbnatural.CheckedChanged

If Control.CheckForIllegalCrossThreadCalls Then


lblDNI.Text = "DNI"

TXTTIPO.Text = "TCL001"

TXTRUCDNI.MaxLength = 8

End If

End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles rdbjuridico.CheckedChanged

If Control.CheckForIllegalCrossThreadCalls Then

TXTRAZONSOCIAL.Enabled = True

lblDNI.Text = "R.U.C."

TXTTIPO.Text = "TCL002"

TXTRUCDNI.MaxLength = 11

TXTRAZONSOCIAL.Enabled = True

TXTRUCDNI.Focus()

End If

End Sub End Class

Movimiento de Factura



Public Class FACTURA

Dim i As Integer

Dim NF As Integer

Dim LDetalle(7, 5) As String

Dim ncod As String




Dim vendedor As DataSet

Dim dr As DataRow

Dim reg As Integer


Dim documento, DETALLEDOCUMENTO As DataSet

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

NF = 0

nff.Text = NF

AbrirConexion()

cn.Close()

DTS = New DataSet


AbrirConexion()




lista = lsvcliente.Items.Add(dr.Item("idcliente"))





lista.SubItems.Add(dr.Item("RUCDNI"))

Next

DAP = New SqlDataAdapter("select * from producto", cn)

DAP.Fill(DTS, "producto")

DT = DTS.Tables("producto")


lista = lsvproducto.Items.Add(dr.Item("idproducto"))


lista.SubItems.Add(dr.Item("precio"))

lista.SubItems.Add(dr.Item("stockmax"))

Next

DAP = New SqlDataAdapter("select * from vendedor", cn)


DT = DTS.Tables("vendedor")


lista = lsvvendedor.Items.Add(dr.Item("idvendedor"))



Next

DAP = New SqlDataAdapter("select * from documento", cn)

DAP.Fill(DTS, "documento")

DT = DTS.Tables("documento")

txtnumero.Text = "0001"

If DT.Rows.Count < 1 Then

txtserie.Text = "0001"

Else

txtnumero.Text = "000" + Format(DTS.Tables("documento").Rows.Count + 1)

End If

txtcodigo.Text = txtnumero.Text

txtserie.Text = "0001"

End Sub

Private Sub lsvcliente_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lsvcliente.SelectedIndexChanged

If lsvcliente.SelectedIndices.Count = 0 Then Exit Sub

txtcodigoc.Text = lsvcliente.SelectedItems(0).SubItems(0).Text

txtnombre.Text = lsvcliente.SelectedItems(0).SubItems(1).Text

txtapellidoc.Text = lsvcliente.SelectedItems(0).SubItems(4).Text

txtdireccion.Text = lsvcliente.SelectedItems(0).SubItems(2).Text

TXTRUC.Text = lsvcliente.SelectedItems(0).SubItems(5).Text

btnagregar.Enabled = True

End Sub

Private Sub lsvvendedor_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lsvvendedor.SelectedIndexChanged

If lsvvendedor.SelectedIndices.Count = 0 Then Exit Sub

txtcodigov.Text = lsvvendedor.SelectedItems(0).SubItems(0).Text

txtnombrev.Text = lsvvendedor.SelectedItems(0).SubItems(1).Text

txtapellido.Text = lsvvendedor.SelectedItems(0).SubItems(2).Text

End Sub

Private Sub lsvproducto_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lsvproducto.SelectedIndexChanged

If lsvproducto.SelectedIndices.Count = 0 Then Exit Sub

txtcodigop.Text = lsvproducto.SelectedItems(0).SubItems(0).Text

txtdescripcion.Text = lsvproducto.SelectedItems(0).SubItems(1).Text

txtprecio.Text = lsvproducto.SelectedItems(0).SubItems(2).Text

txtstockmax.Text = lsvproducto.SelectedItems(0).SubItems(3).Text

End Sub

Private Sub btnagregar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnagregar.Click

Dim cant As Integer

Dim estock As Integer

estock = Val(txtstockmax.Text)

cant = Val(txtcantidad.Text)

If txtcodigoc.Text = "" Then

MsgBox("Falta seleccionar Los Datos del Cliente", MsgBoxStyle.Critical, "Mensaje")

lsvcliente.Focus()

ElseIf txtnombrev.Text = "" Then

MsgBox("Falta seleccionar Los Datos del vendedor", MsgBoxStyle.Critical, "Mensaje")

lsvvendedor.Focus()

ElseIf txtcantidad.Text = "" Then

txtcantidad.Focus()

MsgBox("Falta Ingresar la Cantidad", MsgBoxStyle.Critical, "Mensaje")

ElseIf txtcodigop.Text = "" Then

lsvproducto.Focus()

MsgBox("selecsione un producto", MsgBoxStyle.Critical, "Mensaje")

ElseIf cant > estock Then

MsgBox("Error, el stock maximo es : " & txtstockmax.Text)

txtcantidad.Text = ""

txtcantidad.Focus()

Else

Dim total As Double

Dim Cantidad As Double

Dim Precio As Double

Precio = Val(txtprecio.Text)

Cantidad = Val(txtcantidad.Text)

ncod = txtcodigop.Text

If NF < 1 Then

Else

For i = 1 To NF

'MsgBox(i)

If LDetalle(2, i) = ncod Then

MsgBox("Dato ya Ingresado", MsgBoxStyle.Critical, "Error de Grabado")

Exit Sub

End If

Next

End If

NF = NF + 1

nff.Text = NF

LDetalle(1, NF) = NF

LDetalle(2, NF) = ncod

LDetalle(3, NF) = Cantidad

LDetalle(4, NF) = txtdescripcion.Text

LDetalle(5, NF) = Format(txtprecio.Text, "currency")

LDetalle(6, NF) = Format(txtmonto.Text, "currency")

LDetalle(7, NF) = Val(txtstockmax.Text) - LDetalle(3, NF)

txtmonto.Text = Cantidad * Precio


ELEMENTO = lsvboleta.Items.Add(ncod)

ELEMENTO.SubItems.Add(txtcantidad.Text)

ELEMENTO.SubItems.Add(txtdescripcion.Text)

ELEMENTO.SubItems.Add(Format(txtprecio.Text, "currency"))

ELEMENTO.SubItems.Add(Format(txtmonto.Text, "currency"))

ELEMENTO.SubItems.Add(Format(total, "currency"))

limpiarproducto()

End If

End Sub

Private Sub limpiarproducto()

txtcodigop.Text = ""

txtprecio.Text = ""

txtcantidad.Text = ""

txtdescripcion.Text = ""

btntotalizar.Enabled = True

btnquitar.Enabled = True

End Sub

Private Sub btnquitar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnquitar.Click

For i As Integer = lsvboleta.SelectedItems.Count - 1 To 0 Step -1

lsvboleta.SelectedItems(i).Remove()

Next

txttotal.Text = ""

End Sub

Private Sub btntotalizar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btntotalizar.Click

Dim sumas As Integer = 0

Dim suma As Double = 0

Dim x

Dim i

For i = 0 To lsvboleta.Items.Count - 1

suma = suma + lsvboleta.Items(i).SubItems(4).text

Next

For x = 0 To lsvboleta.Items.Count - 1

sumas = sumas + lsvboleta.Items(x).SubItems(1).Text

Next

txtcantidadb.Text = sumas

txttotal.Text = suma

txttotal.Text = Format(txttotal.Text, "currency")

txtcantidadb.Text = txtcantidadb.Text

txtigv.Text = "S/." + Format(txttotal.Text * 0.19)

LBLSUBTOTAL.Text = "S/." + Format(suma - txtigv.Text)

btntotalizar.Enabled = False


btnimprimir.Enabled = True

btnguardar.Enabled = True

btncancelar.Enabled = True

End Sub

Private Sub btnguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnguardar.Click

Dim z, q, s As Integer

s = Val(txtstockmax.Text)

q = Val(txtcantidadb.Text)

z = Val(txtnumero.Text)


conexion.Open()

cmd = New SqlCommand("insert into documento(iddocumento,numero,serie,idCLIEnTE,idvendedor,idtipodocum)values('" & txtcodigo.Text & "','" & txtnumero.Text & "','" & txtserie.Text & "','" & txtcodigoc.Text & "','" & txtcodigov.Text & "','" & TXTCODIGOTD.Text & "')", conexion)


cmd.Dispose()

'MsgBox("doc")

For i = 1 To NF

'MsgBox(i)

cmd = New SqlCommand("insert into DETALLEdocumento(cantidad,iddocumento,idproducto)values('" & LDetalle(3, i) & "','" & txtcodigo.Text & "','" & LDetalle(2, i) & "')", conexion)


Next

cmd.Dispose()

MsgBox("DATO INGRESADO..", MsgBoxStyle.Information, "INGRESAR documento.")

For i = 1 To NF

'MsgBox(i)

cmd = New SqlCommand("UPDATE producto set stockmax='" & LDetalle(7, i) & "' WHERE idproducto='" & LDetalle(2, i) & "'", conexion)


cmd.Dispose()

Next

'MsgBox("")

cn.Close()

txtnumero.Text = "000" + Format(z + 1)

txtcodigo.Text = txtnumero.Text

txtstockmax.Text = s - q

limpiar()

End Sub

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click


Close()

End If

End Sub


txtcodigoc.Text = ""

txtnombre.Text = ""

txtapellidoc.Text = ""

txtdireccion.Text = ""

txttotal.Text = ""

txtcantidadb.Text = ""

txtmonto.Text = ""

TXTRUC.Text = ""

txtigv.Text = ""

LBLSUBTOTAL.Text = ""

lsvboleta.Items.Clear()


btnquitar.Enabled = False

btnimprimir.Enabled = False


lsvcliente.Focus()

End Sub

Private Sub btncancelar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncancelar.Click

btnimprimir.Enabled = False

btntotalizar.Enabled = True


End Sub

Private Sub btnimprimir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnimprimir.Click

PTDimprimir.Document = prtdocumento

PTDimprimir.ShowDialog()

If PTDimprimir.ShowDialog = Windows.Forms.DialogResult.OK Then

prtdocumento.Print()

End If

End Sub

End Class



Public Class reportecliente


Private Sub reportecliente_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load



DTS = New DataSet

AbrirConexion()



For Each DR In DT.Rows

lista = lsvcliente.Items.Add(DR.Item("idcliente"))

lista.SubItems.Add(DR.Item("nombre"))

lista.SubItems.Add(DR.Item("apellido"))

lista.SubItems.Add(DR.Item("telefono"))

lista.SubItems.Add(DR.Item("rucdni"))

lista.SubItems.Add(DR.Item("direccion"))

lista.SubItems.Add(DR.Item("idtipocliente"))

Next

BTNCOLOR.Focus()

End Sub

Private Sub Btnsalir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btnsalir.Click


Close()

End If

End Sub

Private Sub color(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNCOLOR.Click

If cldcolor.ShowDialog() = Windows.Forms.DialogResult.OK Then

lsvcliente.ForeColor = cldcolor.Color

End If

End Sub


If fntfuente.ShowDialog() = Windows.Forms.DialogResult.OK Then

lsvcliente.Font = fntfuente.Font

End If

End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)

sdfgrabar.Filter() = "Documento(*.RTF)|*.rtf"

If sdfgrabar.ShowDialog = Windows.Forms.DialogResult.OK Then

RTBEDITOR.SaveFile(sdfgrabar.FileName)

End If

End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)

ppdvista.Document = prtdocumento

ppdvista.ShowDialog()

End Sub

Private Sub prtdocumento_PrintPage(ByVal sender As System.Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) Handles prtdocumento.PrintPage

Dim letra As New Font("comic sans Ms", 30)

e.Graphics.MeasureString(RTBEDITOR.Text, RTBEDITOR.Font, New SizeF(650, 900), _

New StringFormat(StringFormatFlags.LineLimit), Len(RTBEDITOR.Text), 1)

e.Graphics.DrawString(RTBEDITOR.Text, Font, Brushes.Black, 50, 50)

End Sub


psdconfigurar.Document = prtdocumento

psdconfigurar.PageSettings = prtdocumento.DefaultPageSettings

'si el usuaruo pulsa aceptar

If psdconfigurar.ShowDialog = Windows.Forms.DialogResult.OK Then

'configurar las paginas que se van imprimir

prtdocumento.DefaultPageSettings = psdconfigurar.PageSettings

End If

End Sub


PTDimprimir.Document = prtdocumento

PTDimprimir.ShowDialog()

If PTDimprimir.ShowDialog = Windows.Forms.DialogResult.OK Then

prtdocumento.Print()

End If

End Sub

Private Sub BTNCOLOR_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNCOLOR.MouseLeave

BTNCOLOR.BackColor = Drawing.Color.Gainsboro

End Sub

Private Sub BTNCOLOR_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles BTNCOLOR.MouseMove

BTNCOLOR.BackColor = Drawing.Color.Red

End Sub

Private Sub Button1_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.MouseLeave

Button1.BackColor = Drawing.Color.Gainsboro

End Sub

Private Sub Button1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.MouseMove

Button1.BackColor = Drawing.Color.Red

End Sub



End Sub



End Sub



End Sub



End Sub

Private Sub Btnsalir_MouseLeave(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btnsalir.MouseLeave

Btnsalir.BackColor = Drawing.Color.Gainsboro

End Sub

Private Sub Btnsalir_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Btnsalir.MouseMove

Btnsalir.BackColor = Drawing.Color.Red

End Sub

End Class


Public Class ConsultaCliente

Dim reg As Integer

Dim dtv As New DataView

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btnbuscar.Click

BUSCAR()

End Sub

Private Sub BUSCAR()

If rdbDNI.Checked = True Then

dtv.Table = DTS.Tables("cliente")

dtv.RowFilter = "rucdni='" & txtcriterio.Text & "'"

dgvcliente.DataSource = dtv

If txtcriterio.TextLength 8 Then

MsgBox("El numero de DNI debe contener 8 dgitos")

End If

txtcriterio.Focus()

ElseIf rdbapellido.Checked = True Then

dtv.Table = DTS.Tables("cliente")

dtv.RowFilter = "apellido='" & txtcriterio.Text & "'"

dgvcliente.DataSource = dtv

End If

End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

DTS = New DataSet


AbrirConexion()


cn.Close()

'dgvcliente.DataSource = DTS

'dgvcliente.DataMember = "cliente"

rdbDNI.Checked = True

Label3.Text = "Total de Clientes: " & DTS.Tables("CLIENTE").Rows.Count

Label1.Text = "Ingrese el Nro. de DNI a Buscar"

txtcriterio.Focus()

End Sub

Private Sub txtcriterio_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtcriterio.KeyPress

If Asc(e.KeyChar) = 13 Then Btnbuscar.Focus()



e.KeyChar = ""

End If

ElseIf rdbapellido.Checked Then


e.Handled = False


e.Handled = False


e.Handled = False

Else

e.Handled = True

End If

End If

End Sub

Private Sub btnsalir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsalir.Click


Close()

End If

End Sub

Private Sub Btnbuscar_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Btnbuscar.Enter

If txtcriterio.Text = "" Then


MsgBox("Ingrese Un Nro. De DNI A Buscar", MsgBoxStyle.Information, "MENSAJE")

txtcriterio.Focus()

ElseIf rdbapellido.Checked = True Then

MsgBox("Ingrese Un Apellido A Buscar", MsgBoxStyle.Information, "MENSAJE")

txtcriterio.Focus()

End If

Else

BUSCAR()

If dtv.Count = 0 Then

MsgBox("No Se Encontr Ningun Registro En La Base De Datos", MsgBoxStyle.Information, "MENSAJE")

txtcriterio.Focus()

End If

End If

End Sub

Private Sub rdbapellido_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles rdbapellido.Click

Label1.Text = "Ingrese el Apellido a Buscar"

txtcriterio.Text = ""

txtcriterio.Focus()

End Sub

Private Sub CLIENTEBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)

Me.Validate()

Me.CLIENTEBindingSource.EndEdit()

Me.CLIENTETableAdapter.Update(Me.VENTASDataSet.CLIENTE)

End Sub

Private Sub rdbDNI_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles rdbDNI.Click

Label1.Text = "Ingrese el Nro. de DNI a Buscar"

txtcriterio.Text = ""

txtcriterio.Focus()

End Sub

Private Sub txtcriterio_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles txtcriterio.KeyUp

Clipboard.Clear()

End Sub

Private Sub txtcriterio_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles txtcriterio.MouseDown

Clipboard.Clear()

End Sub

End Class

SISTEMA DE VENTA

DE FERRETERIA

AUTORES:

GARCIA TEJEDA OBED

ESCOBEDO CABEL MONICA

SANCHEZ JARA YURI

GESTOR DE BASE DE DATOS: SQL 2000LENGUAJE DE PROGRAMACIN: Visual Basic 6.0MANTENEDOR DE CLIENTE

A continuacin se detalla el cdigo fuente con el cual se cre el formulario para registrar clientes:

En declaraciones se establecieron las respectivas variables:

Dim rsCliente as New ADODB.Recordset

Dim RSFILTRAR as New ADODB.Recordset

Dim RSY as New ADODB.Recordset

Dim X as StringDim max as Integer

En el evento Load del formulario se codifico lo siguiente:

desactivatxt

Call Skn

Call estadobotones (True, CLIENTE)

rsCliente.Open "Cliente", CN, adOpenKeyset, adLockOptimistic

RSFILTRAR.Open "SELECT * FROM Cliente", CN, adOpenStatic, adLockOptimistic

Set MSHBUSCAR.DataSource = RSFILTRAR

Configuragrid

VerdatosEn los Botones se codifico lo siguiente:

En el Botn Nuevo:

Call estadobotones (False, CLIENTE)

activatxt

limpiar

GENERACODIGO

rsCliente.AddNew

En el Botn Modificar:

Call estadobotones (False, CLIENTE)

activa

txtraz_nomb.SetFocus

En el Botn Grabar:


Dim X As IntegerX = MsgBox ("Deseas Grabar...?", 36, "Guardando Datos")

If X = 6 Then RSFILTRAR.Close


grabar

RSFILTRAR.Close


Set MSHBUSCAR.DataSource = RSFILTRAR

Configuragrid

Else

rsCliente.CancelUpdate

verdatos

desactivatxt

End If

Desactivatxt

En el Boton Cancelar:


rsCliente.CancelUpdate

verdatos

desactivatxt

En el Boton Salir:

Dim i As Integeri = MsgBox ("Seguro de Salir?", vbYesNo + vbQuestion, "Salir de Cliente")

If i = vbYes ThenSet rsCliente = NothingUnload Me

MENUPRINCIPAL.Show

MENUPRINCIPAL.Enabled = TrueRSFILTRAR.Close

End If

A continuacin se crearon procedimientos a nivel de Formulario que son detallados como sigue para luego ser llamados en cada botn segn sea necesario:

---------------------------------------------------------------------------------

Sub Skn ()

Skin.LoadSkin App.Path & "\SteelBlue.skn"

Skin.ApplySkin hWnd

End Sub

------------------------------------------------------------------------------------Sub verdatos ()

txtcodigo.Text = rsCliente!id_cliente

Cbotipocliente.Text = rsCliente!tipocliente

DTPfechar.Value = rsCliente!fechaReg

txtraz_nomb.Text = rsCliente!RazSoc_Nomb

txtdire.Text = rsCliente!Direccion

txtdist.Text = rsCliente!Distrito

txtfono.Text = rsCliente!Telefono

txtemail.Text = rsCliente!Email

txtrucdni.Text = rsCliente!RUC_DNI

End Sub

------------------------------------------------------------------------------------

Sub limpiar ()

txtcodigo.Text = ""

txtraz_nomb.Text = ""

txtdire.Text = ""

txtemail.Text = ""

Cbotipocliente.Text = ""

txtrucdni.Text = ""

txtfono.Text = ""

txtdist.Text = ""

DTPfechar.Value = Date

Cbotipocliente.SetFocus

End Sub

------------------------------------------------------------------------------------------

Sub GENERACODIGO ()

If rsCliente.BOF = True Thentxtcodigo.Text = "00001"

Else

rsCliente.MoveLast

ultimo = rsCliente!id_cliente

ultimo = ultimo + 1

txtcodigo.Text = Right("00000" + RTrim(ultimo), 5)

End If

End Sub

------------------------------------------------------------------------------------

Sub muestraRUCDNI()

If Cbotipocliente.Text = "natural" Then SkinLabel7.Caption = "DNI"

txtrucdni.MaxLength = 8

SkinLabel4.Visible = True SkinLabel3.Visible = FalseElse

SkinLabel3.Visible = True SkinLabel7.Caption = "RUC"

txtrucdni.MaxLength = 11

SkinLabel4.Visible = FalseEnd If

End Sub

-------------------------------------------------------------------------------------

Sub desactivatxt ()

txtraz_nomb.Enabled = Falsetxtdire.Enabled = Falsetxtemail.Enabled = FalseCbotipocliente.Enabled = Falsetxtrucdni.Enabled = Falsetxtfono.Enabled = Falsetxtdist.Enabled = False

DTPfechar.Enabled = FalseEnd Sub

------------------------------------------------------------------------------------

Sub activatxt ()Cbotipocliente.Enabled = True

txtraz_nomb.Enabled = False

txtdire.Enabled = False

txtemail.Enabled = False

txtrucdni.Enabled = False

txtfono.Enabled = False

txtdist.Enabled = False

DTPfechar.Enabled = False

End Sub

---------------------------------------------------------------------------------------

Sub activa ()Cbotipocliente.Enabled = True

txtraz_nomb.Enabled = True

txtdire.Enabled = True

txtemail.Enabled = True

txtrucdni.Enabled = True

txtfono.Enabled = True

txtdist.Enabled = True

DTPfechar.Enabled = True

End Sub

-----------------------------------------------------------------------------------

Sub EBMov (ByVal Est1, ByVal Est2) For i = 2 To 3 Mover (i).Enabled = Est1

Next

For i = 0 To 1 Mover (i).Enabled = Est2

Next

End Sub

--------------------------------------------------------------------------------------

Sub configuragrid ()

With MSHBUSCAR

.ColWidth(0) = 0

.TextMatrix(0, 1) = "CODIGO"

.ColWidth(1) = 800

.TextMatrix(0, 2) = "TIPO CLIENTE"

.ColWidth(2) = 1200

.TextMatrix(0, 3) = "FECHA DE REGISTRO"

.ColWidth(3) = 1200

.TextMatrix(0, 4) = "RAZONSOCIAL/NOMBRE"

.ColWidth(4) = 2500

.TextMatrix(0, 5) = "DIRECCION"

.ColWidth(5) = 1900

.TextMatrix(0, 6) = "DISTRITO"

.ColWidth(6) = 1500

.TextMatrix(0, 7) = "TELEFONO"

.ColWidth(7) = 1200

.TextMatrix(0, 8) = "EMAIL"

.ColWidth(8) = 2300

.TextMatrix(0, 9) = "RUC/DNI"

.ColWidth(9) = 1200

.ColWidth(10) = 0

'.ColWidth(10) = 0

End With

End Sub

-----------------------------------------------------------------------------------

Sub grabar ()

rsCliente!id_cliente = Trim$(txtcodigo)

rsCliente!RazSoc_Nomb = Trim$(txtraz_nomb)

rsCliente!Direccion = Trim$(txtdire)

rsCliente!Email = Trim$(txtemail)

rsCliente!tipocliente = Trim$(Cbotipocliente)

rsCliente!RUC_DNI = Trim$(txtrucdni)

rsCliente!Distrito = Trim$(txtdist)

rsCliente!Telefono = Trim$(txtfono)

rsCliente!fechaReg = DTPfechar.Value

rsCliente.Update

rsCliente.Requery Set MSHBUSCAR.DataSource = RSFILTRAREnd Sub

--------------------------------------------------------------------------------------

En los botones de desplazamiento se cre un Array de botones siendo su cdigo para cada botn como sigue:

Private Sub Mover_Click (Index As Integer)

Select Case Index

Case 0

rsCliente.MoveFirst

verdatos

Call EBMov (True, False)

Case 1

rsCliente.MovePrevious

If rsCliente.BOF Then rsCliente.MoveFirst

Call EBMov (True, False)

Else

Call EBMov (True, True)

End If

verdatos

Case 2

rsCliente.MoveNext

If rsCliente.EOF Then rsCliente.MoveLast

Call EBMov(False, True)

Else

Call EBMov (True, True)

End If

verdatos

Case 3

rsCliente.MoveLast

Call EBMov (False, True)

verdatos

End Select

End Sub

En el evento Keypress de cada TextBox se codifico lo siguiente:

Private Sub txtdire_KeyPress (KeyAscii as Integer)

If KeyAscii = 13 Then txtfono.Enabled = True txtfono.SetFocus

End If

End Sub

---------------------------------------------------------------------------------------

Private Sub txtdist_KeyPress (KeyAscii as Integer)

Call letras (KeyAscii)If KeyAscii = 13 Then

DTPfechar.Enabled = True

DTPfechar.SetFocus

End If

End Sub

-----------------------------------------------------------------------------------------

Private Sub TxtEmail_KeyPress (KeyAscii as Integer)If KeyAscii = 13 Then

txtdist.Enabled = True

txtdist.SetFocus

End If

End Sub

----------------------------------------------------------------------------------------

Private Sub txtfono_KeyPress (KeyAscii As Integer)Call numeros (KeyAscii)If txtfono.Text = "" And KeyAscii = 13 Then

MsgBox "Digite su Telefono", 64, "Atencin"

ElseIf KeyAscii = 13 And (Len(txtfono) = 7 Or Len(txtfono) = 8 Or Len(txtfono) < 6) Then

MsgBox "El telefono debe tener 6 o 9 digitos", 0, "Advertencia"

txtfono.Text = ""

ElseIf KeyAscii = 13 Then

txtemail.Enabled = True

txtemail.SetFocus

End If

End Sub

-------------------------------------------------------------------------------------------

Private Sub txtraz_nomb_KeyPress (KeyAscii as Integer)Call letras(KeyAscii)If KeyAscii = 13 Then

txtrucdni.Enabled = True

txtrucdni.SetFocus

End If

End Sub

-------------------------------------------------------------------------------------------

Private Sub txtrucdni_KeyPress (KeyAscii as Integer)Call numeros(KeyAscii)X = SkinLabel7.Caption

max = txtrucdni.MaxLength

If txtrucdni.Text = "" And KeyAscii = 13 Then

MsgBox "Digite su" & " " & X, 64, "Atencin"

ElseIf KeyAscii = 13 And (Len(txtrucdni) = 9 Or Len(txtrucdni) = 10 Or Len(txtrucdni) < 8) Then

MsgBox "Debe tener" & " " & max & " " & "digitos el" & " " & X, 64, "Atencin"

txtrucdni.Text = ""

ElseIf KeyAscii = 13 Then

txtdire.Enabled = True

t

modelos de sistemas

Documents