private void comboBoxCari_TextChanged(object sender, EventArgs e)
{
textBoxCari.Clear();
string hasilBaca = Pengiriman.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewPengiriman.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
if (listHasilData[i].JenisPengiriman == "SP")
{
jenis = "Shipping Point";
}
else
{
jenis = "Destination Point";
}
string total = listHasilData[i].BiayaKirim.ToString("RP 0,###");
dataGridViewPengiriman.Rows.Add(listHasilData[i].KodePengiriman, jenis,
total, listHasilData[i].TglKirim.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Nama, listHasilData[i].Keterangan, listHasilData[i].NotaPenjualan.NoNotaPenjualan,
listHasilData[i].Ekspedisi.IdEkspedisi, listHasilData[i].Ekspedisi.Nama);
}
}
}
public void FormDaftarPengiriman_Load(object sender, EventArgs e)
{
comboBoxCari.Items.AddRange(new string[] { "Kode Pengiriman", "Jenis Penerimaan", "Biaya Kirim", "Tanggal Kirim", "Nama", "Keterangan",
"Nomor Nota Penjualan", "ID Ekspedisi", "Nama Ekspedisi" });
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
FormatDataGrid();
string hasilBaca = Pengiriman.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewPengiriman.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
if (listHasilData[i].JenisPengiriman == "SP")
{
jenis = "Shipping Point";
}
else
{
jenis = "Destination Point";
}
string total = listHasilData[i].BiayaKirim.ToString("RP 0,###");
dataGridViewPengiriman.Rows.Add(listHasilData[i].KodePengiriman, jenis,
total, listHasilData[i].TglKirim.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Nama, listHasilData[i].Keterangan, listHasilData[i].NotaPenjualan.NoNotaPenjualan,
listHasilData[i].Ekspedisi.IdEkspedisi, listHasilData[i].Ekspedisi.Nama);
}
}
}
private void textBoxCari_TextChanged(object sender, EventArgs e)
{
string kriteria = "";
if (comboBoxCari.Text == "Nomor Dokumen")
{
kriteria = "P.nomor_dokumen";
}
else if (comboBoxCari.Text == "Nomor Spk")
{
kriteria = "P.nomor_spk";
}
string hasilBaca = Pengiriman.BacaData(kriteria, textBoxCari.Text, listHasilData);
if (hasilBaca == "1")
{
dataGridViewPengiriman.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
dataGridViewPengiriman.Rows.Add(listHasilData[i].NomorDokumen, listHasilData[i].NomorSPK.NoSPK, listHasilData[i].TanggalKirim);
}
}
}
public void FormDaftarPengiriman_Load(object sender, EventArgs e)
{
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
FormatDataGrid();
listHasilData.Clear();
string hasilBaca = Pengiriman.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewPengiriman.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
dataGridViewPengiriman.Rows.Add(listHasilData[i].NomorDokumen, listHasilData[i].NomorSPK.NoSPK, listHasilData[i].TanggalKirim);
}
}
}
private void FormTambahPenerimaan_Load_1(object sender, EventArgs e)
{
frmDaftar = (FormDaftarPenerimaan)this.Owner;
listHasilData.Clear();
string hasilBaca = Pengiriman.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
comboBoxNomorPengiriman.Items.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
comboBoxNomorPengiriman.Items.Add(listHasilData[i].NomorDokumen);
}
}
else
{
MessageBox.Show("Data Jabatan gagal ditampilkan. Pesan kesalahan: " + hasilBaca);
}
}
private void textBoxNomerDokumen_TextChanged(object sender, EventArgs e)
{
listHasilData.Clear();
string hasilBaca = Pengiriman.BacaData("P.nomor_dokumen", textBoxNomerDokumen.Text, listHasilData);
if (hasilBaca == "1")
{
if (listHasilData.Count > 0)
{
textBoxSPK.Text = listHasilData[0].NomorSPK.NoSPK;
textBoxTanggal.Text = listHasilData[0].TanggalKirim.ToString();
}
}
else
{
textBoxSPK.Text = "";
textBoxTanggal.Text = "";
}
}
private void buttonCari_Click(object sender, EventArgs e)
{
string nilaiKriteria = textBoxCari.Text;
if (comboBoxCari.Text == "Kode Pengiriman")
{
kriteria = "P.kodePengiriman";
}
else if (comboBoxCari.Text == "Jenis Penerimaan")
{
kriteria = "P.jenisPenerimaan";
}
else if (comboBoxCari.Text == "Biaya Kirim")
{
kriteria = "P.biayaKirim";
}
else if (comboBoxCari.Text == "Tanggal Kirim")
{
kriteria = "P.tglKirim";
}
else if (comboBoxCari.Text == "Nama")
{
kriteria = "P.nama";
}
else if (comboBoxCari.Text == "Keterangan")
{
kriteria = "P.keterangan";
}
else if (comboBoxCari.Text == "Nomor Nota Penjualan")
{
kriteria = "NP.noNotaPenjualan";
}
else if (comboBoxCari.Text == "ID Ekspedisi")
{
kriteria = "E.idEkspedisi";
}
else if (comboBoxCari.Text == "Nama Ekspedisi")
{
kriteria = "E.namaEkspedisi";
}
string hasilBaca = Pengiriman.BacaData(kriteria, nilaiKriteria, listHasilData);
if (hasilBaca == "1")
{
dataGridViewPengiriman.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
if (listHasilData[i].JenisPengiriman == "SP")
{
jenis = "Shipping Point";
}
else
{
jenis = "Destination Point";
}
string total = listHasilData[i].BiayaKirim.ToString("RP 0,###");
dataGridViewPengiriman.Rows.Add(listHasilData[i].KodePengiriman, jenis,
total, listHasilData[i].TglKirim.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Nama, listHasilData[i].Keterangan, listHasilData[i].NotaPenjualan.NoNotaPenjualan,
listHasilData[i].Ekspedisi.IdEkspedisi, listHasilData[i].Ekspedisi.Nama);
}
}
}
