/// <summary> /// 新增组权限数据 /// </summary> /// <param name="data"></param> /// <param name="nOpStaffId"></param> /// <param name="strOpStaffName"></param> /// <param name="strErrText"></param> /// <returns></returns> public bool InsertGroupPermission(SysGroupPermission data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(GROUPID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.GroupId), MakeParam(FUNCID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.FuncId), MakeParam(ALLOWOPEN_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowOpen), MakeParam(ALLOWNEW_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowNew), MakeParam(ALLOWMODIFY_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowModify), MakeParam(ALLOWDELETE_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDelete), MakeParam(ALLOWCANCEL_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowCancel), MakeParam(ALLOWDETAIL_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDetail), MakeParam(ALLOWSEARCH_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowSearch), MakeParam(ALLOWSUBMIT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowSubmit), MakeParam(ALLOWAPPROVE_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowApprove), MakeParam(ALLOWDISPATCH_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowDispatch), MakeParam(ALLOWEXPORT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowExport), MakeParam(ALLOWIMPORT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowImport), MakeParam(ALLOWPRINT_PARAM, SqlDbType.Bit, 1, ParameterDirection.Input, (object)data.AllowPrint), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName) }; if (Execute("InsertGroupPermission", Params, out strErrText) >= 0) { return(true); } else { return(false); } }
/// <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); } }