Public Class Form35068
Dim A As New OleDb.OleDbConnection("Provider=microsoft.ACE.OLEDB.12.0;data source=" & Application.StartupPath & "\DATAMAJEMUK.accdb")
Dim dt As New DataTable
Private Sub Form35068_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 KODEBARANG, UNIT, HARGA from DETAILTRANSAKSI WHERE NOTRANS= '" & no068.Text & "'", A)
X.Fill(dt)
X.Dispose()
dgv068.DataSource = dt
End Sub
Private Sub Tambah068_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Tambah068.Click
'a'
If kb068.Text.Length = 0 Then
MsgBox("Kode barang sudah ada")
Exit Sub
End If
If Val(unit068.Text) = 0 Then
MsgBox("Masukkan Harga barang")
Exit Sub
End If
If Val(hb068.Text) = 0 Then
MsgBox("Masukkan jumlah barang")
Exit Sub
End If
'b'
Dim dr As DataRow
dr = dt.NewRow
dr("KODEBARANG") = kb068.Text
dr("UNIT") = unit068.Text
dr("HARGA") = hb068.Text
dt.Rows.Add(dr)
'c'
kb068.Text = ""
unit068.Text = ""
hb068.Text = ""
End Sub
Private Sub Simpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Simpan.Click
'a'
If no068.Text.Length = 0 Then
MsgBox("No. transaksi sudah ada")
Exit Sub
End If
If jt068.Text.Length = 0 Then
MsgBox("Jenis transaksi sudah ada")
Exit Sub
End If
'b'
If dt.Rows.Count = 0 Then
MsgBox("Jumlah baris tidak terisi")
Exit Sub
End If
'c'
Dim pencari As New ByIskandar.CariKeDataBaseByIskandar
pencari.AturPencarianDataBase("MASTERTRANSAKSI", "NOTRANS", no068.Text, 1, A)
If pencari.JumlanBaris > 0 Then
MsgBox("data tersebut sudah ada")
Exit Sub
End If
'd'
Dim CM As New OleDb.OleDbCommand
CM = New OleDb.OleDbCommand("INSERT INTO MASTERTRANSAKSI (NOTRANS, TANGGALTRANSAKSI, JENISTRANSAKSI) VALUES ('" & no068.Text & "', #" & tgl068.Value.Month & "/" & tgl068.Value.Day & "/" & tgl068.Value.Year & "#, '" & jt068.Text & "')", A)
A.Open()
CM.ExecuteNonQuery()
A.Close()
'e'
For Each X As DataRow In dt.Rows
CM = New OleDb.OleDbCommand("INSERT INTO DETAILTRANSAKSI (NOTRANS, KODEBARANG, UNIT, HARGA) VALUES ('" & no068.Text & "','" & X("KODEBARANG") & "', " & X("UNIT") & ", " & X("HARGA") & ")", A)
A.Open()
CM.ExecuteNonQuery()
A.Close()
CM.Dispose()
Next
'f'
no068.Text = ""
jt068.Text = ""
'g'
dt.Rows.Clear()
End Sub
End Class
Tidak ada komentar:
Posting Komentar