public void Load_data()
{
string query = "select * from tbl_nhanvien";
DataTable dt = KiemTraKetNoi.getDatatable(query, "tbl_nhanvien");
dataNhanVien.DataSource = dt;
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
if (txtID.Text == "" || txtPass.Text == "")
{
MessageBox.Show("Bạn chưa nhập tên đăng nhập và mật khẩu!", "Thông báo");
return;
}
string query = "select * from tbl_user where ID = '" + txtID.Text + "' and Password = '******'";
DataTable dt = KiemTraKetNoi.getDatatable(query, "tbl_user");
if (dt.Rows.Count > 0)
{
MessageBox.Show("Xin chào " + txtID.Text + "! Bạn đã đăng nhập thành công!", "Thông báo");
this.Hide();
Form main = new Form1(txtID.Text, txtPass.Text);
main.Show();
}
else
{
MessageBox.Show("Đăng nhập không thành công!", "Thông báo");
txtID.Clear();
txtPass.Clear();
txtID.Focus();
}
}
public void Load_data()
{
string str = "select * from tbl_user";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(str, "tbl_user");
dataNguoiDung.DataSource = dt;
}
public void Load_data()
{
string querySelectAllBHXH = "select * from tbl_baohiemxh";
DataTable dt = KiemTraKetNoi.getDatatable(querySelectAllBHXH, "tbl_baohiemxh");
dataBaoHiem.DataSource = dt;
}
public void Load_data()
{
string query = "select * from tbl_user";
DataTable dt = KiemTraKetNoi.getDatatable(query, "tbl_user");
dataLuong.DataSource = dt;
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
string update = "update tbl_user set Password='******' where(ID=N'" + txtTaiKhoan.Text + "' and Password='******')";
string ten = txtTaiKhoan.Text;
if (ten == "")
{
MessageBox.Show("Bạn chưa nhập tên truy cập");
return;
}
if (txtMatKhauCu.Text == "")
{
MessageBox.Show("Bạn chưa nhập mật khẩu");
return;
}
if (txtMatKhauMoi.Text == "")
{
MessageBox.Show("Bạn chưa nhập mật khẩu mới");
return;
}
if (txtXacNhanMatKhau.Text == "")
{
MessageBox.Show("Bạn chưa nhập lại mật khẩu");
return;
}
if ((txtMatKhauMoi.Text == txtXacNhanMatKhau.Text) && txtMatKhauCu.Text == password)
{
DataTable dt = KiemTraKetNoi.getDatatable(update, "tbl_user");
MessageBox.Show("Bạn đã thay đổi mật khẩu thành công");
this.Close();
}
else
{
MessageBox.Show("Bạn nhập lại mật khẩu không đúng");
}
}
private void txtTimKiem_TextChanged(object sender, EventArgs e)
{
try
{
if (radMaNV.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE MaNV='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radTenNV.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE TenNV LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNoiSinh.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE NoiSinh LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radDiaChi.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE DiaChi LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radChuyenMon.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE ChuyenMon LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radTDHV.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE TDHV LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radDanToc.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE DanToc LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radTonGiao.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE TonGiao LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radQuocTich.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE QuocTich LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radLuongCB.Checked == true)
{
string Search = "SELECT * FROM tbl_luong WHERE LuongCoBan='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radDonVi.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE MaDonVi='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNoiCapBHXH.Checked == true)
{
string Search = "SELECT * FROM tbl_baohiemxh WHERE NoiCap LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNoiDKKCB.Checked == true)
{
string Search = "SELECT * FROM tbl_baohiemxh WHERE NoiDKKCB LIKE N'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radGioiTinh.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE GioiTinh=N'" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radSDT.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE SDT LIKE'%" + txtTimKiem.Text + "%'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radEmail.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE Email='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNgaySinh.Checked == true)
{
string Search = "SELECT * FROM tbl_nhanvien WHERE NgaySinh='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_nhanvien");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNgayNhapLuong.Checked == true)
{
string Search = "SELECT * FROM tbl_luong WHERE NgayNhap='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_luong");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNgaySuaLuong.Checked == true)
{
string Search = "SELECT * FROM tbl_luong WHERE NgaySua='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_luong");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (radNgayCapBHXH.Checked == true)
{
string Search = "SELECT * FROM tbl_baohiemxh WHERE NgayCap='" + txtTimKiem.Text + "'";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_baohiemxh");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (txtTimKiem.Text == "Nhân viên nào có lương cao nhất?" || txtTimKiem.Text == "nhân viên nào có lương cao nhất?" || txtTimKiem.Text == "lương cao nhất?")
{
string Search = "SELECT * FROM tbl_luong where LuongCoBan = (select max(LuongCoBan) from tbl_luong )";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_luong");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
if (txtTimKiem.Text == "Nhân viên nào có lương thấp nhất?" || txtTimKiem.Text == "nhân viên nào có lương thấp nhất?" || txtTimKiem.Text == "lương thấp nhất?")
{
string Search = "SELECT * FROM tbl_luong where LuongCoBan = (select min(LuongCoBan) from tbl_luong )";
System.Data.DataTable dt = KiemTraKetNoi.getDatatable(Search, "tbl_luong");
dataTimKiem.DataSource = dt;
int count = dataTimKiem.Rows.Count - 1;
txtKQTimKiem.Text = count.ToString();
}
//
}
catch (Exception)
{ }
}
