public int Insert(RoleInfo oParam) { string sql = @"INSERT INTO Sys_Role ( SysNo, RoleID, RoleName, Status ) VALUES ( @SysNo, @RoleID, @RoleName, @Status )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4); SqlParameter paramRoleID = new SqlParameter("@RoleID", SqlDbType.NVarChar,20); SqlParameter paramRoleName = new SqlParameter("@RoleName", SqlDbType.NVarChar,50); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4); paramSysNo.Value = oParam.SysNo; paramRoleID.Value = oParam.RoleID; paramRoleName.Value = oParam.RoleName; paramStatus.Value = oParam.Status; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramRoleID); cmd.Parameters.Add(paramRoleName); cmd.Parameters.Add(paramStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public int Update_DBC(RoleInfo oParam) { string sql = @"UPDATE Sys_Role SET RoleID=@RoleID, RoleName=@RoleName, Status=@Status, OperationTypeID=@OperationTypeID WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramRoleID = new SqlParameter("@RoleID", SqlDbType.NVarChar, 20); SqlParameter paramRoleName = new SqlParameter("@RoleName", SqlDbType.NVarChar, 50); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramOperationTypeID = new SqlParameter("@OperationTypeID", SqlDbType.Int, 4); paramSysNo.Value = oParam.SysNo; paramRoleID.Value = oParam.RoleID; paramRoleName.Value = oParam.RoleName; paramStatus.Value = oParam.Status; if (oParam.OperationTypeID == -2) paramOperationTypeID.Value = System.DBNull.Value; else paramOperationTypeID.Value = oParam.OperationTypeID; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramRoleID); cmd.Parameters.Add(paramRoleName); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramOperationTypeID); return SqlHelper.ExecuteNonQuery(cmd); }
/// <summary> /// Map RoleInfo /// </summary> /// <param name="oParam"></param> /// <param name="tempdr"></param> private void map(RoleInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.RoleID = Util.TrimNull(tempdr["RoleID"]); oParam.RoleName = Util.TrimNull(tempdr["RoleName"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); }
public Hashtable GetRoleHtByDept(Hashtable paramHash) { DataSet ds = GetRoleDsByDept(paramHash); if (!Util.HasMoreRow(ds)) return null; Hashtable ht = new Hashtable(20); foreach (DataRow dr in ds.Tables[0].Rows) { RoleInfo item = new RoleInfo(); map(item, dr); ht.Add(item, null); } return ht; }
/// <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 UpdateRole(RoleInfo oParam) { string sql = "select * from sys_role where sysno <> " + oParam.SysNo + " and roleid = " + Util.ToSqlString(oParam.RoleID); DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( Util.HasMoreRow(ds)) throw new BizException("the same Role ID exists"); return new RoleDac().Update(oParam); }
/// <summary> /// ����SysNo��ȡ��ɫ /// </summary> /// <param name="paramRoleSysNo"></param> /// <returns></returns> public RoleInfo LoadRole(int paramRoleSysNo) { string sql = "select * from sys_role where sysno = " + paramRoleSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if ( !Util.HasMoreRow(ds) ) return null; RoleInfo oRoleInfo = new RoleInfo(); map(oRoleInfo, ds.Tables[0].Rows[0]); return oRoleInfo; }
/// <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; }
/// <summary> /// ���ӽ�ɫ����ɫID�����ظ� /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int InsertRole(RoleInfo oParam) { 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); }