void LoadData()
{
cboPhanQuyen.DataSource = PhanQuyenBUS.LoadPhanQuyen();
cboPhanQuyen.DisplayMember = "TenPQ";
cboPhanQuyen.ValueMember = "MaPQ";
cboTo.DataSource = ToBUS.LoadTo();
cboTo.DisplayMember = "MaTo";
cboTo.ValueMember = "MaTo";
txtMaNV.Text = NhanVienBUS.GetIDNhanVien();
}
private void ReLoad()
{
PhanQuyenBUS phanQuyenBUS = new PhanQuyenBUS();
List <PhanQuyenDTO> phanQuyenDTOs = phanQuyenBUS.GetRoleForm(int.Parse(cbVaiTro.SelectedValue.ToString()));
dgvPhanQuyen.DataSource = phanQuyenDTOs;
dgvPhanQuyen.Columns["FormID"].Visible = false;
dgvPhanQuyen.Columns["FormName"].HeaderText = "Chức năng";
dgvPhanQuyen.Columns["AllowAccess"].HeaderText = "Truy cập";
dgvPhanQuyen.Columns["AllowAdd"].HeaderText = "Thêm";
dgvPhanQuyen.Columns["AllowDelete"].HeaderText = "Xóa";
dgvPhanQuyen.Columns["AllowUpdate"].HeaderText = "Cập nhật";
dgvPhanQuyen.Columns["AllowImport"].HeaderText = "Nhập";
dgvPhanQuyen.Columns["AllowExport"].HeaderText = "Xuất";
}
void LoadData()
{
cboPhanQuyen.DataSource = PhanQuyenBUS.LoadPhanQuyen();
cboPhanQuyen.DisplayMember = "TenPQ";
cboPhanQuyen.ValueMember = "MaPQ";
cboTo.DataSource = ToBUS.LoadTo();
cboTo.DisplayMember = "MaTo";
cboTo.ValueMember = "MaTo";
txtMaNV.Text = NV.MaNV;
txtHoten.Text = NV.HoTen;
txtDiaChi.Text = NV.DiaChi;
txtCMND.Text = NV.CMND;
txtDienthoai.Text = NV.DienThoai;
txtKhanang.Text = NV.KhaNangLai.ToString();
txtUsername.Text = NV.Username;
cboTo.SelectedValue = NV.MaTo;
cboPhanQuyen.SelectedValue = NV.MaPQ;
}
private void btnSave_Click(object sender, EventArgs e)
{
PhanQuyenBUS phanQuyenBUS = new PhanQuyenBUS();
List <PhanQuyenDTO> phanQuyenDTOs = new List <PhanQuyenDTO>();
foreach (DataGridViewRow dr in dgvPhanQuyen.Rows)
{
PhanQuyenDTO item = new PhanQuyenDTO();
item.FormName = dr.Cells["FormName"].Value.ToString();
item.AllowAccess = bool.Parse(dr.Cells["AllowAccess"].Value.ToString());
item.AllowAdd = bool.Parse(dr.Cells["AllowAdd"].Value.ToString());
item.AllowDelete = bool.Parse(dr.Cells["AllowDelete"].Value.ToString());
item.AllowImport = bool.Parse(dr.Cells["AllowImport"].Value.ToString());
item.AllowUpdate = bool.Parse(dr.Cells["AllowUpdate"].Value.ToString());
item.AllowExport = bool.Parse(dr.Cells["AllowExport"].Value.ToString());
item.FormID = int.Parse(dr.Cells["FormID"].Value.ToString());
phanQuyenDTOs.Add(item);
}
phanQuyenBUS.SetRoleForm(phanQuyenDTOs, int.Parse(cbVaiTro.SelectedValue.ToString()));
}
private void gvDanhSachPhanQuyen_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhSachPhanQuyen.FocusedRowHandle > -1)
{
try
{
PhanQuyenDTO itemDTO = new PhanQuyenDTO();
PhanQuyenBUS itemBUS = new PhanQuyenBUS();
itemDTO.Doc = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Doc").ToString());
itemDTO.Them = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Them").ToString());
itemDTO.Sua = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Sua").ToString());
itemDTO.Xoa = bool.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Xoa").ToString());
itemDTO.Id = int.Parse(gvDanhSachPhanQuyen.GetFocusedRowCellValue("Id").ToString());
itemBUS.Sua(itemDTO);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void frmMain_Load(object sender, EventArgs e)
{
timer.Start();
Form frm = CheckForm(typeof(Dashboard));
if (frm != null)
{
frm.Activate();
}
else
{
Dashboard frmN = new Dashboard();
frmN.MdiParent = this;
frmN.Show();
}
//user login label
NhanVienBUS busNV = new NhanVienBUS();
var dt = busNV.GetDataByID(IDNhanVien);
this.txtUserLogin.Caption = " Tài khoản đang đăng nhập: " + dt.Rows[0]["HoTen"].ToString() + " (" +
dt.Rows[0]["TaiKhoan"].ToString() + ")";
//check quyen han
PhanQuyenBUS busPQ = new PhanQuyenBUS();
dt = busPQ.GetDataByIDNhom(IDNhom);
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["IDChucNang"].Equals("baocao") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnBCBanHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnBCSanPham.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnBCKhachHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnBCNhaCungCap.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnBCNhanVien.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonBaoCao.Visible = true;
//btnBCBanHang.Enabled = true;
//btnBCSanPham.Enabled = true;
//btnBCKhachHang.Enabled = true;
//btnBCNhaCungCap.Enabled = true;
//btnBCNhanVien.Enabled = true;
}
//============================= Group doi tac ===============================
if (dataRow["IDChucNang"].Equals("khachhang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnKhachHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonDoiTac.Visible = true;
//btnKhachHang.Enabled = true;
}
if (dataRow["IDChucNang"].Equals("nhacungcap") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnNhaCungCap.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonDoiTac.Visible = true;
//btnNhaCungCap.Enabled = true;
}
//============================= Group hang hoa =============================
if (dataRow["IDChucNang"].Equals("loaihang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnLoaiHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonHangHoa.Visible = true;
//btnLoaiHang.Enabled = true;
}
if (dataRow["IDChucNang"].Equals("sanpham") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnSanPham.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonHangHoa.Visible = true;
//btnSanPham.Enabled = true;
}
if (dataRow["IDChucNang"].Equals("donvitinh") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnDonViTinh.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonHangHoa.Visible = true;
//btnDonViTinh.Enabled = true;
}
//============================= Group Nhap xuat hang =============================
if (dataRow["IDChucNang"].Equals("nhaphang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnNhapHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonNhapXuatHang.Visible = true;
//btnNhapHang.Enabled = true;
}
if (dataRow["IDChucNang"].Equals("banhang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnBanHang.Enabled = true;
ribbonNhapXuatHang.Visible = true;
}
if (dataRow["IDChucNang"].Equals("qlbanhang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnQLBanHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonNhapXuatHang.Visible = true;
//btnQLBanHang.Enabled = true;
}
if (dataRow["IDChucNang"].Equals("qlnhaphang") && Convert.ToInt32(dataRow["Xem"]) == 1)
{
btnQLKhoHang.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
ribbonNhapXuatHang.Visible = true;
//btnQLKhoHang.Enabled = true;
}
}
if (IDNhom == 1)
{
btnNhanVien.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnNhomQuyen.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
btnPhanQuyen.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
//btnNhanVien.Enabled = true;
//btnNhomQuyen.Enabled = true;
//btnPhanQuyen.Enabled = true;
}
}
void Custom()
{
dgvDanhSach.AutoGenerateColumns = false;
dgvDanhSach.Columns.Clear();
dgvDanhSach.AllowUserToAddRows = false;
DataGridViewTextBoxColumn dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Mã nhân viên";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvCol.DataPropertyName = "MaNV";
dgvCol.ReadOnly = true;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Họ tên";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgvCol.DataPropertyName = "HoTen";
dgvCol.Width = 160;
dgvCol.ReadOnly = true;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Địa chỉ";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgvCol.DataPropertyName = "DiaChi";
dgvCol.ReadOnly = true;
dgvCol.Width = 300;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "CMND";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgvCol.DataPropertyName = "CMND";
dgvCol.ReadOnly = true;
dgvCol.Width = 120;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Điện thoại";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgvCol.DataPropertyName = "DienThoai";
dgvCol.ReadOnly = true;
dgvCol.Width = 110;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Khả năng lái";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvCol.DataPropertyName = "KhaNangLai";
dgvCol.ReadOnly = true;
dgvCol.DefaultCellStyle.Format = "#,0 km";
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Username";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvCol.DataPropertyName = "Username";
dgvCol.ReadOnly = true;
dgvDanhSach.Columns.Add(dgvCol);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Password";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvCol.DataPropertyName = "Password";
dgvCol.ReadOnly = true;
dgvDanhSach.Columns.Add(dgvCol);
DataGridViewComboBoxColumn dgvCo = new DataGridViewComboBoxColumn();
dgvCo.HeaderText = "Phân quyền";
dgvCo.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvCo.DataSource = PhanQuyenBUS.LoadPhanQuyen();
dgvCo.DisplayMember = "TenPQ";
dgvCo.ValueMember = "MaPQ";
dgvCo.DataPropertyName = "MaPQ";
dgvCo.ReadOnly = true;
dgvCo.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
dgvDanhSach.Columns.Add(dgvCo);
dgvCol = new DataGridViewTextBoxColumn();
dgvCol.HeaderText = "Tổ";
dgvCol.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvCol.DataPropertyName = "MaTo";
dgvCol.ReadOnly = true;
dgvDanhSach.Columns.Add(dgvCol);
dgvCo = new DataGridViewComboBoxColumn();
dgvCo.HeaderText = "Tình trạng";
dgvCo.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvCo.DataSource = PhanQuyenBUS.LoadTinhTrang();
dgvCo.DisplayMember = "TenTinhTrang";
dgvCo.ValueMember = "MaTinhTrang";
dgvCo.DataPropertyName = "TinhTrang";
dgvCo.ReadOnly = true;
dgvCo.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
dgvDanhSach.Columns.Add(dgvCo);
}
