/// <summary> /// 新增权限组 /// </summary> /// <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 long InsertPermissionGroup(string strName, string strRemark, List<SysFunction> listFunction, long nOpStaffId, string strOpStaffName, out string strErrText) { long nGroupId = 0; try { using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (PermissionDAO dao = new PermissionDAO()) { //新增权限组 nGroupId = dao.InsertPermissionGroup(strName, strRemark, nOpStaffId, strOpStaffName, out strErrText); if (nGroupId <= 0) return 0; //新增组权限 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 0; } } } transScope.Complete(); } return nGroupId; } catch (Exception e) { strErrText = e.Message; return 0; } }
/// <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; }