public Penerimaan(string pNomor, Pengiriman p, DateTime pTanggal, string pNama, string pAlamat, string pKeterangan)
{
Nomor = pNomor;
NomorPengiriman = p;
Tanggal = pTanggal;
Nama = pNama;
Alamat = pAlamat;
Keterangan = pKeterangan;
}
public static string HapusData(Pengiriman pPengiriman)
{
string sql = "DELETE FROM pengiriman WHERE nomor_dokumen = '" + pPengiriman.NomorDokumen + "'";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}
public static string UbahData(Pengiriman pPengiriman)
{
string sql = "UPDATE INTO pengiriman SET tanggal_pengiriman ='" + pPengiriman.TanggalKirim.ToString("yyyy-MM-dd hh:mm:ss")
+ "' WHERE nomor_dokumen = '" + pPengiriman.NomorDokumen + "'";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}
public static string TambahData(Pengiriman pPengiriman)
{
string sql = "INSERT INTO pengiriman VALUES ('" +
pPengiriman.NomorDokumen + "','" +
pPengiriman.NomorSPK.NoSPK + "','" +
pPengiriman.TanggalKirim.ToString("yyyy-MM-dd hh:mm:ss") + "')";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}
public static string BacaData(string kriteria, string nilaiKriteria, List <Penerimaan> listHasilData)
{
string sql = "";
if (kriteria == "")
{
sql = "SELECT PT.nomor, PT.nomor_dokumen_pengiriman, PT.tanggal, PT.nama, PT.alamat, PT.keterangan FROM nota_penerimaan PT";
}
else
{
sql = "SELECT PT.nomor, PT.nomor_dokumen_pengiriman, PT.tanggal, PT.nama, PT.alamat, PT.keterangan FROM nota_penerimaan PT WHERE "
+ kriteria + " LIKE '%" + nilaiKriteria + "%'";
}
try
{
MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql);
while (hasilData.Read() == true)
{
Pengiriman p = new Pengiriman();
p.NomorDokumen = hasilData.GetValue(1).ToString();
Penerimaan PT = new Penerimaan();
PT.Nomor = hasilData.GetValue(0).ToString();
PT.Tanggal = DateTime.Parse(hasilData.GetValue(2).ToString());
PT.Nama = hasilData.GetValue(3).ToString();
PT.Alamat = hasilData.GetValue(4).ToString();
PT.Keterangan = hasilData.GetValue(5).ToString();
PT.NomorPengiriman = p;
listHasilData.Add(PT);
}
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
return("1");
}
public static string BacaData(string kriteria, string nilaiKriteria, List <Pengiriman> listHasilData)
{
string sql = "";
if (kriteria == "")
{
sql = "SELECT P.nomor_dokumen, P.tanggal_pengiriman, S.nomor FROM pengiriman P INNER JOIN spk S ON P.nomor_spk=S.nomor";
}
else
{
sql = "SELECT P.nomor_dokumen, P.tanggal_pengiriman, S.nomor FROM pengiriman P INNER JOIN spk S ON P.nomor_spk=S.nomor WHERE "
+ kriteria + " LIKE '%" + nilaiKriteria + "%'";
}
try
{
MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql);
while (hasilData.Read() == true)
{
Pengiriman p = new Pengiriman();
p.NomorDokumen = hasilData.GetValue(0).ToString();
p.TanggalKirim = DateTime.Parse(hasilData.GetValue(1).ToString());
Spk s = new Spk();
s.NoSPK = hasilData.GetValue(2).ToString();
p.NomorSPK = s;
listHasilData.Add(p);
}
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
return("1");
}
