예제 #1
0
        private void grdMasaDurumRaporu_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
            if (grdMasaDurumRaporu.Rows.Count > 0)
            {
                double toplamTutar  = 0.0;
                double toplamOdenen = 0.0;
                double toplamKalan  = 0.0;

                foreach (DataGridViewRow row in grdMasaDurumRaporu.Rows)
                {
                    if (Convert.ToDouble(row.Cells["grdTOPLAM_TUTAR"].Value.ToString()) > 0.0)
                    {
                        toplamTutar += Convert.ToDouble(row.Cells["grdTOPLAM_TUTAR"].Value.ToString());
                    }
                    if (Convert.ToDouble(row.Cells["grdODENEN_TUTAR"].Value.ToString()) > 0.0)
                    {
                        toplamOdenen += Convert.ToDouble(row.Cells["grdODENEN_TUTAR"].Value.ToString());
                    }
                    if (Convert.ToDouble(row.Cells["grdKALAN_TUTAR"].Value.ToString()) > 0.0)
                    {
                        toplamKalan += Convert.ToDouble(row.Cells["grdKALAN_TUTAR"].Value.ToString());
                    }
                }

                TOPLAM_TUTAR.SetDoubleData(toplamTutar);
                ODENEN_TUTAR.SetDoubleData(toplamOdenen);
                KALAN_TUTAR.SetDoubleData(toplamKalan);
                ACIK_MASA_SAYISI.SetDoubleData(grdMasaDurumRaporu.Rows.Count);
            }
        }
예제 #2
0
        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"));
            }
        }
예제 #3
0
        private void grdIptalStok_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
            if (grdIptalStok.Rows.Count > 0)
            {
                double toplamTutar = 0.0;
                double toplamAdet  = 0.0;

                foreach (DataGridViewRow row in grdIptalStok.Rows)
                {
                    if (Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString()) > 0.0)
                    {
                        toplamTutar += Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString());
                    }
                    if (Convert.ToDouble(row.Cells["grdMIKTAR"].Value.ToString()) > 0.0)
                    {
                        toplamAdet += Convert.ToDouble(row.Cells["grdMIKTAR"].Value.ToString());
                    }
                }

                TOPLAM_TUTAR.SetDoubleData(toplamTutar);
                ACIK_MASA_SAYISI.SetDoubleData(toplamAdet);
            }
        }
예제 #4
0
        private void grdGarsonHareketRaporu_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
            if (grdGarsonHareketRaporu.Rows.Count > 0)
            {
                double toplamMiktar = 0.0;
                double toplamTutar  = 0.0;

                foreach (DataGridViewRow row in grdGarsonHareketRaporu.Rows)
                {
                    if (Convert.ToDouble(row.Cells["grdMIKTAR"].Value.ToString()) > 0.0)
                    {
                        toplamMiktar += Convert.ToDouble(row.Cells["grdMIKTAR"].Value.ToString());
                    }
                    if (Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString()) > 0.0)
                    {
                        toplamTutar += Convert.ToDouble(row.Cells["grdTUTAR"].Value.ToString());
                    }
                }

                ACIK_MASA_SAYISI.SetDoubleData(toplamMiktar);
                TOPLAM_TUTAR.SetDoubleData(toplamTutar);
            }
        }