private void FormHoSoNV_Load(object sender, EventArgs e) { database.loadComboBox(cbbMaPB, "SELECT MaPB FROM dbo.PhongBan"); database.loadComboBox(cbbLuong, "SELECT MaLuong FROM dbo.Luong"); database.loadComboBox(cbbMaNV, "SELECT MaNV FROM dbo.HoSoNV"); database.loadDataGridView(dgvHoSo, "SELECT * FROM dbo.HoSoNV"); }
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e) { string MaNV = comboBoxMaNV.SelectedItem.ToString(); string query = "SELECT * FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"; database.loadDataGridView(dataGridView, query); }
private void buttonSearch_Click(object sender, EventArgs e) { string search = textBoxSearch.Text.Trim(); if (search.Length != 0) { if (check == 0) { MessageBox.Show("Vui lòng chọn kiểu tìm kiếm!", "", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else if (check == 1) { try { string MaNV = textBoxSearch.Text.Trim(); string timkiem = "EXEC.TimKiemMaNV @MaNV=N'" + MaNV + "'"; db.loadDataGridView(dataGridView1, timkiem); textBoxSearch.Text = ""; } catch { } } else if (check == 2) { try { string PB = textBoxSearch.Text.Trim(); bool temp = db.Check(PB, "SELECT * FROM dbo.PhongBan WHERE MaPB = N'" + PB + "'"); //MessageBox.Show(temp.ToString()); if (temp == false) { db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.PhongBan WHERE TenPB LIKE N'%" + PB + "%'"); textBoxSearch.Text = ""; } else { db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.PhongBan WHERE MaPB = N'" + PB + "'"); textBoxSearch.Text = ""; } } catch { } } else { db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.HoSoNV WHERE TenNV LIKE N'%" + search + "%'"); textBoxSearch.Text = ""; } } else { MessageBox.Show("Vui lòng nhập khóa để tìm kiếm", "", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
private void comboBoxMaNV_SelectedIndexChanged(object sender, EventArgs e) { string MaNV = comboBoxMaNV.SelectedItem.ToString(); Reset(); dataGridView1.DataSource = ""; database.loadDataGridView(dataGridView1, "SELECT * FROM dbo.TTNhanVienCoBan WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxTenNV, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxHoNV, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxChucVu, "SELECT ChucVu FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); database.loadTextBox(textBoxPhongBan, "SELECT MaPB FROM dbo.HoSoNV WHERE MaNV='" + MaNV + "'"); }
private void comboBoxMaNV1_SelectedIndexChanged(object sender, EventArgs e) { Reset(); string MaNV = comboBoxMaNV1.SelectedItem.ToString(); db.loadTextBox(textBoxMaLuong1, "SELECT MaLuong FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); db.loadTextBox(textBoxTenNV1, "SELECT TenNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); string ten = textBoxTenNV1.Text.Trim(); db.loadTextBox(textBoxTenNV1, "SELECT HoDemNV FROM dbo.HoSoNV WHERE MaNV=N'" + MaNV + "'"); string ho = textBoxTenNV1.Text.Trim(); string HoTenNV = ho + " " + ten; textBoxTenNV1.Text = HoTenNV; db.loadDataGridView(dataGridViewBH, "SELECT * FROM dbo.CDBaoHiemXaHoi WHERE MaNV=N'" + MaNV + "'"); try { db.loadTextBox(textBoxMaBHXH, "SELECT MaBHXH FROM dbo.CDBaoHiemXaHoi WHERE MaNV='" + MaNV + "'"); } catch { } }
private void Form1_Load(object sender, EventArgs e) { viTriBanDau(); user = UI.FormLOGIN.useraccount; string loichao = "Hello " + user + "!"; labelChao.Text = loichao; int toado = 787 - 10 * user.Length; labelChao.Location = new Point(toado, 50); string query = "SELECT * FROM dbo.HoSoNV"; database.loadDataGridView(dataGridView1, query); }
private void FormCheDo_Load(object sender, EventArgs e) { dgvTS.AllowUserToResizeColumns = true; dgvBH.AllowUserToResizeColumns = true; db.loadDataGridView(dgvTS, "SELECT * FROM dbo.CDThaiSan"); db.loadDataGridView(dgvBH, "SELECT * FROM dbo.CDBaoHiemXaHoi"); db.loadComboBox(cbbMaNV1, "SELECT MaNV FROM dbo.HoSoNV"); db.loadComboBox(cbbMaNV2, "SELECT HS.MaNV FROM dbo.HoSoNV HS, dbo.TTNhanVienCoBan TT WHERE HS.MaNV = TT.MaNV AND TT.GioiTinh = N'Nữ'"); }
private void FormTTCaNhan_Load(object sender, EventArgs e) { database.loadComboBox(cbbMaNV, "SELECT MaNV FROM dbo.HoSoNV"); database.loadDataGridView(dgvTTCN, "SELECT * FROM dbo.TTNhanVienCoBan"); }
private void FormBacLuong_Load(object sender, EventArgs e) { db.loadComboBox(cbbBacLuong, "SELECT MaLuong FROM dbo.Luong"); db.loadDataGridView(dgvBacLuong, "SELECT * FROM dbo.Luong"); }
private void FormPhongBan_Load(object sender, EventArgs e) { db.loadComboBox(cbbMaPB, "SELECT MaPB FROM dbo.PhongBan"); db.loadComboBox(cbbMaTruongPhong, "SELECT MaNV FROM dbo.HoSoNV"); db.loadDataGridView(dgvPhongBan, "SELECT * FROM dbo.PhongBan"); }
private void comboBoxMaPB_SelectedIndexChanged(object sender, EventArgs e) { string MaPB = comboBoxMaPB.SelectedItem.ToString(); db.loadDataGridView(dataGridView, "SELECT * FROM dbo.PhongBan WHERE MaPB=N'" + MaPB + "'"); }
private void comboBoxBacLuong_SelectedIndexChanged(object sender, EventArgs e) { string MaLuong = comboBoxBacLuong.Text.TrimEnd(); db.loadDataGridView(dataGridView1, "SELECT * FROM dbo.Luong WHERE MaLuong='" + MaLuong + "'"); }