private void cbHienThiAll_CheckedChanged(object sender, EventArgs e)
{
if (cbHienThiAll.Checked)
{
lblTrangThai.Visible = true;
btTrangThai.Visible = true;
dgvNhanVien.DataSource = busnhanvien.DanhSachNhanVienAll();
dgvNhanVien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvNhanVien.Columns[5].Visible = true;
dgvNhanVien.Columns[7].Visible = false;
foreach (DataGridViewRow dr in dgvNhanVien.Rows)
{
if (!string.IsNullOrWhiteSpace(dr.Cells[5].FormattedValue.ToString()))
{
if (!(string.Compare(dr.Cells[5].Value.ToString(), "Hoạt động", true) == 0))
{
dr.DefaultCellStyle.BackColor = Color.Red;
dr.DefaultCellStyle.ForeColor = Color.White;
}
}
}
}
else
{
lblTrangThai.Visible = false;
btTrangThai.Visible = false;
dgvNhanVien.DataSource = busnhanvien.getDanhSachNV();
dgvNhanVien.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
// Check Email trùng
public bool checkemailTrung(string email, BUS_NhanVien busnhanvien)
{
DataTable getMail = busnhanvien.DanhSachNhanVienAll();
foreach (DataRow row in getMail.Rows)
{
if (string.Compare(email, row[1].ToString(), true) == 0)
{
return(true);
}
}
return(false);
}
private void DgvData_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (cbHoaDon.Checked == true || cbDTNam.Checked == true || cbDTThang.Checked == true)
{
if (e.ColumnIndex == DgvData.Columns["Detail"].Index && e.RowIndex >= 0 && e.RowIndex < DgvData.Rows.Count - 1)
{
DTO_HoaDon hd = busTK.curHD(DgvData.CurrentRow.Cells["MaHD"].FormattedValue.ToString());
string TenNV = (from DataRow dr in busNv.DanhSachNhanVienAll().Rows
where string.Compare(dr[0].ToString(), hd.MaNV, true) == 0
select dr[2].ToString()).FirstOrDefault();
string TenBan = (from DataRow dr in busBan.DanhSachBanALL().Rows
where (int)dr[0] == hd.IdBan
select dr[1].ToString()).FirstOrDefault();
DataTable dtHDCT = busTK.ThongkeHoaDonChitiet(hd.MaHD);
CrystalReport.Detail cb = new CrystalReport.Detail();
TextObject txtnv = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["txtTenNV"];
txtnv.Text = TenNV;
TextObject txtDate = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["TxtNgayHD"];
txtDate.Text = hd.NgayHD.ToString("dd/MM/yyyy");
TextObject txthd = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtMaHD"];
txthd.Text = hd.MaHD;
TextObject txtvt = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtViTri"];
txtvt.Text = TenBan;
TextObject txtkh = (TextObject)cb.ReportDefinition.Sections["Section2"].ReportObjects["txtKH"];
txtkh.Text = hd.SDT_KH;
TextObject txtkm = (TextObject)cb.ReportDefinition.Sections["Section4"].ReportObjects["TextKM"];
txtkm.Text = hd.KhuyenMai.ToString() + "%";
TextObject txttongtien = (TextObject)cb.ReportDefinition.Sections["Section5"].ReportObjects["TxtTongTien"];
txttongtien.Text = (hd.ThanhTien * 100 / (100 - hd.KhuyenMai)).ToString();
TextObject txtThanhTien = (TextObject)cb.ReportDefinition.Sections["Section5"].ReportObjects["txtThanhtien"];
txtThanhTien.Text = hd.ThanhTien.ToString();
TextObject txtname = (TextObject)cb.ReportDefinition.Sections["Section1"].ReportObjects["TextName"];
txtname.Text = "CHI TIẾT HOÁ ĐƠN";
cb.Database.Tables["CTHD"].SetDataSource(dtHDCT);
frmDetail frm = new frmDetail(cb);
frm.Show();
}
}
}