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