private void SanPham_Load_1(object sender, EventArgs e)
{
acc.AutoComplete(tbx_masp, "SELECT MASP FROM SANPHAM");
acc.AutoComplete(tbx_mancc, "SELECT MANCC FROM NHACUNGCAP");
acc.AutoComplete(tbx_madm, "SELECT MADANHMUC FROM DANHMUC");
dgvsanpham.DataSource = acc.Select_Data("Select * from SANPHAM");
dgvsanpham.ClearSelection();
tbx_masp.Enabled = false;
}
private void NhanVIen_Load(object sender, EventArgs e)
{
cbx_nv.SelectedIndex = 0;
Disabletbx();
Enablebtn();
lbx_trangthai.Visible = false;
cbx_trangthai.Visible = false;
cbx_trangthai.Checked = false;
acc.AutoComplete(tbx_MaNV, "SELECT MANV FROM NHANVIEN");
acc.AutoCompletecbx(tbx_MaBP, "SELECT TENBP FROM BOPHAN", "TENBP");
acc.AutoComplete(tbx_chucvu, "SELECT CHUCVU FROM NHANVIEN");
dgvNhanVien.DataSource = acc.Select_Data("Select NHANVIEN.TRANGTHAI, MANV, TENNV, EMAIL, NS, GT, NHANVIEN.DIENTHOAI, CHUCVU, HINHANH, DIACHI, LUONG, TENBP from NHANVIEN, BOPHAN WHERE BOPHAN.MABP = NHANVIEN.MABP and NHANVIEN.TRANGTHAI = '1' order by MANV asc");
dgvNhanVien.ClearSelection();
tbx_MaNV.Enabled = false;
rbtn_Nam.Checked = true;
dgvNhanVien.Columns["TRANGTHAI"].HeaderText = "TT";
dgvNhanVien.Columns["MANV"].HeaderText = "Mã Nhân Viên";
dgvNhanVien.Columns["TENNV"].HeaderText = "Nhân Viên";
dgvNhanVien.Columns["EMAIL"].HeaderText = "Email";
dgvNhanVien.Columns["NS"].HeaderText = "Ngày Sinh";
dgvNhanVien.Columns["GT"].HeaderText = "GT";
dgvNhanVien.Columns["DIENTHOAI"].HeaderText = "Điện Thoại";
dgvNhanVien.Columns["CHUCVU"].HeaderText = "Chức Vụ";
dgvNhanVien.Columns["HINHANH"].HeaderText = "Ảnh";
dgvNhanVien.Columns["DIACHI"].HeaderText = "Địa Chỉ";
dgvNhanVien.Columns["LUONG"].HeaderText = "Lương";
dgvNhanVien.Columns["TENBP"].HeaderText = "Bộ Phận";
dgvNhanVien.Columns["TRANGTHAI"].Width = 30;
dgvNhanVien.Columns["MANV"].Width = 70;
dgvNhanVien.Columns["GT"].Width = 60;
dgvNhanVien.Columns["TENNV"].Width = 150;
dgvNhanVien.Columns["TENBP"].Width = 170;
dgvNhanVien.Columns["EMAIL"].Width = 150;
dgvNhanVien.Columns["CHUCVU"].Width = 150;
dgvNhanVien.CurrentRow.Cells["TRANGTHAI"].ReadOnly = false;
if (QUYENHD == "ADMIN" || QUYENHD == "Admin" || QUYENHD == "admin")
{
btn_xoa.Enabled = true;
lbx_nv.Enabled = true;
cbx_nv.Enabled = true;
}
else
{
btn_xoa.Enabled = false;
lbx_nv.Enabled = false;
cbx_nv.Enabled = false;
}
}
private void DanhMucSP_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaDN, "SELECT MADANHMUC FROM DANHMUC");
acc.AutoComplete(tbx_makho, "SELECT MAKHO FROM KHOHANG");
dgv_dmsanpham.DataSource = acc.Select_Data("SELECT * FROM DANHMUC");
ClearText();
dgv_dmsanpham.Columns[0].Width = 100;
dgv_dmsanpham.Columns[1].Width = 100;
dgv_dmsanpham.Columns[2].Width = 130;
dgv_dmsanpham.Columns[3].Width = 100;
}
private void ThemTaiKhoan_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaNV, "SELECT MANV FROM NHANVIEN");
acc.AutoComplete(tbx_QuyenHan, "SELECT QUYENHAN FROM DANGNHAP");
dgvThemTK.DataSource = acc.Select_Data("Select * from DANGNHAP");
dgvThemTK.ClearSelection();
// INSERT
//Dộ rộng cột
dgvThemTK.Columns[0].Width = 120;
dgvThemTK.Columns[1].Width = 105;
dgvThemTK.Columns[2].Width = 100;
dgvThemTK.Columns[3].Width = 120;
}
private void BoPhan_Load(object sender, EventArgs e)
{
Disabletbx();
Enablebtn();
btn_mo.Enabled = false;
acc.AutoComplete(tbx_MaBP, "SELECT MABP FROM BOPHAN");
acc.AutoCompletecbx(tbx_MaKho, "SELECT TENKHO FROM KHOHANG", "TENKHO");
acc.AutoCompletecbx(tbx_NQL, "SELECT TENNV FROM NHANVIEN", "TENNV");
dgv_BoPhan.DataSource = acc.Select_Data("SELECT BOPHAN.MABP, TENBP, BOPHAN.DIENTHOAI, TENKHO, TENNV FROM BOPHAN left join NHANVIEN on BOPHAN.NQL = NHANVIEN.MANV left join KHOHANG on BOPHAN.MAKHO = KHOHANG.MAKHO");
dgv_BoPhan.Columns["MABP"].Width = 80;
dgv_BoPhan.Columns["TENBP"].Width = 150;
dgv_BoPhan.Columns["DIENTHOAI"].Width = 120;
dgv_BoPhan.Columns["TENKHO"].Width = 145;
dgv_BoPhan.Columns["TENNV"].Width = 150;
dgv_BoPhan.Columns["MABP"].HeaderText = "Mã BP";
dgv_BoPhan.Columns["DIENTHOAI"].HeaderText = "Điện Thoại";
dgv_BoPhan.Columns["TENKHO"].HeaderText = "Kho";
dgv_BoPhan.Columns["TENNV"].HeaderText = "Nhân Viên";
dgv_BoPhan.Columns["TENBP"].HeaderText = "Bộ Phận";
dgv_BoPhan.ClearSelection();
ClearText();
if (QUYENHD == "ADMIN" || QUYENHD == "Admin" || QUYENHD == "admin")
{
btn_xoa.Enabled = true;
}
else
{
btn_xoa.Enabled = false;
}
}
private void ThemTaiKhoan_Load(object sender, EventArgs e)
{
Disabletbx();
acc.AutoCompletecbx(tbx_MaNV, "Select TENNV from NHANVIEN", "TENNV");
acc.AutoComplete(tbx_QuyenHan, "SELECT QUYENHAN FROM DANGNHAP");
tbx_MaNV.SelectedIndex = -1;
dgvThemTK.DataSource = acc.Select_Data("Select USERNAME, PASSWORD, TENNV, QUYENHAN from DANGNHAP, NHANVIEN WHERE DANGNHAP.MANV = NHANVIEN.MANV");
dgvThemTK.ClearSelection();
// INSERT
//Dộ rộng cột
dgvThemTK.Columns[0].Width = 105;
dgvThemTK.Columns[1].Width = 105;
dgvThemTK.Columns[2].Width = 145;
dgvThemTK.Columns[3].Width = 130;
dgvThemTK.Columns["USERNAME"].HeaderText = "Tên Đăng Nhập";
dgvThemTK.Columns["PASSWORD"].HeaderText = "Mật Khẩu";
dgvThemTK.Columns["TENNV"].HeaderText = "Tên Nhân Viên";
dgvThemTK.Columns["QUYENHAN"].HeaderText = "Quyền Hạn";
Enablebtn();
Disabletbx();
Cleartbx();
if (QUYENHD == "ADMIN" || QUYENHD == "Admin" || QUYENHD == "admin")
{
bt_xoa.Enabled = true;
}
else
{
bt_xoa.Enabled = false;
}
}
private void BoPhan_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaBP, "SELECT MABP FROM BOPHAN");
acc.AutoComplete(tbx_MaKho, "SELECT MAKHO FROM KHOHANG");
acc.AutoComplete(tbx_NQL, "SELECT MANV FROM NHANVIEN");
dgv_BoPhan.DataSource = acc.Select_Data("SELECT * FROM BOPHAN");
dgv_BoPhan.Columns[0].Width = 120;
dgv_BoPhan.Columns[1].Width = 130;
dgv_BoPhan.Columns[2].Width = 120;
dgv_BoPhan.Columns[3].Width = 120;
dgv_BoPhan.Columns[4].Width = 120;
dgv_BoPhan.ClearSelection();
ClearText();
}
private void Luong_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_Manv, "SELECT MANV FROM NHANVIEN");
dgvLuong.DataSource = acc.Select_Data("Select MANV, TENNV, NS, GT, LUONG from NHANVIEN");
dgvLuong.ClearSelection();
}
private void NhanVIen_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaNV, "SELECT MANV FROM NHANVIEN");
acc.AutoComplete(tbx_MaBP, "SELECT MABP FROM BOPHAN");
acc.AutoComplete(tbx_chucvu, "SELECT CHUCVU FROM NHANVIEN");
dgvNhanVien.DataSource = acc.Select_Data("Select * from NHANVIEN");
dgvNhanVien.ClearSelection();
tbx_MaNV.Enabled = false;
rbtn_Nam.Checked = true;
dgvNhanVien.Columns["MANV"].Width = 70;
dgvNhanVien.Columns["GT"].Width = 60;
dgvNhanVien.Columns["TENNV"].Width = 150;
dgvNhanVien.Columns["MABP"].Width = 80;
}
private void KhoHang_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_makho, "SELECT MAKHO FROM KHOHANG");
dgv_khohang.DataSource = acc.Select_Data("SELECT * FROM KHOHANG");
ClearText();
dgv_khohang.Columns[0].Width = 100;
dgv_khohang.Columns[0].Width = 100;
dgv_khohang.Columns[0].Width = 100;
dgv_khohang.Columns[0].Width = 115;
}
private void NhaCC_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaNCC, "SELECT MANCC FROM NHACUNGCAP");
dgv_nhacungcap.DataSource = acc.Select_Data("SELECT * FROM NHACUNGCAP");
ClearText();
btn_them.Enabled = true;
btn_sua.Enabled = true;
btn_xoa.Enabled = true;
tbx_Diachi.Enabled = false;
tbx_Ghichu.Enabled = false;
tbx_MaNCC.Enabled = false;
tbx_TenNCC.Enabled = false;
btn_ghinhan.Enabled = false;
btn_mo.Enabled = false;
}
private void KhachHang_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_makh, "SELECT MAKH FROM KHACHHANG");
dataGridView1.DataSource = acc.Select_Data("SELECT * FROM KHACHHANG");
ClearText();
btn1.Enabled = true;
btn2.Enabled = true;
btn3.Enabled = true;
tbx_diachi.Enabled = false;
tbx_dienthoai.Enabled = false;
tbx_email.Enabled = false;
tbx_fax.Enabled = false;
btn_ghinhan.Enabled = false;
btn_mo.Enabled = false;
tbx_gioitinh.Enabled = false;
tbx_makh.Enabled = false;
tbx_tenkh.Enabled = false;
}
private void NhapXuat_Load(object sender, EventArgs e)
{
bt_nhap_Click(sender, e);
// key = 1: Nhập, key = 2: Xuất
if (key == 1)
{
// Nhập
acc.AutoComplete(tbx_MaPhieuX_N, "SELECT MAPN FROM PHIEUNHAPKHO");
acc.AutoComplete(tbx_MaKH_NCC, "SELECT MANCC FROM NHACUNGCAP");
}
if (key == 2)
{
// Xuất
acc.AutoComplete(tbx_MaPhieuX_N, "SELECT MAPX FROM PHIEUXUAT");
acc.AutoComplete(tbx_MaKH_NCC, "SELECT MAKH FROM KHACHHANG");
}
acc.AutoComplete(tbx_MaKho, "SELECT MAKHO FROM KHOHANG");
acc.AutoComplete(tbx_MaSP, "SELECT MASP FROM SANPHAM");
acc.AutoComplete(tbx_NVXuat_Nhap, "SELECT MANV FROM NHANVIEN");
}
private void DoiQuyen_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_tdn, "SELECT USERNAME FROM DANGNHAP");
acc.AutoComplete(tbx_quyencu, "SELECT QUYENHAN FROM DANGNHAP");
acc.AutoComplete(tbx_quyenmoi, "SELECT QUYENHAN FROM DANGNHAP");
}
private void KhachHang_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_makh, "SELECT MAKH FROM KHACHHANG");
dataGridView1.DataSource = acc.Select_Data("SELECT * FROM KHACHHANG");
ClearText();
}
private void NhaCC_Load(object sender, EventArgs e)
{
acc.AutoComplete(tbx_MaNCC, "SELECT MANCC FROM NHACUNGCAP");
dgv_nhacungcap.DataSource = acc.Select_Data("SELECT * FROM NHACUNGCAP");
ClearText();
}
