/// <summary> /// ���½�ɫ,��ӵIJ��� /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int UpdateRole_DBC(RoleInfo oParam, string paramDelSql) { int _return = 0; string[] strPrivilege = paramDelSql.Split(','); //oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { _return = new RoleDac().Update_DBC(oParam); _return = new RoleDac().DelPrivilegeRole(paramDelSql, oParam.SysNo); for (int i = 0; i < strPrivilege.Length; i++) { if (Util.IsNumber(strPrivilege[i])) _return = new RoleDac().InsertPrivilegeRole(oParam.SysNo, Int16.Parse(strPrivilege[i])); } scope.Complete(); } return _return; }
/// <summary> /// ɾ����ɫ /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int DeleteRole(int SysNo) { int _return = 0; TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { _return = new RoleDac().DeleteRole(SysNo); scope.Complete(); } return _return; }
/// <summary> /// ���ӽ�ɫ����ɫID�����ظ�,�����˲��� /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int InsertRole_DBC(RoleInfo oParam,string paramDelSql) { //string sql = "select top 1 sysno from sys_role where roleid = " + Util.ToSqlString((oParam.RoleID)); //DataSet ds = SqlHelper.ExecuteDataSet(sql); //if (Util.HasMoreRow((ds))) // throw new BizException("the same Role ID exists"); //oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence"); //return new RoleDac().Insert(oParam); int _return = 0; string[] strPrivilege = paramDelSql.Split(','); oParam.SysNo = SequenceDac.GetInstance().Create("Sys_Sequence"); TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { _return = new RoleDac().Insert_DBC(oParam); _return = new RoleDac().DelPrivilegeRole(paramDelSql, oParam.SysNo); for (int i = 0; i < strPrivilege.Length; i++) { if (Util.IsNumber(strPrivilege[i])) _return = new RoleDac().InsertPrivilegeRole(oParam.SysNo, Int16.Parse(strPrivilege[i])); } scope.Complete(); } return _return; }