private void button1_Click(object sender, EventArgs e) { if (!cb.Checked) { MethodLoad.Datagridview(dataGridView1); DataTable dt = BLL.tb_TonDauKyBLL.layDuLieuBCTonDauKy( dateTimePicker1.Value, dateTimePicker2.Value ); dataGridView1.DataSource = dt; double sum = 0; for (int i = 0; i < dt.Rows.Count; i++) { double gtriHD = Convert.ToDouble(dt.Rows[i][4]); sum += gtriHD; } lblDT.Text = sum.ToString(); } else { MethodLoad.Datagridview(dataGridView1); DataTable dt = BLL.tb_TonDauKyBLL.layDuLieuBCHienTai(); dataGridView1.DataSource = dt; double sum = 0; for (int i = 0; i < dt.Rows.Count; i++) { double gtriHD = Convert.ToDouble(dt.Rows[i][4]); sum += gtriHD; } lblDT.Text = sum.ToString(); } }
private void frmHoaDon_ADD_Load(object sender, EventArgs e) { MethodLoad.LoadCombobox(cbbMaNCC, tb_NhaCungCapBLL.layDuLieu(), "Mã nhà cung cấp", "Tên nhà cung cấp"); MethodLoad.LoadCombobox(cbbMaNV, tb_NhanVienBLL.layDuLieu(), "Mã nhân viên", "Tên nhân viên"); cbbMaNV.SelectedIndex = 0; cbbMaNCC.SelectedIndex = 0; }
private void btnTaiLai_Click(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataGridView1, BLL.tb_ChiTietHoaDonNhapBLL.layDuLieuSoHD(mahoadonnhap)); dataGridView1.Columns[1].Visible = false; double sum = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { double sl = Convert.ToDouble(dataGridView1.Rows[i].Cells[4].Value.ToString()); double dg = Convert.ToDouble(dataGridView1.Rows[i].Cells[3].Value.ToString()); sum += sl * dg; lbTong.Text = sum.ToString(); } }
private void frmBanHang_Load(object sender, EventArgs e) { MethodLoad.LoadCombobox(cbxNhanVien, BLL.tb_NhanVienBLL.layDuLieu(), "Mã nhân viên", "Tên nhân viên"); MethodLoad.LoadCombobox(cbxKH, BLL.tb_KhachHangBLL.layDuLieu(), "Mã khách hàng", "Tên khách hàng"); MethodLoad.LoadDatagridview(dataGridView1, BLL.tb_MatHangBLL.layDuLieuRutGon()); for (int i = 0; i < dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = false; } dataGridView1.SelectionMode = DataGridViewSelectionMode.CellSelect; dataGridView1.Columns[2].ReadOnly = true; dataGridView1.Columns[3].ReadOnly = true; dataGridView1.Columns[4].ReadOnly = true; btnIn.Enabled = false; }
private void button1_Click(object sender, EventArgs e) { MethodLoad.Datagridview(dataGridView1); DataTable dt = BLL.tb_HoaDonBanBLL.layDuLieuBaoCao( dateTimePicker1.Value, dateTimePicker2.Value ); dataGridView1.DataSource = dt; //Thread.Sleep(3000); double sum = 0; for (int i = 0; i < dt.Rows.Count; i++) { double gtriHD = Convert.ToDouble(dt.Rows[i][6]); sum += gtriHD; } lblDT.Text = sum.ToString(); }
private void button1_Click(object sender, EventArgs e) { DataTable dt = BLL.tb_MatHangBLL.thongke(dateTimePicker1, dateTimePicker2); MethodLoad.LoadDatagridview(dataGridView1, dt); }
private void ucNhaCungCap_Load(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataNhaCungCap, tb_NhaCungCapBLL.layDuLieu()); dataNhaCungCap_CellClick(sender, new DataGridViewCellEventArgs(0, 0)); }
private void NhaCungCap_Load(object sender, EventArgs e) { DataTable dt = BLL.tb_NhaCungCapBLL.thongke(); MethodLoad.LoadDatagridview(dataGridView1, dt); }
private void ucKhachHang_Load(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataKhachHang, tb_KhachHangBLL.layDuLieu()); dataKhachHang_CellClick(sender, new DataGridViewCellEventArgs(0, 0)); }
private void frmHangHoa_ADD_Load(object sender, EventArgs e) { MethodLoad.LoadCombobox(cbbNhaCC, tb_NhaCungCapBLL.layDuLieu(), "Mã nhà cung cấp", "Tên nhà cung cấp"); MethodLoad.LoadCombobox(cbbNhomHang, tb_NhomHangBLL.layDuLieu(), "Mã nhóm hàng", "Tên nhóm hàng"); }
private void button1_Click(object sender, EventArgs e) { DataTable dt = BLL.tb_HoaDonBanBLL.layDuLieuBaoCao(dateTimePicker1.Value, dateTimePicker2.Value); MethodLoad.LoadDatagridview(dataGridView1, dt); }
private void ucNhomHang_Load(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataNhomHang, tb_NhomHangBLL.layDuLieu()); dataNhomHang_CellClick(sender, new DataGridViewCellEventArgs(0, 0)); dataNhomHang.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; }
private void button1_Click(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataTonDauKy, tb_TonDauKyBLL.tdk(dateTimePicker1.Value, dateTimePicker2.Value)); dataTonDauKy.Columns[dataTonDauKy.Columns.Count - 1].Visible = false; }
private void frmNhanVien_ADD_Load(object sender, EventArgs e) { MethodLoad.LoadCombobox(cbbPhongBan, tb_PhongBanBLL.layDuLieu(), "Mã phòng ban", "Tên phòng ban"); }
private void PhongBan_Load(object sender, EventArgs e) { DataTable dt = BLL.tb_PhongBanBLL.layDuLieu(); MethodLoad.LoadDatagridview(dataGridView1, dt); }
private void ucHoaDonBan_Load(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataHoaDonBan, tb_HoaDonBanBLL.layDuLieu()); dataHoaDonBan_CellClick(sender, new DataGridViewCellEventArgs(0, 0)); }
private void ucQuanLyHangHoa_Load(object sender, EventArgs e) { MethodLoad.LoadDatagridview(dataHangHoa, tb_MatHangBLL.layDuLieu()); dataHangHoa_CellEnter(sender, new DataGridViewCellEventArgs(0, 0)); }