private void button1_Click(object sender, EventArgs e) { string ma = comboBox1.Text; string bd = dateTimePicker1.Text; string kt = dateTimePicker2.Text; if (ma != "" && bd != "" && kt != "") { dataGridView1.DataSource = bus.ThongKeDoanhThu(ma, bd, kt); int tong = 0; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { tong = tong + Int32.Parse(dataGridView1.Rows[i].Cells["DOANHTHU"].Value.ToString()); } textBox1.Text = tong.ToString(); } }
public void ThongKeDoanhThu() { // Xử lý request /* * int pageSize = 10; * if (Request["results"] != null) * pageSize = int.Parse((string)Request["results"]); * * int pageNum = 1; * if (Request["startIndex"] != null) * pageNum = (int.Parse((string)Request["startIndex"]) / pageSize) + 1; */ String hinhthuc = Request["hinhthuc"]; DateTime ngaybatdau = DateTime.Parse(Request["ngaybatdau"].ToString()); DateTime ngayketthuc = DateTime.Parse(Request["ngayketthuc"].ToString()); ThongKeBUS bus = new ThongKeBUS(); ArrayList arrKq = bus.ThongKeDoanhThu(hinhthuc, ngaybatdau, ngayketthuc); XL_THE Kq = new XL_THE("DANH_SACH"); XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("totalRecords", arrKq.Count.ToString()); Kq.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); foreach (ThongKeDoanhThu tk in arrKq) { XL_THE the = new XL_THE("Record"); Thuoc_tinh = new XL_THUOC_TINH("NgayBatDau", tk.NgayBatDau.ToShortDateString()); the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("NgayKetThuc", tk.NgayKetThuc.ToShortDateString()); the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("DoanhThu", tk.DoanhThu.ToString()); the.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(the); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }