DESAIN FORM MENU
LISTING PROGRAM
Public Class Form1
Private Sub DataBarangToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataBarangToolStripMenuItem.Click
Form2.Show()
End Sub
Private Sub DataPemesanToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataPemesanToolStripMenuItem.Click
pemesan.Show()
End Sub
Private Sub DataPetugasPengirimanToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataPetugasPengirimanToolStripMenuItem.Click
Form4.Show()
End Sub
Private Sub PemesananToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PemesananToolStripMenuItem.Click
pemesan.Show()
End Sub
Private Sub PengirimanToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PengirimanToolStripMenuItem.Click
pengirim.Show()
End Sub
Private Sub btnkeluar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnkeluar.Click
End
End Sub
Private Sub LaporanDataBarangToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LaporanDataBarangToolStripMenuItem.Click
Form5.Show()
Form5.MdiParent = Me
Dim laporan As New CachedCrystalReport1
Form5.CrystalReportViewer1.ReportSource = laporan
End Sub
Private Sub LaporanDataCustumerToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LaporanDataCustumerToolStripMenuItem.Click
Form6.Show()
Form6.MdiParent = Me
Dim laporan As New CachedCrystalReport2
Form6.CrystalReportViewer1.ReportSource = laporan
End Sub
Private Sub LaporanDataPetugasToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LaporanDataPetugasToolStripMenuItem.Click
Form7.Show()
Form7.MdiParent = Me
Dim laporan As New CachedCrystalReport3
Form7.CrystalReportViewer1.ReportSource = laporan
End Sub
Private Sub LaporanToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LaporanToolStripMenuItem1.Click
Form8.Show()
Form8.MdiParent = Me
Dim laporan As New CachedCrystalReport4
Form8.CrystalReportViewer1.ReportSource = laporan
End Sub
Private Sub LaporanDataPemesananToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LaporanDataPemesananToolStripMenuItem.Click
Form9.Show()
Form9.MdiParent = Me
Dim laporan As New CachedCrystalReport5
Form9.CrystalReportViewer1.ReportSource = laporan
End Sub
End Class
Nama Tabel: Barang
FORM DATA BARANG
LISTING PROGRAM
Imports System.Data.OleDb
Public Class Form2
Public db As OleDbConnection
Public cmd As OleDbCommand
Public adp As OleDbDataAdapter
Public dr As OleDbDataReader
Public ds As New DataSet
Dim sql As String
Public Sub opendb()
Dim lokasi = “provider=microsoft.jet.oledb.4.0;data source=c:\vb2\perpustakaan1.mdb”
db = New OleDbConnection(lokasi)
If db.State = ConnectionState.Closed Then
db.Open()
End If
End Sub
Sub tampilbarang()
adp = New OleDbDataAdapter(“select * from barang”, db)
ds = New DataSet
adp.Fill(ds, “barang”)
DataGridView1.DataSource = ds.Tables(“barang”)
End Sub
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call opendb()
Call hapustext()
Call tampilbarang()
End Sub
Sub buttonbaru()
btnbaru.Enabled = True
btnsimpan.Enabled = False
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub buttonedit()
btnbaru.Enabled = False
btnsimpan.Enabled = False
btnedit.Enabled = True
btnhapus.Enabled = True
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub buttonsimpan()
btnbaru.Enabled = False
btnsimpan.Enabled = True
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub hapustext()
kode_barang.Text = “”
nabar.Text = “”
jenis.Text = “”
type.Text = “”
lebar.Text = “”
tinggi.Text = “”
satuan.Text = “”
harga.Text = “”
Call buttonbaru()
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnhapus.Click
sql = “delete from BARANG where kodebarang= ‘” & kode_barang.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilbarang()
End Sub
Private Sub btnkeluar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnkeluar.Click
Me.Close()
End Sub
Private Sub btnbaru_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnbaru.Click
Call hapustext()
kode_barang.Focus()
End Sub
Private Sub kode_barang_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles kode_barang.KeyPress
Dim tombol As Integer = Asc(e.KeyChar)
Dim xkode As String
If tombol = 13 Then
sql = “select * from barang where kodebarang='” & kode_barang.Text & “‘”
cmd = New OleDbCommand(sql, db)
dr = cmd.ExecuteReader
dr.Read()
If dr.HasRows = True Then
nabar.Text = dr.Item(1)
jenis.Text = dr.Item(2)
type.Text = dr.Item(3)
lebar.Text = dr.Item(4)
tinggi.Text = dr.Item(5)
satuan.Text = dr.Item(6)
harga.Text = dr.Item(7)
Call buttonedit()
MsgBox(“Data diTemukan..!!!”)
Else
xkode = kode_barang.Text
Call hapustext()
kode_barang.Text = xkode
Call buttonsimpan()
End If
nabar.Focus()
jenis.Focus()
type.Focus()
lebar.Focus()
tinggi.Focus()
satuan.Focus()
harga.Focus()
End If
End Sub
Private Sub btnbatal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnbatal.Click
Call hapustext()
kode_barang.Focus()
End Sub
Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click
sql = “update barang set namabarang='” & nabar.Text & “‘,” & _
“jenis='” & jenis.Text & “‘,” & _
“type='” & type.Text & “‘,” & _
“lebar='” & lebar.Text & “‘,” & _
“tinggi='” & tinggi.Text & “‘,” & _
“satuan='” & satuan.Text & “‘,” & _
“harga='” & harga.Text & “‘,” & _
“where kodebarang='” & kode_barang.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilbarang()
End Sub
Private Sub btnsimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsimpan.Click
sql = “insert into barang (kodebarang, namabarang, jenis, type, lebar, tinggi, satuan, harga)” & _
“values (‘” & kode_barang.Text & “‘,'” & _
nabar.Text & “‘,'” & _
jenis.Text & “‘,'” & _
type.Text & “‘,'” & _
lebar.Text & “‘,'” & _
tinggi.Text & “‘,'” & _
satuan.Text & “‘,'” & _
harga.Text & “‘)”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilbarang()
End Sub
End Class
Nama Tabel: PEMESAN
FORM DATA PEMESAN
LISTING PROGRAM
Imports System.Data.OleDb
Public Class pemesan
Public db As OleDbConnection
Public cmd As OleDbCommand
Public adp As OleDbDataAdapter
Public dr As OleDbDataReader
Public ds As New DataSet
Dim sql As String
Public Sub opendb()
Dim lokasi = “provider=microsoft.jet.oledb.4.0;data source=c:\vb2\perpustakaan1.mdb”
db = New OleDbConnection(lokasi)
If db.State = ConnectionState.Closed Then
db.Open()
End If
End Sub
Sub tampilpemesan()
adp = New OleDbDataAdapter(“select * from pemesan”, db)
ds = New DataSet
adp.Fill(ds, “pemesan”)
DataGridView1.DataSource = ds.Tables(“pemesan”)
End Sub
Private Sub pemesan_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call opendb()
Call hapustext()
Call tampilpemesan()
End Sub
Sub buttonbaru()
btnbaru.Enabled = True
btnsimpan.Enabled = False
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub buttonedit()
btnbaru.Enabled = False
btnsimpan.Enabled = False
btnedit.Enabled = True
btnhapus.Enabled = True
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub buttonsimpan()
btnbaru.Enabled = False
btnsimpan.Enabled = True
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub hapustext()
no_pesan.Text = “”
kode_p.Text = “”
nama_p.Text = “”
alamat.Text = “”
kode_barang.Text = “”
nama_b.Text = “”
jenis.Text = “”
type.Text = “”
lebar.Text = “”
tinggi.Text = “”
satuan.Text = “”
harga.Text = “”
tanggal.Text = “”
tgl_selesai.Text = “”
pembayaran_awal.Text = “”
sisa_bayar.Text = “”
Call buttonbaru()
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnhapus.Click
sql = “delete from pemesan where no pesan= ‘” & no_pesan.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpemesan()
End Sub
Private Sub btnkeluar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnkeluar.Click
End
End Sub
Private Sub btnbaru_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnbaru.Click
Call hapustext()
no_pesan.Focus()
End Sub
Private Sub no_pesan_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles no_pesan.KeyPress
Dim tombol As Integer = Asc(e.KeyChar)
Dim xkode As String
If tombol = 13 Then
sql = “select * from pemesan where nopesan='” & no_pesan.Text & “‘”
cmd = New OleDbCommand(sql, db)
dr = cmd.ExecuteReader
dr.Read()
If dr.HasRows = True Then
kode_p.Text = dr.Item(1)
nama_p.Text = dr.Item(2)
alamat.Text = dr.Item(3)
kode_barang.Text = dr.Item(4)
nama_b.Text = dr.Item(5)
jenis.Text = dr.Item(6)
type.Text = dr.Item(7)
lebar.Text = dr.Item(8)
tinggi.Text = dr.Item(9)
satuan.Text = dr.Item(10)
harga.Text = dr.Item(11)
tanggal.Text = dr.Item(12)
tgl_selesai.Text = dr.Item(13)
pembayaran_awal.Text = dr.Item(14)
sisa_bayar.Text = dr.Item(15)
Call buttonedit()
MsgBox(“Data diTemukan..!!!”)
Else
xkode = no_pesan.Text
Call hapustext()
no_pesan.Text = xkode
Call buttonsimpan()
End If
kode_p.Focus()
nama_p.Focus()
alamat.Focus()
kode_barang.Focus()
nama_b.Focus()
jenis.Focus()
type.Focus()
lebar.Focus()
tinggi.Focus()
satuan.Focus()
harga.Focus()
tanggal.Focus()
tgl_selesai.Focus()
pembayaran_awal.Focus()
sisa_bayar.Focus()
End If
End Sub
Private Sub btnbatal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnbatal.Click
Call hapustext()
no_pesan.Focus()
End Sub
Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnedit.Click
sql = “update pemesan set kode pemesan='” & kode_p.Text & “‘,” & _
“nama='” & nama_p.Text & “‘,” & _
“alamat='” & alamat.Text & “‘,” & _
“kodebarang='” & kode_barang.Text & “‘,” & _
“namabarang='” & nama_b.Text & “‘,” & _
“jenis='” & jenis.Text & “‘,” & _
“type='” & type.Text & “‘,” & _
“lebar='” & lebar.Text & “‘,” & _
“tinggi='” & tinggi.Text & “‘,” & _
“satuan='” & satuan.Text & “‘,” & _
“harga='” & harga.Text & “‘,” & _
“tanggal='” & tanggal.Text & “‘,” & _
“tanggalselesai='” & tgl_selesai.Text & “‘,” & _
“pembayaranawal='” & pembayaran_awal.Text & “‘,” & _
“sisabayar='” & sisa_bayar.Text & “‘,” & _
“where nopesan='” & no_pesan.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpemesan()
End Sub
Private Sub btnsimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsimpan.Click
sql = “insert into pemesan (nopesan,kodepemesan,nama,alamat,kode barang,nama barang, jenis, type, lebar, tinggi, satuan, harga,tanggal,tanggalselesai,pembayaranawal,sisabayar)” & _
“values (‘” & no_pesan.Text & “‘,'” & _
kode_p.Text & “‘,'” & _
nama_p.Text & “‘,'” & _
alamat.Text & “‘,'” & _
kode_barang.Text & “‘,'” & _
nama_b.Text & “‘,'” & _
jenis.Text & “‘,'” & _
type.Text & “‘,'” & _
lebar.Text & “‘,'” & _
tinggi.Text & “‘,'” & _
satuan.Text & “‘,'” & _
harga.Text & “‘,'” & _
tanggal.Text & “‘,'” & _
tgl_selesai.Text & “‘,'” & _
pembayaran_awal.Text & “‘,'” & _
sisa_bayar.Text & “‘)”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpemesan()
End Sub
End Class
Nama Tabel: PETUGAS
FORM DATA PETUGAS PENGIRIMAN
LISTING PROGRAM
Imports System.Data.OleDb
Public Class Form4
Public db As OleDbConnection
Public cmd As OleDbCommand
Public adp As OleDbDataAdapter
Public dr As OleDbDataReader
Public ds As New DataSet
Dim sql As String
Public Sub opendb()
Dim lokasi = “provider=microsoft.jet.oledb.4.0;data source=c:\vb2\perpustakaan1.mdb”
db = New OleDbConnection(lokasi)
If db.State = ConnectionState.Closed Then
db.Open()
End If
End Sub
Sub tampilpetugas()
adp = New OleDbDataAdapter(“select * from petugas”, db)
ds = New DataSet
adp.Fill(ds, “petugas”)
DataGridView1.DataSource = ds.Tables(“petugas”)
End Sub
Private Sub Form4_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call opendb()
Call hapustext()
Call tampilpetugas()
End Sub
Sub buttonbaru()
btnbaru.Enabled = True
btnsimpan.Enabled = False
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub buttonedit()
btnbaru.Enabled = False
btnsimpan.Enabled = False
btnedit.Enabled = True
btnhapus.Enabled = True
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub buttonsimpan()
btnbaru.Enabled = False
btnsimpan.Enabled = True
btnedit.Enabled = False
btnhapus.Enabled = False
btnbatal.Enabled = True
Btnkeluar.Enabled = False
End Sub
Sub hapustext()
kode_petugas.Text = “”
nama_petugas.Text = “”
no_plat.Text = “”
Call buttonbaru()
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
sql = “delete from petugas where kode= ‘” & kode_petugas.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpetugas()
End Sub
Private Sub btnkeluar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
End
End Sub
Private Sub btnbaru_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Call hapustext()
kode_petugas.Focus()
End Sub
Private Sub btnbatal_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Call hapustext()
kode_petugas.Focus()
End Sub
Private Sub btnedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
sql = “update petugas set namapetugas='” & nama_petugas.Text & “‘,” & _
“noplat='” & no_plat.Text & “‘,” & _
“where kodepetugas='” & kode_petugas.Text & “‘”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpetugas()
End Sub
Private Sub btnsimpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
sql = “insert into petugas (kodepetugas, namapetugas, noplat)” & _
“values (‘” & kode_petugas.Text & “‘,'” & _
nama_petugas.Text & “‘,'” & _
no_plat.Text & “‘)”
cmd = New OleDbCommand(sql, db)
cmd.ExecuteNonQuery()
Call btnbaru_Click(sender, e)
Call tampilpetugas()
End Sub
Private Sub kode_petugas_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles kode_petugas.KeyPress
Dim tombol As Integer = Asc(e.KeyChar)
Dim xkode As String
If tombol = 13 Then
sql = “select * from petugas where kodepetugas='” & kode_petugas.Text & “‘”
cmd = New OleDbCommand(sql, db)
dr = cmd.ExecuteReader
dr.Read()
If dr.HasRows = True Then
nama_petugas.Text = dr.Item(1)
no_plat.Text = dr.Item(2)
Call buttonedit()
MsgBox(“Data diTemukan..!!!”)
Else
xkode = kode_petugas.Text
Call hapustext()
kode_petugas.Text = xkode
Call buttonsimpan()
End If
nama_petugas.Focus()
no_plat.Focus()
End If
End Sub
End Class