Latihan_38_36110044 Aplikasi Komputer 4

Form Latihan_38  terdapat lima object yaitu Label, Textbox, Button, DateTimePicker dan DataGridView

Object Label

Terdapat sembilan object Label (yang bertuliskan No. Transaksi, Tanggal, Jenis Transaksi, Kode Barang, Nama Barang, Unit,  Harga, Jumlah dan Total)

Object Textbox

Terdapat delapan object textbox (lima berstatus input dan tiga berstatus ReadOnly).

Status input digunakan untuk memasukkan angka.

Statua ReadOnly untuk menampilkan hasil perhitungan.

Object Button

Terdapat dua object button yaitu TAMBAH dan SIMPAN 

Date TimePicker

Terdapat 1 object DateTimePicker yang digunakan untuk memasukkan tanggal terjadinya transaksi.

DataGridView

Terdapat 1 DataGridView untuk menampilkan data transaksi

Script Unique

Untuk button TAMBAH

If KODE_36110044.Text.Length = 0 Then

            MsgBox("kode barang belum terisi")

            Exit Sub

        End If

Untuk button SIMPAN

If NO_36110044.Text.Length = 0 Then

            MsgBox("no.transaksi belum terisi")

            Exit Sub

        End If

Even

Latihan_38_36110044_Load

TOTALJUMLAH()

KODE_36110044_Leave

KODE_36110044_TextChanged

UNIT_36110044_TextChanged

TAMBAH_36110044_Click

SIMPAN_36110044_Click

PROSEDUR PENYELESAIAN:

1.      Klik star lalu pilih Microsoft Visual Studio 2008

2.      Pilih icon Add New Item

3.      Ubah nama pada lembar “Add New Item” kemudian add

4.      Buat design form dengan menggunakan Label, Textbox, Button, DateTimePicker dan DataGridView yang ada dalam "Toolbox”

5.      Ganti nama Textbox dan Button menggunakan "Properties Window"

6.      Klik kanan pada kotak design kemudian pilih View Code untuk membuka lembar vb
 Masukkan rumus berikut untuk menyelesaikan latihan_38

            Public Class Latihan_38_36110044

    Dim CONECT As New OleDb.OleDbConnection("provider=microsoft.ace.oledb.12.0;data source= " & Application.StartupPath & "\DATAMAJEMUK.accdb;Jet OLEDB:Database Password=22")

    Dim tiya As New DataTable

    Dim INNA As DataRow

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

        Dim X As New OleDb.OleDbDataAdapter

        X = New OleDb.OleDbDataAdapter("Select BARANG.KODEBARANG, BARANG.NAMABARANG, DETAILTRANSAKSI.UNIT, DETAILTRANSAKSI.HARGA, DETAILTRANSAKSI.UNIT*DETAILTRANSAKSI.HARGA AS JUMLAH from DETAILTRANSAKSI INNER JOIN BARANG ON DETAILTRANSAKSI.KODEBARANG=BARANG.KODEBARANG WHERE NOTRANS= '" & NO_36110044.Text & "'", CONECT)

        X.Fill(tiya)

        X.Dispose()

        Dim dataPrimary(1) As DataColumn

        dataPrimary(0) = tiya.Columns("KODEBARANG")

        tiya.PrimaryKey = dataPrimary

        DGV_36110044.DataSource = tiya

    End Sub

    Private Sub TOTALJUMLAH()

        Dim TOT As Double = 0

        For Each x As DataRow In tiya.Rows

            TOT = TOT + x("JUMLAH")

        Next

        TOTAL_36110044.Text = TOT

    End Sub

    Private Sub KODE_36110044_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles KODE_36110044.Leave

        If KODE_36110044.Text.Length = 0 Then

            Exit Sub

        End If

        Dim Pencari As New ByIskandar.CariKeDataBaseByIskandar

        Pencari.AturPencarianDataBase("BARANG", "KODEBARANG", KODE_36110044.Text, 1, CONECT)

        If Pencari.JumlanBaris > 0 Then

            KODE_36110044.Text = Pencari.DataTablenya.Rows(0).Item("KODEBARANG")

            NMBARANG_36110044.Text = Pencari.DataTablenya.Rows(0).Item("NAMABARANG")

        Else

            MsgBox("Kode barang tersebut tidak ada")

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

                KODE_36110044.Text = Latihan_383940_36110044.DGV_36110044.CurrentRow.Cells("KodeBarang").Value

                NMBARANG_36110044.Text = Latihan_383940_36110044.DGV_36110044.CurrentRow.Cells("NamaBarang").Value

            Else

                KODE_36110044.Text = ""

            End If

        End If

    End Sub

    Private Sub KODE_36110044_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles KODE_36110044.TextChanged

        NMBARANG_36110044.Text = ""

        UNIT_36110044.Text = ""

        HARGA_36110044.Text = ""

    End Sub

    Private Sub UNIT_36110044_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UNIT_36110044.TextChanged, HARGA_36110044.TextChanged

        JUMLAH_36110044.Text = Val(UNIT_36110044.Text) * Val(HARGA_36110044.Text)

    End Sub

    Private Sub TAMBAH_36110044_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TAMBAH_36110044.Click

        If KODE_36110044.Text.Length = 0 Then

            MsgBox("Kode barang sudah ada")

            Exit Sub

        End If

        If NMBARANG_36110044.Text.Length = 0 Then

            MsgBox("Nama barang sudah ada")

        End If

        If Val(UNIT_36110044.Text) = 0 Then

            MsgBox("Masukkan unit barang")

            Exit Sub

        End If

        If Val(HARGA_36110044.Text) = 0 Then

            MsgBox("Masukkan harga barang barang")

            Exit Sub

        End If

        INNA = tiya.Rows.Find(KODE_36110044.Text)

        If INNA Is Nothing Then

            INNA = tiya.NewRow

            INNA("KODEBARANG") = KODE_36110044.Text

        Else

            MsgBox("Maaf kodebarang sudah ada")

            Exit Sub

        End If

        INNA = tiya.NewRow

        INNA("KODEBARANG") = KODE_36110044.Text

        INNA("NAMABARANG") = NMBARANG_36110044.Text

        INNA("UNIT") = UNIT_36110044.Text

        INNA("HARGA") = HARGA_36110044.Text

        INNA("JUMLAH") = JUMLAH_36110044.Text

        tiya.Rows.Add(INNA)

        KODE_36110044.Text = ""

        NMBARANG_36110044.Text = ""

        UNIT_36110044.Text = ""

        HARGA_36110044.Text = ""

        TOTALJUMLAH()

    End Sub

    Private Sub SIMPAN_36110044_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SIMPAN_36110044.Click

        If NO_36110044.Text.Length = 0 Then

            MsgBox("No. transaksi sudah ada")

            Exit Sub

        End If

        If JENIS_36110044.Text.Length = 0 Then

            MsgBox("Jenis transaksi sudah ada")

            Exit Sub

        End If

        If tiya.Rows.Count = 0 Then

            MsgBox("Jumlah baris tidak terisi")

            Exit Sub

        End If

        Dim pencari As New ByIskandar.CariKeDataBaseByIskandar

        pencari.AturPencarianDataBase("MASTERTRANSAKSI", "NOTRANS", NO_36110044.Text, 1, CONECT)

        If pencari.JumlanBaris > 0 Then

            MsgBox("data tersebut sudah ada")

            Exit Sub

        End If

        Dim NN As New OleDb.OleDbCommand

        NN = New OleDb.OleDbCommand("INSERT INTO MASTERTRANSAKSI (NOTRANS, TANGGALTRANSAKSI, JENISTRANSAKSI) VALUES ('" & NO_36110044.Text & "', #" & DTP_36110044.Value.Month & "/" & DTP_36110044.Value.Day & "/" & DTP_36110044.Value.Year & "#, '" & JENIS_36110044.Text & "')", CONECT)

        CONECT.Open()

        NN.ExecuteNonQuery()

        CONECT.Close()

        For Each X As DataRow In tiya.Rows

            NN = New OleDb.OleDbCommand("INSERT INTO DETAILTRANSAKSI (NOTRANS, KODEBARANG, UNIT, HARGA) VALUES ('" & NO_36110044.Text & "','" & X("KODEBARANG") & "'," & X("UNIT") & ", " & X("HARGA") & ")", CONECT)

            CONECT.Open()

            NN.ExecuteNonQuery()

            CONECT.Close()

            NN.Dispose()

        Next

        NO_36110044.Text = ""

        JENIS_36110044.Text = ""

        JUMLAH_36110044.Text = ""

        tiya.Rows.Clear()

        TOTALJUMLAH()

    End Sub

End Class

7.      Jalankan program dengan menggunakan  “start debugging”