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