daftar pustaka surabaya - dinamikarepository.dinamika.ac.id/id/eprint/309/9/daftar pustaka.pdf ·...

60

DAFTAR PUSTAKA

Davis GB. 1999. Kerangka Dasar Sistem Informasi Manajemen. Cetakan

Kesepuluh. Terjemahan. Penerbit : PT. Pustaka Binaman Pressindo, Jakarta

Kendall, dan Kendall, 2003, Analisis dan Perancangan Sistem Jilid 1,

Prenhallindo, Jakarta.

Marlinda, Linda, S.Kom, 2004, Sistem Basis Data, Andi Offset, Yogyakarta.

McLeod Raymond & Schell George,2008, Sistem Informasi Manajemen, Penerbit

: Salemba empat, Jakarta

Santoso, Budi. 2009. Manajemen Proyek Konsep & Implementasi. Edisi Pertama.

Penerbit : Graha Ilmu, Yogyakarta.

Sutanta, Edhy. 2004.Algoritma : Teknik Penyelesaian Permasalahan untuk

Komputasi. Edisi Pertama. Penerbit : Graha Ilmu, Yogyakarta.

STIKOM S

URABAYA

61

LAMPIRAN

Kartu bimbingan (Tampak depan)

STIKOM S

URABAYA

62

Kartu bimbingan (Tampak belakang)

STIKOM S

URABAYA

63

Acuan kerja

STIKOM S

URABAYA

64

Garis besar acuan kerja

STIKOM S

URABAYA

65

Surat balasan

STIKOM S

URABAYA

66

Log harian kerja

STIKOM S

URABAYA

67

Kehadiran kerja

STIKOM S

URABAYA

68

Source code

Koneksi.vb

Imports System.Data.SqlClient

Module koneksi

Public Conn As New SqlClient.SqlConnection

Public comm As New SqlCommand

Public dtReader As SqlDataReader

Public da As New SqlDataAdapter

Public dt As New DataTable

Public query As String = ""

Public datRow As DataRow

Public dv As DataView

Public ds As New DataSet

Public id As String

Public periode As String

Public Sub konek()

Dim strConn As String

strConn = "Data Source=192.168.29.50;database=Proxsis;

user id=proxsisuser; password=1122;"

Conn = New SqlClient.SqlConnection(strConn)

Try

Conn.Open()

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

End Module

CRUD.vb


Module CRUD

'query untuk manipulasi data (insert, update, delete)

Public Sub CUD(ByVal query As String)

konek()

Try

comm.Connection = Conn

comm.CommandText = query

comm.ExecuteNonQuery()


MessageBox.Show(ex.Message, "Warning")

Finally

End Try

End Sub

'query untuk mengisi data table (select)

Public Sub view(ByVal query As String)

STIKOM S

URABAYA

69

konek()

da = New SqlDataAdapter(query, Conn)

dt = New DataTable

da.Fill(dt)

End Sub

'query untuk mengisi data table (select)

Function GetView(ByVal query As String) As DataTable

konek()

Try

Dim dtInternal As New DataTable


comm = New SqlCommand(query, Conn)

da.Fill(dtInternal)

dir = comm.ExecuteReader

'dir.Close()

Return dtInternal


MessageBox.Show("Error SQL", "Informasi",

MessageBoxButtons.OK)

End Try

Return New DataTable

End Function

Public Function getdata(ByVal data As String, ByVal nama_tabel

As String, ByVal nama_kolom As String, ByVal nilai As String)

query = "select " + data + " from " & nama_tabel & " where

" & nama_kolom & " = '" & nilai & "'"

Dim value As String = view2(query)

Return value

End Function

Public dir As SqlDataReader

'query untuk mengembalikan 1 nilai dari 1 kolom

'contoh select (namakolom) from namatable where kolom key

'syarat, query harus mengembalikan 1 baris

Public Function view2(ByVal query As String)

konek()

comm = New SqlCommand(query, Conn)

Dim nilai As String

nilai = comm.ExecuteScalar

Return nilai

End Function

'untuk mendapatkan informasi nama - nama kolom dari suatu

table

Public Sub Schemakolom(ByVal tabel As String)

konek()

query = "SELECT COLUMN_NAME FROM

INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='" + tabel + "' ORDER

BY ORDINAL_POSITION "


dt = New DataTable

da.Fill(dt)

End Sub

STIKOM S

URABAYA

70

'cara penggunaan dalam aplikasi

Public Sub simpan(ByVal query As String)

CUD(query)

End Sub

Public Sub hapus(ByVal query As String)

CUD(query)

End Sub

Public Sub ubah(ByVal query As String)

CUD(query)

End Sub

End Module

Penjadwalan.vb


Imports System.ComponentModel

Imports DevExpress.Skins

Imports DevExpress.LookAndFeel

Imports DevExpress.UserSkins

Imports DevExpress.XtraBars.Helpers

Public Class Penjadwalan

Sub New()

InitSkins()

InitializeComponent()

Me.InitSkinGallery()

End Sub

Sub InitSkins()

DevExpress.Skins.SkinManager.EnableFormSkins()

DevExpress.UserSkins.OfficeSkins.Register()

DevExpress.UserSkins.BonusSkins.Register()

UserLookAndFeel.Default.SetSkinStyle("DevExpress Style")

End Sub

Private Sub InitSkinGallery()

SkinHelper.InitSkinGallery(rgbiSkins, True)

End Sub

Private Sub Penjadwalan_Load(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles MyBase.Load

konek()

Timer1.Start()

End Sub

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

As System.EventArgs) Handles Timer1.Tick

'menampilkan waktu hari ini

STIKOM S

URABAYA

71

BarStaticItem1.Caption = DateTime.Now.ToString("dddd, dd

MMMM yyyy")

'menampilkan tanggal hari ini

BarStaticItem3.Caption = DateTime.Now.ToString("hh:mm:ss")

End Sub

Private Sub EditTahapanItem_LinkClicked_1(ByVal sender As

System.Object, ByVal e As

DevExpress.XtraNavBar.NavBarLinkEventArgs) Handles

EditTahapanItem.LinkClicked

Dim found As Boolean = False

For Each frm As Form In Me.MdiChildren

If TypeOf frm Is MasterTahapan Then

frm.Show()

found = True

End If

Next

If found = False Then

Dim tampil As Form = New MasterTahapan With

{.MdiParent = Me}

tampil.Show()

End If

'MasterTahapan.Show()

End Sub

Private Sub EditKegiatanItem_LinkClicked_1(ByVal sender As



EditKegiatanItem.LinkClicked



If TypeOf frm Is MasterKegiatan Then

frm.Show()

found = True

End If

Next


Dim tampil As Form = New MasterKegiatan With

{.MdiParent = Me}

tampil.Show()

End If

'MasterKegiatan.Show()

End Sub

Private Sub EditKonsultanItem_LinkClicked_1(ByVal sender As



EditKonsultanItem.LinkClicked



If TypeOf frm Is MasterKonsultan Then

frm.Show()

found = True

End If

STIKOM S

URABAYA

72

Next


Dim tampil As Form = New MasterKonsultan With

{.MdiParent = Me}

tampil.Show()

End If

'MasterKonsultan.Show()

End Sub

Private Sub DokumenItem_LinkClicked_1(ByVal sender As



DokumenItem.LinkClicked

'Dim found As Boolean = False

'For Each frm As Form In Me.MdiChildren

' If TypeOf frm Is BukaDokumen Then

' frm.Show()

' found = True

' End If

'Next

'If found = False Then

' Dim tampil As Form = New BukaDokumen With {.MdiParent

= Me}

' tampil.Show()

'End If

BukaDokumen.Show()

End Sub

Private Sub JadwalBaruItem_LinkClicked(ByVal sender As



JadwalBaruItem.LinkClicked



' If TypeOf frm Is FormU1 Then

' frm.Show()

' found = True

' End If

'Next


' Dim tampil As Form = New FormU1 With {.MdiParent =

Me}

' tampil.Show()

'End If

FormU1.Show()

End Sub

Private Sub iExit_ItemClick(ByVal sender As System.Object,

ByVal e As DevExpress.XtraBars.ItemClickEventArgs) Handles

iExit.ItemClick

Me.Close()

End Sub

Private Sub CetakJadwalKegiatan_LinkClicked(ByVal sender As


STIKOM S

URABAYA

73


CetakJadwalKegiatan.LinkClicked



' If TypeOf frm Is CetakDokumen Then

' frm.Show()

' found = True

' End If

'Next


' Dim tampil As Form = New CetakDokumen With

{.MdiParent = Me}

' tampil.Show()

'End If

CetakDokumen.Show()

End Sub

Private Sub CetakLaporanKonsultan_LinkClicked(ByVal sender As



CetakLaporanKonsultan.LinkClicked



' If TypeOf frm Is CetakDokumen2 Then

' frm.Show()

' found = True

' End If

'Next


' Dim tampil As Form = New CetakDokumen2 With

{.MdiParent = Me}

' tampil.Show()

'End If

CetakDokumen2.Show()

End Sub

End Class

FormU1.vb


Public Class FormU1

Dim idTransaksiProyek As String

Sub transaksi()

query = "select id_transaksi_penjualan from

Transaksi_Penjualan where status='Deal'"

view(query)

For i = 0 To dt.Rows.Count - 1

STIKOM S

URABAYA

74

ComboBox1.Items.Add(dt.Rows(i)!id_transaksi_penjualan.ToString)

Next

End Sub

Sub clear()

End Sub

Private Sub FormU1_Load(ByVal sender As Object, ByVal e As

System.EventArgs) Handles Me.Load

transaksi()

End Sub

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As

System.Object, ByVal e As System.EventArgs) Handles

ComboBox1.SelectedIndexChanged

query = "select nama_klien, Bidang_usaha, Alamat,

Jenis_produk, periode from Transaksi_Penjualan tp join Produk_Jasa

pj on tp.id_produk=pj.id_produk join Klien k on

tp.id_klien=k.id_klien where tp.id_transaksi_penjualan = '" &

ComboBox1.SelectedItem & "'"

view(query)


tb_Namaklien.Text = dt.Rows(i)!nama_klien.ToString

tb_Bidangusaha.Text = dt.Rows(i)!bidang_usaha.ToString

tb_alamat.Text = dt.Rows(i)!Alamat.ToString

tb_Jenisproduk.Text =

dt.Rows(i)!jenis_produk.ToString()

tb_periode.Text = dt.Rows(i)!periode.ToString

Next

periode = tb_periode.Text

End Sub

Private Sub tb_Lanjutkan_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles tb_Lanjutkan.Click

Me.Hide()

FormU2.Show()

End Sub

Private Sub tb_batal_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles tb_batal.Click

Me.Close()

End Sub

End Class

FormU2.vb


Public Class FormU2

Dim id_transaksi_penjadwalan As String

Sub clear()

'tb_Periode.Clear()

STIKOM S

URABAYA

75

dtp_TglMulai.Text = Format(Date.Now, "dd/MM/yyyy")

dtp_TglSelesai.Text = Format(Date.Now, "dd/MM/yyyy")

tbMulaiJam.Value = 0

tbMulaiMenit.Value = 0

tbSelesaiJam.Value = 0

tbSelesaiMenit.Value = 0

cb_Kegiatan.Text = "Pilih"

cb_status.Text = "Pilih"

cb_Tahapan.Text = "Pilih"

cb_NamaKonsultan.Text = "Pilih"

cb_Kegiatan.SelectedItem = "Pilih"

cb_NamaKonsultan.SelectedItem = "Pilih"

cb_Tahapan.SelectedItem = "Pilih"

cb_status.SelectedItem = "Pilih"

End Sub

Sub id_transaksi()

'query = "select max(id_transaksi_penjadwalan) from

transaksi_penjadwalan "

'id_transaksi_penjadwalan = view2(query) + 1

konek()

comm = New SqlCommand("select

replace(MAX(id_transaksi_penjadwalan), 'Tr','')+1 from

Transaksi_Penjadwalan", Conn)

Dim id As String = comm.ExecuteScalar

id_transaksi_penjadwalan = "Tr" + id

End Sub

Private Sub btn_Simpan_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles btn_Simpan.Click

dgv_jadwal.ColumnCount = 11

dgv_jadwal.Columns(2).Name = "Periode"

dgv_jadwal.Columns(3).Name = "Tahapan"

dgv_jadwal.Columns(4).Name = "Kegiatan"

dgv_jadwal.Columns(5).Name = "Tanggal Mulai"

dgv_jadwal.Columns(6).Name = "Tanggal Selesai"

dgv_jadwal.Columns(7).Name = "Waktu Mulai"

dgv_jadwal.Columns(8).Name = "Waktu Selesai"

dgv_jadwal.Columns(9).Name = "Nama Konsultan"

dgv_jadwal.Columns(10).Name = "Status"

Dim tampung1 As String

tampung1 = Format(dtp_TglMulai.Value, "yyyy-MM-dd")


tampung2 = Format(dtp_TglSelesai.Value, "yyyy-MM-dd")

Dim isfound As Boolean = False

For i As Integer = 0 To dgv_jadwal.Rows.Count - 1

If tampung1.Equals(dgv_jadwal.Item("Tanggal Mulai",

i).Value) And tampung2.Equals(dgv_jadwal.Item("Tanggal Selesai",

i).Value) Then

isfound = True

End If

Next

If isfound = False Then

dgv_jadwal.Rows.Add("", "", tb_Periode.Text,

cb_Tahapan.SelectedItem, cb_Kegiatan.SelectedItem, tampung1,

STIKOM S

URABAYA

76

tampung2, tbMulaiJam.Value & ":" & tbMulaiMenit.Value,

tbSelesaiJam.Value & ":" & tbSelesaiMenit.Value,

cb_NamaKonsultan.SelectedItem, cb_status.SelectedItem)

Else

MsgBox("Tanggal yang dimasukkan sudah ada")

End If

clear()

End Sub

Private Sub cb_Tahapan_SelectedIndexChanged(ByVal sender As


cb_Tahapan.SelectedIndexChanged

Try

query = "select * from Kegiatan k join Tahapan t on

k.id_tahapan = t.id_tahapan where k.id_tahapan = '" +

getdata("id_tahapan", "tahapan", "nama_tahapan",

cb_Tahapan.SelectedItem) + "'"

view(query)


MsgBox(ex.Message)

End Try

cb_Kegiatan.Items.Clear()


cb_Kegiatan.Items.Add(dt.Rows(i)!nama_kegiatan.ToString)

Next

End Sub

Sub load_tahapan()

query = "select * from tahapan"

view(query)


cb_Tahapan.Items.Add(dt.Rows(i)!nama_tahapan)

Next

query = "select * from konsultan"

view(query)


cb_NamaKonsultan.Items.Add(dt.Rows(i)!nama_konsultan)

Next

End Sub

Private Sub FormU2_Load(ByVal sender As Object, ByVal e As


konek()

load_tahapan()

tb_Periode.Text = FormU1.tb_periode.Text

id_transaksi()

End Sub

STIKOM S

URABAYA

77

Private Sub cb_Kegiatan_SelectedIndexChanged(ByVal sender As


cb_Kegiatan.SelectedIndexChanged

query = "select * from kegiatan where nama_kegiatan='" &

cb_Kegiatan.SelectedItem & "'"

view(query)


cb_status.SelectedItem = dt.Rows(i)!status.ToString

Next

End Sub

Private Sub dgv_jadwal_CellContentClick(ByVal sender As


System.Windows.Forms.DataGridViewCellEventArgs) Handles

dgv_jadwal.CellContentClick

Dim jam() As String

Dim i As Integer

i = dgv_jadwal.CurrentRow.Index

If dgv_jadwal.Item(0, i).Selected = True Then

tb_Periode.Text = dgv_jadwal.Item(2, i).Value

cb_Tahapan.SelectedText = dgv_jadwal.Item(3, i).Value

cb_Kegiatan.SelectedItem = dgv_jadwal.Item(4, i).Value

dtp_TglMulai.Text = dgv_jadwal.Item(5, i).Value

dtp_TglSelesai.Text = dgv_jadwal.Item(6, i).Value

jam = Split(dgv_jadwal.Item(7, i).Value, ":")

tbMulaiJam.Value = jam(0)

tbMulaiMenit.Value = jam(1)

jam = Split(dgv_jadwal.Item(8, i).Value, ":")

tbSelesaiJam.Value = jam(0)

tbSelesaiMenit.Value = jam(1)

cb_NamaKonsultan.SelectedItem = dgv_jadwal.Item(9,

i).Value

cb_status.SelectedItem = dgv_jadwal.Item(10, i).Value

dgv_jadwal.Rows.RemoveAt(i)

ElseIf dgv_jadwal.Item(1, i).Selected = True Then

dgv_jadwal.Rows.RemoveAt(i)

End If

End Sub

Private Sub tb_kembali_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles tb_kembali.Click

Me.Hide()

FormU1.Show()

End Sub

Private Sub btn_Batal_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles btn_Batal.Click

Me.Close()

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles Button1.Click

Dim id_transaksi_penjualan As String

STIKOM S

URABAYA

78

Dim id_kegiatan As String

Dim id_konsultan As String

Dim mulai As Date

Dim selesai As Date

For i = 0 To dgv_jadwal.Rows.Count - 1

query = "select id_transaksi_penjualan from

transaksi_penjualan where periode='" & dgv_jadwal.Item(2, i).Value

& "'"

id_transaksi_penjualan = view2(query)

query = "select id_kegiatan from kegiatan where

nama_kegiatan='" & dgv_jadwal.Item(4, i).Value & "'"

id_kegiatan = view2(query)

query = "select id_konsultan from konsultan where

nama_konsultan='" & dgv_jadwal.Item(9, i).Value & "'"

id_konsultan = view2(query)

mulai = Convert.ToDateTime(dgv_jadwal.Item(7,

i).Value)

selesai = Convert.ToDateTime(dgv_jadwal.Item(8,

i).Value)

query = "insert into Transaksi_Penjadwalan

(id_transaksi_penjadwalan,

id_transaksi_penjualan,id_kegiatan,id_konsultan,tanggal_kegiatan_m

ulai,tanggal_kegiatan_selesai,waktu_mulai,waktu_selesai,isdelete)

values('" & id_transaksi_penjadwalan & "','" &

id_transaksi_penjualan & "','" & id_kegiatan & "','" &

id_konsultan & "','" & dgv_jadwal.Item(5, i).Value & "','" &

dgv_jadwal.Item(6, i).Value & "','" & mulai.ToString("HH:mm") &

"','" & selesai.ToString("HH:mm") & "','false')"

simpan(query)

query = "update kegiatan set status='" &

cb_status.SelectedItem & "' where id_kegiatan='" & id_kegiatan &

"'"

CUD(query)

Next

clear()

id_transaksi()

dgv_jadwal.Rows.Clear()

End Sub

Private Sub dtp_TglMulai_ValueChanged(ByVal sender As


dtp_TglMulai.ValueChanged

End Sub

End Class

MasterKonsultan.vb

STIKOM S

URABAYA

79


Public Class MasterKonsultan

Dim idkonsultan As String

Sub awal()

Try

da = New SqlDataAdapter("Select * from Konsultan where

isdelete='False'", Conn)


MessageBox.Show(ex.Message)

End Try

ds = New DataSet

da.Fill(ds, "Konsultan")

DataGridView1.DataSource = ds.Tables("Konsultan")

DataGridView1.AllowUserToAddRows = False

DataGridView1.ReadOnly = True

DataGridView1.Columns("isdelete").Visible = False

End Sub

Sub tambahKonsultan()

konek()

comm = New SqlCommand("select replace(MAX(id_konsultan),

'C','')+1 from Konsultan", Conn)


tb_idKonsultan.Text = "C" + id

End Sub

Sub clear()

tb_NamaKonsultan.Text = ""

tb_Alamat.Text = ""

tb_Telpon.Text = ""

tb_Email.Text = ""

cb_Status.Text = ""

End Sub

Private Sub btnTambah_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles btnTambah.Click

CUD("INSERT INTO Konsultan VALUES" & _

"('" & tb_idKonsultan.Text & "','" & _

tb_NamaKonsultan.Text & "','" & _

tb_Alamat.Text & "','" & _

tb_Telpon.Text & "','" & _

tb_Email.Text & "','" & _

cb_Status.Text & "','False')")

tambahKonsultan()

awal()

clear()

End Sub

Private Sub btnUbah_Click(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles btnUbah.Click

CUD(String.Format("update Konsultan set nama_konsultan =

'{0}', Alamat ='{1}', Telepon ='{2}', Email ='{3}', status ='{4}'

WHERE id_konsultan = '{5}'", tb_NamaKonsultan.Text,

tb_Alamat.Text, tb_Telpon.Text, tb_Email.Text, cb_Status.Text,

tb_idKonsultan.Text))

STIKOM S

URABAYA

80

awal()

clear()

End Sub

Private Sub BtnHapus_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles BtnHapus.Click

CUD(String.Format("update Konsultan set isdelete=false

where id_konsultan='{0}'", tb_idKonsultan.Text))

awal()

clear()

End Sub

Private Sub btn_batal_Click(ByVal sender As System.Object,

ByVal e As System.EventArgs) Handles btn_batal.Click

tb_NamaKonsultan.Text = ""

tambahKonsultan()

idkonsultan = ""

End Sub

Private Sub DataGridView1_CellContentClick(ByVal sender As



DataGridView1.CellContentClick

If DataGridView1.RowCount > 1 Then

Dim rowid As Integer = e.RowIndex

Dim rowview As DataGridViewRow =

DataGridView1.Rows(rowid)

tb_idKonsultan.Text = rowview.Cells(0).Value

tb_idKonsultan.ReadOnly = True

tb_NamaKonsultan.Text = rowview.Cells(1).Value

tb_Alamat.Text = rowview.Cells(2).Value

tb_Telpon.Text = rowview.Cells(3).Value

tb_Email.Text = rowview.Cells(4).Value

cb_Status.Text = rowview.Cells(5).Value

End If

End Sub

Private Sub MasterKonsultan_Load(ByVal sender As Object, ByVal

e As System.EventArgs) Handles Me.Load

konek()

awal()

tambahKonsultan()

clear()

End Sub

End Class

MasterTahapan.vb


Public Class MasterTahapan

Dim idtahapan As String

Sub awal()

Try

STIKOM S

URABAYA

81

da = New SqlDataAdapter("Select * from Tahapan where

isdelete='False'", Conn)



End Try

ds = New DataSet

da.Fill(ds, "Tahapan")

DataGridView1.DataSource = ds.Tables("Tahapan")


DataGridView1.Columns("isdelete").Visible = False

End Sub

Sub tambahTahapan()

konek()

comm = New SqlCommand("select replace(MAX(id_tahapan),

'S','')+1 from Tahapan", Conn)


tb_Tahapan.Text = "S" + id

End Sub

Sub clear()

tb_NamaTahapan.Text = ""

End Sub

Private Sub btnTambah_Click(ByVal sender As System.Object,


tambahTahapan()

CUD("INSERT INTO Tahapan VALUES" & _

"('" & tb_Tahapan.Text & "','" & tb_NamaTahapan.Text &

"','False')")

awal()

End Sub



CUD(String.Format("update tahapan set nama_tahapan='{0}'

where id_tahapan='" & tb_Tahapan.Text & "'", tb_NamaTahapan.Text))

awal()

btn_batal.PerformClick()

End Sub

Private Sub BtnHapus_Click(ByVal sender As System.Object,


CUD(String.Format("update tahapan set isdelete='True'

where id_tahapan='{0}'", tb_Tahapan.Text))

awal()

End Sub



tb_NamaTahapan.Text = ""

tambahTahapan()

End Sub

STIKOM S

URABAYA

82









'idtahapan = rowview.Cells(0).Value

tb_Tahapan.Text = rowview.Cells(0).Value

tb_Tahapan.ReadOnly = True

tb_NamaTahapan.Text = rowview.Cells(1).Value

End If

End Sub

Private Sub MasterTahapan_Load(ByVal sender As Object, ByVal e

As System.EventArgs) Handles Me.Load

konek()

awal()

tambahTahapan()

clear()

End Sub

End Class

MasterKegiatan.vb


Public Class MasterKegiatan

Dim idkegiatan As String

Dim idtahapan As String

Dim status As String

Sub awal()

Try

da = New SqlDataAdapter("Select Tahapan.id_tahapan,

Kegiatan.nama_kegiatan, Kegiatan.lama_hari, Kegiatan.status from

Kegiatan, Tahapan where Tahapan.id_tahapan = Kegiatan.id_tahapan

and Kegiatan.isdelete='False' ", Conn)



End Try

ds = New DataSet

da.Fill(ds, "tahapan_kegiatan")

da = New SqlDataAdapter("Select id_tahapan,nama_tahapan

from tahapan where ", Conn)

DataGridView1.DataSource = ds.Tables("tahapan_kegiatan")


DataGridView1.ReadOnly = True

DataGridView1.Columns("id_tahapan").Visible = False

DataGridView1.Columns("status").Visible = False

STIKOM S

URABAYA

83

End Sub

Sub tambahKegiatan()

konek()

comm = New SqlCommand("select replace(MAX(id_kegiatan),

'K','')+1 from Kegiatan", Conn)


idkegiatan = "K" + id

End Sub

Sub clear()

tb_NamaKegiatan.Text = ""

Nud_LamaHari.Text = ""

End Sub


ByVal e As System.EventArgs)

tb_NamaKegiatan.Text = ""

tambahKegiatan()

idkegiatan = ""

End Sub



System.Windows.Forms.DataGridViewCellEventArgs)





tb_NamaKegiatan.Text = rowview.Cells(1).Value

Nud_LamaHari.Text = rowview.Cells(2).Value

End If

End Sub

Private Sub MasterKegiatan_Load(ByVal sender As Object, ByVal

e As System.EventArgs) Handles Me.Load

konek()

query = "select * from tahapan where

tahapan.isdelete='False'"

view(query)


cmbTahapan.Properties.Items.Add(dt.Rows(i)!nama_tahapan.ToString)

Next

awal()

tambahKegiatan()

clear()

STIKOM S

URABAYA

84

End Sub

Private Sub cmbTahapan_SelectedIndexChanged(ByVal sender As


cmbTahapan.SelectedIndexChanged

query = String.Format("select * from kegiatan join tahapan

on kegiatan.id_tahapan=tahapan.id_tahapan where

nama_tahapan='{0}'", cmbTahapan.SelectedItem)

view(query)

tb_NamaKegiatan.Text = dt.Rows(0)!nama_kegiatan.ToString

Nud_LamaHari.Text = dt.Rows(0)!lama_hari.ToString

query = String.Format("select nama_kegiatan 'Nama

Kegiatan' ,lama_hari 'Lama Hari' from kegiatan join tahapan on

kegiatan.id_tahapan=tahapan.id_tahapan where

kegiatan.isdelete='false' and nama_tahapan='{0}' and lama_hari='"

& Nud_LamaHari.Text & "'", cmbTahapan.SelectedItem)

view(query)

DataGridView1.DataSource = dt

End Sub

Private Sub DataGridView1_CellContentClick_1(ByVal sender As




Dim i As Integer = DataGridView1.CurrentRow.Index

tb_NamaKegiatan.Text = DataGridView1.Item(1, i).Value

Nud_LamaHari.Value = DataGridView1.Item(2, i).Value

query = String.Format("select id_kegiatan from kegiatan

where nama_kegiatan='{0}'", tb_NamaKegiatan.Text)

idkegiatan = view2(query)

End Sub



CUD(String.Format("update Kegiatan set nama_kegiatan =

'{0}', lama_hari ='{1}' WHERE id_kegiatan = '{2}'",

tb_NamaKegiatan.Text, Nud_LamaHari.Text, idkegiatan))

awal()

clear()

End Sub

Private Sub btn_batal_Click_1(ByVal sender As System.Object,


clear()

End Sub

Private Sub btnTambah_Click_1(ByVal sender As System.Object,


query = "select MAX (CONVERT (INT,SUBSTRING(id_kegiatan,

2, 2)))+1 from kegiatan"

idkegiatan = "k" + view2(query)

STIKOM S

URABAYA

85

query = "select id_tahapan from tahapan where

nama_tahapan='" & cmbTahapan.SelectedText & "' "

idtahapan = view2(query)

CUD("INSERT INTO Kegiatan VALUES" & _

"('" & idkegiatan & "','" & idtahapan & "','" &

tb_NamaKegiatan.Text & "','" & Nud_LamaHari.Text & "','" & status

& "','False')")

tambahKegiatan()

awal()

clear()

End Sub

Private Sub BtnHapus_Click_1(ByVal sender As System.Object,


query = "update Kegiatan set isdelete='True' where

nama_kegiatan='" & tb_NamaKegiatan.Text & "'"

CUD(query)

awal()

End Sub

End Class

CetakDokumen.vb


Public Class CetakDokumen

Sub cariTransaksi()

query = "select distinct (id_transaksi_penjadwalan) from

Transaksi_Penjadwalan"

view(query)


ComboBox1.Items.Add(dt.Rows(i)!id_transaksi_penjadwalan.ToString)

Next

End Sub

Private Sub CetakDokumen_Load(ByVal sender As Object, ByVal e


konek()

cariTransaksi()

End Sub



Laporan.Show()

End Sub

End Class

Cetak.Dokumen2.vb

STIKOM S

URABAYA

86


Public Class CetakDokumen2



Laporan2.Show()

End Sub

Private Sub CetakDokumen2_Load(ByVal sender As Object, ByVal e


konek()

End Sub

End Class

Laporan.vb

Imports CrystalDecisions.CrystalReports.Engine

Imports CrystalDecisions.Shared


Public Class Laporan

Private Sub Laporan_Load(ByVal sender As Object, ByVal e As


Dim conn As New SqlConnection

conn.ConnectionString = "server=192.168.29.50;

database=Proxsis; user id=proxsisuser; password=1122;"

Dim dalap As SqlDataAdapter

Dim dsRekam As New DataSet1

Dim Rdlap As New ReportDocument

dalap = New SqlDataAdapter("select * from

Transaksi_Penjadwalan WHERE id_transaksi_penjadwalan = '" &

CetakDokumen.ComboBox1.Text & "'", conn)

dalap.Fill(dsRekam, "Transaksi_Penjadwalan")

dalap = New SqlDataAdapter("select * from Kegiatan", conn)

dalap.Fill(dsRekam, "Kegiatan")

dalap = New SqlDataAdapter("select * from Tahapan", conn)

dalap.Fill(dsRekam, "Tahapan")

dalap = New SqlDataAdapter("select * from Konsultan",

conn)

dalap.Fill(dsRekam, "Konsultan")


Detil_Konsultan", conn)

dalap.Fill(dsRekam, "Detil_Konsultan")

dalap = New SqlDataAdapter("select * from Detil_Produk",

conn)

dalap.Fill(dsRekam, "Detil_Produk")

STIKOM S

URABAYA

87

dalap = New SqlDataAdapter("select * from Produk_Jasa",

conn)

dalap.Fill(dsRekam, "Produk_Jasa")

dalap = New SqlDataAdapter("select * from Klien", conn)

dalap.Fill(dsRekam, "Klien")


Transaksi_Penjualan", conn)

dalap.Fill(dsRekam, "Transaksi_Penjualan")

Rdlap = New CrystalReport2

Rdlap.SetDataSource(dsRekam)

CrystalReportViewer1.ReportSource = Rdlap

End Sub

End Class

Laporan2.vb

Imports CrystalDecisions.CrystalReports.Engine

Imports CrystalDecisions.Shared


Public Class Laporan2

Private Sub Laporan_Load(ByVal sender As Object, ByVal e As


Dim conn As New SqlConnection

conn.ConnectionString = "server=192.168.29.50;

database=Proxsis; user id=proxsisuser; password=1122;"

Dim dalap As SqlDataAdapter

Dim dsRekam As New DataSet1

Dim Rdlap As New ReportDocument


tampung1 = Format(CetakDokumen2.DateTimePicker1.Value,

"yyyy-MM-dd")



"yyyy-MM-dd")



"yyyy-MM-dd")



"yyyy-MM-dd")


Transaksi_Penjadwalan where

Transaksi_Penjadwalan.tanggal_kegiatan_mulai between '" &

tampung1 & "' and '" & tampung2 & "' and

Transaksi_Penjadwalan.tanggal_kegiatan_selesai between '" &

tampung3 & "' and '" & tampung4 & "' ", conn)

STIKOM S

URABAYA

88

dalap.Fill(dsRekam, "Transaksi_Penjadwalan")

dalap = New SqlDataAdapter("select * from Kegiatan", conn)

dalap.Fill(dsRekam, "Kegiatan")

dalap = New SqlDataAdapter("select * from Tahapan", conn)

dalap.Fill(dsRekam, "Tahapan")

dalap = New SqlDataAdapter("select * from Konsultan",

conn)

dalap.Fill(dsRekam, "Konsultan")


Detil_Konsultan", conn)

dalap.Fill(dsRekam, "Detil_Konsultan")

dalap = New SqlDataAdapter("select * from Detil_Produk",

conn)

dalap.Fill(dsRekam, "Detil_Produk")

dalap = New SqlDataAdapter("select * from Produk_Jasa",

conn)

dalap.Fill(dsRekam, "Produk_Jasa")

dalap = New SqlDataAdapter("select * from Klien", conn)

dalap.Fill(dsRekam, "Klien")


Transaksi_Penjualan", conn)

dalap.Fill(dsRekam, "Transaksi_Penjualan")

Rdlap = New CrystalReport3

Rdlap.SetDataSource(dsRekam)

CrystalReportViewer1.ReportSource = Rdlap

End Sub

End Class

STIKOM S

URABAYA

daftar pustaka surabaya - dinamikarepository.dinamika.ac.id/id/eprint/309/9/daftar pustaka.pdf ·...

Documents