private void RefreshGrid() { grdMasaRaporu.SQLText = "SELECT AD.REC_ID " + ", MASA_TANIMI " + ",AD.CREATE_DATE AS ACILIS_ZAMANI " + ", FAT.CREATE_DATE AS KAPANIS_ZAMANI " + ", FAT.GENEL_TOPLAM AS TUTAR " + ", CASE " + " WHEN(SELECT COUNT(*) FROM TBLKASAHAR WHERE UST_BELGE_TIPI = 'ft1' AND UST_BELGE_NO = FAT.BELGE_NO) > 0 " + " THEN(SELECT KASA_ADI FROM TBLKASA WHERE KASA_KODU = (SELECT KASA_KODU FROM TBLKASAHAR WHERE UST_BELGE_TIPI = 'ft1' AND UST_BELGE_NO = FAT.BELGE_NO)) " + " WHEN(SELECT COUNT(*) FROM TBLBANKAHAR WHERE UST_BELGE_TIPI = 'ft1' AND UST_BELGE_NO = FAT.BELGE_NO) > 0 "+ " THEN(SELECT HESAP_ADI FROM TBLBANKA WHERE HESAP_KODU = (SELECT BANKA_KODU FROM TBLBANKAHAR WHERE UST_BELGE_TIPI = 'ft1' AND UST_BELGE_NO = FAT.BELGE_NO)) " + " ELSE '' "+ " END AS ODEME_YERI " + ", CASE " + " WHEN(SELECT COUNT(*) FROM TBLFATURA WHERE ADISYON_RECID = AD.REC_ID) > 1 THEN 'Kısmi Ödeme' " + " ELSE 'Tüm Ödeme' END AS ODEME_TIPI " + "FROM[TBLBLUEADISYON] AD, TBLFATURA FAT, TBLBLUEMASA MASA " + "WHERE FAT.ADISYON_RECID = AD.REC_ID " + "AND MASA.REC_ID = AD.MASA_RECID " + "AND AD.DURUM = 1 " + "AND AD.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "' AND AD.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "' "; if (MASA_TANIMI.IsNotEmpty()) { grdMasaRaporu.SQLText += "AND MASA.MASA_TANIMI = '" + MASA_TANIMI.GetDataStr() + "' "; } grdMasaRaporu.SQLText += "ORDER BY AD.TARIH"; grdMasaRaporu.Open(); dsRapor = grdMasaRaporu.gridDataSet; }
private void MASA_TANIMI_KeyDown(object sender, KeyEventArgs e) { if (e.Modifiers == Keys.Control && e.KeyCode == Keys.F1) { if (MASA_TANIMI.IsNotEmpty()) { ArsSQLQry qryMasa = new ArsSQLQry(); qryMasa.SQLText = "SELECT TOP 1 MASA_TANIMI FROM [TBLBLUEMASA] WHERE /*WS*/MASA_TANIMI LIKE '" + MASA_TANIMI.GetDataStr() + "%'/*WE*/ ORDER BY REC_ID DESC"; qryMasa.Open(); if (qryMasa.Found()) { MASA_TANIMI.SetDataStr(qryMasa.GetString("MASA_TANIMI")); } } } }
private void RefreshGrid() { grdIptalStok.SQLText = "SELECT MASA_TANIMI, IPTAL.STOK_ISIM AS STOK_ADI, IPTAL.MIKTAR, IPTAL.CREATE_DATE TARIH, IPTAL.ACIKLAMA, " + "ISNULL(IPTAL.BIRIM_FIYAT, 0) * ISNULL(IPTAL.MIKTAR, 0) AS TUTAR" + ", IPTAL.GARSON_ADI " + "FROM TBLBLUEADISYONIPTAL IPTAL, TBLBLUEADISYON AD, TBLBLUEMASA MASA " + "WHERE IPTAL.ADISYON_RECID = AD.REC_ID " + "AND AD.MASA_RECID = MASA.REC_ID " + "AND IPTAL.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "' AND IPTAL.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "' "; if (MASA_TANIMI.IsNotEmpty()) { grdIptalStok.SQLText += "AND MASA.MASATANIMI = '" + MASA_TANIMI.GetDataStr() + "' "; } grdIptalStok.SQLText += "ORDER BY IPTAL.CREATE_DATE"; grdIptalStok.Open(); dsRapor = grdIptalStok.gridDataSet; }
private void MASA_TANIMI_ArsExit(object sender, EventArgs e) { if (MASA_TANIMI.IsNotEmpty()) { ArsSQLQry qryMasa = new ArsSQLQry(); qryMasa.SQLText = "SELECT * FROM [TBLBLUEMASA] WHERE /*WS*/MASA_TANIMI = '" + MASA_TANIMI.Text + "'/*WE*/"; qryMasa.Open(); if (qryMasa.Found()) { ArsLibrary.ArsQryToPanel(PnlMasa, qryMasa); } else { PnlMasa.Clear(MASA_TANIMI.ArTag); } } else { PnlMasa.Clear(); } }
private void BtnSil_Click(object sender, EventArgs e) { MASA_TANIMI_ArsExit(MASA_TANIMI, null); if (MASA_TANIMI.IsNotEmpty()) { if (ArsMessage.Question("Sil Onay", "Kayıt Silinsin Mi?\nMasa Adı: " + MASA_TANIMI.Text) == DialogResult.Yes) { ArsSQLQry qryMasa = new ArsSQLQry(); qryMasa.SQLText = "SELECT * FROM [TBLBLUEMASA] WHERE /*WS*/MASA_TANIMI = '" + MASA_TANIMI.Text + "'/*WE*/"; qryMasa.Open(); qryMasa.Mode = EnmQryMode.Delete; qryMasa.Exec(); if (qryMasa.execErrorCode == "0") { grdMasa.RefreshGrid(); ArsMessage.ShowMessage("Bilgi", "Kayıt Silme Başarılı"); BtnTemizle_Click(BtnTemizle, null); } } } MASA_TANIMI.Focus(); }
private void BtnKaydet_Click(object sender, EventArgs e) { if (PnlMasa.CanNullsCheck()) { ArsSQLQry qryMasa = new ArsSQLQry(); qryMasa.SQLText = "SELECT * FROM [TBLBLUEMASA] WHERE /*WS*/MASA_TANIMI = '" + MASA_TANIMI.Text + "'/*WE*/"; qryMasa.Open(); if (qryMasa.Found()) { qryMasa.Mode = EnmQryMode.Update; } else { qryMasa.Mode = EnmQryMode.Insert; } ArsLibrary.ArsPanelToQry(PnlMasa, qryMasa); qryMasa.Exec(); if (qryMasa.execErrorCode == "0") { grdMasa.RefreshGrid(); switch (qryMasa.Mode) { case EnmQryMode.Update: ArsMessage.ShowMessage("Bilgi", "Kayıt Düzenleme Başarılı"); break; case EnmQryMode.Insert: ArsMessage.ShowMessage("Bilgi", "Kayıt Ekleme Başarılı"); break; } BtnTemizle_Click(BtnTemizle, null); } } MASA_TANIMI.Focus(); }
private void RefreshGrid() { grdMasaHareketRaporu.SQLText = "SELECT " + "MASA.MASA_TANIMI AS MASA_ADI " + ", CASE HAR.GARSON_RECID " + " WHEN - 1 THEN 'Kasa' " + " ELSE(SELECT GARSON_ADI FROM TBLBLUEGARSON GARSON WHERE GARSON.REC_ID = HAR.GARSON_RECID) " + " END AS GARSON_ADI " + ", STOK.STOK_ADI " + ", MIKTAR, HAR.CREATE_DATE AS TARIH " + "FROM[TBLBLUEGARSONHAR] HAR, TBLSTOK STOK, TBLBLUEADISYON AD, TBLBLUEMASA MASA " + "WHERE /*WS*/HAR.STOK_KODU = STOK.STOK_KODU "; if (MASA_TANIMI.IsNotEmpty()) { grdMasaHareketRaporu.SQLText += "AND MASA.MASA_TANIMI = '" + MASA_TANIMI.GetDataStr() + "' "; } grdMasaHareketRaporu.SQLText += "AND HAR.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "' AND HAR.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "' " + "AND HAR.ADISYON_RECID = AD.REC_ID " + "AND AD.MASA_RECID = MASA.REC_ID " + "AND (SELECT COUNT(*) FROM TBLBLUEADISYONHAR ADHAR WHERE ADHAR.ADISYON_RECID = AD.REC_ID) > 0 /*WE*/" + "ORDER BY HAR.CREATE_DATE, HAR.GARSON_RECID, STOK.STOK_ADI "; grdMasaHareketRaporu.Open(); dsRapor = grdMasaHareketRaporu.gridDataSet; }
private void BtnTemizle_Click(object sender, EventArgs e) { PnlMasa.Clear(); MASA_TANIMI.Focus(); }