/// <summary> /// 新增帐号权限数据 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool InsertAccountPermission(AccountPermission data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(ACCOUNTID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.AccountId), MakeParam(GROUPID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GroupId), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName) }; if (Execute("InsertAccountPermission", Params, out strErrText) >= 0) return true; else return false; }
/// <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; } }