private void dtgridaylikkasa_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (dtgridaylikkasa.ColumnCount > 0) { dtgridaylikayrintlikasa.Columns.Clear(); string secili_ay = dtgridaylikkasa.CurrentRow.Cells[0].Value.ToString(); DatabaseClass database = new DatabaseClass(); string sorgu = "Select * FROM `günlük_kasa` WHERE aylar = '" + secili_ay + "'"; dtgridaylikayrintlikasa.DataSource = database.ListData(sorgu); dtgridaylikayrintlikasa.Columns[0].HeaderText = "TARİH"; dtgridaylikayrintlikasa.Columns[1].HeaderText = "AYLAR"; dtgridaylikayrintlikasa.Columns[2].HeaderText = "EURO"; dtgridaylikayrintlikasa.Columns[3].HeaderText = "DOLAR"; dtgridaylikayrintlikasa.Columns[4].HeaderText = "TL"; dtgridaylikayrintlikasa.Columns[5].HeaderText = "Hangi Yıl"; } } catch (Exception) { } }
private void datagridYillikKasa_CellClick(object sender, DataGridViewCellEventArgs e) { DatabaseClass database = new DatabaseClass(); try { if (datagridYillikKasa.ColumnCount > 0) { dtgridaylikkasa.Columns.Clear(); string secili_yil = datagridYillikKasa.CurrentRow.Cells[0].Value.ToString(); string sqlay = "select aylar, SUM(Euro) as EuroT, SUM(Dolar) as DolarT, SUM(TL) as TLT FROM `günlük_kasa` WHERE HANGI_YIL = '" + secili_yil + "' GROUP BY aylar"; dtgridaylikkasa.DataSource = database.ListData(sqlay); dtgridaylikkasa.Columns[0].HeaderText = "HANGİ AY?"; dtgridaylikkasa.Columns[1].HeaderText = "EURO"; dtgridaylikkasa.Columns[2].HeaderText = "DOLAR"; dtgridaylikkasa.Columns[3].HeaderText = "TL"; } } catch (Exception) { } }
private void kasadevirHesapla() { string tarih, yil, ay, gun; try { if (dataGridgKasa.ColumnCount > 0) { string secili_tarih = dataGridgKasa.CurrentRow.Cells[0].Value.ToString(); //dataGridgKasa_CellClick(sender, e); DateTime DTIME = Convert.ToDateTime(secili_tarih); yil = DTIME.Date.Year.ToString(); ay = DTIME.Date.Month.ToString(); gun = DTIME.Date.Day.ToString(); if (ay.Length <= 1) { ay = "0" + ay; } if (gun.Length <= 1) { gun = "0" + gun; } tarih = yil + "-" + ay + "-" + gun; DatabaseClass database = new DatabaseClass(); string sorgu = "select " + " SUM(CAST(REPLACE(TL, ',', '.') as DECIMAL(9, 2))) as TLT, " + " SUM(CAST(REPLACE(Euro, ',', '.') as DECIMAL(9,2))) EuroT," + "SUM(CAST(REPLACE(Dolar, ',', '.') as DECIMAL(9, 2))) as DolarT " + "FROM günlük_kasa WHERE Tarih <= '" + tarih + "'"; dataGVKasaDevir.Columns.Clear(); dataGVKasaDevir.DataSource = database.ListData(sorgu); dataGVKasaDevir.Columns[0].HeaderText = "TL"; dataGVKasaDevir.Columns[1].HeaderText = "EURO"; dataGVKasaDevir.Columns[2].HeaderText = "DOLAR"; lblTarih.Text = "-" + Convert.ToDateTime(secili_tarih).ToShortDateString() + "-"; datetpislemtarihi.Text = dataGridgKasa.CurrentRow.Cells[0].Value.ToString(); } } catch (Exception) { } }
private void Ayrintilar_Load(object sender, EventArgs e) { DatabaseClass database = new DatabaseClass(); string sql = "select HANGI_YIL, SUM(CAST(REPLACE(Euro, ',', '.') as DECIMAL(9, 2))) as EuroT, SUM(CAST(REPLACE(Dolar, ',', '.') as DECIMAL(9, 2))) as DolarT, SUM(CAST(REPLACE(TL, ',', '.') as DECIMAL(9, 2))) as TLT FROM `günlük_kasa` GROUP BY HANGI_YIL"; datagridYillikKasa.DataSource = database.ListData(sql); datagridYillikKasa.Columns[0].HeaderText = "HANGİ YIL?"; datagridYillikKasa.Columns[1].HeaderText = "EURO"; datagridYillikKasa.Columns[2].HeaderText = "DOLAR"; datagridYillikKasa.Columns[3].HeaderText = "TL"; string sqlay = "select aylar, SUM(CAST(REPLACE(Euro, ',', '.') as DECIMAL(9, 2))) as EuroT, SUM(CAST(REPLACE(Dolar, ',', '.') as DECIMAL(9, 2))) as DolarT, SUM(CAST(REPLACE(TL, ',', '.') as DECIMAL(9, 2))) as TLT FROM `günlük_kasa` GROUP BY aylar"; dtgridaylikkasa.DataSource = database.ListData(sqlay); dtgridaylikkasa.Columns[0].HeaderText = "HANGİ AY?"; dtgridaylikkasa.Columns[1].HeaderText = "EURO"; dtgridaylikkasa.Columns[2].HeaderText = "DOLAR"; dtgridaylikkasa.Columns[3].HeaderText = "TL"; }
private void listele() { string yil, ay, gun, tarih, tarih_2; dataGridgKasa.Columns.Clear(); DatabaseClass database = new DatabaseClass(); // DateTime DTIME = dateTimePicker1.Value; yil = DTIME.Date.Year.ToString(); ay = DTIME.Date.Month.ToString(); gun = DTIME.Date.Day.ToString(); if (ay.Length <= 1) { ay = "0" + ay; } if (gun.Length <= 1) { gun = "0" + gun; } tarih = yil + "-" + ay + "-" + gun; DateTime DTIME2 = dateTimePicker2.Value; yil = DTIME2.Date.Year.ToString(); ay = DTIME2.Date.Month.ToString(); gun = DTIME2.Date.Day.ToString(); if (ay.Length <= 1) { ay = "0" + ay; } if (gun.Length <= 1) { gun = "0" + gun; } tarih_2 = yil + "-" + ay + "-" + gun; String tarih1 = tarih; String tarih2 = tarih_2; // /* TARİH BAZLIYA DÖNÜŞTÜRÜLDÜ * yil = DateTime.Now.Date.Year.ToString(); * ay = DateTime.Now.Date.Month.ToString(); * gun = DateTime.Now.Date.Day.ToString(); * * string secili_gun, secili_gunt; // henuz kullanılmıyor. * if (gun.Length > 1) * { * secili_gun = (Convert.ToDouble(gun) - 1).ToString(); * secili_gunt = secili_gun + "/" + ay + "/" + yil; * } * else * { * secili_gun = "0"; * secili_gunt = gun + "/" + ay + "/" + yil; * } * * string secili_ay; * if (ay.Length > 1) * { * secili_ay =ay + "/" + yil; * } * else secili_ay = "0" + ay + "/" + yil;*/ string sql = "Select `Tarih`, `TL`, `Euro`, `Dolar` from günlük_kasa WHERE Tarih between '" + tarih1 + "' and '" + tarih2 + "' ORDER BY Tarih";; dataGridgKasa.DataSource = database.ListData(sql); dataGridgKasa.Columns[0].HeaderText = "TARİH"; dataGridgKasa.Columns[1].HeaderText = "TL"; dataGridgKasa.Columns[2].HeaderText = "EURO"; dataGridgKasa.Columns[3].HeaderText = "DOLAR"; // dataGridgKasa.Columns[0].Visible = false; if (dataGridgKasa.RowCount > 1) { double veresiyeToplamE = 0; double veresiyeToplamD = 0; double veresiyeToplamTl = 0; for (int i = 0; i < dataGridgKasa.Rows.Count; i++) { veresiyeToplamTl += Convert.ToDouble(dataGridgKasa.Rows[i].Cells[1].Value); veresiyeToplamE += Convert.ToDouble(dataGridgKasa.Rows[i].Cells[2].Value); veresiyeToplamD += Convert.ToDouble(dataGridgKasa.Rows[i].Cells[3].Value); } lblEuro.Text = "€ : " + veresiyeToplamE.ToString(); lblDolar.Text = "$ : " + veresiyeToplamD.ToString(); lblTL.Text = "TL : " + veresiyeToplamTl.ToString(); /*List<string> topalmdegerler = database.ListDatatab(secili_ay); * lblEuro.Text = " € : " + topalmdegerler[0]; * lblDolar.Text = " $ : " + topalmdegerler[1]; * lblTL.Text = " TL : " + topalmdegerler[2];*/ dataGridgKasa.ClearSelection(); // dataGridgKasa.Rows[dataGridgKasa.RowCount - 2].Selected = true; int nRowIndex = dataGridgKasa.Rows.Count - 1; int nColumnIndex = 2; dataGridgKasa.Rows[nRowIndex].Selected = true; dataGridgKasa.Rows[nRowIndex].Cells[nColumnIndex].Selected = true; dataGridgKasa.CurrentCell = dataGridgKasa.Rows[nRowIndex].Cells[nColumnIndex]; //In case if you want to scroll down as well. // dataGridgKasa.FirstDisplayedScrollingRowIndex = nRowIndex; kasadevirHesapla(); veresiyeHesapla(); } else { lblEuro.Text = " € : 0"; lblDolar.Text = " $ : 0"; lblTL.Text = " TL : 0"; } }