public static Feature getFeature(DataRow row) { Feature feature = new Feature(); feature.id = HelpNumber.ParseInt64(row["ID"]); feature.featureName = row["NAME"].ToString().Trim(); feature.isRead = (row["isread_bit"].ToString().Equals("Y") ? true : false); feature.isInsert = (row["isinsert_bit"].ToString().Equals("Y") ? true : false); feature.isUpdate = (row["isupdate_bit"].ToString().Equals("Y") ? true : false); feature.isDelete = (row["isdelete_bit"].ToString().Equals("Y") ? true : false); feature.isPrint = (row["isprint_bit"].ToString().Equals("Y") ? true : false); feature.isExport = (row["isexport_bit"].ToString().Equals("Y") ? true : false); return feature; }
public static void CustomizePermit() { try { if (User.isAdmin()) return; DevExpress.XtraBars.Ribbon.RibbonControl ribbon = ((frmRibbonMain)FrameworkParams.MainForm).Ribbon; FeatureQLTV = Permission.loadFeature(OChuongTrinh.id, OChuongTrinh.featureName, FrameworkParams.currentUser.username); if (FeatureQLTV.isInsert == false) { ribbon.Items[typeof(FrmChuongTrinh).FullName].Enabled = false; ribbon.Items[typeof(frmPostMaster).FullName].Enabled = false; ribbon.Items[typeof(frmBienMuc).FullName].Enabled = false; } var featureMT = Permission.loadFeature(OMuonTra.id, OMuonTra.featureName, FrameworkParams.currentUser.username); if (featureMT.isInsert == false) { ribbon.Items[typeof(frmMuonTra).FullName].Enabled = false; } var featureHD = Permission.loadFeature(OHardDisk.id, OHardDisk.featureName, FrameworkParams.currentUser.username); if (featureHD.isRead == false) { ribbon.Items[typeof(DMHardDisks).FullName].Enabled = false; ribbon.Items[typeof(DMThuMucHardDisk).FullName].Enabled = false; } var featureTTPS = Permission.loadFeature(OLichPhatSong.id, OLichPhatSong.featureName, FrameworkParams.currentUser.username); if (featureTTPS.isInsert == false) { ribbon.Items[typeof(FrmLichPhatSonNew).FullName].Enabled = false; } #region Danh mục var featureDMNuocSanXuat = Permission.loadFeature(DMNuocSanXuat.id, DMNuocSanXuat.featureName, FrameworkParams.currentUser.username); if (featureDMNuocSanXuat.isRead == false) { ribbon.Items[typeof(DMNuocSanXuat).FullName].Enabled = false; } var featureDMDonViCungCap = Permission.loadFeature(DMDonViCungCap.id, DMDonViCungCap.featureName, FrameworkParams.currentUser.username); if (featureDMDonViCungCap.isRead == false) { ribbon.Items[typeof(DMDonViCungCap).FullName].Enabled = false; } var featureDMDonViSoHuu = Permission.loadFeature(DMDonViSoHuu.id, DMDonViSoHuu.featureName, FrameworkParams.currentUser.username); if (featureDMDonViSoHuu.isRead == false) { ribbon.Items[typeof(DMDonViSoHuu).FullName].Enabled = false; } var featureDMHangSanXuat = Permission.loadFeature(DMHangSanXuat.id, DMHangSanXuat.featureName, FrameworkParams.currentUser.username); if (featureDMHangSanXuat.isRead == false) { ribbon.Items[typeof(DMHangSanXuat).FullName].Enabled = false; } var featureDMTietMuc = Permission.loadFeature(DMTietMuc.id, DMTietMuc.featureName, FrameworkParams.currentUser.username); if (featureDMTietMuc.isRead == false) { ribbon.Items[typeof(DMTietMuc).FullName].Enabled = false; } var featureDMLoaiBang = Permission.loadFeature(DMLoaiBang.id, DMLoaiBang.featureName, FrameworkParams.currentUser.username); if (featureDMLoaiBang.isRead == false) { ribbon.Items[typeof(DMLoaiBang).FullName].Enabled = false; } var featureDMDMThongSoLoaiBang = Permission.loadFeature(DMThongSoLoaiBang.id, DMThongSoLoaiBang.featureName, FrameworkParams.currentUser.username); if (featureDMDMThongSoLoaiBang.isRead == false) { ribbon.Items[typeof(DMThongSoLoaiBang).FullName].Enabled = false; } var featureDMDoiTuongKG = Permission.loadFeature(DMDoiTuongKG.id, DMDoiTuongKG.featureName, FrameworkParams.currentUser.username); if (featureDMDoiTuongKG.isRead == false) { ribbon.Items[typeof(DMDoiTuongKG).FullName].Enabled = false; } var featureDMDaiTruyenHinh = Permission.loadFeature(DMDaiTruyenHinh.id, DMDaiTruyenHinh.featureName, FrameworkParams.currentUser.username); if (featureDMDaiTruyenHinh.isRead == false) { ribbon.Items[typeof(DMDaiTruyenHinh).FullName].Enabled = false; } var featureDMTuKhoa = Permission.loadFeature(DMTuKhoa.id, DMTuKhoa.featureName, FrameworkParams.currentUser.username); if (featureDMTuKhoa.isRead == false) { ribbon.Items[typeof(DMTuKhoa).FullName].Enabled = false; } var featureDMDaoDien = Permission.loadFeature(DMDaoDien.id, DMDaoDien.featureName, FrameworkParams.currentUser.username); if (featureDMDaoDien.isRead == false) { ribbon.Items[typeof(DMDaoDien).FullName].Enabled = false; } var featureDMDienVien = Permission.loadFeature(DMDienVien.id, DMDienVien.featureName, FrameworkParams.currentUser.username); if (featureDMDienVien.isRead == false) { ribbon.Items[typeof(DMDienVien).FullName].Enabled = false; } var featureDMTinhTrangBang = Permission.loadFeature(DMTinhTrangBang.id, DMTinhTrangBang.featureName, FrameworkParams.currentUser.username); if (featureDMTinhTrangBang.isRead == false) { ribbon.Items[typeof(DMTinhTrangBang).FullName].Enabled = false; } var featureDMPostMaster = Permission.loadFeature(DMPostMaster.id, DMPostMaster.featureName, FrameworkParams.currentUser.username); if (featureDMPostMaster.isRead == false) { ribbon.Items[typeof(DMPostMaster).FullName].Enabled = false; } var featureDMLoaiFile = Permission.loadFeature(DMLoaiFile.id, DMLoaiFile.featureName, FrameworkParams.currentUser.username); if (featureDMLoaiFile.isRead == false) { ribbon.Items[typeof(DMLoaiFile).FullName].Enabled = false; } var featureDMRanking = Permission.loadFeature(DMRanking.id, DMRanking.featureName, FrameworkParams.currentUser.username); if (featureDMRanking.isRead == false) { ribbon.Items[typeof(DMRanking).FullName].Enabled = false; } var featureDMBanQuyenThuoc = Permission.loadFeature(DMBanQuyenThuoc.id, DMBanQuyenThuoc.featureName, FrameworkParams.currentUser.username); if (featureDMBanQuyenThuoc.isRead == false) { ribbon.Items[typeof(DMBanQuyenThuoc).FullName].Enabled = false; } var featureLoaiGhiChu = Permission.loadFeature(DMLoaiGhiChu.id, DMLoaiGhiChu.featureName, FrameworkParams.currentUser.username); if (featureLoaiGhiChu.isRead == false) { ribbon.Items[typeof(DMLoaiGhiChu).FullName].Enabled = false; } var itemDanhMuc = (BarSubItem)ribbon.Items[AppMenu.ItemDanhMuc]; var all = itemDanhMuc.ItemLinks.Count; var c = itemDanhMuc.ItemLinks.Cast<BarItemLink>().Count(link => link.Item.Enabled == false); if (all == c) itemDanhMuc.Enabled = false; c = 0; var featureDMCongTy = Permission.loadFeature(DMCongTy.id, DMCongTy.featureName, FrameworkParams.currentUser.username); if (featureDMCongTy.isRead == false) { ribbon.Items[typeof(DMCongTy).FullName].Enabled = false; c++; } var featureDMFWPhongBan = Permission.loadFeature(DMFWPhongBan.id, DMFWPhongBan.featureName, FrameworkParams.currentUser.username); if (featureDMFWPhongBan.isRead == false) { ribbon.Items[typeof(DMFWPhongBan).FullName].Enabled = false; c++; } var featureDMFWNhanVien = Permission.loadFeature(DMFWNhanVien.id, DMFWNhanVien.featureName, FrameworkParams.currentUser.username); if (featureDMFWNhanVien.isRead == false) { ribbon.Items[typeof(DMFWNhanVien).FullName].Enabled = false; c++; } if (c == 3) { ribbon.Items[AppMenu.ItemToChuc].Enabled = false; } #endregion #region Phân quyền dữ liệu var featurePQDLChuongTrinh = Permission.loadFeature(FPhanQuyenDLChuongTrinh.id, FPhanQuyenDLChuongTrinh.featureName, FrameworkParams.currentUser.username); // Feature featureQQDLHardDisk = Permission.loadFeature(FPhanQuyenDlHardDisk.id, FPhanQuyenDlHardDisk.featureName, FrameworkParams.currentUser.username); var featureQPDLMuonTra = Permission.loadFeature(FPhanQuyenDLMuonTra.id, FPhanQuyenDLMuonTra.featureName, FrameworkParams.currentUser.username); var featureQQDLKHPhatSong = Permission.loadFeature(FPhanQuyenDLKHPS.id, FPhanQuyenDLKHPS.featureName, FrameworkParams.currentUser.username); var featureQQDLKHBudget = Permission.loadFeature(FPhanQuyenDLKHBudget.id, FPhanQuyenDLKHBudget.featureName, FrameworkParams.currentUser.username); if (featurePQDLChuongTrinh.isRead == false && featureQPDLMuonTra.isRead == false && featureQQDLKHPhatSong.isRead == false && featureQQDLKHBudget.isRead == false) { ribbon.Items[typeof(frmPermissionDataQL).FullName].Enabled = false; } else { ribbon.Items[typeof(frmPermissionDataQL).FullName].Enabled = true; } #endregion FeatureChuyenTrangThaiKHBG12 = Permission.loadFeature(FChuyenTrangThaiKHBG12.id, FChuyenTrangThaiKHBG12.featureName, FrameworkParams.currentUser.username); FeatureChuyenTrangThaiKHBG23 = Permission.loadFeature(FChuyenTrangThaiKHBG23.id, FChuyenTrangThaiKHBG23.featureName, FrameworkParams.currentUser.username); FeatureBangGiaBudget = Permission.loadFeature(OBangGiaBudget.id, OBangGiaBudget.featureName, FrameworkParams.currentUser.username); var featureTNSFile = Permission.loadFeature(OQLFileNguonTNS.id, OQLFileNguonTNS.featureName, FrameworkParams.currentUser.username); if (featureTNSFile.isInsert == false) { ribbon.Items[typeof(FrmTNSProgramGridSCR).FullName].Enabled = false; } var featureTNSDSSale = Permission.loadFeature(FDanhMucSale.id, FDanhMucSale.featureName, FrameworkParams.currentUser.username); if (featureTNSDSSale.isRead == false) { ribbon.Items[AppMenu.ItemDanhSachTNSSale].Enabled=false; } } catch { } }
private void barButtonItemSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { List<Feature> features = new List<Feature>(); List<BaoBieu> reports = new List<BaoBieu>(); if (this.xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup")) { foreach (int j in gridViewGroup.GetSelectedRows()) { DataRow row1 = this.gridViewGroup.GetDataRow(j); long groudId = HelpNumber.ParseInt64(row1["groupid"].ToString()); //for (int i = 0; i < gridViewFeature.RowCount; i++) //{ // Feature feature = new Feature(); // feature = this.getFeature(this.gridViewFeature.GetDataRow(i)); // features.Add(feature); //} //HUNG//treelist DataTable dt = treeListFeature.DataSource as DataTable; foreach (DataRow row in dt.Rows) { //Chi luu child row, khong luu parent row if (row["PARENTID"] != DBNull.Value) { Feature feature = new Feature(); feature = this.getFeature(row); features.Add(feature); } } ///--------------- for (int i = 0; i < gridViewReport.RowCount; i++) { BaoBieu report = new BaoBieu(); report = this.getReport(this.gridViewReport.GetDataRow(i)); reports.Add(report); } Feature.updateGroup(groudId, features); BaoBieu.updateGroup(groudId, reports); } } else { foreach (int j in gridViewUser.GetSelectedRows()) { DataRow row1 = this.gridViewUser.GetDataRow(j); long userID = HelpNumber.ParseInt64(row1["userid"].ToString()); //for (int i = 0; i < gridViewFeature.RowCount; i++) //{ // Feature feature = new Feature(); // feature = this.getFeature(this.gridViewFeature.GetDataRow(i)); // features.Add(feature); //} //HUNG//treelist DataTable dt = treeListFeature.DataSource as DataTable; foreach (DataRow row in dt.Rows) { //Chi luu child row, khong luu parent row if (row["PARENTID"] != DBNull.Value) { Feature feature = new Feature(); feature = this.getFeature(row); features.Add(feature); } } ///--------------- for (int i = 0; i < gridViewReport.RowCount; i++) { BaoBieu report = new BaoBieu(); report = this.getReport(this.gridViewReport.GetDataRow(i)); reports.Add(report); } Feature.updateUser(userID, features); BaoBieu.updateUser(userID, reports); } } if (xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup")) loadGridViewGroupSelectionChanged(); else loadGridViewUserSelectionChanged(); }
public Feature load(long featureID, string featureName, string username) { DatabaseFB db = DABase.getDatabase(); DbCommand dbSelect = db.GetStoredProcCommand("FW_GET_FEATURE"); db.AddInParameter(dbSelect, "@USERNAME", DbType.String, username); db.AddInParameter(dbSelect, "@FEATURENAME", DbType.String, featureName); IDataReader reader = db.ExecuteReader(dbSelect); Feature feature = new Feature(); feature.featureName = featureName; feature.id = featureID; while (reader.Read()) { feature.id = HelpNumber.ParseInt64(reader["ID"].ToString()); if (reader["ISREAD_BIT"].ToString().Equals("Y")) feature.isRead = true; if (reader["ISINSERT_BIT"].ToString().Equals("Y")) feature.isInsert = true; if (reader["ISDELETE_BIT"].ToString().Equals("Y")) feature.isDelete = true; if (reader["ISUPDATE_BIT"].ToString().Equals("Y")) feature.isUpdate = true; if (reader["ISPRINT_BIT"].ToString().Equals("Y")) feature.isPrint = true; if (reader["ISEXPORT_BIT"].ToString().Equals("Y")) feature.isExport = true; } reader.Close(); return feature; }
//PHUOC OK public List<Feature> getAllFeature() { List<Feature> listFeature = new List<Feature>(); DatabaseFB db = DABase.getDatabase(); DbCommand dbSelect = db.GetSQLStringCommand("SELECT * FROM FEATURE_CAT ORDER BY lower(NAME) ASC WHERE VISIBLE_BIT='Y'"); IDataReader reader = db.ExecuteReader(dbSelect); while (reader.Read()) { Feature feature = new Feature(); feature.id = HelpNumber.ParseInt64(reader["ID"].ToString()); feature.featureName = reader["NAME"].ToString(); listFeature.Add(feature); } reader.Close(); return listFeature; }