public void binding()
{
DataSet data = new gaji_dao().tampilgaji();
dgv_gaji.DataSource = data;
dgv_gaji.DataMember = "t_penggajian";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
DataSet data = new gaji_dao().tampilgaji();
DataTable dt = new DataTable();
dt = data.Tables[0];
cr_penggajian obj_rpt_gaji = new cr_penggajian();
obj_rpt_gaji.SetDataSource(dt);
crv_penggajian.ReportSource = obj_rpt_gaji;
crv_penggajian.Refresh();
}
private void btn_cari_Click(object sender, EventArgs e)
{
if (txt_cari.Text == "")
{
MessageBox.Show("Kata Kunci Tidak Boleh Kosong");
}
gaji g = new gaji();
if (cb_cari.Text == "NIK")
{
try
{
g.nik = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_nik(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
catch
{
MessageBox.Show("Tidak Ketemu");
}
}
else if (cb_cari.Text == "Gaji Pokok")
{
g.gajipokok = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_gajipokok(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
else if (cb_cari.Text == "Tunjangan")
{
g.tunjangan = txt_cari.Text;
DataSet ds = new gaji_dao().caridata_tunjangan(g);
dgv_gaji.DataSource = ds;
dgv_gaji.DataMember = "db_indomart";
DataGridViewColumn kolom0 = dgv_gaji.Columns[0];
kolom0.Width = 180;
kolom0.HeaderText = "NIK";
DataGridViewColumn kolom1 = dgv_gaji.Columns[1];
kolom1.Width = 230;
kolom1.HeaderText = "Nama Karyawan";
DataGridViewColumn kolom2 = dgv_gaji.Columns[2];
kolom2.Width = 170;
kolom2.HeaderText = "Jabatan";
DataGridViewColumn kolom3 = dgv_gaji.Columns[3];
kolom3.Width = 180;
kolom3.HeaderText = "Gaji Pokok.(Rp)";
DataGridViewColumn kolom4 = dgv_gaji.Columns[4];
kolom4.Width = 210;
kolom4.HeaderText = "Tunjangan.(Rp)";
}
}
