public void CoBox() { String q, f; q = "SELECT * FROM tbl_barang"; f = "NamaBarang"; qr.ShowBox(q, f, cb); }
public UserData() { InitializeComponent(); Kelas.Query qr = new Kelas.Query(); String q = "SELECT * FROM users WHERE users.UseId=detail.UseId"; qr.ShowAll(q, "users", dg_user); dg_user.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dg_user.AllowUserToAddRows = false; dg_user.Refresh(); qr.ShowBox(q, "UseId", cb1); }
public TransactionReport() { InitializeComponent(); SetLabel(); qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rt); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar", "All", chart1); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Standar'", "Standar", chart1); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Super'", "Super", chart1); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Deluxe Room'", "Deluxe", chart1); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Superior Room'", "Deluxe", chart1); qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Excekutif Room'", "Excekutif", chart1); }
public Employee() { InitializeComponent(); qr = new Kelas.Query(); String q = "SELECT * from Employee"; tampil(q); qr.ShowBox("SELECT * FROM Job", "Name", cm_job); clear(); button(1); id.Visible = false; }
public void Box() { qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rt); qr.ShowBox("SELECT * FROM JenisPemesanan", "NamaJenisPemesanan", rt2); qr.ShowBox("SELECT * FROM FasilitasTambahan", "NamaFailitasTambahan", af); qr.ShowBox("select NamaPenghuni+' - '+Email as 'n' from Penghuni", "n", nm); }
public void Box() { qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rmtyp); }
public void Box() { qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rm); qr.ShowBox("SELECT * FROM Fasilitas", "NamaFasilitas", fn); }
public void Box() { qr.ShowBox("SELECT * FROM Kamar", "NomorKamar", rm); }
public void Box() { qr.ShowBox("SELECT * FROM TypeKendaraan", "NamaTypeKendaraan", vt); }
public void Box() { qr.ShowBox("SELECT * FROM Pemesanan", "IDPemesanan", bk); }