private void RefreshGrd()
{
string islem = "C";
if (ISLEM.GetString() != "")
{
islem = ISLEM.GetString();
}
grdRapor.SQLText = "SELECT STOK_ADI AS STOK_ADI, SUM(MIKTAR) AS MIKTAR, SUM(TUTAR) AS TUTAR, SUM(KAR) AS KAR FROM (SELECT STOK.STOK_ADI, CASE WHEN GC = '" + islem + "' THEN HAR.MIKTAR " +
"ELSE 0.0 END AS MIKTAR , ";
if (islem == "C")
{
grdRapor.SQLText += "HAR.BIRIM_FIYAT* MIKTAR AS TUTAR, ";
}
else
{
grdRapor.SQLText += "STOK.ALIS_FIYAT * MIKTAR AS TUTAR, ";
}
if (islem == "C")
{
grdRapor.SQLText += "((STOK.SATIS_FIYAT * MIKTAR) - (STOK.ALIS_FIYAT * MIKTAR)) AS KAR ";
}
else
{
grdRapor.SQLText += "0 AS KAR ";
}
grdRapor.SQLText += "FROM[TBLSTOKHAR] HAR, TBLSTOK STOK " +
"WHERE /*WS*/TARIH BETWEEN '" + BAS_TAR.GetSQLDataStr() + " 00:00:00' AND '" + BIT_TAR.GetSQLDataStr() + " 23:59:59' AND STOK.STOK_KODU = HAR.STOK_KODU " +
"AND GC = '" + islem + "' " +
"/*WE*/) AS RAPOR " +
"GROUP BY STOK_ADI";
grdRapor.Open();
}
private void Raporla()
{
grdSipListe.SQLText = "SELECT REC_ID, BELGE_NO, CONVERT(VARCHAR(10), CONVERT(SMALLDATETIME, TARIH, 106), 104) AS TARIH, TUTAR, " +
"(SELECT FIRMA_ADI FROM TBLKULLANICI KUL WHERE KUL.KULLANICI_KODU = SIP.KULLANICI_KODU) AS FIRMA_ADI, " +
"CASE " +
" WHEN ODEME_TURU = 0 THEN 'Havale-EFT' " +
" WHEN ODEME_TURU = 1 THEN 'Kredi Kartı' END AS ODEME_TURU " +
", CASE " +
" WHEN DEMIR_FLOAT_2 = 1 THEN 'Sipariş Alındı' " +
" WHEN DEMIR_FLOAT_2 = 2 THEN 'Kargoda' " +
" ELSE 'Bekleyen Sipariş' END AS DURUM ";
if (durum == 1)
{
grdSipListe.SQLText += ",'Durum Güncelle' AS SIP_DURUM ";
}
grdSipListe.SQLText += "FROM [TBLSIPARIS] SIP " +
"WHERE /*WS*/ISNULL(DURUM, 1) = " + durum + " ";
if (FIRMA_ADI.IsNotEmpty())
{
grdSipListe.SQLText += "AND KULLANICI_KODU = (SELECT KULLANICI_KODU FROM TBLKULLANICI KUL WHERE KUL.FIRMA_ADI = '" + FIRMA_ADI.Text + "') ";
}
grdSipListe.SQLText += "AND TARIH BETWEEN '" + BAS_TAR.GetSQLDataStr() + "' AND '" + BIT_TAR.GetSQLDataStr() + "' ";
grdSipListe.SQLText += "/*WE*/";
if (durum == 2)
{
grdSipDurum.Visible = false;
grdDURUM.Visible = false;
}
grdSipListe.Open();
}
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 RefreshGrd()
{
grdStokHareketRaporu.SQLText = "SELECT HAR.TARIH, " +
"CASE " +
" WHEN HAR.BELGE_TIPI IN(1, 2) THEN(SELECT EVRAK_NO FROM TBLFATURA WHERE BELGE_NO = HAR.BELGE_NO) " +
" ELSE '' END AS EVRAK_NO " +
", CASE " +
" WHEN HAR.BELGE_TIPI IN(1, 2) THEN(SELECT VADE_TARIHI FROM TBLFATURA WHERE BELGE_NO = HAR.BELGE_NO) " +
" ELSE HAR.TARIH END AS VADE_TARIHI " +
", HAR.BELGE_NO " +
", (SELECT BELGE_ADI FROM TBLBELGETIP BELGETIP WHERE BELGETIP.BELGE_TIPI = HAR.BELGE_TIPI) AS ISLEM " +
", CASE " +
" WHEN GC = 'C' THEN HAR.MIKTAR " +
" ELSE 0.0 END AS CIKIS " +
", CASE " +
" WHEN GC = 'G' THEN HAR.MIKTAR " +
" ELSE 0.0 END AS GIRIS " +
", ISNULL((SELECT SUM(HAR_TEMP.MIKTAR) FROM TBLSTOKHAR HAR_TEMP WHERE HAR_TEMP.REC_ID <= HAR.REC_ID AND HAR_TEMP.GC = 'G' AND HAR_TEMP.STOK_KODU = HAR.STOK_KODU), 0) " +
" -ISNULL((SELECT SUM(HAR_TEMP.MIKTAR) FROM TBLSTOKHAR HAR_TEMP WHERE HAR_TEMP.REC_ID <= HAR.REC_ID AND HAR_TEMP.GC = 'C' AND HAR_TEMP.STOK_KODU = HAR.STOK_KODU), 0) AS BAKIYE "+
"FROM[TBLSTOKHAR] HAR " +
"WHERE /*WS*/STOK_KODU = '" + STOK_KODU.Text + "' ";
if (stokKodu == "")
{
grdStokHareketRaporu.SQLText += "AND TARIH BETWEEN '" + BAS_TAR.GetSQLDataStr() + "' AND '" + BIT_TAR.GetSQLDataStr() + "' ";
}
grdStokHareketRaporu.SQLText += "/*WE*/ " +
"ORDER BY HAR.REC_ID";
grdStokHareketRaporu.Open();
grdStokHareketRaporu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
private void miYazdir_Click(object sender, EventArgs e)
{
if (dsRapor != null)
{
ArsSQLQry qryGarsonSatisRap = new ArsSQLQry();
qryGarsonSatisRap.SQLText = "SELECT " +
"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 " +
", SUM(HAR.MIKTAR) AS MIKTAR " +
"FROM[TBLBLUEGARSONHAR] HAR, TBLSTOK STOK " +
"WHERE /*WS*/HAR.STOK_KODU = STOK.STOK_KODU " +
"AND HAR.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "' AND HAR.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "'/*WE*/" +
"GROUP BY HAR.GARSON_RECID, STOK.STOK_ADI " +
"ORDER BY HAR.GARSON_RECID, STOK.STOK_ADI ";
qryGarsonSatisRap.Open();
ArsSQLQry qryIptalUrunRap = new ArsSQLQry();
qryIptalUrunRap.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 + "' " +
"ORDER BY IPTAL.CREATE_DATE";
qryIptalUrunRap.Open();
GunSonuBakiyeRaporuMiniDizayn reportDesign = new GunSonuBakiyeRaporuMiniDizayn();
reportDesign.basTarStr = BAS_TAR.Text + " " + BAS_SAAT.Text;
reportDesign.bitTarStr = BIT_TAR.Text + " " + BIT_SAAT.Text;
reportDesign.topGiren = TOP_GIREN.Text;
reportDesign.topCikan = TOP_CIKAN.Text;
reportDesign.bakiye = BAKIYE.Text;
reportDesign.DataSource = dsRapor;
//reportDesign.ShowRibbonPreview();
reportDesign.Print("Merkez");
GarsonSatisRaporuMiniDizayn reportDesign2 = new GarsonSatisRaporuMiniDizayn();
reportDesign2.DataSource = qryGarsonSatisRap.dataSet;
//reportDesign2.ShowRibbonPreview();
reportDesign2.Print("Merkez");
IptalUrunRaporuMiniDizayn reportDesign3 = new IptalUrunRaporuMiniDizayn();
reportDesign3.DataSource = qryIptalUrunRap.dataSet;
//reportDesign3.ShowRibbonPreview();
reportDesign3.Print("Merkez");
}
}
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 RefreshGrd()
{
grdCariHareketRaporu.SQLText = "SELECT HAR.CARI_KODU, CARI_ADI, GETDATE() AS OLUSTURMA_TARIH, TARIH, EVRAK_NO, VADE_TARIHI, BELGE_NO, " +
"CASE " +
" WHEN MODUL = 'ft' THEN 'Fatura' " +
" WHEN MODUL = 'cs' THEN 'Çek' " +
" WHEN MODUL = 'ks' THEN 'Kasa' " +
" WHEN MODUL = 'bn' THEN 'Banka' END AS MODUL , " +
"CASE " +
" WHEN MODUL = 'ft' THEN(SELECT BELGE_ADI FROM TBLBELGETIP BELGETIP WHERE BELGETIP.BELGE_TIPI = SUBSTRING(CONVERT(VARCHAR(10), HAR.BELGE_TIPI), 3, 2)) " +
" WHEN MODUL = 'cs' THEN(SELECT BELGE_ADI FROM TBLCEKSENBELGETIP BELGETIP WHERE BELGETIP.BELGE_TIPI = SUBSTRING(CONVERT(VARCHAR(10), HAR.BELGE_TIPI), 3, 2)) " +
" WHEN MODUL = 'bn' THEN(SELECT BELGE_ADI FROM TBLBANKABELGETIP BELGETIP WHERE BELGETIP.BELGE_TIPI = SUBSTRING(CONVERT(VARCHAR(10), HAR.BELGE_TIPI), 3, 2)) " +
" WHEN MODUL = 'ks' THEN(SELECT BELGE_ADI FROM TBLKASABELGETIP BELGETIP WHERE BELGETIP.BELGE_TIPI = SUBSTRING(CONVERT(VARCHAR(10), HAR.BELGE_TIPI), 3, 2)) END AS ISLEM , " +
"CASE " +
" WHEN BORC_ALACAK = 'B' THEN TUTAR " +
" ELSE 0.0 END AS BORC , " +
"CASE " +
" WHEN BORC_ALACAK = 'A' THEN TUTAR " +
" ELSE 0.0 END AS ALACAK , " +
" 0.0 AS BAKIYE " +
"FROM[TBLCARIHAR] HAR, TBLCARI CARI WHERE /*WS*/HAR.CARI_KODU = '" + CARI_KODU.Text + "' AND HAR.CARI_KODU = CARI.CARI_KODU ";
if (cariKodu == "")
{
grdCariHareketRaporu.SQLText += "AND TARIH BETWEEN '" + BAS_TAR.GetSQLDataStr() + "' AND '" + BIT_TAR.GetSQLDataStr() + "' ";
if (HAREKET_TIPI.SelectedIndex != 0)
{
if (HAREKET_TIPI.SelectedIndex == 1)
{
grdCariHareketRaporu.SQLText += "AND BORC_ALACAK = 'B' ";
}
else
{
grdCariHareketRaporu.SQLText += "AND BORC_ALACAK = 'A' ";
}
}
}
grdCariHareketRaporu.SQLText += "/*WE*/" +
"ORDER BY TARIH, HAR.REC_ID";
grdCariHareketRaporu.Open();
grdCariHareketRaporu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
private void grdMasaRaporu_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
if (grdMasaRaporu.Rows.Count > 0)
{
double toplamTutar = 0.0;
foreach (DataGridViewRow row in grdMasaRaporu.Rows)
{
if (Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString()) > 0.0)
{
toplamTutar += Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString());
}
}
ArsSQLQry qryKapananMasaSayisi = new ArsSQLQry();
qryKapananMasaSayisi.SQLText = "SELECT COUNT(*) MASA_SAYISI FROM [TBLBLUEADISYON] AD WHERE /*WS*/AD.DURUM = 1 " +
"AND AD.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "' AND AD.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "' /*WE*/";
qryKapananMasaSayisi.Open();
TOPLAM_TUTAR.SetDoubleData(toplamTutar);
ACIK_MASA_SAYISI.SetDoubleData(qryKapananMasaSayisi.GetInt("MASA_SAYISI"));
}
}
private void RefreshGrid()
{
grdGarsonHareketRaporu.SQLText = "SELECT " +
"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 " +
", SUM(HAR.MIKTAR) AS MIKTAR " +
", SUM(HAR.MIKTAR * STOK.SATIS_FIYAT) AS TUTAR " +
"FROM[TBLBLUEGARSONHAR] HAR, TBLSTOK STOK " +
"WHERE /*WS*/HAR.STOK_KODU = STOK.STOK_KODU ";
if (GARSON_KODU.IsNotEmpty())
{
grdGarsonHareketRaporu.SQLText += "AND HAR.GARSON_RECID = (SELECT REC_ID FROM TBLBLUEGARSON WHERE GARSON_KODU = '" + GARSON_KODU.GetDataStr() + "')";
}
grdGarsonHareketRaporu.SQLText += "AND HAR.CREATE_DATE >= '" + BAS_TAR.GetSQLDataStr() + " 00:00:00' AND HAR.CREATE_DATE <= '" + BIT_TAR.GetSQLDataStr() + " 23:59:59'/*WE*/" +
"GROUP BY HAR.GARSON_RECID, STOK.STOK_ADI " +
"ORDER BY HAR.GARSON_RECID, STOK.STOK_ADI ";
grdGarsonHareketRaporu.Open();
dsRapor = grdGarsonHareketRaporu.gridDataSet;
}
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 RefreshGrd()
{
grdGunSonuBakiyeRaporu.SQLText = "EXEC proc_GunSonuBakiyeRaporu '" + BAS_TAR.GetSQLDataStr() + " " + BAS_SAAT.Text + "', '" + BIT_TAR.GetSQLDataStr() + " " + BIT_SAAT.Text + "'";
grdGunSonuBakiyeRaporu.Open();
dsRapor = grdGunSonuBakiyeRaporu.gridDataSet;
}
private void RefreshGrd()
{
if (kasaKodu == "")
{
grdKasaHareketRaporu.SQLText = "EXEC proc_KasaHareketRaporu '" + KASA_KODU.Text + "', '" + BAS_TAR.GetSQLDataStr() + "', '" + BIT_TAR.GetSQLDataStr() + "', ";
if (DEVIRLI_MI.Checked)
{
grdKasaHareketRaporu.SQLText += DEVIRLI_MI.CheckedValue;
}
else
{
grdKasaHareketRaporu.SQLText += DEVIRLI_MI.UnCheckedValue;
}
}
else
{
grdKasaHareketRaporu.SQLText = "EXEC proc_KasaHareketRaporu '" + KASA_KODU.Text + "', '', '', ";
if (DEVIRLI_MI.Checked)
{
grdKasaHareketRaporu.SQLText += DEVIRLI_MI.CheckedValue;
}
else
{
grdKasaHareketRaporu.SQLText += DEVIRLI_MI.UnCheckedValue;
}
}
grdKasaHareketRaporu.Open();
grdKasaHareketRaporu.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}