private void Init() { txtPass.Properties.UseSystemPasswordChar = true; txtXacNhan.Properties.UseSystemPasswordChar = true; //Khởi tạo nhân viên bán hàng leNhanVien.Properties.TextEditStyle = TextEditStyles.Standard; leNhanVien.Properties.BestFitMode = BestFitMode.BestFit; SetDataSource(leNhanVien, BUS_NhanVien.LayNhanVienDonGian(), "EMPLOYEE_Name", "EMPLOYEE_ID"); leNhanVien.Properties.Columns[0].FieldName = "EMPLOYEE_Name"; leNhanVien.Properties.Columns[1].FieldName = "EMPLOYEE_ID"; //Khởi tạo vai trò leVaiTro.Properties.TextEditStyle = TextEditStyles.Standard; leVaiTro.Properties.BestFitMode = BestFitMode.BestFit; SetDataSource(leVaiTro, BUS_PhanQuyen.LoadPermision(), "Description", "ID"); leVaiTro.Properties.Columns[0].FieldName = "ID"; leVaiTro.Properties.Columns[1].FieldName = "Description"; if (add == true) { phatSinhMa(); } else { LoadDuLieuBP(); } }
private void phatSinhMa() { DataTable table = BUS_PhanQuyen.LoadUser(); var query = from tb in table.AsEnumerable() where tb.Field <string>("UserID").Contains("US") select new { maND = tb.Field <string>("UserID") }; DataTable dttb = new DataTable(); dttb.Columns.Add("UserID", typeof(string)); foreach (var item in query) { dttb.Rows.Add(item.maND); } string max, currentMa; int num; try { max = dttb.Compute("Max(UserID)", "").ToString(); num = int.Parse(max.Substring(2)) + 1; currentMa = "US" + num.ToString("000000"); Ma = currentMa; } catch { currentMa = "US000001"; Ma = currentMa; } }
private void Init() { gcUser.DataSource = BUS_PhanQuyen.LoadUser(); gvUser.Columns[0].FieldName = "UserID"; gvUser.Columns[1].FieldName = "UserName"; gvUser.Columns[2].FieldName = "Group_ID"; gvUser.Columns[3].FieldName = "Description"; gvUser.Columns[4].FieldName = "Active"; gcPermision.DataSource = BUS_PhanQuyen.LoadPermision(); gvPermision.Columns[0].FieldName = "ID"; gvPermision.Columns[1].FieldName = "Name"; gvPermision.Columns[2].FieldName = "Description"; gvPermision.Columns[3].FieldName = "ACTIVE"; gvRule.Columns[0].FieldName = "PER_ID"; gvRule.Columns[1].FieldName = "Object_ID"; gvRule.Columns[2].FieldName = "AllowView"; gvRule.Columns[3].FieldName = "AllowEdit"; gvRule.Columns[4].FieldName = "AllowAdd"; gvRule.Columns[5].FieldName = "AllowDelete"; gvRule.Columns[6].FieldName = "Active"; gvUser.FocusedRowChanged += GvUser_FocusedRowChanged; btnLamMoi.ItemClick += BtnLamMoi_ItemClick; btnXoa.ItemClick += BtnXoa_ItemClick; btnSua.ItemClick += BtnSua_ItemClick; btnThem.ItemClick += BtnThem_ItemClick; }
public UI_ThemNhanVien(Grid gridMain, DTO_NhanVien obj) { InitializeComponent(); DataContext = new TextFieldsViewModel(); this.gridMain = gridMain; isChangingVisible = false; cbbPermissionName.ItemsSource = BUS_PhanQuyen.showData(); cbbPermissionName.SelectedIndex = 0; if (obj == null) { AutoGenerateID(); btnVisible.IsChecked = true; isNew = true; } else { txtEmployeesID.Text = obj.MaNhanVien; txtEmployeesName.Text = obj.TenNhanVien; txtEmployeesUserName.Text = obj.UserName; txtEmployeesPass.Password = obj.Password; cbbPermissionName.Text = obj.TenPhanQuyen; if (obj.TrangThai == false) { btnVisible.IsChecked = false; txtEmployeesID.FontStyle = FontStyles.Oblique; txtEmployeesName.FontStyle = FontStyles.Oblique; txtEmployeesUserName.FontStyle = FontStyles.Oblique; txtEmployeesPass.FontStyle = FontStyles.Oblique; cbbPermissionName.FontStyle = FontStyles.Oblique; } isNew = false; } }
private void GvUser_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (gvUser.FocusedRowHandle >= 0 && gvUser.FocusedRowHandle <= gvUser.RowCount) { string ma = gvUser.GetFocusedRowCellValue("Group_ID").ToString(); gcRule.DataSource = BUS_PhanQuyen.LoadPhanQuyen(ma); } }
private void xl() { List <CQuyenHan> lqh = new List <CQuyenHan>(); string _PER_ID = editq.ID; string _Object_ID; bool _AllowView; bool _AllowAdd; bool _AllowDelete; bool _AllowEdit; bool _Active; GridView gv = gvRule as GridView; for (int i = 0; i < gvRule.RowCount; i++) { _Object_ID = gv.GetRowCellValue(i, "Object_ID").ToString(); _AllowView = bool.Parse(gv.GetRowCellValue(i, "AllowView").ToString()); _AllowAdd = bool.Parse(gv.GetRowCellValue(i, "AllowAdd").ToString()); _AllowDelete = bool.Parse(gv.GetRowCellValue(i, "AllowDelete").ToString()); _AllowEdit = bool.Parse(gv.GetRowCellValue(i, "AllowEdit").ToString()); _Active = bool.Parse(gv.GetRowCellValue(i, "Active").ToString()); CQuyenHan qh = new CQuyenHan ( _PER_ID, _Object_ID, _AllowView, _AllowAdd, _AllowDelete, _AllowEdit, _Active ); lqh.Add(qh); } if (add == true) { BUS_PhanQuyen.ThemVaiTro(editq, lqh); Action.Module = "Vai Trò"; Action.ActionName = "Thêm"; Action.Reference = editq.ID; Action.LuuThongTin(); } else { BUS_PhanQuyen.SuaVaiTro(editq, lqh); Action.Module = "Vai Trò"; Action.ActionName = "Sửa"; Action.Reference = editq.ID; Action.LuuThongTin(); } Close(); }
public static DataTable LayQuyenNguoiDung() { try { return(BUS_PhanQuyen.LoadPhanQuyen(vaitro)); } catch (Exception ex) { throw ex; } }
private void BtnLamMoi_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { gcUser.DataSource = BUS_PhanQuyen.LoadUser(); gcPermision.DataSource = BUS_PhanQuyen.LoadPermision(); string ma = string.Empty; try { ma = gvUser.GetFocusedRowCellValue("Group_ID").ToString(); } catch { } gcRule.DataSource = BUS_PhanQuyen.LoadPhanQuyen(ma); }
private void xlSua() { editUser.UserName = txtUserName.Text; editUser.Password = txtPass.Text; editUser.GroupID = leVaiTro.EditValue.ToString(); editUser.PartID = leNhanVien.Text == "" ? "" : leNhanVien.EditValue.ToString(); editUser.Description = txtDienGiai.Text; editUser.Active = checkConQL.Checked; BUS_PhanQuyen.SuaUser(editUser); Action.Module = "Người Dùng"; Action.ActionName = "Sửa"; Action.Reference = Ma; Action.LuuThongTin(); Close(); }
private void BtnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DialogResult rs = lc.ShowDialog(); if (rs == DialogResult.OK)//Vai trò { string ma = gvPermision.GetFocusedRowCellValue("ID").ToString(); BUS_PhanQuyen.XoaVaiTro(ma); return; } else if (rs == DialogResult.Yes)//Người dùng { string ma = gvUser.GetFocusedRowCellValue("UserID").ToString(); BUS_PhanQuyen.XoaUser(ma); return; } }
public static void LayQuyenNguoiDungTheoChucNang(string form) { try { DataTable table = BUS_PhanQuyen.LoadPhanQuyen(vaitro, form); Xem = bool.Parse(table.Rows[0]["AllowView"].ToString()); Sua = bool.Parse(table.Rows[0]["AllowEdit"].ToString()); Xoa = bool.Parse(table.Rows[0]["AllowDelete"].ToString()); Them = bool.Parse(table.Rows[0]["AllowAdd"].ToString()); ConHoatDong = bool.Parse(table.Rows[0]["Active"].ToString()); } catch (Exception ex) { throw ex; } }
public fSuaVaiTro(bool isAdd = true, CQuyen q = null) { InitializeComponent(); if (isAdd == false && q == null) { XtraMessageBox.Show("ERROR : Dữ liệu không được cung cấp để thực hiện hành động !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); Close(); } if (isAdd == true) { table = BUS_PhanQuyen.LoadPhanQuyen("admin"); Text = "Thêm Vai Trò"; } else { editq = q; table = BUS_PhanQuyen.LoadPhanQuyen(q.ID); Text = "Sửa thông tin vai trò"; } add = isAdd; gcRule.DataSource = table; Init(); }
public void Login() { try { data = bUS_NguoiDung.GetData(); if (data != null && !string.IsNullOrEmpty(txtUserName.Text) && !string.IsNullOrEmpty(txtPassWord.Text)) { if (CheckUsername(txtUserName.Text)) { if (CheckPass(HashPassword(txtPassWord.Text))) { //mở chức năng tương ứng với user //MessageBox.Show(Const.CurrentUser.TenDangNhap + " đăng nhập thành công!"); if (Const.CurrentUser.TenDangNhap == "admin") { Const.isFullOp = true; Const.isLogin = true; NhatKyHoatDong nhatKy = new NhatKyHoatDong(); nhatKy.NguoiDungId = Const.CurrentUser.NguoiDungId; nhatKy.NoiDung = "Tài khoản: admin đã đăng nhập"; nhatKy.ThaoTac = ""; nhatKy.ThoiGian = DateTime.Now; nhatKy.ChucNang = "Đăng nhập"; Const.NhatKyHoatDong.Insert(nhatKy); return; } BUS_PhanQuyen bUS_PhanQuyen = new BUS_PhanQuyen(); data = bUS_PhanQuyen.GetDetailPhanQuyen(Const.CurrentUser.NguoiDungId); for (int i = 0; i < data.Rows.Count; i++) { PhanQuyen quyen = new PhanQuyen(); quyen.TenNhomChucNang = data.Rows[i][1].ToString(); quyen.TenChucNang = data.Rows[i][2].ToString(); quyen.ChucNangThem = (bool)data.Rows[i][3]; quyen.ChucNangSua = (bool)data.Rows[i][4]; quyen.ChucNangXoa = (bool)data.Rows[i][5]; quyen.ChucNangDoc = (bool)data.Rows[i][6]; Const.PhanQuyens.Add(quyen); } Const.isLogin = true; NhatKyHoatDong nhatKyHoatDong = new NhatKyHoatDong(); nhatKyHoatDong.NguoiDungId = Const.CurrentUser.NguoiDungId; nhatKyHoatDong.NoiDung = "Tài khoản: " + Const.CurrentUser.TenDangNhap + " đã đăng nhập"; nhatKyHoatDong.ThaoTac = ""; nhatKyHoatDong.ThoiGian = DateTime.Now; nhatKyHoatDong.ChucNang = "Đăng nhập"; Const.NhatKyHoatDong.Insert(nhatKyHoatDong); } else { MessageBox.Show(CheckPass(txtPassWord.Text).ToString()); errorProvider1.BlinkStyle = ErrorBlinkStyle.BlinkIfDifferentError; errorProvider1.BlinkRate = 500; errorProvider1.SetError(txtPassWord, "Sai mật khâu người dùng!"); Const.isLogin = false; } } else { errorProvider1.BlinkStyle = ErrorBlinkStyle.BlinkIfDifferentError; errorProvider1.BlinkRate = 500; errorProvider1.SetError(txtUserName, "Sai tên tài khoản người dùng!"); Const.isLogin = false; } } } catch (Exception e) { MessageBox.Show(e.Message); } }