media belajar vb.net online & bimbingan tugas akhir - skripsi program penjualan dan... · 2020....
Post on 27-Oct-2020
6 Views
Preview:
TRANSCRIPT
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Aplikasi Penawaran Harga dan Penjualan VB.Net
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
TBLPerusahaan
Name Type Size Keterangan
ID_Perusahaan Text 2 Primary key
Nama Text 100
Alamat Text 100
Telepon Text 50
Fax Text 50
Email Text 50
website Text 50
Kota Text 50
TBLUser
Name Type Size Keterangan
ID_User Text 5 Primary key
Nama_User Text 30
Pwd_User Text 10
Jabatan Text 15
TBLCustomer
Name Type Size Keterangan
ID_Customer Text 255 Primary key
Nama_Customer Text 40
Alamat_Customer Text 40
Telepon_Customer Text 20
Fax_Customer Text 15
Email_Customer Text 30
Contact_Person Text 30
TBLPenawaran
Name Type Size Keterangan
ID_Penawaran Text 16 Primary key
Tanggal_Penawaran Date/Time 8
ID_Customer Text 5 Foreign key
Harga_Penawaran Long Integer 4
Pajak_Penawaran Long Integer 4
Total_awal_penawaran Long Integer 4
Diskon_Penawaran Long Integer 4
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Total_Akhir_Penawaran Long Integer 4
Status_Penawaran Text 20
Keterangan_Penawaran Text 100
ID_User Text 5 Foreign key
ID_Perusahaan Text 2 Foreign key
TBLPenawaranDetail
Name Type Size Keterangan
ID_Penawaran Text 16 Foreign key
Deskripsi_Penawaran Text 100
Unit_Penawaran Text 15
Harga_Penawaran Long Integer 4
Jumlah_Penawaran Long Integer 4
Subtotal_Penawaran Long Integer 4
TBLPenjualan
Name Type Size Keterangan
ID_Penjualan Text 16 Primary key
Tanggal_Penjualan Date/Time 8
ID_Penawaran Text 16 Foreign key
Nomor_PO Text 16
Harga_Penjualan Long Integer 4
Pajak_Penjualan Long Integer 4
Total_Awal_Penjualan Long Integer 4
Diskon_Penjualan Long Integer 4
Total_Akhir_Penjualan Long Integer 4
Status_Penjualan Text 20
Keterangan_Penjualan Text 100
ID_User Text 5 Foreign key
ID_Perusahaan Text 2 Foreign key
TBLPenjualanDetail
Name Type Size Keterangan
ID_Penjualan Text 16 Foreign key
Deskripsi_Penjualan Text 100
Unit_Penjualan Text 15
Harga_Penjualan Long Integer 4
Jumlah_Penjualan Long Integer 4
Subtotal_Penjualan Long Integer 4
ID_Surat_Jalan Text 16 Foreign key
ID_Invoice Text 16 Foreign key
ID_Pembayaran Text 16 Foreign key
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
TBLSuratJalan
Name Type Size Keterangan
ID_Surat_Jalan Text 16 Primary key
Tanggal_Surat_Jalan Date/Time 8
ID_Penjualan Text 16 Foreign key
Status_Surat_Jalan Text 15
Keterangan_Surat_Jalan Text 100
ID_User Text 5 Foreign key
ID_Perusahaan Text 2 Foreign key
TBLInvoice
Name Type Size Keterangan
ID_Invoice Text 16 Primary key
Tanggal_Invoice Date/Time 8
ID_Surat_Jalan Text 16 Foreign key
Harga_Invoice Long Integer 4
Pajak_Invoice Long Integer 4
Total_Awal_Invoice Long Integer 4
Diskon_Invoice Long Integer 4
Total_Akhir_Invoice Long Integer 4
Status_Invoice Text 20
Keterangan_Invoice Text 100
ID_User Text 5
ID_Perusahaan Text 2
TBLPembayaran
Name Type Size Keterangan
ID_Pembayaran Text 16 Primary key
Tanggal_Pembayaran Date/Time 8
ID_Invoice Text 16 Foreign key
Nomor_PO Text 16
Harga_Pembayaran Long Integer 4
Pajak_Pembayaran Long Integer 4
Total_Awal_Pembayaran Long Integer 4
Diskon_Pembayaran Long Integer 4
Total_Akhir_Pembayaran Long Integer 4
Status_Pembayaran Text 20
Keterangan_Pembayaran Text 100
Terbilang Memo -
ID_User Text 5 Foreign key
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
ID_Perusahaan Text 2 Foreign key
TblLabaRugi
Name Type Size Keterangan
Nomor Autuincreament Long Integer Primary Key
Tanggal Date/Time 8
Keterangan Text 255
Pemasukan Long Integer 4
Pengeluaran Long Integer 4
Id_User Text 5 Foreign key
Nomor_Transaksi Text 16
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
unnormal
ID_Perusahaan ID_User
Nama ID_Perusahaan
Alamat ID_Penjualan
Telepon Deskripsi_Penjualan
Fax Unit_Penjualan
Email Harga_Penjualan
website Jumlah_Penjualan
Kota Subtotal_Penjualan
ID_User ID_Surat_Jalan
Nama_User ID_Invoice
Pwd_User ID_Pembayaran
Jabatan ID_Surat_Jalan
ID_Customer Tanggal_Surat_Jalan
Nama_Customer ID_Penjualan
Alamat_Customer Status_Surat_Jalan
Telepon_Customer Keterangan_Surat_Jalan
Fax_Customer ID_User
Email_Customer ID_Perusahaan
Contact_Person ID_Invoice
ID_Penawaran Tanggal_Invoice
Tanggal_Penawaran ID_Surat_Jalan
ID_Customer Harga_Invoice
Harga_Penawaran Pajak_Invoice
Pajak_Penawaran Total_Awal_Invoice
Total_awal_penawaran Diskon_Invoice
Diskon_Penawaran Total_Akhir_Invoice
Total_Akhir_Penawaran Status_Invoice
Status_Penawaran Keterangan_Invoice
Keterangan_Penawaran ID_User
ID_User ID_Perusahaan
ID_Perusahaan ID_Pembayaran
ID_Penawaran Tanggal_Pembayaran
Deskripsi_Penawaran ID_Invoice
Unit_Penawaran Nomor_PO
Harga_Penawaran Harga_Pembayaran
Jumlah_Penawaran Pajak_Pembayaran
Subtotal_Penawaran Total_Awal_Pembayaran
ID_Penjualan Diskon_Pembayaran
Tanggal_Penjualan Total_Akhir_Pembayaran
ID_Penawaran Status_Pembayaran
Nomor_PO Keterangan_Pembayaran
Harga_Penjualan Terbilang
Pajak_Penjualan ID_User
Total_Awal_Penjualan ID_Perusahaan
Diskon_Penjualan Nomor
Total_Akhir_Penjualan Tanggal
Status_Penjualan Keterangan
Keterangan_Penjualan Pemasukan Pengeluaran
Id_User
Nomor_Transaksi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
normal 1
ID_Perusahaan * Nama Alamat Telepon Fax Email website Kota ID_User * Nama_User Pwd_User Jabatan ID_Customer * Nama_Customer Alamat_Customer Telepon_Customer Fax_Customer Email_Customer Contact_Person ID_Penawaran * Tanggal_Penawaran Harga_Penawaran Pajak_Penawaran Total_awal_penawaran Diskon_Penawaran Total_Akhir_Penawaran Status_Penawaran Keterangan_Penawaran Deskripsi_Penawaran Unit_Penawaran Harga_Penawaran Jumlah_Penawaran Subtotal_Penawaran ID_Penjualan * Tanggal_Penjualan Nomor_PO Harga_Penjualan Pajak_Penjualan Total_Awal_Penjualan Diskon_Penjualan Total_Akhir_Penjualan Status_Penjualan Keterangan_Penjualan Deskripsi_Penjualan Unit_Penjualan Harga_Penjualan Jumlah_Penjualan Subtotal_Penjualan
ID_Surat_Jalan * Tanggal_Surat_Jalan Status_Surat_Jalan Keterangan_Surat_Jalan ID_Invoice * Tanggal_Invoice Harga_Invoice Pajak_Invoice Total_Awal_Invoice Diskon_Invoice Total_Akhir_Invoice Status_Invoice Keterangan_Invoice ID_Pembayaran * Tanggal_Pembayaran Harga_Pembayaran Pajak_Pembayaran Total_Awal_Pembayaran Diskon_Pembayaran Total_Akhir_Pembayaran Status_Pembayaran Keterangan_Pembayaran Terbilang Nomor * Tanggal Keterangan Pemasukan Pengeluaran Nomor_Transaksi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
normal 2
ID_Perusahaan * Nama Alamat Telepon Fax Email website Kota
ID_User * Nama_User Pwd_User Jabatan
ID_Customer * Nama_Customer Alamat_Customer Telepon_Customer Fax_Customer Email_Customer Contact_Person
ID_Penawaran * Tanggal_Penawaran ID_Customer ** Harga_Penawaran Pajak_Penawaran Total_awal_penawaran Diskon_Penawaran Total_Akhir_Penawaran Status_Penawaran Keterangan_Penawaran ID_User ** ID_Perusahaan ** Deskripsi_Penawaran Unit_Penawaran Harga_Penawaran Jumlah_Penawaran Subtotal_Penawaran
ID_Penjualan * Tanggal_Penjualan ID_Penawaran ** Nomor_PO Harga_Penjualan Pajak_Penjualan Total_Awal_Penjualan Diskon_Penjualan Total_Akhir_Penjualan Status_Penjualan Keterangan_Penjualan ID_User ** ID_Perusahaan ** Deskripsi_Penjualan Unit_Penjualan Harga_Penjualan Jumlah_Penjualan Subtotal_Penjualan ID_Surat_Jalan * ID_Invoice ** ID_Pembayaran ** Tanggal_Surat_Jalan ID_Penjualan ** Status_Surat_Jalan Keterangan_Surat_Jalan ID_User ** ID_Perusahaan **
ID_Invoice * Tanggal_Invoice ID_Surat_Jalan ** Harga_Invoice Pajak_Invoice Total_Awal_Invoice Diskon_Invoice Total_Akhir_Invoice Status_Invoice Keterangan_Invoice ID_User ** ID_Perusahaan **
ID_Pembayaran * Tanggal_Pembayaran ID_Invoice * Nomor_PO Harga_Pembayaran Pajak_Pembayaran Total_Awal_Pembayaran Diskon_Pembayaran Total_Akhir_Pembayaran Status_Pembayaran Keterangan_Pembayaran Terbilang ID_User ** ID_Perusahaan ** Nomor * Tanggal Keterangan Pemasukan Pengeluaran Id_User ** Nomor_Transaksi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
normal 3
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR1Penawaran
Dim romawi As String
Sub Notis()
If Month(Ttanggal.Text) = 1 Then
romawi = "I"
ElseIf Month(Ttanggal.Text) = 2 Then
romawi = "II"
ElseIf Month(Ttanggal.Text) = 3 Then
romawi = "III"
ElseIf Month(Ttanggal.Text) = 4 Then
romawi = "IV"
ElseIf Month(Ttanggal.Text) = 5 Then
romawi = "V"
ElseIf Month(Ttanggal.Text) = 6 Then
romawi = "VI"
ElseIf Month(Ttanggal.Text) = 7 Then
romawi = "VII"
ElseIf Month(Ttanggal.Text) = 8 Then
romawi = "VIII"
ElseIf Month(Ttanggal.Text) = 9 Then
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
romawi = "IX"
ElseIf Month(Ttanggal.Text) = 10 Then
romawi = "X"
ElseIf Month(Ttanggal.Text) = 11 Then
romawi = "XI"
ElseIf Month(Ttanggal.Text) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_penawaran,4) &
mid(Tanggal_penawaran,4,2) &left(id_penawaran,2) as ketemu from
tblpenawaran order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
tid.Text = "01/SPH/" + romawi + "/" +
Microsoft.VisualBasic.Right(Ttanggal.Text, 4)
tcoba.Text = Year(Ttanggal.Text) &
Month(Ttanggal.Text)
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6)
= Format(Today, "yyyyMM") Then
tid.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/SPH/" + romawi + "/" +
Microsoft.VisualBasic.Right(Ttanggal.Text, 4)
tcoba.Text = Year(Ttanggal.Text) &
Month(Ttanggal.Text)
Else
tid.Text = "01/SPH/" + romawi + "/" +
Microsoft.VisualBasic.Right(Ttanggal.Text, 4)
tcoba.Text = Year(Ttanggal.Text) &
Month(Ttanggal.Text)
End If
End If
End Sub
Sub Bersihkan()
ComboBox1.Text = ""
DGV.Rows.Clear()
Tharga.Text = 0
Tpajak.Text = 0
Tdiskon.Text = 0
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
TTotalawal.Text = 0
Ttotalahir.Text = 0
Tcustomer.Clear()
tketerangan.Text = "Keterangan"
End Sub
Sub HitungHarga()
On Error Resume Next
Dim x As Double = 0
For baris As Integer = 0 To DGV.RowCount - 1
x = x + DGV.Rows(baris).Cells("Total").Value
Next
Tharga.Text = FormatNumber(x, 0)
Tpajak.Text = Val(Microsoft.VisualBasic.Str(Tharga.Text)
* 10) / 100
Tpajak.Text = FormatNumber(Tpajak.Text, 0)
TTotalawal.Text =
Val(Microsoft.VisualBasic.Str(Tharga.Text)) +
Val(Microsoft.VisualBasic.Str(Tpajak.Text))
TTotalawal.Text = FormatNumber(TTotalawal.Text, 0)
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text))
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End Sub
Sub HitungTotal()
TTotalawal.Text =
Val(Microsoft.VisualBasic.Str(Tharga.Text)) +
Val(Microsoft.VisualBasic.Str(Tpajak.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
End Sub
Private Sub TR1Penawaran_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Me.CenterToScreen()
Call Bersihkan()
Call Koneksi()
CMD = New OleDbCommand("select * from tblcustomer",
Conn)
DR = CMD.ExecuteReader
ComboBox1.Items.Clear()
Do While DR.Read
ComboBox1.Items.Add(DR(0))
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Loop
Ttanggal.Text = Format(Today, "dd-MMMM-yyyy")
Call Notis()
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
CMD = New OleDbCommand("select * from tblcustomer where
id_customer='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tcustomer.Text = "Nama: " & DR(1) & " " & DR(2) &
vbCrLf & "Telp/Fax: " & DR(3) & " " & DR(4) & vbCrLf & "Email: "
& DR(5) & vbCrLf & "Contact Person: " & DR(6)
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Call Bersihkan()
End Sub
Private Sub DGV_CellEndEdit(ByVal sender As Object, ByVal e
As System.Windows.Forms.DataGridViewCellEventArgs) Handles
DGV.CellEndEdit
Try
If e.ColumnIndex = 0 Then 'keterangan
DGV.Rows(e.RowIndex).Cells(0).Value =
UCase(DGV.Rows(e.RowIndex).Cells(0).Value)
DGV.CurrentCell = DGV(1,
DGV.CurrentCell.RowIndex)
SendKeys.Send("{up}")
End If
If e.ColumnIndex = 1 Then 'satuan
DGV.Rows(e.RowIndex).Cells(1).Value =
UCase(DGV.Rows(e.RowIndex).Cells(1).Value)
DGV.CurrentCell = DGV(2,
DGV.CurrentCell.RowIndex)
SendKeys.Send("{up}")
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
End If
If e.ColumnIndex = 2 Then 'harga satuan
DGV.Rows(e.RowIndex).Cells(2).Value =
FormatNumber(DGV.Rows(e.RowIndex).Cells(2).Value, 0)
DGV.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.CurrentCell = DGV(3,
DGV.CurrentCell.RowIndex)
SendKeys.Send("{up}")
End If
If e.ColumnIndex = 3 Then 'jumlah
DGV.Rows(e.RowIndex).Cells(3).Value =
FormatNumber(DGV.Rows(e.RowIndex).Cells(3).Value, 0)
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Rows(e.RowIndex).Cells(4).Value =
DGV.Rows(e.RowIndex).Cells(2).Value *
DGV.Rows(e.RowIndex).Cells(3).Value
DGV.Rows(e.RowIndex).Cells(4).Value =
FormatNumber(DGV.Rows(e.RowIndex).Cells(4).Value, 0)
DGV.Columns(4).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.CurrentCell = DGV(0,
DGV.CurrentCell.RowIndex)
End If
Call HitungHarga()
Catch ex As Exception
MsgBox("Ada kesalahan, cek kembali isian data..")
MsgBox(ex.Message)
End Try
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
Private Sub DGV_KeyDown(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyEventArgs) Handles DGV.KeyDown
On Error Resume Next
If e.KeyCode = Keys.Escape Then
DGV.Rows.RemoveAt(DGV.CurrentCell.RowIndex)
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Call HitungHarga()
Tdiskon.Text = 0
Ttotalahir.Text = 0
End If
End Sub
Private Sub Tdiskon_KeyDown(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyEventArgs) Handles Tdiskon.KeyDown
On Error Resume Next
If e.KeyCode = Keys.Enter Then
If Not IsNumeric(Tdiskon.Text) Then
MsgBox("harus angka")
Tdiskon.Text = 0
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
Exit Sub
Else
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
End If
Tdiskon.Text = FormatNumber(Tdiskon.Text, 0)
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End If
End Sub
Private Sub TTanggal_ValueChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs)
Call Notis()
End Sub
Private Sub Tdiskon_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Tdiskon.TextChanged
On Error Resume Next
Tdiskon.Text = FormatNumber(Tdiskon.Text, 0)
Tdiskon.SelectionStart = Len(Tdiskon.Text)
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR2Penjualan
Dim romawi As String
Sub Notis()
If Month(Today) = 1 Then
romawi = "I"
ElseIf Month(Today) = 2 Then
romawi = "II"
ElseIf Month(Today) = 3 Then
romawi = "III"
ElseIf Month(Today) = 4 Then
romawi = "IV"
ElseIf Month(Today) = 5 Then
romawi = "V"
ElseIf Month(Today) = 6 Then
romawi = "VI"
ElseIf Month(Today) = 7 Then
romawi = "VII"
ElseIf Month(Today) = 8 Then
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
romawi = "VIII"
ElseIf Month(Today) = 9 Then
romawi = "IX"
ElseIf Month(Today) = 10 Then
romawi = "X"
ElseIf Month(Today) = 11 Then
romawi = "XI"
ElseIf Month(Today) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_penjualan ,4) &
mid(Tanggal_penjualan,4,2) &left(id_penjualan,2) as ketemu from
tblpenjualan order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
tid.Text = "01/PJL/" + romawi + Format(Today,
"/yyyy")
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6)
= Format(Today, "yyyyMM") Then
tid.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/PJL/" + romawi + Format(Today, "/yyyy")
Else
tid.Text = "01/PJL/" + romawi + Format(Today,
"/yyyy")
End If
End If
End Sub
Sub Bersihkan()
ComboBox1.Text = ""
DGV.Columns.Clear()
Tharga.Text = 0
Tpajak.Text = 0
Tdiskon.Text = 0
TTotalawal.Text = 0
Ttotalahir.Text = 0
Tcustomer.Clear()
tnomorPO.Clear()
Tidcustomer.Text = ""
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
tketerangan.Text = "Keterangan"
Call TampilPenawaran()
End Sub
Sub HitungHarga()
On Error Resume Next
Dim x As Double = 0
For baris As Integer = 0 To DGV.RowCount - 1
x = x +
Val(Microsoft.VisualBasic.Str(DGV.Rows(baris).Cells(5).Value))
Next
Tharga.Text = FormatNumber(x, 0)
Tdiskon.Text = 0
Tpajak.Text = Val(Microsoft.VisualBasic.Str(Tharga.Text)
* 10) / 100
Tpajak.Text = FormatNumber(Tpajak.Text, 0)
TTotalawal.Text =
Val(Microsoft.VisualBasic.Str(Tharga.Text)) +
Val(Microsoft.VisualBasic.Str(Tpajak.Text))
TTotalawal.Text = FormatNumber(TTotalawal.Text, 0)
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text))
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End Sub
Sub HitungTotal()
TTotalawal.Text = Val(Tharga.Text) + Val(Tpajak.Text) -
Val(Tdiskon.Text)
End Sub
Sub TampilPenawaran()
CMD = New OleDbCommand("select ID_PENAWARAN from
tblPENAWARAN WHERE STATUS_penawaran='OPEN'", Conn)
DR = CMD.ExecuteReader
ComboBox1.Items.Clear()
Do While DR.Read
ComboBox1.Items.Add(DR(0))
Loop
End Sub
Private Sub TR1Penawaran_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Me.CenterToScreen()
Call Koneksi()
Call Bersihkan()
Call TampilPenawaran()
Call Notis()
Ttanggal.Text = Format(Today, "dd-MMMM-yyyy")
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
CMD = New OleDbCommand("select * from tblpenawaran where
id_penawaran='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidcustomer.Text = DR("id_customer")
Tharga.Text = FormatNumber(DR("harga_penawaran"), 0)
Tpajak.Text = FormatNumber(DR("pajak_penawaran"), 0)
TTotalawal.Text =
FormatNumber(DR("total_awal_penawaran"), 0)
Tdiskon.Text = FormatNumber(DR("diskon_penawaran"),
0)
Ttotalahir.Text =
FormatNumber(DR("total_akhir_penawaran"), 0)
CMD = New OleDbCommand("select * from tblcustomer
where id_customer='" & Tidcustomer.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tcustomer.Text = "Nama: " & DR(1) & " " & DR(2)
& vbCrLf & "Telp/Fax: " & DR(3) & " " & DR(4) & vbCrLf & "Email:
" & DR(5) & vbCrLf & "Contact Person: " & DR(6)
End If
Dim baris As Integer = DGV.RowCount - 2
DA = New OleDbDataAdapter("select * from
tblpenawarandetail where id_penawaran='" & ComboBox1.Text & "'",
Conn)
DS = New DataSet
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
DA.Fill(DS)
DGV.DataSource = DS.Tables(0)
DGV.Columns(3).DefaultCellStyle.Format = "#,0"
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(4).DefaultCellStyle.Format = "#,0"
DGV.Columns(4).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter
DGV.Columns(5).DefaultCellStyle.Format = "#,0"
DGV.Columns(5).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(0).Visible = False '
DGV.Columns(1).Width = 250
DGV.Columns(1).HeaderText = "Keterangan"
DGV.Columns(2).HeaderText = "Unit"
DGV.Columns(3).HeaderText = "Harga Satuan"
DGV.Columns(4).HeaderText = "Jumlah"
DGV.Columns(5).HeaderText = "Total"
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Call Bersihkan()
End Sub
Private Sub DGV_CellEndEdit(ByVal sender As Object, ByVal e
As System.Windows.Forms.DataGridViewCellEventArgs) Handles
DGV.CellEndEdit
'Try
If e.ColumnIndex = 1 Then 'keterangan
DGV.Rows(e.RowIndex).Cells(0).Value = ComboBox1.Text
DGV.Rows(e.RowIndex).Cells(1).Value =
UCase(DGV.Rows(e.RowIndex).Cells(1).Value)
DGV.CurrentCell = DGV(2, DGV.CurrentCell.RowIndex)
SendKeys.Send("{up}")
End If
If e.ColumnIndex = 2 Then 'satuan
DGV.Rows(e.RowIndex).Cells(2).Value =
UCase(DGV.Rows(e.RowIndex).Cells(2).Value)
DGV.CurrentCell = DGV(3, DGV.CurrentCell.RowIndex)
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
SendKeys.Send("{up}")
End If
If e.ColumnIndex = 3 Then 'harga satuan
On Error Resume Next
DGV.Rows(e.RowIndex).Cells(5).Value =
DGV.Rows(e.RowIndex).Cells(3).Value *
DGV.Rows(e.RowIndex).Cells(4).Value
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.CurrentCell = DGV(4, DGV.CurrentCell.RowIndex)
SendKeys.Send("{up}")
End If
If e.ColumnIndex = 4 Then 'jumlah
DGV.Rows(e.RowIndex).Cells(5).Value =
DGV.Rows(e.RowIndex).Cells(3).Value *
DGV.Rows(e.RowIndex).Cells(4).Value
DGV.CurrentCell = DGV(1, DGV.CurrentCell.RowIndex)
End If
Call HitungHarga()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
Private Sub DGV_KeyDown(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyEventArgs) Handles DGV.KeyDown
On Error Resume Next
If e.KeyCode = Keys.Escape Then
DGV.Rows.RemoveAt(DGV.CurrentCell.RowIndex)
Call HitungHarga()
Tdiskon.Text = 0
Ttotalahir.Text = 0
End If
End Sub
Private Sub Tdiskon_KeyDown(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyEventArgs) Handles Tdiskon.KeyDown
On Error Resume Next
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
If e.KeyCode = Keys.Enter Then
If Not IsNumeric(Tdiskon.Text) Then
MsgBox("harus angka")
Tdiskon.Text = 0
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
Exit Sub
Else
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
End If
Tdiskon.Text = FormatNumber(Tdiskon.Text, 0)
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End If
End Sub
Private Sub Tdiskon_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Tdiskon.TextChanged
On Error Resume Next
Tdiskon.Text = FormatNumber(Tdiskon.Text, 0)
Tdiskon.SelectionStart = Len(Tdiskon.Text)
Ttotalahir.Text =
Val(Microsoft.VisualBasic.Str(TTotalawal.Text)) -
Val(Microsoft.VisualBasic.Str(Tdiskon.Text))
Ttotalahir.Text = FormatNumber(Ttotalahir.Text, 0)
End Sub
Private Sub TTanggal_ValueChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs)
Call Notis()
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR3SuratJalan
Dim romawi As String
Sub Notis()
If Month(Today) = 1 Then
romawi = "I"
ElseIf Month(Today) = 2 Then
romawi = "II"
ElseIf Month(Today) = 3 Then
romawi = "III"
ElseIf Month(Today) = 4 Then
romawi = "IV"
ElseIf Month(Today) = 5 Then
romawi = "V"
ElseIf Month(Today) = 6 Then
romawi = "VI"
ElseIf Month(Today) = 7 Then
romawi = "VII"
ElseIf Month(Today) = 8 Then
romawi = "VIII"
ElseIf Month(Today) = 9 Then
romawi = "IX"
ElseIf Month(Today) = 10 Then
romawi = "X"
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
ElseIf Month(Today) = 11 Then
romawi = "XI"
ElseIf Month(Today) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_surat_jalan,4) &
mid(Tanggal_surat_jalan,4,2) &left(id_surat_jalan ,2) as ketemu
from tblsuratjalan order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
tid.Text = "01/SJL/" + romawi + Format(Today,
"/yyyy")
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6)
= Format(Today, "yyyyMM") Then
tid.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/SJL/" + romawi + Format(Today, "/yyyy")
Else
tid.Text = "01/SJL/" + romawi + Format(Today,
"/yyyy")
End If
End If
End Sub
Sub Bersihkan()
ComboBox1.Text = ""
tidpenawaran.Text = ""
DGV.Columns.Clear()
Tcustomer.Clear()
tnomorpo.Clear()
Tidcustomer.Text = ""
tketerangan.Text = "Keterangan"
Call TampilPenjualan()
End Sub
Sub TampilPenjualan()
CMD = New OleDbCommand("select ID_Penjualan from
tblPenjualan WHERE STATUS_penjualan='OPEN'", Conn)
DR = CMD.ExecuteReader
ComboBox1.Items.Clear()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Do While DR.Read
ComboBox1.Items.Add(DR(0))
Loop
End Sub
Private Sub TR3SuratJalan_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CenterToScreen()
Call Koneksi()
Call Bersihkan()
Call TampilPenjualan()
Call Notis()
Ttanggal.Text = Format(Today, "dd-MMMM-yyyy")
DGV.ReadOnly = True
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
CMD = New OleDbCommand("select * from tblpenjualan where
id_penjualan='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
tidpenawaran.Text = DR("id_penawaran")
tnomorpo.Text = DR("nomor_po")
'================================
CMD = New OleDbCommand("select * from tblpenawaran
where id_penawaran='" & tidpenawaran.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidcustomer.Text = DR("id_customer")
End If
CMD = New OleDbCommand("select * from tblcustomer
where id_customer='" & Tidcustomer.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Tcustomer.Text = "Nama: " & DR(1) & " " & DR(2)
& vbCrLf & "Telp/Fax: " & DR(3) & " " & DR(4) & vbCrLf & "Email:
" & DR(5) & vbCrLf & "Contact Person: " & DR(6)
End If
DA = New OleDbDataAdapter("select * from
tblpenjualandetail where id_penjualan='" & ComboBox1.Text & "'",
Conn)
DS = New DataSet
DA.Fill(DS)
DGV.DataSource = DS.Tables(0)
DGV.ReadOnly = True
'================
DGV.Columns(0).Visible = False
DGV.Columns(1).Width = 250
DGV.Columns(1).HeaderText = "Keterangan"
DGV.Columns(2).HeaderText = "Unit"
DGV.Columns(3).HeaderText = "Harga Satuan"
DGV.Columns(4).HeaderText = "Jumlah"
DGV.Columns(5).HeaderText = "Total"
DGV.Columns(3).DefaultCellStyle.Format = "#,0"
DGV.Columns(4).DefaultCellStyle.Format = "#,0"
DGV.Columns(5).DefaultCellStyle.Format = "#,0"
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(4).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter
DGV.Columns(5).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Call Bersihkan()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Private Sub TTanggal_ValueChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs)
Call Notis()
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR4Invoice
Dim romawi As String
Sub Notis()
If Month(Today) = 1 Then
romawi = "I"
ElseIf Month(Today) = 2 Then
romawi = "II"
ElseIf Month(Today) = 3 Then
romawi = "III"
ElseIf Month(Today) = 4 Then
romawi = "IV"
ElseIf Month(Today) = 5 Then
romawi = "V"
ElseIf Month(Today) = 6 Then
romawi = "VI"
ElseIf Month(Today) = 7 Then
romawi = "VII"
ElseIf Month(Today) = 8 Then
romawi = "VIII"
ElseIf Month(Today) = 9 Then
romawi = "IX"
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
ElseIf Month(Today) = 10 Then
romawi = "X"
ElseIf Month(Today) = 11 Then
romawi = "XI"
ElseIf Month(Today) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_invoice ,4) &
mid(Tanggal_invoice,4,2) &left(id_invoice,2) as ketemu from
tblinvoice order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
tid.Text = "01/INV/" + romawi + Format(Today,
"/yyyy")
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 5)
Or Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6) =
Format(Today, "yyyyMM") Then
tid.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/INV/" + romawi + Format(Today, "/yyyy")
Else
tid.Text = "01/INV/" + romawi + Format(Today,
"/yyyy")
End If
End If
End Sub
Sub Bersihkan()
ComboBox1.Text = ""
DGV.Columns.Clear()
Tharga.Text = 0
Tpajak.Text = 0
Tdiskon.Text = 0
TTotalawal.Text = 0
Ttotalahir.Text = 0
Tcustomer.Clear()
tnomorpo.Clear()
Tidcustomer.Text = ""
tketerangan.Text = "Keterangan"
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Call Tampilsuratjalan()
End Sub
Sub HitungHarga()
On Error Resume Next
Dim x As Integer = 0
For baris As Integer = 0 To DGV.RowCount - 1
x = x + DGV.Rows(baris).Cells("Total").Value
Next
Tharga.Text = x
Tpajak.Text = Val(Tharga.Text) * 10 / 100
TTotalawal.Text = Val(Tharga.Text) + Val(Tpajak.Text)
Ttotalahir.Text = TTotalawal.Text
End Sub
Sub HitungTotal()
TTotalawal.Text = Val(Tharga.Text) + Val(Tpajak.Text) -
Val(Tdiskon.Text)
End Sub
Sub Norutis()
Dim baris As Integer = DGV.RowCount - 1
If DGV.RowCount - 1 = 0 Then
DGV.Rows(baris).Cells(0).Value = 1
Else
DGV.Rows(baris).Cells(0).Value = DGV.RowCount
End If
End Sub
Sub Tampilsuratjalan()
CMD = New OleDbCommand("select ID_surat_jalan from
tblsuratjalan WHERE STATUS_surat_jalan='OPEN'", Conn)
DR = CMD.ExecuteReader
ComboBox1.Items.Clear()
Do While DR.Read
ComboBox1.Items.Add(DR(0))
Loop
End Sub
Private Sub TR4Invoice_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
Me.CenterToScreen()
Call Koneksi()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Call Bersihkan()
Call Tampilsuratjalan()
Call Notis()
TTanggal.Text = Format(Today, "dd-MMMM-yyyy")
DGV.ReadOnly = True
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
CMD = New OleDbCommand("select * from tblsuratjalan
where id_surat_jalan='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidpenjualan.Text = DR("id_penjualan")
CMD = New OleDbCommand("select
tblpenjualan.id_penjualan,tblpenjualan.Nomor_po,tblcustomer.id_c
ustomer from tblpenawaran,tblpenjualan,tblsuratjalan,tblcustomer
where tblcustomer.id_customer=tblpenawaran.id_customer and
tblpenjualan.id_penjualan=tblsuratjalan.id_penjualan and
tblsuratjalan.id_surat_jalan='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidpenjualan.Text = DR("id_penjualan")
tnomorpo.Text = DR("nomor_PO")
Tidcustomer.Text = DR("id_customer")
End If
CMD = New OleDbCommand("select * from tblpenjualan
where id_penjualan='" & Tidpenjualan.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tharga.Text =
FormatNumber(DR("harga_penjualan"), 0)
Tpajak.Text =
FormatNumber(DR("pajak_penjualan"), 0)
TTotalawal.Text =
FormatNumber(DR("total_awal_penjualan"), 0)
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Tdiskon.Text =
FormatNumber(DR("diskon_penjualan"), 0)
Ttotalahir.Text =
FormatNumber(DR("total_akhir_penjualan"), 0)
End If
'================================
CMD = New OleDbCommand("select * from tblcustomer
where id_customer='" & Tidcustomer.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tcustomer.Text = "Nama: " & DR(1) & " " & DR(2)
& vbCrLf & "Telp/Fax: " & DR(3) & " " & DR(4) & vbCrLf & "Email:
" & DR(5) & vbCrLf & "Contact Person: " & DR(6)
End If
DA = New OleDbDataAdapter("select * from
tblpenjualandetail where id_penjualan='" & Tidpenjualan.Text &
"'", Conn)
DS = New DataSet
DA.Fill(DS)
DGV.DataSource = DS.Tables(0)
DGV.ReadOnly = True
'================
DGV.Columns(0).Visible = False
DGV.Columns(1).Width = 250
DGV.Columns(1).HeaderText = "Keterangan"
DGV.Columns(2).HeaderText = "Unit"
DGV.Columns(3).HeaderText = "Harga Satuan"
DGV.Columns(4).HeaderText = "Jumlah"
DGV.Columns(5).HeaderText = "Total"
DGV.Columns(3).DefaultCellStyle.Format = "#,0"
DGV.Columns(4).DefaultCellStyle.Format = "#,0"
DGV.Columns(5).DefaultCellStyle.Format = "#,0"
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(4).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter
DGV.Columns(5).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
End If
End Sub
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Call Bersihkan()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
Private Sub TTanggal_ValueChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs)
Call Notis()
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR5Pembayaran
Dim romawi As String
Sub Notis()
If Month(Today) = 1 Then
romawi = "I"
ElseIf Month(Today) = 2 Then
romawi = "II"
ElseIf Month(Today) = 3 Then
romawi = "III"
ElseIf Month(Today) = 4 Then
romawi = "IV"
ElseIf Month(Today) = 5 Then
romawi = "V"
ElseIf Month(Today) = 6 Then
romawi = "VI"
ElseIf Month(Today) = 7 Then
romawi = "VII"
ElseIf Month(Today) = 8 Then
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
romawi = "VIII"
ElseIf Month(Today) = 9 Then
romawi = "IX"
ElseIf Month(Today) = 10 Then
romawi = "X"
ElseIf Month(Today) = 11 Then
romawi = "XI"
ElseIf Month(Today) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_pembayaran ,4) &
mid(Tanggal_pembayaran,4,2) &left(id_pembayaran,2) as ketemu
from tblpembayaran order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
tid.Text = "01/BYR/" + romawi + Format(Today,
"/yyyy")
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6)
= Format(Today, "yyyyMM") Then
tid.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/BYR/" + romawi + Format(Today, "/yyyy")
Else
tid.Text = "01/BYR/" + romawi + Format(Today,
"/yyyy")
End If
End If
End Sub
Sub Bersihkan()
ComboBox1.Text = ""
DGV.Columns.Clear()
Tharga.Text = 0
Tpajak.Text = 0
Tdiskon.Text = 0
TTotalawal.Text = 0
Ttotalahir.Text = 0
Tcustomer.Clear()
tnomorpo.Clear()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Tidcustomer.Text = ""
tketerangan.Text = "Keterangan"
tidpenawaran.Text = ""
Tidsuratjalan.Text = ""
Tidpenjualan.Text = ""
Call Notis()
Call tampilinvoice()
End Sub
Sub tampilinvoice()
CMD = New OleDbCommand("select ID_invoice from
tblinvoice WHERE STATUS_invoice='OPEN'", Conn)
DR = CMD.ExecuteReader
ComboBox1.Items.Clear()
Do While DR.Read
ComboBox1.Items.Add(DR(0))
Loop
End Sub
Private Sub TR5Pembayaran_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.CenterToScreen()
Call Koneksi()
Call Bersihkan()
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ComboBox1.SelectedIndexChanged
CMD = New OleDbCommand("select id_surat_jalan from
tblinvoice where id_invoice='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidsuratjalan.Text = DR("id_surat_jalan")
End If
CMD = New OleDbCommand("select id_penjualan from
tblsuratjalan where id_surat_jalan='" & Tidsuratjalan.Text &
"'", Conn)
DR = CMD.ExecuteReader
DR.Read()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
If DR.HasRows Then
Tidpenjualan.Text = DR("id_penjualan")
End If
CMD = New OleDbCommand("select id_penawaran,Nomor_po
from tblpenjualan where id_penjualan='" & Tidpenjualan.Text &
"'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
tnomorpo.Text = DR("nomor_po")
tidpenawaran.Text = DR("id_penawaran")
End If
CMD = New OleDbCommand("select id_customer from
tblpenawaran where id_penawaran='" & tidpenawaran.Text & "'",
Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tidcustomer.Text = DR("id_customer")
End If
CMD = New OleDbCommand("select * from tblcustomer where
id_customer='" & Tidcustomer.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tcustomer.Text = "Nama: " & DR(1) & " " & DR(2) &
vbCrLf & "Telp/Fax: " & DR(3) & " " & DR(4) & vbCrLf & "Email: "
& DR(5) & vbCrLf & "Contact Person: " & DR(6)
End If
'==================================
CMD = New OleDbCommand("select * from tblinvoice where
id_invoice='" & ComboBox1.Text & "'", Conn)
DR = CMD.ExecuteReader
DR.Read()
If DR.HasRows Then
Tharga.Text = FormatNumber(DR("harga_invoice"), 0)
Tpajak.Text = FormatNumber(DR("pajak_invoice"), 0)
TTotalawal.Text =
FormatNumber(DR("total_awal_invoice"), 0)
Tdiskon.Text = FormatNumber(DR("diskon_invoice"), 0)
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Ttotalahir.Text =
FormatNumber(DR("total_akhir_invoice"), 0)
End If
DA = New OleDbDataAdapter("select * from
tblinvoicedetail where id_invoice='" & ComboBox1.Text & "'",
Conn)
DS = New DataSet
DA.Fill(DS)
DGV.DataSource = DS.Tables(0)
'================
DGV.Columns(0).Visible = False '
DGV.Columns(1).Width = 250
DGV.Columns(1).HeaderText = "Keterangan"
DGV.Columns(2).HeaderText = "Unit"
DGV.Columns(3).HeaderText = "Harga Satuan"
DGV.Columns(4).HeaderText = "Jumlah"
DGV.Columns(5).HeaderText = "Total"
DGV.ReadOnly = True
DGV.Columns(3).DefaultCellStyle.Format = "#,00"
DGV.Columns(5).DefaultCellStyle.Format = "#,00"
DGV.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(4).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleCenter
DGV.Columns(5).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Call Bersihkan()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
Private Sub TTanggal_ValueChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TTanggal.ValueChanged
Call Notis()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
End Sub
Public Function Terbilang(ByVal nilai As Long) As String
Dim bilangan As String() = {"", "Satu", "Dua", "Tiga",
"Empat", "Lima", _
"Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh",
"Sebelas"}
If nilai < 12 Then
Return " " & bilangan(nilai)
ElseIf nilai < 20 Then
Return Terbilang(nilai - 10) & " Belas"
ElseIf nilai < 100 Then
Return (Terbilang(CInt((nilai \ 10))) & " Puluh") +
Terbilang(nilai Mod 10)
ElseIf nilai < 200 Then
Return " Seratus" & Terbilang(nilai - 100)
ElseIf nilai < 1000 Then
Return (Terbilang(CInt((nilai \ 100))) & " Ratus") +
Terbilang(nilai Mod 100)
ElseIf nilai < 2000 Then
Return " Seribu" & Terbilang(nilai - 1000)
ElseIf nilai < 1000000 Then
Return (Terbilang(CInt((nilai \ 1000))) & " Ribu") +
Terbilang(nilai Mod 1000)
ElseIf nilai < 1000000000 Then
Return (Terbilang(CInt((nilai \ 1000000))) & "
Juta") + Terbilang(nilai Mod 1000000)
ElseIf nilai < 1000000000000 Then
Return (Terbilang(CInt((nilai \ 1000000000))) & "
Milyar") + Terbilang(nilai Mod 1000000000)
ElseIf nilai < 1000000000000000 Then
Return (Terbilang(CInt((nilai \ 1000000000000))) & "
Trilyun") + Terbilang(nilai Mod 1000000000000)
Else
Return ""
End If
End Function
Private Sub Ttotalahir_TextChanged(ByVal sender As Object,
ByVal e As System.EventArgs) Handles Ttotalahir.TextChanged
On Error Resume Next
tterbilang.Text = Terbilang(Ttotalahir.Text) & " Rupiah"
End Sub
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class TR6BiayaPengeluaran
Dim romawi As String
Sub Notis()
If Month(Today) = 1 Then
romawi = "I"
ElseIf Month(Today) = 2 Then
romawi = "II"
ElseIf Month(Today) = 3 Then
romawi = "III"
ElseIf Month(Today) = 4 Then
romawi = "IV"
ElseIf Month(Today) = 5 Then
romawi = "V"
ElseIf Month(Today) = 6 Then
romawi = "VI"
ElseIf Month(Today) = 7 Then
romawi = "VII"
ElseIf Month(Today) = 8 Then
romawi = "VIII"
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
ElseIf Month(Today) = 9 Then
romawi = "IX"
ElseIf Month(Today) = 10 Then
romawi = "X"
ElseIf Month(Today) = 11 Then
romawi = "XI"
ElseIf Month(Today) = 12 Then
romawi = "XII"
End If
CMD = New OleDbCommand("select right(id_pembayaran ,4) &
mid(Tanggal_pembayaran,4,2) &left(id_pembayaran,2) as ketemu
from tblpembayaran order by 1 desc", Conn)
DR = CMD.ExecuteReader
DR.Read()
If Not DR.HasRows Then
lblnomorbiaya.Text = "01/BYR/" + romawi +
Format(Today, "/yyyy")
Else
If Microsoft.VisualBasic.Left(DR.Item("ketemu"), 5)
Or Microsoft.VisualBasic.Left(DR.Item("ketemu"), 6) =
Format(Today, "yyyyMM") Then
lblnomorbiaya.Text =
Format(Microsoft.VisualBasic.Right(DR.Item("ketemu"), 2) + 1,
"00") + "/BYR/" + romawi + Format(Today, "/yyyy")
Else
lblnomorbiaya.Text = "01/BYR/" + romawi +
Format(Today, "/yyyy")
End If
End If
End Sub
Private Sub DGV_CellEndEdit(ByVal sender As Object, ByVal e
As System.Windows.Forms.DataGridViewCellEventArgs) Handles
DGV.CellEndEdit
If e.ColumnIndex = 1 Then
DGV.Rows(e.RowIndex).Cells(1).Value =
UCase(DGV.Rows(e.RowIndex).Cells(1).Value)
DGV.Rows(e.RowIndex).Cells(0).Value = TglBiaya.Text
DGV.CurrentCell = DGV(2, DGV.CurrentCell.RowIndex)
SendKeys.Send("{UP}")
End If
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
If e.ColumnIndex = 2 Then
DGV.Rows(e.RowIndex).Cells(2).Value =
FormatNumber(DGV.Rows(e.RowIndex).Cells(2).Value, 0)
DGV.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.CurrentCell = DGV(1, DGV.CurrentCell.RowIndex)
End If
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
DGV.Rows.Clear()
End Sub
Private Sub Button4_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button4.Click
Me.Close()
End Sub
Private Sub DGV_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles DGV.KeyPress
On Error Resume Next
If e.KeyChar = Chr(27) Then
DGV.Rows.Remove(DGV.CurrentRow)
End If
End Sub
Private Sub Biaya_Load(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles MyBase.Load
Me.CenterToScreen()
Call Koneksi()
Call Notis()
TglBiaya.Format = DateTimePickerFormat.Short
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class Lap1Penawaran
Private Sub Lap1Penawaran_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
BulanTahun.Format = DateTimePickerFormat.Short
Call Koneksi()
CMD = New OleDbCommand("select distinct
(tanggal_penawaran) from tblpenawaran", Conn)
DR = CMD.ExecuteReader
ListBox1.Items.Clear()
Do While DR.Read
ListBox1.Items.Add(Format(DateValue(DR(0)),
"dd/MM/yyyy"))
Loop
CMD = New OleDbCommand("select distinct (id_penawaran)
from tblpenawaran", Conn)
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
DR = CMD.ExecuteReader
ListBox2.Items.Clear()
Do While DR.Read
ListBox2.Items.Add(DR(0))
Loop
CMD = New OleDbCommand("select distinct
tblcustomer.nama_customer from tblcustomer,tblpenawaran where
tblcustomer.id_customer=tblpenawaran.id_customer", Conn)
DR = CMD.ExecuteReader
ListBox3.Items.Clear()
Do While DR.Read
ListBox3.Items.Add(DR(0))
Loop
CMD = New OleDbCommand("select distinct
(status_penawaran) from tblpenawaran", Conn)
DR = CMD.ExecuteReader
ListBox4.Items.Clear()
Do While DR.Read
ListBox4.Items.Add(DR(0))
Loop
End Sub
Private Sub TextBox2_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox2.TextChanged
CMD = New OleDbCommand("select distinct (id_penawaran)
from tblpenawaran where id_penawaran like '%" & TextBox2.Text &
"%'", Conn)
DR = CMD.ExecuteReader
ListBox2.Items.Clear()
Do While DR.Read
ListBox2.Items.Add(DR(0))
Loop
End Sub
Private Sub TextBox3_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox3.TextChanged
CMD = New OleDbCommand("select distinct
tblcustomer.nama_customer from tblcustomer,tblpenawaran where
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
tblcustomer.id_customer=tblpenawaran.id_customer and
tblcustomer.nama_customer like '%" & TextBox3.Text & "%'", Conn)
DR = CMD.ExecuteReader
ListBox3.Items.Clear()
Do While DR.Read
ListBox3.Items.Add(DR(0))
Loop
End Sub
Sub bantugrid()
DS = New DataSet
DA.Fill(DS)
DGV.DataSource = DS.Tables(0)
DGV.ReadOnly = True
DGV.Columns(5).DefaultCellStyle.Format = "#,00"
DGV.Columns(6).DefaultCellStyle.Format = "#,00"
DGV.Columns(7).DefaultCellStyle.Format = "#,00"
DGV.Columns(8).DefaultCellStyle.Format = "#,00"
DGV.Columns(9).DefaultCellStyle.Format = "#,00"
DGV.Columns(5).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(6).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(7).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(8).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.Columns(9).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV.AutoSizeColumnsMode =
DataGridViewAutoSizeColumnsMode.DisplayedCells
End Sub
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ListBox1.SelectedIndexChanged
ttangal.Text = ListBox1.Text
Tbulan.Text = ""
Tnomor.Text = ""
Tcustomer.Text = ""
Tstatus.Text = ""
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
DA = New OleDbDataAdapter("SELECT * from querypenawaran
where cdate(tanggal_penawaran)='" & (ListBox1.Text) & "'", Conn)
Call bantugrid()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
Tbulan.Text = BulanTahun.Text
ttangal.Text = ""
Tnomor.Text = ""
Tcustomer.Text = ""
Tstatus.Text = ""
DA = New OleDbDataAdapter("SELECT * from querypenawaran
where (month(tanggal_penawaran))='" & Month(BulanTahun.Value) &
"' and (year(tanggal_penawaran))='" & Year(BulanTahun.Value) &
"'", Conn)
Call bantugrid()
End Sub
Private Sub ListBox2_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ListBox2.SelectedIndexChanged
Tnomor.Text = ListBox2.Text
ttangal.Text = ""
Tbulan.Text = ""
Tcustomer.Text = ""
Tstatus.Text = ""
DA = New OleDbDataAdapter("SELECT * from querypenawaran
where tblpenawaran.id_penawaran='" & (ListBox2.Text) & "'",
Conn)
Call bantugrid()
End Sub
Private Sub ListBox3_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ListBox3.SelectedIndexChanged
Tcustomer.Text = ListBox3.Text
ttangal.Text = ""
Tbulan.Text = ""
Tnomor.Text = ""
Tstatus.Text = ""
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
DA = New OleDbDataAdapter("SELECT * from querypenawaran
where tblcustomer.nama_customer='" & (ListBox3.Text) & "'",
Conn)
Call bantugrid()
End Sub
Private Sub ListBox4_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ListBox4.SelectedIndexChanged
Tstatus.Text = ListBox4.Text
ttangal.Text = ""
Tbulan.Text = ""
Tnomor.Text = ""
Tcustomer.Text = ""
DA = New OleDbDataAdapter("SELECT * from querypenawaran
where tblpenawaran.status_penawaran='" & (ListBox4.Text) & "'",
Conn)
Call bantugrid()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
Cetak.Show()
If ttangal.Text <> "" Then
Cetak.CRV.SelectionFormula =
"totext({querypenawaran.tanggal_penawaran})='" & ttangal.Text &
"'"
Rpt.Load("penawaran master.rpt")
Call TampilLaporan()
Cetak.CRV.ReportSource = Rpt
Cetak.CRV.RefreshReport()
ElseIf Tbulan.Text <> "" Then
Cetak.CRV.SelectionFormula =
"month({querypenawaran.tanggal_penawaran})=(" &
Month(BulanTahun.Text) & ") and
year({querypenawaran.tanggal_penawaran})=(" &
Year(BulanTahun.Text) & ")"
Rpt.Load("penawaran master.rpt")
Call TampilLaporan()
Cetak.CRV.ReportSource = Rpt
Cetak.CRV.RefreshReport()
ElseIf Tnomor.Text <> "" Then
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Cetak.CRV.SelectionFormula =
"{querypenawaran.id_penawaran}='" & Tnomor.Text & "'"
Rpt.Load("penawaran master.rpt")
Call TampilLaporan()
Cetak.CRV.ReportSource = Rpt
Cetak.CRV.RefreshReport()
ElseIf Tcustomer.Text <> "" Then
Cetak.CRV.SelectionFormula =
"{querypenawaran.nama_customer}='" & Tcustomer.Text & "'"
Rpt.Load("penawaran master.rpt")
Call TampilLaporan()
Cetak.CRV.ReportSource = Rpt
Cetak.CRV.RefreshReport()
ElseIf Tstatus.Text <> "" Then
Cetak.CRV.SelectionFormula =
"{querypenawaran.status_penawaran}='" & Tstatus.Text & "'"
Rpt.Load("penawaran master.rpt")
Call TampilLaporan()
Cetak.CRV.ReportSource = Rpt
Cetak.CRV.RefreshReport()
End If
End Sub
End Class
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
Imports System.Data.OleDb
Public Class Lap7LabaRugi
Private Sub LaporanLabaRugi_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call Koneksi()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
CMD = New OleDbCommand("select distinct Tgl from
Tbllabarugi", Conn)
DR = CMD.ExecuteReader
Do While DR.Read
ListBox1.Items.Add(DR.Item(0))
Loop
LBLPendapatan.Text = 0
LBLBiaya.Text = 0
LBLSaldo.Text = 0
LBLKeterangan.Text = "-"
End Sub
Sub HitungTransaksi()
LBLPendapatan.Text = 0
LBLBiaya.Text = 0
LBLSaldo.Text = 0
Dim hitung1 As Double
For baris1 As Integer = 0 To DGV1.RowCount - 1
hitung1 = hitung1 + DGV1.Rows(baris1).Cells(2).Value
Next
LBLPendapatan.Text = FormatNumber(hitung1, 0)
Dim hitung2 As Double
For baris2 As Integer = 0 To DGV2.RowCount - 1
hitung2 = hitung2 + DGV2.Rows(baris2).Cells(3).Value
Next
LBLBiaya.Text = FormatNumber(hitung2, 0)
LBLSaldo.Text =
Val(Microsoft.VisualBasic.Str(LBLPendapatan.Text)) -
Val(Microsoft.VisualBasic.Str(LBLBiaya.Text))
LBLSaldo.Text = FormatNumber(LBLSaldo.Text, 0)
If Val(LBLSaldo.Text) < 0 Then
LBLKeterangan.Text = "RUGI"
Else
LBLKeterangan.Text = "LABA"
End If
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
'tampilkan rincian pendapatan di dgv1
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
DA = New OleDbDataAdapter("Select * FROM Tbllabarugi
where month(Tbllabarugi.Tgl)='" & Month(BulanTahun.Text) & "'
and year(Tbllabarugi.Tgl)='" & Year(BulanTahun.Text) & "' and
Pemasukan>0 order by Tgl", Conn)
DS = New DataSet
DA.Fill(DS)
DGV1.DataSource = DS.Tables(0)
DGV1.Columns(4).Visible = False
DGV1.Columns("Tgl").DefaultCellStyle.Format = "dd-MMMM-
yyyy"
DGV1.Columns(2).DefaultCellStyle.Format = "#,0"
DGV1.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV1.Columns(3).DefaultCellStyle.Format = "#,0"
DGV1.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DA = New OleDbDataAdapter("Select * FROM Tbllabarugi
where month(Tbllabarugi.Tgl)='" & Month(BulanTahun.Text) & "'
and year(Tbllabarugi.Tgl)='" & Year(BulanTahun.Text) & "' and
pengeluaran>0 order by Tgl", Conn)
DS = New DataSet
DA.Fill(DS)
DGV2.DataSource = DS.Tables(0)
DGV2.Columns(4).Visible = False
DGV2.Columns("Tgl").DefaultCellStyle.Format = "dd-MMMM-
yyyy"
DGV2.Columns(2).DefaultCellStyle.Format = "#,0"
DGV2.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV2.Columns(3).DefaultCellStyle.Format = "#,0"
DGV2.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV1.Columns(5).Visible = False
DGV2.Columns(5).Visible = False
Call HitungTransaksi()
CRV.ReportSource = Nothing
CRV.SelectionFormula = "month({Tbllabarugi.Tgl})=(" &
Month(BulanTahun.Text) & ") and year({Tbllabarugi.Tgl})=(" &
Year(BulanTahun.Text) & ")"
Rpt.Load("laba rugi BULANAN OK.rpt")
Call TampilLaporan()
CRV.ReportSource = Rpt
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
CRV.RefreshReport()
End Sub
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ListBox1.SelectedIndexChanged
'tampilkan rincian pendapatan di dgv1
DA = New OleDbDataAdapter("Select * from Tbllabarugi
where cdate(Tbllabarugi.Tgl)='" & ListBox1.Text & "' AND
pemasukan>0 order by Tgl", Conn)
DS = New DataSet
DA.Fill(DS)
DGV1.DataSource = DS.Tables(0)
DGV1.Columns(4).Visible = False
DGV1.Columns("Tgl").DefaultCellStyle.Format = "dd-MMMM-
yyyy"
DGV1.Columns(2).DefaultCellStyle.Format = "#,0"
DGV1.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV1.Columns(3).DefaultCellStyle.Format = "#,0"
DGV1.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
'tampilkan rincian biaya dalam dgv2
DA = New OleDbDataAdapter("Select * from Tbllabarugi
where cdate(Tbllabarugi.Tgl)='" & ListBox1.Text & "' AND
pengeluaran>0 order by Tgl", Conn)
DS = New DataSet
DA.Fill(DS)
DGV2.DataSource = DS.Tables(0)
DGV2.Columns(4).Visible = False
DGV2.Columns("Tgl").DefaultCellStyle.Format = "dd-MMMM-
yyyy"
DGV2.Columns(2).DefaultCellStyle.Format = "#,0"
DGV2.Columns(2).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV2.Columns(3).DefaultCellStyle.Format = "#,0"
DGV2.Columns(3).DefaultCellStyle.Alignment =
DataGridViewContentAlignment.MiddleRight
DGV1.Columns(5).Visible = False
DGV2.Columns(5).Visible = False
Call HitungTransaksi()
wwwwwwwwwwww....belajarvbbelajarvbbelajarvbbelajarvb....netnetnetnet Media Belajar VB.Net Online & Bimbingan Tugas Akhir - Skripsi
CRV.SelectionFormula = "totext({Tbllabarugi.Tgl})='" &
DateValue(ListBox1.Text) & "'"
Rpt.Load("laba rugi pertanggal OK.rpt")
Call TampilLaporan()
CRV.ReportSource = Rpt
CRV.RefreshReport()
End Sub
Private Sub LBLKeterangan_TextChanged(ByVal sender As
Object, ByVal e As System.EventArgs) Handles
LBLKeterangan.TextChanged
If LBLKeterangan.Text = "LABA" Then
LBLKeterangan.ForeColor = Color.Blue
Else
LBLKeterangan.ForeColor = Color.Red
End If
End Sub
End Class
top related