private void dgvLich_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtMaCN_QLCC.Text = dgvLich.CurrentRow.Cells[0].Value.ToString();
dgvGiolam.DataSource = cnb.ViewGioLamViec("SELECT MaCaLV,Thu,GioToi,GioVe,DiTre,Tong,[Ngay/Thang/Nam],GioLamViec.MaNV,MaGioLamViec,Ho,Ten,Hinh FROM GioLamViec,CongNhan WHERE GioLamViec.MaNV=CongNhan.MaNV AND GioLamViec.MaNV='" + dgvLich.CurrentRow.Cells[0].Value.ToString() + "' AND DATEPART(MONTH,[Ngay/Thang/Nam])=" + dgvLich.CurrentRow.Cells[32].Value.ToString() + " AND YEAR([Ngay/Thang/Nam])=" + dgvLich.CurrentRow.Cells[33].Value.ToString()).ToList();
txtHo_QLCC.Text = dgvGiolam.CurrentRow.Cells[9].Value.ToString();
txtTen_QLCC.Text = dgvGiolam.CurrentRow.Cells[10].Value.ToString();
//picCN_QLCC.Image = Image.FromFile(dgvGiolam.CurrentRow.Cells[11].Value.ToString());
lbThang.Text = dgvLich.CurrentRow.Cells[32].Value.ToString();
lbNam.Text = dgvLich.CurrentRow.Cells[33].Value.ToString();
int j = 0;
for (int i = 1; i <= 31; i++)
{
if ((bool)dgvLich.CurrentRow.Cells[i].Value)
{
j++;
}
lbTongngay.Text = j.ToString();
}
try
{
lbTonggio.Text = cnb.ViewLuong("SELECT *FROM Luong WHERE MaNV='" + txtMaCN_QLCC.Text + "'")[0].GioLamViec.ToString();
}
catch (Exception p)
{
MessageBox.Show(p.ToString());
}
}