lampiran i. struktur organisasi -...

43

Lampiran I. Struktur Organisasi

JUNIOR MANAGER

ADMIN CONTROL

OFFICER

SUPERVISOR

STAFF ADMIN OPERATOR OPERATOR

STUKTUR ORGANISASI WARE HOUSE ROW

MATERIAL SYNTETIC

44

Lampiran II. Data Flow Diagram Level 0

Sistem

persediaan

kapas

syntetics WH.

RM

Gudang

Bag.

Produksi

Supplier

Akuntansi

1.Pemesanan

Polyester /

rayon

2.polyester /

rayon dari

3.Penerimaan

Polyester /

rayon

4. Permintaan

polyester /

rayon

5.Pengeluaran

Polyester /

rayon

6.Pencatatan

Polyester /

rayon Masuk &

Keluar

7.Pengolahan

polyester /

rayon

45

Lampiran III. Flowchart Sistem Penyimpanan dan Pengiriman Material

mulai

Invoice /

Surat

jalan

Sesui no. invoice /

surat jalan, nama

cust,qty?

Membuat laporan

berupa E- mail

dikirim ke Purchase

Dept, Accounting Dept, QC Lab dan

Manager.

Menyimpan barang

dan membuat laporan

penerimaan barang

1

Laporang

penerimaan

barang

Menyimpan barang

Sesuai dengan tanggal

yang terdapat pada

packing bale

Diserahkan ke

bag. Accounting

Bagian Gudang

Ya Tidak

Bagian Produksi

2

Laporang

penerimaan

barang

N

Invoice /

Surat jalan

dari Supplier

N

Melakukan foto

copy invoice /

Surat jalan

Invoice /

Surat jalan

dari Supplier

Foto Copy

Invoice / Surat

jalan dari

Supplier

Diserahkan ke

bag. Accounting

1

Bagian Timbangan

Timbangan1

1

barang

Form

Produksi

Membuat Bon

Permintaan

Barang

1

Bon

Permintaan

Barang

2

Bon

Permintaan

Barang

2

Form

Produksi

N

Dari

Dept.Despacth

Diserahkan ke

bag. Gudang

2

Sesuai permintaan

produksi

Mempersiapkan

barang yang

akan dikirim ke

produksi sesuai

permintaan

barang maklon/

AIC

ya

tidak

Melakukan

konfirmasi ke

bag. Produksi

apakah barang

akan diganti

dengan yang

lain atau tidak

1

Bon

Permintaan

Barang

2

Bon

Permintaan

Barang

1

Bon

Permintaa

n Barang

2

Bon

Permintaa

n Barang

3Membuat

laporan

pengeluar

an barang

2

Bon

Permintaa

n BarangN

Laporan

pengelu

aran

Melakukan

penimbangan

Timbangan1

2

1Di arsip bag.

Timbangan

A

Timbangan2

barang

Barang

datang

masuk ke

jembatan

timbang

3

1

Bon

Permintaa

n Barang

Sesuai permintaan

barang

Melakukan

proses

produksi

Melakukan

konfirmasi ke

bag. Gudang

utuk

melakukan

penukaran

barang yang

sesuai dengan

permintaan

tidak

ya

1

Bon

Permintaa

n Barang

Barang produksiBarang sisa

produksi

Membuat

catatan

sisa

produksi

Catatan

sisa

produksi

1

Barang sisa

produksi

Catatan

sisa

produksi

2

N

4

Catatan

sisa

produksi

2

Barang sisa

produksi

4

Membuat

laporan

penerimaan

re-use

Catatan

sisa

produksi

2

Barang sisa

produksiN

Melakukan

penyimpanan

barang

46

Lampiran IV. Surat Keterangan Selesai Kerja Praktik

47

Lampiran V. Rekapitulasi Kehadiran Praktik Kerja

48

Lampiran VI . Jurnal Praktik Kerja Lapangan

Lampiran VII. Jurnal Praktik Kerja Lapangan

50

Lampiran VIII.Jurnal Bimbingan Laporan PKL

Form Kontainer

51

Imports System.Data

Imports System.Data.OleDb

Public Class Form_kontainer

Dim jml_baris As Integer

Dim brs As Integer = 0

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

Handles Btn_Simpan.Click

If Me.Txt_KodeKon.Text = "" Or Me.Txt_NamaKon.Text = "" Or Me.Txt_KodeKon.Text = "" Then

MsgBox("Input Belum Lengkap")

Exit Sub

End If

Try

Dim simpanmaster As String = "Insert into

tb_barang(tanggal_packing,no_bale,nama_barang,jenis,supplier) values " & _

"('" & Me.Txt_KodeKon.Text & "','" & Me.Txt_NamaKon.Text & "','" & "')"

cmd = New OleDbCommand(simpanmaster, cn)

cmd.ExecuteNonQuery()

MsgBox("Data Tersimpan")

'Call hitung_baris()

brs = 0

'Call tampil()

Catch ex As Exception

MsgBox(ex.Message, MsgBoxStyle.Information, "Perhatian")

End Try

'Call mati()

Me.Btn_Simpan.Enabled = False

Me.Btn_Edit.Enabled = True

Me.Btn_Hapus.Enabled = True

End Sub

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

Handles Btn_Hapus.Click

Try

If MessageBox.Show("Yakin akan dihapus..?", "", MessageBoxButtons.YesNo) =

Windows.Forms.DialogResult.Yes Then

Dim Com_Hapus As New OleDbCommand

Com_Hapus.Connection = cn

Com_Hapus.CommandText = "DELETE FROM tb_kontainer WHERE no_kontainer=" & _

"'" & Me.Txt_KodeKon.Text & "'"

Com_Hapus.ExecuteNonQuery()

End If


brs = 0

'Call tampil()


MsgBox(ex.ToString())

End Try

'Me.TS_Total.Text = "of" & "<" & jml_baris & ">"

End Sub

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

Handles Btn_Tambah.Click

Call hidup()

Me.Btn_Edit.Enabled = False

Me.Btn_Hapus.Enabled = False


Me.Txt_KodeKon.Text = ""

Me.Txt_NamaKon.Text = ""

End Sub

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

Handles MyBase.Load

Call koneksi()

Me.Txt_KodeKon.Text = True

Me.Txt_NamaKon.Select()

Me.Btn_Edit.Enabled = False


Call mati()

End Sub

52

Sub mati()

Me.Txt_KodeKon.ReadOnly = True

Me.Txt_NamaKon.ReadOnly = True

End Sub

Sub hidup()

Me.Txt_KodeKon.ReadOnly = False

Me.Txt_NamaKon.ReadOnly = False

End Sub

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

Handles Btn_Keluar.Click

Me.Close()

End Sub

Sub tampil()

Dim semua = "select * From t_barang order by no_bale"

da = New Data.OleDb.OleDbDataAdapter(semua, cn)

ds = New DataSet

da.Fill(ds)

Dim barang As New DataTable

barang.Clear()

da.Fill(barang)

DG_Kon.DataSource = barang

Try

Me.Txt_KodeKon.Text = ds.Tables(0).Rows(brs).Item(0)

Me.Txt_NamaKon.Text = ds.Tables(0).Rows(brs).Item(1)


MsgBox(ex.ToString)

End Try

End Sub

Sub tampildt()

Me.Txt_KodeKon.Text = ds.Tables(0).Rows(brs).Item(0)

Me.Txt_NamaKon.Text = ds.Tables(0).Rows(brs).Item(1)

End Sub

Private Sub lastToolStripButton_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles lastToolStripButton.Click

Try

If (Not brs = ds.Tables(0).Rows.Count - 1) Then

brs = ds.Tables(0).Rows.Count - 1

Call tampil()

Me.DG_Kon.CurrentRowIndex = brs

End If



End Try

TS_NO.Text = jml_baris

End Sub

Private Sub nextToolStripButton_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles nextToolStripButton.Click

Try


brs += 1

Call tampil()


End If



End Try

TS_NO.Text = brs + 1

End Sub

Private Sub previousToolStripButton_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles previousToolStripButton.Click

Try

If (Not brs = 0) Then

brs -= 1

Call tampil()


End If


53


End Try


End Sub

Private Sub firstToolStripButton_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles firstToolStripButton.Click

Try

brs = 0

Call tampil()




End Try


End Sub

End Class

Form Penerimaan

Imports System.Data


Public Class Form_penerimaan



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

Handles btn_simpan.Click

If Me.txt_no.Text = "" Or Me.txt_kode.Text = "" Or Me.txt_nama.Text = "" Or

Me.txt_tgterima.Text = "" Or Me.txt_sup.Text = "" Then


Exit Sub

End If

Try


tb_penerimaan(tg_packing,no_bale,nama_barang,tg_penerimaan,kode_supplier) values " & _

"('" & Me.txt_no.Text & "','" & Me.txt_kode.Text & "','" & Me.txt_nama.Text & "','" &

Me.txt_no.Text & "','" & Me.txt_sup.Text & "')"





brs = 0

'Call tampil()



End Try

'Call mati()

Me.btn_simpan.Enabled = False

Me.btn_edit.Enabled = True

Me.btn_hapus.Enabled = True

End Sub

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

Handles btn_hapus.Click

Try





Com_Hapus.CommandText = "DELETE FROM tb_penerimaan WHERE no_bale=" & _

"'" & Me.txt_kode.Text & "'"


End If


brs = 0

'Call tampil()


54


End Try


End Sub

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

Handles MyBase.Load

End Sub



Try


brs += 1

Call tampil()

Me.dg_brg.CurrentRowIndex = brs

End If



End Try


End Sub



Try



Call tampil()


End If



End Try


End Sub



Try


brs -= 1

Call tampil()


End If



End Try


End Sub



Try

brs = 0

Call tampil()




End Try


End Sub

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

Handles btn_edit.Click

End Sub

End Class

55

Form Retur

Imports System.Data


Public Class Form_retur





If Me.txt_no.Text = "" Or Me.txt_tgret.Text = "" Or Me.txt_no.Text = "" Or

Me.txt_noret.Text = "" Then


Exit Sub

End If

Try

Dim simpanmaster As String = "Insert into tb_retur(no_retur,tg_retur,no_penerimaan)

values " & _

"('" & Me.txt_no.Text & "','" & Me.txt_tgret.Text & "','" & Me.txt_no.Text & "','" &

Me.txt_noret.Text & "')"




Call hitung_baris()

brs = 0

Call tampil()



End Try

Call mati()




End Sub



Try





Com_Hapus.CommandText = "DELETE FROM tb_retur WHERE no_penerimaan=" & _

"'" & Me.txt_tgret.Text & "'"


End If

Call hitung_baris()

brs = 0

Call tampil()



End Try

Me.TS_Total.Text = "of" & "<" & jml_baris & ">"

End Sub



Me.txt_tgret.Text = ""

Me.txt_noret.Text = ""

Me.txt_no.Text = ""

End Sub

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

Handles MyBase.Load

Call koneksi()

Me.txt_no.Text = True

Me.txt_tgret.Text = True

Me.txt_noret.Select()

56

Me.btn_edit.Enabled = False


Call mati()

End Sub

Sub mati()

Me.txt_no.ReadOnly = True

Me.txt_tgret.ReadOnly = True

Me.txt_noret.ReadOnly = True

End Sub

Sub hidup()

Me.txt_no.ReadOnly = False

Me.txt_tgret.ReadOnly = False

Me.txt_noret.ReadOnly = False

End Sub

Sub tampil()

Dim semua = "select * From tb_retur order by no_penerimaan"


ds = New DataSet

da.Fill(ds)


barang.Clear()

da.Fill(barang)

Me.dg_brg.DataSource = barang

Try

Me.txt_no.Text = ds.Tables(0).Rows(brs).Item(0)

Me.txt_noret.Text = ds.Tables(0).Rows(brs).Item(1)

Me.txt_tgret.Text = ds.Tables(0).Rows(brs).Item(2)


MsgBox(ex.ToString)

End Try

End Sub

Sub tampildt()

Me.txt_no.Text = ds.Tables(0).Rows(brs).Item(0)

Me.txt_noret.Text = ds.Tables(0).Rows(brs).Item(1)

Me.txt_tgret.Text = ds.Tables(0).Rows(brs).Item(1)

End Sub

End Class

Form Reuse

Imports System.Data


Public Class Form_reuse



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

End Sub



If Me.txt_kode.Text = "" Or Me.txt_kode.Text = "" Or Me.txt_nama.Text = "" Or

Me.txt_tgpac.Text = "" Or Me.txt_spin.Text = "" Then


Exit Sub

End If

Try


tb_reuse(kode_bale,nama_barang,tg_packing,kode_spining) values " & _

"('" & Me.txt_kode.Text & "','" & Me.txt_nama.Text & "','" & Me.txt_tgpac.Text & "','" &

Me.txt_spin.Text & "')"





brs = 0

'Call tampil()


57


End Try

'Call mati()




End Sub



Try





Com_Hapus.CommandText = "DELETE FROM tb_reuse WHERE kode_bale=" & _



End If


brs = 0

'Call tampil()



End Try


End Sub

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

Handles MyBase.Load

End Sub




End Sub

Private Sub ToolStrip2_ItemClicked(ByVal sender As System.Object, ByVal e As

System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ToolStrip2.ItemClicked

End Sub



Try


brs += 1

Call tampil()

DG_Sup.CurrentRowIndex = brs

End If



End Try


End Sub



Try



Call tampil()


End If



End Try


End Sub

58



Try


brs -= 1

Call tampil()


End If



End Try


End Sub



Try

brs = 0

Call tampil()




End Try


End Sub

End Class

Form Persediaan

Imports System.Data


Public Class Form_stock



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

MyBase.Load

Call koneksi()

Me.rb_kode.Checked = True

Me.txt_cari.Select()



Call mati()

End Sub

Sub mati()

Me.txt_jenis.ReadOnly = True

Me.txt_kode.ReadOnly = True

Me.txt_nama.ReadOnly = True

Me.txt_line.ReadOnly = True

Me.txt_tgl.ReadOnly = True

End Sub

Sub hidup()

Me.txt_jenis.ReadOnly = False

Me.txt_kode.ReadOnly = False

Me.txt_nama.ReadOnly = False

Me.txt_line.ReadOnly = False

Me.txt_tgl.ReadOnly = False

End Sub

Sub hitung_baris()

da = New Data.OleDb.OleDbDataAdapter("SELECT * FROM T_Barang", cn)

ds = New DataSet

da.Fill(ds)

jml_baris = ds.Tables(0).Rows.Count

End Sub

Sub tampil()

Dim semua = "select * From t_barang order by no_bale"


ds = New DataSet

da.Fill(ds)


barang.Clear()

59

da.Fill(barang)

dg_brg.DataSource = barang

Try

Me.txt_tgl.Text = ds.Tables(0).Rows(brs).Item(0)

Me.txt_jenis.Text = ds.Tables(0).Rows(brs).Item(1)

Me.txt_kode.Text = ds.Tables(0).Rows(brs).Item(2)

Me.txt_nama.Text = ds.Tables(0).Rows(brs).Item(3)

Me.txt_line.Text = ds.Tables(0).Rows(brs).Item(4)


MsgBox(ex.ToString)

End Try

End Sub

Sub tampildt()

Me.txt_tgl.Text = ds.Tables(0).Rows(brs).Item(0)

Me.txt_jenis.Text = ds.Tables(0).Rows(brs).Item(1)

Me.txt_kode.Text = ds.Tables(0).Rows(brs).Item(2)

Me.txt_nama.Text = ds.Tables(0).Rows(brs).Item(3)

Me.txt_line.Text = ds.Tables(0).Rows(brs).Item(4)

End Sub

Sub cari()

If Me.txt_cari.Text = "" Then MsgBox("masukkan kode atau nama barang")

Me.txt_cari.Focus()

Exit Sub

end if

Try

If Me.rb_kode.Checked = True Then

da = New OleDbDataAdapter("select * from tb_barang where no_bale like '" &

Me.txt_cari.Text & "%'", cn)

End If

ElseIf RB_Nama.Checked = True Then

da = New OleDbDataAdapter("select * from tb_Barang where nama_barang like '" &

Me.txt_cari.Text & "%'", cn)

end if

ds = New DataSet

da.Fill(ds)

If ds.Tables(0).Rows.Count = Nothing Then

MsgBox("Data tidak ditemukan!", MsgBoxStyle.Information, "Perhatian")

txt_cari.Clear()

txt_cari.Focus()

Exit Sub

End If

Call tampildt()


barang.Clear()

da.Fill(barang)

dg_brg.DataSource = barang

Call hitung_baris()

'Me.Lbl_Cari.Text = "*ditemukan " & barang.Rows.Count & " record....!!!"

'Me.TS_Total.Text = "of" & "<" & barang.Rows.Count & ">"

Catch ex As ApplicationException


End Try

End Sub

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

Handles txt_cari.TextChanged

'If e.keychar = Chr(13) Then

Call cari()

'End If

End Sub

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

Handles Btn_cari.Click

Call cari()

End Sub



If Me.txt_tgl.Text = "" Or Me.txt_kode.Text = "" Or Me.txt_nama.Text = "" Or

Me.txt_jenis.Text = "" Or Me.txt_line.Text = "" Then

60


Exit Sub

End If

Try


tb_barang(tg_packing,kode_bale,nama_barang,jenis,line) values " & _

"('" & Me.txt_tgl.Text & "','" & Me.txt_kode.Text & "','" & Me.txt_nama.Text & "','" &

Me.txt_jenis.Text & "','" & Me.txt_line.Text & "')"




Call hitung_baris()

brs = 0

Call tampil()



End Try

Call mati()




End Sub

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

Handles btn_tambah.Click

Call hidup()


Me.btn_hapus.Enabled = False


Me.txt_tgl.Text = ""

Me.txt_kode.Text = ""

Me.txt_nama.Text = ""

Me.txt_jenis.Text = ""

Me.txt_line.Text = ""

End Sub



Me.btn_tambah.Enabled = False

End Sub



Try





Com_Hapus.CommandText = "DELETE FROM tb_barang WHERE kode_bale=" & _



End If

Call hitung_baris()

brs = 0

Call tampil()



End Try


End Sub

Private Sub dg_brg_CellContentClick(ByVal sender As System.Object, ByVal e As

System.Windows.Forms.DataGridViewCellEventArgs) Handles dg_brg.CellContentClick




Try

Call tampildt()


61


End Try

End Sub

Private Sub ToolStrip1_ItemClicked(ByVal sender As System.Object, ByVal e As

System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ToolStrip1.ItemClicked

End Sub



Try


brs += 1

Call tampil()

Me.dg_brg.CurrentCell = brs

End If



End Try


End Sub



Try



Call tampil()


End If



End Try


End Sub



Try


brs -= 1

Call tampil()


End If



End Try


End Sub



Try

brs = 0

Call tampil()




End Try


End Sub

End Class

Form Supplier

Imports System.Data


Public Class Form_suplier



62

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

Handles MyBase.Load

Call koneksi()

Call tampil()

Call hitung_baris()

Me.Rb_Kode.Checked = True

Me.Txt_Cari.Select()


Me.TS_NO.Text = 1

Call mati()


End Sub

Sub mati()

Me.Txt_KodeSup.ReadOnly = True

Me.Txt_NamaSup.ReadOnly = True

Me.Txt_Alamat.ReadOnly = True

Me.Txt_Email.ReadOnly = True

End Sub

Sub hidup()

Me.Txt_KodeSup.ReadOnly = False

Me.Txt_NamaSup.ReadOnly = False

Me.Txt_Alamat.ReadOnly = False

Me.Txt_Email.ReadOnly = False

End Sub

Sub hitung_baris()

da = New Data.OleDb.OleDbDataAdapter("SELECT * FROM T_Suplier", cn)

ds = New DataSet

da.Fill(ds)

jml_baris = ds.Tables(0).Rows.Count

End Sub

Sub tampil()

Dim semua = "select * From T_Suplier order by kode_Suplier"


ds = New DataSet

da.Fill(ds)


barang.Clear()

da.Fill(barang)

DG_Sup.DataSource = barang

Try

Me.Txt_KodeSup.Text = ds.Tables(0).Rows(brs).Item(0)

Me.Txt_NamaSup.Text = ds.Tables(0).Rows(brs).Item(1)

Me.Txt_Alamat.Text = ds.Tables(0).Rows(brs).Item(2)

Me.Txt_Email.Text = ds.Tables(0).Rows(brs).Item(3)



End Try

End Sub

Sub tampilteks()

Me.Txt_KodeSup.Text = ds.Tables(0).Rows(brs).Item(0)

Me.Txt_NamaSup.Text = ds.Tables(0).Rows(brs).Item(1)

Me.Txt_Alamat.Text = ds.Tables(0).Rows(brs).Item(2)

Me.Txt_Email.Text = ds.Tables(0).Rows(brs).Item(3)

End Sub

Sub cari()

If Txt_Cari.Text = "" Then

MsgBox("Isikan kata kunci pencarian")

Txt_Cari.Focus()

Exit Sub

End If

Try

If RB_Kode.Checked = True Then

da = New OleDbDataAdapter("select * from T_Suplier where Kode_Suplier like '" &

Txt_Cari.Text & "%'", cn)

ElseIf RB_Nama.Checked = True Then

da = New OleDbDataAdapter("select * from T_Suplier where Nama_Suplier like '" &

Txt_Cari.Text & "%'", cn)

End If

ds = New DataSet

da.Fill(ds)

63

If ds.Tables(0).Rows.Count = Nothing Then

MsgBox("Data tidak ditemukan!", MsgBoxStyle.Information, "Perhatian")

Txt_Cari.Clear()

Txt_Cari.Focus()

Exit Sub

End If

Call tampilteks()


barang.Clear()

da.Fill(barang)

DG_Sup.DataSource = barang

Call hitung_baris()

'Me.Lbl_Cari.Text = "*ditemukan " & barang.Rows.Count & " record....!!!"

Me.TS_Total.Text = "of" & "<" & barang.Rows.Count & ">"

Catch ex As ApplicationException


End Try

End Sub

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

Handles Txt_Cari.TextChanged

'If e.KeyChar = Chr(13) Then

' Call cari()

'End If

End Sub

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

Handles Btn_Cari.Click

Call cari()

End Sub



Try


brs += 1

Call tampil()


End If



End Try


End Sub



Try

brs = 0

Call tampil()




End Try


End Sub



Try


brs -= 1

Call tampil()


End If



End Try


End Sub

64



Try



Call tampil()


End If



End Try


End Sub

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

Handles btn_tambah.Click

Call hidup()


Me.btn_hapus.Enabled = Fals

Me.btn_simpan.Enabled = True

Me.Txt_KodeSup.Text = ""

Me.Txt_NamaSup.Text = ""

Me.Txt_Alamat.Text = ""

Me.Txt_Email.Text = ""

End Sub



'--------------------------Input Lengkap------------

If Me.Txt_KodeSup.Text = "" Or Me.Txt_NamaSup.Text = "" Or Me.Txt_Alamat.Text = "" Or

Me.Txt_Negara.Text = "" Or Me.Txt_Telp.Text = "" Or Me.Txt_Fax.Text = "" Or Me.Txt_Email.Text =

"" Then


Exit Sub

End If

Try


tb_supplier(kode_supplier,nama_suplier,alamat,Email) values " & _

"('" & Me.Txt_KodeSup.Text & "','" & Me.Txt_NamaSup.Text & "','" & Me.Txt_Alamat.Text &

"','" & Me.Txt_Email.Text & "')"




Call hitung_baris()

brs = 0

Call tampil()



End Try

Call mati()





End Sub



Me.btn_tambah.Enabled = False

Call hidup()

End Sub



Try




65


Com_Hapus.CommandText = "DELETE FROM tb_supplier WHERE kode_supplier=" & _

"'" & Me.Txt_KodeSup.Text & "'"


End If

Call hitung_baris()

brs = 0

Call tampil()



End Try


End Sub

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

DG_Sup.Click




Try

brs = DG_Sup.CurrentCell.RowNumber

Call tampilteks()



End Try


End Sub

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

Button1.Click

Me.Close()

End Sub

End Class

Form Surat Jalan

Imports System.Data


Public Class Form_surat



'--------------------------Input Lengkap------------

If Me.Txt_NoSJ.Text = "" Or Me.Txt_NamaSopir.Text = "" Or Me.Txt_No_Kendaraan.Text = ""

Or Me.Txt_Hasil.Text = "" Or Me.Cmb_KodeKon.Text = "" Then


Exit Sub

End If

Try


tb_suratjln(no_surat,tg_surat,no_kontainer,no_kendaraan,nama_sopir,berat_kosong) values " & _

"('" & Me.Txt_NoSJ.Text & "','" & Format(Me.Dtp_Tgl.Value, "MM/dd/yyyy") & "','" &

Format(Me.Dtp_Jam.Value, "hh:mm") & "','" & Me.Cmb_KodeKon.Text & "','" &

Me.Txt_No_Kendaraan.Text & "','" & Me.Txt_NamaSopir.Text & "'," & Me.Txt_Hasil.Text & ")"


'MsgBox(simpanmaster)


MsgBox("Data Tersimpan", MsgBoxStyle.MsgBoxRight)

Call bersih()

Call sj_Oto()



End Try

End Sub

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

Handles MyBase.Load

66

Call koneksi()

Call Isi_KOn()

Call sj_Oto()

Me.Cmb_KodeKon.Select()

End Sub

Sub Isi_KOn()

Dim A As DataRow

da = New Data.OleDb.OleDbDataAdapter("SELECT no_kontainer From tb_kontainer", cn)

ds = New DataSet

da.Fill(ds)

Me.Cmb_KodeKon.Items.Clear()

For Each A In ds.Tables(0).Rows

Me.Cmb_KodeKon.Items.Add(A.Item(0))

Next

End Sub

Sub bersih()

Me.Cmb_KodeKon.Text = ""

Me.Txt_NamaSopir.Text = ""

Me.Txt_No_Kendaraan.Text = ""

Me.Txt_Hasil.Text = ""

Call sj_Oto()

End Sub

Sub sj_Oto()

Try

cmd = New OleDbCommand("SELECT

Max(Val(Right([tb_suratjln]![no_surat],(Len([tg_surat]![no_kendaraan)-3)))) AS Max_Number FROM

tb_suratjln", cn)

rd = cmd.ExecuteReader

rd.Read()

If rd.HasRows Then

'MsgBox(rd.GetValue(0))

Me.Txt_NoSJ.Text = "SJ-" & rd.GetValue(0) + 1

Else

Me.Txt_NoSJ.Text = "SJ-1"

End If



End Try

End Sub

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

Handles Btn_Print.Click

'--------------------------Input Lengkap------------

If Me.Txt_NoSJ.Text = "" Or Me.Txt_NamaSopir.Text = "" Or Me.Txt_No_Kendaraan.Text = ""

Or Me.Txt_Hasil.Text = "" Or Me.Cmb_KodeKon.Text = "" Then


Exit Sub

End If

Try


tb_suratjln(no_surat,tg_surat,no_kontainer,no_kendaraan,nama_sopir,berat_kosong)values " & _

"('" & Me.Txt_NoSJ.Text & "','" & Format(Me.Dtp_Tgl.Value, "MM/dd/yyyy") & "','" &

Me.Dtp_Jam.Text & "','" & Me.Cmb_KodeKon.Text & "','" & Me.Txt_No_Kendaraan.Text & "','" &

Me.Txt_NamaSopir.Text & "'," & Me.Txt_Hasil.Text & ")"


'MsgBox(simpanmaster)





End Try

Frm_Cetak_SJ.ShowDialog()

End Sub



End Sub

End Class

67

Form Transfer

Imports System.Data


Public Class Form_transfer

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

MyBase.Load

Call koneksi()

Call Isi_Dep()

Call Combo_Gudang()

Call combo_line()

Call Tk_Oto()

End Sub

Sub Isi_Dep()

Dim A As DataRow

da = New Data.OleDb.OleDbDataAdapter("SELECT kode_spining From tb_spining", cn)

ds = New DataSet

da.Fill(ds)

Me.Cmb_Dept.Items.Clear()

For Each A In ds.Tables(0).Rows

Me.Cmb_Dept.Items.Add(A.Item(0))

Next

End Sub

Sub Combo_Gudang()

Dim cmd As OleDbCommand = New OleDbCommand("Select kode_spining from tb_spining", cn)

cmd.CommandType = CommandType.Text

Dim adapter As OleDbDataAdapter = New OleDbDataAdapter(cmd)

Dim datatbl As DataTable = New DataTable

Dim ds As DataSet = New DataSet()

adapter.FillSchema(ds, SchemaType.Mapped, "kode_spining")

'Isi table

adapter.Fill(ds, "kode_spining")

datatbl = ds.Tables("kode_spining")

Dim listCol As DataGridViewComboBoxColumn = New DataGridViewComboBoxColumn()

listCol.DisplayIndex = 0

listCol.HeaderText = "Gdg"

listCol.DataPropertyName = "kode_spining"

listCol.DataSource = ds.Tables("kode_spining")

listCol.DisplayMember = "kode_spining"

DGV_TK.Columns.Add(listCol)

DGV_TK.Columns(4).Width = 50

End Sub

Sub combo_line()

Dim cmd1 As OleDbCommand = New OleDbCommand("Select kode_barang from tb_persediaan group

by kode_barang", cn)

cmd1.CommandType = CommandType.Text

Dim adapter As OleDbDataAdapter = New OleDbDataAdapter(cmd1)

Dim datatbl As DataTable = New DataTable

Dim ds As DataSet = New DataSet()

adapter.FillSchema(ds, SchemaType.Mapped, "kode_barang")

'Isi table

adapter.Fill(ds, "kode_barang")

datatbl = ds.Tables("kode_barang")

Dim listCol As DataGridViewComboBoxColumn = New DataGridViewComboBoxColumn()

listCol.DisplayIndex = 1

listCol.HeaderText = "kode_barang"

listCol.DataPropertyName = "kode_barang"

listCol.DataSource = ds.Tables("kode_barang")

listCol.DisplayMember = "kode_barang"

DGV_TK.Columns.Add(listCol)

DGV_TK.Columns(5).Width = 75

End Sub

Sub bersih()

Me.Cmb_Dept.Text = ""

DGV_TK.Rows.Clear()

68

End Sub

Sub Tk_Oto()

Try

cmd = New OleDbCommand("SELECT

Max(Val(Right([tb_transaksi]![no_bond],(Len([tg_bond]![kode_barang])-3)))) AS Max_Number FROM

tb_transaksi", cn)


rd.Read()

If rd.HasRows Then

'MsgBox(rd.GetValue(0))

Me.Txt_NoTK.Text = "TK-" & rd.GetValue(0) + 1

Else

Me.Txt_NoTK.Text = "TK-1"

End If



End Try

End Sub

Private Sub Cmb_Dept_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles Cmb_Dept.SelectedIndexChanged

da = New Data.OleDb.OleDbDataAdapter("SELECT * From tb_spining where kode_spining='" &

Me.Cmb_Dept.Text & "'", cn)

ds = New DataSet

da.Fill(ds)

'Me.Lbl_Dept.Text = ds.Tables(0).Rows(0).Item(1)

End Sub

Private Sub DGV_TK_CellContentClick(ByVal sender As System.Object, ByVal e As

System.Windows.Forms.DataGridViewCellEventArgs) Handles DGV_TK.CellContentClick

Dim A = Me.DGV_TK.RowCount - 1

Dim SqlKode = "SELECT * From tb_persediaan WHERE kode_barang= '" &

Me.DGV_TK.Rows(e.RowIndex).Cells(0).Value & "'"

If e.ColumnIndex = 0 Then

cmd = New OleDbCommand(SqlKode, cn)


rd.Read()

If rd.HasRows Then

DGV_TK.Rows(e.RowIndex).Cells(1).Value = rd.Item(1)

DGV_TK.Rows(e.RowIndex).Cells(2).Value = rd.Item(2)

DGV_TK.Rows(e.RowIndex).Cells(3).Value = 0

'MsgBox(DGV_TK.Rows(e.RowIndex).Cells(4).Value)

'DGV_TM.Rows(e.RowIndex).Cells(5).Value = "-"

Else

MsgBox("Kode barang tidak terdaftar!!!", MsgBoxStyle.Information)

End If

End If


cmd = New OleDbCommand("SELECT Q_In_Out_Jadi.kode_spining, Q_In_Out_Jadi.kode_barang,

='" & Me.DGV_TK.Rows(e.RowIndex).Cells(4).Value & "'", cn)


rd.Read()

If rd.HasRows Then

Me.DGV_TK.Rows(e.RowIndex).Cells(0).ReadOnly = False


Else

MsgBox("Barang gudang tidak tersedia!!!", MsgBoxStyle.Information)

Me.DGV_TK.Rows(e.RowIndex).Cells(0).ReadOnly = True


End If

End If


cmd = New OleDbCommand("SELECT Q_In_Out_Jadi.kode_spining, Q_In_Out_Jadi.kode_barang,

='" & Me.DGV_TK.Rows(e.RowIndex).Cells(4).Value & "'", cn)


rd.Read()

If rd.HasRows Then


Else

69

MsgBox("Barang gudang tidak tersedia!!!", MsgBoxStyle.Information)


End If

End If

End Sub



If Me.Cmb_Dept.Text = "" Or DGV_TK.Rows(0).Cells(1).Value = "" Then

MsgBox("Input Data Belum Lengkap")

Exit Sub

End If

'==============Simpan ke trans masuk

Dim simpanmaster As String = "Insert into tb_transaksi(no_bond,tg_bond,kode_spining)

values " & _

"('" & Me.Txt_NoTK.Text & "','" & Format(Me.Dtp_Tgl.Value, "dd/MM/yyyy") & "','" &

Me.Cmb_Dept.Text & "')"



'==============Simpan ke detail masuk

For baris As Integer = 0 To DGV_TK.Rows.Count - 2

Dim sqlsimpan As String = "Insert into

tb_transaksi(no_bond,kode_bond,jumlah_Keluar,kode_spining) values " & _

"('" & Me.Txt_NoTK.Text & "','" & DGV_TK.Rows(baris).Cells(0).Value & "','" &

DGV_TK.Rows(baris).Cells(3).Value & "','" & DGV_TK.Rows(baris).Cells(4).Value & "','" &

DGV_TK.Rows(baris).Cells(5).Value & "')"

cmd = New OleDbCommand(sqlsimpan, cn)

' MsgBox(sqlsimpan)


Next baris

MsgBox("Data Telah Tersimpan!!!", MsgBoxStyle.Information)

bersih()

Call Tk_Oto()

End Sub



Me.Close()

End Sub

End Class

70

Form Utama

Public Class Form_utama

Private Sub ShowNewForm(ByVal sender As Object, ByVal e As EventArgs)

' Create a new instance of the child form.

Dim ChildForm As New System.Windows.Forms.Form

' Make it a child of this MDI form before showing it.

ChildForm.MdiParent = Me

'm_ChildFormNumber += 1

'ChildForm.Text = "Window " & m_ChildFormNumber

ChildForm.Show()

End Sub


Button3.Click

Form_departemen.Show()

End Sub


Button1.Clic

Form_suplier.Show()

End Sub


Button2.Click

Form_surat.Show()

End Sub


Button4.Click

Form_stock.Show()

End Sub


Button5.Click

Form_penerimaan.Show()

End Sub

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

Handles FRM_UTAMA.Click

Form_reuse.Show()

End Sub

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

MyBase.Load

End Sub

Private Sub ContainerToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles ContainerToolStripMenuItem.Click

Form_kontainer.Show()

End Sub

Private Sub CekStokToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs)

End Sub

Private Sub BarangToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles BarangToolStripMenuItem.Click

Form_stock.Show()

End Sub

Private Sub ReturToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles ReturToolStripMenuItem.Click

Form_retur.Show()

End Sub

Private Sub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As

System.EventArgs) Handles ExitToolStripMenuItem.Click

71

Me.Close()

End Sub

End Class

lampiran i. struktur organisasi -...

Documents