public void AutoCompletecbx(ComboBox cbx_combobox, string sql, string tencot)
{
cbx_combobox.DataSource = acc.Select_Data(sql);
cbx_combobox.DisplayMember = tencot;
cbx_combobox.ValueMember = tencot;
cbx_combobox.SelectedIndex = -1;
}
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 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;
Enablebtn();
Disabletbx();
Cleartbx();
if (QUYENHD == "ADMIN" || QUYENHD == "Admin" || QUYENHD == "admin")
{
bt_xoa.Enabled = true;
}
else
{
bt_xoa.Enabled = false;
}
}
private void KhoHang_Load(object sender, EventArgs e)
{
dgvKHOHANG.DataSource = acc.Select_Data("SELECT * FROM KHOHANG");
dgvKHOHANG.ClearSelection();
groupBox_ketquatimkiem.Text = "";
tbx_makho.Text = "";
tbx_tenkho.Focus();
Disable();
//btn_chophepsua.Enabled = false; btn_ghinhan.Enabled = false; bt_xoa.Enabled = false;
//hiển thị tiêu đề của cột:
dgvKHOHANG.Columns[0].HeaderText = "Mã Kho";
dgvKHOHANG.Columns[1].HeaderText = "Tên Kho";
dgvKHOHANG.Columns[2].HeaderText = "Tổng Số Danh Mục";
dgvKHOHANG.Columns[3].HeaderText = "Ghi Chú";
// can chinh do rong cot:
dgvKHOHANG.Columns[0].Width = 80;
dgvKHOHANG.Columns[1].Width = 250;
dgvKHOHANG.Columns[2].Width = 70;
dgvKHOHANG.Columns[3].Width = 160;
btn_ghinhan.Enabled = false;
bt_them.Enabled = true;
bt_xoa.Enabled = true;
btn_chophepsua.Enabled = true;
}
private void DanhMucSP_Load(object sender, EventArgs e)
{
tbx_madm.Text = " ";
Disable();
bt_xoa.Enabled = true;
tbx_tendm.Focus();
acc.AutoCompletecbx(tbx_makho, "SELECT TENKHO FROM KHOHANG", "TENKHO");
tbx_madm.Enabled = false;
dgvDANHMUC.DataSource = acc.Select_Data("SELECT DM.MADANHMUC,TENDANHMUC,KHOHANG.TENKHO,DM.GHICHU from DANHMUC DM left join KHOHANG on KHOHANG.MAKHO=DM.MAKHO");
dgvDANHMUC.ClearSelection();
//hiển thị tiêu đề của các cột:
dgvDANHMUC.Columns[0].HeaderText = "Mã Danh Mục";
dgvDANHMUC.Columns[1].HeaderText = "Tên Danh Mục";
dgvDANHMUC.Columns[2].HeaderText = "Tên Kho";
dgvDANHMUC.Columns[3].HeaderText = "Ghi Chú";
//căn độ rộng cột:
dgvDANHMUC.Columns[1].Width = 200;
dgvDANHMUC.Columns[2].Width = 200;
dgvDANHMUC.Columns[3].Width = 160;
btn_ghinhan.Enabled = false;
bt_them.Enabled = true;
bt_xoa.Enabled = true;
bt_chophepsua.Enabled = true;
}
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 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 btn_timkiem_Click(object sender, EventArgs e)
{
if (tbx_timkiem.Text.Trim() == "")
{
MessageBox.Show("Đề Nghị Bạn Nhập Từ Khóa Càn Tìm!", "Thông Báo!");
return;
}
else
{
dgv_BoPhan.DataSource = acc.Select_Data("Select * from BOPHAN Where MABP like N'%" + tbx_timkiem.Text + "%' OR TENBP like N'%" + tbx_timkiem.Text + "%' OR DIENTHOAI like N'%" + tbx_timkiem.Text + "%' OR MAKHO like N'%" + tbx_timkiem.Text + "%' OR NQL like N'%" + tbx_timkiem.Text + "%'");
tbx_timkiem.Clear();
dgv_BoPhan.ClearSelection();
}
}
public void Nhap_load()
{
dgv_NhapXuat.DataSource = acc.Select_Data("SELECT N.MAPN, CTN.MASP, N.MAKHO, N.MANCC, N.NVNHAP, N.NGAYNHAP, CTN.SOLUONG,SP.GIA, CTN.TONGTIEN, N.GHICHU FROM PHIEUNHAPKHO N, CHITIETPHIEUNHAP CTN, SANPHAM SP WHERE N.MAPN = CTN.MAPN and CTN.MASP = SP.MASP");
panel_QTX.Show();
key = 1;
lb_MaPX.Text = "Mã PN";
lb_MaKH.Text = "Mã NCC";
lb_NV_xuat.Text = "NV Nhập";
lb_ngay_xuat.Text = "Ngày Nhập";
ClearText();
tbx_MaPhieuX_N.Focus();
bt_nhap.BackColor = System.Drawing.Color.Coral;
bt_xuat.BackColor = System.Drawing.Color.AliceBlue;
}
private void btn_timkiem_Click(object sender, EventArgs e)
{
if (tbx_timkiem.Text.Trim() == "")
{
MessageBox.Show("Đề Nghị Bạn Nhập Từ Khóa Càn Tìm!", "Thông Báo!");
return;
}
else
{
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 WHERE ( BOPHAN.MABP like N'%" + tbx_timkiem.Text + "%' OR TENBP like N'%" + tbx_timkiem.Text + "%' OR BOPHAN.DIENTHOAI like N'%" + tbx_timkiem.Text + "%' OR TENKHO like N'%" + tbx_timkiem.Text + "%' OR TENNV like N'%" + tbx_timkiem.Text + "%')");
tbx_timkiem.Clear();
dgv_BoPhan.ClearSelection();
}
}
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 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 SANPHAM_Load(object sender, EventArgs e)
{
acc.AutoCompletecbx(txb_madm, "SELECT TENDANHMUC FROM DANHMUC", "TENDANHMUC");
acc.AutoCompletecbx(txb_ncc, "SELECT TENNHACC FROM NHACUNGCAP", "TENNHACC");
acc.AutoCompleteByArray(txb_phanloai, DS_PhanLoai);
Disable();
tbx_masp.Enabled = false; tbx_tensp.Focus();
tbx_masp.Text = " ";
label_thongbaoSP.Text = "";
txb_timkiem.Text = "Hãy nhập từ khóa tìm kiếm..";
dgv_SANPHAM.DataSource = acc.Select_Data("SELECT MASP,TENSP,GIA,SERIAL,NHACUNGCAP.TENNHACC,DANHMUC.TENDANHMUC ,NGAYSANXUAT,HANSUDUNG,SOLUONG,PHANLOAI,HINHANH,SP.GHICHU FROM SANPHAM SP LEFT JOIN DANHMUC on DANHMUC.MADANHMUC = SP.MADANHMUC left join NHACUNGCAP on NHACUNGCAP.MANCC = SP.MANCC");
dgv_SANPHAM.ClearSelection();
groupBox_DSSP.Text = "Danh Sách Sản Phẩm";
// CUSTOM SIZE COLUMN:
dgv_SANPHAM.Columns[0].Width = 70;
dgv_SANPHAM.Columns[1].Width = 150;
dgv_SANPHAM.Columns[2].Width = 100;
dgv_SANPHAM.Columns[3].Width = 100;
dgv_SANPHAM.Columns[4].Width = 200;
dgv_SANPHAM.Columns[5].Width = 180;
dgv_SANPHAM.Columns[8].Width = 50;
dgv_SANPHAM.Columns[9].Width = 150;
// hiển thị tiêu đề của các cột:
dgv_SANPHAM.Columns[0].HeaderText = "Mã Sản Phẩm";
dgv_SANPHAM.Columns[1].HeaderText = "Tên Sản Phẩm";
dgv_SANPHAM.Columns[2].HeaderText = "Giá";
dgv_SANPHAM.Columns[3].HeaderText = "Serial";
dgv_SANPHAM.Columns[4].HeaderText = "Tên Nhà Cung Cấp";
dgv_SANPHAM.Columns[5].HeaderText = "Tên Danh Mục";
dgv_SANPHAM.Columns[6].HeaderText = "Ngày Sản Xuất";
dgv_SANPHAM.Columns[7].HeaderText = "Hạn Sử Dụng";
dgv_SANPHAM.Columns[8].HeaderText = "Số Lượng";
dgv_SANPHAM.Columns[9].HeaderText = "Phân Loại";
dgv_SANPHAM.Columns[10].HeaderText = "Hình Ảnh ";
dgv_SANPHAM.Columns[11].HeaderText = "Ghi Chú";
//
textBox_showpart.Enabled = false;
btn_themmoi.Enabled = true;
btn_xoa.Enabled = true;
btn_chophepsua.Enabled = true;
btn_ghinhan.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 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 left join BOPHAN on BOPHAN.MABP = NHANVIEN.MABP WHERE 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 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 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 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 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();
}
private void NhapXuat_Load(object sender, EventArgs e)
{
acc.AutoCompletecbx(txb_nvnhap, "select TENNV from NHANVIEN", "TENNV");
acc.AutoCompletecbx(txb_maspPN, "Select TENSP from SANPHAM", "TENSP");
acc.AutoCompletecbx(txb_mancc, "SELECT TENNHACC FROM NHACUNGCAP", "TENNHACC");
acc.AutoCompletecbx(txb_makhoPN, "SELECT TENKHO FROM KHOHANG", "TENKHO");
acc.AutoCompletecbx(txb_manvPX, "select TENNV from NHANVIEN", "TENNV");
acc.AutoCompletecbx(txb_maspPX, "Select TENSP from SANPHAM", "TENSP");
acc.AutoCompletecbx(txb_makh, "select TENKH from KHACHHANG", "TENKH");
acc.AutoCompletecbx(txb_makhoPX, "SELECT TENKHO FROM KHOHANG", "TENKHO");
//
tbx_maPN.Text = ""; txb_maPX.Text = ""; DisablePN(); DisablePX();
dgv_phieunhap.DataSource = acc.Select_Data("SELECT PN.MAPN, KHOHANG.TENKHO,NHANVIEN.TENNV,NGAYNHAP,NHACUNGCAP.TENNHACC,SANPHAM.TENSP,CT.SOLUONG,TONGTIEN,PN.GHICHU FROM PHIEUNHAPKHO PN left join NHACUNGCAP on NHACUNGCAP.MANCC = PN.MANCC left join KHOHANG on KHOHANG.MAKHO = PN.MAKHO left join NHANVIEN on NHANVIEN.MANV = PN.NVNHAP INNER JOIN CHITIETPHIEUNHAP CT ON PN.MAPN=CT.MAPN INNER join SANPHAM on SANPHAM.MASP = CT.MASP");
dgv_phieuxuat.DataSource = acc.Select_Data("SELECT PX.MAPX, KHOHANG.TENKHO, NHANVIEN.TENNV,NGAYXUAT,KHACHHANG.TENKH,SANPHAM.TENSP,CT.SOLUONG,TONGTIEN,PX.GHICHU FROM PHIEUXUAT PX LEFT join NHANVIEN on NHANVIEN.MANV = PX.NVXUAT left join KHACHHANG on KHACHHANG.MAKH = PX.MAKH left join KHOHANG on KHOHANG.MAKHO = PX.MAKHO INNER JOIN CHITIETPHIEUXUAT CT ON PX.MAPX = CT.MAPX INNER join SANPHAM on SANPHAM.MASP = CT.MASP");
cleartextPN();
dgv_phieunhap.ClearSelection();
autoWidth();
// Hiển thị tên cột nhập hàng:
dgv_phieunhap.Columns[0].HeaderText = "Mã Phiếu Nhập";
dgv_phieunhap.Columns[1].HeaderText = "Tên Kho";
dgv_phieunhap.Columns[2].HeaderText = "Tên Nhân Viên";
dgv_phieunhap.Columns[3].HeaderText = "Ngày Nhập";
dgv_phieunhap.Columns[4].HeaderText = "Tên Nhà Cung Cấp";
dgv_phieunhap.Columns[5].HeaderText = "Tên Sản Phẩm";
dgv_phieunhap.Columns[6].HeaderText = "Số lượng";
dgv_phieunhap.Columns[7].HeaderText = "Tổng Tiền";
dgv_phieunhap.Columns[8].HeaderText = "Ghi Chú";
// căn chỉnh độ rộng cột:
dgv_phieunhap.Columns[0].Width = 60;
dgv_phieunhap.Columns[1].Width = 150;
dgv_phieunhap.Columns[2].Width = 150;
dgv_phieunhap.Columns[6].Width = 50;
dgv_phieunhap.Columns[3].Width = 80;
dgv_phieunhap.Columns[4].Width = 200;
dgv_phieunhap.Columns[5].Width = 200;
// Hiển Thị tên cột xuất hàng:
dgv_phieuxuat.Columns[0].HeaderText = "Mã Phiếu Xuất";
dgv_phieuxuat.Columns[1].HeaderText = "Tên kho";
dgv_phieuxuat.Columns[2].HeaderText = "Nhân Viên Xuất";
dgv_phieuxuat.Columns[3].HeaderText = "Ngày Xuất";
dgv_phieuxuat.Columns[4].HeaderText = "Tên Khách Hàng";
dgv_phieuxuat.Columns[5].HeaderText = "Tên Sản Phẩm";
dgv_phieuxuat.Columns[6].HeaderText = "Số Lượng";
dgv_phieuxuat.Columns[7].HeaderText = "Tổng Tiền";
dgv_phieuxuat.Columns[8].HeaderText = "Ghi Chú";
// can do rong cot:
dgv_phieuxuat.Columns[0].Width = 60;
dgv_phieuxuat.Columns[1].Width = 150;
dgv_phieuxuat.Columns[2].Width = 150;
dgv_phieuxuat.Columns[4].Width = 150;
dgv_phieuxuat.Columns[5].Width = 150;
dgv_phieuxuat.Columns[6].Width = 50;
bt_xoa.Enabled = true;
bt_them.Enabled = true;
btn_themPX.Enabled = true;
button_chophepsua.Enabled = true;
btn_xoaPX.Enabled = true;
btn_themPX.Enabled = true;
btn_ghinhan.Enabled = false;
btn_chophepsua.Enabled = true;
btn_suaPX.Enabled = false;
DisablePN();
DisablePX();
tbx_maPN.Enabled = false;
txb_maPX.Enabled = false;
textBox1.Enabled = false;
}