private void frmNhatKy_Load(object sender, EventArgs e)
{
#region Init GridView
AppGridView.InitGridView(gridViewTaiKhoan, true, true, GridMultiSelectMode.RowSelect, false, false);
AppGridView.ShowField(gridViewTaiKhoan, new string[] { "MaNhomQuyen", "HoTen", "TenDangNhap", "TenMayTinh", "PhienBan", "NgayDangNhap" },
new string[] { "Nhóm quyền", "Họ tên", "Tên truy cập", "Tên máy tính", "Phiên bản", "Ngày đăng nhập" },
new int[] { 200, 200, 150, 150, 100, 150 });
//Attach Control to GridView
AppGridView.RegisterControlField(gridViewTaiKhoan, "MaNhomQuyen", repositoryItemGridLookUpEditNhomQuyen);
AppGridView.RegisterControlField(gridViewTaiKhoan, "NgayDangNhap", repositoryItemTextEditNgayDangNhap);
AppGridView.ReadOnlyColumn(gridViewTaiKhoan, new string[] { "MaNhomQuyen", "HoTen", "TenDangNhap", "TenMayTinh", "PhienBan", "NgayDangNhap" });
#endregion
#region RepositoryItemGridLookUpEdit Nhom Quyen
AppRepositoryItemGridLookUpEdit.InitRepositoryItemGridLookUp(repositoryItemGridLookUpEditNhomQuyen, true, TextEditStyles.Standard);
AppRepositoryItemGridLookUpEdit.ShowField(repositoryItemGridLookUpEditNhomQuyen, new string[] { "TenNhomQuyen" }, new string[] { "Tên nhóm quyền" });
repositoryItemGridLookUpEditNhomQuyen.ValueMember = "MaNhomQuyen";
repositoryItemGridLookUpEditNhomQuyen.DisplayMember = "TenNhomQuyen";
repositoryItemGridLookUpEditNhomQuyen.NullText = string.Empty;
#endregion
#region Init Datasource
bindingSourceTaiKhoan.DataSource = DataServices.TaiKhoan.GetAll();
bindingSourceNhomQuyen.DataSource = DataServices.NhomQuyen.GetAll();
#endregion
}
private void ucTuDienDuLieu_Load(object sender, EventArgs e)
{
DataTable dt = DataProvider.ExecQueryStore("sp_UI_GridView_LayTheoMa", new SqlParameter("@MaGridView", _chucNang.MaGridView));
DataRow dr = dt.Rows[0];
#region Init GridView
AppGridView.Init(gridViewDuLieu
, (bool)XuLyKieuDuLieu.ThayTheNull(dr["MultiSelect"], typeof(bool))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["MultiSelectMode"], typeof(string))
, (bool)XuLyKieuDuLieu.ThayTheNull(dr["ShowDetailButtons"], typeof(bool))
, (bool)XuLyKieuDuLieu.ThayTheNull(dr["ShowGroupPanel"], typeof(bool))
, (int)XuLyKieuDuLieu.ThayTheNull(dr["WordWrapHeader"], typeof(int))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["NewItemRowText"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["GroupPanelText"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["ColumnFields"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["ColumnNames"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["ColumnWidths"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["HideFields"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["ReadOnlyFields"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["FixedFields"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(dr["FixedStyle"], typeof(string))
);
dt = DataProvider.ExecQueryStore("sp_UI_GridView_AlignHeader_LayTheoMa", new SqlParameter("@MaGridView", _chucNang.MaGridView));
foreach (DataRow row in dt.Rows)
{
AppGridView.AlignHeader(gridViewDuLieu
, (string)XuLyKieuDuLieu.ThayTheNull(row["AlignHeaders"], typeof(string))
, (string)XuLyKieuDuLieu.ThayTheNull(row["AlignStyle"], typeof(string))
);
}
#endregion
}
private void frmXemNguoiDung_Load(object sender, EventArgs e)
{
AppGridView.InitGridView(gridViewNguoiDung, true, false, DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect, false, false);
AppGridView.ShowField(gridViewNguoiDung, new string[] { "TenDangNhap", "Chon" }, new string[] { "Tên truy cập", "Chọn" }, new int[] { 250, 70 });
AppGridView.ReadOnlyColumn(gridViewNguoiDung, new string[] { "TenDangNhap" });
AppGridView.AlignHeader(gridViewNguoiDung, new string[] { "Chon" }, DevExpress.Utils.HorzAlignment.Center);
AppGridView.UnSortField(gridViewNguoiDung, new string[] { "Chon" });
InitData();
}
private void ShowFile()
{
AppGridView.InitGridView(gridViewTieuDe, true, false, DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect, false, false);
AppGridView.ShowField(gridViewTieuDe, strIDColumns, strFieldColumns, iSizeColumns);
AppGridView.ShowEditor(gridViewTieuDe, NewItemRowPosition.Top);
AppGridView.AlignHeader(gridViewTieuDe, strIDColumns, DevExpress.Utils.HorzAlignment.Center);
AppGridView.ReadOnlyColumn(gridViewTieuDe, new string[] { "IdFileName" });
AppGridView.RegisterControlField(gridViewTieuDe, "IdFrom", repositoryItemCheckedComboBoxEditIdFrom);
Load_IdFrom();
}
private void frmPhanQuyenTaiKhoan_Load(object sender, EventArgs e)
{
AppGridView.InitGridView(gridViewPhanQuyenTaiKhoan, true, true, DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect, true, false);
AppGridView.ShowField(gridViewPhanQuyenTaiKhoan, new string[] { "TenChucNang", "KhongDuocPhepCapNhat" }
, new string[] { "Tên chức năng", "Không được phép cập nhật" }, new int[] { 350, 150 });
AppGridView.AlignHeader(gridViewPhanQuyenTaiKhoan, new string[] { "TenChucNang", "KhongDuocPhepCapNhat" }, DevExpress.Utils.HorzAlignment.Center);
AppGridView.ReadOnlyColumn(gridViewPhanQuyenTaiKhoan, new string[] { "TenChucNang" });
InitData();
}
private void gridViewQuyen_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (AppGridView.IsNewRow(gridViewQuyen, e.RowHandle))
{
gridViewQuyen.SetRowCellValue(e.RowHandle, "TrangThaiThayDoi", TrangThaiDuLieu.Them);
}
else
{
gridViewQuyen.SetRowCellValue(e.RowHandle, "TrangThaiThayDoi", TrangThaiDuLieu.CapNhat);
}
}
private void frmQuyen_Load(object sender, System.EventArgs e)
{
#region gridview
AppGridView.Init(gridViewQuyen, true, false, DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CellSelect
, true, true, "Nhấn vào đây để thêm dòng mới");
AppGridView.ShowField(gridViewQuyen
, new string[] { "MaQuyen", "TenQuyen", "GhiChu" }
, new string[] { "Mã quyền", "Tên quyền", "Ghi chú" }
, new int[] { 100, 200, 300 });
bsQuyen.DataSource = _dataQuyen.LayDuLieu();
#endregion
}
private void frmTaiKhoan_Load(object sender, EventArgs e)
{
#region Init GridView
AppGridView.InitGridView(gridViewTaiKhoan, true, true, GridMultiSelectMode.CellSelect, false, false, "Nhấn vào đây để thêm dòng mới");
AppGridView.ShowField(gridViewTaiKhoan, new string[] { "MaNhomQuyen", "HoTen", "TenDangNhap", "MatKhau", "Xem", "TrangThai", "ResetPassWordGv", "PhanQuyen", "UserUis" },
new string[] { "Nhóm quyền", "Họ tên", "Tên truy cập", "Mật khẩu", "Xem", "Khoá tài khoản", "Reset mật khẩu GV", "Phân quyền chức năng", "Tài khoản UIS" }, new int[] { 200, 200, 150, 70, 60, 100, 120, 150, 200 });
AppGridView.ShowEditor(gridViewTaiKhoan, NewItemRowPosition.Top);
AppGridView.AlignHeader(gridViewTaiKhoan, new string[] { "MaNhomQuyen", "HoTen", "TenDangNhap", "MatKhau", "Xem", "TrangThai", "ResetPassWordGv", "PhanQuyen", "UserUis" }, DevExpress.Utils.HorzAlignment.Center);
//Attach Control to GridView
AppGridView.RegisterControlField(gridViewTaiKhoan, "MaNhomQuyen", repositoryItemGridLookUpEditNhomQuyen);
AppGridView.RegisterControlField(gridViewTaiKhoan, "MatKhau", repositoryItemTextEditMatKhau);
AppGridView.RegisterControlField(gridViewTaiKhoan, "Xem", repositoryItemButtonEditXem);
AppGridView.RegisterControlField(gridViewTaiKhoan, "PhanQuyen", repositoryItemButtonEditPhanQuyenTaiKhoan);
AppGridView.RegisterControlField(gridViewTaiKhoan, "UserUis", repositoryItemCheckedComboBoxEditTaiKhoanUis);
AppGridView.AlignHeader(gridViewTaiKhoan, new string[] { "Xem", "TrangThai", "PhanQuyen" }, DevExpress.Utils.HorzAlignment.Center);
AppGridView.UnSortField(gridViewTaiKhoan, new string[] { "Xem", "TrangThai", "PhanQuyen" });
AppGridView.HideField(gridViewTaiKhoan, new string[] { "Xem" });
#endregion
#region RepositoryItemGridLookUpEdit Nhom Quyen
AppRepositoryItemGridLookUpEdit.InitRepositoryItemGridLookUp(repositoryItemGridLookUpEditNhomQuyen, true, TextEditStyles.Standard);
AppRepositoryItemGridLookUpEdit.ShowField(repositoryItemGridLookUpEditNhomQuyen, new string[] { "TenNhomQuyen", "GhiChu" }, new string[] { "Tên nhóm quyền", "Ghi chú" });
repositoryItemGridLookUpEditNhomQuyen.ValueMember = "MaNhomQuyen";
repositoryItemGridLookUpEditNhomQuyen.DisplayMember = "TenNhomQuyen";
repositoryItemGridLookUpEditNhomQuyen.NullText = string.Empty;
#endregion
#region Init Datasource
bindingSourceTaiKhoan.DataSource = DataServices.TaiKhoan.GetByNhomQuyenQL((Int32)UserInfo.GroupID);
bindingSourceNhomQuyen.DataSource = DataServices.NhomQuyen.GetByNhomQuyenQL((Int32)UserInfo.GroupID);
repositoryItemCheckedComboBoxEditTaiKhoanUis.SelectAllItemCaption = "Tất cả";
repositoryItemCheckedComboBoxEditTaiKhoanUis.TextEditStyle = TextEditStyles.Standard;
repositoryItemCheckedComboBoxEditTaiKhoanUis.Items.Clear();
IDataReader dr = DataServices.TaiKhoan.GetAllTaiKhoanUis();
DataTable tkUis = new DataTable();
tkUis.Load(dr);
bindingSourceTKUis.DataSource = tkUis;
List <CheckedListBoxItem> list = new List <CheckedListBoxItem>();
foreach (DataRow obj in tkUis.Rows)
{
list.Add(new CheckedListBoxItem((string)obj["MaTaiKhoan"], (string)obj["HoTen"], CheckState.Unchecked, true));
}
repositoryItemCheckedComboBoxEditTaiKhoanUis.Items.AddRange(list.ToArray());
repositoryItemCheckedComboBoxEditTaiKhoanUis.SeparatorChar = ';';
#endregion
}
private void frmKhoaTaiKhoanGiangVien_Load(object sender, EventArgs e)
{
#region Init GridView
AppGridView.InitGridView(gridViewKhoaTaiKhoan, true, true, DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect, true, true);
AppGridView.ShowField(gridViewKhoaTaiKhoan, new string[] { "MaGiangVien", "MaQuanLy", "HoTen", "TenHocHam", "TenHocVi", "TenLoaiGiangVien", "TenDonVi", "KhoaTaiKhoan" }
, new string[] { "Id", "Mã giảng viên", "Họ tên", "Học hàm", "Học vị", "Loại giảng viên", "Khoa - Đơn vị", "Khoá tài khoản" }
, new int[] { 99, 90, 140, 100, 100, 100, 100, 100 });
AppGridView.AlignHeader(gridViewKhoaTaiKhoan, new string[] { "MaGiangVien", "MaQuanLy", "HoTen", "TenHocHam", "TenHocVi", "TenLoaiGiangVien", "TenDonVi", "KhoaTaiKhoan" }, DevExpress.Utils.HorzAlignment.Center);
AppGridView.HideField(gridViewKhoaTaiKhoan, new string[] { "MaGiangVien" });
AppGridView.ReadOnlyColumn(gridViewKhoaTaiKhoan, new string[] { "MaGiangVien", "MaQuanLy", "HoTen", "TenHocHam", "TenHocVi", "TenLoaiGiangVien", "TenDonVi" });
AppGridView.SummaryField(gridViewKhoaTaiKhoan, "MaQuanLy", "{0}", DevExpress.Data.SummaryItemType.Count);
#endregion
InitData();
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
_dsMaCanXoa.Add((string)gridViewQuyen.GetRowCellValue(gridViewQuyen.FocusedRowHandle, "MaQuyen"));
AppGridView.DeleteSelectedRows(gridViewQuyen);
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
AppGridView.DeleteSelectedRows(gridViewTaiKhoan);
}
private void gridViewTaiKhoan_KeyUp(object sender, KeyEventArgs e)
{
AppGridView.DeleteSelectedRows(gridViewTaiKhoan, e);
}
private void gridViewTaiKhoan_KeyDown(object sender, KeyEventArgs e)
{
AppGridView.CopyCell(gridViewTaiKhoan, e);
}
