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