private void C02_Statistic_Load(object sender, EventArgs e) { C02_StatisticBUS staBUS = new C02_StatisticBUS(); this.dataGridView1.DataSource = staBUS.loadBillList(); DisableAllDateTimePicker(); this.lblTotalQuantity.Text = TotalQuantity(); this.lblTotalAmount.Text = TotalAmount(); }
private void btnFilter_Click(object sender, EventArgs e) { C02_StatisticBUS staBUS = new C02_StatisticBUS(); if (this.rbtnYear.Checked) { int yearfr = Convert.ToInt32(this.dpFromYear_FilterByYear.Value.Year.ToString()); DateTime from = new DateTime(yearfr, 1, 1); int yearto = Convert.ToInt32(this.dpToYear_FilterByYear.Value.Year.ToString()); DateTime to = new DateTime(yearto, 12, 31); this.dataGridView1.DataSource = staBUS.ViewYearRange(from, to); } if (rbtnMonth.Checked) { int monthfr = Convert.ToInt32(this.dpFromMonth_FilterByMonth.Value.Month.ToString()); int yearfr = Convert.ToInt32(this.dpFromMonth_FilterByMonth.Value.Year.ToString()); DateTime from = new DateTime(yearfr, monthfr, 1); int monthto = Convert.ToInt32(this.dpToMonth_FilterByMonth.Value.Month.ToString()); int yearto = Convert.ToInt32(this.dpToMonth_FilterByMonth.Value.Year.ToString()); DateTime to = new DateTime(yearto, monthto, 31); this.dataGridView1.DataSource = staBUS.ViewDateRange(from, to); } if (rbtnDay.Checked) { this.dataGridView1.DataSource = staBUS.ViewDateRange(this.dateTimePicker2.Value, this.dateTimePicker1.Value); } this.lblTotalQuantity.Text = TotalQuantity(); this.lblTotalAmount.Text = TotalAmount(); }