/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="modifyUser"></param> /// <returns></returns> public bool LogicDeleteInfo(long id, string loginUser) { UserRoleInfo userRoleInfo = dal.GetInfo(id); if (userRoleInfo == null) { throw new Exception("MC:0x00000084");///数据错误 } string sql = "update [dbo].[TS_SYS_USER_ROLE] " + "set [VALID_FLAG] = 0,[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " + "where [ID] = " + id + ";" + "update [dbo].[TS_SYS_USER_ROLE_RANGE_AUTH] " + "set [VALID_FLAG] = 0,[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " + "where [USER_FID] = N'" + userRoleInfo.UserFid.GetValueOrDefault() + "' and [ROLE_FID] = N'" + userRoleInfo.RoleFid.GetValueOrDefault() + "';"; using (var trans = new TransactionScope()) { CommonDAL.ExecuteNonQueryBySql(sql); trans.Complete(); } return(true); }