public ActionResult SearchPermissionAll(string strKeyWord, int intPageIndex = 0)
{
try
{
StringBuilder strHTMLPermission = new StringBuilder();
DataTable dtbPermission = new PermissionDAO().SearchPermission(strKeyWord, -1, -1);
if (dtbPermission != null && dtbPermission.Rows.Count > 0)
{
strHTMLPermission = GenHTMLPermissionAll(dtbPermission);
}
else
{
strHTMLPermission.Append("<tr><td colspan='12' class='table-content-null'>Hiện không có nội dung</td></tr>");
}
return(Json(new
{
iserror = false,
content = Convert.ToString(strHTMLPermission)
}));
}
catch
{
return(Json(new { iserror = true }));
}
}
/// <summary>
/// 为创建角色返回权限列表
/// </summary>
/// <param name="hasPermission"></param>
/// <returns></returns>
public Status getPermissions(out List <Permission> permissions)
{
permissions = new List <Permission>();
PermissionDAO permissionDao = Factory.getInstance <PermissionDAO>();
List <PermissionVO> permissionVos = permissionDao.getAll <PermissionVO>();
if (permissionVos.Count == 0)
{
return(Status.NONFOUND);
}
foreach (PermissionVO vo in permissionVos)
{
permissions.Add(
new Permission
{
permissionID = vo.permissionID,
permissionName = vo.permissionName
});
}
return(Status.SUCCESS);
}
override public void AddPermission(int gameId, int playerId, string identifier, string password, Permission.TYPE type)
{
using (var permissionsDAO = new PermissionDAO())
{
permissionsDAO.AddPermission(gameId, playerId, identifier, type, password);
}
}
override public Object GetPermission(int gameId)
{
using (PermissionDAO dao = new PermissionDAO())
{
return(dao.GetPermissions(gameId, ClaimsPrincipal.Current.Identity.Name));
}
}
/// <summary>
/// 删除权限组
/// </summary>
/// <param name="nGroupId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool DeletePermissionGroup(long nGroupId, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
//删除权限组
if (!dao.DeletePermissionGroup(nGroupId, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
//删除组权限
if (!dao.DeleteGroupPermissions(nGroupId, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
}
transScope.Complete();
}
return(true);
}
catch (Exception e)
{
strErrText = e.Message;
return(false);
}
}
public void GetPermission(int id = 0)
{
PermissionDAO permissionDAO = new PermissionDAO();
var listPermission = permissionDAO.ListAll();
ViewBag.ListPermission = new SelectList(listPermission, "PermissionID", "PermissionName", id);
}
public ViewPermissions(controlPanel parent)
{
InitializeComponent();
this.parent = parent;
dataGrid.IsReadOnly = true;
dataGrid.ItemsSource = PermissionDAO.getAllPermissions();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (btnXoa.Text == "Xóa")
{
DialogResult rs = MessageBox.Show("Bạn có chắc chắn muốn xóa ?", "Thông báo", MessageBoxButtons.YesNo);
if (rs == DialogResult.Yes)
{
long Emp_ID = Convert.ToInt32(grv_Quyen.GetFocusedRowCellValue("ID"));
bool result = new PermissionDAO().Delete_Permission(Emp_ID);
if (result)
{
MessageBox.Show("Xóa thành công");
Disable_Control();
Load_dgr_Quyen();
}
else
{
MessageBox.Show("Có lỗi xảy ra");
}
}
}
if (btnXoa.Text == "Hủy")
{
btnThem.Text = "Thêm";
btnSua.Text = "Sửa";
btnXoa.Text = "Xóa";
Disable_Control();
Load_dgr_Quyen();
}
}
public UniversalEntity RetrievePermissionsByUserLeft(int id)
{
PermissionDAO entDAO = new PermissionDAO();
sc = new SqlCommand("RetrievePermissionsByUserLeft");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@UserID", id);
return(entDAO.retrieveEntity(sc));
}
/// <summary>
/// 修改权限组
/// </summary>
/// <param name="nGroupId"></param>
/// <param name="strName"></param>
/// <param name="strRemark"></param>
/// <param name="listFunction"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool UpdatePermissionGroup(long nGroupId, string strName, string strRemark, List <SysFunction> listFunction, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
//修改权限组
if (!dao.UpdatePermissionGroup(nGroupId, strName, strRemark, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
//删除组权限
if (!dao.DeleteGroupPermissions(nGroupId, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
//新增组权限
foreach (SysFunction f in listFunction)
{
SysGroupPermission p = new SysGroupPermission();
p.GroupId = nGroupId;
p.FuncId = f.Id;
p.FuncName = f.Name;
p.AllowOpen = f.AllowOpen;
p.AllowNew = f.AllowNew;
p.AllowModify = f.AllowModify;
p.AllowDelete = f.AllowDelete;
p.AllowCancel = f.AllowCancel;
p.AllowDetail = f.AllowDetail;
p.AllowSearch = f.AllowSearch;
p.AllowSubmit = f.AllowSubmit;
p.AllowApprove = f.AllowApprove;
p.AllowDispatch = f.AllowDispatch;
p.AllowExport = f.AllowExport;
p.AllowImport = f.AllowImport;
p.AllowPrint = f.AllowPrint;
if (!dao.InsertGroupPermission(p, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
}
}
transScope.Complete();
}
return(true);
}
catch (Exception e)
{
strErrText = e.Message;
return(false);
}
}
public SystemService(IMapper mapper, ConfigurationOptions options)
{
_menuDao = new MenuDAO(options);
_permissionDao = new PermissionDAO(options);
_permissionApiDao = new PermissionApiDAO(options);
_userDao = new UserDAO(options);
_roleDao = new RoleDAO(options);
_mapper = mapper;
}
public static PermissionDTO GetAll()
{
PermissionDTO dto = new PermissionDTO();
dto.Departments = DepartmentDAO.GetDepartments();
dto.Positions = PositionDAO.GetPositions();
dto.States = PermissionDAO.GetStates();
dto.Permissions = PermissionDAO.GetPermissions();
return(dto);
}
public int CreatePermission(Permission ent)
{
int createdid = 0;
PermissionDAO entDAO = new PermissionDAO();
sc = new SqlCommand("CreatePermission");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public bool DeletePermission(int id)
{
bool success = true;
PermissionDAO entDAO = new PermissionDAO();
sc = new SqlCommand("DeletePermission");
sc.Parameters.Add("@ID", id);
sc.CommandType = CommandType.StoredProcedure;
success = entDAO.deleteEntity(sc);
return(success);
}
public int AddPermissionToUser(int userid, int permissionid)
{
int createdid = 0;
PermissionDAO entDAO = new PermissionDAO();
sc = new SqlCommand("AddPermissionToUser");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@PermissionID", permissionid);
sc.Parameters.Add("@UserID", userid);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public bool DeletePermissionFromUser(int userid, int permissionid)
{
bool success = true;
PermissionDAO entDAO = new PermissionDAO();
sc = new SqlCommand("DeletePermissionFromUser");
sc.Parameters.Add("@PermissionID", permissionid);
sc.Parameters.Add("@UserID", userid);
sc.CommandType = CommandType.StoredProcedure;
success = entDAO.deleteEntity(sc);
return(success);
}
override public Object GetPermission(int gameId)
{
if (HttpContext.Current.Request.Cookies.AllKeys.Contains("_guid"))
{
using (PermissionDAO dao = new PermissionDAO())
{
return(dao.GetCookiePermissions(gameId, HttpContext.Current.Request.Cookies["_guid"].Value));
}
}
return(null);
}
public EditPermission(User user, controlPanel parent)
{
this.user = user;
this.parent = parent;
InitializeComponent();
applications = ApplicationDAO.getAllApplicationRecords();
permissions = PermissionDAO.getAllPermissions();
String [] permStrings = (from p in permissions select p.Permission_Name).ToArray <String>();
String[] active = { "Active", "Disabled" };
permission_combobox.ItemsSource = permStrings;
isActive_combobox.ItemsSource = active;
save_btn.IsEnabled = false;
}
private void save_btn_Click(object sender, RoutedEventArgs e)
{
Permission perm = permissions.ElementAt(permission_combobox.SelectedIndex);
perm.IsActive = isActive_combobox.SelectedIndex == 0 ? true : false;
perm.LastModifiedBy = user.User_ID;
perm.LastModifiedOn = DateTime.Now;
if (PermissionDAO.updatePermission(perm))
{
save_btn.IsEnabled = false;
}
else
{
}
}
public async Task <bool> Create(Permission Permission)
{
PermissionDAO PermissionDAO = new PermissionDAO();
PermissionDAO.Code = Permission.Code;
PermissionDAO.Name = Permission.Name;
PermissionDAO.RoleId = Permission.RoleId;
PermissionDAO.MenuId = Permission.MenuId;
PermissionDAO.StatusId = Permission.StatusId;
DataContext.Permission.Add(PermissionDAO);
await DataContext.SaveChangesAsync();
Permission.Id = PermissionDAO.Id;
await SaveReference(Permission);
return(true);
}
public ActionResult SearchPermission(string strKeyWord, int intPageIndex = 0)
{
try
{
//Lấy config số trang hiển thị trên thanh phân trang
int intVisiblePages = Convert.ToInt32(ConfigurationManager.AppSettings["visiblePages"]);
int intTotalPages = 0;
int intTotalRows = 0;
//Gen HTML
StringBuilder strHTMLPermission = new StringBuilder();
DataTable dtbPermission = new PermissionDAO().SearchPermission(strKeyWord, intPageIndex, intVisiblePages);
if (dtbPermission != null && dtbPermission.Rows.Count > 0)
{
strHTMLPermission = GenHTMLPermission(dtbPermission);
//Lấy tổng số lưởng dòng
intTotalRows = Convert.ToInt32(dtbPermission.Rows[0]["TotalRows"]);
//Lấy tổng số lượng trang
intTotalPages = intTotalRows / intVisiblePages;
//Trường hợp số phần tử không chia hết cho intVisiblePages
if (intTotalRows % intVisiblePages != 0)
{
intTotalPages = intTotalPages + 1;
}
}
else
{
strHTMLPermission.Append("<tr><td colspan='12' class='table-content-null'>Hiện không có nội dung</td></tr>");
}
return(Json(new
{
iserror = false,
content = Convert.ToString(strHTMLPermission),
totalpages = intTotalPages,
totalrows = intTotalRows
}));
}
catch
{
return(Json(new { iserror = true }));
}
}
override public void AddPermission(int gameId, int playerId, string identifier, string password, Permission.TYPE type)
{
string guid;
if (!HttpContext.Current.Request.Cookies.AllKeys.Contains("_guid"))
{
guid = GenerateGuid();
}
else
{
guid = HttpContext.Current.Request.Cookies["_guid"].Value;
}
using (var permissionsDAO = new PermissionDAO())
{
permissionsDAO.AddCookiePermission(gameId, guid, playerId, identifier, type, password);
}
}
public async Task <bool> BulkMerge(List <Permission> Permissions)
{
List <PermissionDAO> PermissionDAOs = new List <PermissionDAO>();
foreach (Permission Permission in Permissions)
{
PermissionDAO PermissionDAO = new PermissionDAO();
PermissionDAO.Code = Permission.Code;
PermissionDAO.Name = Permission.Name;
PermissionDAO.RoleId = Permission.RoleId;
PermissionDAO.MenuId = Permission.MenuId;
PermissionDAO.StatusId = Permission.StatusId;
PermissionDAOs.Add(PermissionDAO);
}
await DataContext.BulkMergeAsync(PermissionDAOs);
foreach (Permission Permission in Permissions)
{
PermissionDAO PermissionDAO = PermissionDAOs.Where(p => p.Code == Permission.Code).FirstOrDefault();
Permission.Id = PermissionDAO.Id;
Permission.PermissionActionMappings.ForEach(x => x.PermissionId = PermissionDAO.Id);
Permission.PermissionContents.ForEach(x => x.PermissionId = PermissionDAO.Id);
}
List <PermissionActionMapping> PermissionActionMappings = Permissions.SelectMany(x => x.PermissionActionMappings).ToList();
List <PermissionContent> PermissionContents = Permissions.SelectMany(x => x.PermissionContents).ToList();
List <PermissionActionMappingDAO> PermissionActionMappingDAOs = PermissionActionMappings.Select(x => new PermissionActionMappingDAO
{
ActionId = x.ActionId,
PermissionId = x.PermissionId,
}).ToList();
List <PermissionContentDAO> PermissionContentDAOs = PermissionContents.Select(x => new PermissionContentDAO
{
FieldId = x.FieldId,
PermissionOperatorId = x.PermissionOperatorId,
Value = x.Value,
PermissionId = x.PermissionId,
}).ToList();
await DataContext.BulkMergeAsync(PermissionActionMappingDAOs);
await DataContext.BulkMergeAsync(PermissionContentDAOs);
return(true);
}
public async Task <bool> Update(Permission Permission)
{
PermissionDAO PermissionDAO = DataContext.Permission.Where(x => x.Id == Permission.Id).FirstOrDefault();
if (PermissionDAO == null)
{
return(false);
}
PermissionDAO.Id = Permission.Id;
PermissionDAO.Code = Permission.Code;
PermissionDAO.Name = Permission.Name;
PermissionDAO.RoleId = Permission.RoleId;
PermissionDAO.MenuId = Permission.MenuId;
PermissionDAO.StatusId = Permission.StatusId;
await DataContext.SaveChangesAsync();
await SaveReference(Permission);
return(true);
}
private void btnSua_Click(object sender, EventArgs e)
{
if (btnSua.Text == "Sửa")
{
btnSua.Text = "Lưu";
btnSua.Image = Resources.download_32x32;
btnXoa.Text = "Hủy";
btnXoa.Image = Resources.cancel_32x32;
btnThem.Enabled = false;
Enable_Control();
return;
}
if (btnSua.Text == "Lưu")
{
if (Validate())
{
Permission item = new Permission();
item.ID = Convert.ToInt32(txbMaQuyen.Text);
item.Name = txbTenQuyen.Text;
bool result = new PermissionDAO().Update_Permission(item);
if (result)
{
MessageBox.Show("Sửa quyền thành công");
Disable_Control();
Load_dgr_Quyen();
}
else
{
MessageBox.Show("Sửa quyền xảy ra lỗi");
}
}
return;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (btnThem.Text == "Thêm")
{
btnThem.Text = "Lưu";
btnThem.Image = Resources.download_32x32;
btnXoa.Text = "Hủy";
btnXoa.Image = Resources.cancel_32x32;
btnSua.Enabled = false;
Clear_Control();
Enable_Control();
return;
}
if (btnThem.Text == "Lưu")
{
if (Validate())
{
Permission item = new Permission();
item.Name = txbTenQuyen.Text;
long result = new PermissionDAO().Insert_Permission(item);
if (result != 0)
{
MessageBox.Show("Thêm quyền thành công");
Disable_Control();
Load_dgr_Quyen();
}
else
{
MessageBox.Show("Thêm quyền xảy ra lỗi");
}
}
return;
}
}
/// <summary>
/// 修改帐号权限
/// </summary>
/// <param name="nAccountId"></param>
/// <param name="listGroup"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool UpdateAccountPermissions(long nAccountId, List <SysGroup> listGroup, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
//删除原帐号权限
if (!dao.DeleteAccountPermissions(nAccountId, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
//新增岗位权限
if (listGroup != null)
{
foreach (SysGroup g in listGroup)
{
AccountPermission p = new AccountPermission();
p.AccountId = nAccountId;
p.GroupId = g.Id;
if (!dao.InsertAccountPermission(p, nOpStaffId, strOpStaffName, out strErrText))
{
return(false);
}
}
}
}
transScope.Complete();
}
return(true);
}
catch (Exception e)
{
strErrText = e.Message;
return(false);
}
}
/// <summary>
/// 读取指定权限组记录
/// </summary>
/// <param name="nGroupId"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public SysGroup LoadPermissionGroup(long nGroupId, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
SysGroup dataResult = null;
strErrText = String.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
dataResult = dao.LoadPermissionGroup(nGroupId, nOpStaffId, strOpStaffName, out strErrText);
}
transScope.Complete();
}
return(dataResult);
}
catch (Exception e)
{
strErrText = e.Message;
return(null);
}
}
/// <summary>
/// 读取指定帐号的某个权限状态
/// </summary>
/// <param name="nFunctionId"></param>
/// <param name="strPermission"></param>
/// <param name="nOpStaffId"></param>
/// <param name="strOpStaffName"></param>
/// <param name="strErrText"></param>
/// <returns></returns>
public bool LoadAccountPermission(long nFunctionId, string strPermission, long nOpStaffId, string strOpStaffName, out string strErrText)
{
try
{
bool dataResult;
strErrText = String.Empty;
using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0)))
{
using (PermissionDAO dao = new PermissionDAO())
{
dataResult = dao.LoadAccountPermission(nFunctionId, strPermission, nOpStaffId, strOpStaffName, out strErrText);
}
transScope.Complete();
}
return(dataResult);
}
catch (Exception e)
{
strErrText = e.Message;
return(false);
}
}
private void addPermissionButton_Click(object sender, RoutedEventArgs e)
{
if (permissionName.Text.Length > 1)
{
String permName = permissionName.Text;
int idx = appComboBox.SelectedIndex;
Permission permission = new Permission(0, permName, apps.ElementAt(idx).App_ID, true, DateTime.Now, DateTime.Now, user.User_ID, user.User_ID);
if (PermissionDAO.savePermission(permission))
{
MessageBox.Show("The Permission is saved", "SUCCESS");
this.Close();
}
else
{
MessageBox.Show("Permission not saved", "FAILURE");
}
}
else
{
MessageBox.Show("Please enter a valid name for permission", "INVALID PERMISSION");
}
}
