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"); }