private void bt_Tim_Click(object sender, EventArgs e)
{
//Clear GirdView
if (grid_Luong.Rows.Count > 1)
{
int k = grid_Luong.Rows.Count;
for (int i = 0; i < k; i++)
{
grid_Luong.Rows.RemoveAt(0);
i = 0;
k--;
}
}
//Tim nhan vien ung voi ten nhap vao
NhanVienXL NhanVien = new NhanVienXL();
DataTable DT_DSNhanVien = NhanVien.TraCuuNhanVien("", txt_Ten.Text);
//Lay ve thang, nam
int Thang = Convert.ToInt16(cb_Thang.Text);
int Nam = Convert.ToInt16(cb_Nam.Text);
//
for (int i = 0; i < DT_DSNhanVien.Rows.Count; i++)
{
//Lay ra ma nhan vien
string MaNV = DT_DSNhanVien.Rows[i][0].ToString();
//Lay ra bang cham cong ung voi nhan vien nay
ChamCongXL ChamCong = new ChamCongXL();
DataTable dt = ChamCong.LayRaChamCongThanhVien(MaNV, Thang, Nam);
if (dt.Rows.Count > 0)
{
//Them thong tin vao grid view
DataGridViewRow row = new DataGridViewRow();
DataGridViewCell col = new DataGridViewTextBoxCell();
//Cot Ten Nhan Vien
col.Value = DT_DSNhanVien.Rows[i][1].ToString();
row.Cells.Add(col);
//Cot So Ngay Nghir
col = new DataGridViewTextBoxCell();
col.Value = dt.Rows[0][4].ToString();
row.Cells.Add(col);
//Cot So Ngay Di Tre
col = new DataGridViewTextBoxCell();
col.Value = dt.Rows[0][5].ToString();
row.Cells.Add(col);
//Cot luong co ban
//Lay ra ma loai nhan vien ung voi ma nhan vien
string MaLoaiNV = NhanVien.TimMaLoaiNV(MaNV);
//Lay ra Luong co ban
LoaiNhanVienXL LoaiNV = new LoaiNhanVienXL();
DataTable dt_Luong = LoaiNV.LayThongTinLoaiNV(MaLoaiNV);
//
col = new DataGridViewTextBoxCell();
col.Value = dt_Luong.Rows[0][2].ToString();
row.Cells.Add(col);
//Cot tong luong
//Lay ra tham so
ThamSoXL ThamSo = new ThamSoXL();
DataTable dt_ThamSo = ThamSo.LayThamSo();
//Tinh luong
double TongLuong = Convert.ToDouble(dt_Luong.Rows[0][2].ToString()) - Convert.ToDouble(dt.Rows[0][4].ToString()) * Convert.ToDouble(dt_ThamSo.Rows[0][4].ToString()) - Convert.ToDouble(dt.Rows[0][5].ToString()) * Convert.ToDouble(dt_ThamSo.Rows[0][5].ToString());
col = new DataGridViewTextBoxCell();
col.Value = TongLuong.ToString();
row.Cells.Add(col);
grid_Luong.Rows.Add(row);
}
}
}
private void bt_Tim_Click(object sender, EventArgs e)
{
NhanVienXL NhanVien = new NhanVienXL();
DataTable DT_DSNhanVien;
if (cb_LoaiNV.Enabled == true)
{
DT_DSNhanVien = NhanVien.TraCuuNhanVien(cb_LoaiNV.SelectedValue.ToString(), txt_TheoTen.Text);
}
else
{
DT_DSNhanVien = NhanVien.TraCuuNhanVien("", txt_TheoTen.Text);
}
//DataTable DT_DSNhanVien = NhanVien.TraCuuNhanVien("", txt_TheoTen.Text);
//Tim theo tuoi
if (txt_TuoiTu.Text.CompareTo("") != 0 && txt_TuoiDen.Text.CompareTo("") != 0)
{
if (Convert.ToInt16(txt_TuoiTu.Text) > Convert.ToInt16(txt_TuoiDen.Text))
{
MessageBox.Show("Giá trị tuổi không hợp lệ, Hệ thông sẽ loại bỏ giá trị tìm kiếm theo tuổi.");
}
else
{
//Tinh tuoi => nam
String ToDay = DateTime.Now.ToString();
int NamTu = TachNam(ToDay) - Convert.ToInt16(txt_TuoiTu.Text);
int NamDen = TachNam(ToDay) - Convert.ToInt16(txt_TuoiDen.Text);
MessageBox.Show(NamTu.ToString() + ":" + NamDen.ToString());
//Xoa cac row co do tuoi khong nam trong khoang nay
int k = DT_DSNhanVien.Rows.Count;
for (int i = 0; i < k; i++)
{
if (TachNam(DT_DSNhanVien.Rows[i][2].ToString()) > NamTu || TachNam(DT_DSNhanVien.Rows[i][2].ToString()) < NamDen)
{
//MessageBox.Show(DT_DSNhanVien.Rows[i][2].ToString());
DT_DSNhanVien.Rows.RemoveAt(i);
i = 0;
k--;
}
}
}
}
//Clear GirdView
if (grid_KetQua.Rows.Count > 1)
{
int k = grid_KetQua.Rows.Count;
for (int i = 0; i < k; i++)
{
grid_KetQua.Rows.RemoveAt(0);
i = 0;
k--;
}
}
for (int i = 0; i < DT_DSNhanVien.Rows.Count; i++)
{
DataGridViewRow row = new DataGridViewRow();
for (int j = 0; j < DT_DSNhanVien.Columns.Count; j++)
{
DataGridViewCell col = new DataGridViewTextBoxCell();
col.Value = DT_DSNhanVien.Rows[i][j].ToString();
row.Cells.Add(col);
}
grid_KetQua.Rows.Add(row);
}
}